Experience Summary:

• 7.7 years of working experience in end to end business solution software development involving Enterprise Data Integration, Business Intelligence, Enterprise Data Warehouse EDW , ETL, Data Mining DM , Online Analytical Processing OLAP , Online Transactional processing OLTP , Analytic workspace, Data Marts, Data Integration and Analytics DIA and Business Reporting across financial, pharmaceutical and travel and hospitality vertical involving systems across Level 3, Level 3.x, level 4 within S-95 architecture.
• Smoothen the compliance of the regularities imposed/enforced by Securities Exchange Board and to provide a platform for trading over securities in money and dept market Equity, Index, derivatives, futures, Options, Forex, Bonds and Debentures across Stock Markets.
• End to End implementation of DWH solutions LORS , GMARS , ViCoM , GLIMS, DSI, MDI , HIT
• Worked across various projects as an architect for data warehousing, dimensional modelling needed for the development of the customised propriety solutions for OLAP, Multi-Dimensional Online Analytical Processing.
• Extensive experience in interacting with business users, business owners for requirements gathering, analysing business process and making necessary changes from the enterprise data integration to the DWH to fulfil reporting/end users needs.
• Experience in architecting and developing/enhancing/migrating Universes for major cGMP projects, Retrieving data using Universes, Personal data files, stored procedures and Freehand SQL methods.
• Posses' extensive working experience in Data Integration and Analytics, application of ETL, Data Mining, Business Intelligence and Data Warehousing concepts across business solutions.
• Worked as an architect for the manufacturing OSSCE Enterprise Data integration and Analytics across SCM Supply Chain Management right from the Procurement to Sales and Delivery, involving OTIF Delivery, SOP, ROP, Master Production Schedule, MRP, CRP, Supply Chain Relationship, Inventory, Cycle Time, Data Quality, Shop Floor Control, etc.
• Simplify definition and modification of software rules in accordance to the business requirements using ETL engine concept of mapping, extraction, movement, transformation, cleansing, load, incremental aggregation, pipeline dynamic and cache partitioning for the development and optimization of the solution.
• Writing complex SQL queries for Mining and analysis of source data for the purpose of solution analysis and optimization.
• Expertise in creating canned /Ad Hoc Reports, Dashboards, Charts, Graphs having highly complex business logic with improved performance using Business Objects, Web Intelligence and Crystal Reports.
• Involved in continual process improvement activity, worked finding out ways to improve the process performance, flexibility and responsiveness to produce and approve a product with reducing working capital resulting in high customer service.
• Building Data warehouse with requirement specific accurate data. Very large databases VLDB for Online analytical processing OLAP - Star and Snow flake schema design and administration.
• Identification of materialized views and holistic warehouse tuning using agile replication for pre-summarization and aggregation.
• Skilled working and expertise knowledge of ETL and supporting tools like Informatica client tool Administration Console, Repository Manager, Designer, Workflow Manager, and Workflow Monitor , etc.
• Involved in performance improvement and data synchronization/profiling for universes and reports for correct mapping of the objects and data correctness.
• Skilled working knowledge on procedural Data base language PL/SQL, LINUX/UNIX shell, Perl Scripting.
• Analyse the requirements and develop detailed specifications BRD Business Requirement Document for development of modules as per Change Management Procedure.
• Conceptualising and visualizing the integrating data sources for the extraction of the measures describing common aspects of the business.
• Performance tuning through optimization of sources, staging, targets, transformation, grid ,etc.
• Working with sites for the stabilization and acceptance of the solution.
• System Release Management.
• System Outage Management.
• Repository organization and migration.
• Performing Impact analysis and sending Notifications to all stakeholders in case of issues.
• Active team player and as an individual with Excellent Communication, Interpersonal skills, self-motivated fast learner and good listener.
• Software Testing including Unit, System and Integration Testing, Test case/data preparation, execution and verification of the test results using Quality Centre.
• Performing walkthroughs inspections as per standards.
• Maintaining all the standards, design documentation.

Internal Trainings:

• Six Sigma
• BEM Business Excellence Model
• ISO 14001 Environment Policies, IPMS, IQMS, Security Awareness
• Statistical Process Control SPC
• MSBI

PROFESSIONAL EXPERIENCE

Confidential

