SUMMARY

• Over 10 years of IT experience in Development, Maintenance Projects.
• More than 9 years of HealthCare Industry Experience.
• Worked UnitedHealth Care, Cigna and Blue Cross Blue Shield healthcare companies.
• Implementing a Microsoft SQL Server 2008 R2 Database Microsoft Gold Certified.
• IBM DB2 UDB 700 V8.1 Family Fundamental Certified.
• Worked with FACETS application for HealthCare claims, Membership and Provider Data processing.
• Designed and configured the ICD9 to ICD10 Conversion for all Diagnosis and Procedure codes.
• Successfully implemented very large size projects such as HEDIS, VBB, Provider Data, Membership data in the warehouse.
• Handled claims processing, EOB, Remits, FEP data from multiple vendors.
• Very good experience with Trizetto Facets Products, Good knowledge on Database models created by Trizetto for Healthcare Industries.
• Worked as a consultant in providing Business Intelligence solutions in Data Warehousing for OLAP application, decision support systems, building Data Marts.
• Capable of Full life cycle initiative including doing analysis, design, cleanse, transform and Development of high performance ETL for very large - scale data sets.
• Managed Teams with resources being onsite and offshore.
• Worked collaboratively by translating requirements into designs and taking responsibility for the implementation of those designs.
• Managed difficult situations involving technical issues, demanding Clients, escalations and making the team work as a unit.
• To provide the technical help and assist the team with the issues.
• Performs design review and assist the team if any necessary changes are required.
• Transforms the business knowledge to other team members. Train the team if required on any tools.
• Discuss with the team on all issues and provides the optimized solution to the issues.
• Implemented tuning and Database queries for Oracle and Teradata.
• Experience in Designing and populating Dimensional model (Star & Snowflake Schema) for Data warehouse and data marts and Reporting Data Sources.
• Experience in designing, developing, performance tuning, debugging, troubleshooting, and Monitoring ETL jobs using DataStage Designer, Director, Manager and Administrator.
• Strong knowledge of Extraction Transformation and Loading (ETL) processes using UNIX Shell scripting, PL/SQL and SQL Loader.
• Expertise in design and development of Database applications in Client/Server applications. Extensive experience in using RUP(Rational Unified Process) and Waterfall Models in
• Software Development Life Cycle (SDLC).
• Extensive experience in database programming using SQL and PL/SQL that includes stored Procedures, functions and Packages.
• Actively involved in data collection, group discussions and analysis, analyzed the functional flow of the projects and lead the team in database designing and maintenance
• Excellent with PL/SQL, T-SQL, Stored Procedures, Database Triggers and SQL * Loader.
• Very good problem solving, analytical techniques and programming skills.
• Experience in RDBMS Concepts, Database Management Systems, Database Physical and Logical design, Data Mapping, Table normalization, Data Modeling,
• Experience in Application Development Analysis, Requirement Analysis, Scoping, Developing, Debugging, Testing and Documentation of various phases in a project life cycle of Client/Server Applications.
• A well-organized, goal-oriented, highly motivated and effective team leader/member with excellent analytical, troubleshooting, and problem solving Skill.
• Excellent Verbal & Written Communication skills and strong in Documentation.
• Flexible, enthusiastic and project oriented team player with solid communication and leadership skills to develop creative solution for challenging client needs.
• Ability to work independently and within the team.
• Team player with good communication and interpersonal skills.

TECHNICAL SKILLS

Data Warehousing: DataStage 8.5/8.1/8.0 (IBM Web Sphere Data Stage/Info sphere DataStage) / 7.5/7.1/6.1/6.0/5.2 (Designer, Director, Manager, Administrator), Parallel Extender, Quality Stage, Audit Stage, Profile Stage & Meta Stage.

Data Modeling: Star-Schema Modeling, Snowflake-Schema Modeling, FACT and dimension tables, Pivot Tables, Erwin 3.x/4.x, Designer2000

