PROFILE SUMMARY:

• Posses 11 years of Data Engineering experience across Guidewire Billing Center Conversion project implementation, ETL tool ( IBM Infosphere DataStage 7.5/8.x/9.x) and Databases (DB2,Teradata, Oracle, SQL Server).
• Associated with top of the line international IT Industries, Product/Consulting companies across Application Development, Product Development, Support & Maintenance, Data warehouse Solutions as ETL Developer, executing projects & programs in challenging business environments demanding high standards of quality and precision.
• Defining data conversion Strategy, Source system identification, Scoping & de - scoping, Conversion approach, Conversion methodology for Guidewire Billing Center Conversion project implementation.
• Expertise in handling different project models i.e. Development Model as well as Support & Maintenance Model, completely equipped with the activities and challenges involved in both the models. Application Support, Production Support, Source Data Analysis, Failure Mode Effect Analysis, Root Cause Analysis, Top n Analysis, Preparing the Coding Standard documents as well as providing estimations by doing end-to-end Impact Analysis with large data warehouse and data lake implementations experience.
• Cost effective professional with domain knowledge of technical architecture design and have a good understanding of technology tools and components in Data warehousing space.
• Technical expertise in ETL using DataStage 7.5/8.x/9.x and beginner in reporting technologies predominantly with Cognos 10.

KEY TECHNICAL SKILLS:

Databases: Oracle9i/10g, DB2,Teradata,Microsoft Sql server2008, NoSQL

ETL and Reporting Tools: DataStage 9.x/8.x/7.5, SSIS, SSRS, Cognos 10

Languages: SQL, PL/SQL, UNIX Shell Scripting, Python

Operating Systems : UNIX,Linux (RHEL 6.x/7.x), Windows

Other Software Tools : Control-M(Scheduler), Quality Center( Automation Testing), Guidewire’s BillingCenter (Insurance tool), HP Service Desk(Implementation)

PROFESSIONAL EXPERIENCE:

Confidential, Kansas City, MO

Sr. DataStage Developer

Responsibilities:

• Involved in understanding of business processes to learn business requirements.
• Extracted data from different systems into Source.
• Mainly involved in ETL developing.
• Analyzed all the source Data and Design DataStage jobs in 11.3 & 11.5 and load SCD - type1 dimension tables.
• Design DataStage Fact load jobs and ensure the order of sequence is followed.
• Documented ETL test plans, test cases, test scripts, and validations based on design specifications for unit testing, system testing, functional testing, prepared test data for testing, error handling and analysis.
• Used Data Stage Director and its run-time engine for job monitoring, testing and debugging its components, and monitoring the resulting executable versions on ad hoc or scheduled basis
• Fix defects and deploy code into production on time.
• Develop ASG-ZENA scheduling tool jobs and automate the DataStage load jobs.
• Do DataStage code check in Visual Studio team foundation server and follow deployment t guidelines.
• Support DataStage jobs in production for any job failures.
• Follow Agile frame work and participate in Daily stand ups meetings and update user stories and tasks in timely fashion.

Environment: IBM Infosphere DataStage 11.3, 11.5, IBM AIX UNIX, Sybase, MS SQL server 2012, DB2, Microsoft Visual Studio 2015, ASG-ZENA scheduling tool.

Confidential

ETL Consultant

Environment: DataStage 9,1, Oracle 9i,UNIX

Responsibilities:

• Provide high level of technical support, perform root cause analysis for problems experienced within area of DataStage ETL Jobs.
• Develops design specifications for ETL jobs Design, Implement and support ETL programs
• Performs code reviews for existing ETL Code
• Create the Project Initiation Document which contains Deliverables, Boundaries and time of project.
• Analyze the data sources and determine the scope of data
• Identify Multiple coding, redundant values, duplicates, null values, missing values in the data source.

Confidential

Environment: Data Stage 8.7, Guidewire’s Billing Center, Vertica and Microsoft Sql server 2008

