SUMMARY:

• Over Eight years in Information Technology with experience in Data Warehousing teamed with Business Requirements Analysis, Application design, Data Modeling, Development, Testing and Documentation.
• Eight years of strong Data Warehousing experience using Informatica Power Center (Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Transformation developer), Informatica Power Mart, Power Connect, Power Exchange, Data Quality(IDQ), Master Data Services, OLAP, OLTP.
• Proficient in Data Warehousing Concepts like Ralph Kimball and Bill Inmon Methodologies and Seven Plus years of Dimensional Data Modeling experience using Star Schema/Snowflake modeling, FACT & Dimensions tables, Physical & logical data modeling using ERWIN 4.5/4.0/3.x and Oracle Designer.
• Extensive experience in ETL processes in extracting data from operational and legacy systems to data warehouse using Informatica. Understands complex mappings, transformation rules, data conversion and efficient in performance tuning of sources, mappings, targets and sessions. Extensively used various active and passive transformations like Filter, Router, Expression Transformation, Source Qualifier, Joiner, Web services Consumer, Update Strategy, Rank, Normalizer, Sorter, Aggregator and Look Up.
• Experienced in estimation, planning, Risk Management, finalization of technical / functional specifications, communication management and quality management of an application. Sound knowledge in tuning Informatica mappings and identifying bottlenecks and resolving the issues to improve the performance.
• Seven Plus years of experience using Oracle 10G/ 11G, Teradata, MS SQL Server, DB2, Oracle Report Writer, M - Load, TPUMP, BTEQ, Fast Load, Erwin 4.x/3.x, XML, XSD, SQL, PL/SQL, SQL Navigator and Developer, HPSM, TOAD, Tidal, Control M, Active Batch, UNIX Shell Scripting.
• Excellent Client Interaction, Communication and Presentation Skills.

TECHNICAL SKILLS:

ETL: Informatica Power Center 9.5,9.1,8.6.1/8.1 (Repository Manager, Designer, Server manager, Work Flow Monitor, Work Flow Manager). Informatica Power Exchange, Informatica Data Quality 9.1, DataStage 8.1, SSIS 2008 R2.

BI & Reporting: MicroStrategy 10.1

Data Modeling: Physical Modeling, Logical Modeling, Relational Modeling, Dimensional Modeling (Star Schema, Snow-Flake, FACT, Dimensions), Entities, Attributes, Cardinality, ER Diagrams, OLTP, OLAP.

Databases: Oracle 11g/10g, MS SQL Server 2008, IBM DB2 9.1, MS Access, SAP, IDOC, Sybase, Netezza, Teradata with M-Load, TPUMP & BTEQ. PsotGRE.

Job Scheduling & Other tools: Autosys, Control M, Tidal, Clear Case, Ultra Edit, TOAD, AQT, Erwin, SQL Developer, MDM, Microsoft Master Data Services 2014, Visual Studio.

Environment: UNIX ( Confidential -UX, AIX), Windows, Sun-Ultra, Sun-Spark, Sun Classic, RS/6000, Confidential 9000, SCO UNIX, Mainframes.

Others: Java, XML, HTML, DHTML, C++, VBScript, CSS, SQL, Dream weaver, PL/SQL, LAN, WAN, TCP/IP, D-AMPS, GSM, W-CDMA, Networking.

Functional Knowledge: Utility, Pharmaceutical, Health Care, Retail/Supply Chain, Telecom, Finance.

PROFESSIONAL EXPERIENCE:

Confidential

Lead Informatica Developer / Admin

Responsibilities:

• Coordinated with business analysts for requirement gathering, business analysis and prepared high level technical specification documentation and Informatica mapping document.
• Configured web services hub for AWS (Amazon web service) in Informatica administration console.
• Coordinated with Confidential ’s network team and Accenture team for understanding and opening firewalls for Informatica Server, Opening/trouble shooting VPN Tunnels for AWS integration.
• Developed, tested Informatica mappings and web services workflows for all the Business interfaces.
• Involved in transitioning Progress code to Informatica ETL, integration testing and Prod deployments.
• Used Quality Gates for checking data discrepancies, creating Data quality rules and other data checks.
• Worked on Master Data Services for trouble shooting UAT defects and creating Product Hierarchies.
• Installation of PostGre ODBC drivers on UNIX servers and configuration of odbc and odbcinst files.
• Configured REST API calls through HTTP transformation for extracting CAS Promotions data.
• Closely interacted with Accenture’s team for setting up hand shake communication for sending out web service SOAP messages and exporting data out from Accenture system through http post message.