• Wyndham Exchange Rentals, part of the Wyndham Worldwide family of companies NYSE: WYN , is the worldwide leader in vacation exchange and the European leader in vacation rentals, with access for specified periods to more than 80,000 vacation properties in approximately 100 countries.
• The Enterprise Data Warehouse EDW /HIT is the centralized repository where all historical and current data is located and stored. It contains the raw material that can be used by data analysts and decision support systems to perform complex analysis such as data mining.
• The EDW stores a copy of the loyalty member database handled by the loyalty system. This copy is being updated incrementally. It was reported that this synchronization process was not bulletproof and that differences persist between EDW and LOLA.
• Besides being a historical storage location, the EDW performs certain operations, such as the proactive match, in regard to the loyalty program. The EDW receives hotel stay information of powered up properties on a nightly basis. For hotel stay files, that are not associated to a loyalty member, the system will try to match the consumer/guest information with the loyalty member account information stored in the EDW. When a match is found, the system will inform the loyalty system to credit points to the member account for the hotel stay.

Role: Systems Analyst from BRD to IQ/OQ and Product stabilization

Responsibilities

• Successful implementation of Right Rate, Acxiom Digital and Fee Credit Waiver BI Solution.
• Responsible for analytics requirements analysis reporting data assessment design and development of analytic data sets data extract, transform, and load ETL from relational databases analysis and handling of data outliers implementation of Informatica processes to deliver data into Data mart, maintenance and tuning of ETL processes, documentation of all activities. Primary deliverable would include Data Analysis, Design, and Development of ETL applications using Informatica Power Center.
• Perform data analysis to gain an understating of how the business uses the data.
• Formulation of complex SQL queries for identification of statistics across billing process, member process and stay process.
• Development of mappings, sessions workflows using ETL tool Informatica Power Center to transform data from multiple sources including flat files, DB2, Oracle and Informix relational sources. Create Stored Procedures and optimization scripts. Error Handing.
• Created shell scripts for the creation of the data files, sending CSV generated report automatically to the users, decrypting and encrypting pgp files to and from landing area to the external SFTP server.
• Provide expertise in developing technical solutions aligned to departmental strategy and vision. This involves getting involved in requirement gathering, analysis, and design and development process.
• Logical Modelling involving creation of the star and snowflake schema, by identifying different facts/Measure and Dimensions. Data flow logical entities, data associations and key attributes. Conversion of Logical Model in Physical model involving creation of table structures. Database tuning.
• Web service access of the data reports using Informatica.
• Document the application development process following AIM guidelines in preparing DDD.
• Performance tuning of sources, mappings, targets and sessions through partitioning.
• Interact with business users to answer questions and understand reporting needs.
• End user training.

Environment: Informatica 9, DB2, WINSCP, MS-SQL Server 2005 ,Informatica IDE, Informatica Metadata Manager, Aqua Data Studio 4.7, Oracle, Windows 2003 Server, SQL Developer, Quest Central for DB2 v5.0.

Confidential

• Confidential is the Confidential headquarters of Tokyo-based DAIICHI SANKYO, COMPANY, LTD. DSI is a member of the Daiichi Sankyo Group, which spans 56 countries. DSI's primary concentrations were in Cardiovascular and metabolic therapies including a wide range of treatments for hypertension and heart disease, diabetes and hyperlipidemia.
• DSI's Sales Marketing division leverages two data marts Sales Mart SM Catalyst hosted by Dendrite and ZS respectively, Dendrite also hosts ODS to address the extract requirements. There are few challenges in the existing system like no unified view due to data silos, Sub-optimal performance and lack of flexibility in time to market, Limited functionalities, Higher costs for changes, etc.
• The DSI enterprise data warehouse EDW focus on Replicate data from the hosted ZS Catalyst to EDW and Leverage the Netezza platform to improve user experience with respect to Reporting. Once in production, DSI IT, power users, end-users, and vendor partners will be able to create all types of views and functions.

Role: ETL Lead

Responsibilities

• SME for entire life cycle development of DSI EDW.
• Detailed analysis of the BRD and transformation of the business rules in technical specifications. Develop detailed specifications for development of modules as per Change Management Procedure.
• Identification of different discrete data sources for the purpose of data integration and breaking it into subject areas for the purpose of integration of the Data into warehouse IMS-RX,IMS-DDD,IMS-HCOS,SAP,NP,SOPS,FF
• Formulation of complex SQL queries PLSQL packages for identification of statistics , report generation across sales and marketing data.
• Created shell scripts for the creation of the data files from the XML,CSV and place them in the landing area.
• Logical Modelling involving creation of the star and snowflake schema, by identifying different facts/Measure and Dimensions. Data flow logical entities, data associations and key attributes.
• Transforming the Logical model into the Implementation of the Physical Model viz Data warehouse. Physical data modelling involved defining the overall topology of the physical data warehouse, physical storage and partitioning allocations.

• Design complex ETL mappings using informatica for purpose of extraction of required data from the different discrete sources, transformation of the data applying business rules specified in the BRD/SRS, cleansing and loading in Target Data Warehouse.
• Netezza procedures for the complex lookups, evaluation of different cycle times and business days conversion while adjusting the dates based on the cycle, tolerance ,etc
• Define and maintain Enterprise framework and firm standards for ETL processes

