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 the 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 the 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 the whole project life cycle.
• Extensive experience in the development, implementation, deployment & integration strategies within 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 knowledge 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 the data from and load the data into the salesforce application using Bulk API and Soap API concepts in Salesforce.
• Experience in integration of various Operational Data Source (ODS) s with Multiple Relational databases like Oracle, Teradata, SQL Server and Worked on integrating data from flat files of fixed width and delimited.
• Hands on expertise with SQL Server, Oracle, Teradata and DB2 Databases.
• Writing batch scripts to process source files, target files, automate the email notifications, archive the files, copy, ftp and cleanse the 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 toolsInformatica MDM Multi-domain 9.5.1/9.7.1 , IDD, SIF.

OS/Environment: Windows 9X, DOS, UNIX

PROFESSIONAL EXPERIENCE

Confidential

Informatica Developer

Responsibilities:

• Requirements gathering and requirements analysis through coordination with 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 the 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 with deploying multiple Application Servers such as Jboss, Weblogic and Web sphere.
• Create, design and implement the core ETL methodologies using Star and Snowflake schema.
• Also Developed SSIS Packages and loading the data from the raw feed files into target using MS SSIS.
• Used Informatica Power Center 9.6 for extraction, transformation and load (ETL) of data into the 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 the 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 with testing team to define a robust test plan and support them during the functional testing of the application.
• Identifying & removing the bottlenecks, tuning the 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 the 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 the requirements. Created mapping documents to outline data flow from sources to targets.
• Extracted the data from the 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 the Session task to execute scripts needed for cleanup and update purposes.
• Assist with task identification and effort estimates for ETL development as per Agile Development methodology.
• Documented the test plans and executed for UNIT testing and also supported for system testing, volume testing and USER testing. Also provided production support by monitoring the processes running daily.
• Created email notifications. Scheduled the loads at required frequency using Control M, generated completion messages and status reports using Workflow Manager.
• Using debugger to test the data flow and fix the 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:

• Build and promote the use of repeatable EDW processes, templates, and tools.
• Involved in Requirement gathering and analyzing the requirements.
• ETL Tools Informatica 9.5.0, MS SQl Server Integration Services (SSIS)
• Responsible for holding meetings with the functional Analyst to understand the business requirements.
• Maintain account lineage.
• Reconcile the month end loan balances in Associated Bank’s general ledger (GL) to the month-end loan balances in the 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 the loads at required frequency using Power Center Workflow Manager, Generated completion messages and status reports using Workflow Manager.
• Join business discussions to attribute the 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