CAREER SUMMARY

• 8+ years’ experience inBI Architecting, Design and development for various Data ware housing projects usingInformatica 9.1.0/8.5/8.6/7.1, SAP Business Weaver, EMC Green plum 4.2, Tableau, Netezza 3.6, SSIS, SSRS, SSAS 2008, Oracle, DB2,MS SQL Server 2005Sybase, and Teradata.
• Proficient in data integration between different sources to the EMC Greenplum and Netezza environment and reporting the same on Tableau environment.
• Attending/Training/Implementing on BIG DATA seminars/webinars by Cloudera/Hortonworks and Amazon Web Services training (EC2 & EMR) and involved in designing of Map reduce jobs with Greenplum hadoop system (HDFS).
• Proficiency in architecting/designing the ETL environment, ETL Tools, Data Ware Housing, Reporting environment and their Design & Development using Informatica 9.0.1.
• Proficient in creating ETL, Reporting/ OLAP design/technical documentation, low level/high level mapping documentation from functional specifications.
• Strong Sql query writing skills, and query tuning skills in a VLDB environment.
• Expertise in constructing proper Administrative procedure through well-described system operational procedures, ETL Data Flow diagrams and design documents using MS Visio.
• Experience in enhancing existing database design for new enhancements to meet Tight SLA refreshes, reverse engineering, forward engineering, logical and physical data modeling using ERWINFusion Modelerand ER Studio.
• Experience in Creation ofPL/SQL/T-SQLstored procedures, functions, packages, Sql loader scripts,as part of ETL developments.
• Proficient in design/development of the scheduling tools like Control-M 4.6, Maestro & Autosys.
• StrongData warehousing conceptual/practical knowledge including star schema dimensional modeling, snowflake schema dimensional modeling, Kimball and inman\'s methodologies.
• Experience in designing/buildingcomplexUNIXshellscriptsandPERL Scripts.
• Experience in many Operating systems such asUNIX, AIX, SOLARIS, WINDOWS 2000, and WINDOWS NT.
• Extensively worked on performance tuning ofthe ETL process and SQL optimization on a large database.
• Experience in formulation of test process with Quality Center Management System. Created unit and integration test plans.
• Experience in working with cross-functionalteams. Team player and self-starter.

Profile
More than 8yearsof total work experience providingRetail,Insurance,Banking and Financial, storagesolutions leveragingBusiness System Analysis, Data Architecture,ETL (Extraction, Transformation and Loading) Tools like EMC Greenplum, Informatica, Netezza, SSIS, BusinessIntelligence, process consulting, software development and testing. Keystrengthsincludeproblem-solving skills, people leadership, superior communication, relationship buildingandsolid software development lifecycle skills.

Professional Experience
Currently working at Client site– Confidential,Southborough, MA.
Key projects and Accomplishments
Confidential,Southborough, MA (Nov 2011 till date)

Senior Informatica Lead/Developer – contributing for BIaaS (Business Intelligence as a Service). This project is very similar to that of the existing Amazon Web services (using EC2 & EMR). Thisprojectinvolves the migration of the masterdata, sales and revenue data from the Oracle systems to the new EMC Greenplum systems. The Business Intelligence as Service (BIaaS) project constitutes the provisioning of the data hosting, data reporting and data analytics as a service for a specific period of time. The source data is a combination of the Generic Data Warehouse data (already existing in Oracle) and the SAP Business Weaver data.

The EMC BIaaS project consists of a number of challenges that are unique to traditional ETL / BI development. The initial/future implementation of this endeavor consists of a number of “proof of concept” iterations that will load data from existing EMC DW/SAP BW sources(Customer, product, sales, revenue, finance data) into the central repository, which is a Greenplum MPP database. EMC Greenplum is a new technology that exists in the same technical space with Teradata, Netezza, and other MPP platforms. As an MPP application, its greatest feature is the ability to perform fast searches across large data spaces. In order to meet performance requirements for this project, high-speed methods of data loading are developed and an overall framework are implemented and published.
Key responsibilities

• Responsible for gathering the business requirements for the Initial PoCs to load the enterprise data warehouse data to Greenplum databases.
• Contributed in creation of the BRD/functional and technical design document after having multiple sessions with business users team.
• Responsible for architecting/designing the ETL framework for the Proof of concepts from different GDW/SAP BW data sources to Greenplum database/sandbox.
• Responsible for analysis of the load strategies and number of records in the source and designed/developed the Informatica mappings/workflows with Informatica connectors to Greenplum (PowerExchange for Greenplum connector).
• Worked on designing/developing the Control-M jobs based on the dependencies for GDW/SAP BW data.
• Involved in creating the greenplum framework on the security model, data layer and schema creations.
• Involved in the creation of Greenplum functions and views for the customer use, both on the Hub level and the Spoke level.
• Actively involved with Greenplum DBAs for loading of GP data along with query performances and standard metric processes.

