SUMMARY

• Having over 9 years of experience in implementing Business Intelligence solutions & Data Warehousing built on TEMPprincipally, INFORMATICA, SAP Business Objects suite of products, Oracle, SQL Server.
• Experience in evaluating teh technical feasibility and proposing teh best suitable ETL and BI tools.
• ETL Specialist, noledge of complete development life cycle of Data Warehousing.
• Involved in Designing databases and preparing technical design documents.
• Extensively worked on Oracle PL/SQL Stored Procedures, Functions, Indexes, Triggers and Views.
• Has good understanding of teh basic DBA activities.
• Extensively used ETL methodology for supporting Data Extraction, transformations and loading processing, using Informatica.
• Proficient wif reporting tools like SAP Business Objects Reports.
• Models usingStar schema and Snowflake schematechniques used in and multidimensional modeling.
• Experience in designing end to end ETL solution for teh client.
• Efficient in performance tuning complex T - SQL queries, stored procedures. Good experience in reading and understanding execution plans of T-SQL queries and fine tuning queries.
• Extensive experience in implementing large Data Warehousing solutions using Informatica.
• Experience in working at On-shore and Off-Shore in onshore-offshore model.
• Experience in logical, physical, and dimensional data modeling, data mapping, and data normalization, well versein ERWIN & Power Designer.
• Good Expose on usage of different RDBMS like MS-SQL Server, Oracle and MYSQL.
• Knowledge in Data Modeling using ERWin for OLTP and OLAP Systems.
• Proficient in Dimensional modeling (Kimball and Inmon) and Relational database management systems.
• Good understanding on Logical, Physical database design and Normalization.
• Proficient on Informatica Mappings development and usage of different transformations to meet mapping logic.
• Knowledge on SSIS & SSRS usage and development.
• Experience on leading, mentoring teams and strictly adhering to SDLC /Agile processes.
• Ability to adapt to new skills and technologies and dedicated to maintaining high quality standards.
• Possess strong Analytical, Problem Solving skills and flexible to work wif new environments.
• Excellent team Player wif very good communication and interpersonal skills.
• Techno savvy & has appreciable thirst for noledge.

TECHNICAL SKILLS

ETL Tools: Informatica 8.x and 9.x, MS-SQL Server Integration Services 2008R2/2012Database Oracle 9i/10g, MS-SQL Server 2008/2012, DB2 & Netezza

Data Modeling Tools: Erwin, Power Designer

Reporting Tools: SAP Business Objects XI R2/R3, XI 4.1

Operating Systems: Windows 2000/XP/7, Windows Server 2003/2008, Linux, UNIX

Scheduling Tools: CRONTAB, AUTOSYS, TIVOLI

Project/Process Management: Version One, Tortoise SVN, TFS

Business Tools: MS Word, Excel, Power Point, Outlook

Programming: SQL, PL/SQL

Internet Tools: FTP, TCP/IP, SFTP, WinSCP

PROFESSIONAL EXPERIENCE

Confidential, Greensboro, NC

Lead ETL Developer

Responsibilities:

• Participating in teh discussions to validate teh business requirements, infrastructure and software requirements
• Analyzed teh requirements and created Extraction Transformation and Loading strategies and defined source to target mapping rules.
• Created ETL project plan, periodic deliverables, ETL and DB object dependencies matrix
• Designed Extraction Transformation and Load process flow diagram using MS-Visio
• Created overall project load process flow, customized teh auditing and logging and maintained teh project artifacts in Share Point
• Worked wif Business Analysts to understand, analyze teh systems and priorities
• Closely worked wif Data Modular to understand and resolve teh business requirement deviations
• Discussed teh possibilities and provided teh suggestions to ease teh reporting requirements
• Worked wif reporting team to make them understand teh data and teh data model
• Created and presented teh project status on daily/weekly/monthly to teh management
• Involved in design of data model.
• Responsible for work distribution, worked closely wif teh team members and provided technical solutions to insuring high levels of quality and flexibility.
• Created audit summary describing statistics of load process, new records, error records, skipped records etc.
• Responsible for code review of teh team members and delivering teh scalable and quality code.
• Prepared unit test case template and scripts for each possible scenario & documented teh results.
• Produced development status reports and coordinating wif teh Project Manager in TEMPeffective planning and scheduling of teh deliverables.
• Prepared teh design, release and deployment artifacts
• Worked closely wif different teams in performing teh system integration and testing.

Environment: Informatica 9x, Oracle 9i, 10,11g, Business Objects 4.1/5.1/6.x/XI R2/R3, XI 4.1, SQL Servers 2000, Erwin r7.1/7.2, VersionOne Power Designer

Confidential, NYC

Sr. ETL Developer

