SUMMARY

• Professional experience of over 8+ years in the field of Enterprise DataWarehousing, Data Integration and Data/code Migration.
• Experience in all the phases of Data Warehouse life cycle involving Requirement analysis, Design, Coding, Testing and Deployment.
• Expert in Database skills using SQL, PL/SQL Developer for debugging applications.
• Experience in writing stored procedures and functions (PL/SQL).
• Strong SQL experience in Coding and Query tuning. Well versed with Oracle SQL tools like TOAD, SQL developer and SQL Plus.
• Proficient in Data Migration, Data Extraction, Data Transformation and Data Loading using Oracle PL/SQL
• Effectively made use of Bulk Collect, Multi Table inserts, Merge, Collections, SQL types, PL/SQL tables & Nested tables.
• Extensively worked on various different ETL mappings, analysis and documentation of OLAP reports requirements.
• Strong knowledge of Entity - Relationship concept, Facts and dimensions tables, slowly changing dimensions and Dimensional Modeling such as Star Schema and Snow Flake Schema.
• Extensive experience with informatica powercenter 9.0.1/7.x/6.x
• Worked onIDQtools for data profiling, data enrichment and standardization.
• Addressdata cleansing using InformaticaAddressDoctorto discover deliverable personal and businessaddresses.
• Extensive experience in Extraction, Transformation and Loading from various sources into Datawarehouses and marts using informatica power center(Repository manager, Designer, workflow manager, workflow monitor).
• Experience in writing various ETL procedures in order to load data from different sources like Oracle 10g, DB2, XML Files, Flat Files, MS SQL Server and MS Access into Data marts, Data warehouse using Informatica Power Center.
• Worked on flatfiles both of delimited and fixed length.
• Implemented different Slowly changing dimensions(SCD) using Informatica.
• Designed and developed various complex mappings such as Filter, Router, Connected and Unconnected lookups, update strategy, sorter, Aggregator and Joiner.
• Experience in creating Reusable Tasks (Sessions, Command, Email) and Non-Reusable Tasks (Decision, Event Wait, Event Raise, Timer, Assignment, Worklet, Control).
• Extensive experience in writing UNIX scripts and also automation of the ETL processes using UNIX shell scripting.
• Extensive experience on working with scheduling tools like SAS Management console, Crontab and lsfadmin tools.
• Worked on performance tuning, identifying and resolving various performance bottlenecks at various levels like sources, mapping and sessions.
• Involved in Unit testing, system testing to check whether the data loads in to target are accurate.
• Expert in debugging, troubleshooting, monitoring, and performance tuning of Sources, Mappings, targets and sessions.
• Experience in designing exception handling procedures to identify, record and report errors.
• Quick learner and excellent team player, ability to meet deadlines and work under pressure with Analytical and Technical aptitude with the ability to solve complex problems.
• Can also work very well in a team as well as independently under minimum supervision.
• Excellent written and oral communication, interpersonal skills and presentation skills.
• Experience in working with senior level managers, business people and developers across multiple disciplines.

TECHNICAL SKILLS

ETL Tools: IDQ9.6, Informatica 9.5.1/9.1/8. x/7.x (PowerCenter)

Data Modeling: Relational Modelling, Dimensional Modelling (Star Schema, Snow-Flake, Fact, Dimensions), Data Quality, Entities, Attributes, ER Diagrams.

Databases: Oracle 11g/9i/8i, MS SQL Server 2005/2000, MS Access, Teradata and DB2

Tools: SQL plus, PL/SQL Developer, Toad, SQL* Loader

Query Languages: SQL, PL/SQL, C, C++, UNIX Shell Script, Visual Basic

Job Scheduling Tools: lsfadmin, Crontab, Control-M

Operating Systems: UNIX, Windows NT/2000/2003/XP/Vista/7, MS-DOS

Others: MDM.

PROFESSIONAL EXPERIENCE

Confidential, Richmond,VA

Sr. Informatica Developer

Responsibilities:

• Interacted with subject matter experts and dataStewardsto get information about the business rules for cleaning the source system data.
• Optimized the performance ofby using Persistant cache across multiple Lookup transformations which will be useful for building different rules.
• Followed Agile methodology. Logged all the user stories that needs to be developed on sprint basis.
• Also used Informatica Analyst tool which will be helpful for maintaining Reference tables and also helpful for viewing the scorecarding and Profiling results.
• Used differentPostGresGreenplumDatabasefunctions in order to aggregate across source summary,column summary and issue summary based on requirement.
• Used Unix scripting in order to trigger various functions in Greenplum and also to trigger Informatica powercenter workflows.
• Informatica Powercenter is used for using command tasks to triggerIDQApplications and also greenplum functions.
• Involved in Test data management using IBM OPTIM tool which will be helpful for masking sensitive data from Production environment.
• Used spotfire for reporting data issues to the business users who take necessary action based on the issue encountered. Reason for issue will also be shown across each record.
• Involved in migratingIDQfrom 9.6 version toIDQ10.0 version. Communicated with Admin team based on requirement and provided necessary information regarding the same.
• Used appworx for scheduling theIDQobjects