Environment: Informatica Power Center 9.0.1, EMC Greenplum 4.2, Tableau, SAS, Oracle 10i/11g, Control-M 4.6, DB2, MS Sharepoint, QC Defect Tracking system, AR process, UNIX, AIX.
Key projects and Accomplishments
Confidential,Boston, MA (Mar 2011 till Nov 2012)

Informatica Senior Developer/Lead – contributing for the IPM (Integrated Provider Management System). Thisprojectinvolves the migration of the provider data from the legacy systems to the new Portico Systems. The Integrated Provider Management (IPM) refers to the tools, applications, methodology and strategy used to re-architect how the corporation stores, utilizes, and accesses provider information. Portico systems will be leveraged to support IPM.

Portico Systems offers health plans enterprise-class software solutions built exclusively to support end-to-end Provider Network Operations. Since 1997, Portico Systems has been enabling payers to streamline their Provider business processes. Portico Systems leverages a unique blend of healthcare operations experience, payer/Provider relationship expertise and technology skills to build holistic solutions engineered for the primary purpose of managing Provider Network Operations. Portico Platform solutions improve processing accuracy, reduce costs and enhance Provider satisfaction by impacting a core area of health plan functionality.
Key responsibilities

• Working on with multiple business users on understanding the whole Legacy Systems such as RTMS/HURON/NETWORK PRO and Provider Credentialing databases
• Responsible for collecting the business requirements for the Initial load from Legacy systems (provider data) and loading it into the Portico Systems and also from Portico to Legacy through Proxy.
• Involving actively in requirement analysis, business requirement, detailed analysis and design sessions of various phases of the project and contributing to the business and stakeholders.
• Involving also in the functional and technical design document sessions with Technical team and business users team.
• Actively involved in acquiring training on the Portico 8.0/9.0 versions of Provider Manager and Business Administrator modules of Portico.
• Working on the Data Analyser, Data Quality and data profiler tool for handling the business logic and exception logic from the inbound feeds and also the outbound feeds.

Environment: Informatica Power Center 9.0.1/8.6, MS OFFICE/VISIO 2007, COGNOS, SAS, Oracle 11g, DB2, MS Sharepoint, QC Defect Tracking system, AR process, UNIX, AIX.
Confidential,Dallas, TX (Mar 2010 till Jan 2011)

Informatica Senior Developer/Lead – contributing for the OMNI (Order Management Initiative) – Reporting datawarehouse project. Thisprojectinvolved processing the Sterling OLTP (Sterling Transactional system) and transforming with respective business logic for reporting purposes. The target databases were DB2 and Oracle. This system had multiple interfaces like COES, INET (Internet orders) and COFS systems that sent multiple feeds to come in OMNI Reporting and the DODS (Data Operational Data Store) was populated with the same. The DODS data is then loaded to a STAR schema for OBIEE advanced reporting purposes.
Key responsibilities

• Involved in structuring and designing the DODS database models and Star schema for the new Client requirements for NOC Telemarketing extracts, jQuery extracts and DOSR (Daily Order Status Report) extract.
• Worked with multiple business users on understanding the whole Sterling order management process of different phases or orders from Creation till the release to shipment steps that helped in flexible design of OMNI Reporting project.
• Responsible for designing and implementingthe ETL process from multiple Sterling to multiple Staging tables and then to respective DODS tablesin Informatica 8.5.1/8.6 along with Informatica Power Exchange.
• Involved in working on the Data Analyser, Data Quality and data profiler tool for handling the business logic and exception logic from the inbound feeds and also the outbound feeds.
• Created and managed multiple UNIX shell & Perl scripts that involve handling Telemarketing daily orders, DOSR (Daily order status) and jQuery extracts, along with their ESP schedules.
• Responsible for creating, testing and deploying multiple ESP (External Scheduling processor) schedules in development, testing and production mainframe boxes.
• Contributed to the advanced partitioning and index methods on Oracle database structures in production and testing environment.
• Involved in handling the defects through the Quality Center Defect Management system and also Action Remedy (AR) system for DEV/TEST/PROD issues.
• Created multiple standard and how-to documents for Informatica/UNIX shell and Mainframe activities to be handled on a daily basis and uploaded to sharepoint.
• Involved in Performance tuning of multiple Informatica mappings to improve performance as the volume of Internet orders entered the system on a daily basis. The factors involved were PDO (Push down optimization), bulk loading and also adding indexes on the staging tables.