• Manage Data Mapping, transformations from source system to the Data Warehouse Environment. Analyse the data to find out data inconsistency and anomalies.
• Manage reporting Meta data and data standardization for end to end integration
• Coordinating with development team.
• Unit, system and integration testing, test case / data preparation, execution and verification of the test results using Quality Centre.

End user training.

Environment: Informatica 9, DB2, WINSCP, MS-SQL Server 2005 ,Informatica IDE, Informatica Metadata Manager, Aqua Data Studio 4.7, Oracle, Windows 2003 Server, SQL Developer, Quest Central for DB2 v5.0, Tidal , Citrix Client, Informix, Remedy Action Request System User, CVS , MSTSC , Sybase Power Designer.

Confidential

MDI, LORS, GMARS, GLIMS, ViCoM are level 3 system designed to ensure that global supply chain requirements are met via a solution that is replicable locally to manufacturing sites. The solution will support Quality Control Laboratories QCL by transforming data into reports that are utilized to obtain OSSCE metrics. The reports generated from the system are required for regulated activities and the system is GMP validated. Sites generate the reports that are required by the FDA/External auditors/Lab Managers for evaluation and sustainment of site Class A OSSCE certification. Development of a EDW will bring integration of data form heterogeneous sources, enabling business to get the inside view of the mutli-dimension enterprise data that reflect the true dimensionality of the organisation and will help in quick business taking and have a significant improvement on the Lilly global supply chain management.

Role: IT Analyst

Responsibilities

• POC and SME for entire life cycle development of EDW LORS, GMARS, GLIMS, ViCoM Solution.
• Detailed analysis of the information regarding various OSSCE measures that the sites generate across various business areas in SCM as needed by the users. Breaking down into different subject areas that the users can relate to in their business terms. Creation of BRD/SRS.
• Identification of different discrete data sources for the purpose of data integration and breaking it into subject areas for the purpose of integration of the Data into warehouse of the pharmaceutical related production, manufacturing and lab result critical data along with the discrete Lab systems like Darwin, LIMS Laboratory information management system and SAP in developing an end-to-end GMP business solution.
• Logical Modelling involving creation of the star and snowflake schema, by identifying different facts/Measure and Dimensions. Data flow logical entities, data associations and key attributes.
• Transforming the Logical model into the Implementation of the Physical Model viz Data warehouse. Physical data modelling involved defining the overall topology of the physical data warehouse, physical storage and partitioning allocations, indexing, etc.

• Design complex ETL mappings using informatica for purpose of extraction of required data from the different discrete sources, transformation of the data applying business rules specified in the BRD/SRS, cleansing and loading in Target Data Warehouse.
• Writing Complex SQL for the purpose of analysis for proposing different ways of solutions.
• Developing Shell scripts for the archival and retention of the log file generated, notifying by automated email generation and Trouble Ticket creation in an event of failure.
• PL/SQL procedures and SQL queries for the complex lookups, evaluation of different cycle times and business days conversion while adjusting the dates based on the cycle, tolerance, etc.
• Addressing the need of making model to integrate multisite Level 3 data in a single data warehouse enabling row level security.
• Developed shell scripts to kick of the Ada Rec system to formulate the COBOL files into the landing area.
• Define and maintain Enterprise framework and firm standards for ETL processes
• Manage Data Mapping, transformations from source system to the Data Warehouse Environment. Analyse the data to find out data inconsistency and anomalies.
• Architect and develop Universes based on the business subject areas to enable Adhoc report generation.
• Developing a .Net based MDE tool for GmP Config data entry.
• Developed 23 Business OSSCE Canned Reports to represent different OSSCE information across SCM using BOXI r2.

• Software Testing including Unit, System and Integration Testing, Test case/data preparation, execution and verification of the test results using Quality Centre.

• Ensure the data requirements of the application are effectively addressed in accordance to the BRD/SRS.

• Conceptualising and visualizing the integrating data sources for the extraction of the measures describing common aspects of the business.
• Documentation Data Dictionary, ETL Design, Reporting Design, Universe Design, System Design and Overview, IQ/OQ, DRP, System Configuration and Release Notes.
• Content organization, migration and Deployment from DEV to TST to PRD.
• System Release Management.
• Working with sites for the stabilization and acceptance of the solution.
• System Outage Management.
• Performing Impact analysis and sending Notifications to all stakeholders in case of issues.
• Coordinating with offshore team.

