SUMMARY

• Results oriented professional with 15+ years of IT industry experience with hands on expertise in Informatica, IBM Netezza Pure Data, IBM InfoSphere DataStage, ETL, Oracle, Oracle BI Applications, Oracle BI Data Warehouse Administration (DAC), Spark, Scala, Hadoop, Python, PL/SQL, OBIEE, data warehousing tools and techniques.
• Experience throughout the Software Development Life Cycle of Federal government and corporate business applications using various technical platforms.
• Possess exceptional knowledge and skills in Data Warehousing, Business Intelligence, Data Replication and Client/Server applications.
• Excellent conceptual knowledge and hands - on experience in BI, Data warehousing, Star Schema/Snow Flake Schema, ETL, OLAP and Report delivery methodologies.
• Strong Data warehousing experience specializing inRDBMS, ETL Concepts, Strategy, Design & Architecting, Informatica Administration, Development & Testing
• Involved in the complete life cycle of quite a few Data warehouse implementations which includeSystem Architecture, Functional/Technical Design, Development - Coding and Testing(Unit Testing, System Integration Testing and User Acceptance Testing) andImplementation.
• Extensive design and development experience in ETL tools/ processes using Informatica PowerCenter tools (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Administration Console), IBM Infosphere DataStage.
• Strong Team building and mentoring skills and excellent Team leadership capability.
• Worked extensively in all stages of SDLC, from gathering requirements to testing, implementation and support, Maintenance of various Applications in Data Warehousing, client server and three-tier architecture.
• Excellent in communicating with users and business people in requirements gathering meetings to understand the need and translate their needs into functional requirements, convert these requirements into a technical design.
• Proven ability in communicating highly technical contents to non-technical people
• Extensive experience in back end programming including Database table design, Stored procedures, Triggers, Indexes, performance tuning in various databases like Oracle, MS SQL Server.
• Strong knowledge and understanding of SQL and ability to fine-tune SQL queries.
• Excellent team player with excellent communication, analytical, verbal and writing skills.

TECHNICAL SKILLS

Database: Oracle 11g/10g/9i/8i/7.0 ( SQL, PL/SQL, SQL*Plus, SQL Performance tuning, SQL Loader, Stored Procedure, Triggers), Teradata v2r6, SQL Server 2005/2000

ETL Tool: Informatica Power Center 9.5.1/9.0.1/8.1.1/7.1 (Repository Manager, Workflow Manager, Designer, Workflow Monitor), IBM InfoSphere DataStage 8.5, Oracle Data Integrator (ODI) 11g

BI Tools: Oracle BI apps, OBIEE 11g, Business Objects XI R2, Brio

Data Modeling: Erwin 4.1, Designer/2000 2.1

Configuration Management tools: CVS, Visual Source Safe, SVN, Rational ClearQuest, JIRA, TortoiseHg Mercurial 3.3.3

Programming Languages and GUI tools: Python, Scala, Spark(including SparkSQL, Spark Streaming, MLlib or GraphX), Hadoop, MapReduce, HDFS, PL/SQL, SQL, Unix Shell Scripting, Forms 6i/5.0/4.5, Reports 6i/3.0/2.5,SQL*Loader, C, COBOL

Interface Tool: WebMethods

Designing Tools: Eclipse

Connectivity Tools: TOAD, PLSQL Developer, SQL Developer, DB Saint

Hardware: Sun T200, Sun Sparc

Operating Systems: Unix, Windows NT/2000

Unix: Sun Solaris 5.10/2.8/2.6/2.5

PROFESSIONAL EXPERIENCE

Confidential

Sr. ETL Developer/ETL Architect

Responsibilities:

• Played the role of a ETL Architect/Sr. ETL Developer and was responsible for designing the ETL Strategy & Architecture of the Project.
• Conducted ETL development in the Netezza environment using standard design methodologies.
• Responsible for managing tasks and deadlines for the ETL teams.
• Worked with Data Architects in evaluating enterprise data models as per business needs
• Break up the work into task list and estimate based on simple, medium and complex methodology
• Interaction with business users and requirement gathering.
• High level & low-level ETL flow design
• Involved in detailed technical design
• Involved in conducting the review of Informatica Code, Unit Test Cases & Results with the Developers.
• Organize daily technical discussions with the ETL team .
• Involved with data warehouse initiative from development to implementation through iterative strategy development and tactical execution of objectives.
• Responsible for designing, developing and implementing ETL jobs using Informatica and Oracle
• Experience in performance tuning of Informatica mappings and sessions to improve performance of the large volume projects.
• Worked with the dba’s to create database objects.
• Developed Python scripts for converting some of the existing Informatica jobs.

