OBJECTIVE

• To obtain a challenging position that will utilize my educational background and professional experience to contribute to the organization's growth and achieve strategic goals and provide excellent opportunities for career development and personal growth.

SUMMARY

• Over 15+ years of experience in Information Technology with a strong back ground in Analyzing, Designing, Developing, Testing, and Implementing of Data Warehouse development, Mainframe development in Health Care, P&C Insurance.
• Over 8+years of Data Warehousing experience using Informatica Power center 9.x/8.x
• Certified PowerCenter Data Integration 9.x:Developer Specialist.
• Expertise in Database development skills using Oracle 11g/10g/9i, SQL, PL/SQL stored procedures, Functions, Packages and Triggers.
• Experienced in complete life cycle Implementation of data warehouse.
• Strong Knowledge in Relational Database Concepts, Entity Relation Diagrams, Normalization and De normalization Concepts.
• Expertise in building Enterprise Data Warehouses (EDW), Operational Data Store (ODS), Data Marts, and Dimensional modeling techniques, Star and Snowflake schema addressing Slowly Changing Dimensions (SCDs).
• Extensively worked on various Data warehouse projects using Informatica Client Tools - Source Analyzer, Transformation Developer, Workflow Manager, Workflow Monitor, Server Manager, Mapping Designer, Mapplet Designer and Warehouse Designer.
• Expertise in designing and Developing complex Mappings using Informatica Power Center Transformations - Lookup, Filter, Expression, Router, Joiner, Update Strategy, Aggregator, Stored Procedure, Sorter, Sequence Generator and Slowly Changing Dimensions.
• Experience in using Informatica Workflow Manager to create Sessions, Batches and schedule workflows and Worklets, Developing complex Mapplets, Worklets, Re-usable Tasks, Re-usable Mappings, Define Workflows & Tasks, Monitoring Sessions, Export & Import Mappings & Workflows.
• Expertise in doing Unit Testing, Integration Testing, System Testing and Data Validation for Informatica Mappings.
• Data loading using UNIX Shell scripts and SQL*Loader.
• Experience in dealing with various databases like Oracle 12c/11g/10g/9i, SQL Server 2012/2008 R2, Teradata, DB2, VSAM files, Flat files and XML files.
• Experience in developing SQL and PL/SQL block codes through various Stored Procedures, Functions, and Triggers to implement the business logics of database in Oracle, DB2 and SQL Server 2005/2008.
• Well Experienced in Error Handling and Troubleshooting using various log files.
• Good exposure to development, testing, debugging, implementation and documentation.

TECHNICAL SKILLS

Data Warehousing: Informatica Power Center 9.x/8.x, Informatica Power Exchange 9.x/8.x, Repository Manager, Designer, Workflow Manager, and Workflow Monitor.

Data Modeling: Ralph-Kimball Methodology, Bill-Inmon Methodology, Star schema, Snowflake schema, Dimensional data modeling

Databases/Files: Oracle 11g/10g/9i/8i, SQL Server 2012/2008R2, DB2, VSAM, XML, Flat files

Database Tools/Utilities: TOAD 11.x/9.x/8.x,Oracle SQL Developer, SQL * Plus, QMF, SPUFI

Operating Systems: Windows NT/000/XP, UNIX/ Linux, OS/390

Reporting Tools: SAP Business Objects, Cognos8.x/6.x

Modeling Tools: Erwin 4.1/4.0, ER-Studio

Scheduling Tools: CA7, Control-M

Configuration Tools: ENDEVOR, PANVALET, Putty

Programming Languages: SQL, PL/SQL, COBOL, JCL, HTML, R programming, XML, SAS

Scripting: UNIX Shell Scripting, Java-Scripting

Testing Tools: HP ALM

Legacy Systems: IBM Mainframes

PROFESSIONAL EXPERIENCE

Confidential, MD

Senior Principal Consultant

Responsibilities:

• Responsible for working with Data and Governance team to understand the business requirements and validating the business logic.
• Responsible for analyzing the employer group size data files received from enrollment system.
• Responsible for analyzing the facets 4.7, NASCO and CBI claim data from different data marts.
• Responsible for designing solution for Facets and NASCO feed from adjudication engines to Enterprise Data Warehouse (EDW).
• Created UNIX shell Scripts to process jobs (run scripts, generate parameters), FTP transfer of Data Files and/or trigger completion of ETL Workflow process.
• Extensively used transformations such as Source Qualifier, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Joiner, Transaction Control and Stored Procedure.
• Designed the mappings between sources (external files and databases) to operational staging targets.
• Developed Informatica mappings and Mapplets and also tuned them for Optimum performance
• Implemented Slowly Changing Dimension methodology for Historical data.
• Created SDS(Solution Design Specification documents) after analyzing MLR PRD document.

