SUMMARY

• 15 years of experience in IT including extensive Functional and Technical expertise in Data Warehousing, Data modelling, Data Profiling, Business Intelligence, Reports Generation, SQL Development and Business Analysis.
• Excellent analytical and interpretation skills
• Skilled in Project Management and team leadership. (PMP Certified)
• Experience applying SDLC framework to align IT to business.
• Good Experience wif global resource development and allocation. 5 years of experience managing Data warehouse teams.
• Worked on variety of roles including Data Architecture, Project Manager and Lead.
• Software: Informatica Power Center (Cloud and standard), IDQ, SAP ECC, R3 and SAP BI, Veeva MDM, Oracle DB, SQL Server DB, Data Vault, Redshift, LINUX and Windows Servers.
• Experience using MS Project.
• Good Business acumen in Finance, Biotech, Supply Chain, Operations, etc.

PROFESSIONAL EXPERIENCE

Data Warehouse Architect

Confidential

Responsibilities:

• Lead projects from requirements gathering and business rules analysis to creating physical database model.
• Liaison wif senior management and business users to meet their Business Intelligence needs.
• Provide and document process, procedures, policies and standards for data warehouse implementations.
• Responsible for project planning, scope management, resource estimation, metrics definition, change control process, define data quality process and standards, verification and validation.
• Designed Architecture for Informatica Implementation.
• Manage projects in breaking down the existing EDW to manageable Data Marts.
• Responsible for mentoring business and developers on projects.
• Responsible for Data Modelling, Architecture, Production Support and migration to Informatica.
• Hands on Informatica Development, Business Objects, Cognos, Crystal Reports, Unix Scripts Development.
• Schedule Batches using Enterprise scheduling applications such as Active Batch, Autosys, Maestro, Cron, etc.

Confidential

Environment: Informatica 9.6.1 HotFix4, Oracle 11g/12c, Active Batch Scheduling tool, Linux, Jira, ERWIN, Veeva CRM, Veeva MDM, Salesforce, Workday, etc.

Responsibilities:

• Design data warehouse from requirements gathering to conceptualization to creation of data marts using Inmon, Kimball and data vault methodologies.
• Lead projects at various stages from requirements gathering and business rules analysis to creating physical database model, Informatica / PL - SQL development, Unix Scripting, scheduling and Reporting.
• Manage and improvised existing Enterprise Data Warehouse
• Instrumental in creating process, procedures, policies and standards for data warehouse implementation.
• Creating/ Managing the project plan, task allocation, work wif stake holders and PMO office for achieving project goals in an agile work environment
• Responsible for project planning, scope management, resource estimation, metrics definition, change control process, define data quality process and standards, verification and validation.
• Designed architecture for Informatica implementation and created data models.
• Co-ordinate wif business owners, DBAs, reporting team to address system improvements.
• Managed the project in breaking down the existing EDW to manageable data marts.
• Mentored individuals from business and technical stand point.
• Instrumental in creating an in-house tool for meta data and data governance for quality purposes.
• Responsible for Data Modelling, Architecture and Production support.
• Developed inhouse code migration methods and version control for platform support teams.
• Hands on Informatica development and production support of around 32 data marts and the Enterprise Data Warehouse, Meta data and Universe creation for reporting.

Confidential

Environment: Informatica Power Center 9.1.0, Oracle 11g/12c, Hobsons (MS SQL Server 2012), Tableau, Solaris / Red Hat Linux 6, Toad, Maestro, Apply Yourself, Oracle EBS.

Responsibilities:

• Responsible for designing and overseeing of Data Warehousing solutions using Informatica as the ETL tool and Oracle as the Database. Develop large scale Business Intelligence/data strategy for clients to achieve long term corporate goals.
• Co-ordinate wif business owners, DBAs, reporting team to address system improvements.
• Understand existing source system and analyze the data required to be loaded to the datawarehouse.
• Analyze short term and long term Datawarehouse strategies and assist team during planning phase.
• Manage end-user business intelligences, Data Convergence designs and ensure data is balanced across system landscape.
• Responsible on analyzing Source Systems and ODS data to ensure Data Quality of overall Datawarehouse.
• Provide guidance to developers on Informatica Best Practices.
• Assist wif Installation and administration of Informatica Power Center on Linux.
• Develop Technical Design Documents as per DWH requirements.
• Assist DBA on configuration settings.
• Responsible for mentoring business and developers on projects.
• Ensure control of SDLC on ETL related objects.

