SUMMARY:

• Fifteen years of progressive IT, Analytics & SAP HANA/BW/BI experience in a large and medium sized manufacturing/retail/pharmaceutical/healthcare enterprise
• Worked on complex agile data modeling and analytical programming in HANA
• Lead multiple successful complex data integration and analytics projects in a wide range of industries
• Confidential experience in clients serving B2B and B2C. Senior management role and delivery experience
• Certified as a BW on HANA user with experience working in mixed scenarios
• Served as a Business Analyst and liaison between technical and functional team to deliver projects as per management requirements
• Ten years of progressive experience in hands - on business and technical programming in both non-SAP environments
• Experienced data modeller using Eclipse and HANA Studio
• In depth knowledge and understanding of in memory computing solutions using SAP HANA
• Experienced in OData Services development and exposure of OData services for external application
• Highly proficient and hands on development using SQL, OpenSQL, ABAP & BAPI development
• Experience in HANA performance tuning and query optimization, configuring HANA views from HANA Live content
• Developed several Calculation views (Private, Reuse and Query)
• Created several CDS views (Basic, Composite and Comprehensive) and embedded in HANA XSJS applications.
• Strong Knowledge of SAP integration tools like SLT, SDI and SDA
• Hands on experience in developing within S/4HANA and Native HANA modelling
• Experience in Installation and Configuration of S/4HANA and performance tuning of HANA.
• In-depth knowledge of IT concepts, strategies and methodologies, including Agile. In-depth knowledge of diverse and emerging technologies and new architectural concepts and principles.
• Knowledgeable in software engineering languages and tools; proficient in new and emerging technologies. In-depth understanding of layered solutions (LSA++ and LSA) and designs; in-depth understanding of shared software concepts, Cloud computing platforms (GCP, Azure, AWS) and product features.
• Expertise in BW Design, Modeling, data processing using ETL tools and Enterprise/Web Reporting
• Comfortable programming in multiple languages, databases and versatile understanding cloud technologies
• Working experience with Business Users and C-Execs.
• Improved existing Infoproviders and reporting methods for optimal performance to accomplish cost savings
• Participated in multiple full cycle implementation of SAP BW/BI and recently BW on HANA
• Familiarity with functional domains like SD, MM, FI/CO, CRM
• Wrote functional and technical specification documents, business process procedures, user manual, guides and also trained end user in adopting BI/BOBJ reports
• Served as informatics consultant/data scientist for several SEC listed companies and major organizations
• Designed and customized data warehouse solutions, translating several complex requirements into an optimal data warehouse design
• Experienced developer using web technologies, full stack application development in LAMPP and SaaS application dev/deploy using cloud technologies
• Natural ability to learn and adopt new technologies in both individual and team setting
• Strong written and communication skills, lead and mentoring skills and exposure to working with offshore teams across the globe.

TECHNICAL EXPERTISE:

Programming: PHP, Python, Perl, VB, VBA, C, C++, Java, JavaScript (JQuery), Shell scripting, XML, HTML5, SQL, OpenSQL, R

Non-SAP: Tableau, Qlikview, Spotfire, MicroStrategy, Diver

SAP: SAP BW/BI 4.X, 7.X, SAP R/3 3.X, ECC 6.0, HANA 1.0 SP12, HANA 2.0, HANA XSJS, XSOD, XSDS, SQLSCRIPT, BODS 4.X, BOBJ XI R2, R3, 4.0, 4.2 SP2, IDT, Crystal Reports for enterprise, Xcelsius, Web Intelligence 4.1, BO BI 4.2Launchpad, Universe Designer, Analysis for Office/OLAP, Lumira

Database: Oracle DB, MS SQL Server 2017, My SQL server, NoSQL (MongoDB)

Webserver: Apache Webserver, IIS, Tomcat

OS: Unix, Linux (RH Enterprise 4 and above), AIX 6.0, MS DOS

Big Data: Hadoop Ecosystem, Spark, SGE

Software Development: Agile programming, DevOps, ITIL, Software Development Lifecycle

PROFESSIONAL EXPERIENCE:

Confidential

Dir. of Business Intelligence & Big Data

Responsibilities:

• Lead & Manage digital transformation strategy and efforts to modernize BI infrastructure using big data, in memory analytics and cloud technologies for specialty retailer
• Modernize data warehouse using in memory/columnar storage, high analytical and transactional processing systems
• Implement customer and marketing analytics solutions using Spark/Hadoop
• Scalable data storage architecture and data lake design solutions
• HANA based predictive analytics solutions to forecast sales, customer spend and lifetime value analysis
• BW4/Hana and S4/Hana enterprise transition from traditional ERP.
• Established partnership with Microsoft to lay roadmap to transform in house infrastructure into Azure cloud technologies (Azure Datalake, Azure Data Warehouse, Machine Learning Studio, Data Factory, Databricks).

Confidential

SAP HANA/Big Data integration/BI Consultant

Responsibilities:

• Served as architect for creating dashboards for supply chain financials, perpetual inventory
• Created near real-time data pipes for visualizing inventory at worldwide distribution centers
• Worked with junior and senior staff members on Spark based solutions to ELT large volume of data
• Worked on application of Artificial Intelligence, Predictive Analytics, Big Data Integration
• Created dashboard and reports to provide visibility to WIP, open production orders, backlogs, on-time delivery
• Implemented predictive methods to forecast initial sales for new product releases

Confidential

SAP HANA/BW/Big Data Digital Integration consultant

Responsibilities:

