SUMMARY

• IT professional withover 14 years of extensive experience in System Analysis, Design, Development and Implementation of Business Applications using MS - SQL Server, Oracle PL/SQL, Db2 and Data warehousing using IBM Data Stage 11.5/9.1/8.5.
• Over 10 years of experience using IBM Data Stage (V 11.5 /9.1/8.5 ) designing and developing parallel jobs using Data Stage Designer, Data Stage Director and Data Stage Administrator.
• Good experience with Snowflake Cloud Data warehouse, AWS S3.
• Good experience with Snowflake utility SnowSQL.
• Having strong 6+ years of Finance domain, 5+ years of Retail domain and 3 years of Insurance domain experience.
• Extensive experience in writing Complex SQL Queries, Stored Procedures, Views, Functions, Triggers, Indexes and Exception Handling using MS-SQL Server (TSQL) 2016/2012/2008/2005 .
• Proficient in Microsoft Power BI Dashboards and Reports with custom Visualizations.
• Good experience in Extraction, Transformation and Loading (ETL) data from multiple database sources for medium to large Enterprise Data Warehousing using IBM Info Sphere Data Stage.
• Experience in working with Waterfall and Agile Software methodologies projects.
• Strong understanding of the principles of Data Warehousing concepts using Fact tables, Dimension tables and Star / Snowflake Schema modeling.
• Proficient in logical and physical database design and Normalizing Techniques.
• Developed parallel jobs using different stages like Aggregator, Join, Filter, Funnel, Copy, Sequential File, Lookup, Remove Duplicate, Dataset, Transformer, Change Capture and Sort etc.
• Strong in writing complex SQL Queries, functions, views in Oracle PL/SQL & SQL (9i/10g/11g) and used Database utility tools like SQL Navigator, SQL Plus, and SQL Developer.
• Performed Administrative tasks like connectivity, configuration of projects, configuring DSN entries, and user defined environmental variables.
• Developed Source-Target mapping documents for the Dimensions and Fact tables.
• Extensively used Parallel Extender to load data into Data Warehouse with different techniques like Pipeline and Partition in MPP environment.
• Strong experience in MS-SQL Server T-SQL Programming.
• Strong programming experience using PL/SQL Packages, Stored Procedures, Functions, Cursors, Constraints, Triggers, Indexes, Views, Materialized Views.
• Extensive knowledge of advanced query concepts like Group by, Having clause, Union, Union All, and Analytical functions Row Number, RANK, DENSE RANK, LAG, LEAD.
• Proficient in logical and physical database design and Normalizing Techniques.
• Experienced with onshore / offshore business models for development activities.
• Good experience in creating Autosys JIL s to schedule the ETL jobs.
• Good experience in UNIX Commands and UNIX Shell Scripting.
• Expertise in Unit Testing, System Integration Testing, implementation and maintenance.
• Expertise in designing the flow chart diagrams using MS-Visio.
• Good experience in versioning tools like Rational ClearCase, Microsoft Visual SourceSafe (VSS), and Team Foundation Server (TFS).

TECHNICAL SKILLS

ETL Tools: IBM Infosphere Data Stage 11.5/9.1/ 8.7 / 8.5 , SSIS

Cloud Technologies: Snowflake, SnowSQL

Database: Oracle 9i/10g/11g, MS-SQL Server 2016/2012/2008/2005 , DB2, Teradata, Netezza, MS-Access

Reporting Tools: Microsoft Power BI, SSRS, Crystal Reports, Interactive Report Designer (IRD)

Languages: T-SQL, Oracle SQL, PL/SQL, C#.NET, JavaScript

Web Technology: ASP.NET

Design Tools: MS-Visio

Tools: SQL Navigator, SQL Developer, TOAD, Putty, Autosys, Outlook, MS-Office (Excel /Word /PowerPoint)

Versioning Tools: IBM Clear Case, Microsoft Visual SourceSafe (VSS), Team Foundation Server (TFS)

Operating Systems: Windows Vista/ XP / NT/2000/2003, 7 / 8/10, UNIX

PROFESSIONAL EXPERIENCE

Confidential

Sr ETL Data Stage / Snowflake Developer

Responsibilities:

• Extensively interact with Business Analysts, Technical Architect and understand the Business requirements, preparing technical specifications.
• Analyzed the existing process and developed ETL jobs like Unload jobs lookup jobs, Transformation jobs and Load jobs to extract the source data and load it into the enterprise-wide Data Warehouse.
• Created mapping documents, technical design documents as per the business specifications to design and load the data from source to target tables/files.
• Developed complex parallel jobs and sequence jobs using various stages like Join, Transformer, Pivot, Lookup, Dataset, Remove Duplicate, Sort, Funnel, Copy, stored procedure stage, Sequential File, Aggregator, Exception Activity, Job Activity, Notification Activity, Execute Command Activity, Sequencer etc.
• Created tables, views, secure views, user defined functions in Snowflake Cloud Data Warehouse.
• Extracted and loaded CSV files, json files data from AWS S3 to Snowflake Cloud Data Warehouse.
• Migrated Oracle database tables data into Snowflake Cloud Data Warehouse.
• Worked on EDW modules by retrieving the data from the different source systems databases like DB2, Oracle, Netezza, MS SQL Server, Flat files and then loading it into target databases of Netezza/ MS-SQL Server Database using IBM Data Stage parallel jobs.
• Created parallel jobs to extract the data from flat files, MS-SQL Server, Netezza and DB2 databases.
• Created complex SQL Queries, Stored Procedures, Functions, Views in MS SQL Server to accomplish some of the business logic.
• Created test cases with SQL Queries to compare data between source and target systems to make sure data is matched as per requirement.
• Created Autosys JIL’s to schedule the jobs and support activities for the jobs that are in Production.
• Created and modified UNIX Shell scripts.
• Check in the code to TFS for version controlling and raise request in ServiceNow to migrate the code to QA.and Production environments.
• Reviewing the code that was developed by offshore team.
• Created unit test case documents and done unit testing, capturing test results and moved the code to QA and Production environments.

Environment: IBM Info Sphere Data Stage v11.5, Snowflake, AWS, MS-SQL Server 2016, Netezza, DB2, Autosys, Putty, UNIX, ServiceNow, TFS,SQL Developer, Windows 8, MS-Excel, MS-Word

Confidential

Sr ETL Data Stage Developer

Responsibilities:

• Analyzed the existing process and developed ETLDatastage parallel jobs.
• Created mapping documents as per the business specifications to design and load the data from source to target tables/files.
• Worked on Policy Cash, Policy Data Mart and Web Focus modules by retrieving the data from the different source systems like DB2, MS-SQL Server, flat files and loading it into target MS-SQL Server Database using IBM Data Stageparallel jobs.
• Created parallel jobs to extract the data from flat files, MS-SQL Server and DB2 databases.
• Created Dashboards and custom visualizations using Microsoft Power BI.
• Created DAX columns, Measures, Views, Roles in Power BI and Implemented user Level security.
• Created complex SQL Queries, Stored Procedures, Functions, Views in MS SQL Server to accomplish some of the business logic.
• Created Autosys JIL’s to schedule the jobs and support activities for the jobs that are in Production.
• Created and modified UNIX Shell scripts.
• Created unit test case documents and done unit testing, capturing test results and moved the code to QA and Production environments.

Environment: IBM Info Sphere Data Stage v11.5/9.1, MS-SQL Server 2016/2012, DB2, Microsoft Power BI, Autosys, Putty, SQL Developer, Windows 8, MS-Excel, MS-Word, UNIX, ServiceNow

Confidential

Sr ETL Data Stage Developer

Responsibilities:

• Understanding Business process, gathering requirements, identifying potential usability issues and ensuring that an appropriate level of application quality was maintained always.
• Used Agile Software Methodologies for the project to satisfy the customer through early and continuous delivery of valuable software.
• Defined and implemented ETL development standards and procedures.
• Developed Data Stage parallel jobs and sequences using Data Stage Designer.
• Prepared technical design document and participated in source to target mapping design document.
• Converted complex job designs to different job segments and executed through Job Sequencer for better performance and easy maintenance.
• Involved in Data Stage Admin tasks setting project wide defaults, Creating Environmental variables and monitor project disk space, configuring DSN entries.
• Prepared Unit test case document.
• Responsible for designing and maintaining ETL jobs that includes extracting the data from MS-SQL Server database and transforming the data as per Business requirements and then loading into Oracle database.
• Created Data Stage parallel jobs using different stages like Aggregator, Sort, Filter, Funnel, Join, Merge, Lookup, Remove Duplicate, Sequential File and Transformer.
• Resolved technical challenges loading large data volume efficiently.
• Scheduled various ETL Batch processes using scheduler tool Autosys.
• Developed advanced PL/SQL packages, procedures, functions, views, indexes and collections to implement business logic using SQL Developer on the target database of Oracle 11g.
• Involved in optimizing the database performance by analyzing database objects, generating statistics, creating indexes, and Global Temporary Tables (GTT) and creating table partitions.
• Created and modified the financial reports using Interactive Reporting Designer tool to display report to end users on the dashboard of web portal MyStateStreet.
• Involved in creating and modifying the UNIX Shell scripts.
• Extensively used putty to check jobs logs.
• Created and modified Data Flow Diagrams using MS Visio.
• Extensively worked on Unit Testing, Functional Testing, Integration Testing, User Acceptance Testing and Performance Testing of the application.

Environment: IBM Info Sphere Data Stage v9.1, Oracle 11g, SQL Server 2012, Interactive Report Designer (IRD), ESP, Autosys, Putty, UNIX, SQL Developer, Windows 8, Outlook, MS-Excel, Clear Case