SUMMARY

• Over 10+ years of experience in the IT Industry focused on ETL Solutions Implementations, Data Quality, Data warehousing, Development - Complete SDLC involving system study, analysis, design, development& implementation of application software for Client/Server, Web and Web services.
• Highly Proficient in using Informatica Power Center 9.1/8.1. Extensively used all Power Center Tools - Designer, Workflow Manager, Monitor and Repository Manager.
• Experience withInformaticaData Quality (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, address standardization, exception handling, and reporting and monitoring capabilities of IDQ Using Informatica Developer tool.
• Experience in working with creating mappings, mapplets, Data Profiling, ScoreCards, Classifier models, probabilistic models, Human task, Exception record management, Data Masking and used IDQ Specific transformations like Key Generator, labeler and standardize transformations in IDQ.
• Experience in working with Informatica Power Exchange Change Data Capture (CDC) to improve IT Responsiveness.
• Experience on implementing Informatica B2B Data Exchange to automate unstructured data formats.
• Experience in working with Informatica components like workflows, mappings, mapplets, sessions, tasks, User Defined Functions (UDF), Debugger, partitioning, reusable components and also extensively worked with session logs, workflow logs for error handling and troubleshooting on mapping failures
• ETL development experience building data warehouses and as middleware interface for applications, data profiling and analysis, data modeling for OLTP & OLAP (data marts and data warehouses), BI reporting, and production support for data warehouses.
• Worked in complete life cycle of project like requirements gathering, data analysis, design, construct, test, deployment and warranty/production support driven by both Waterfall and Agile methodology.
• Excellent in High Level Design of SSIS Packages for integrating data using OLEDB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Experience in migration of data using BCP Utility, Bulk Insert command, SSIS and DTS Packages and Import/Export Wizard
• Extensively worked on Teradata Bteq scripts, Utilities (FastLoad, MLoad, TPump), Teradata Parallel Transporter, and SQL Assistant.
• Worked on Reporting tools like, SSRS, Tableau Reporting.
• Experience in understanding Clinical administrative data coming through of HL7 using IGUANA Interface.
• Worked on different modules on Healthcare like Eligibility, Medical Necessity, Estimator, Credit Check, Payment Modules (Using Auth Net).
• Experience on loading CPT Price listing data with respective to the ICD9-10 Codes.
• Experience on HealthCare domain with Claims data using 276/277 and also understanding about Payment & advice transactions using 835/837.
• Experience with Mastermind and Monitoring Database on Security Monitoring Domain ( Confidential Security systems).
• Expertise in Performance Tuning of Informatica mappings, sessions.
• Excellent written and verbal communication skills with an ability to interact with individuals at all levels in all teams like - Systems, Business, Vendors, Architecture, Quality and Testing teams.
• Have sound knowledge on Retail domain - Supply Chain Management (Demand Planning, Production Planning, Replenishment Planning, and Transportation Management), Store Management and Logistics.
• Have fair knowledge on Telecom, Health care and Retail domains.

TECHNICAL SKILLS

Data warehouse Technologies: Informatica PowerCenter 9.X/8.X, Informatica Developer 9.X, Teradata, SSIS, ERWIN

Languages: C#,VB.Net

RDBMS: MSSQLServer 2005/2008/2012 , MS Access, Oracle9i/10g, Teradata

Op Systems: Windows 2000/NT/XP, Windows 95, DOS, and UNIX

Tools: /Technologies: Microsoft Share point 2007, Microsoft. Net, COM/COM+, ODBC, ADO, IIS, XML/XSL, SSRS, SSIS, SSAS, Informatica Developer 9.X,Informatica Developer 9.X

Packages: MS Office Tools, MS Project, Microsoft Visio, Visual Source Safe

Web: ASP, HTML, VBScript, Java Script, WML, XML, .NET, ASP.NET, VB.NET, C#.NET, XML, XSL, XSLT, WCF, AJAX

Special Skills: LDM/PDM Modeling using Erwin

PROFESSIONAL EXPERIENCE

Confidential, Norfolk, VA

Sr. IDQ Developer

Responsibilities:

• Design and developed ETL process using Informatica to sync provider data from EPDS V2 to GBD Facets, using inbound CRF files.
• Implemented multiple business rules on SQL server to sync the EPDS with GBD FACETS
• Handled all the Errors, Session/Workflow logs, Exceptions in a separate log tables
• Worked on re-processing the failed provider records from the previous execution.
• Used Informatica Developer tool for profiling the data
• Used Informatica Address Doctor to standardize the address from Central Region Facets and GBD Facets.

Environment: Informatica Powercenter 9.X/, Informatica Developer 9.X / IDQ, SQL Server 2008 R2, SSIS, Tidal, JIRA, SVN.

Confidential, Irving, TX

Sr. ETL Consultant - IDQ

Responsibilities:

• Involved on business calls with protection one for planning sessions.
• Analyzed Mastermind schema objects on both the systems ( Confidential and P1).
• Responsible for designing and documenting logical and physical Enterprise Application (OLTP) and Data Warehouse (OLAP) databases and creating the related ETL Design Specifications and supporting documentation
• Interacted with Management to determine the organization’s data needs, and translate them into systems design.
• Interacted with Development teams to identify and accommodate technical requirements and establish standards for adherence to industry best practices, company policies, and project standards as they relate to data.
• Mapping the objects manually and converts the data types from oracle to sql server.
• Developed design documents for P1 - MMB Item Interface and Internal Purchase Acknowledgement items.
• Developed ETL packages using INFA with different transformation like look up, Data Conversions.
• Extensively worked with Slowly Changing Dimensions (SCD) Type1, Type2, and Type3 for Data Loads.
• Extensively worked on comparison Matrix for different Systems in both the companies.
• Created multiple packages using Informatica for moving the data between MMB oracle to eSuite DataMart sql server.
• Successful completion of first phase of Customer related data migration between both the systems.
• Worked on moving all the solution files, scripts to SVN for completion of the development.
• Created JIRA tickets and assign them to team members as a part of integration.
• Also used Informatica Data Quality tool for address standardizations
• Also Created SSRS reports for billing and invoice data.

Confidential, Dallas, TX

Sr. Data Consultant

Responsibilities:

• Manage and plan data extracts schedule, timelines, cut over plan, progress and budget
• Preparing comparison matrix for 182 IT systems and establish 1:1 or 1: Many or Many: 1 relation.
• Performed Data Architecture and Data Modeling supporting data management for the Integrated Data Warehouse (IDW).
• Responsible for analysis and design of the Enterprise Data Warehouse which will be used for reporting and analytics
• In depth knowledge of SQL Server for database architecture, modeling and transformation along with a good understanding of SSIS and C#.
• Expertise in implementing complex business rules by creating robust mappings, mapplets, and reusable transformations using Informatica Power Center using different transformations which include Joiner Transformations, Look-up Transformations, Rank, Filter Transformations, Router Transformations, Expressions, Aggregators and Sequence Generator, Sorter, Update Strategy, Partitioning and Debugging Mappings to identify performance issues in existing mappings by analyzing the data flow and evaluating transformations.
• Worked withInformaticaData Quality (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, address standardization, exception handling, and reporting and monitoring capabilities of IDQ.
• Identified and eliminated duplicates in datasets thorough IDQ components of Edit Distance, Jaro Distance and Mixed Field matcher, It enables the creation of a single view of customers, help control costs associated with mailing lists by preventing multiple pieces of mail.
• Expertise in implementing Profiling, Score Card, Classifier models, probabilistic models, Human task, Exception record management as part of IDQ process.
• Expertise in Exporting IDQ mappings into Informatica designer and creating tasks in workflow manager and scheduling the mapping with scheduling tools to run these mappings.
• Created reusable objects like Mapplets, worklets, transformations and user defined functions to use across multiple mappings.
• Created high level reports in SSRS for all the data extracts coming from source systems on every 4-hour interval
• Alignment of data dictionary, schema, mode of transfer, data mapping of extracts of each system.

Environment: Informatica Powercenter 9.X/8.X (Repository Manager, Designer, Work Flow Manager, Workflow monitor), Informatica Developer 9.X / IDQ, SQL Server 2008 R2, SSIS, Shell Scripting, CONTROL M, SFTP, FTP

Confidential, Dallas, TX

Sr. ETL Developer

Responsibilities:

• Heavily involved in analyzing 32+ data sources for marketing data market.
• Designed/developed/Implemented the sourcing of 32+ data sources with Informatica 9.5.1.
• Integrated data from EDW stage to marketing data mart with customer 360 using Informatica 9.5.1.
• Worked withInformaticaData Quality (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, address standardization, exception handling, and reporting and monitoring capabilities of IDQ for small mod projects.
• Expertise in Exporting IDQ mappings into Informatica designer and creating tasks in workflow manager and scheduling the mapping with scheduling tools to run these mappings.
• Effectively handled the Production Support by performing normal loads, initial loads, daily loads and monthly loads.
• Worked with Session logs and Workflow logs for Error handling and troubleshooting during the job failures.
• Extensively worked on Performance Tuning at the mapping level, session level, source level, and the target level for the mappings which were taking long time to complete.
• Extensively worked on handling production defects and change requests.
• Analyze source data for potential data quality issues and created the exception mappings/clean up scripts to clean up the bad data in data warehouse.
• Built many reusable components in informatica, like mapplets, worklets, reusable transformations and Use.
• Created a shell scripting in UNIX platform for running Informatica workflows, updating the Parmfiles, sending emails and the FTPing the Files.
• Well acquainted using Teradata utilities BTEQ, Fast Load, Multi Load, Fast Export, Tpump, SQL Assistant and SQL Administrator.
• Architected and design solution for integrating lead/prospect lists from various sources including webinars, trade shows and third party marketing vendors.

Environment: Informatica, SqlServer 2008, Microsoft SharePoint 2007, SSAS, Teradata, Unix shell scripting.

Confidential, San Francisco, CA

Sr. Developer

Responsibilities:

• Requirements gathering, analyze, design, code, test highly efficient and highly scalable integration solutions using Informatica Power Center 9.0.1 and Power Exchange, Oracle, SQL, Source systems viz.
• Implemented SCD I, II to the extracts based on the business requirement and client expectations.
• Imported data from various sources transformed and loaded into Data Warehouse Targets using Informatica.
• Worked on Informatica - Source Analyzer, Warehouse Designer, Mapping Designer & Mapplet, and TransformationDeveloper.
• Fixing invalid Mappings, testing of Stored Procedures and Functions, Unit and Integration Testing of Informatica Sessions, Batches and Target Data.
• Extensively used Transformations like Router, Aggregator, Source Qualifier, Joiner, Expression, Aggregator and Sequence generator
• Scheduled Sessions and Batches on the Informatica Server using Informatica Server Manager/Workflow Manager.
• Worked with different sources such as Oracle, SQL and flat files.
• Knowledge of slowly changing dimension tables and fact tables.
• Optimizing the mappings by changing the logic to reduce run time.

Environment: Informatica Power Center 9.5 (Designer, Workflow Manager, Workflow Monitor, Repository manager), Pushdown Optimization, Performance Counters, SQL, PL/SQL, UNIX, Shell scripts

Confidential, Dallas, TX

Sr. Developer

Responsibilities:

• Extensively worked with both Connected and Un-Connected Lookups and Look up Caches like Persistent Cache, Static Cache, and Dynamic Cache to improve the performance of the lookup transformations.
• Extensively worked with Incremental Loading using parameter files, mapping variables, and mapping parameters.
• Developed reports using reporting services 2008.
• Customized Microsoft SSRS API for custom security.
• Managed client expectations on the adhoc reports and delivered using Share point 2007.
• Experience in understanding the EDI transactional data includes HL7, 270,271,835,837.
• Experience in creating different payor templates to get the data based on 270 request and retrieve 271 response.
• Ability to understand 270/271 companion guides to create templates and add different payors.
• Also Experience in understanding the process of parsing the EDI into transactional level.
• Enhanced the eligibility, registration, billing modules code using AJAX, jQuery, WCF.
• Successfully worked with the clients Quality Assurance team to get the Document Management application tested and ready for production under a tight deadline.

Environment: .net 3.5,Informatica Power Center 8.6 (Repository Manger, Designer, Workflow Monitor, Workflow Manager), Flat Files, SSRS 2008, T-SQL,UNIX Scripting, Putty, Visio, EDI Format.

Confidential, Dallas, TX

Sr. BI Developer

Responsibilities:

• Attended Requirements gathering sessions.
• Managed, Lead and coordinated both onshore and off shore teams (VDSI) for continued deliverables.
• Developed reports using reporting services 2008.
• Customized Microsoft SSRS API for custom security.
• Developed SSAS 2005/2008 cubes for drill to detail data using star schema model.
• Developed Microsoft Share point executive scorecard for one version of Truth across Confidential .
• Developed, modified various screens for UI on Dashboards.
• Developed various scripts, functions, stored procedures for data manipulation and extraction for RDL’s.
• Created SSIS package to pull data from SQL Server and exported to Excel Spreadsheets and Vice versa.
• Deployed SSIS package into production and used package configuration to export various package properties to make package environment independent
• Customized Microsoft SSRS API for custom security.
• Developed SSAS 2005/2008 cubes for drill to detail data using star schema model.

Environment: Visual Studio 2008, T-SQL, SSAS 2005 / 2008, SSRS 2008, SSIS 2008, Share Point 2007

Confidential

Developer

Responsibilities:

• Created tabular, matrix, chart, drilldown reports, parametric, cascaded reports and dashboards and scorecards reports according to business requirement.
• Developed SSRS reports against Oracle and SQL Server, to Drill Through increasing levels of detail to view different reports for Region Operations and Regional Sales consumer.
• Developed crosstab, repeater, chart and complex reports which involved conditional formatting with Parameter Fields, multi-query reports against multiple databases.
• Provided various management levels with reports, time series graphs and pie charts using various SSAS 2005 reports.
• Involved in the migration of Crystal reports to SSRS reports and custom .net reports.

Environment: .net 3.5, SQL Server 2005/2008, SSIS, SSAS, SSRS