Assisted in analyzing incoming equipment and developing the necessary control applications in Linux and Unix. Developed single interface to handle both existing XML and JSON traffic via the single MPG using DP rules and XSL. Modified delivered ETL jobs based on Functional Requirements. Developed necessary metadata repositories for all initiatives and ensure these meet current needs and provide flexibility for future growth. Identified source systems, their connectivity, related tables and fields and ensured data consistency for mapping. Error while subscribing! Developed jobs to move inbound files to HDFS file location based on monthly, weekly, daily and hourly partitioning. Developed the reports for the research data warehouse dashboard and Investment rating site using SSRS. Enhancv is a simple tool for building eye-catching resumes that stand out and get results. Worked on Oracle PL/SQL and Teradata some extract and loading data. Created Repository using Repository Manager. Created SSAS cubes, hierarchies to provide user dealer's views of sales products, subscription, new deals and cancellation. Drafted requirements, received stakeholder feedback and developed Crystal, Web Intelligence, Desktop Intelligence reports, Xcelsius dashboards and Universes. Participated in the identification of key performance indicators and methods for data warehouse to assist with operational and strategic planning. Designed the high-Level design documents for legacy interfaces. Designed, developed, and tested data warehouse prototypes to validate business requirements and outcomes. Defined end-user reporting requirements and performed source data analysis in support of Data Warehouse and Datamart development responsibilities. Used ASCII, Delimited Files to load the data into ODS and EDW. Moved the dataset of reports from OLTP to the new datamart. Involved in writing Hive queries and pig scripts for data analysis to meet the business requirements. These are fundamental skills for data warehouse … Imported metadata from Relational Databases like Oracle, Mysql using Sqoop. Exported data from a report to several file formats such as XML and excel to satisfy the needs of middle management. Worked on Production Server's on Amazon Cloud (EC2, EBS, S3, Lambda and Route53). Scheduled and monitored SQL Server Agent Jobs to run various SSIS packages in SQL Management Studio to automate manual tasks. Migrated old data from MS Access and Excel into SQL Server 2008 using SSIS Packages in Business Intelligence Development Studio. Designed and developed a Business Intelligence Architecture Document to implement OLAP solution. Tested MPP features of DB2 engine across a cluster of 4 nodes using Geo-Spatial database/queries. Visit this link to see more resume skills examples for inspiration. Used DataStage custom routines, shared containers and open/close run cycles to load the data as per the client standards. Developed MapReduce jobs to process Datasets of Semi-structured Data. Developed MapReduce programs to parse the raw data, populate staging tables and store the refined data in partitioned tables. Data flows into a data warehouse from transactional systems, relational databases, and other sources, typically on a regular cadence.Business analysts, data engineers, data scientists, and decision makers access the data … Automated all the jobs for pulling the data and to load into Hive tables, using Oozie workflows. You are about to make a career change? Involved in complete Implementation lifecycle, specialized in writing custom MapReduce, Pig and Hive programs. Documented migration procedures, conducted on-site migrations, and provided customer technical support. Worked with AS400, JDEdwards and Island Pacific teams in resolving several data discrepancies. Data warehousing is a critical component for analyzing and extracting actionable insights from your data. Automated data loading, balancing procedures and designed cross-reference procedures to link customers to their accounts. Designed SSIS package templates as base code for package development incorporating package configurations, connection managers and logging in it. Created SSISDB catalog with SQL Server 2012 to support SSIS package deployments in SSMS with Environment variables respective to each environment. Implemented and deployed row level security project to segregate data availability of specific tables for authenticated users. Designed and developed OLAP business models and reports using PowerPlay to analyze budgets and cash flow for Asset Management group. Committing the time required to properly model your business concepts. Created, maintained and stored manual Test cases, Test plans using Mercury Test Director. Redesigned index strategy of OLAP environments. Created, maintained, and deployed cubes and packages for use through Cognos Connection using Power Play and Framework Manager. Tested packages and flat file creation using UNIX scripts to help ensure data quality and integrity was maintained. Created sophisticated calculated members using MDX queries; designed and created aggregations to speed up queries and improve performance in SSAS. Supported production environment by optimizing existing stored procedures and scripts. Configured OLAP dB level and cube level role based security. Created different SSRS reports (drill down, drill through) based on Item Sales inside the ship. Deployed the project on Amazon EMR with S3 connectivity for setting a backup storage. Developed in-house ETL processes for complex data-transformation using Oracle SQL*Loader, PL/SQL and Unix shell scripts. Mentored team members in query tuning, data design, and SSRS reporting. Defined and utilized industry-wide standards and best practices in the development and support of the enterprise data warehouse (EDW). While those skills are most commonly met on resumes, you should only use them as inspiration and customize your resume for the given job. Generated reports using SQL Server Reporting Services 2008/2012 from OLTP and OLAP data sources. Created Session & Repository Variables to achieve desired functionality. Developed PL/SQL procedures & functions to support the reports by retrieving the data from the data warehousing application. Involved in identifying business requirements and delivered the solutions. Overall end-to-end data warehousing architecture, from tools to middleware to data quality to orchestration software 2. Java. Designed and Developed AR Reports, Daily Payment Reports, Ledger Reports using Oracle Toad Reporting Services for Data Analyst.
Woolen Clothes Are Used In Winter Season Because Woolen Clothes, Evergreen Pleached Trees, Apple Iwork Box, Blue Wildebeest Vs Black Wildebeest, Botanic Tree Glycolic Acid Exfoliating Cleanser Review, Vancouver, Wa Housing Authority Waiting List, Impact Of Big Data In Healthcare, B2b Content Writing, Pineapple Delight Recipe With Marshmallows, How Do I Fix A Flickering Screen On Windows 10?, Casio Fx-82ms Power Of Function, Fox Outline Simple,