SUMMARY:

• Self - motivated, innovative and goal-oriented professional committed to pursuing a long-term career in building business intelligence (BI) and data warehousing (DW) solutions.
• Offer 15 years of track record demonstrating strong analytical and problem solving skills, computer proficiency and ability to follow through with projects from inception to completion, always striving to deliver the best of both industry and consulting worlds while meeting all applicable business goals and objectives.
• Currently working as Business Intelligence Technical Architect with Confidential
• Extensive experience using ETL methodology for supporting Data Extraction, Transformations and Loading. Processing, using Informatica 9.x\8.x, Informatica Power Exchange and Informatica Analyst tool.
• Extensive experience working in an Agile Development environment.
• Highly skilled in create/modify statement of work (SOW), manage teams and resources, Project estimates, create functional and technical documents, data analysis and resolve critical issues.
• Strong Data Warehousing ETL experience using Informatica Power Center 9.x, Informaitca Power Exchange 9.x, Informatica Analyst, Informatica IDQ 9.5, Hadoop 9.5, MDM, Big Data
• Experienced in the Requirements Data Analysis, Mapping, Design, Development, Testing and Implementation of datawarehouse systems, datamarts for Financial, Communication and Retail domains.
• Extensive experience in business analysis, source to target mapping, Data flow diagrams
• Creating DFD, HLD, LLD, Technical specification document (TSD)
• Experienced in mentoring the Onsite and Offshore developers and getting the quality code delivered on time.
• Strong experience in working with Databases like Oracle 11/10/9, MS SQL Server 2000, 2005
• Excellent team player with strong written, communication, interpersonal skills.
• Design complex solutions to meet business requirements and manage the projects efficiently.
• Working in a client facing role and Technology Lead for the project

KEY SKILLS:

Functional: Project Management, Technical Architecture, Team Leader (Onsite/Offshore), Strategic/Tactical Planning, Business Analysis and Development, Bu d geti n g/ F o r e c a s ti ng, Excellent Communication and Interpretation skills

Technical: Informatica Power Center 9.x, Informaitca Power Exchange 9.x, Informatica Analyst, Informatica IDQ 9.5, Hadoop 9.5, MDM, Big Data, Oracle 10g, Microsoft SQL server management, Toad 9.x, windows 10, Data Integration Scheduler (DIS), HP Quality Center

TECHNICAL SKILLS:

RDBMS: Oracle 10g/9i/8i, DB2, MS SQL SERVER

Languages: SQL, PL/SQL

ETL Tools: Informatica (Power Center 9.x/8.x, Power Exchange 8.x, Informatica Analyst)

BI Tools: Business Objects, Oracle Business Intelligence Enterprise Edition 11g (OBIEE), Microstrategy

Dimensional Data Modeling: Dimensional Data Modeling, Star Schema Modeling, Snowflake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, ERWIN

Operating Systems: Windows NT/98/95, MS DOS, UNIX.

Other Tools: Toad 9.x/8.x, PL/SQL-Developer, MS-Office, Data Integration Scheduler (DIS), SM9, Quality Center

EMPLOYMENT HISTORY:

ETL Architect / Lead Developer

Confidential

Responsibilities:

• Design complex solutions to meet business requirements and manage the projects efficiently.
• Co-ordinate Onsite and Offshore developers and getting the quality code delivered on time.
• Work with the manager and team to establish and implement industry best practices.
• A seasoned enterprise integration architect who has experienced the evolution of the enterprise integration space over the past 9 years from point to point integration to ETL.
• Solutions architecture experience with complex enterprise applications including Data warehousing /BI, MDM implementations.
• Strong experience on Project Management, Systems Integration, Data warehouse architecture, Database Design, ETL Design, Report Design, ETL Optimization, Data Profiling, Data quality process design, Best practice implementation, ETL Development, Production support and team co-ordination.
• Subject Matter Expert (SME) for the Data warehouse.
• Data acquisition, Data analysis, Data mapping, data profiling and source to target mapping
• Creation of BRD/DSD. Data Requirements, Data flow diagrams, key data analysis and data remediation
• Multi-task under pressure to meet the deadlines.
• Plan and execute tasks to meet Organizational objectives and goals.
• Responsible for the Data model design and implementation using Informatica.
• Interfacing with the Business users and the client Technical teams during various stages of the project.
• Co - ordinate deployments and UAT support

