SUMMARY

• Over 12+ years of extensive experience in IT industry with good exposure in data modeling, data architect, solution architect, data warehousing, business intelligence and master data management (MDM) concepts.
• Strong Knowledge of all phases of Software Development Life Cycle and have worked in large scale projects with incremental deliverables
• Good Knowledge of Waterfall and Agile SDLC model. Worked in many agile projects involving 2 - 3 weeks of Sprint cycle.
• Hands-on experience of leading end to end Data warehousing projects, ETL design documentation and BI Data Visualization.
• Experience in OLTP Modeling (2NF, 3NF) and OLAP Dimensional modeling (Star and Snow Flake) using ERwin (conceptual, logical and physical data models)
• Trained in Big Data - Cloudera Hadoop, HDFS, HIVE, Pig, Squoop and Hbase.
• Extensive knowledge in architecture design of Extract, Transform, Load environment using Informatica Power Center.
• Worked on Informatica Cloud to design mappings, Data synchronization, Data Replication tasks and configure connections.
• Worked on Informatica cloud to replicate Salesforce and SAP data with on premise Oracle and SQL Server database.
• Hands-on experience of Informatica Cloud to design and develop real-time integration interface (APIs) using pre-installed salesforce and database connectors.
• Experience in implementing the complex business rules by creating Informatica transformations, re-usable transformations (Lookup (Connected and Un-connected), Joiner, Union, Sorter, Aggregator, Rank, Normalizer, Filter, Router and Update Strategy), and developing complex Mappings & Mapplets.
• Experience in data quality tools like Informatica Data Quality (IDQ)
• Experience in Informatica Power Exchange to read data from Mainframe/Cobol files.
• Expertise in debugging and performance tuning of Informatica mappings, sessions and SQL stored procedures
• Experience with relational databases such as Oracle 8i/9i/10g/11g, SQL Server, Teradata, MS Access
• Strong skills in SQL, PL/SQL programming like packages, functions, stored procedures & triggers
• Hands on experience in UNIX shell scripting
• Experience in working with various scheduling tools (Control M scheduler & Autosys)
• Team Player; Excellent Interpersonal skills; Ability to work effectively with different stakeholders in a project

TECHNICAL SKILLS

Core Competency: Data modeler, Data architect, ETL solution architect, Master Data Management (MDM) specialist, Business Intelligence (BI) Manager

Data warehouse Utilities: Informatica Power Center, Informatica Data Quality, Informatica Master Data Management

Databases: Oracle, SQL Server, Teradata, MS Access

Database Tools: TOAD, PL/SQL Developer, Microsoft SQL Server Studio

Development Framework: Agile, Waterfall

Schedulers: CA scheduler(Autosys), Control M scheduler

Programming Languages: Visual Basic, ASP, Java Script, VB Script, HTML

Other Tools: MS Office, MS Project Plan, MS Visio, SharePoint

Operating System: Windows, UNIX

PROFESSIONAL EXPERIENCE

Confidential, Phoenix, AZ

Tech Lead

Responsibilities:

• Conduct requirement gathering sessions with Analyst to understand technical requirement.
• Transform technical requirements into ETL design.
• Review Source to target mappings and provide feedback to Analyst.
• Participate in ETL Design review sessions.
• Design and Develop Informatica mappings based on Source to target mapping.
• Design and Develop Informatica sessions and workflows.
• Developed mappings using Informatica Cloud to extract data using salesforce connector at real time and load it into SQL Server database.
• Co-ordinate and provide technical assistance during Testing phase.
• Provide details migration steps to Informatica admin for Test and Production deployment.
• Monitor data load in TEST and Production post deployment.

Environment: Informatica Power Center 9.6, Informatica Cloud, Informatica Data Quality, Informatica Metadata Manager, Salesforce, Oracle 11g, SQL Server, Windows, Autosys scheduler.

Confidential, Lake Forest, IL

ETL Architect/DWBI Manager

Responsibilities:

• Conduct requirement gathering sessions with business team to understand business requirement.
• Transform business requirements into FRS (Functional Requirement Specification). Perform impact analysis, Understand project scope and assumptions.
• Prepare work order document, Provide estimate and Resource Load plan for project execution.
• Perform data analysis to put forward the Solution Design. It involved browsing through different Source systems, document the availability/gaps & then come up with a solution to bring data from these Source systems into one single Warehouse.
• Prepare/Modify application architecture diagrams.
• Prepare Detailed Technical Design document including Source to target mappings for Informatica.
• Enable offshore team for ETL development. Coordinate with offshore team to get the development done as per FRS & Design document.
• Develop mappings using Power center and Informatica Cloud to extract data from salesforce, SAP and load it into Teradata and oracle database.
• Conduct code review sessions with offshore team to ensure code is aligned with requirements and conform to coding standards.
• Review system test protocol documents and coordinate system testing.
• Provide technical assistance to business users during User acceptance testing phase.
• Work with deployment groups and DBA to deploy changes into production.
• Performed knowledge transition to the Operations Support team.
• Provided hyper-care support post successful Production go-live.
• Prepare weekly status report, conduct weekly status meeting with all stake holders to communicate project status.

Environment: Informatica Power Center 9.x, Informatica Data Quality, Informatica Metadata Manager, Informatica Cloud, Salesforce, SAP, Oracle 11g, SQL Server, Teradata, Unix, Autosys scheduler, IBM Message Queue.

Confidential, Temecula, California

