SUMMARY:

Senior IT Professional with experience managing projects and executing Analytics, Data Warehousing, Business Intelligence, Data Architecture, Master Data Management, Data Integration and CRM initiatives. Exceptional at translating business needs and envisioning bigger picture to convert into tangible solutions. Delivered strategic and tactical projects, managed support & maintenance operations.Technical Competencies

PROFESSIONAL EXPERIENCE:

Confidential

Business Intelligence & Analytics

Responsibilities:

• Interfaced with internal customers and partnered with the client teams for gathering requirements and realizing appropriate solutions.
• Executed project management activities for multiple projects, including -
• Built business case and estimated budgets
• Delivered project scope documents
• Worked with business partners for gathering requirements
• Onboarded employee and contractor resources
• Broke down work to appropriate team and individual tasks, and built project plans
• Provided timely and efficient project status reports with appropriate risk mitigation highlights
• Managed schedule and cost of the projects
• Managed team members
• Managed technology evaluation projects including MicroStrategy, Informatica ETL and Informatica MDM, IBM Netezza
• Executed migration project for migrating in house data warehouse to AWS cloud based on reporting solution. Set up AWS S3 for housing source data as a staging layer. Leveraged AWS EMR and AWS Spark for data processing. Enabled single sign on leveraging Okta. Provided analytics via Tableau. Integrated data such as prescriptions, sales, customer, calls and samples for providing a wide range of decision support capabilities.
• Envisioned and built a Data Lake platform on AWS S3 for storing data in native formats and enabling ad hoc access for Data Scientists. Archived prescriber interaction data from around 20 source platforms on AWS S3 with structured access via AWS Athena, thereby enabling easy retrieval of data and adhering to compliance requirements.
• Delivered Sales Reporting project for an in house Commercial Data Warehouse on IBM Netezza to enable Field and Home Office Reporting. The project various sources including SFA, SAP Sales, HR Systems and 3rd party data into a Data Warehouse. Provided technical specifications to ETL developers for sourcing and transforming data. Directed the MicroStrategy reporting capabilities on mobile platforms for enabling high performance report delivery on ipads. Worked on enabling single sign on, authentication and authorization for appropriate data access for external traffic.
• Integrated various 3rd party ongoing and ad hoc data sources into an Analytics database to enable visualization and predictive analytics via SAS and R
• Delivered an MDM solution leveraging Informatica MDM for a Customer Master application bringing in various attributes from 15 systems. Application enabled matching/merging of data and enriching by leveraging external data to enable clean transactional data in the SFA system and better analytics on the Data Warehouse
• Integrated web traffic data from Google Analytics on brand websites for marketing teams to evaluate ad performance
• Technical Landscape - AWS, IBM Netezza, MicroStrategy, Tableau, R, Informatica PowerCenter, Informatica MDM, Veeva SFA, Globalscape SFTP

Confidential

Senior Manager

• Managed project for Sales & Marketing Data Warehouse of the Animal Health division of Schering-Plough. Technical landscape - Oracle, Datastage, Business Objects
• Assessed the current state of the Data warehousing program at Ace Insurance and benchmarked against best practices.
• Aided Abbott Labs in streamlining and defining a BI strategy for their R&D division (GPRD). Assessed current state, defined To-be state and implementation roadmap; benchmarked against best practices.

Confidential

Architect/ Program Manager

• Managed the Data Warehouse Project for Catalent Pharmaceuticals centered around delivering KPI’s for the manufacturing sites. Work included evaluating and procuring Teradata, Informatica ETL and Business Objects. As a project manager, enabled requirement gathering, analysis, design and development for the deliverables including Data Model, ETL specs and mapping, Report specs and Dashboards. Managed customer relationship and provided timely status reports Technical landscape - ERWin, Terdata, Informatica PowerCenter, Business Objects
• Provided technical leadership for a Data Conversion effort at Cardinal Health. Extracted and converted data from legacy systems including JDE and Oracle ERP to SAP ECC 6.0. Gathered requirements and provided technical specifications. Tested and approved deliverables. Technical landscape - SAP, Informatica PowerCenter, PL/SQL
• Worked as a Data Analyst / Data Architect at Best Buy in the Customer Analytics field delivering solutions such as Segmentation, Loyalty program, Campaign Analytics. Architected data flow and data structures for Best Buy’s Customer Centricity program for integrating data from Point of Sale, CRM, Loyalty Card, Hyperion and 3rd party data for analyzing and evaluating Customer Profitability by Segment. Technical landscape - ERWin, Teradata, Oracle, Informatica PowerCenter, MicroStrategy, Unica
• Defined Roadmap for Analytics & BI for various organizations -
• Carried out data migration roadmap consulting for HCA, a large healthcare provider client, who were adopting Salesforce.com.
• Defined a roadmap for structuring an Integration Center of Excellence at Medtronics, a medical devices manufacturer.
• Laid out a BI strategy for integrating the diverse reporting needs of 37 user communities at Target Corporation. Roadmap included setting up a BI Competency Center.
• Devised and executed a roadmap for migrating seven legacy reporting applications to a standardized and robust EDW platform for US Foodservice, a food distribution client.
• Streamlined 11 different tools into 3 tools by mapping various reporting applications as part of an enterprise reporting architecture assessment for Winn-Dixie, a grocery chain.

Confidential

Project Manager - CRM

• Managed offshore delivery for Orbitech- a global services and delivery arm for Citibank N.A.
• Led team of 24 direct / indirect reports in support of software development projects, carried responsibilities to plan and coordinate resources, testing requirements, and vendor and client relationships.
• Delivered an offshore software development project to design and deploy an innovative call center application for Citibank Greece for monitoring customer inquiries, complaints, and transactions. Technical landscape - Siebel CRM, Oracle, Informatica PowerCenter

Confidential

Senior IT Consultant - CRM

• Worked hands on in a CRM solution for Direkt Analage Bank, Germany leveraging Clarify CRM platform. This required customizing screens per requirement, mapping to database objects, testing and incorporating fixes. Technical Landscape - Clarify, Oracle
• Worked on setting up a Data Warehousing competency center and training on various tools

Confidential

Consultant - DW & BI

• Worked on support & maintenance of a Oracle Financial Analyzer based financial consolidation platform for delivering reports such as Balance Sheets and P&L. Technical Landscape - Oracle Financial Analyzer