BI ETL Architect/Technical Manager

Confidential, Canton, MA

Responsibilities:

• Working in a client facing role and Technology Lead for the project
• Preparation of Estimates and responding to the Change Requests.
• Subject Matter Expert (SME) for the Data warehouse.
• Coordinate and manage the tasks assigned to external consultants.
• Plan and execute tasks to meet Organizational objectives and goals.
• Perform cost estimation and proposals for new projects/enhancements.
• Work with stake holders across the board to understand their requirements and explain available options in non-technical terms.
• Design complex solutions to meet business requirements and manage the projects efficiently.
• Work with the manager and team to establish and implement industry best practices.
• Manage the team and communication on behalf of the Manager as needed.
• Multi-task under pressure to meet the deadlines.
• Coordination with the offshore project manager on daily basis for status tracking and issue resolution.
• Responsible for the Data model design and implementation using Informatica.
• Responsible for the OBIEE reporting solution (11g) based on the data model.
• Interfacing with the Business users and the client Technical teams during various stages of the project.
• Involved in the preparation of Business Requirements Document and Technical requirement document for the project.

BI ETL Lead Devloper

Confidential, Alpharetta, GA

Responsibilities:

• Working in a client facing role and Technology Lead for the project
• Preparation of Estimates and responding to the Change Requests.
• Subject Matter Expert (SME) for the Data warehouse.
• Coordinate and manage the tasks assigned to external consultants.
• Plan and execute tasks to meet Organizational objectives and goals.
• Perform cost estimation and proposals for new projects/enhancements.
• Work with stake holders across the board to understand their requirements and explain available options in non-technical terms.
• Design complex solutions to meet business requirements and manage the projects efficiently.
• Work with the manager and team to establish and implement industry best practices.
• Manage the team and communication on behalf of the Manager as needed.
• Multi-task under pressure to meet the deadlines.
• Coordination with the offshore project manager on daily basis for status tracking and issue resolution.

ETL Tech Lead

Confidential, Fishers, IN

Responsibilities:

• Subject Matter Expert (SME) for the Data warehouse.
• Plan and execute tasks to meet Organizational objectives and goals.
• Provide proof of concept (POC) as required to the business users.
• Coordinate and manage the tasks assigned to external consultants.
• Develop & Support Answers and Dashboards (OBIEE 10g).
• Provide the team with a vision of the project objectives and Motivate, inspire team members.
• Keep the project manager and product committee informed of task, issues and status.
• Exposure to quality process.
• Contributing to the development, Provide technical guidance to the team and improvement of processes and procedures.
• Working on additional tasks and responsibilities as assigned that will contribute towards team, department, and company goals.
• Coordinates meetings with the product committee, project manager and functional management to discuss project impediments, needed resources or issues/delays in completing the task.

Offshore/Onsite Tech Lead

Confidential

Responsibilities:

• Developed complex Informatica mappings to load the data from various sources using different transformations like source qualifier, connected and unconnected look up, expression, aggregator, joiner, filter, normalizer, rank and router transformations.
• Worked Informatica power center tools like source analyzer, mapping designer, mapplet and transformations.
• Developed Informatica mappings and also tuned for better performance.
• Worked with MLOAD, FASTLOAD, TPUMP and BTEQ utilities of Teradata for faster loading and to improve the performance.
• Extensively used Informatica to load data from flat files, Oracle, Teradata database.
• Teradata views have been developed against the Departmental database and claims engine database to get the required data.
• Extensively used various Functions like LTRIM, RTRIM, ISNULL, ISDATE, TO DATE, Decode, Substr, Instr and IIF function.

ETL Developer

Confidential

Responsibilities:

• Designed and Created data validation for Oracle data warehouse using Informatica ETL tool.
• Created data mappings to extract data from different source Databases, transform the data using ETL. Informatica Transformations then load to Oracle data warehouse.
• Preparation of Low Level Design for the mappings created.
• Prepared Unit test cases for the mappings.
• Review of Unit test cases, Integration test cases of all the assigned modules.
• Testing individual modules of the software against the Unit test cases.
• Doing Integration testing of the software against integration test cases.
• Classification and reporting the bugs to the Project Lead.
• Repeating the Individual modules and Integration testing cycles after bug fixes.