PROFESSIONAL SUMMARY

• Around 6+ experience in IT Software Development Life cycle involved in Business Requirement Analysis, Application Design, Data Modeling, Development, Testing and Implementation of Data Warehousing applications in Manufacturing, Travel and Insurance domains.
• Experience in Analysis, Design, Development and Maintenance of various Business Intelligence Tools likeTableauServer,TableauDesktop.
• Extensive experience in writing SQL, Stored procedures, Functions, Packages, Database triggers, Shell - Scripts and SQL Loader scripts.
• Extensively Used Data Blending to Join Multiple Data Sources and Rendering teh data into visualization inTableau
• Proficient in SQL using Stored Procedure, Dynamic SQL, joins, Views, Indexes, Triggers, Cursors, CTE, DML, DDL and etc.
• Very strong in SQL Query Tuning, Indexes and Stored Procedures, Review and optimize daily batch jobs.
• Expertise in conducting requirements gathering sessions, feasibility studies, Impact Analysis, Risk analysis & management and base lining teh acceptance criteria.
• Provided strategic thinking and solutions while driving Architectural Recommendations specific to data warehouse applications and business intelligence tools focusing on ETL functions.
• Provided project level design, data analysis and application performance analysis.
• Expertise in managing several projects simultaneously for teh whole project life cycle.
• Extensive experience in teh development, implementation, deployment & integration strategies wifin a team oriented environment, utilizing quantitative & qualitative analytical skills.
• Strong Knowledge of SDLC and Agile (Scrum) methodology.
• Experience in using Informatica Power Center, an ETL tool to integrate data from various source systems includes flat files, XML, Relational and COBOL on UNIX and Windows platform.
• Expertise in Master Data Management concepts, Methodologies and ability to apply this noledge in building MDMsolutions.
• Experience in several facts of MDMimplementations including Data Profiling, Data extraction, Data validation, Data Cleansing, Data Match,Data Load,Data Migration, Trust Score validation.
• Good understanding of ETL, Dimensional Data Modeling, Slowly Changing Dimensions (SCD) and Data Warehouse Concepts.
• Experience in using Informatica Power Exchange to extract teh data from and load teh data into teh salesforce application using Bulk API and Soap API concepts in Salesforce.
• Experience in integration of various Operational Data Source (ODS) s wif Multiple Relational databases like Oracle, Teradata, SQL Server and Worked on integrating data from flat files of fixed width and delimited.
• Hands on expertise wif SQL Server, Oracle, Teradata and DB2 Databases.
• Writing batch scripts to process source files, target files, automate teh email notifications, archive teh files, copy, ftp and cleanse teh files to process in ETL.
• Expert level understanding of Oracle Database Capabilities and DW best practices including appropriate use of Index, Partitions, Materialized Views etc.
• Excellent in project management, communication, documentation, interpersonal and analytical skills. Strong ability to perform as part of a team.

TECHNICAL SKILLS

Business Intelligence: Informatica 10.1/9.x/8.x,SSIS, Cognos

Source/Target Systems: Oracle, DB2, SQL Server, Teradata, Salesforce, SAP

Languages: SQL, PL/SQL, Shell Scripting, PostgreSQL, C, Java

Tools: SQL Developer, TOAD, Control M, Subversion

EIM tools: Informatica MDM Multi-domain 9.5.1/9.7.1, IDD, SIF.

OS/Environment: Windows 9X, DOS, UNIX

PROFESSIONAL EXPERIENCE:

Confidential Michigan

Informatica Developer

Responsibilities:

• Requirements gathering and requirements analysis through coordination wif business analysts and define business and functional specifications.
• Experience in Analysis, Design, Development and Maintenance of various Business Intelligence Tools like Tableau Server, Tableau Desktop.
• Extensively Used Data Blending to Join Multiple Data Sources and Rendering teh data into visualization in Tableau.
• Provided documentation of ETL design and technical specifications, high level and low-level design specifications.
• Worked on MDMHub configurations - Data modeling & Mappings, Data validation, Match and Merge rules, Hierarchy Manager, customizing/configuring InformaticaData Director (IDD).
• MDMdevelopment includes creating Base object tables, staging tables and landing tables as per requirement in LLD.
• Good amount of experience working in Data Warehouse project i.e. creating and loading different Data Feeds through Informatica and SSIS packages
• Well acquainted wif deploying multiple Application Servers such as Jboss, Weblogic and Web sphere.
• Create, design and implement teh core ETL methodologies using Star and Snowflake schema.
• • Also Developed SSIS Packages and loading teh data from teh raw feed files into target using MS SSIS.
• Used Informatica Power Center 9.6 for extraction, transformation and load (ETL) of data into teh data warehouse.
• Worked extensively on different types of transformations like Source qualifier, Expression, Filter, Aggregator, Lookup, Sequence generator, Router and Joiner.
• Worked on Informatica Advanced concepts & also Implementation ofInformatica PushDown Optimization and Partitioning.
• Created mapplets and reusable transformations to leverage teh coding efforts and to help code maintenance.
• Used Type 2 SCD logic in Informatica to load Slowly Changing Dimension tables.
• Created complex stored procedures, functions, triggers, and tables and materialized views. Developed complex SQL code to read data from source system and in lookup transformations.
• Worked wif testing team to define a robust test plan and support them during teh functional testing of teh application.
• Identifying & removing teh bottlenecks, tuning teh mappings and sessions to improve performance.
• Precise Documentation was done for all mappings and workflows.
• Developed Shell scripts to automate file manipulation and data loading procedures.
• Review and deploy teh code.
• Prepare and use test data/cases to verify accuracy and completeness of ETL process.

Environment: InformaticaMulti domain MDM9.5.0, JBoss 5.1, Oracle 11g, SSIS Package, Address Doctor 5, IDD, SIF, InformaticaData Quality (IDQ) 9.5.0,Teradata R6,InformaticaPower Center 9.1.0,ToadInformatica Power Center 9.6, SQL Server, Oracle, UNIX, SAP, Control M

Confidential, Hartford, CT

Informatica Developer

Responsibilities:

• Involved in Requirement gathering and analyzing teh requirements. Created mapping documents to outline data flow from sources to targets.
• Extracted teh data from teh flat files and Oracle into staging area and populated onto Data warehouse. Worked on Flat Files and Oracle as sources.
• Provide documentation of ETL design and technical specifications, high level and low-level design specifications.
• Create test cases for Unit testing, Integration testing and User acceptance testing.
• Create mappings using different Transformations like Source Qualifier, filter, Router, Aggregator, Lookup, Expression, Sequence Generator, and update strategy etc.
• Create mappings, sessions, workflows and run those using workflow manger and monitor jobs using workflow monitor.
• Involved in upgrading Informatica from 9.6 to 10.1
• Connecting and loading data from SAP and AZURE source systems.
• Made use ofPost-Session successandPost-Session failurebatch scripts in teh Session task to execute scripts needed for cleanup and update purposes.
• Assist wif task identification and effort estimates for ETL development as per Agile Development methodology.
• Documented teh test plans and executed for UNIT testing and also supported for system testing, volume testing and USER testing. Also provided production support by monitoring teh processes running daily.
• Created email notifications. Scheduled teh loads at required frequency using Control M, generated completion messages and status reports using Workflow Manager.
• Using debugger to test teh data flow and fix teh mappings.
• Prepare and use test data/cases to verify accuracy and completeness of ETL process.
• Involve in Production Support and troubleshooting data quality and integrity issues.

Environment: Informatica Power Center 10.1/9.6.1, AZURE, SQL Server, Oracle, Windows, Control M

Confidential

Informatica Developer

Responsibilities:

• Design ETL Best Practice Methodology for teh Creation of an Enterprise Data Warehouse (EDW) for Associated Bank.
• Build and promote teh use of repeatable EDW processes, templates, and tools.
• Involved in Requirement gathering and analyzing teh requirements.
• ETL Tools Informatica 9.5.0, MS SQl Server Integration Services (SSIS)
• Responsible for holding meetings wif teh functional Analyst to understand teh business requirements.
• Maintain account lineage.
• Reconcile teh month end loan balances in Associated Bank’s general ledger (GL) to teh month-end loan balances in teh credit risk data mart.
• Provide vintage analysis (vintage delinquency, payoff trend, charge-off curves) and HELOC (home equity line-of-credit).
• Provide probability of default (PD), loss given default (LGD), exposure at default (EAD) and dynamic cohort reporting.
• Created email notifications. Set up Workflow to schedule teh loads at required frequency using Power Center Workflow Manager, Generated completion messages and status reports using Workflow Manager.
• Join business discussions to attribute teh business and functional requirements and qualify and quantify data requirements and project planning.
• Provide documentation of ETL design and technical specifications, high level and low-level design specifications.
• Design and build reconciliation process.
• Police code maintenance and code deployments.

Environment: Informatica PowerCenter 9.5.0, Oracle 11g, SQL Server, SSIS, Windows