*ETL Developer (San Ramon, CA) *
*1 year share resumes at [email protected] <[email protected]>* Seeking a Software Engineer II who will analyze, design, program, debug, test, implement and modify software enhancements and/or new applications used in local, networked, or Internet-related computer programs. Code may be used in end-user applications, such as materials management, financial management, HRIS or desktop applications products. Completes SDLC documentation, and procedures for all phases of software development lifecycle. May interact with users to define system requirements and/or necessary modifications. Supports launched applications in the production environment. Specific responsibilities will include: · Works as a member of a cross-functional development team to provide excellent production support and customer service in support of the RHI Business Specific Data Marts. · Work independently in developing and maintaining RHI business reporting and analytics applications. · Creates technical designs, develops, unit tests, and documents application enhancements and fixes using RH approved technologies. · Work independently to analyze and provide solution for simple to moderate sized system or data related issues. · Designs, implements and maintains report batches using Oracle Reporting tools and Hyperion toolsets. · Designs and Develops ETL processes to populate Enterprise Data Warehouse and data marts using Informatica, Pentaho, Oracle PL/SQL, & Unix shell scripts · Prepares code migration document and works with release team in migrating the code to QA & other environments · Troubleshoots and resolves database, application, software configuration and ETL related performance issues · Excellent knowledge of distributed systems and SOA (Service Oriented Architecture) · Prior experience deploying and/or maintaining a SOA application · Good knowledge of AWS and Big Data technologies (Hadoop, Pig, Hive etc) · Experience with Data models, ETL/ELT and other backend services · Good knowledge of BI tools *Sample Resume:* Ø 10+ years of Professional Experience in SQL Development, Data Warehousing, Reporting and Business Intelligence solutions using SQL Server 2005/ 2008/ 2012 and BIDS. Ø Highly Proficient in T-SQL programming and vast experience in creating stored procedures, triggers, views and user defined functions on SQL 2005/2008 and 2012 Servers to meet the requirement of the applications. Ø Skilled in creating SSIS packages providing specific functionality like Data Profiling and Data Cleansing for a clean ETL process and populating Data Warehouse and Data-Marts. Ø Experienced working profoundly with T-SQL, using functionality like dynamic SQL, Sub Query, Co-related Sub Query, CTE, openquery, case statements, ranking functions, DMF and DMV’s. Ø Implemented various SSIS Transformations such as Slowly Changing Dimension, Aggregate, Data Conversion, Derived Column, Lookup, Fuzzy Group, Multicast, etc. Ø Knowledge in Optimizing OLAP cubes by creating Partitions, Usage based Aggregations/ Optimizations and using proper storage modes like MOLAP, HOLAP and ROLAP using SSAS. Ø Develop, maintain and administer the architecture for data extraction, data scrubbing, data cleansing components using the Data Transformation Services (DTS/SSIS) of MS SQL Server 2005/2008 – Enterprise Manager and various utilities like BCP and SQL Loader. Ø Designed Reports using SQL Server Reporting Services (SSRS). Included graphical structures using charts, tables, matrices, parameters and conditional formatting. Developed high data volume SSRS reports for analytical purposes. Ø Utilized conditional formatting which provides a visually appealing and descriptive representation of information in the reports. Ø Proficient in using Report Manager for setting up roles, security on the reports and creating Standard and Data Driven Subscriptions in Delivery of Reports. Ø Knowledge of DBA activities like Partitioning and Index Tuning by taking into consideration Internal and External Fragmentation levels according to the Microsoft’s best practices. Ø Implementation knowledge of High availability methods for database recovery including log-shipping and replication. Highly experienced in query optimization to enhance the performance of applications. Ø Understanding of HADOOP concepts, MAP Reduce, Hive and PIG utility. Ø Proficient in creating rich dashboards using Tableau Desktop and user stories to create compelling dashboards to deliver actionable insights. Ø Complete understanding of working on Quality Centre for bug tracking. Detailed knowledge of working on Tortoise SVN, VSS and TFS for version control. PAC2000 and Remedy for Incident Request. *Technical Skills* ------------------------------ DATABASES: Microsoft SQL Server 2005, 2008/R2, 2012, MySQL DATABASE TOOLS: Management Studio, SQL Profiler, DTA, ER-Win, Visio, APEX-SQL, TOAD DATABASE LANGUAGES: T-SQL, PL/SQL BUISNESS INTELLIGENCE: BIDS, SSIS, SSAS, SSRS, SharePoint, Tableau DATABASE MODELING: ER-Diagrams, Dimensional Diagrams, Star & Snowflake Schemas, SQL Developer Data Modeler. *Work Experience* ------------------------------ *Consultant @ McKesson Corporation Aug 2011 – Present* *Lead/Sr. SQL ETL Developer* *Responsibilities:* Ø Entitled as Lead BI Engineer for the acquisition of US Oncology by McKesson. Responsibilities included data modeling, design and implementation of SQL system to handle US Oncology sales and McKesson sales and process SSRS reports as Invoices for the suppliers each month. Ø Team up with Business analysts and conducted JRD session for requirement gathering from Business Users. Ø Involved in JAD sessions for the business analysis, documenting Functional Requirement Document, test planning, and project coordination. Ø Developed system design, architecture design diagrams and application design specifications. Ø Involved in design the architecture and implementation of various McKesson applications by writing several Stored Procedures, Functions and CTE. Well versed with Triggers, Cursors, Sub Query and Joins. Ø Worked in SQL Server for the design and implementation for a new Data Warehouse for McKesson Applications. Utilized Warehouse as repository for Supplier Rebates and Sales, process SSRS reports as per the Business requirements for various applications. Ø Worked on the Optimization and restructuring of stored procedures for the application by evaluating indexing and partitioning large tables. Ø Worked on master-child stored procedure to make automated execution with less complexity. Ø Designed and optimized dynamic SQL batches to perform bulk operation (updating millions of records) in OLTP environment. Ø Responsible for implementation of standards for query optimization and performance tuning. Ø Involved in the complete ETL Process: From Planning to Maintenance. Used Erwin tool to create a data model for the SSIS application. Ø Designed, Created and Implemented complex ETL Strategies using SSIS Packages that extracted the data from different heterogeneous sources like Oracle, Flat Files, Excel Files and dumped it into a centralized Data mart for reporting. Ø Designed several SSIS Packages to pull data from upstream applications, perform data cleansing and massaging, apply validations on the data and push data to downstream applications and Data Warehouse for generating Rebates and Invoice reports. Involved in debugging the Packages by utilizing SSIS features like breakpoints, event-handlers, Data-Viewers and custom loggings. Ø Identified and maintained slowly changing dimensions, heterogeneous Sources and determined the hierarchies in dimensions. Ø Involved in the troubleshooting of SSIS Packages, managing their configurations to transfer them from production to other databases. Ø Created, optimized and deployed various cubes depending upon business needs for analyzing data for different business perspectives Ø Implemented complex relation between fact and dimension using many – many and Referenced Dimension. Ø Verified new developed cube by slicing and dicing through various dimensions attributes. Ø Reduced the response time for OLAP cubes by creating partitions, assigning proper storage modes like MOLAP, ROLAP and designing aggregations in SSAS. Ø Created various application specific Billing reports. These reports included Drill-Through, Linked and Sub-Reports. Scheduled delivery of Invoice reports to Business users through the use of subscriptions in several different formats like Excel, PDF and Text. Ø Designed and developed interactive dashboards, reports utilizing Tableau Visualizations like bar graphs, scatter plots, pie-charts, geographic visualization and other making use of actions, other local and global filters according to the end user requirement. Ø Built complex formulas, complex calculated fields, table calculations, filters, parameters in Tableau for various business calculations and analysis. Ø Deployed reports to the reporting server in SharePoint Integrated mode and on Server and assisted in troubleshooting deployment problems. Ø Implemented security to restrict the access to users and to allow them to use only certain reports. Ø Administered interface to organize reports and data sources, schedule report execution, delivery and track report history. Ø Implemented database restores for various teams to support testing of applications at various stages. Implemented log shipping and replication for moving data from one server to another. *Technologies:* Microsoft SQL Server 2008R2/12, SSIS, SSAS, SSRS, Erwin, T-SQL, Tableau Desktop, Tableau Server, TFS, Report Builder, Power Pivot, SharePoint *Wells Fargo, San Francisco, CA Jan 2010 – July2011* *ETL/BI Developer* *Responsibilities:* Ø Worked closely with the end users in writing the functional specifications based on the business needs. Ø Developed standards and procedures for transformation of data as it moves from source systems to the data warehouse. Ø Created data base objects like tables, views, triggers, complex stored procedures and indexes with optimization in point of view in support of the databases. Ø Monitored the incoming data because of nightly jobs and other regular processes to identify the impact on the server. Performed cleansing of the data and loaded in the production server. Ø Created views to facilitate easy user interface implementation, and triggers on them to assist consistent data entry into the database. Ø Performed T-SQL Tuning operations at various levels by embedding code into a Stored Procedure, making proper use of Indexes and Partitions as well as using SQL Profiler and Data Base Engine Tuning Advisor. Ø Created Change Request and Work Request for Production and Non Production Environment issues using PAC 2000. Ø Created several business specific Stored Procedures for generating various kinds of daily and monthly reports for different Business Requirements. These reports were utilized by Business Analyst to keep track of Referrals for the Customers. Ø Involved in troubleshooting, monitoring, optimization of SQL Server and non-production database code as well as T-SQL code. Ø Interacted with DBA’s about database issues and performed applications tuning by analyzing trace files and explain plans. Ø Involved in the conversion of Wachovia Users to Wells Fargo by maintaining their profiles and roles. Ø Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using SQL Server SSIS. Ø Involved in extracting source data from Oracle, Access, XML, Flat Files, Excel files on different systems. Ø Monitored all the packages that were scheduled. Involved in debugging the Packages by utilizing SSIS features like breakpoints, event-handlers, Data-Viewers and custom loggings. Ø Incorporated Error Redirection during ETL load in SSIS packages to identify dimensions and facts that were not properly populated. Ø Optimized procedures and functions utilized by ETL Packages to reduce ETL Process time. Ø Configured various SSIS packages to make packages dynamic by implementing proper package configuration features and finally securing the packages by using password and encryption methods. Ø Designed and created OLAP cubes by selecting proper User defined hierarchies, Dimensions and Aggregations. Ø Implemented Proactive Caching for refreshing the cubes, either by using scheduled MOLAP or Automatic MOLAP. Ø Installed, Configured and managed Report Server and scheduled report delivery using Data Driven Subscriptions in SSRS. Ø Identified and defined the Datasets for the report generation and wrote the queries for the drill down reports, identifying and adding the report parameters. Ø Involved in designing and development of Tableau visualization solutions and Created Business requirement documents and plans for creating dashboards. Ø Managed very large reports that return a large volume of records and optimized their performance using techniques like cascading parameters and filters. Ø Generated Tableau combination charts using Tableau visualization software. Ø Actively involved in securing the reports created depending upon the level of sensitivity of information that the report contained. Ø Optimized reports by optimizing the embedded queries, or optimized the stored procedures that generate them. *Technologies:* MS SQL Server 2008/2008R2, Microsoft SQL Business Studio, SSIS, SSAS, SSRS, Erwin, T-SQL, Excel, Oracle, Flat Files, Tableau *CCS Global Tech (Multiple in-house projects) Nov 2004 – Dec 2009* *SQL/ETL Developer* *Responsibilities:* Ø Actively involved as part of a team for gathering and analyzing the needs of End User Requirement and System Specification. Ø Documented the technical specifications and generated the reports for the implementation and testing of the application Ø Worked extensively with T-SQL creating objects like table, stored procedure, views, user definite functions, making use of case statements, sub query, dynamic query, CTE, temp tables, table variable, ranking function, DMV and DMF’s. Ø Worked on multiple teams that used elements of agile methodology for creating our applications. Ø Performed T-SQL Tuning operations at various levels by embedding code into a Stored Procedure, making proper use of Indexes and Partitions as well as using SQL Profiler and Data Base Engine Tuning Advisor. Ø Created source to target data mapping, attribute metadata reconciliation against Access and Local Service Request industry standards, prepared transaction and data flow as well as database topology diagrams in Erwin. Ø Created the design documents for the entire project including table structures and design logic of stored procedures and packages. Ø Designed the Data Marts using the Kimball Design Methodology and the Analysis Database which included the dimensions and fact tables based on the business requirement after scanning through the business process, granularity and measures to use. Ø Designed SSIS packages to export and import data from SQL Server to MS Access, Oracle10g,Infopath files, text files and Excel files. Ø Implemented Master/Child Packages so only the Master Package has to be scheduled which will in turn fire the other packages. Ø Implemented transactions at package level and task level to meet the business requirements. Ø Optimized the performance of slow executing SSIS packages by making changes as Control Flow and Data Flow like avoiding blocking transformations, increasing buffer size. Ø Deploying SSIS Packages on respective server and effectively using configuration files for using same packages on other environments. Ø Created test plans for regression and unit testing in the form of scripts to test ETL applications. Ø Designed and created Report templates, bar graphs and pie charts based on the financial data. Ø Developed SSRS Reports like drill through, drill down, linked, sub reports and parameterized reports for better business analysis. Ø Deployed reports to the Report server in Native Mode and implemented Report delivery using Subscription in SSRS. Ø Optimized a report response time by 98%; and helped to decommission a dedicated report server to further save the company’s precious resources. Ø Involved in the Troubleshoot the deployment of reports in the test and production environment using SSRS. *Environment:* Microsoft SQL Server 2008/05, SSIS, SSAS, SSRS, ER-Win, BIDS, Flat Files, Windows Server 2008, Oracle *Education* ------------------------------ *University of Rajasthan, Jaipur, India * *Bachelor of Science, Electronics & Communication Engineering * -- You received this message because you are subscribed to the Google Groups "Citrix and Sap problems" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/citrix-and-sap-problems. For more options, visit https://groups.google.com/d/optout.