RDBMS: Oracle 11i,10g,9i/8i/7.x, MS SQL Server 2000, 2008, UDB DB2, Sybase, SQL, Teradata, Server 12.0/11.x, MS Access 7.0

Systems/Platforms: UNIX (IBM-AIX, Sun Solaris, HP-UX), Windows 98/NT/2000, and MS-DOS.

Programming: SQL, PL/SQL, Unix Shell Scripting (Korn shell), C, C++, COBOL, JCL, Java.

Other Tools: SQL * Loader, BTEQ, TOAD, SQL Developer, SQL *Plus, ZENA, ZEKE, CA-7, JHS, VSAM, REXX

RAD Tools: Magic 9.3/9.4, UniPaaS, Magic XPA.

PROFESSIONAL EXPERIENCE

Confidential

Sr. ETL /Datastage / Datawarehouse Lead Architect

Responsibilities:

• Understanding client requirements through close interaction with clients.
• Project Time Estimation / Delivery Planning
• Implemented Datastage jobs for the exchange of data between different data sources (CSV File, Access Database, SQL Database) and load to SQL Server 2008 or files with proper mapping.
• Design and develop project document templates based on Agile SDLC methodology.
• Create different mappings for back & reporting request &ad hoc reporting request.
• Analyze the risk factors / challenges to perform impact analysis.
• Create and maintained RISKS, ISSUES & DECISIONS (RID) documents to track progress of the projects.
• Used ZEKE Scheduler to schedule the job. Created request triggers and Time trigger to enable the jobs.
• Developed test plan and test cases for integration testing and UAT.
• Performed Data Analysis on delivered product, Conducted behavioral assessment with customers.
• Creating packages to move elements from one region to other in Endeavor.
• Developing T-SQL queries, triggers, functions, cursors and stored procedures.
• Responsible for logical and physical design of SQL Server databases.
• Designed and created data marts, databases, indexes, views, stored procedures and data integrity.
• Experience in SQL joins, Sub-Queries, tracing and performance tuning for better running of queries.
• Participate and adhere to quality processes such as design reviews, code reviews, and documentation.
• Involved in testing, implementation and user training.
• Preparation of deployment guide, batch file and review.
• Tracing the deliverables received against the drafted requirements.
• Keeping track of all delivery dates ensuring on time delivery.
• Prepared Test Cases
• Involvement in system testing and UAT.
• Adept knowledge and experience in mapping source to target data using IBM Data Stage 8.x
• Implemented multi-node declaration using configuration files (APT Config file) for performance enhancement.
• Experienced in developing parallel jobs using various Development/debug stages (Peek stage, Head & Tail Stage, Row generator stage, Column generator stage, Sample Stage) and processing stages (Aggregator, Change Capture, Change Apply, Filter, Sort & Merge, Funnel, Remove Duplicate Stage)
• Debug, test and fix the transformation logic applied in the parallel jobs
• Involved in creating UNIX shell scripts for database connectivity and executing queries in parallel job execution.
• Used the ETL Data Stage Director to schedule and running the jobs, testing and debugging its components & monitoring performance statistics.
• Experienced in using SQL *Loader and import utility in TOAD to populate tables in the data warehouse

Environment: IBM Info sphere DataStage 8.5, SQL Server 2008, Flat files, ZENA, UNIX, Command Editor for DB2, MS SQL Server database 2008, SSMS, XML files, COBOL, JCL, DB2, and VSAM, SYBASE, MS Access database, Facets.

Confidential, KS

Sr. ETL /Datastage / Datawarehouse Lead Architect

Responsibilities:

• Analysis and conducting high level and low level design phases, documenting the same.
• Involved in SQL Server Mirroring and Database optimization.
• Perform extensive Requirement Analysis including risk, cost benefit and build or buy analysis.
• Perform detail analysis to shortlist and prioritize projects based on ease of integration and contribution to synergies.
• Create Traceability Matrix for Test cases & Functional Requirements and perform User Acceptance Testing (UAT) to ensure standard and proper functionality implementation.
• Interact with business users, SME's, and managers to create, complete and correct business and functional requirements specification documentation.
• Trace requirements by Business intelligence (BI) tools, to high-level design, test cases and product requirements. Perform mapping of records layouts from disparate source systems to PeopleSoft General Ledger target tables.
• Design and develop Use Cases, Activity Diagrams, Sequence Diagrams, and OOD using MS Visio.
• Design and develop project document templates based on Agile SDLC methodology.
• Create different mappings for back & reporting request &ad hoc reporting request.
• Analyze the risk factors / challenges to perform impact analysis.
• Create and maintained RISKS, ISSUES & DECISIONS (RID) documents to track progress of the projects.
• Developed test plan and test cases for integration testing and UAT.
• Performed Data Analysis on delivered product, Conducted behavioral assessment with customers.
• Creating packages to move elements from one region to other in Endeavor.
• Developing T-SQL queries, triggers, functions, cursors and stored procedures.
• Responsible for logical and physical design of SQL Server databases.
• Alter the schema for the required objects.
• Used DDL and DML for writing triggers, stored procedures, and data manipulation.
• Created views to restrict access to data in a table for security.
• Status Updates to high level manager.
• Provide support on weekends and nights by participating with onsite in the release and solving emergency issues.
• Knowledge Acquisition of the Application
• Followed and Prepared all the Quality process documents throughout the Project
• Analyzed, designed, developed, implemented and maintained Parallel jobs using IBM info sphere Data stage.
• Involved in design of dimensional data model - Star schema and Snow Flake Schema
• Generating DB scripts from Data modeling tool and Creation of physical tables in DB.
• Worked SCDs to populate Type I and Type II slowly changing dimension tables from several operational source files
• Created some routines (Before-After, Transform function) used across the project.
• Experienced in PX file stages that include Complex Flat File stage, DataSet stage, LookUp File Stage, Sequential file stage.
• Implemented Shared container for multiple jobs and Local containers for same job as per requirements.
• Experienced in developing server and parallel jobs using various Development/debug stages (Peek stage, Head & Tail Stage, Row generator stage, Column generator stage, Sample Stage) and processing stages (Aggregator, Change Capture, Change Apply, Filter, Sort & Merge, Funnel, Remove Duplicate Stage)
• Debug, test and fix the transformation logic applied in the parallel jobs
• Involved in creating UNIX shell scripts for database connectivity and executing queries in parallel job execution.
• Used the ETL Data Stage Director to schedule and running the jobs, testing and debugging its components & monitoring performance statistics.
• Experienced in using SQL *Loader and import utility in TOAD to populate tables in the data warehouse.
• Successfully implemented pipeline and partitioning parallelism techniques and ensured load balancing of data.
• Deployed different partitioning methods like Hash by column, Round Robin, Entire, Modulus, and Range for bulk data loading and for performance boost.
• Repartitioned job flow by determining DataStage PX best available resource consumption.
• Deployment of programs using COBOL, DB2, VSAM in to production after they are fixed.
• Make necessary Step Changes to jobs using JCL
• Involved in optimization of programs that are built by the project team.

Environment: IBM Info sphere DataStage 8.5,SQL Server 2008, Flat files, Autosys, UNIX, TOAD, MS SQL Server database, XML files, COBOL, JCL, DB2, and VSAM,MS Access database.

Confidential

Sr. ETL /Datastage / Datawarehouse Lead Architect

Responsibilities:

