SUMMARY

• Around 13 years of experience in developing and supporting enterprise level application platforms, shared and managed services in the field of ETL, data warehousing, business intelligence database management and analytical reporting. Managed technology operations and infrastructure teams in delivering value to business and technology stakeholders.
• Hands - on expertise in Informatica PowerCenter, RDBMS, Oracle, MS-SQL Server, Micro Strategy, Actuate Reports, Erwin, Data/Crystal reports.
• Around 5 years of experience working within Confidential ’s enterprise shared services teams. Have established relationships and strong network within Confidential .
• Managed the infrastructure team resources for effective day-to-day operations for ETL shared services (Informatica, MDM and Abinitio)
• Developed road maps for Informatica patch applications and upgrades aligning them with the FNMA tech mandates.
• Defined an operating model for ETL shared services - including OLA, KPI’s, roles and responsibilities, escalation paths for issues.
• Defined the shared services model for Master Data Management (MDM) application - involved in the entire lifecycle, from design to implementation of the product.
• Worked closely with JBoss engineering and Ops team to customize the needs of MDM pertaining to Confidential ’s JBoss standards.
• Worked with business stake holders to identify their issues and requirements and successfully implemented corrective actions.
• Worked with application teams to get the upgrades on their road map and manage their timelines.
• Developed best practices guidelines for Informatica platform for the application teams (35+ applications use Informatica, 50+ installed servers with 500+ application users)
• Established and documented formal processes for application team user on-boarding, operations support handbook and design documents for ETL shared services.
• Provided training for MDM/Informatica to application teams.
• Performed effective vendor management and built relationships between Informatica vendor and Confidential stakeholders.
• Facilitated engagement review and immediate need assessments between Confidential and Informatica vendor.
• Worked closely on licensing and contractual issues with Informatica vendor.
• Working with Informatica vendor support to resolve issues for Informatica/MDM services. Responsible for coordination and follow-up between various teams to resolve issues in a timely manner.
• Executed multiple end-to-end projects with good understanding of all phases of SDLC
• Experience in interfacing different data sources like Oracle and flat files from various types of source systems.
• Expertise in shell scripting and PL/SQL scripts to complement the ETL tool.

TECHNICAL SKILLS

ETL tool: Informatica PowerCenter 9.x/10x, MDM 9x; Abinitio 3.x

RDBMS

: Oracle 11g/12c, Sybase, MS-SQl Server

Scripting: UNIX shell scripting

Reporting tool: MicroStrategy, Actuate, Crystal Reports, Data Reports

Scheduling Tools: UNIX Cron, Autosys

Procedural language: PL/SQL

Platforms: SUN Solaris UNIX 9.x, Linux, Windows 98/NT/2000/XP

Programming: Visual Basic, SQL, PL/SQL

Data Modeling S/W: Erwin, MS Visio

Project Management Tool: MS Project 2000, XPlanner, Version One

Agile Tools: Kanban, Scrum

PROFESSIONAL EXPERIENCE

Confidential, Mclean, VA

Senior Data Analyst

Environment: Informatica 9x, Sybase, MS-Sql Server, Oracle 11g/12c

Responsibilities:

• Analyzed and validated the business requirements for Manager Series project.
• Developed mappings to extract data from CDW and load into SPP database to create a baseline.
• Responsible for SIT and UAT data testing in collaboration with the IT team.
• Responsible for the SIT and UAT testing for the MicroStrategy dashboard.
• Provided support for the issues that the servicers face using the dashboard.

Confidential, Reston, VA

Operations Lead

Environment: Informatica 10x, Oracle 11g/12c, MDM 9.5.1, 9.7.0; Abinitio 2x, 3x

Responsibilities:

• Developed best practices guidelines for Informatica platform for the application teams (35+ applications use Informatica, 50+ installed servers with 500+ application users)
• Established and documented formal processes for application team user on-boarding, operations support handbook and design documents for ETL shared services.
• Lead overall ETL/Informatica architecture for recommendations and implementation/development process and architecture improvements. Responsible for setting ETL coding standards, establishing/maintaining best practices, adopting and driving these principles throughout Delivery and perform Code review.
• Managed the infrastructure team resources for effective day-to-day operations for ETL shared services (Informatica, MDM and Abinitio)
• Developed road maps for Informatica patch applications and upgrades aligning them with the FNMA tech mandates.
• Defined an operating model for ETL shared services - including OLA, KPI’s, roles and responsibilities, escalation paths for issues.
• Defined the shared services model for Master Data Management (MDM) application - involved in the entire lifecycle, from design to implementation of the product.
• Worked closely with JBoss engineering and Ops team to customize the needs of MDM pertaining to Confidential ’s JBoss standards.
• Worked with business stake holders to identify their issues and requirements and successfully implemented corrective actions.
• Worked with application teams to get the upgrades on their road map and manage their timelines.
• Provided training for MDM/Informatica to application teams.
• Performed effective vendor management and built relationships between Informatica vendor and Confidential stakeholders.
• Facilitated engagement review and immediate need assessments between Confidential and Informatica vendor.
• Worked closely on licensing and contractual issues with Informatica vendor.
• Working with Informatica vendor support to resolve issues for Informatica/MDM services. Responsible for coordination and follow-up between various teams to resolve issues in a timely manner.
• Worked on upgrading the production environment from Informatica 9.5.0 HF2 to Informatica 9.5.1 and 9.5.1 HF to 9.6.1 HF2
• Responsible for certifying and testing Informatica Power center 9.5.1 HF2, 9.6.1 HF2 Version.
• Successfully upgraded all the environments for power center and DQ to 9.6.1 HF2.
• Completed the POC for Informatica 10.1.1 (DQ and PC) and the implementation plan for roll out for all the application teams.
• Completed training on AWS operations and working on used case within the team to install Informatica on AWS.

