SUMMARY

• Extensively worked on ETL projects using Confidential Technologies for clients in financial services, retail, manufacturing and Oil & Gas domains.
• Experience in ETL Architecture and Software development life cycle.
• Having good knowledge on Data Warehousing and Business intelligent concepts with emphasis on Extraction, Transformation and loading data of a business process including requirement development, testing and implementation.
• Good Experience with ETL development using MSBI, Talend, and Reporting Solutions.
• Extensive database experience and highly skilled in SQL Server, Oracle, Teradata, MS Access, HAWQ.
• Worked extensively with TOAD and SQL developer for writing SQL, PL/SQL queries and stored procedures.
• Developed many Reports / Dashboards with different Analytics Views (Drill - Down, Pivot Table, Chart and Filters) using Spotfire, SSRS and provide End User Training.
• Expertise in Tuning the Data Warehouse environment including Oracle SQL query tuning, Database tuning.
• Extensively worked for monitoring scheduled, running, completed and failed sessions. Involved in debugging the failed mappings and developing error handling methods.
• Strong Experience to databases SQL Server, PL/SQL & ODBC interfaces to Oracle.
• Worked on Code Migration, Version Control, Scheduling Tools, Auditing, Shared Folders, Data Movement, and Naming in accordance with ETL Best Practices, Standards and Procedures.
• Experience in RDBMS concepts.
• Knowledge of VB, UNIX and Java scripting.
• Have good knowledge of Share point development.
• Also have knowledge of C# .Net, ASP .Net, MVC Framework.
• Experience in preparing the ETL Specifications and Technical Design documents
• Experience in on call production support, troubleshooting issues and debugging code.
• Experience in administrative work by creating users, user groups, folders, configure security, giving permissions in folders and to users in Repository manager.
• Ability to work with team to develop policies, standards, best practices, training.
• Experienced in leading teams and managing multiple projects simultaneously while working in the Global Delivery Model.
• Have excellent experience in working with top international clients and various stake holders and gained global exposure working at client locations.
• Excellent communication, interpersonal and problem solving skills with the ability to work in a team or independently.

TECHNICAL SKILLS

ETL Tools: SSIS, DTS, Talend

Reporting Tools: SSRS, Crystal Reports, Spotfire

Scheduling Tools: SQL server agent, Windows task scheduler, Talend administration center

Databases: SQL Server 2000,2005 and 2008, Oracle, Teradata, HAWQ, MS Access, Green plum

Programming Languages: C# .Net, ASP.Net, HTML, JavaScript, UNIX, VB Script

Other Tools: Visual Studio, SQL Developer, Toad, Putty

Operating Systems: Windows XP, 7, 2008 R2 server

Source Control Tools: Visual Source Safe, Team Foundation Server, SVN

Framework: Dot Net, MVC

Domain Knowledge: Financial services, Retail, Manufacturing and Oil & Gas

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

Sr. ETL Developer

Responsibilities:

• Requirement gathering and data analysis of source, target and dependent systems.
• Involved in Logical and Physical data modeling of the data warehouse.
• Managing ETL operations: Job-stream definition and management, parameters, scheduling, monitoring, communication and alerting.
• Perform root-cause analysis and suggest solutions related to issue fixing.
• Hands on SSIS packages, Talend jobs, stored procedures and performance tuning database queries.
• Prepared SQL queries to validate the data in both the source and the target systems.
• Hands on SSRS, Spotfire reporting tools.
• Involved in developing reports/dashboards from data marts and provided assistance to downstream reporting teams and business users.
• Experience in administrative work by creating users, user groups, folders, configure security, giving permissions in folders and to users in Talend Administration Center.
• Designed and developed VB scripts for automation, scheduling of windows tasks.
• Providing technical support to meet application service level agreements and business-users on ad-hoc technical queries.
• Deliver high quality code deliverables and supports peers in quality checks such that design requirements are met.
• Involved in administrative activities for FlowCal, OFM, PEEP, Primavera, Crystal ball, DTrio and other Oil & Gas domain applications.
• Upgraded FlowCal from version 7 to 8.
• Upgraded OFM from 2005 to 2010 and 2012.
• Migrated Primavera database from Oracle to SQL Server.
• Providing extensive technical support around Oil & Gas domain specific applications to users and team.
• Knowledge transition to the new resources.

Confidential, Redmond, WA

ETL Developer

Responsibilities:

• Interacted with the Business Analysts to understand the business & gather technical requirements.
• Interacted with Architect to understand the High level Design.
• Helped in creation of mapping specs for better code processing.
• Implementing and testing enhancements to the application.
• Involved in database development by creating PL/SQL functions, procedures, triggers and packages to increase the performance.
• Perform root-cause analysis and suggest solutions related to issue fixing.
• Developed SSRS reports for the statistics ad performance dashboards.
• Configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
• Worked on SQL Server stored procedures and tuning queries for reporting.
• Extensively used SQL Management Studio to check if data is properly loaded into target systems by writing SQL Queries.
• Also involved in testing the migration of a Dot Net application.

Confidential

ETL MSBI Developer

Responsibilities:

• Requirement gathering & data analysis of source, target and dependent systems.
• Implemented various transformations using SSIS packages and SQL Server stored procedures.
• Involved in database development by creating PL/SQL functions, procedures, triggers and packages to increase the performance.
• Involved in implementing various credit mitigation techniques such as Collateral, Offset, Guarantee and Hedge as per the Basel norms.
• Created Market Risk Netting reports using SSRS which facilitate the business to evaluate the profit and loss for the securities and other investments.
• Provided business user support to the dashboards for generating reports and analyze data.
• Worked in enhancements of FSA, stress testing and other annual reports.
• Developed a user interface which enables the client to upload files, load data into database by running packages and download various reports from the reporting server.
• Involved in production support - performance tuning, troubleshooting problems, root cause analysis of production issues.
• Knowledge transition to production support team and induction to new joiners.

Confidential

ETL Developer

Responsibilities:

• Involved in Maintenance and Production support of source, target and dependent systems.
• Implemented various transformations using SSIS, DTS packages and SQL Server stored procedures.
• Developed SSIS and DTS packages for loading the customer information that flow in from different data sources and JP1 Jobs to run the packages at a scheduled time.
• Implemented the assessment workflow through a web based application.
• Also involved in production support - root cause analysis of production issues, bug fixing, and enhancement of mappings.
• Preparation of impact analysis based on data analysis of source and target systems.
• Troubleshooting production issues by checking logs and schedules.
• Peer review of mappings, workflows, sessions etc. and preparation of review checklists for maintaining the production standards.
• Involved in the Performance Tuning of databases.
• Provide knowledge transition and support the team members and new joiners.

Confidential

Systems Analyst

Responsibilities:

• Ensure a smooth flow and completion of Nightly RDW Batch in time by coordinating with different teams.
• Develop reports using Crystal Reports by writing queries, stored procedures.
• Performance tuned the queries to ensure better performance.
• Validate the reports generated daily which enable the customer to take quick business decisions.
• Migrated the queries and stored procedures from Oracle to Teradata.