Experience Summary:

• 7.5 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.
• 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.
• Mining and analysis of source data for the purpose of solution performance analysis, optimization and creation of the target Data warehouse.
• 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.
• Performing walkthroughs inspections as per standards.
• Software Testing including Unit, System and Integration Testing, Test case/data preparation, execution and verification of the test results using Quality Centre.
• Active team player and as an individual with Excellent Communication, Interpersonal skills, self-motivated fast learner and good listener.
• Performing Impact analysis and sending Notifications to all stakeholders in case of issues.
• Repository organization and migration.
• System Outage Management.
• System Release Management.
• Working with sites for the stabilization and acceptance of the solution.
• Performance tuning through optimization of sources, staging, targets, transformation, grid ,etc.
• Conceptualising and visualizing the integrating data sources for the extraction of the measures describing common aspects of the business.
• Analyse the requirements and develop detailed specifications BRD Business Requirement Document for development of modules as per Change Management Procedure.
• Skilled working knowledge on procedural Data base language PL/SQL, LINUX/UNIX shell, Perl Scripting.
• Involved in performance improvement and data synchronization/profiling for universes and reports for correct mapping of the objects and data correctness.
• Maintaining all the standards, design documentation.

Technical Skills:

PROFESSIONAL EXPERIENCE

Confidential

Role: Systems Analyst

Responsibilities

• 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
• 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.
• 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.
• Document the application development process following AIM guidelines in preparing DDD.
• Performance tuning of sources, mappings, targets and sessions.
• 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

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
• 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

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.
• Conceptualising and visualizing the integrating data sources for the extraction of the measures describing common aspects of the business.
• Ensure the data requirements of the application are effectively addressed in accordance to the BRD/SRS.
• Software Testing including Unit, System and Integration Testing, Test case/data preparation, execution and verification of the test results using Quality Centre.
• Developed 23 Business OSSCE Canned Reports to represent different OSSCE information across SCM using BOXI r2.
• Developing a .Net based MDE tool for GmP Config data entry.
• Architect and develop Universes based on the business subject areas to enable Adhoc report generation.
• Manage Data Mapping, transformations from source system to the Data Warehouse Environment. Analyse the data to find out data inconsistency and anomalies.
• Define and maintain Enterprise framework and firm standards for ETL processes
• PL/SQL procedures for the complex lookups, evaluation of different cycle times and business days conversion while adjusting the dates based on the cycle, tolerance, etc.
• 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.
• Addressing the need of making model to integrate multisite Level 3 data in a single data warehouse enabling row level security.
• 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.
• 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.
• 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, Putty and Regulus

Confidential

Role: ETL Architect

Responsibilities

• Offshore POC and SME for MDI development/support.
• Analyse the requirements and develop detailed specifications for development/up gradation of modules as per Change Management Procedure.
• Development lead for the RTMS and Elanco Subscription.
• Backup Team Lead for entire EDW-MDI system.
• System Outage Management.
• Data retention and archival across data ware house components non- business data, processed business staging data, data purging .
• 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.
• Analysing the existing system, Mining and analysis of production data and process for the purpose of process performance analysis and optimization.
• 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, Putty and Regulus

Confidential

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 data definitions for RMS.
• Analysis of production data and process for the purpose of process performance analysis and optimization.
• 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