Environment: Informatica 8.6 , Business Objects BOXI r2, Web Intelligence, Infoview, Crystal Reports, PL/SQL, LINUX Shell Scripting, Oracle 11g, MS Visual Studio2005, Citrix Client, TOAD 8.6.1.0, Remedy Action Request System User, Rational ClearCase, Reflection for Unix and Digital, ERWIN ,SSH Secure Client Shell, Autosys, Putty and Regulus

Confidential

• The Company is linked to various offices all around the world and also to its Clinics, manufacturing sites, research center and other Business Partners. The sole purpose of MICS CoE is to provide support and enhancement to all forty-six applications used by the client. The Manufacturing Information and Control Systems organization develops and supports the computer and automation systems used to run manufacturing and laboratory equipment.
• Prior to formation of MI CS CoE, separate teams working with little or no interaction were managing support and maintenance of these applications. To help realize this opportunity MI CS CoE has chosen TCS as an External Service Provider ESP to support the applications in its portfolio keeping in mind the Number of applications 45 , Wide range of technologies 35 , Nature of support 24x7 and cGMP regulation compliance.
• The sole purpose of Regulatory IT is to provide Tier-2 and Tier-3 development and support to the Lilly Support System LSS application used by the client.

Role: System Developer

Responsibilities

• Analyse the requirements and develop detailed specifications for development/up gradation of modules as per Change Management Procedure.
• Writing complex SQL queries for the mining and analysis of production data and process for the purpose of process performance analysis and optimization.
• Created shell scripts for the data retention and archival across data ware house components non- business data, processed business staging data, data purging .
• Development lead for the RTMS and Elanco Subscription.
• System Outage Management.
• System Release Management.
• Performing Impact analysis and sending Notifications to all stakeholders in case of issues.
• Enhancement of Application depending on business requirements.
• Resolving DWH stabilization issues enabling client to make strategic business decisions without significant delays.
• Working on Change Requests raised by the customer as well as proactively identifying areas of change.
• Coordinating with onsite team.
• Managing System and Data Change Requests.

Environment: Informatica 8.6 , Business Objects BOXI r2, Web Intelligence, Infoview, Crystal Reports, PL/SQL, LINUX Shell Scripting, Oracle 11g, MS Visual Studio2005, Citrix Client, TOAD 8.6.1.0, Remedy Action Request System User, Rational ClearCase, Reflection for Unix and Digital, ERWIN ,SSH Secure Client Shell, Autosys, Putty and Regulus

Confidential

The Client is linked to various sub-Brokers. The main objective of the eIBS is to smoothen the compliance of the regularities imposed/enforced by Securities Exchange Board and to provide a platform for trading over securities in money and dept market Equity, Index, derivatives, futures, Options, Forex, Bonds and Debentures across Stock Markets. Provision to trade in Primary Market IPO's , secondary market, bullion and in the metal market and commodities. As Securities Exchange Board continuously works in amendment of regularity policies the Brokerage system needs to be updated as and when needed. This helps the Company to focus more in the market and removes overhead of the system and it compliance with the Securities Exchange Board.

Role: System Developer

Responsibilities

• First Point of Contact for the RMS Risk Management System module.
• Client site interaction to understand Environment and Functional aspect of RMS.
• Providing real time support during the market and non-market hours for RMS.
• Developing new declared by SEBI and modifying enforced by SEBI existing components of the system in compliance with the SEBI for RMS.
• Validating the RMS report output.
• Performing RMS System SOD Start of Day before the market Opens for trading.
• Performing RMS System EOD End of Day after market closes for the day.
• Writing Shell scripts to kick of the SOD and EOD processes for RMS,TWS,OWS.
• Analysis of production data by writing complex SQL queries to identify and locate the mismatch from the trade file and the system file.
• Developer of the International eIBS system to trade across countries across markets across currencies.
• First Point of Contact for the OWS Operator Work Station module and TWS Trader Work Station .
• Client site interaction to understand Environment and Functional aspect of requirements for the International eIBS system.
• Providing real time support during the market and non-market hours for OWS and TWS.
• Developing new declared by SEBI and modifying enforced by SEBI existing components of the system in compliance with the SEBI for OWS and TWS.
• Validating the OWS and TWS report output.
• Performing OWS and TWS System SOD Start of Day before the market Opens for trading.
• Performing OWS and TWS System EOD End of Day after market closes for the day.
• Writing data definitions for OWS and TWS.
• Analysis of production data and process for the purpose of process performance analysis and optimization.
• Applications related Issue Tracking Resolution.

Environment: PowerCenter Informatica 8.6, BOXIr2/r3, Oracle 9i and 10g, TOAD 8.6.1.0 MS-Visual Source Safe, MS-Visual Studio, Rational ClearCase , Cronjob Schedular