• Used the IBM DataStage (Designer, Director, Manager), SQL Server 2008, DB2 UDB, Flat files, Sequential files, Autosys, TOAD 9.6 and UNIX to transform and load the data from our legacy systems to different types of data marts.
• Playing the role of Module lead and Application Developer my responsibilities include
• Analysis and conducting high level and low level design phases, documenting the same
• Imported table/file definitions into the Datastage repository
• Creating packages to move elements from one region to other in Endeavor
• Status Updates to high level manager.
• Provide support on weekends and nights by participating with onsite in the release and solving emergency issues.
• Acted as liaison between end users and vendor, expediting resolution of issues.
• Identified and resolved issues.
• Worked as a liaison among stakeholders in order to elicit, analyze, communicate and validate requirements for changes to business processes, policies and information systems using Rational Requisite Pro
• Gathered and defined business requirements.
• Assisted with the screen design, report design, and all user interface issues by providing detailed functional requirements.
• Working knowledge of Software Development Life Cycle (SDLC), having thorough understanding of various phases like Requirements, Analysis/Design, Development and Testing
• Developed Use Cases, Logical Views, Activity Diagrams using Rational Rose
• Created and authored Use Case Diagrams and Activity Diagrams using MS Visio.
• Coordinated the User Acceptance testing with the end users
• Used Rational RequisitePro for managing the requirements
• Documented Test Plans and Test Cases using Rational Test Manager
• Analyzed and mapped processes (current state/future state).
• Participated in the implementation and support of various modules and other core applications as assigned.
• Directed quality assurance efforts through the creation of test plans and test matrixes. Coordinated and assists with user acceptance testing.
• Wrote custom reports and reported status and issues to the Project Manager
• Assured that the project plan is adhered to and scope changes are formally reviewed and documented
• Knowledge Acquisition of the Application.
• Going through the clients’ requirements and coming up with database design and application architecture. Plan capacity specification requirements for new database servers.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in SQL Server 2000.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to administer SQL Server. Used SQL Server System Tables to retrieve metadata.
• Troubleshoot and minimize production down issues.
• Knowledge Transition of the application to the newly inducted Team members
• Allocating work to offshore.
• Performed ETL coding using Hash file, Sequential file, Transformer, Sort, Merge, Aggregator stages compiled, debugged and tested. Extensively used stages available to redesign Data Stage jobs for performing the required integration.
• Documented ETL test plans, test cases, test scripts, and validations based on design specifications for unit testing, system testing, functional testing, regression testing, prepared test data for testing, error handling and analysis.
• Designed and developed the ETL jobs using Parallel edition which distributed the incoming data concurrently across all the processors, to achieve the best performance.
• Handled Performance Tuning of Jobs to ensure faster Data Loads
• Designed parallel jobs using stages such as Join, Merge, Lookup, Remove Duplicates, Copy, Filter, Funnel, Dataset, Lookup, Pivot, and Sort, Surrogate key Generator, Change Data Capture (CDC), Modify, Row Generator and Aggregator.
• Created Master controlling sequencer jobs using DataStage Job Sequencer.
• Extensively worked with Shared Containers for Re-using the Business functionality.
• Extensively developed and deployed UNIX Shell scripts as wrappers that provide values to DataStage jobs during runtime.
• Created Job Parameters and Environment variables to run the same job for different sources and targets.
• Used Director to monitor jobs, run and validating its components.
• Involved in the Performance Tuning of the DataStage jobs using different partition methodologies and node configurations of the environment variable file, designing and editing configurations, increasing the reading as well as the writing speed while fetching or loading data to files or databases.
• Extensive worked with jobs export, jobs import and multi job compilation etc.
• Provided data models and dataflow (extract, transform and load analysis) of the data marts and feeder/target systems in the aggregation effort.
• Migrated projects from development to QA to Production environments
• Performed the Integration and System testing on the ETL processes.
• Taking the regular backups of the jobs using Data Stage Export/Import utility.
• Working with BI team to apply the business rules for OLAP, designing the Frame Work models.
• Assisted operation support team for transactional data loads in developing SQL & Unix scripts

Environment: IBM InfoSphere DataStage 8.5, IBM Websphere DataStage 8.0.1, IBM AIX 5.2, Oracle 10g, XML files, Autosys, DB2,Teradata, REXX MS SQL Server database, sequential flat files, TOAD.

Confidential

Senior ETL Developer

Responsibilities:

• Playing the role of Team Member my responsibilities include
• Analysis of the Application Design specifications provided by the clients and preparing the Design Documents.
• Deploying new functionality / enhancing the existing functionality by making changes to the programs, creating new programs when service request are raised.
• Gathered requirements by using interviews, observation, JAD, brainstorming sessions, and documents analysis
• Gained consensus for business requirements being fully met and attainable technical development expectations
• Designed use-cases and use-case models to further refine the requirements and understand the business processes. Worked extensively in Rational Requisite Pro to organize and catalog requirements, documents, and use-case documents
• Conducted need analysis and resource allocation to determine the most effective use of the Design, Architecture, and Review
• Reviewed development plans, quality assurance test plans, and user documentation to ensure correct interpretation of original specifications
• Facilitated JAD sessions for defining business requirements and follow-up for Project Plan updates, gained consensus for User Acceptance Testing requirements
• Developed process flow diagrams and created Script Files containing the test cases. These would later help the testing team to properly comprehend the scope and extent of testing required
• Full-filling the technical task.(Includes Batch Monitoring using CA-7 and Abend Resolution )
• Daily basis effective communication with customer for their clarifications.
• Preparation of elements for Functional, Integration and Production Regions.
• Client demand issue resolving.
• Delivering deliverables on time and Defect analysis and solving them.
• Responsible for overseeing the Quality procedures related to the project.
• Analyze and fix Production fallouts when the same comes under the scope of development activities
• Conducted Knowledge Dissemination sessions
• Successfully handled the slowly changing dimensions.
• Involved in the Dimensional modeling of the Data warehouse.
• Developed documents like Source to Target mapping for developing the ETL jobs.
• Worked with DataStage server stages like OCI, ODBC, Transformer, Hash file, Sequential file, Aggregator, Sort, Merge, and other stages.
• Imported the required Metadata from heterogeneous sources at the project level.
• Involved in designing various jobs using PX.
• Extensive worked with jobs export, jobs import and multi job compilation etc.
• Developed Parallel jobs using Parallel stages like: Merge, Join, Lookup, Transformer (Parallel), Teradata Enterprise Stage, Funnel, Dataset, Oracle Enterprise Stage.
• Performed debugging on these jobs using Peek stage by outputting the data to Job Log or a stage.
• Used Remove Duplicates stage to remove the duplicates in the data.
• Involved in the migration of DataStage jobs from Development to Production environment.
• Worked on implementation job performance tuning techniques.
• Designed and implemented several wrappers to execute the DataStage jobs, create job reports out of the DataStage job execution results from shell scripts.
• Designed and implemented wrappers to execute the DataStage jobs from remote servers.
• Worked on database connections, SQL joins, views, aggregate conditions, parsing of objects and hierarchies.
• Tuned SQL queries for better performance for processing business logic in the database.

Confidential

Software Engineer

Responsibilities:

• Supervised the activity of the Database for identifying the bottlenecks that are slowing down the performance of the data warehouse.
• Identified and implemented the methods to fine tune the queries, procedures and functions.
• Reviewed the executions of views and stored procedure and identified the bottle necks within the query.
• Monitored Database and Server Resources with various tools such as Performance Monitor, SQL Profiler, Stored Procedures and Database Tuning Advisor.
• Finding and Tuning Problem Queries.
• Implemented Peer to Peer Transactional Replication within the system.
• Creation of file groups for the existing Tempdb Database.
• Changing collation in the existing configurations.
• Designed Ideal disk configurations for the future Database server.
• Designed and Created Cube and report from scratch including research.
• Set up guidelines for the team for the future.
• Created reports using ProClarity and analyzed accordingly
• Worked with database performance tuning and query optimization, data integrity and statistics
• Provided documentation on current database environment and as well on the structure that needs to be modified in the future for better performance of the system.
• Advised on the question and concern they had for maintaining the database.

Environment: SQL Server 2000, T-SQL, Datastage, Query Analyzer, SQL Profiler, SQL - Database Tuning Advisor, SQL Performance Monitor, Windows OS