Informatica Architect/ ETL Lead

Responsibilities:

• Conduct requirement gathering sessions with business team to understand business requirement.
• Transform business requirements into FRS (Functional Requirement Specification).
• Prepare application architecture diagrams.
• Data Modeling, DWH/Data Mart Design and Design Documentation.
• Prepare Detailed Technical Design document including Source to target mappings for Informatica.
• Enable offshore team and coordinate development activities as per FRS & Design.
• Planning and managing day - to - day activities and interaction with client to facilitate smooth implementation.
• Conduct code review sessions with developers to ensure code is aligned with requirements and conform to coding standards.
• Provide support to business users during User acceptance testing phase.
• Develop mappings using Informatica Cloud to extract data from salesforce and load it into Teradata and Oracle database.
• Coordinate deployment activities with different deployment groups and DBA.
• Performed knowledge transition to the Application Support team.

Environment: Informatica Power Center 9.x, Informatica Cloud, Rackspace cloud database, Oracle 11g, Teradata, Unix, Salesforce, SAP, Autosys scheduler.

Confidential, Springfield, Massachusetts

Informatica Designer, Technology lead

Responsibilities:

• Participated in Project Team & Business Meetings to understand & record the Requirements of the Project.
• Participated in project planning sessions with Project Managers, Business Analysts and Support Team members to analyze business requirements and outline the proposed solution.
• Prepare Requirement document, Software Design Document
• Perform ETL development activities under subject matter expert supervision using Informatica power center designer and workflow manager.
• Perform Unit testing and System Integration testing.
• Provide Technical support during UAT Phase.

Environment: Informatica Power Center, Informatica Power Exchange, Oracle 11g, SQL, PL/SQL, Unix, Salesforce, Autosys scheduler.

Confidential

Technology Lead

Responsibilities:

• Conduct Requirement Gathering session to understand business requirements.
• Prepare Functional Specifications and ETL design document and get it reviewed with subject matter expert.
• Prepare Detailed Technical Design document including Source to target mappings for Informatica.
• Enable offshore team for ETL development. Coordinate with offshore team to get the development done as per FRS & Design document.
• Conduct code review sessions with offshore team to ensure code is aligned with requirements.
• Review system test protocol documents and coordinate system testing.
• Prepare weekly status report to share it with all stakeholders.
• Conduct knowledge transition sessions with application support team.
• Guide offshore team members in developing high quality deliverables.

Environment: Informatica Power Center, SQL, Oracle PL/SQL, Unix,, Oracle 11g, Autosys scheduler, Putty.

Confidential

Informatica Designer, Technology lead

Responsibilities:

• Conduct Requirement Gathering session to understand business requirements.
• Prepare Functional Specifications and ETL design document and get it reviewed with subject matter expert.
• Perform ETL development activities under subject matter expert supervision using Informatica power center designer and workflow manager.
• Prepare Unit test & System Test Case documents.
• Perform Unit testing and System Integration testing.
• Prepare weekly status report to share it with all stakeholders.
• Conduct knowledge transition sessions with application support team.

Environment: Informatica Power Center, SQL, Oracle PL/SQL, Unix,, Oracle 11g, Autosys scheduler, Putty.

Confidential

Technology Lead

Responsibilities:

• Worked as Technology Lead of Customization core team.
• Worked closely with sales team on design discussions, responsible for doing Requirement analysis, project estimations, code review and project delivery.
• Involved in Code Optimization projects, Scripts Optimization of PL/SQL code.
• Assisting the development team in customizations, Enhancements and code changes as per the change request.

Environment: Informatica Power Center, SQL, Oracle PL/SQL, Unix, Oracle 11g, Autosys scheduler, Putty.

Confidential, Sunnyvale California

I.T. Analyst

Responsibilities:

• Worked as Team Lead & Onsite coordinator for this project, responsible for getting work done from offshore team.
• Worked directly with Product owner and customer for requirement collection, design discussions, and project estimation.
• Responsible for doing project planning, project estimation, resource planning, work allocation, code review, unit testing and project delivery.
• Assisting the development team in customizations, Enhancements and code review as per the change request.
• UAT and Production support.

Environment: Informatica Power Center, SQL, Oracle PL/SQL, Mod PL/SQL, Javascript, Unix, Oracle 11g, Autosys scheduler, Putty.

Confidential

Asst. System Engineer

Responsibilities:

• Worked as Modules lead of Change Management Team, responsible to co-ordinate all code change in production environment.
• Responsible for customizations and code changes includes Oracle SQL and PL/SQL in the existing production environment.
• Assisting the development team in customizations, Enhancements and code changes as per the change request.
• UAT and Production support.

Environment: Oracle PL/SQL, SQL, Unix, Oracle 11g, Autosys scheduler, Putty.

Confidential

Programmer/Implementation Consultant.

Responsibilities:

• Implementation Coordinator.
• Implemented this product in Zulekha Hospital Dubai-UAE.
• Generating user reports using Oracle SQL, PL/SQL for various modules.

Environment: Oracle PL/SQL, SQL, Oracle Forms, Unix, Visual basic, Putty.

Confidential

Programmer/Implementation Consultant.

Responsibilities:

• Implementation Coordinator.
• Providing Online/offline Technical Support to BHEL Users.
• Generating reports using Oracle SQL, PL/SQL for various modules.

Environment: Oracle PL/SQL, SQL, Oracle Forms, Unix, Visual basic, Putty.