PROFESSIONAL SUMMARY:

• With overall 12 + years of experience in IT in ETL - Informatica and 8 years OBIA, OBIEE Development and Siebel Analytics I have involved myself in all phases of Software Development Life Cycle and took utmost initiatives in learning methods to enhance software development process and project management.
• Experience in design and implementation using ETL tools like Informatica 10.x, 9.x (Power Center) Designer, Repository Manager and Workflow / Server Manager.
• Experience in Design, Development and Implementation of Data Warehousing and Business Intelligence tools such as OBIEE, Siebel Analytics, Informatica and Siebel Data Warehouse Application Console (DAC).
• Experience in Data warehousing designing and Data modeling of physical/logical data, Facts and Dimensions, Star schema, analysis, implementation by using Erwin and Visio.
• Requirements gathering by interacting with the onsite and client team.
• Experience with data extraction, migrations, transformation and Loading using DTS & SSIS.
• Designed new reports and wrote technical documentation, gathered requirements, analyzed data, developed and built SSRS reports and dashboard
• Have attended Working with Hadoop & BigData Skilling training programs conducted by Cognizant Academy.
• Setup and configured a POC server using ecosystem components like Hadoop MapReduce, HDFS, HBase, Zoo Keeper, Oozie, Hive, Cassandra, Sqoop, Pig, Flume, Avro and Horton Works Talend.
• Good understanding in working with ecosystems like Hive, Pig, Sqoop, Map Reduce.
• Knowledge of Hadoop and Hive and Hive's analytical functions.
• Built Hive, pig and map Reduce scripts.
• Designed Hive tables to load data to and from external files.
• Scope document, High Level and Technical design documents based on the Business requirements.
• Built Metadata Repository at 3 layers Physical Layer (connecting Data sources & import schema), Business Model & data mapping (creating Logical tables & data source mapping) and Presentation layer level (creating presentation catalogs).
• Extensively worked on UNIX shell scripts on automation (Auto restart of servers, Disk space utilization, Informatica Server monitoring and UNIX file system maintenance and cleanup, and scripts using Informatica Command line utilities.
• Experience in Performance tuning of Informatica by Query Optimization, Pushdown optimization, Pipeline Partitioning, Memory/CPU management, and RDBMS data management.
• Developed effective working relationships with client team to understand requirements, develop tactical and strategic plans to implement technology solutions, and effectively meet client expectations.
• Credited with ramping up the Informatica (ETL) capability by training 100+ resources and involved in resolving complex ETL related issues for various project teams.
• A great team player as well as an independent contributor. Possess excellent interpersonal and communication skills, industrious and result-oriented.
• Experienced in solution feasibility study, Gap Analysis, analyzing existing / proposed systems solution and coming up with new business processes/ solutions and proposals.
• Exceptional expertise in area of DW Solution, ETL, Database and Infrastructure architecture along with good understanding of Business/ Functional /Conceptual/Technical design requirement documents, Traceability Matrix and working solution/application.

TECHNICAL SKILLS:

Big Data Ecosystems: Hadoop, MapReduce, HDFS, Zookeeper, Hive, HBase, Pig, Sqoop

ETL Tools: Informatica Power Center 9.x/8.x/7.x, Informatica TDM, Power Exchange / Power Connect, SSIS.

Databases: Oracle 11g/10g/9i, DB2, MS SQL, Netezza, Teradata V14

BI Tools: OBIEE 11.x, 10.x, Siebel Analytics 7.8.4 /7.7, Business Objects XI R2, SSRS

Operating System: IBM AIX 4.3, HP UNIX, Linux, Windows NT/2000/XP/7

Job Scheduling Tools: Control M, TWS, Crontab & Informatica Scheduler

Languages: SQL, PL/SQL, Shell Scripting, XML, C, Perl, Python

Modeling Tools: Erwin, Power Designer, MS Visio

Database frontend tools: Oracle SQL Developer, IBM DB2-QMF, TOAD

Other Tools: DTS Package, Oracle Streams, DAC.

PROFESSIONAL EXPERIENCE:

Confidential

Operating System: Windows 7 / Unix

Tools: Informatica Power Center 10.1.0, Informatica TDM, MS SQL 2012, MongoDB, DB2, Informatica B2B Data Exchange, Informatica Data Transformation.

ETL Lead / Solutions Architect

Responsibilities:

• Manage the project Scope, Schedule, Cost, Issues/ Risk, Quality and timely Delivery of the Deliverables.
• Participate in meetings with the business teams to gather requirements to enhance the existing functionality.
• Creating custom Java transformation to read and write into REST web services.
• Design and Developed Informatica Data masking projects for various mainframe DB2 applications, AS400 DB2, MS SQL based application.
• Created Endpoints for the vendor to drop files for processing.
• Informatica TDM Upgrade from 9.6.1 to 10.1
• Provide technical guidance to the team with complex issues.

Confidential

Operating System: Windows 7 / Unix

Tools: Informatica 9.5.1, Toad, DB2, Netezza, PL/SQL & Microstrategy.

ETL Lead

Responsibilities:

• Participate in meetings with the business teams to gather requirements to enhance the existing functionality.
• Creating Source-Target attribute level mapping spreadsheets.
• Design and Developed Informatica Mappings & Workflows.
• Provide technical guidance to the team when complex issues arise.

Confidential

Operating System: Windows 7 / Unix

Tools: Informatica 9.0.1, 8.6, SSIS, Toad, Oracle 11g, PL/SQL, MS SQL 2008, Qlikview & Microstrategy.

Technical Architect

Responsibilities:

• Manage the project Scope, Schedule, Cost, Issues/ Risk, Quality and timely Delivery of the Deliverables.
• Leading 10 member team (onsite / offshore team) for design, build, QA, deploy & support phase of the project works in area of DB/ETL and reports using Infomatica / Microstrategy Oracle.
• Involve in complete understanding of business requirement and gathering; analyze, clarify and resolve ambiguities and conflicts in the business requirements
• Create High level and Detail level Informatica Power Center ETL design and specifications.
• Develop Source to Target Power Center Informatica Power Center ETL mappings from Oracle, Excel/Flat files to Oracle using Informatica Power Center and Oracle Utilities
• Worked with the SSAS develpoers to develop new cubes.
• Store procedures, User defined functions, Views, T-sql scripting for complex business logic.
• SSIS package configuration, deployment, jobs schedule and package failure email functionality.
• Developed and maintained project management artifacts such as Project/Program plan, Project charter, estimations, Forecasts, resource plan, Issue / Risk log & tracking, release & deployment plan, Project financial (CPAX/ OPEX) tracking & status reports.

Confidential

Operating System: Windows 7 / Unix

Tools: Informatica 9.0.1, 8.6, Toad, Oracle 11g & PL/SQL.

Technical Architect

Responsibilities:

• Designed functional & technical ETL specifications from High Level requirements.
• Data Profiling and analysis to spot Data Quality Issues.
• Designed ETL process to feed the downstream application with the Model N data.
• Identify the bottlenecks of the existing system architecture and proposed the best suitable methodology follows with Best practices standard of ETL Design for operations prospective manner.
• Developed UNIX shell scripts to get data from external systems flat files to stage area, and to schedule various workflows to load the data into target system.
• Peer review the code developed by other team members.
• Involved in System testing and User Acceptance Testing.

Confidential

Operating System: Windows 7 / Unix

Tools: Informatica 9.0.1, 8.6, Toad, Oracle 11g & PL/SQL, MS SQL Server 2008.

Technical Architect

Responsibilities:

• Create data analysis and scope documents.
• Preparing High Level and Technical design documents based on the Business requirements.
• Gap Analysis between the existing system and the new transaction system and new data warehouse.
• Re design considerations needed to be drafted and coordinate between various client teams involved in the migration project.
• Part of the data modeling team for the new data warehouse.
• Data Profiling and analysis to spot Data Quality Issues.
• Peer review the code developed by other team members.
• Involving system testing end to end process & full support for UAT environment.

Confidential .

Operating System: Windows 7 / Unix

Tools: Informatica 9.0.1, Informatica ILM, 8.6, OBIA, OBIEE 11.1.1.6.7, DAC, Toad, Oracle 11g & Green plum Database.

Technical Architect

Responsibilities:

• Participate in meetings with the business teams to gather requirements.
• Preparing High Level and Technical design documents based on the Business requirements.
• Design and Developed Informatica Mappings & Workflows.
• Data Profiling and analysis to spot Data Quality Issues.
• Enhance the Meta model for the additional reporting requirements.
• Installed and configured PowerCenter 9.0.1 and 9.1.0 on UNIX platform.
• Performed Informatica upgrade from V8.6.1 to 9.0.1 and 9.1.0.
• Creation and maintenance of Informatica users and privileges.
• Develop best practices for standard naming conventions and coding practices to ensure consistency of data models.
• Support ETL developers by providing technical assistance, troubleshooting and alternative development solutions.
• Involving system testing end to end process & full support for UAT environment.

Confidential

Operating System: Windows 7 / Unix

Tools: Informatica 8.6, OBIEE 11.1.1.6.7, DAC, Toad & Oracle 11g.

Technical Architect

Responsibilities:

• Worked closely with business user to gather reporting requirements.
• Preparing High Level and Technical design documents based on the Business requirements.
• Enhance existing reports to meet the current business reporting needs.
• Co Ordinate between Client team and offshore.
• Peer review the enhanced code developed by other team members.
• Performance tuning of Informatica mappings.
• Involving system testing end to end process & full support for UAT environment.