PROFESSIONAL SUMMARY:

• Around 13 years of extensive experience in Information Technology with special emphasis on design, development of Database/Data Warehousing.
• 7+ years of ETL and data integration experience in developing ETL mappings and scripts using Informatica PowerCenter 9.5/9.1/8.1.1/7.1/6.2/5.1 using Designer (Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer), Repository Manager, Workflow Manager & Workflow Monitor.
• 7+ Years of DataWareHousing experience using Informatica Power Center 9.5/9.1/8.1.1/7.1.3/7.1.2/7.0/6.2 Warehouse Designer, ETL, Data mart, OLAP, OLTP, Star Schema, Snowflake Schema, relational database and logical modeling.
• Experienced in different stages of the software development life cycle (SDLC) such as requirement gathering, analysis, design, coding, testing and maintenance of systems application software.
• Extensive database experience using Teradata, Oracle, SQL, PL/SQL, Confidential - SQL, SQL*Plus.
• Extensively used Informatica in development, documentation, implementation and enhancement of ETL strategies.
• Expertise includes Data Profiling, Data Analysis, Data Migration, Data Modeling, and Data Cleansing.
• Excellent knowledge in performance tuning including identifying and eliminating performance bottlenecks of targets, sources, mappings and sessions.
• Experienced in integration of heterogeneous data sources such as Oracle, DB2, Teradata, Excel files, Access files, Flat files and XML files.
• Managing Backups, exports and imports, Loading flat file data with SQL*Loader, tuning SQL queries etc using several Oracle tools and packages.
• Strong work experience in Unix Environment writing shell scripts to automate Data Load Process to target Data ware house.

SOFTWARE:

Programming Languages: SQL, PL/SQL, Shell scripting, Python

Development Tools: PL/pgSQL, TOAD, SQL Developer, PL/SQL Developer, Informatica 7/8/9/10, Informatica BDM, Snowflake, Cassandra

RDBMS: Oracle 8i, 9i, 10g, SQL Server, Exadata

ERP: Oracle Apps 11i

Front End: Forms 5.0 and 6i, Reports 2.5 and 6i and VBA

Web Technologies: Java Script, XML, XSL

Operating Systems: MS-DOS, Windows 95/98/NT/XP/Vista, Linux, UNIX.

Testing: Manual, Test Director,Quality Center, Clear Quest

Other Tools: SQL*Loader, Erwin, Power Designer, MS Visio.

Cloud Technology: AWS, S3, EMR, EC2, Sqoop, Presto, Snowflake, Hadoop, HDFS, Hive

PROFESSIONAL EXPERIENCE:

Confidential, Boston, MA

Sr. Oracle Developer

Responsibilities:

• Involved in Requirement gathering and Business Analysis.
• Analyzed the functional specs provided by the data architect and created technical specs documents.
• Involved in POC research and design for Cloud migration project.
• Interacted with Business users and created design documents.
• Used PL/SQL collections (Nested Tables and Varray) in complex backend packages.
• Wrote Database triggers for audit and to implement complex business logic.
• Was involved in writing complex SQL, joining multiple tables and testing the queries.
• Performance Tuning of complex SQL queries using Explain Plan to improve the performance of the application.
• Used PIVOT, UNPIVOT, LISTAGG and many functions in Oracle 11G to transform complex source data as per requirement.
• Used Bulk Collect, Pipleline, Materialized view to improve performance of the packages
• Used Autonomous Transaction, Nested Table, Varray, Bulk Bind, Referential Cursor in Packages
• Built reporting against Single, Multiple Tables, Views, Materialized Views and Complex Custom SQL.
• Created PL/SQL Scripts to extract the data from the operational database into simple fla Confidential text files using UTL FILE package.
• Coded UNIX shell scripts to call SQL scripts and to manipulate the returned data.
• Developed test plan documents for all back end database modules
• Involved in POC projects to test the best viable solution to move the on prem system over to AWS S3
• Used Sqoop to migrate data from on-prem Oracle system to AWS S3.
• Created partition loads on AWS S3 using Hive tables.
• Was involved in loading data using Snowflake
• Tested performance of business users queries using Presto and Snowflake
• Developed an Oracle framework that helps in auto generation of Unit test packages using Oracle PL/SQL.
• Plan production deployment activities and coordinate with various teams like DBAs, Unix etc.
• Scheduled pl/sql jobs using AutoSys
• Created Autosys jil files to setup insert job, set start time, days of week runs, max run alarm
• Set job run dependencies in Autosys jil file using success, run window and date conditions condition

Environment: Oracle 11g/12c, PL/SQL, PySpark, Spark, Hadoop, AWS, RDS, S3, Sqoop, Informatica BDM, Snowflake, Hive, Presto, Hadoop, UNIX, Linux, MySQL, SQL Developer, Toad.

Confidential, Marlborough, MA

Sr. Software Developer

