Profile Summary:

• Forward-thinking ETL Integration developer having 10 years of experience in SDLC, System analysis, design, development, and support of relational Database and Data Warehousing Systems.
• ETL strategies for highly scalable data warehouse/marts using IBM InfoSphere DataStage 8.5/8.x/7.x Parallel Extender/Enterprise Edition and ETL performance tuning to improve overall throughput
• Significant experience in data quality, data profiling, and metadata management using IBM Information Analyzer 8.x/ProfileStage 7.5.x, QualityStage 8.x, and MetaStage 7.x
• Very well versed in conceptual, logical, physical, relational E-R , dimensional Star and Snowflake schemas data modeling using ERwin Data Modeler 7.x
• Expert in Slowly Changing Dimension SCD's and Change Data Capture CDC . Experienced in bug fixing and troubleshooting of DataStage ETL Jobs.
• Oracle 11g/10g/9i, IBM DB2 UDB 9.x/8.x, SQL Server 2005, SQL, PLSQL. SQL Performance Tuning using Explain plan, Optimizer Costs, Hints, and indexes.
• Experienced in developing Korn Shell Scripting for flat files mgt, data scrubbing and batch integration.
• Well versed in Informatica PowerCenter 7.1 toolset and SQL Server Integration Service 2005 using BIDS
• Extensively worked under JAD, Agile, Scrum, SDLC methodologies and related environments.
• Worked in various domains: Health Insurance, Healthcare, Banking/Credit card, Financial, Pharmaceutical, Retail and Telecommunications
• Excellent team player with good analytical, communication, interpersonal skills, coordination.

Technical Skills:

• ETL /Integration Tools: IBM InfoSphere DataStage 8.5/8.x/7.5.x Enterprise Edition, IBM Information Analyzer 8.x/ProfileStage 7.5.x, QualityStage 8.x/7.5.x, MetaStage 7.x.
• Also aware of: Informatica 7.1 PowerCenter, Workflow Manager, Repository Manager, Data Mapping, MS SQL Server Integration Service 2005, SQL Server DTS 2000.
• OLAP Tools: IBM Cognos Reports Framework Manager 8.4, MicroStrategy Desktop, Web, Intelligence Server 8, BusinessObjects 6.x Supervisor, Designer, Reports, Broadcast Agent, Set Analyzer , Web Intelligence 2.7/2.5 SDK.
• Databases: Oracle 10g/9i, TOAD 9.6, IBM-DB2/UDB 9.x/8.x, Sybase ACE IQ, MS-SQL Server 2005/2000
• Data Modeling: ERwin Data Modeler 7.3, Relational Dimensional data models.
• Languages: C, C , C .NET, Java, VB.NET, VB 6.0, SQL, PL/SQL, Korn Shell Scripting
• Web Technologies: Java Struts 1.1, JSP, HTML, ASP, IIS 5.x/4.x, JavaScript, VBScript.
• Operating Systems: IBM AIX 5.3, UNIX, Sun Solaris 8.x/7.x , RedHat Linux 2.5, Windows Server 2003/Windows XP
• Others: WinCVS, Autosys, Rational ClearCase, MS Visual Studio.NET 2005/2003, MS Visio 2007, Mercury/HP Quality Center 9.0

Professional Experience:

Confidential

Sr. ETL DataStage Integration Lead/Consultant

• The Medicaid Redesign Team projects focuses on the process and fulfillment state requirements. The goal is to gather membership demography, eligibility and other related data from various sources for state government time bound reporting and other related analytics.
• Performed Medicaid Redesign Team project detailed analysis on legacy and other application layers Member Demography, Eligibility, Claims, Customer Service, Referrals, Pre-Authorizations, Welcome Kit, IVR systems, Web usages, Market Prominence, and related
• Prepared HLD and other Tech docs to present to SME and stakeholders in a design review and walkthrough sessions.
• Extensively designed, and developed ETL Processes using DataStage 8.5 and IBM MDM Server stages. Designed ETL jobs/job sequences to manage data extraction/load strategies for various source systems. Developed ETL data load jobs to implement slowly changing dimension.
• Implemented DataStage 8.5 WSDL/XML process within DataStage jobs to invoke Web Services methods on internally hosted .NET/Java servers
• Created Master Job Sequences. Performed process integration, errors, restartability and email notifications. Implemented Process ETL Control logic to capture job success, failure, error and audit, information for reporting.
• Tuned/optimized DataStage parallel jobs partition/sorting methods, node config. files, environmental variables, shared containers code modularization .
• Created PL/SQL packages, stored procs, functions, and triggers, views for business transformations. SQL Performance Tuning - Explain Plans and Indexes, Hints and Partitions.
• ETL integration with Autosys jobs JIL scripts , and DataStage Director.
• Performed and helped on SIT, Functional, Integration and UAT, Testing with HP Quality Center.
• Environment: IBM DataStage QualityStage 8.5 Parallel Extender EE Citrix , IMB MDM Server 8.0.1, Oracle 11g/10g, Toad 9.6, HP-UX B.11.31, Windows 7, Citrix, Autosys Scheduler, and MS Visio 2007