Environment: UNIX, Informatica Data Quality 9.6/10.0,IDQ/IDE, TOAD for Oracle, Oracle12.1c/11g, SQL Server2005/2008,Informatica Analyst,Spotfire,IBMOPTIM,Shell Scripting.

Confidential, Chicago,IL

Sr. Informatica Developer

Responsibilities:

• Interacted with subject matter experts and data management team to get information about the business rules for data cleansing.
• Work with the project team and data owner to gather requirements.
• Created the Technical Design Document for the DQ Services.
• Build profiling, cleansing and validation plans.
• Analyze profiling results and make recommendations for improvements.
• Built Physical Data Objects and developed various Mapping, Mapplets/rules using Informatica Data Quality based on requirements to profile, validate and cleanse the data.
• Identified and eliminated duplicate datasets and performed Columns, Primary Key, Foreign Key profiling using IDQ.
• Designed and developed Technical and Business Data Quality rules in IDQ (Informatica Developer) and created the Score Card to present it to the Business users for a trending analysis (Informatica Analyst).
• Worked on detailed analysis of Master data based on attributes such as Data Completeness, conformity, consistency, accuracy, duplication and Integrity. Analysis involved creating a presentation.
• Involved in Implementation of DQ Services using Informatica Data Quality. Implementation Included Cleansing and Matching Services.
• Worked with various developer modules like profiling, standardization and matching.
• Showing various counts, creating Scorecard using Informatica Analyst and Trend analysis report.
• Set up IDQ Base Line Architecture involving Installation and configuration of IDQ.
• Implemented PC DQ mappings to test the standardized and cleansed new data.
• Utilized Informatica Data Quality (IDQ) software to provide name and address cleansing for improving data quality and customer house holding purposes.
• Assist in code testing, migration, deployment, enhancement and bug fixes.
• Good understanding of relational database management systems like Oracle, PLSQL and SQL and extensively worked on Data Integration using Informatica for the Extraction transformation and loading of data from various database source systems.
• Created shell scripts to fine tune the ETL flow of the Informatica workflows.
• Created a Unix Shell Scripts and automated them with the help of Control M Scheduler which automated the Profile and Profile Model batch execution for the Data Quality rules, ETL and Metadata Load batch.
• Implemented and governed the best practices relating to enterprise metadata management standards.
• Involved in enhancements and maintenance activities of the data warehouse including tuning, modifying of stored procedures for code enhancements.
• Create a weekly process presenting cleansing, validation and duplicate suspect Results to all the distributors.

Environment: IDQ 9.5.1, Oracle 11g, PL/SQL, UNIX Shell Scripts, windows XP

Confidential, OH

ETL Informatica Developer

Responsibilities:

• Worked on 9.5.1 version of informatica in Confidential AMI Project.
• Worked on handling large amount of data usually in millions per day.
• Confidential is a utilities project where we handle live data which usually come in millions depending on number of customers.
• We have designed a system which accepts the requests based on certain flags and created a extract for handling such requests.
• The customers data will be stored in a dimension table and a fact table will be incrementally loaded.
• Worked with dynamic sql transformation which involves lot of joins on fact and dimension tables.
• Used pre sql of source qualifier which involves handling many sql queries.
• Worked on Mapping and workflow variables and also how to use the mapping variables in workflow and viceversa.
• Used lot of functions like set variable function in order to assign the incoming values to mapping variables.
• Created mappings in such a way where we connect all the mappings using mapping and workflow variables which are part of a single workflow.
• Used pre session success varable assignment and also post session success variable assignment at non reusable session task in order to pass the workflow varibales to mapping andf vice versa.
• Created unix scripts inorder to schedule or unscheduled athe workflows based on requirement.
• Created concurrent workflow which will be called form a different workflow using command task.
• Worked on continuous scheduling of informatica workflow.
• Used decision task, assignment task, email task based on requirement.
• Created parameter files at workflow level and also merged both of the parameter files used at workflow and session level.
• Created unit test cases and also documented all of them .
• Used lookup transformation where I wrote a lookup override in order to divide the comma separated values into multiple rows by using CONNECT clause in oracle.
• Used oracle minus queries in order to compare the data between two schemas.
• Create a mapplet which can be reused across two mappings and functions to give a differentoutput based on incoming data.
• Used transactional control transformation in order to generate dynamic files at mapping level.
• Also we used an approach to calculate the dynamic files by dividing with timestamp at session level.
• Worked on performance tunning where we increase the throughput by switching from Sql transformation and using the same query in source qualifier.
• Used parallel hint clause for increasing performance which divides across 16 cpus to run a oracle query which has multiple joins.
• Worked on informatica dynamic partitions which can be used for loading large amount of history data.
• Worked on calling the same workflow multiple times until a condition is satisfied which is handled in Unix script.
• Involved in code migration from development to integration testing, Staging and finally to Production Environment.
• Also, prepared documentation required to migrate all the objects across different environments.