Responsibilities:

• Worked with business analysts to gather business requirements and implementing the same into a functional data warehouse design.
• Involved in creating Logical and Physical design of data models using Visio.
• Actively involved in requirements gathering and complete life cycle of the project.
• Maintain SVN repository, deploy code base to SIT, QA, UAT, dry-run environments as requested.
• Create new tables, views, materialized views, Packages, Stored Procedures and functions per the requirements
• Built reporting against Single, Multiple Tables, Views, Materialized Views and Complex Custom SQL.
• Developed comprehensive test plans, scripts and cases and perform unit and comprehensive testing with system developers to ensure overall functionality and technical quality of deliverables.
• Ability to trouble shoot technical issues and problems, monitor progress against plan, and communicate status to Leads.
• Created tables, Correlated sub queries, Nested Queries, Views for Business Application Development.
• Developed back end interfaces using PL/SQL Packages, Stored Procedures, Collections.
• Wrote dynamic SQL queries in different procedures and packages
• Involved in optimizing database performance by analyzing database objects, creating indexes, creating materialized views etc.
• Provide development, CUT, and SIT estimates to project services team.
• Migration from Oracle 10g to Oracle 11g..
• Used DBMS SCHEDULER to schedule jobs in non prod environment

Environment: Informatica 9.1/9.6, IDQ, UNIX, Oracle, SQL Developer, Toad.

Confidential, Westlake, TX

Sr. Oracle Developer

Responsibilities:

• Involved in Requirement gathering and Business Analysis.
• Analyzed the functional specs provided by the data architect and created technical specs documents for the mappings.
• Was actively involved in interacting with other teams to resolving Sev2 and Sev 3 production issues.
• Worked with Admin on Grid configuration and HA, during Informatica upgrade, to recover and restart the workflow on different nodes and monitor the first runs in the new environment.
• Managing of database objects like Tables, views, indexes..
• Wrote PL/SQL Procedures, Functions and Packages for Insert, Update and Delete transactions and optimized for maximum performance.
• Created TRIGGERS to Audit the changes to data in main Tables.
• Created Cursors and Ref cursors as a part of the procedure to retrieve the selected data and present it to the Front-End Team.
• Extensively used TOAD for the entire project activities.
• Involved in creating the indexes, constraints, public synonyms, DB links, granting roles etc.
• Created procedures and functions by making use of utl file to read and write data to the Database.
• Created views for generating reports and restricting data access to different users.
• Worked on materialized views with complete, force refreshes to improve the Performance of the application by making local copies of remote Tables.
• Performance Tuning of complex SQL queries using Explain Plan to improve the performance of the application..
• Developed PL/SQL Stored Procedures, Functions, Cursors, Views, Triggers, Packages and SQL queries using join conditions.
• Was involved in writing complex SQL, joining multiple tables and performance tuning and testing the queries.
• Worked with various teams to perform end to end integration and system testing.
• Performed Unit testing, during the mapping phase to ensure proper and efficient implementation of the transformations.
• Was involved in new resources from Ireland and India
• Scheduled jobs using AutoSys

Environment: Informatica Power Center 8.6.1, Informatica 9.1/9.6, UNIX, Linux, DB2, Oracle, Exadata, SQL Developer, Visio, Surveyor, Toad.

Confidential, Dallas, TX

Sr. Oracle Developer

Responsibilities:

• Responsible for the Business Analysis and Requirements gathering, create a road map for the Data warehouse designing.
• Translated user requirements into system solutions.
• Involved in Data Modeling sessions using Erwin.
• Involved in Data Analysis of the OLTP system to identify the sources for extraction of the data.
• Prepared the Technical and Functional Specification Documents.
• Prepared the Tech Design Document to some extent gathering the requirements from the clients.
• Responsible for data mapping and creating Run-Books from legacy system to oracle.
• Extensive experience in working with different FTP clients such as IpSwitch, winSCP for extracting data from sources to own destination.
• Created synonyms and make sure that users have executable permissions on all objects.
• Performed re-org for several dimension and fact tables for space release management in data warehouse.
• Extensively used cursors, sequences and indexes in the procedures.
• Created PL/SQL based ETL process to transfer data from legacy sources to staging area and from staging area to data warehouse.
• Responsible for monthly ETL in SQL server which are used by the users for potential tableau reporting.
• Created stored procedures for daily database space monitoring.
• Wrote dynamic SQL queries in different procedures and packages and function.
• Involved in Unit testing, User Acceptance Testing to check whether the data is loading into target, which was extracted from different source systems according to the user requirements.
• Jobs were scheduled through Control M
• Maintaining issue log of the issues during the UAT phase for future .
• Actively involved in the production support and also transferred knowledge to the other team members.

Environment: Informatica Power Center 8.6.1, UNIX, DB2, Oracle, Visio, Surveyor, Toad.

Confidential, Dallas, TX