Confidential

Sr. ETL / Integration Lead/Consultant

• SRO Sunset is the project is planned for discontinuing the Special Risk Operation a 40 year old legacy process to be replaced by FINEOS system and other new bread of application platforms. The projects goal is to build new infrastructure capture correct matrixes and dimensions for Claims, Payments, Policy, Client, Consumer, and others to drive several legacy downstream processes in place of SRO.
• Effective onsite and offshore CGI resources coordination consisting 20 resources , project process assignments, design walkthroughs, code development, follow up and other aspects.
• Extensively prepared HLD and tech docs and presented to Client SME and stakeholders in a design review and walkthrough sessions.
• Developed ETL data load jobs to implement slowly changing dimension SCD Type IV .
• Designed ETL jobs/job sequences to manage data extraction/load strategies for various source systems, Acclaim DB, Client, Policy, Consumer GADB and FINEOS system to centralized integration GCIF database serves as data source to drive legacy downstream processes.
• Created Master Job Sequences. Done process integration, errors, restart ability and email notifications. Implemented Process PCDB logic to capture job success, failure, error and audit, information for reporting.
• Extensively designed, and developed ETL Processes using DataStage 8.1 and IBM MDM Server Stages.
• Performed SRO Sunset project detailed analysis on legacy downstream applications IMAGE, SROHIST, CARS, OSCARS, FICA Policy, CEPP EFTs, CEPP Write backs, CheckFree, DHCC, TIAA CREF and others which were written 40 years back Mainframes .
• Tuned/optimized DataStage parallel jobs partition/sorting methods, node config. files, environmental variables, shared containers code modularization .
• Created SQL/PL/SQL packages, stored procs, functions, and triggers, views for business transformations. SQL Performance Tuning - Explain Plans, Indexes, Hints and Partitions. ETL integration with ESP jobs and DataStage Director.
• Performed and helped on SIT, Functional, and Integration, Testing with HP Quality Center for tracking/resolution.

Environment: IBM DataStage QualityStage 8.x/7.5.x Parallel Extender EE Citrix , Oracle 10g, SQL Developer, SQL Server 2010, BO.XI.Rel2, IMB MDM Server 8.0.1, IBM AIX 5.3, Windows 7, Citrix, ESP Scheduler, and MS Visio 2007

Confidential

Sr. ETL/Integration Lead/Consultant

• Barclaycard is a division of Barclays PLC, major global financial services provider engaged in retail and commercial banking, credit cards, investment banking, and investment management services. Barclaycard US creates customized co-branded credit card programs for travel, entertainment, retail and financial institutions - US Airways, Best Western, Carnival Cruise Lines, Princess Cruises, Travelocity, L.L.Bean, Barnes Noble and BJ's Wholesale Club. Globally, Barclaycard provides credit cards in the U.K., Germany, Spain, Italy and Portugal.
• Performed detailed analysis for UDAP Disputes, Collections Ops., Multiproduct Account Structure Changes, Multiple ACH Payments Draft 5/Return file and legacy Money Movement processes involving MasterCard and TSYS, Wachovia/Wells Fargo systems for Collections/Customer Care, Data retention/Compliance departments. Some legacy processes are written 12 years back.
• Effective onsite and offshore resources coordination consisting 10 resources , project process assignments, design walkthroughs, code development, follow up and other aspects.
• Extensively developed ETL processes for Disputes Cases, Collections Operations, Mercury Account Structure Changes, Multiple ACH Payments and Money Movement using DataStage 8.1 with various stages by implementing Barclay's custom data transfer processes.
• Extensively prepared HLD/LLD docs and presented to Client SME in code review and walkthrough sessions.
• Designed Master Job sequences to integrate, manage errors, restartability and email notifications. Implemented Process Run-Log logic to capture job success and failure status tracking for MIS reporting.
• Designed BCUS custom file transfer process configurations for credit card, customer payment transactions, and third party vendor CMC and TSYS
• Configured DataStage 8.1 Web Services connectivity using BPM/Java WSDL. Performed Web Services method invocation for BPM Disputes, Money Movement, and Credit Card Services within DataStage jobs using XML stages.
• Tuned, optimized parallel jobs - partition strategies, single/multiple node config. files, environmental variables, shared containers.
• Created PL/SQL packages, stored procs., functions, and triggers, views for business transformations.
• SQL Performance Tuning applied Explain Plans, Indexes, SQL Hints and Partitions. Korn shell scripts, Control-M jobs, and director for ETL integration.
• Closely worked with MicroStrategy BI reporting team for Disputes, Collection and Customer Payments, Money Movement, Oracle Data Retention processes reports generation.
• Feature Checklists FCLs . Release Plans, Change Mgt. Process implementation. Interacted with Release Quality and Config. Mgt. dept. for Batch/WEB/Data Feed - Weekly, Monthly QA/PROD release cycles