Confidential, Washington DC

Senior Engineer III

Environment: Informatica 8x, 9x, Oracle 10g/11g, Microstrategy10

Responsibilities:

• Worked on developing mappings for the loading the data into the Surgery program for all the Customers. This involved in getting an Organization stand file from the customer and converting this into a Standard format required for the Surgery Data warehouse.
• Performed unit, system and integration testing to validate source and target data and performed Internal Quality Auditing of the ETL code before delivery.
• Coordinate with the Quality Assurance team to plan and execute QA testing and resolve of any defects
• Automated ETL executions for various applications by writing UNIX scripts framework which enabled the code to run for multiple members. This increased the productivity and the turnaround time for the customers to view their data.
• Automated the purge/swap routines for various applications by writing UNIX scripts. This helped in reducing the time taken to run the ETL code.
• Worked on defining the cost model for applications using Informatica.
• Created a framework for automation of ETL migrations from non-production to production environments. This framework is used by each application and is the standard automated process for all the products. The framework generates dynamic control files to automate the infa code migration.
• Actively worked with Product Delivery teams and Development teams to define a code and customer data drop-off/migration process for every application. Identified the to-do steps for different customers.
• Took on the role as the release manager for various applications. Was responsible to get the deployments done across different technology stacks to higher environments. The role demanded planning and interaction with various deployment teams to get the plan together and implement it smoothly to the higher environments.
• ETL Admin Activities:
• In-charge of installing, configuring and fine-tuning Informatica Power Center version 8x and 9x in all environments.
• Responsible for applying service pack upgrades and patches on Informatica PowerCenter Installations.
• Worked actively with Informatica support to resolve various server, domain, integration service and repository services issues.
• Upgraded Informatica PowerCenter 8.1.1 version to 8.6.1 version, Responsible for the planning, coordination and execution of the upgrade
• Architected a multiple repository model for all the products which eased a lot of issues for the teams.
• Worked with the development teams to make changes to the core code, to facilitate the 8.6.1 upgrade (getting them upgrade ready)
• Worked with Product Mangers, Project Managers, QA team to plan, test and upgrade each product from 811 version to 861 version.
• Upgraded Informatica PowerCenter Version 8.6.1 to PowerCenter Version 9.1, Responsible for the planning, coordination and execution of the upgrade
• Designed and developed “TRENDING” DW application for support team, which captured the run-time statistics for Informatica for various applications.
• Developed an in-house timesheet application using pl-sql and excel. The results were displayed in micro strategy dashboard.
• Involved in support for upgrading Informatica metadata oracle databases upgrade from 10g to 11gr2 that used SCAN-IP configuration.

Confidential, Washington DC

ETL Developer

Environment: Data Integrator, PL/SQL, Oracle, SAS, UNIX.

Responsibilities:

• Created templates, Data mappings for various elements in the RDW data warehouse.
• Designed and Developed mappings for Servicer Scorecard.
• Wrote/Enhanced SAS Programs in the relational data warehouse to meet the user needs.
• Extensive use of PL/SQL Programming to write stored procedures, packages etc, to complement the ETL work for the servicer scorecard.

Confidential, New York City

DB /ETL resource

Environment: Informatica Power Center 7.2.1, Oracle 9i, UNIX, PL/SQL, Actuate Reporting Tool 8.

Responsibilities:

• Involved in requirement gathering and analysis.
• Participated in Project planning, Estimations for the initiatives.
• Involved in database modeling and design for Capital Markets Data Warehouse.
• Designed and Developed Informatica mappings for Capital Markets Data, which extracted from flat file into staging tables, for various dimensions like Product, People and Client.
• Extensive experience in Offshore - Onsite Coordination and team management. Managed a team of 4 at offshore.
• Wrote complex stored procedures to complement Informatica mappings.
• Worked with Actuate reporting tool, to produce various quarterly canned reports for Consolidated, Head Count and Product data.
• Wrote Autosys jobs to schedule Informatica mappings.
• Designed and implemented stored procedures, functions, packages for reporting layer in Oracle 9i.
• Solely responsible for all the DB/Informatica/Autosys programs and Reports in QA, SIT and Production releases for Capital Markets.
• Responsible for interaction with the QA team for issue resolution.

Confidential

Software Engineer

Environment: Visual Basic 6.x, PL/SQL, XML, and HTML, Windows 98/NT/2K, UNIX, Oracle 8i, Crystal Reports

Responsibilities:

• Attended trainings for Visual Basic 6.0, Oracle 8i and PL/SQL.
• Part of the VB-Oracle Application Software Development Team.
• Have worked extensively on Visual Basic 6.0, Java, Oracle 8i etc.
• Part of the QA team. Involved in conducting data and functionality testing of the applications.
• Involved in documentation and training team. Developed User Manuals and Online Help for clients.