Environment: Informatica Power Center 8.6.1/8.5, OBIEE, SAS, Oracle 10g, DB2, MS Sharepoint, QC Defect Tracking system, AR process, UNIX, AIX.
Confidential,Kansas city, MO (May 2009 till Mar 2010)

ETLSenior Developer, SSIS/SSRS Tech Lead– while contributing for the survey datawarehousing developed for 150 different retail clients such as Starbucks, JC Penney etc
Thisprojectinvolved migration of calls and survey related data from legacy SQL server systems to 3rd Normalized form database and then moving the data into Netezza for extremely faster and reliable performance.
Key responsibilities

• Designed and formulated3rd Normalized databasein SQL SERVER 2005/2008.
• Developed database diagrams for3NF database and had frequent meetings with Business Analysts, System architect and Client servicesteam to establish the design accuracy and maintainability.
• GeneratedT-SQL scripts to create 3NFdatabasein SQL Server 2005/08and the respective 3NF tables in the system. Added appropriate clustered and non-clustered indexes on the 3NF tables.
• Designedstored procedureswithdynamic T-SQLs, temp tables and table variablesfor reading data for different tables and made it as a generic oneto read data fromlegacy CALLS tablesand load into 3NF tables.
• Responsible for designing and implementing150 ETL packagesin Informatica 8.5, databases and their respective tables for 150 different Clients to movedata from legacy transactional database to 3NFSql serverdatabase.
• Contributed in writing storedproceduresandInformatica8.5packagesto move data from 3NF tables toNetezza5.0tables.
• Responsible forscheduling, maintaining and deploying 150 SQL server schedulesand jobs on the development, testing and production boxes.Created stored procs and ETL packages to move the scheduled jobs in development to testing and production box.
• Designed generic scripts to create 150 different staging and production databasesinNetezza5.0and population of tables in Netezza5.0with performance Monitoring.
• Contributed increating the XML query datasets,defining data source and for the reportsandusingglobal variables, expressions and functionsfor the reports usingSSRS2008.
• DevelopedTabular,Drill Down, and Parameterized, cascaded and sub-reportsusingSSRS.
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDFand Excel formats usingSSRS 2008.

Environment: Informatica Power Center 8.6.1/7.1, SQL SERVER 2005/2008, SSRS, MS Visual Studio 2008, C#, .NET, SSRS 2008, Netezza 5.1, WinSQL, UNIX, AIX.

Metlife Insurance –Edison, NJ (Mar 2009 till May 2009)

ETLSenior Developer, Informatica Tech Lead,Business Analyst– while contributing for the Insurance and Mortgage project for Metlife Insurance Inc.
Key responsibilities

• Contributed as a ETL tech Leadfor the Data WarehousingProject that involved thedesign,analysisofEnhancements to theDatawarehouseofMetlife Insurance and Mortgages project.
• Involved in the complete design and modeling of small business Insurance databases in SQL server 2008.
• Contributed to the detailed study of the existing datawarehousingmodelthat was completely handled inSQL SERVER2005/2008STORED PROCSand to the documentation formigration from STORED PROCS to Informatica mappings.
• Worked on designing and analyzing the ETL requirements forInformatica8.5.1. Helped the ETL developers in thecoding and testing phaseand processes.
• Contributed to the development ofETLcomplex mappingsincludingjoiner, sorter, router, aggregator, union, lookup and filter transformationsetc. involving facts/dimension tables,usingInformatica Power Center8.1.1(PowerExchange,Power Center Repository Manager, Power Center Designer, Power Center Workflow Manager, Power Center Change Data Capture, Power Center Workflow Monitor)
• Involved in alltheETL data architecture process such asdata loading,scheduling,re-start abilityand the execution of around40workflowsand sessions which involved thefacts and dimension datainto the datawarehouse.
• Developed a number ofstored procedures, triggers, SQL(in Oracle and MS SQL Server 2005/2008) andUNIX Korn shellandPerl scriptsfor the business logic and the interface betweenUNIX, AIXand Informatica.

Environment: Informatica Power Center 8.6.1/7.1, SQL SERVER 2005/2008, SQL Navigator, SQL, PL/SQL, star Schema, Snowflake Schema, UNIX, AIX.

Education
Bachelor of Engineering
Electrical and Electronics