• Provided SME Confidential for predictive/prescriptive analytics
• Worked on application of Artificial Intelligence, Predictive Analytics, Big Data Integration
• Architected data solutions for solving day-to-day issues in manufacturing and distribution
• Machine Learning Methods to optimize pharmaceutical supply chain using in memory computing platform
• Created Advanced Analytics and models using predictive library (AFL/PAL) in SAP HANA platform (High Performance in memory computing engine)
• Designed and Developed CDS Views in S4/HANA
• Designed and developed data models for reporting requirements in OTC, P2P, FI, SCM
• Designed and developed ABAP Managed Database Procedures (AMDP) using Eclipse
• Acted as a lead S/4HANA solution engineer and/or technically responsible for the implementation of approved technologies that align with technical architecture, customer s business plans and long term strategy
• Made recommendations to improve process efficiency and effectiveness in the IT division
• Provided consultation services major architectural designs to ensure consistency, security, maintainability and flexibility with respect to overall system, technical and product architectures within domain/portfolio
• Participated in incident management events and provided consultative recommendations on viable resolutions
• Contributed towards forecast of business and IT trends to define the technical direction for clients
• Guided the development of system, technical and product standards based on business plan and vision. In coordination with architectural team, did research and made innovative recommendations around new technologies
• Responsible for prototyping complex, cross platform business solutions to validate newer technologies
• Participated in the evaluation and selection of hardware and software products
• Planed and managed execution of architecture migrations using BODS, custom scripts and other tools
• Maintained collaborative and strategic partnerships between different team members, customers, vendors, business partners, and IT
• Contributed to decisions that impacted profitability and operational effectiveness saving time/capital.
• Mentored IT staff to develop S/4HANA software systems development capabilities
• Facilitated cross-team/, provided sessions for learning and conducted workshop

Confidential, MA

BW/BI/HANA Developer & Systems Analyst

Responsibilities:

• Worked with multiple stakeholders in the US business and developed/refined ideas for integrating predictive and prescriptive analytics
• Played critical role in identifying reporting requirements and designed solutions for OTC, P2P, RTR, RTL using HANA Live content.
• Migrate several reports from MicroStrategy to Webi/Lumira on HANA
• Built several Attribute, Analytical and complex Calculation views in HANA for consumption in BO tools
• Designed and implemented Customer 360, Sales 360, dealer portal, retail portal and several strategic reports for omnichannel marketing
• Developed reporting solutions using Lumira and other dashboard applications
• Played a critical role in conducting Blueprint sessions for BI reporting requirements, legacy data migration and data integration strategies
• Configured Smart Data Access and SDI to access large archived data in Hadoop
• Identified implementation bottlenecks and increased overall team efficiency
• Participated in architecting the enterprise data warehouse and reporting solutions
• Created several real-time analytics solutions and dashboard report to be consumed by members from business based on XSJS, PHP, XSODATA services.
• Designed and developed efficient HANA XS based program to recalculate time based dimension to accelerate speed of handling time dimension
• Coordinated remote insourcing teams for implementing reporting solutions based on SAP HANA
• Fully leveraged rapid development in phased manner using SAP HANA ASAP 8 agile methodology.

Confidential

Solution Architect

Responsibilities:

• Lead the technical implementation of BW on HANA project, complete from Business Blueprint, Solution Design, Architect, Sizing, migration, upgrade and rollout reporting solutions
• Migrated IBM DB2 to HANA DB 1.0 SP8 for the 3-system landscape (DEV, QA and PROD)
• Upgraded the BW system from BW 7.1 to BW 7.4 SP9 and changed platform from AIX to Windows
• Used SAP HANA best practices to craft a 80-point detailed project plan, complete from BW housecleaning activity, Pre-Migration Steps, Migration Steps (BASIS), Post-Migration Verification steps, Post-Migration Enhancement / Modeling steps
• Engage with BASIS, infrastructure and internal IT teams to collaborate and coordinate various stages of the HANA migration/upgrade steps
• Built BOBJ 3 system landscape (DEV, QA, PROD) and rollout Launch Pad, WEBI, Analysis for Office and OLAP, complete with integration to backend BW 7.4 system
• Built new Lumira visualizations for the key stakeholders, with real time replication from ECC to HANA DB via SLT and reporting via BW Virtual Provider
• Upgraded legacy SD, CRM, FI/CO along with a team of consultants
• Built Analytic View and Calculation View for Open Orders Report, built virtual provider in BW to report complete with BEx Analysis Authorization row-level security
• Built Composite Providers to list daily sales, invoice and Receivables information, using new BW 7.4 Eclipse Query Designer.
• Coached the teams and demonstrated the BW 7.4 capabilities along with HANA DB capability
• Supported HANA Extended Application Services (XS) for Dealer Portal Apps to view Customer Orders via HANA DB through NetWeaver Enterprise Portal

Confidential

Head of Informatics/Senior Data Scientist

Responsibilities:

• Managed, architected and implemented the Pharmaceutical Supply Chain Management Reporting solution, integrating multiple non-SAP application data to provide high-level property information to C-level execs and VPs
• Conducted blueprint sessions, engage with Business and scientific Users and collect requirements
• Collaborated with multiple application IT-Teams to understand the software, create interface requirements
• Worked with middleware team, design SSIS interface structures, transfer routines to extract data from multiple applications to a centralized BW system
• Developed comprehensive Laboratory information management system to manage complex data pipeline in a regulated environment.
• The reporting solution now provides KPI for informed decision making

Environment: Crystal Reports, Diver, MS-SQL Server 2008, SQL Server Integration Service (SSIS)