Surya Jagadam

ad3p6t@r.postjobfree.com

SUMMARY

Over 15 years of experience in Information technology, with 12+ years of expertise in DataStage and Data warehousing in various domains using IBM Infosphere DataStage 11.7/11.3/9.x/8.5/8.1/7.x, ProfileStage and QualityStage.

Extensively involved in the development of DataStage ETL process for extracting data from different data sources, data transformation and loading the data into data warehouse for data mart operations.

Extensively used Parallel Stages like Sort, Merge, Aggregator, Remove Duplicates, Join, slowly changing dimensions, Funnel, Row Generator, Column Generator, Modify, Head and Peek for development and debugging purposes.

Experience in creating Infopackages for SAP-BW and writing data into SAP-BW using PACK for SAP R/3-BAPI, ABAP extract PACK for SAP R/3, IDOC Load PACK for SAP R/3 and IDOC Extract PACK for SAP R/3.

Strong Skills in Coding (Stage Variables, Derivations and Constraints) Business Logics in Transformation Stage.

Working experience in Development as well as support projects.

Working experience in onsite/offshore co-ordination to deliver projects.

Experience working with Agile and waterfall development methodologies.

Expertise in performance tuning DataStage code.

Well versed with understanding/grasping complex table hierarchies and business models.

In depth knowledge of Dimensional Data Modeling, Star Schema, Snowflake.

Working experience in Implementing ETL/DataStage best practices.

Very strong in Oracle, SQL Server and Teradata.

Expertise in migrating/Upgrading projects.

Worked on supporting, debugging and enhancing production systems.

Excellent communication and interpersonal skills.

Quick Learner, highly motivated team player with excellent organizational and analytical skills.

TECHNICAL SKILLS

Languages: PL/SQL, SQL, COBOL, Java, HTML, XML

Databases: Mongo DB, Oracle 19c, DB2, TERADATA, SQL Server 2012, Aurora Postgres

Scripting Languages: SQL Scripts, UNIX shell scripting, JCL

GUI Tools: Developer/2000, Visual Basic 5.0, TOAD, DB Admin, RBMS, TestMan.

ETL Tools: IBM Cloud Pak for Data, IBM Infosphere DataStage 11.7/11.3/9.x/8.5/8.1, DataStage 7.x, Quality Stage v7.5, DataStage PX (Parallel Extender), DataStage Version Control, Informatica PowerCenter 10.1.1, SSIS

Scheduling Tools: Autosys, Control-M

Tracking Tools: JIRA, Bug zero

Change Management Tools: HP Service Manager, Cherwell

Data Modeling Tools: Erwin, Visio

CRM: SAP-BW 3.1, ABAP, BAPI and IDOC

BI Tools: Business Objects V6.1, SAS

Operating Systems: HP-UX, UNIX (SunOS 5.9, Solaris 2.9/2.8/2.6), AIX, MVS, Windows

EDUCATION

Masters of Technology in Computer Science & Engineering

PROFESSIONAL EXPERIENCE

Erie, PA

Sr. DataStage Consultant April’22 - Present

This project involves the launch of Erie Family life’s fully underwritten term and whole life products on a new EFL platform.

Front-end user interface built upon the Life Web application development for ERIE Express Life.

Integration into existing systems such as Policy administration (PAS) including policy servicing, commission processing, billing, Claims Processing and payment.

Data & reporting for fully underwritten term product.

Responsibilities:

Collaborated with stake holders for creating layout design and document the requirements for various reporting modules.

Data analysis for the new reports and data to downstream to load data to prep area.

Worked with report developers in creating of final reports using Qlik.

Lead a team of offshore analysist.

Created ETL requirement document, ETL workflow diagrams for different business areas.

Designed ETL jobs to convert the source JSON to target XML files for different business areas.

Lead a team of offshore ETL developers.

Document requirement for various interfaces as part of file transfers.

Environment: IBM Infosphere DataStage v11.5, IBM Cloud Pak for Data, Oracle 19c, Amazon WorkSpaces, PostgreSQL, Unix Shell scripting, ALM Octane, SQL Server

Employers, Kansas City, MO Apr’19 – March’22

Sr. DataStage Consultant

EMPLOYERS, America's small business insurance specialist and Employers Insurance Company of Nevada are registered trademarks of EIG Services, Inc. Insurance is offered through Employers Compensation Insurance Company, Employers Insurance Company of Nevada.

Responsibilities:

Migrated the data from source systems such as Oracle, MongoDB, SQL Server to AWS Environment.

Developed jobs using various stages like Oracle connector, copy, pivot, funnel, lookup, join, merge, sort, transformer, dataset, row generator, column generator, datasets, and aggregator stages.

Used Change Data Capture (CDC) stages for doing incremental loads.

Working in all phases of the development lifecycle, coherent with Data Cleansing, Data Conversion, Performance Tuning and System Testing.

Studied the SQL code developed to relate the source and target mappings.

Transformed and loaded the data based on business rules in AWS Environment.

Implemented SDLC, QA methodologies and concepts in the Project.

Compliance to HIPAA policies and training on quarterly basis.

