Development, Support, Automation, Analytics & Reporting

Handling two projects of Development & Production Support Teams as Lead Analyst with 20+ team members.

Working on Business & Impact Analysis, Data Modeling, Database structures, ETL Designing, Development, Deployment, Reporting, Shell Scripting, Performance Tuning, Incident Management, Resource & People Management and Procurement management

Responsible on 14 applications of Commercial & Investment Banking Data management projects on their Development, L2/L3 Production Support & Maintenance, Data processing, Performance Tuning, Database Tuning, Break fixes, DR Sync & BC Events and daily Data loads monitoring of all the applications.

Worked on the data deals with Home sites, Opportunities, Contacts and other data flows from multiple application servers to SQL server DB and SFDC with synchronizing its business processes. Worked as data architect on data migration and SFDC Data model, creating ICS & ICRT tasks & processes and the process automation using scrum sprints.

AHM is a leading global provider of software and service solutions designed to manage compliant interactions with healthcare professionals (HCPs). Analyzing the data complexity of different feeds fetching from CRM source systems. Designing, developing the mappings and workflows using Informatica Cloud. Dealing with different data from CRM systems like Customer, Account and Sales data and configuring the SFDC changes according the requirements using scrum methodology.

Blue Shield of California (BSC) is health plan provide and insurance company. Analyzing the requirement specifications and preparing the System Use Cases (SUC) with customer. Preparing the business requirement document (BRD) and technical design document (TDD). Worked on Data model changes and enhancements using tool ER-Win. And worked on all PCI, PHI & PII Policy packs and created several projects, profiles, plans, workflows, domains and data patterns and worked on data masking and data sub setting. Deploying the code in live and monitoring through Tidal jobs. Worked as individual contributor for different projects using agile methodology.

AEGON USA Investment Management, LLC (AUIM) is a part of the AEGON Group. Preparing the dimensional data models. ETL Designing, developing the NIDW data warehouse with understand the functionality of EIDW (Existing DW). Worked on XSD, XML data importing from different Application Servers. Interacting with customer EDM teams on data pulling. Creates the labels to deploy the code and monitoring the daily scheduled jobs. Prepares the RDT & CRF documents on the tasks. Managing resource assignments to projects using agile methodology.

FEDEX-MISA (Management Information System - Archive) is an international clearance archive that retains international shipment data for customs audit purpose for all countries. MISA is a distributed system, designed for historical clearance archival and reporting. Creating design specification. Analysis of existing Informatica System and convert Sybase code to Teradata as per the requirements. Migration and conversion of Informatica mappings from Sybase to Teradata database. Creating scripts for loading data to target data warehouse for BTEQ and Fast Load. Generate Hyperion reports in both Sybase and Teradata sides using scrum & sprint methodologies.

Group Health Cooperative is a Seattle, Washington based nonprofit healthcare organization. Patients who receive care at its medical centers are provided Web access to their medical records. Analysis on International Code for Diseases - ICD 9 migration to ICD 10. impacted mappings and prepared the documented report for the same. Development for HBE (Health Benefit Exchange) table load on creating the Acquisition mappings for populating Teradata tables with Flat files being the sources and then to the Integration layer. Sybase to Teradata Conversion, for the Informatica code being used in Sybase database to Teradata database for the LoBs using agile methodology.

Kronos Incorporated provides hardware instruments and its maintenance and also provides IT solutions based in Boston. Handled the responsibility on offshore deliverables. Interacting with BSAs and prepares physical data models on newly changes with Dimension, Fact tables in existing data models. Prepares Code Release Forms (CRFs) for DEV/QA and also for PROD environments along with the UTRs. Scheduling & Monitoring the Informatica jobs on UC4 in Production environment using sprints & scrum methodologies.