Confidential

Environment: Informatica Power Center 9.6.1, Oracle 11g, Barclay’s POINT 8.5.1 (XML source), AWS S3, Redshift, Spark, Windows Server 2008 R2, Toad, Maestro.

• Responsible for design and Architecture of Risk attribution reporting solution.
• Designed high level ETL flow of the entire system.
• Provide guidance to software developers on ETL design and logic.
• Co-ordinate wif business owners, DBAs, reporting team to address system improvements.
• Understand the Barclay’s Point data elements and ensure the data model meets the software requirements.
• Ensure team follows procedures and policies for entire application development.
• Provide technical documentation on projects.
• Analyze short term and long term Datawarehouse strategies and assist team during planning phase.

Manager Analytics

Confidential

Responsibilities:

• Build strategies around the supply chain organization and use latest technologies to increase
• efficiency and reduce costs.
• Managing end-user business intelligence (SAP BW) needs for the Shared Business Services (SBS) Supply Chain organization.
• Responsible for centralizing 97% of MWV’s global procurement transactions data residing in over 20 different source systems across North America, South America (Brazil) and Europe.
• Develop Reports using BI Application - SAP BW.
• Manage team of Business Analysts and Developers to meet Organizations end goals.
• Work wif Global IT and functional teams identify Business needs, gather Requirements,
• identify Costs involved and meet Timelines.
• Development of reporting and analysis needs across multiple source systems - SAP,
• releases R3 4.6c and ECC6.0, Business Warehouse (BW), releases 3.5 and 7.0, Confidential Travel Vision (MTV), Cost Reduction Initiatives Tracking Database.
• Develop Queries and Workbooks using BEX analyzer - using filters, conditions, exceptions, variables, calculated key figures, restricted key figures, navigational attributes and BEX browser.
• Support global data convergence strategy through ETL (Using Informatica Power Center releases 6, 7.1.3 and 8.6.1) process development and minimize failure points wifin current processes.
• Good understanding of Supply chain processes like P2P, O2C, Supply Chain network Modeling, Logistics, etc.
• Work wif primary user and support teams, (Global Business Services, Business Warehouse) to implement improved processes in support of Supply Chain strategy and initiatives. Worked wif our IT vendors to support ETL Go-Live.
• Work wif other key teams on Architecture and overall Integration of Data.

Specialist

Confidential

Responsibilities:

• Involved in Supporting BI and ETL Applications production jobs and changing existing code based on business needs.
• Involved in Analysis and translate functional specifications and change requests into technical specifications.
• Develop SQL queries, triggers and procedures using Query Management Facility (QMF) DB2.
• Automate and improve Business processes using existing technologies.
• Manage master data / dimension for being used in Data Warehouse reporting.
• Scheduling jobs, creation of users and Administration of DW.

ETL - Developer

Confidential

Responsibilities:

• Involved in extracting source data from different files and developed mappings by using Informatica designer and also involved in debugging of mappings and unit testing.
• Involved in developing Data Warehouse using Star schema.
• Created repositories using Informatica Repository Manager.
• Analyzed requirements, functional specifications and the source data to be moved to the Data Warehouse.
• Developed SQL join queries for better performance and PL/SQL stored procedures for loading data into data warehouse.
• Configured the sessions to load data from various heterogeneous sources.
• Worked on pre-session and post-session settings and file list generation.
• Developed work flow diagrams and worked wif technical specifications.
• Involved in Performance tuning for mappings and sessions
• Defined the program specifications for the data migration programs, as well as the necessary test plans used to ensure the successful execution of the data loading processes.
• Involved in developing the mapping, which contains all the Lookups used by all the facts to improve performance.
• Used Server Manager for Creating, Validating, Testing and running the sequential and concurrent Sessions and scheduling them to run at specified time.
• Involved in error checking and testing of ETL procedures and programs in Informatica session log.