Sr. DW Informatica Developer

Responsibilities:

• Involved in Requirement gathering and Business Analysis.
• Analyzed the functional specs provided by the data architect and created technical specs documents for all the mappings.
• Designed and developed Informatica Mappings to load data from Source systems to Data Mart.
• Involved in research and design of the business.
• Interacted with users to design the architecture of some mappings and developed them.
• Extensively used Power Center to design multiple mappings with embedded business logic.
• Worked extensively on transformations such as Lookup, Aggregator, Expression, Joiner, Filter, Rank, Update Strategy, and Sequence Generator and performed performance tuning of ETL process.
• Created various tasks like Command, decision, email, event wait..etc
• Developed re-usable transformations and mapplets extensively to simplify development and maintenance.
• Implemented performance tuning techniques by identifying and resolving the bottlenecks in source, target, transformations, mappings and sessions to improve performance Understanding the Functional Requirements.
• Created various mapping and did performance tuning in Informatica.
• Used Workflow Manager for creating, validating, testing and running sequential and concurrent batches and sessions and scheduling them to run Confidential specified time.
• Implemented exception handling/error handling and Restart-Recovery logic to subject area wise loads.
• Developed PL/SQL Stored Procedures, Functions, Cursors, Triggers, Packages and SQL queries using join conditions
• Performed Unit testing during the mapping phase to ensure proper and efficient implementation of the transformations.
• Involved in fixing invalid mappings as well as remove logical errors using the Informatica Debugger.

Environment: Informatica Power Center 8.6.1, UNIX, DB2, Oracle, Visio, Surveyor, Toad.

Confidential, Buffalo, NY

DW Informatica Developer

Responsibilities:

• Actively interacted with Business Users/Business Owners to get their Business views in developing and modifying Applications and Reports accordingly
• Interacted with Product Manager, and Business Analysts to understand and document the requirements and translate the requirements to technical specifications.
• Involved in designing mapping involving interaction with legacy and phased systems.
• Was involved in the performance tuning of the queries for optimal time frame.
• Was involved in preparing ETL design documents and designing and documenting the ETL process.
• Conducted Data profiling prior to extraction and during building mappings to assess data quality.
• Wrote Pre and post session UNIX Shell scripts for extracting data from files, remove duplicates and sorting in the database to optimize performance.
• Improved performance by creating materialized views.
• Created mappings for Type2/Slowly Changing Dimensions for updating and inserting of records and in turn maintaining history.
• Worked on XML, XSD while creating mappings.
• Created mapping using XML Target files, Performed modification on existing mapping.
• Wrote specific Mappings for populating dimension tables and fact tables
• Performed Unit testing during the mapping phase to ensure proper and efficient implementation of the transformations.
• Created various tasks like Command, decision, email, event wait..etc
• Involved in fixing invalid mappings as well as remove logical errors using the Informatica Debugger.
• Worked on Tidal Scheduler, to schedule Informatica workflows.
• Wrote Unit Test Cases to Validate the mappings
• Develop logical and physical data models that capture current state/future state data elements and data flows using Visio
• Involved in Preparing Unit test cases and testing BAU ETL process.

Environment: Informatica Power Center 8.1.1, UNIX, DB2, Oracle, Reflection, Visio, Surveyor, Toad, UNIX.

Confidential, Alpharetta, GA

DW Oracle Developer

Responsibilities:

• Involved in Requirement gathering and Business Analysis.
• Analyzed the functional specs provided by the data architect and created technical specs documents for all the mappings.
• Develop logical and physical data models that capture current state/future state data elements and data flows using Erwin.
• Converted the data mart from Logical design to Physical design, defined data types, Constraints, Indexes, generated Schema in the Database, created Automated scripts, defined storage parameters for the objects in the Database.
• Defined various facts and Dimensions in the data mart including Fact less Facts, Aggregate and Summary facts.
• Reviewed source systems and proposed data acquisition strategy.
• Designed and Customized data models for Data Mart supporting data from multiple sources on real time.
• Developed mappings using XML, fixed and delimited Source files and loading into a flat file.
• Creation of Transformations like Lookup, Joiner, Rank and Source Qualifier Transformations in Informatica Designer.
• Created Mapplet and used them in different Mappings.
• Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.
• Performance tuning of the Informatica mappings using various components like Parameter files, Variables and Dynamic Cache.
• Worked on Autosys to schedule Informatica workflows.
• Designed and developed Oracle PL/SQL scripts for Data Import/Export.
• Created various UNIX Shell Scripts for scheduling various data cleansing scripts and loading process. Maintained the batch processes using Unix Shell Scripts.
• Managed Change control implementation and coordinating daily, monthly releases and reruns
• Provided production support for Business Users and documented problems and solutions for running the workflow

Environment: Informatica 8.1.1, Oracle, Shell Scripts, SSIS, SQL Assistant, UNIX (Solaris).