Allstate Investments is an Insurance organization based in Northbrook. The purpose of BIS development project is to load the Derivatives, Equities, Fixed Income, Trade & Positions data into master Data Warehouse (DW) from multiple trade & financial applications like Maximis, Eagle Pace & Aladdin. Also, its a testing implementation phase on Security Master, Transactions (Trade), Positions & e-Link data. Interacting with customer & onsite team on further plans & design to be implemented. Developed complex mappings and few mapplets & reusable transformations instead of using stored procedures. for Security master, Transactions & e-Link. Monitoring the data processing to DW from EAGLE PACE, MAXIMIS & ALADDIN applications. Have taken the ETL testing ownership on Security Master Data testing efforts. Prepared automated queries for Pre-& Post data validations and sub test queries prepared as per requirements.

Allstate Investments is an Insurance organization based in Northbrook. The purpose of R2A development project is to load the Derivatives, Equities & Fixed Income data into MAXIMIS from multiple trade & financial applications like Eagle Pace & Aladdin. Developed complex mappings for Derivatives & Fixed Income data. Analyzing the issues found while data processing and prepares the different approaches for resolutions. Monitoring the data processing on the accounting application servers using agile methodology.

FEDEX-MISA (Management Information System - Archive) is an international clearance archive that retains international shipment data for customs audit purpose for all countries. MISA is a distributed system, designed for historical clearance archival and reporting.

Creating design specification. Analysis of existing Informatica System and convert Sybase code to Teradata as per the requirements. Migration and conversion of Informatica mappings from Sybase to Teradata database. Creating scripts for loading data to target data warehouse for BTEQ and Fast Load. Generate Hyperion reports in both Sybase and Teradata sides using scrum & sprint methodologies.

Hospital Corporation of America (HCA) is the largest private operator of healthcare facilities in the world, base in Nashville, Tennessee. Its a migration project replication of the ETL process of the data warehouses of its different Line of Businesses. Migrating the Informatica workflows into SSIS and the jobs development, testing. Worked on workflows related to Salesforce.com with the development and testing of its Jobs at SSIS and data loading using APEX Data Loader and on multiple databases Teradata, SQL Server, Salesforce.com, DB2 and Oracle. Converted and created shell scripts as per the requirement.

Wyndham Hotel Group, part of the Wyndham Worldwide family of companies (NYSE: WYN). Developing the Informatica mapping and optimizing performance in data load. Involved in creating profiles and reference tables in data quality process, rule mapplets and deployment. Creating Landing tables, Staging tables & Base Objects and developing the cleansing functions using MDM tool. Creating Packages and involved in ETL testing using waterfall methodology.

Credit Suisse provides banking services of Investment banking, Private banking & Asset management and securities products to corporate. Extensively worked Informatica mappings, sessions and workflows and data load monitoring and optimizing performance. Maintaining the IB/AM customer master data using Siperian.

The Objective of the project is to understand and capture the requirements and functionalities for CTG processing of Handsets sold and Returns, Budgets, Quantitative sources, Qualitative sources, Quantitative Targets, Qualitative Targets, Volumes and Margins and Stores that data into Enterprise Integration which is a Relational Database. Developing mappings, sessions and workflows and data load monitoring. Map reporting requirements to BO universes. Designing and tuning the BO reports.

This is a Data warehousing solution for retail industry that mainly deals with consumer products specially related to FMCG products. Creating the stage, Dimensional & fact loading mappings. Developing on change requests as per the defects. Closing the defects with code release & unit test results documentation.

Primus Corporation is one of the leading Companies especially in Consumer goods. This project provides Sales Analysis and Inventory Reports for the Management to take Business Decisions as possible as fast. This project involves for Business like Entertainment, Toiletries, Cosmetics, Sports and Food grains etc. The entire Extraction, Transformation and Loading process has been done by using Informatica. Mappings, Mapplets and Reusable Transformations to facilitate daily loading of Data. Worked on performance tuning of mappings in order to increase the load performance.

The project was undertaken for electronics-based industry. This project is involved in the design and development of Enterprise-wise sales data mart. According to the client requirements the data warehouse system has been developed. This project describes the high-level requirements of the data warehouse system. Design mappings load to Staging area in Oracle database using Informatica 6.2. and creating Unit test cases based on the ETL specification & Involved in ETL documentation.