Responsibilities:

• Involved in converting billing functions from the mainframe-based Billing System (AR) to Guidewire’s Billing Center 7.x in single release.
• Involved in the requirement gathering with business Analyst on different data groups
• Involved in Data quality and performance Optimization of the ETL code.
• Involve in creation of Custom SQL and ETL-based operations to move data from the data conversion source staging tables to the Billing Center Confidential staging tables.
• Involved in the load process (API Scripts) to transfer the data from the Billing Center Confidential staging tables to the ODS (Billing center).
• Involved in the Implementation of standard transformation logic to achieve efficiency.
• Involved in unit testing/smoke testing to determine whether the most critical functionalities work before proceeding with in-depth testing and provide solution and defect free data.
• Worked on deletions, data purges, table truncations, database optimization.
• Involved in Knowledge Transition Session's to share ideas and experiences to new joiners and others.
• Coordinate with other teams for any questions raised during following phases: Design phase, Estimation phase, Unit test case preparation, build phase and deployment phase.

Confidential

Environment: Data stage 7.5, DB2, UNIX(AIX), Microstrategy, Putty, Aqua Data Studio

Responsibilities:

• Involved in understanding the Business process, Analyzing the Functional Design and Transformation Rules for the transitioned subject areas and get the clarifications from the Technical Architect and Domain Expert on Functional Requirements.
• Created Jobs for loading the data for landing, staging and foundation tables.
• Designed the ETL Specification (Low Level Design Documents) for Job and prepared the Unit Test Cases for unit testing using SQL queries to verify the data loaded and track the results in unit Test cases.
• Used CDC techniques to maintain the Dimensions tables.
• Extracted data from flat files, Mainframe files, Mainframe Tables and DB2 Tables using DataStage 7.5
• Performed the User Acceptance Testing with Data Quality Team
• Participated in Daily Status Meeting, Defect Status Meeting, Production Release Meeting and transition calls.

Contributions: Done the Enhancements and got appreciations from Client for hard-work.

Confidential

Environment: Data stage 7.5.1, DB2 8.1.4, DB2 Tools (Command Center, Control Center, QMF), Aqua Data Studio, Control - M (6.01), Shell Scripts

Responsibilities:

• Involved in understanding the Business process, Analyzing the Functional Design and Transformation Rules for the transitioned subject areas and get the clarifications from the Technical Architect and Domain Expert on Functional Requirements.
• Created Jobs for loading the data for landing, staging, dimension tables, using various stages.
• Created complex views using inline views, co related sub queries, sub queries, Merge Query etc.
• Designed the ETL Specification (Low Level Design Documents) for Job and prepare the Unit Test Cases for unit testing.
• Used CDC techniques to maintain the Dimensions.
• Extracted data from flat files, Mainframe files, Mainframe Tables and DB2 Tables using DataStage 7.5
• Involved in Performance tuning for better performance of the Jobs and the queries.
• Performed Unit testing of jobs using SQL queries to verify the data loaded and track the results in unit Test cases.
• Performed the User Acceptance Testing with Data Quality Team and Testing Team for DataStage.
• Have participated in Daily Status Meeting, Defect Status Meeting, Development, Production Release Meeting and transition calls.

Confidential

Environment: DataStage 7.5, Oracle 9i,UNIX

Responsibilities:

• Involved in understanding the Business process, Analyzing the Functional Design and Transformation Rules for the transitioned subject areas and get the clarifications from the Functional design team on Functional Requirements.
• Created SQL queries, sub queries, functions relevant to Sql like Lpad, Rpad, Substr, Instr, etc.
• Extracted data from flat files and Oracle using DataStage 7.5
• Created Jobs for loading the data for landing and staging tables.
• Performed Unit testing of jobs using SQL queries to verify the data loaded and track the results in unit Test cases.
• Participated in User Acceptance Testing for the interfaces developed in DataStage.