PROFESSIONAL SUMMARY:

• 7.6+ years of total IT experience in business intelligence and data warehousing technology.
• Hands on in Erwin data modeling techniques (i.e. conceptual, logical and physical model design, Model Merge, different Model reports generation using CA’s Erwin 9x), experience with Operational Data Stores, Enterprise Data Warehouses and Data Marts.
• Hand on experience in diverse businesses with Data Warehousing/Data Integration with ETL tool like Informatica 8x, 9X, business analysis, project management and business process engagements. Scripting with UNIX, Scheduling with Control M & Tidal.
• Good working experience in advance features of Informatica like Pushdown optimization, partitioning, XML transformation etc.
• Worked in different legal and compliance projects under different domains like Insurance, Investment Banking, Asset Management, Life Science and Manufacturing.
• Extensive working experience on a global team including guiding and mentoring junior developers, knowledge transfer and best practices.
• Good working experience with large data sets and performance tuning.
• Familiarity with BI Reporting tools like Business Objects and Cognos.
• Effective oral and written communication, ability to communicate with all stakeholders at the required level. Worked with multiple teams both internally and externally and cross border.
• Ensure successful delivery of projects against agreed timelines and specifications by driving the development teams, responsible for the creation of the implementation plan, identifying and mitigating risks and resolving issues, Initiates object summary calls and provide updates on the every tasks/activity performing. Troubleshooting and debugs new and existing ETL solutions.
• Used Agile methodology and SCRUM master activity in different projects. s: Got many times wow s & customer appreciations for great work and end to end implementation of assigned project work successfully and fixing production issues.

SKILL SUMMARY:

Technology: DWH DI & BI

ETL Tool: Informatica 7/8x/9x (Expert), OWB, SSIS and Abinitio (Trained & Beginner)

Design and modeling tool: Erwin

Data bases: Teradata, Oracle 10g, SQL Server

BI Tool: COGNOS and BO (familiar)

Version Control: MS Visual Source Safe (VSS), SVN

Scripting Languages: UNIX Shell Script, C# (with .NET beginner)

Batch Monitoring tool: Control - M

Test management Tool: ALM QC

Verticals/Functional Domain: Investment Banking & Financials, Asset management, Insurance (life / Non life), Manufacturing and Life-Science.

PROFESSIONAL EXPERIENCE:

Confidential, Austin, TX

Data Modeler & Development Lead

Responsibilities:

• Participating in BRD review, scoping, in depth analysis with providing sample data to review by Business.
• Design - Data Model with review/approvals.
• Design - Informatica solution with review and Approvals.
• Take care of complete implementation activity with SIT/UAT review signoff.
• Take care of defects tracking during SIT/UAT.
• Follow Confidential standard practices and process and mentor the development team onsite and offshore.

Environment: Erwin, Informatica 9X, Confidential -DIAL Scripting Tool, Confidential -SeaQuest database, UNIX Shell Scripting and Confidential ALM tool.

Confidential, NY

Data Modeler/Technical Lead along with Onsite Coordinator

Responsibilities:

• Participated in initial project setup, team setup at offshore, KAP planning.
• Participated in project planning and KAP sessions with project managers, Client, business analysts and team members to analyze current business, all standard process used, and type of business requirements and outline the proposed IT solution.
• Created technical design recommendations for developing and integrating programs per written business / functional specifications; complied with Project Life Cycle Methodology and IT Control policies/Architectural standards in all planning steps.
• Utilized methodology to enhance existing system and new Book Of Work to ensure applications are suitably fit for use and admissible for maintenance/upgrades.
• Identify or troubleshoot application code-related issues; and review and provide feedback to the final user documentation.
• Completed end to end development cycle with production install and post install support.
• Participated in code reviews and ensure that all solutions are aligned to defined architectural and functional specifications.
• Worked on Upstream as well as downstream to generate Extract file through C# script and SQL Server database.
• Onsite Offshore Coordination, BOW analysis and UAT support @onsite.
• Involved in data model design (Logical and Physical data model) in CS project TIS360 using Erwin tool. Contributed efforts to complete logical and physical data model and data analysis review and approvals with Architect Team in client side. Also involved in preparing technical specs and complete ETL cycle till go live along with code review and QA/UAT support.
• Involved in logical and physical data model design part for new source system Tempast added in existing data model of CID dashboard with designing team at client location. Contributes in initial model documentation, Logical and Physical model design using Erwin, data analysis as per requirement, corrections in model as required. Then Involved in Extract data from Tempast source and generate upstream source files and send to CID Dashboard for ETL process. Support ETL offshore team to understand requirement, implement ETL workflows using Informatica, Review after UT, QA support, UAT support and Production implementation.

Environment: Erwin 7x/9x, Informatica 8x/9x, ORACLE SQL/PLSQLUNIX Shell Scripting, Visual Studio -C# scripting with SQL Server.

