Professional Summary

• 15 years of IT experience in the field of Data Warehousing, Application Development, Conceptualization, design and implementation of projects
• Expert level skills and specialization in Application Development, Application Maintenance, Production Support to Decision Support System DSS and Enhancement Projects in Data Warehouse, Client Server Architecture applications and databases
• Extensive experience 10 years with various ETL tools such as Informatica PowerCenter 9.x/8.x/7.x/6.x/5.x, Striva Detail Navigator, Powerconnect for AS400, Data Transformation Services DTS
• Perform Informatica tool Administration, upgrades, global deployment and tool monitoring, Performance tuning
• 10 years of extensive experience as an Informatica Consultant/Administrator setting up best practices and standards Specialized in designing the Infrastructure to install and configure the ETL tool Informatica Powercenter on various servers
• Developed standards for coding folder migration
• Primary contact for Informatica developers to escalate issues to Informatica Technical support and implement the resolution provided
• Developed PMCMD commands and Korn Shell scripts to automate startup/shutdown of the repository, pmservers, pmrepservers
• Worked extensively on various Informatica Data Integration components - Repository Manager, Workflow Manager/Server Manager, Designer
• Extensively worked on Informatica Workflow Manager/Designer Components - Source Analyzer, Warehousing Designer, Transformations Developer, Mapplet and Mapping Designer, Task Developer, Workflow Worklet Designer
• Worked extensively in designing parameters for extraction, cleansing, validation and transformation of data from various source systems to Data Warehouse
• 10 years of expertise in using SQL, PL/SQL, Procedures, Functions, Packages, T-SQL scripts query optimization techniques
• Extensive work experience with Oracle and SQL Server
• Good knowledge of Unix shell scripting, Korn Shell, Oracle 11g, SQL Server 7.0/2000, Visual Basic 6, ADO, FTP, NDM Connect:Direct
• Worked in various roles as Senior Informatica Admin, Lead Informatica Consultant, Senior Data Migration Specialist, Team member in different assignments
• Managed and Mentored developers on usage of Informatica and best practices
• Excellent Client Interaction, Communication Presentation skills

Work Experience:

Confidential

Team Lead/ETL Architect

• HCR-004: A federal/state mandate, HCR calls for three premium stabilization programs related to members on the exchange: risk adjustment, reinsurance and risk corridors. As per the requirement the insurer data membership and claims will be collected, processed and submitted to CMS.
• Currently assigned to this project and core responsibility entails gathering business requirements, create application design, collaborate with product development team and senior designers to develop architectural requirements to ensure client satisfaction, ensure design meets requirements, source data analysis/profiling, writing technical specifications/data mapping, head complex ETL requirements and design, lead and guide development of an Informatica based ETL architecture, co-ordinating with Data Modeler/DBA in implementing database changes etc.
• EDW R5: The EDW Release 5 R5 project was launched to support the addition of data from iFacets as a result of the teansformation program.
• Currently assigned to this project and primary responsibility was to focus on the creation of a new pipeline of data into the EDW, from iFacets via hpxr. Other areas where I was involved was in a re-desgin of then underlying EDW database structure to support the new iFacets subject areas and data elements and a conversion of existing EDW data into the new structure.
• CDMA to Analytix Conversion: Analytix is an Pre-ETL source to target mapping tool. Excellus bought this tool to replace incumbent CDMA.
• I was part of the procurement team representing Data Integration Team and was involved in detail with product evaluation, testing and implementation. I was also responsible for creating/documenting user guide, technical specs. and writing conversion mappings. Additonally, created training materials for Solution Architects and development team.
• MRA Datamart : The Centers for Medicare and Medicaid Services CMS has transitioned to a 100 risk adjusted payment system for Medicare Advantage and Part D Plans. This system requires the timely and accurate submission of member diagnosis information RAPS files to CMS. CMS uses this information to determine the health status of a member, which in turn determines the payment to the health insurer to cover the member's anticipated claims expenses and plan administration expenses.

Responsibilities