Environment: Informatica Powercenter 9.6, Oracle 11g, PL/SQL, UNIX Shell Scripts, windows XP..

Confidential, Owings Mill, MD

PL/SQL Developer

Responsibilities:

• Involved in gathering and analyzing the requirements and preparing business rules and also involved in analyzing the sources to load in oracle Warehouse.
• Generated E-R diagrams based on the actual values and also relationships held in the source data.
• Prepared ETL specifications in order to help develop mapping.
• Worked with Power center designer tools in developing mappings and mapplets to extract and load the data from flat files, oracle in to oracle database.
• Implemented code using various Informatica Transformations like UNION, Expression, Aggregator, Filter, Sequence Generator, Update Strategy, Source qualifier, Union, Lookup, Joiner, XML Source Qualifier and Stored procedure transformations.
• Developed SQL overrides in Source Qualifier/Lookup according to business requirements.
• Developed mappings/Reusable Objects/mapplets by using mapping designer, transformation developer and mapplet designer, since different datatype conversions have to be dealt multiple times which are similar and also most of the lookups have been similar
• Worked with different caches in optimizing the transformations such as Index cache, Data cache and Lookup cache (Static, Dynamic, Persistence and Shared).
• Used Informatica Power Center Workflow manager to create sessions, batches to run the mappings daily, biweekly based on the business requirements.
• Implemented different Tasks in workflows which included Session, Command, E-mail, Event-Wait etc.
• Involved in Performance Tuning of SQL Queries, Sources, Targets and sessions by identifying and rectifying performance bottlenecks.
• Experienced in troubleshooting the errors inILMjobs withInformatica, Followed and Maintained Policies and Guidelines for data movement adhering to Client standards using withILMtool.
• Created accounts for users and provided appropriate roles for them inILMtool.
• Created Source and Target connections by usingILMtool.
• Used Data validation Test, SQL views usingInformaticaDVOUtility for Business analysts to perform UAT on source database upgrade for Well Dimensional Team data, source database.
• Created Entities and loaded the appropriate tables and views and mined them through EDM (Enterprise Data Manager).
• Created new retirement projects and archived the applications successfully by usingILMTool.
• Created Retirement entities for Essbase Cubes
• Monitored theILMjobs after successful run of each retirement project.
• Created pre-session and post session scripts using UNIX/PL-SQL.
• Tuned the Sources, Targets, Transformations and Mapping to remove bottlenecks for better performance.
• Migrated mappings, sessions, and workflows from development to testing and then to Production environments
• Created deployment groups, migrated the code into different environments.
• Worked closely with reporting team to generate various reports.

Environment: Oracle 10g, SQL Server 2000, SQL, PLSQL, SAP BOXI R3, SAP Web Intelligence reporting.

Confidential, Dallas, TX

ETL Informatica Developer

Responsibilities:

• Interacted with Business Analysts in order to gather the requirements.
• Analyzed the requirements to identify the necessary tables that need to be populated into the staging database.
• Worked withInformaticaData Quality 9.6.1 (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities of IDQ 9.6.1
• Designed IDQ mappings which is used as Maplets in Power center
• Performed the data profiling and analysis making use ofInformaticaData Explorer (IDE) andInformaticaData Quality (IDQ).
• Involved in generating and applying rules to profile data for flat files and relational data by creating rules in IDE and case cleanse, parse, standardize data through mappings in IDQ and generated as Mapplets in PC.
• Worked on identifying Mapping Bottlenecks and improved session performance through error handling.
• Worked on Mapplets and created parameter files wherever necessary to facilitate reusability.
• Worked withaddressdoctorfor profiling the data.
• Prepared the DDL’s for the staging/work tables and coordinated with DBA for creating the development environment and data models.
• Worked with Power Center Designer tools in developing mappings to extract and load the data from XML files into different FlatFile formats
• Worked on Informatica Power Center tools like Source Analyzer, Target Designer, Mapping Designer, Workflow Manager, and Workflow Monitor.
• Designed and Developed mappings by using Lookup, Expression, Filter, Update Strategy, Aggregator, Router, transformations to implement requirement logics while coding a Mapping.
• Developed error handling & data quality checks in Informatica mappings.
• Schedule and run Extraction and Load process, monitor task and workflow using the Workflow Manager and Workflow monitor.
• Used Workflow Manager for creating workflows, work lets, email and command tasks.
• Used Informatica features to implement Type II changes in slowly changing dimension (SCD) tables.
• Involved in Performance Tuning of SQL Queries, Sources, Targets and sessions by identifying and rectifying performance bottlenecks.

Environment: Informatica Power Center 8.1, InformaticaData Quality 9.6.1, AddressDoctor, Oracle, Flat files, Shell.

Confidential

Jr. Informatica Developer

Responsibilities:

• Involved from initial stage of the requirement gathering to understand business requirements subjected to business.
• Created new mappings and also modifications in already existing mappings as per the new business rules.
• Analyzed the business requirements and suggested changes to the design accordingly.
• Prepared ETL Specifications to help in developing various mappings.
• Used different transformations such as Expression, Source Qualifier, Lookup, Filter, Update Strategy, aggregate, Router, Sequence generator and Joiner in order to create mappings.
• Created sessions and Workflows for the mappings.
• Documented the mapping process and the process that can be used in order to facilitate future development.
• Interacted with user for his requirements and also involved in various document preparation such as integration test plan, Unit test plan, Deployment Instructions, Roll Back Plans and Production Move Check lists etc.
• Modifying the queries for performance improvement.
• Involved in performance improvement in informatica.
• Involved in running the loads to the data warehouse involving different environments.

Environment: Informatica Power Center 9, Oracle 11g, TIVOLI

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Interacted with the Business Analysts in understanding the business requirements for the project.
• Gathered the requirements from the users and analyzed their business needs and created SRS documents.
• Involved in SDLC including designing, coding and testing.
• Writing Technical design documentation.
• SQLtuning of queries.
• Complex queries like inline views and Sub queries.
• Created database objects like tables, views, procedures, packages using Oracle tools likeSQL*Plus,SQLDeveloper,PL/SQLDeveloper and TOAD.
• Defined database requirements and designed data model
• Created Forced Views.
• Extensively used DynamicSQLfor calling procedures
• Modified and debugged severalPL/SQLprograms for performance tuning using techniques like EXPLAIN PLAN, TKPROF and DBMS PROFILER
• Worked on performance tuning and used Explain Plan, TKPROF andSQLtrace for tuning the queries.
• WritingSQL*Loader scripts for the DDL's. Fixing bugs in .txt,.csv and .dmo files.
• Running explain plan for tuning theSQLqueries.
• Import and export of data from Xl sheets.
• Extensively used for all and bulk collect to fetch large volumes of data from table
• Applying constraints and writing triggers to apply the business rules. Involved in handling errors and transaction processing in the procedures.
• Extracted data from Flat files and transformed it in accordance with the Business logic mentioned by the client usingSQL*Loader. Involved in validating the data while data migration by creatingPL/SQLPackages, Procedures, Functions, Triggers.
• Created Indexes for faster retrieval of the customer information and enhance the database performance.
• Wrote many simple and complex ad-hoc reports usingSQLPlus and TOAD for the business users. Transformed complex business rules to OraclePL/SQL.
• Extensively used Apex DATA loader to load data into Sales Force.
• UAT testing for the one of the functionality for sales force app.
• Worked with Bulk Collects to improve the performance of multi-row queries by reducing the context switching.
• Used Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Table Partitioned by creating a table in to smaller level partitions based on date. Usually we do for Saving storage space and Performance issues instead of querying whole big table.
• Uses Informatica Power Center 9.1 for extraction, loading and transformation (ETL) of data in the data warehouse.
• Interacting with business users to analyze the business process and requirements and transforming requirements into Conceptual, logical and Physical Data Models, designing database, documenting and rolling out the deliverables.

Environment: Oracle 11g/10g,PL/SQL, Oracle Forms 10g, Reports10g,SQLNavigator, UNIX, Windows XP, WINCVS, SSH,SQLDeveloper, PLSQL Developer, TOAD.