Environment: IBM Netezza, Informatica PowerCenter 9.5.1, Spark, Scala, Python 3.4, Oracle 11g, OBIEE 11g, JIRA 7.2, Unix and Windows NT/2000, Mercurial 3.3.3.

Confidential

Sr. ETL Developer/ETL Architect

Responsibilities:

• Played the role of a Program Technical Lead/ETL Architect and was responsible for designing the ETL Strategy & Architecture of the Project.
• Responsible in managing tasks and deadlines for the ETL teams.
• Interaction with business users and requirement gathering.
• Roles includes not limited to Sr.Informatica Developer/Administrator, Oracle BI Data Warehouse Administrator (DAC), BI Apps Developer
• Involved with data warehouse initiative from development to implementation through iterative strategy development and tactical execution of objectives.
• Responsible for designing, developing and implementing ETL jobs using Informatica and Oracle
• Implemented complex business rules by creating Mappings, Mapplets, Sessions and Workflows using Informatica PowerCenter.
• Experience in performance tuning of Informatica mappings and sessions to improve performance of the large volume projects.
• Mapping the source and target data elements including various transformations for source system to data warehouse using Informatica’s Power Center.
• Responsible for Informatica Administration tasks including Importing/Exporting mappings, copying folders over the DEV/QA/PRD environments, managing Users, Groups, associated privileges and performing backups of the repository.
• Worked with the dba’s to create database objects.
• Involved in Unit Testing and addressing defects found in User Acceptance Testing

Environment: Informatica PowerCenter 9.0.1, Oracle Data Integrator (ODI) 11g, Oracle BI Applications 7.9.6.3(Financials,Procurement,Supply Chain), Oracle BI Data Warehouse Administration (DAC), Oracle 11g, OBIEE 11g, Unix and Windows NT/2000.

Confidential

ETL Architect/Technical Lead

Responsibilities:

• Involved with data warehouse initiative from design to implementation through iterative strategy development.
• Responsible for ETL architecture including key designs of integration standards such as loading, real time/batch and data validation with tens of millions of transactions to capture Bank Secrecy Act (BSA).
• Responsible for designing, developing and implementing ETL jobs using IBM InfoSphere DataStage, Oracle
• Responsible for creating STTM for SFS and SOR system.
• Involved in requirements gathering and source data analysis and identified business rules for data migration and for developing data warehouse and data marts.

Environment: IBM InfoSphere DataStage 8.5, Oracle 11g, Unix and Windows NT/2000.

Confidential

Sr. DW Consultant

Responsibilities:

• Worked with XML source file.
• Involved in designing the ETL process.
• Created complex mappings using Normalizer Transformation to convert fields in to multiple rows
• Extracted, Transformed and Loaded data into Data Warehouse built on oracle using Informatica mappings and complex transformations (Aggregator, Joiner, Lookup (Connected & Unconnected), Source Qualifier, Filter, Update Strategy, Normalizer, Router, and Expression).
• Mapping the source and target data elements including various transformations for source system to data warehouse using Informatica’s Power Center.
• Numerous business rules were applied to handle unwanted data, algorithm massages and aggregations at various levels of grains.
• Creation of workflows/batches, tasks/sessions and schedule jobs.
• Involved in Unit Testing / User Acceptance Testing.

Environment: Informatica PowerCenter 8.6.1, Business Objects XI R2, Teradata v2r6, Oracle 10g, Unix and Windows NT/2000.

Confidential, Fairfax, VA

Data Warehousing Consultant

Responsibilities:

• Involved in designing the ETL process.
• Extracted, Transformed and Loaded data into Data Warehouse built on oracle using Informatica mappings and complex transformations (Aggregator, Joiner, Lookup (Connected & Unconnected), Source Qualifier, Filter, Update Strategy, Normalizer, Router, and Expression).

Environment: Informatica PowerCenter 8.1, Business Objects XI R2, Oracle 10g, Unix and Windows NT/2000.