Environment: Informatica PowerCenter 8.6, Informatica PowerExchange, Oracle 11g, Sybase, SQL Developer, SQL* Plus, Reflection FTP Client, UNIX, Mainframe, Facets, TOAD, MS Visio

Confidential, MD

Senior Principal Consultant

Responsibilities:

• Created Informatica mappings to load the data from FACETS to FACETS DA layer
• Created ABC (Audit Balance and Control) scripts to improve quality of workflows.
• Created JCL’s to run the workflows in Test and Production environments.
• Parameterized the code and created parameter files to automate workflows for every month.
• Used Informatica debugging techniques to debug the mappings and used session log files and bad files to trace errors occurred while loading.
• Developed workflow tasks like reusable Email, Event wait, Timer, Command, Decision.
• Created Stored Procedures, Packages in PL/SQL in order to create, update several tables like Audit Log tables, Claims tables and for Data conversion.
• Creating Test cases and detailed documentation for Unit Test, System, Integration Test and UAT to check the data quality.

Environment: Informatica PowerCenter 8.1, Oracle 9i, PL/SQL, SQL Developer, Reflection FTP Client, UNIX, IBM Mainframe, Facets, TOAD, MS Visio

Confidential, MD

Responsibilities:

• Involved in Designing, Developing and Implementing near real-time data Process flow using ETL and Data warehousing methodologies to efficiently load data in Tactical Data stores.
• Designed, Developed and Unit Tested health insurance related membership/claims application using Informatica before deploying into Integration environment.
• Scheduled, conducted and attended code review walkthrough for various Informatica developed applications as well as updated design, source documents.
• Worked on retiring various batch processes which were coded in PowerBuilder and multiple legacy systems and converting them to Informatica.
• Prepared and maintained mapping specification documentation.
• Assisted in implementing JCL on Mainframes to run Informatica jobs as well as FTP files to the shared drive from Informatica Server.
• Created source to target (STM) data mappings document to validate conformance with business need.
• Derive Test Cases and Test Data requirements and communicate it to the testing team.
• Disintegrated various stored procedures used in the application logic and converted them to mappings for performance enhancement and code consistency.
• Extensively used debugger to test defects as well as fixes in Integration/System Test environment.

Environment: Informatica PowerCenter 8.1, Oracle 9i, Sybase, SQL Developer, SQL* Plus, TOAD, MS Visio, MS Project, PowerBuilder, Telnet Unix Client, Mainframe, Facets.

Confidential, MA

Responsibilities:

• Providing Production and User support to the corporate finance applications, analyzing and documenting the production/user support tickets and provide long term fix to the issues.
• Analysis, design, coding and unit testing for maintenance and enhancement work requests.
• Peer reviewed the code changes before implementing in production.
• Performing the month end and year-end activities/tasks and supporting the UAT cycles.
• Created new online CICS maps and mapsets for ABC/BUDA1 systems.
• Made Regulatory compliance/mandated changes and rate changes as per the business requests.

Environment: COBOL, JCL, DB2, CICS, Easytrieve, Xpediter, Intertest, SAS, VSAM, ENDEVOR, CA-7, PeopleSoft, Business Objects.

Confidential, MA

Responsibilities:

• Worked as the WCPS application Team lead and interacted with the onsite WCPS SME’s for issues clarification, technical design review and participated in weekly status meetings with the client.
• Worked on the new project enhancements/maintenance work requests
• Performed coding & unit testing, implementation of code changes in to production.
• Performed impact analysis of the existing batch cycle and moved the batch cycle timing of the less critical applications.
• Worked with testing team to resolve testing defects and closed the defects.

Environment: Cobol, VSAM, JCL, NATURAL 2.3, ADABAS, File-Aid, Xpeditor, ENDEVOR, SYSPAC, PREDICT 3.4, ZEKE, Control - D

Confidential

Responsibilities:

• Involved in the documentation, analysis of the business requirements, and preparation of the technical design documents, Unit test plans and test cases.
• Construction of the programs based on the TD(Technical Design) document, preparing the test data and unit testing of the developed/modified programs, documenting the test results.
• Resolving the issues of the team members and escalating the technical issues to the client & reviewing all the deliverables before delivering to the client.
• Preparing the status reports and participating in status call with team and management.

Environment: COBOL, JCL, VSAM, DB2, EasyTrieve, Assembler, ENDEVOR, FILE-AID, XPEDITOR, INTERTEST, CA-7