Environment: Informatica Power Center 9.5(Designer, Manager, Workflow Monitor, Workflow Manager), Quality GatesOracle 11G, Progress 8.x, Web services, XML, MDS, PostGRE, flat files, Bit Vise, UNIX scripts, Qlikview.

Confidential, Pittsburgh

Senior Informatica Developer

Responsibilities:

• Involved in business requirement gathering and created mapping documents/Business rules for ETL.
• Coordinated with Source System Owners to analyze sources for data feeds, mappings and Defaults in the Data. Created folders, shared folders for shortcuts, groups, users and assigned permissions and privileges to groups and users using the Informatica Repository Manager.
• Created Informatica mappings that involved best practices, client naming conventions, Error Handling and Responsible for Performance Tuning at the Source, Targets, Transformations, Mappings and Sessions.
• Involved in Unit Testing, Integration Testing, and User Acceptance Testing to verify the data loaded into target systems is accurate as per requirements by evaluating test scripts and Data validation rules.
• Created Remedy tickets and tasks for change requests/ code deployments and extensively involved in team assessment meetings and technical peer reviews for receiving approvals from functional manager.
• Worked closely with Database administrators for implementing DDL changes and migrating the changes.
• Created deployment groups for code migration in Repository manager and coordinated with production support team for migration of the deployment groups to TEST and PROD environments.

Environment: Informatica Power Center 9.5(Designer, Repository Manager, Workflow Monitor, Workflow Manager), Netezza, Aginity, Oracle 11G, Toad 11.5, Flat files, UNIX scripts, Telnet, Procedures, Tidal scheduler.

Confidential, Nashville

Informatica Developer/Analyst

Responsibilities:

• Analyzed existing functional specifications and Worked extensively with Business community and database administrators to identify the Data Load issues and proposed ETL framework.
• Replaced tables with Materialized views and enabled parallel hints for long running queries and documented results of performance improvements.
• Monitored workflows and collected performance data to maximize the session performance. And resolved memory related issues like DTM buffer size, cache size to optimize session runs.
• Created several jobs in Tidal to schedule Informatica workflows as per business requirement.
• Analyzed the data loads for Voyager load process and Involved in Performance Tuning of SQL Queries and handled daily load issues in Data Extracts.
• Involved in Unit testing and regression testing of tuned data extracts by coordinating with offshore team.
• Provided detailed technical, process and support documentation like daily process and detailed specifications document for Voyager load and Data Extracts with the workflows and their dependencies.
• Worked on migration documentation, coding and testing of Sybase to Oracle for Embrace aplication.
• Worked on Coding, testing and tuning of Informatica Jobs and performed extensive Data analyzing and testing on reporting files coordinating with accounts team.
• Created HPSM tickets for production deployments. Coordinated with Informatica Admins for completing production migration. Processed/Resolved many Change Request tickets raised by accounts team.
• Analyzed Informatica Data Quality rules for Data Intake process and documented technical defects coordinating with Application DBA to identify Data related issues in UAT and BAT.

Environment: Informatica Power Center 9.1 (Designer, Repository Manager, Workflow Monitor, Workflow Manager)Oracle 11G, Tidal, PL/SQL, Flat Files, Informatica Data Quality 9.1, UNIX, Sybase, SQL Developer 3.2.

Confidential, Columbus

DW/Informatica Developer

Responsibilities:

• Analyzed the existing application physical data model and suggested changes to data Model based on the ETL and Referential Integrity gap requirements. Accommodated ETL Mappings according to Database Management change requests. Developed Data Quality architecture for ETL environment.
• Created User Defined functions, reusable transformations to be re-used during the development life cycle
• Extensively used Informatica Data Quality for applying several rules against data coming from mainframes and VSAM files for data cleansing.
• Maintained Development, Test and Production Repositories using Repository Manager. Also used Repository Manager to maintain the metadata, Security, Backup and Locks.
• Standardized parameter files to define session parameters such as database connection for sources targets, last updated dates for Incremental loads and many default values of fact tables.
• Performed tuning of Informatica Mappings for optimum performance of data loads and extracts and SQL overrides in place of homogeneous sources. Designed and coded rejected row handling process.
• Designed and implemented CDC backup process for Mainframes. Designed data loading sequence and populated data into ODS, staging and warehouse with business rules following Data warehouse methodologies. Implemented SCD Type 1 and Type 2 to update the dimensional schema.
• Implemented Data Validation and Exception handling logic in the mapping to handle at runtime.
• Added enhancements such as mail functioning, success flag, pre and post session functions etc.
• Optimized the mappings using various optimization techniques and also debugged some existing mappings using the Debugger to test and fix the ETL defects.
• Provided detailed technical, process and support documentation like daily process rollback and detailed specifications and very detailed document of all the projects with the workflows and their dependencies.
• Created data lineage documents for data flow and ETL process based on Informatica mappings to support the project once it implemented in production.