Involved in writing Test Plans, Test Cases and Test Scripts.

Simultaneously worked on multiple projects.

Communicated Project Requirements, Business Issues, Solution and made recommendation.

Worked with Project team to determine technical and development impact of a project.

Responsible for defining the scope of the project, gathering business requirements, doing gap analysis and documenting them textually or within models

Gathering and documenting the requirements that are critical to the business mission and using those requirements to design application software.

Worked with Source system Subject Matter Expert (SME) to ensure that the extracts are properly mapped. Used SQL for data mapping and querying.

Environment: IBM InfoSphere DataStage v11.7, Oracle 12c, MongoDB, PostgreSQL, Unix Shell scripting, JIRA, Confluence, ActiveBatch, SQL Server

Sun Life Financial, Kansas City, MO Jul’15 – Apr’19

Role: Senior Application Development Analyst

Sun Life Financial Inc. is an international financial services organization providing a diverse range of protection and wealth accumulation products and services to individuals and corporate customers. It is also known as one of the largest and oldest life insurance companies in the world. Sun Life Financial specializes in quality employee benefits and services, including long-term and short-term disability, life and accidental death, dental coverage

Responsibilities:

Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.

Worked on migrating Datastage jobs from Infosphere Information Server v8.5 to IBM Infosphere Information Server v11.3.

Used DataStage Parallel stages like Sequential, Lookup, Join, Merge, Change Capture, Funnel, Transformer, Filter, remove duplicates, Column Export and Row Generator in accomplishing the ETL Coding.

Involved in writing complex SQL queries, validation scripts, and stored procedure for ETL requirements.

Used DataStage Director to run, monitor, validate and check for any errors in jobs after job run was successful

Involved in code review and provide solution for improving the performance tuning of ETL DataStage jobs and query optimization to ensure faster Data Loads.

Raise necessary requests (HPSM, JIRA, BZ) to promote code move across different environments.

Worked with concerned team to make sure production implementation is completed as planned and monitor production environment for changes.

Analyzing the requirement and providing estimation based on the complexity.

Created source to target mapping and job design documents from staging area to Data Warehouse

Reviewed and updated technical specification documents for ETL process.

Extensively used Autosys for jobs scheduling

Developed unit test plans and involved in system testing. Worked on the code fixes and on the tickets raised due to the job failures.

Worked with the DQA for requirements gathering, analysis and testing.

Support unit, integration, and end to end testing by resolving identified defects.

Adhere to design reviews, code reviews, deployment documents and appropriate industry standard development methodologies.

Used the Datastage Designer to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.

Extensively used almost all database stages, file stages, processing stages, and development/debug stages

Have major contribution to successful rollouts of multiple projects

Environment: IBM InfoSphere DataStage v11.3, Oracle 12c, Unix Shell scripting, SQL Scripts, HP Service Manager, JIRA, Bug Zero, Autosys, SQL Server, Informatica, SSIS, SSRS

Catamaran, Schaumburg, IL Oct’13 – Jun’15

Sr. DataStage Consultant

Specialty Manufacturing Rebates

CatamaranRx is one of the top 5 Pharmacy Benefit Manager (PBM) in the U.S. It provides flexible solutions related to drug prescriptions. It helps to reduce pharmacy cost. Some features of CatamaranRx are flexible plan design, customized website, pharmacy network, mail services. For all of our reports we’re only reporting Catamaran pharmacy data. The reports are being produced from the enterprise pharmacy warehouse. It will be through an automated process through our DataStage tool. All of the reports listed are for external delivery.

Environment: Oracle client, Oracle SQL developer, iSeries Navigator, Aginity Netezza Workbench,7-Zip, WS_FTP, FileZilla, IBM InfoSphere DataStage and QualityStage version 8.5, ShowCase Suite 8.0, RazorSQL, Service now, Pulse Ticket

Department of Veterans Affairs, Hines, IL Feb’07 – Sep’13

DataStage Developer

VETSNET

VETSNET Compensation and Pension conversion project will extract transform and load data from the Benefits Delivery Network to the Corporate Database. The PROFILE module is fundamental to all the other migration modules and will be used to populate the tables that store vital information about a veteran, a veteran’s beneficiaries, the fiduciary and power-of-attorney

CH31

The Profile tables are the Oracle tables in the Corporate Database that involves the participant, person and their various relationships and addresses. The data used to create and/or locate the Participant associated to the veteran will come exclusively from the Chapter 31 Master Record. The rules detailed in this document involve the Profile Tables needed to Archive (i.e. convert) Chapter Master Record data.

VITAL

The Profile tables are the Oracle tables in the Corporate Database that involves the participant, person and their various relationships and addresses. The data used to create and/or locate the Participant associated to the veteran will come exclusively from the VITAL Master Record. This involves creating Audit tables that will be associated in most instances to the Veteran’s Profile

Environment: IBM Websphere DataStage 7.5/Infosphere 8.1/8.5, SunOS, Oracle 11g, Tuxedo, Rational ClearQuest, Serena Dimensions, PL/SQL, Unix shell scripting, SQL Scripts, Attachmate Reflection X

Contact this candidate