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