Environment: IBM DataStage QualityStage 8.1.x Parallel Extender EE, Oracle 10g, Toad 10.0, IBM AIX 5.3, Windows XP, Control-M Scheduler, WinCVS, MicroStrategy 8.1, and MS Visio 2007

Confidential

Sr. ETL/Integration Consultant

• Astellas Pharma is engaged in pharmaceutical sales and promotions. Astellas EDGE Continuous Loop Promotions / Continuous Loop Marketing is data warehouse project to build Customer Interaction Repository CIR for Pharma Analytics, HCP Market segmentation, prescribing habits, adoption rates, behavioral info, physician issues, segment, sample usage, etc. Siebel Pharma v7.8 is used for SFA, CRM, Territory Planning, Call Execution, Handheld, Sampling, Managed Care, Medical Education. Exploria SPS 2.5 software is implemented for HCP-Medical Reps for executing electronic Presentations, Slides Tablet PC integration.
• Created tech design specs. on ETL, conversion and migration process, Operations, production roll out steps for go live and presented to Client in review sessions.
• Designed and implemented data standardization rules and matching solution for HCP and Medical Reps address, IMS Ids, SSN and Contact numbers using QualityStage. Data standardized into most commonly used format/patterns, converting the variable length record to fixed length records, parsing the fields to single domain data fields, by trimming/removing spaces, nonprinting characters.
• Performed Siebel SFA and Exploria Clickstream systems analysis for Call Planning, HCP/Medical Reps detailing, and Tablet syncing to Exploria Servers.
• Task prioritization, planning, estimations, and QA phases 1.0 through 1.2 of CLP/CLM project.
• Involved in data analysis, profiling, functional dependency, table/ column relationships analysis using IBM Information Analyzer 8.1 for HCP, Medical Reps Segmentation and Exploria Clickstream and Siebel SFA data.
• Extensively designed, and developed ETL solution to handle initial/incremental data refresh in data warehouse, Batch Audit and Controls to process Control Totals, Batch Data Errors, and load History using DataStage 8.1 parallel extender.
• Developed ETL data load jobs to implement slowly Changing Dimension SCD Type II .
• Designed Master Job Sequences that handled errors, restartability, and email notifications.
• Tuned parallel jobs using sorting/partition strategies, tuning configuration parameters, shared containers to increase the throughput of the data load.
• Developed PL/SQL stored procedures, functions, packages, and triggers for business transformations and for real time integration between Siebel Call Planning and Data Source Importer process. Designed and developed cleansing procedures for batch process.
• SQL performance tuning using Explain Plan, optimizer hints and applied indexes when required.
• Process integration with IBM Tivoli job streams, DataStage Director, and UNIX Korn shell scripts. Performed real-time integration process of Reps-HCP call planning, presentation-slide execution from Siebel SFA 7.8 to sync the data into Exploria Clickstream database.
• Interfaced with BI reporting team for Cognos BI 8 Reporting and dashboards design to meet CLP Call Planning, HCP Segmentation trends and related business matrix.
• Performance and integration testing. Defect tracking, and code fixing with MS-SharePoint 2007.

Environment: IBM DataStage QualityStage 8.1.x Parallel Extender EE, Information Analyzer 8.1.x, Oracle 10g, Toad 9.6, IBM AIX 5.3, Windows XP, IBM Tivoli Job Scheduler, PVCS, Erwin Data Modeler 7.3, Cognos BI 8 Reporting toolset, MS Visio 2007, MS Office SharePoint 2007, Siebel Pharma v7.8, Exploria SPS 2.5 software

Confidential

Sr. ETL/Data Warehouse Consultant