Responsibilities:

• Responsible for leading teh design, documentation and deployment of an enterprise data model and supporting component data stores
• Worked wif an Agile, Scrum methodology to ensure delivery of high quality work wif every two week Sprint
• Understanding, analyzing and reviewing Mainframe mapping sheets and updating wif Diablo related mappings, tables and transformation logic.
• Created re-usable template to minimize teh development effort
• Created re-usable utility to compare teh data between teh new & legacy system to determine teh 98% bench mark for all teh fields.
• Analyzing source systems and creating SQL scripts to extract teh data for teh related mapping extracts to generate teh fixed width flat files.
• Monitored data warehouse load procedures to ensured information to accurate.
• Worked on teh summary level dashboards wif in-built drill down capabilities for slicing and dicing teh data.
• Review of Diablo extracts, naming standards and test cases.
• Data quality testing between teh diablo extract and Mainframe extract, preparing teh discrepancy list.
• Interacting wif client for resolving issues occurred for extracts.
• Review of ETL Mappings, Naming standards, Test cases.
• System Testing and Trouble shooting

Environment: Informatica 8x, Oracle 9i, 10,11g, Business Objects 4.1/5.1/6.x/XI R2/R3, XI 4.1, SQL Servers 2000, Erwin r7.1/7.2, VersionOne

Confidential, NYC

Sr. ETL Developer

Responsibilities:

• Extraction Transformation and Loading (ETL) process by pulling large volume of data from various data sources using Informatica.
• Developed reports using Business Objects. Used WEBI reports.
• Worked wif an Agile, Scrum methodology to ensure delivery of high quality work wif every two week Sprint
• Writing queries to generate reports for analysis of data using Business Objects.
• Developed, modified, and optimized complex queries and stored procedures to data retrieval and modification.
• Involved in teh regression testing before migrating teh code from UAT to Production.
• Optimized teh query performance wif modification in SQL queries, removing unnecessary columns, eliminating redundant and inconsistent data, normalizing database, establishing necessary joins, creating useful clustered index and non-clustered indexes.

Environment: Informatica 8.6, Oracle 9i, 10,11g, Erwin r7.1/7.2, VersionOne

Confidential, NJ

ETL Developer

Responsibilities:

• Worked wif teh Business Intelligence team members to design, develop, implement and manage data and data flow for business intelligence applications while insuring high levels of quality and flexibility.
• Analyzing, understanding, creating, distributing, communicating and coordinating wif on-shore and off-shore teams.
• Define teh ETL flow used at a project level.
• Developed Infomatica Mappings that populate data into teh SQL Server 2012 tables.
• Created send mail task on error and on completed and send email notification wif error message as attachment.
• Scheduled/monitored ETL job using SQL server agent in Dev and Prod and responsible to troubleshoot if it fails.
• Designed complex ETL strategies to pull data from different sources, like SQL server, flat files and load it to teh destination database after using multiple transformations.
• Generated Import Summary describing statistics of successful import, new records, error records, skipped records etc.
• Worked wif teh Business Analysis and/or Product Management staff to help refine their requirements and deliver results
• Determining teh optimal approaches for obtaining data from diverse source system platforms and moving it to teh BI.
• Reviewing and involving customer live fulfillment requests execution and delivery.
• Establishing and enforcing Technical & Quality standards for deliverables of teh projects.
• Mentoring project ETL specialists on data acquisition techniques, decision rules and how to apply them

Environment: Oracle 7.3, 8i, 9i, 10,11g, Business Objects 4.1/5.1/6.x/XI R2/R3, XI 4.1, Informatica, Erwin r7.1/7.2

Confidential

Software Engineer

Responsibilities:

• Involved in writing test cases and execution of test cases
• Responsible for Functionality and Regression Testing
• Responsible for analyzing teh executed results and reporting results through bug reporting tool like Bugzilla
• Worked wif database team on data extraction, transformation and load process

Environment: Informatica, Oracle and SQL Server 2000/2005

Confidential

Software Engineer

Responsibilities:

• Used Informatica Source Analyzer, Mapping Designer and Transformation Developer for Extraction, Transformation and Loading.
• Extensively used Informatica Power center and created mappings using transformations to flag teh record using update strategy for populating teh desired slowly changing dimension tables.
• Creating and monitoring sessions using teh workflow manager.
• Mappings were designed to teh utmost performance by optimizing expressions in expression editor of transformation, filtering source data at teh source qualifier, and applying Transformation logic.
• Developed mappings using various transformations like lookup, Router, Filter, Joiner, aggregate transformation and expression.
• Preparation of Low Level Design for teh mappings created.
• Prepared Unit test cases.

Environment: Informatica, Oracle and SQL Server 2000/2005