• Create application design, High level design based on customer requirements
• Ensure design meets the requirements
• Source data analysis/profiling where necessary
• Managed developers and their task allocations.
• Developed various Informatica mappings, mapplets, task, workflows
• Mentored developers on usage of Informatica and best practices to assist them with development life cycle
• Developed various PL/SQL and unix scripts
• Provide technical assistance to DW, IT, AD/SQA staff supporting strategic and discretionary projects. Version upgrades of existing tools. Applying patches and fix packs.
• Promote effective use of database tools through creating and administering education programs, performance monitoring, facilitating use of industry best practices.
• Document and administer database toolset policy/procedures for change management, security, performance optimization, version control, and development of standards.
• Act as a liaison between AD/SQA, Database Administration, Systems Programming and Corporate Data Security.
• Production support.
• Capacity Monitoring and Planning, Migrating code between environments.
• Involved in the process of informatica upgrade from version 8 to 9
• Environment Informatica PowerCenter 9.x, Oracle 11g, PL/SQL, DB2, Korn Shells, Unix Scripts, Sun Solaris, AIX, ControlM, Analytix

Confidential

Sr. Informatica Administrator Administrative Tasks

• Gather user and data requirements to get the estimate on the type/size of server required for the projects
• Worked on Estimates, Project planning, Resource allocation, Work co-ordination
• Installed, created and configured dev/test/prod instances of Informatica Power Center 8.x repositories and servers
• Repositories installed on AIX boxes into Oracle database and servers installed on separate AIX boxes
• Installing Informatica clients on users machines
• Developed coding standards documents
• Created and managed shared and user folders and their security
• Created and managed users and UID's and assigned privileges to different users based on their role
• Managed locks in Informatica Repository Manager
• Implemented best practices in Moving/Copying folders/mapping Exporting and importing objects between repositories
• Wrote PMCMD and PMREP commands and Korn Shell scripts to automate various administrative tasks
• Upgraded Informatica Powermart 7.x to PowerCenter 8.x
• Installed, created and configured dev/test/prod instances of Informatica Power Center 8.x repositories and servers
• Development and Test pmservers installed on one server sharing the same PM HOME and production pmserver installed on a separate server
• Developed and maintained capacity plan to accommodate the normal and projected growth which may require additional hardware/software and disk space
• Developed and continuously improved the automated tools monitoring process to maximize the applications up time and proactively monitor the systems
• Performed production support for different applications
• Assisted users with their requests
• Mentored users on usage of Informatica and best practices
• Environment Informatica PowerCenter 8.x, Oracle 10g, PL/SQL, DB2, Korn Shells, Unix Scripts, Sun Solaris, AIX, Autosys

Confidential

Sr. Informatica Consultant

• BXI3 - Blue Exchange Iteration3: was one of the mandated project to support IT services within Excellus and also external vendors for quering the Product ODS. Product ODS will pull group package and benefit detail information from four different source systems, for use by Blue Exchange application. I worked as a Lead Informatica consultant on the project.
• NPI - National Provider ID: A mandated project to support Fiance and IT services within Excellus. Covered health care providers and all health plans and health care clearing houses will use the NPI's in the administrative and financial transactions adopted under HIPAA. The NPI must be used in lieu of legacy ID in the HIPAA standard transactions. I am responsible for updating Datawarehouse extracts going out to vendor. Also, responsible for co-ordinating with external vendors on the timeline of successful migration from LegacyId to NPI. I worked as a developer lead on the project.
• Blue Green: The new Blue Green is a business strategy that spans proactive portfolio management, product innovations and enhanced customer experience. I am responsible for co-ordinating, configuring/setup and load systems with new product and rate information. Existing ETL's need to be updated to populate Product ID and Group Package variables in Product ODS.

Responsibilities

• Create application design, High level design based on customer requirements
• Ensure design meets the requirements
• Source data analysis/profiling where necessary
• Managed developers and their task allocations.
• Developed various Informatica mappings, mapplets, task, workflows
• Mentored developers on usage of Informatica and best practices to assist them with development life cycle
• Developed various PL/SQL and unix scripts
• Develop technical specification and other documentations.
• Production support.
• Environment Informatica PowerCenter 7.x, Oracle 9i/10g, PL/SQL, DB2, Korn Shells, Unix Scripts, Sun Solaris, AIX, ControlM