• Strengthen learning by providing strategic solutions, tracked progress and regularly followed up the ETL development effort onsite and offshore.
• Created technical high level design documents with process flows, migration process documents on Royalty performance statement extract, distribution Y2D, Membership Hold/Release, deductions process.
• Profiling of functional dependency, table/column relationship and data quality, conformance issues and analysis reports with Information Analyzer/ProfileStage
• Performed project conversion/migration from DataStage 7.5 to DataStage 8.1., designed, enhanced, and tested Parallel jobs. Implemented Slowly Changing Dimension SCD of Type II data load in data warehouse
• Data extract from Source system to ODS layer and to Target systems with Oracle Enterprise stage. Efficiently made use of parameter sets, range lookups, and other processing/development/debug parallel stages.
• Tuned and optimized parallel jobs using partition strategies, shared containers setting of single/multiple node configuration files, resolving job locks, and setting up environmental variables, migrating jobs to QA/UAT/Prod environments with DataStage Administrator.
• Extensively designed job sequences to integrate flow, using various Activities, Triggers, sequencer, Email notification, and Wait-for-File activities.
• Developed PL/SQL stored procedures, functions, packages, and triggers for implementing PREP Statements business transformations. Developed cleansing procedures to revert back to previous state to handle aborted Statement batch process. SQL performance tuning with Explain Plan, Optimizer Hints, and indexes.
• Done PREP Statements batch jobs integration via IBM Tivoli job scheduler job streams, DS-Director and Korn shell scripts.
• Done Statements module unit, and integration testing. Bug fixes, defect fixing with Mercury/HP QC 9.0.
• Interfaced with Business Objects BI team for reporting process.

Environment: IBM DataStage QualityStage 8.1/7.5.2 Parallel Extender, Information Analyzer 8.1/ProfileStage 7.5.x, Oracle 10g/9i, Toad 9.6, Windows XP, IBM AIX 5.3, Mainframe COBOL, IBM Tivoli Job Scheduler, IBM WebSphere Web Application Server 5.x. PVCS, Mercury/HP Quality Center 9.0, Erwin Data Modeler 7.x, Business Objects XI Rel2, MS Visio 2003

Confidential

Sr. ETL/Data Warehouse Consultant

• Analyzed SC-EDW architecture, tech. specs, mapping matrix on Clinical observations, ordered, administered medications and other key performance indicators KPI's .
• Performed Source systems profiling for functional dependency, table/column relationships and reporting on source and target systems using ProfileStage for the project.
• Designed ETL parallel extender PX jobs with parallel stages and Oracle and DB2 Enterprise stages for grouping and summarizing on KPI's for Patient Billing, Revenues, Outpatient Visits, Patient Clinical information, Cost-based benchmarking, and Provider Reports.
• Used SAP R/3 ABAP EXT for R3 and IDOC EXT for R3 stages extract pack for SAP Patient Management System for Patient Claims, Billing, Pharmacy, and Provider data extracts to be loaded into SC-EDW.
• ETL Job Performance tuning sorting, partitioning methods, configuration parameters, shared containers. Used DataStage Administrator for node configuration files, releasing job locks, migrating jobs to QA/ /Prod environments and setting up environmental variables.
• Used QualityStage to standardize clinical data HCPs and patients address, SSN, telephone nos. and clinical observation data.
• Extensively developed PL/SQL packages, procedures, functions, and triggers for business transformations under HIPPA guidelines in Oracle, DB2/UDB and SQL Server.
• Implemented Patient's de-identification with Visual Studio .NET/CLR User defined functions/DB objects to deploy/integrate with SQL Server 2005 database Assemblies.
• Involved in unit, performance, and integration testing of DataStage jobs, and shell scripts.
• Created UNIX Korn Shell scripts, Autosys Job Scheduler, Scripts, DataStage Director to run, schedule, monitor, and test integration jobs during development process.
• Used MicroStrategy Desktop ProjectBuilder to import tables, build objects, reports. Used Freeform SQL to create Freeform reports on Patient Trials, Cardiology Study, IV-to-Oral meds, and Provider Drug Cost Reports.
• Used MicroStrategy Web to enable users to run-predefined sales and inventory reports for building customized reports. Configured MicroStrategy Intelligence Server to use project sources to start services, execute and test reports.

Environment: DataStage 7.5.2 EE, ProfileStage 7.5.1, QualityStage 7.5.1, MetaStage 7.x, Oracle 10g/9i, IBM DB2/UDB 8.x, Toad 8.x, SAP R/3, SQL Server 2005, Visual Studio .NET 2005, CLR, MicroStrategy 8 Desktop, Web Intelligence Server 8, Rational ClearCase, Autosys, Erwin Data Modeler 4.0, Windows XP, and UNIX

Confidential

Software Engineer

Confidential Solutions Limited is a subsidiary of Escorts Group worth 500 million which is one of the India's leading corporate conglomerates and also a pioneer in wireless and application services industry in India, working with all major mobile operators and leading enterprises. Cellnext's core competence revolves is working with wireless technologies like SMS, STK, DP, MMS, GPRS, IVR, and J2ME.

Environment: MS-Visual Studio/VB.NET, IIS 5.0, Java 1.3 Servlets, JSP, JNDI-LDAP/JNI, WML, iPlanet Web Calendar Server 2.0, IBM WebSphere App. Server 4.0, Oracle 8i, Toad, Windows NT, Sun Solaris 7, JavaScript, VBScript, VBA macros