Environment: Informatica Power Center 9.1.0 (Designer, Repository Manager, Workflow Monitor, Workflow Manager), Autosys, Oracle 11g, DB2 V 9.1, PL/SQL,Flat Files, AQT, Erwin, Data quality, Power Exchange, UNIX

Confidential, Princeton, NJ

DW/Informatica Developer

Responsibilities:

• Analyzed functional specifications provided by data architect and created technical spec document for ETL process and developed mappings based on STT documents provided by Data Modelers.
• Researched sources and identified necessary reusable components for Mapplets and Transformations
• Populated data into staging tables as a process of data integration from various heterogeneous sources.
• Used Metadata data Manager for analyzing data structures, collect and link various sources.
• Worked on MDM to develop complete and accurate data feeds for storage and administration.
• Extensively used Unix Scripting and used PMCMD commands to interact with Informatica Server from command mode. Worked on Control M to schedule the Jobs and involved in code migrations.
• Used Workflow Manager for Creating, Validating, and Testing, running Batches, scheduling sessions to run at specified time and used pre-session, post-sessions commands for calling UNIX scripts.
• Worked on Informatica mappings to calculate the load times for batch processing and tuning the mappings, SQL Queries, Sources, Targets, Transformations, Sessions.
• Extensively used PL/SQL programming in procedures to implement business rules and to achieve Data Import/Export, also used pre-post SQL scripts at session level to drop and recreate indexes.

Environment: Informatica Power Center 8.6.1(Designer, Workflow Monitor, Workflow Manager), SSIS 2008, Control-M, Master Data Management(MDM), Oracle 11g, Flat Files, Cubes, Toad, UNIX, PERL Scripting.

Confidential, Mettawa, IL

DW/Informatica Developer

Responsibilities:

• Involved in parsing high-level design specification to simple ETL coding and mapping standards and Participated in all phases including Requirement Analysis, Design, Coding, Testing and Documentation.
• Coordinated with Source System Owners to analyze true sources for data feeds which were maintained in DB2 and Data Integration from various sources like DB2, flat files, Mainframes for Teradata migration.
• Worked on Teradata SQL Assistant 7.2 to create BTEQS which are called in the informatica workflows.
• Used FastLoad and MultiLoad Types to load the bulk data into the Teradata Database Tables.
• Worked on Teradata Parallel Transporter(TPT) scripts to load Flat files into staging environment.
• Extensively worked on TPT for data integration from various heterogeneous sources and to eliminate bottlenecks in data load and Performed unit testing by generating SQL based on the Test Plans.

Environment: Informatica Power Center 8.1(Designer, Workflow Monitor, Workflow Manager), Erwin 4.5, Flat files, IDQ, Unix Shell Programming, Autosys, IBM DB2 8.0, Data Quality 8.5, Teradata V2R4, Microsoft Visual Studio.

Confidential, Dallas.

DW / Informatica Developer

Responsibilities:

• Participated in team meetings and proposed ETL Strategy. Worked on solution and detail documents for the High level Design Specifications for ETL Coding and mapping standards.
• Worked in Service Oriented Architecture (SOA) and transact oriented data warehouse where data is updated and fetched real time. Worked on change data capture (CDC) while loading Dimensions by implementing SCD type 1 and type 2 from complex data extractions following business rules.
• Worked with the EAI Team for error detection and correction provided a management console for performing batch validation, conversion, transformations and reporting on schemas, DTDs and XML files.
• Developed and implemented the Audit and Error handling standards for all interfaces which were Developed Using TIBCO EMS and Involved in Archiving and Maintaining TIBCO Tables(CLE).
• Extensively worked on SQL queries and database programming using PL/SQL (writing Packages, Stored Procedures/Functions, Database Triggers) to implement ETL and involved in data modeling using Erwin.

Environment: Informatica Power Center 8.1, Flat files, Oracle9i, SQL Server 2005, PL/SQL, TIBCO BW 5.6, UNIX scripts.

Confidential

Programmer/ Analyst

Responsibilities:

• Analysis Design & coding of the specifications and Interacted with end users to gathering requirements.
• Extensively used PL/SQL to implement cursors, triggers & packages and reports request screens.
• Co-Ordination with users and SQL tuning on existing reports and Tested Database for Performance.
• Involved in system study (Including User Requirement Study, Functional Specification).
• Developed Reports, Forms and Report format Design and Developed user friendly screen using forms
• System Testing and Client Site Implementations

Environment: Java, HTML, Oracle 8i, Developer 2000 (Forms 4.5, Reports 2.5), Windows 95/98, UML.