Confidential

Technical Lead

Responsibilities:

• Responsible for gathering business requirements for various assignments under project and ensuring the final delivery meets the business expectation in terms of functionality without any defects.
• Managed teams for project to deliver project for critical businesses.
• Taken initiatives to make the knowledge available for future projects, enabling - re-use of methodologies, tools and domain understanding, helping increasing the efficiency of future deliverables and eliminating dependencies.
• Mentored and taken the responsibility of bring new members up-to-speed. Guiding the team constantly to take up higher challenges and scale up in much shorter time-frame.

Environment: INFORMATICA POWERCENTER,ORACLE SQL, UNIX SHELL SCRIPTING, Control M

Confidential

Sr. Developer cum Technical Lead

Responsibilities:

• Participated in project planning sessions with project managers and onsite counterparts to understand and analyze business requirements and outline the proposed IT solution with timelines.
• Created technical design recommendations for developing and integrating programs per written business / functional specifications;
• Utilized required feature of tool to ensure data mart are suitably fit for use and admissible for maintenance/upgrades.
• Completed end to end development cycle with production install and post install support.
• Participated in code reviews and ensure that all solutions are aligned to defined architectural and functional specifications.

Environment: INFORMATICA POWERCENTER, ORACLE SQL, TERA Data, UNIX SHELL SCRIPTING

Confidential

Offshore team Lead

Responsibilities:

• Created technical design recommendations for developing and integrating programs per written business / functional specifications.
• Identified or troubleshoot application code-related issues; and review and provided feedback to the final user documentation.
• Completed end to end development cycle with production install and post install support.
• Participated in code reviews and ensure that all solutions are aligned to defined architectural and functional specifications.

Environment: INFORMATICA POWERCENTER, ORACLE SQL, UNIX SHELL SCRIPTING

Confidential

Offshore team Lead

Responsibilities:

• Requirement Analysis.
• Coding (involves policy rule coding, sequence flow, status flow, and dictionary entries).
• Unix Scripting for scheduling and Parameterization ETL Jobs and Unit Testing.

Environment: INFORMATICA POWERCENTER, ORACLE SQL, UNIX SHELL SCRIPTING

Confidential

Technical Consultant

Responsibilities:

• Replacement for the current Customer Price System (CPS) data entry function which currently allows local markets to report back to World Wide HQ.
• Creation of a new Global reimbursement and price referencing repository. Easily capture country specific reimbursement plans, rates, co-pays and plan details. Additionally this system will capture the countries that are used by payer agencies as pricing points in negotiating with Confidential .
• Consolidate syndicated data, such as MTA/IMS, into an easy to use interface that allows internal Confidential data to be analyzed and viewed side - by - side with external competitive data.
• Integrate sales data, current pricing, cost and competitive data.
• Create a global pricing and reimbursement data dictionary that defines commonly used terms and explicitly catalogs formulas and calculations used in analytics.
• Requirement Analysis, Coding (involves policy rule coding, sequence flow, status flow, and dictionary entries) & Unit Testing.

Environment: INFORMATICA POWERCENTER, ORACLE SQL, UNIX SHELL SCRIPTING

Confidential

Sr. Developer

Responsibilities:

• Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed IT solution.
• Created technical design recommendations for developing and integrating programs per written business / functional specifications; incorporated security requirements and provided input to information/data flow, and understood and complied with Project Life Cycle Methodology and IT Control policies/Architectural standards in all planning steps.
• Participated in code reviews and ensure that all solutions are aligned to defined architectural and functional specifications.
• Identified or troubleshoot application code-related issues; and review and provided feedback to the final user documentation.
• ETL Design and Development to Populate Life Asia (DB2 I-series), Wonders and Sun application (Oracle) incremental data to staging area and transform to ODS Data Warehouse (Oracle 10g).
• Unit testing for all the data on Life Asia, Wonders and Sun.
• Completed MIS assignments like Claim MIS, Claim intimation.
• Developed Impromptu Reports and Power play cube using Cognos V 7.1.
• Supported BI team.

Environment: INFORMATICA POWERCENTER, ORACLE SQL, UNIX SHELL SCRIPTING, Cognos

Confidential

Sr. Developer

Responsibilities:

• Project plan, BRD and Implementation of MIS System
• Designed Mappings sessions and workflows using Informatica for Policy, Reinsurance, and Motor subject area.
• Designed dataflow task, execute SQL task with in complete package using MS Visual Studio 05 (SSIS) for Claim subject area.
• Created DB2Scripts for Transform Data from AS400 - DB2 as Source System into DB2 on Windows as Target / Staging / Reporting Database System.
• Developed Impromptu Reports and Power play cube using Cognos V 7.1.

Environment: SSIS, INFORMATICA POWERCENTER, DB2 UDB, Cognos 7X