Confidential

Lead ETL Consultant

Responsibilities

• Participated in various ongoing projects, worked with data architects, DBA's, team members
• Gathered and analyzed Business requirements and then Converted them into formal specifications design documents
• Perform ETL application design, development and implementation for batch process
• Developed ETL procedures to ensure conformity, compliance with standards and lack of redundancy, translated business rules and functionality requirements into ETL mappings
• Used ETL methodology for all data loads and developed mapping specifications and transformation logic to implement business logic
• Extensively worked on Defining Flat File, Relational Source Targets, Designing Transformations Logic, Create Mappings and Mapplets
• Created Session, Command, Event Tasks, Worklets and Workflows using Workflow Manager
• Designed testing strategy for ETL and designed automation process for backend testing
• Massive Data Migration of data between different systems
• Scheduled the Jobs Run the Workflows and Tasks using Workflow Manager, UNIX Scripts both in Sequential Concurrent Processing
• Developed data maps using Striva Detail Navigator Power Connect for AS/400
• Extensively involved in performance tuning of the Informatica Servers/Codes at different levels

Confidential

Data Migration Specialist

Responsibilities

• Extensively involved in requirements gathering with end users
• Build the databases into SQL Server 7.0 and created pertinent tables, views, triggers and indexes for optimal performance
• Created users, user id's, Assigned privileges to different users based on their role
• Wrote stored procedures to automate the provisioning of the file and processing the response file
• Get the provisioning file from the billing system via FTP and use DTS/BCP to import the file into SQL Server 7.0 DB
• Validate the data, do statistical calculation and map the data to the LD provisioning system layout
• Export data using DTS/BCP to the text file for FTP /NDM'ing to the provisioning company
• Process the acknowledge/response file from the provisioning company and update the DB and generate error report for bad errors
• Audit the database using insert/update/delete Triggers
• Involved in production support and enhancements
• Migrated sql server database from one Server to another server
• Used SQL Server 7.0 DTS designer to create a transfer database task and transfer logins task
• Scheduled the package to run during business off hours
• Develop an application using VB 6 to facilitate the end user to request a data feed
• Build the application and database using SQL Server 7
• Link the application to the Sql server database using ADO connection object
• Enable data feed personnel to generate reports based on different feeds stored in the database
• Use Insert trigger to notify the Data feed team of the new request via email
• Gather user requirements to build the application and database for NIP Process
• Developed a VB6/Sql Server application to automate the NIP process
• Design a VB6/TSQL application with the possibility to insert, view and analyze activity on a particular WTN
• Harvest the table 4 times a day to send out the new records for Long Distance provisioning
• Developed various stored procedures to automate data insertion, data manipulation, statistical calculation and data formatting
• Environment Sql Server 7.0/2000, SQL/PLSQL, DTS, Import/Export wizard, FTP/NDM, VB6.0, ADO, SQL Stored procedures, SQL Triggers

Confidential

Database Consultant

Responsibilities

• Extracted and loaded data into Oracle database using SQL Plus and SQL Loader
• Used SQL Plus and shell scripts to generate reports
• Use SQL Loader to define the control file to load data files into multiple tables
• Wrote UNIX scripts to move files between different systems
• Generated multiple reports using SQL/PLSQL stored procedures.
• Documented the whole ETL process and application
• Environment Oracle 8.0, SQL Loader, SQL Plus, Korn Shell scripting

Confidential

Project Planning Automation and Information Systems

Programmer Analyst

Worked as a Programmer with Mafatlal consultancy to design and develop different applications.

Responsibilities:

• Gather user requirements and design database
• Worked with the team to design, develop and implement the Cost Estimation project
• Created database and tables to hold the corresponding data using Oracle 7.0
• Wrote various stored procedures, functions, SQL queries for data manipulation and calculation
• Generate reports from one or more underlying tables using SQL Report writer to serve a well defined purpose
• Environment Oracle 7.0, Forms 3.5, SQL/PLSQL, SQL Report writer