SUMMARY

• Over 7 years of experience in Analysis, Design, Development, Maintenance and Testing in IT industry with experience in Decision Supports Systems - Data Warehousing and implementing ETL (Extraction Transformation, Loading) using Informatica Power Center/ Power Exchange 9.6/9.1/8.6//8.5/8.1/7.1 and Power Exchange.
• Good understanding of the full SDLC of the projects in the different models like waterfall model, agile methodologies.
• Extensively worked on Greenplum, Netezza 6.0.8, Oracle 11g/10g/9i/, DB2, SQL Server 2008/2005/ Teradata, SQL, SQL Plus, PL/SQL, DB2 SQL dialect, SQL Loader, TOAD, ERWIN, UNIX, Windows XP/2000/NT.
• Experience to Teradata utilities likeBTEQ, Fast Export, Fast Load, Multi Loadto export and load data to/from different source systems including flat files.
• Functional and Technical expertise in Decision Support Systems - Data Warehousing, ETL (Extract, Transform and Load) using Informatica developed complex mappings from varied transformation logic like unconnected /connected lookups, source qualifiers, router, filter, expression, aggregator, update strategy, complex joiners, mapplets and more in Informatica.
• Experience in implementing complex business rules by creating complex mappings/ mapplets, stored procedures and reusable transformations.
• Extensively Used Informatica Power Center Workflow manager to create workflows and worklets, to run with the logic embedded in the mappings
• Expertise in trouble shooting and implementing performance tuning at various levels such as source, target, mapping, session and system in ETL Process.
• Experience in partitioning of data, session partitions and using parameter files, mapping parameters and mapping variable in Informatica
• Experience with different source and target systems like Oracle, SQL Server, DB2, Siebel, Sybase, CSV/Flat Files, and XML flat files etc.
• Proficient in coding Oracle and SQL Server stored procedures, triggers, cursors, constraints, index’s, views, inline views and materialized views
• Created batch files to do the FTP and SFTP to the vendor websites to get the source files and integrated the process in the Informatica workflows.
• Experience in UNIX shell scripting, job scheduling, Informatica pre/post session operations and communicating with server using pmcmd command.
• Hands-on experience using Informatica Data Validation Option (DVO) tool for testing.
• Good understanding working with the Metadata Manager (MDM) tool.
• Experience working with the Informatica Data Explorer (IDE)/ Informatica data Quality (IDQ) tool for column level profiling, Structural profilingof the database tables etc.
• Good Knowledge in creating the SSIS packages for loading the data from different source systems and loading to the database tables.
• Extensive experience in implementation of data cleanup procedures, transformations, scripts, stored procedures and execution of test plans for loading the data successfully into the targets.
• Experience with TOAD to analyze the tables, create indexes and import data from different schemas.
• Scheduled jobs and automated the workload using Autosys and Control-M schedulers.
• Extensive experience in code deployments to QA, UAT and pre PROD environments using XML migrations and deployment groups.
• Extensively worked on fixing the issues with QA team
• Experience in writing test plans, test cases, unit testing, system testing, integration testing and functional testing and user acceptance testing (UAT).
• Excellent communication and interpersonal skills. Ability to work effectively while working as a team member and as an individual.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.6/9.5./8.6/8.5/8.1/7.1.2/7.1.1.

Data bases: Greenplum, Netezza, Oracle 11g/10g/9i/8i, DB2, SQL Server 2008/05/00, Teradata, Ms-Access

Data Modeling: Erwin 7.x Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Schema Modeling, Fact and Dimensions Tables, Physical and Logical Data Modeling, Oracle Designer

Languages: C, C++, Java, SQL, PL/SQL, T-SQL, DB2 SQL dialect, HTML

Scripting Languages: UNIX Shell Scripting, Java Scripting

Other Tools: TOAD, SQL*Loader, SQL *Plus, BTEQ, Fload, Mload, Fast Export, WinSCP, Control-M, Autosys, MS Visio, Rational Clear quest, Rational Clear case, Mercury quality center, Harvest, Star team

Operating Systems: Windows 2000/XP/NT, UNIX, Linux, Sun Solaris 9/8/7/2.6/2.5, MS-DOS.

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

Lead Business Intelligence Developer

Responsibilities:

• Leadteam of 5 Developers in getting work done based on requirements.
• Leadand guidedInformaticabased ETL architecture.
• Assessed the requirements for completeness and accuracy.
• Developed solutions and provided hands on guidance to other team members.
• Designed and set standards for preparing mapping documents, test case documents, migration documents.
• Identified, recommended and implemented the ETL process and architecture improvements.
• Modify and optimize current mappings for more efficient data loads.
• Conducted impact assessment and determined the size of effort based on the requirements.
• Resolved difficult designs and development issues.
• Extensively worked withInformaticaBatch Framework which callsInformaticaand loads using Shell Scripts.
• Maintained Type 1/Type II Dimensions using Lookup Transformations and Update Strategy Transformations.
• Extensive use of postgres SQL and PL/SQL in developing complex Stored Procedures and Functionsin Greenplum.
• Created functions and automated the load in Green plum for creating views and tables for reports.
• Scheduled the Greenplum functions using the Cron job scheduler in the database.
• Developed a function to automate the create and update tables in Greenplum
• Coordination with Admin team for deploying code in all upper environments.
• Worked extensively with reporting teams and loaded the data into the Greenplum reporting tables as per the business need.
• Created mappings for various sources like Oracle, SQL server, flat files and Oracle Database to load and integrate data to warehouse.
• Developed various mappings, Reusable transformations and validated the ETL logic coded into mappings.
• Involved in Optimizing the Performance by eliminating Target, Source, Mapping, and Session bottlenecks.

Environment: Informatica 9.5.1, Greenplum, pgAdmin III 1.16.1,SQL Server, ERWIN 9.5.02, Teradata, flat files, XML files.

Confidential, Glen Allen, VA

Sr. Informatica/Netezza Developer

Responsibilities:

• Lead developer and interacted with Business Analyst to understand the business requirements &Involved in analyzing requirements to refine transformations in building the PDW.
• Provided technical guidance for re-engineering functions of Oracle warehouse operations into Netezza
• Worked with the data modelers and helped them in creating Erwin models, doing reverse engineering the models.
• Collaborated with architects to align the ETL design to the business case and the overall solution.
• Developing the UNIX shell scripts for master workflows.
• Design and develop new enhanced functionality for existing applications.
• Created the ETL source to target mapping documents working with the business Analysts.
• Created design standards of the ETL code by applying SCD logics.
• Created Parameter files, mapplets, and worklets for reusability in the code.
• Reviewed and maintained the ETL coding standards.
• Worked on the Persistent cache options where ever required to re-use the cache for larger table lookups.
• Experienced in converting the tables from Oracle to Netezza and used the appropriate distribution keys for better SPU performance in Netezza.
• Created Oracle stored procedures for capturing the ETL run statistics for the daily delta loads.
• Performance tuned the database stored procedures and changed the updates to deletes and inserts to reduce the costly operations on the Netezza database.
• Performance tuned the Informatica ETL code and used the Netezza bulk reader and writer for optimal performance.
• Used performance tuning at the session level, mapping level, and at the database level.
• Used the ‘Organize On’ Option in the Netezza tables for frequently joined tables.
• Creating Netezza DB Objects using Best practices of Netezza in order to avoid data skews on the Netezza Objects.
• Performance tuning of Netezza SQL scripts.
• Created NZLoad Scripts to load the Flat Files into Netezza Staging tables.
• Created and executed the unit test plans based on system and validation requirements.
• Worked on the migration of the code from DEV, QA, UAT, PROD using XML migrations.
• Effectively communicate project expectations to team members in a timely and clear fashion

Environment: Informatica 9.1/9.6.1 Netezza 6.0.8, Oracle 11g, Cognos, ERWIN 9.5.02, Toad 12.1.0, Aginity Workbench 4.3, flat files, XML files.

Confidential, Madison, WI

Informatica Lead Developer

Responsibilities:

• Involved in analyzing the requirements and preparing detailed ETL specification from business requirement.
• Analyzed the existing system and prepared and presented impact analysis.
• Experience in fast paced working environments like such as agile model.
• Created detailed source and target mapping specifications document.
• Developed and maintained the ETL standards document for use in the Organization.
• Worked independently on multiple projects, played as a technical lead in projects and delivered the project within the timelines.
• Assisted the QA team in learning the data validation (DVO) tool for testing the data end to end.
• Experience on the Metadata Manager (MDM) tool in indentifying the dependencies of the objects in the Informatica repository.
• Experience in writing different ETL methods for Change Data Capture (CDC) using incremental loads and using MD5 checksum methods.
• Working on developing the CTAS scripts for retaining data in the tables and change the structure of the tables in Netezza 6.0.8
• Experienced in using Aginity to write SQL queries, use Netezza built in functions, distributing keys, creating external tables etc.
• Experience in grooming the tables/ generating statistics for better performance on a scheduled basis in Netezza database and creating views/materialized views on the tables.
• Developed the mappings to perform the Data quality checks in the Data warehouse.
• Generated queries using SQL to check for consistency of the data in the tables and to update the tables as per the requirements
• Worked on writing stored procedures in Netezza to maintain log details and batch processing for the ETL code.
• Created batch files to do the FTP and SFTP and get the source files from the vendor websites and integrated the process in the Informatica workflows.
• Good knowledge working with XML source flat files.
• Provided on call production support on rotation basis within the team.
• Created re- usable Mapplets, worklets and used them in different mappings to streamline the process.
• Experience in using debugger to debug the mapping and check the data flow in the mapping.
• Implemented Slowly Changing Dimensions - Type I & II in different mappings as per the requirements.
• Developed ETL code for transactional facts and aggregated facts.
• Assisted ETL developers on the ETL errors and resolve problems to reconcile extracted data to the source system.
• Developed parameter files and used parameter variables to support SQL override.
• Performed tuning of Informatica sessions by implementing database partitioning, increasing block size, data cache size, target based commit interval and SQL overrides and tuned the Sources, Targets, Transformations and Mapping to remove bottlenecks for better performance. .
• Created batch scripts for automation of ETL processes.
• Created the unit test plan templates and documents for every tables developed for EDW and tested them before moving to other environments.
• Performed code reviews with peers and created unit test plans document.
• Involved in all phases of software development like code development, unit testing SQL Assistants, integration testing, code promotion, and preparation of checklists at each phase, Maintaining Issue Logger System etc.
• Managed the post production issues and delivered all assignments / projects within specified time lines.
• Created weekly project status report for senior management.
• Worked closely with reporting team and helped them whenever they had any ETL issues.

Environment: Informatica 8.6.1/9.1, Netezza 6.0.8, Oracle 10g,SQL Server 2008, SAS, Business objects, Qlikview, ERWIN, Aginity Workbench, Informatica Data Validation Option(DVO), flat files, XML files, IDE,SQL plus, SQL/PLSQL,Control-M.

Confidential, Tacoma, WA

Sr. Informatica Developer

Responsibilities:

• Analyzed business documents and created software engineering requirements specification.
• Assured that all enterprise procedures are followed such as system testing, change management, project prioritization, promotion to production, time entry, etc
• Used Erwin for logical and database modeling and helped DBA generate DDL.
• Created and walked the team through mapping specification documents.
• Developed Informatica mappings, re-usable transformations, re-usable mappings and Mapplets for data load to data warehouse.
• Refreshed the data by using fast export and fast load utilities.
• Creating and modifying MULTI LOADS for Informatica using UNIX and Loading data into LDW.
• Developed slowly changing dimension techniques to keep track of historical data.
• Worked on the Microsoft SSIS tool to load the data from CSV files to a SQL server tables.
• Created SSIS packages to load the history data into the database tables.
• Created UNIX shell scripts for scheduling the workflow using pmcmd utility.
• Developed mapping parameters and variables to support SQL override.
• Setting up Batches and sessions to schedule the loads at required frequency using Power Center Workflow manager.
• Implemented recovery solutions by writing stored procedures using SQL to undo data quality issues in the tables.
• Created sessions, database connections and batches using Informatica Workflow Manager.
• Created mappings/workflows to extract data from Oracle Server and Flat File sources and load Created complex SQL, PL/SQL, stored procedures, functions.
• Involved in identifying the bugs in existing mappings by analyzing the data flow, evaluating transformations and fixing bugs so that they conform to the business needs.
• Actively participated in user acceptance and sign-off process. Worked effectively with assigned project managers.
• Participated in the review and maintenance of data security standards to protect information assets.
• Provided reliable, timely support of integration, performance and user acceptance testing processes.

Environment: Informatica Power Center 8.5, SQLServer 2005,Teradata, Teradata Fast load, BTEQ, Microsoft Visio, Erwin 7.0, TOAD 8.6.1, Windows XP.

Confidential

SQL Developer/Web Developer

Responsibilities:

• Performed the Creation, manipulation and supporting the SQL Server databases.
• Involved in Creation of tables, indexes, sequences, constraints, triggers and procedures.
• Created stored procedures and triggers which were used to implement business rules.
• Helped in integration of the front end with the SQL Server backend.
• Written triggers, stored procedures and manipulated the data using DDL and DML functions.
• Migrated the data (Import & Export of data) from one server to other servers using tools like Data Transformation Services (DTS)
• Written complex T-SQL statements (Queries) for retrieval of data and involved in performance tuning of TSQL queries
• According to the business requirements made the documentation of the performed tasks.
• Backing up, restoring system & other databases as per requirements, and also scheduled those backups.
• Managing the security of the servers, creating the new logins and users, changing the roles of the users.