Resume

Sign in

Data Sap

Location:
Waterbury, Connecticut, United States
Posted:
November 15, 2018

Contact this candidate

Resume:

SIRI (LS)

Email:ac7plx@r.postjobfree.com

Cell: 510-***-****

Professional Summary:

BI/BW/BOBJ/HANA/BODS/TABLEAU/ANALYTICS Consultant.

Multi-faceted Business Intelligence & Analytics/ETL professional with a track record of successful

projects, and proven expertise in designing, developing BI Solutions. I bring both technical and functional expertise with strong leadership & teamwork skills.

•Overall 12+ years of Data-warehouse/Database/Reporting Writing/ Lotus Notes (Domino) and Java experience with 7+ years of extensive experience of working in all phases of large complex enterprise BI projects as Lead/Consultant.

•Senior-level Business Intelligence – Analytics Consultant with extensive experience in design, development and implementation of cost-effective, high-performance technology solutions to meet challenging business needs.

•Passionate about BI & Analytics/ETL and driven to recommend and deliver real value and innovative work applying Technology, functional knowledge and best practices.

•Innovative and practical Business Intelligence consultant with extensive project delivery experience who engages with all levels within the business.

•Worked as Onsite coordinator for projects based out onsite/offshore model.

•Delivered high-quality BI/Data solutions in complex and multi-disciplinary business organizations to budget, scope and plan.

•Experienced in developing strategy roadmaps and proposal discussions.

•Highly analytical in problem solving with the ability to apply original and innovative thinking.

•Excellent stakeholder management skills with the ability to support various stakeholder groups.

•A strong communicator, with the ability to lead and mentor project teams, provides guidance to senior management with a high level of customer focus.

•Experienced in working on high-profile, cross-department transformational projects and have the experience to start contributing from day one.

•Experienced in conducting end-user training for business users, developing Business Process documentation and technical design documents.

•Worked on setting up processes for various testing cycles like scenario testing, integration testing, regression testing, and customer acceptance testing using tools like HP quality center.

•Hands on experience on Agile Methodology.

•Presentations - Conducted workshops and presentations to validate business requirements and solutions with the end user community. Developed business process documentation.

•Ability to involve in complex development and integration efforts and mentor peers, users and staff.

Expertise includes

•Team Management

•Requirements (business rules) gathering and analysis

•Expert in Business improvement implementations.

•Presentations-Workshops, Educating End users; End users Training.

•Good Analytical and Problem solving skills.

•Source To Target mapping.

•Report Writing

•Data Analytics

AWARS/CERTIFICATIONS:

•In appreciation of outstanding contribution as a member of the Dream Team.

•IBM Certified Domino 6/6.5.

•Certified Automotive –Level 1

•Certified Medical Devices and Supplies Guide to Compliance and Quality Manufacturing - Medtronic

•Certified 35 PDSu’s of Project Management Professional (PMP)

Education

•M.Sc (Computer Science) from Osmania University, India.

•Bachelor in Computer Science, Osmania University, India.

Technical Skills

- SAP BW, BW on HANA

- SAP HANA

- SAP SLT

- SAP Business Objects Data Services (BODS)

- SAP Business Objects(SAP BOBJ): Analysis for Office, Design Studio, SAP Lumira, Web Intelligence, Universe (IDT), Crystal Reports, Dashboards.

- SAP BEx, Query Designer, Web Application Designer (WAD)

- Tableau 10.X

- Webfocus

- Web Technologies: HTML, JavaScript

- SAP Functional Areas: Finance, Logistics, Manufacturing, HR, CRM, Utilities, APO, Integrated Planning,

BPC.

- Languages : C,C++,Java, ABAP, SQL

- Databases : Oracle, MS-Access, HANA

- ERP Packages : ECC 6.X/ SAP R3-4.7/4.6C, 3.1C.

- Delivery Methodologies: Agile.

- Domain Knowledge: Automotive, Manufacturing, Finance, EHS, Medical Devices (Health Care) and

Public Sector.

Professional Experience

Nov 16 – Present

Sr. SAP-BI & ANALYTICS CONSULTANT, MEDTRONIC (COVIDIEN/SURGICALS), NORTH HAVEN,CT

Project 2 : Salesforce to SAP BOBJ ; HANA as DB ; Informatica for ETL process

Project 1: Cognos/Access to SAP BOBJ (Nov 16 – Dec 17); HANA as DB ; Informatica for ETL process

•Responsible for leading a group of PMV Data Analysts in developing statistically based adhoc reports utilizing data generated by the Client's complaint system to assist in the evaluation of safety triggers by PMV Analysts.

•Served as the key subject matter expert on analytics/business intelligence.

•Identified business requirements and analytical needs.

•Compiled and mined data from multiple cross business sources.

•Collaborated with senior staff regarding specific customized reports and ad hoc analyses.

•Ensured adherence to data management regulations and policies.

•Developed systems to provide support and tracking of adhoc reporting outside the complaint group, as well as development and maintenance of the PMV SharePoint site.

•Introduced and established various industry best practices and process improvement initiatives in the project like development standards, naming conventions, design principles, Key Design documentations required to ensure that business intelligence and analysis meets organizational requirements and reuse principles, and supports business efficiency.

•Provided leadership in the administration of the Client's Complaint Tracking System (CTS) across the various Surgical Solutions Group sites.

•Designed, created and validate adhoc reports on SAP Business Objects (BOBJ/Webi Queries) on various aspects of complaint activities to a multitude of different departments located in different locations.

•Involved in enhancements, upgradation, migration activities related to system.

•Managing Webi Folders, Documents, Reports within BOBJ.

•Managed on time delivery of various monthly and weekly KPI reports/Dashboard reports.

•Created firm-wide dashboards and automated reporting.

•Developing relevant statistical methodologies for detecting event triggers.

•Generated queries charts/graphs and performed analysis of complaint data in support of - Monthly metrics; Corporate metrics; CAPA metrics.

•Completed urgent ad-hoc reporting requests for various levels of management within required timeframes and with accuracy.

•Created Metric/Dashboard reports for Senior Directors, Senior Managers for better decision making.

•Created Daily Product Analyst metric reports to measure performance, to better identify and retain top performers.

•Created data visualization reports using BOBJ and Excel for further data processing and create charts/graphs.

•Created GEO metric report for Latin America/AUS-NZ/Greater China/Japan/APAC/Canada for different business units.

•Created Aging Investigations reports; P50/P90 day reports.

•Partially involved in random sampling reports.

•Partially involved in extracting sales data from Cognos.

•Created MDR/MDVs; Complaint Investigations; Regulatory Inquiry’s metric reports.

•Created rolling 12 Months MDR/MDVs Dashboard reports.

•Created rolling 6 weeks closed complaints metric reports.

•Created Summarized Closed/Voided Complaint dashboard reports.

•Mapping the fields between legacy and current system.

•Developing Weekly/Monthly analytics reports on complaint handling metrics.

•Designing and writing Webi queries.

•Designed and Created Excel As a data source queries.

•Creating Webi-excel workbooks to support user reporting

•Performing weekly/month-end reporting closure activities.

•Involving in group discussions with teams.

•Formatting report workbooks.

•End users training on BOBJ(Webi) and reports writing trainings.

•Per customers requests, gave the report SQL to compare the results with HANA DB SQL. On the HANA studio, based on the webi report SQL, similar SQL will be created and the results will be compared with the HANA DB.

•Coached team members on BOBJ and gave technical support as and when required.

•Involving in reconciliation.

•Validating the data.

•Scheduling/Bursting reports in excel/csv/pdf formats.

•Distributing weekly/monthly reports to end users.

•Monitoring the schedules

•Rescheduling the failed jobs..

•SQL Scripting.

•Service now tickets on SQL Scripts - Webi Reports.

•Perform other duties as assigned by manager to assist in the deployment and scheduling of solutions.

•Engage with end users to incorporate usability and user interface needs using standard prototyping tools & techniques.

•Contributing to release/change management process.

•Participating in full project lifecycle modeling.

•Providing estimates for assigned tasks and work efforts.

•Providing project and task updates on a timely basis.

•Presenting reports to users

•Gathering further reporting requirements

•Supporting UAT activities.

•Providing post Go Live support

•Work within the PMO to and other stakeholder to incorporate best practices.

Team Size: 18

Environment: SAP- HANA ; SAP BOBJ (Webi) ; MS-Access ; MS-Visual Studio ; SQL / T-SQL,

Cognos, Salesforce, Share Point, SVN, Service Now; Informatica.

TABLEAU CONSULTANT, SOFTPATH,MI Oct 16 – Nov 16

•Trained on Tableau 10.X.

•Worked on self directed project two mini projects: Super Store ; Track bugs(Issues) that were filed by department and which includes the below technical.

•Hands-on experience in building Analytic Dashboards using Tableau Visualization tool.

•In-depth knowledge on Tableau Desktop, Tableau Viewer and Tableau Server.

•Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.

•Created complex formulas and calculations with in tableau.

•Used Navigation and drill down features in Tableau dashboards.

•Designed analytical reports by blending data on a single worksheet on Tableau Desktop.

•Experience with, ER Modeling, Dimensional Modeling, Star Schema / Snowflake Schema, FACT and Dimensional tables and Operational Data Store (ODS).

•Experience with ETL tools and Relational Database Management Systems (RDBMS) – Oracle, SQL server.

•Ability to develop, designs, estimate, test and deploy ETL packages.

•Expertise in writing TSQL, SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.

•Knowledge on Optimized connections, Data extracts, and schedules for background task and Data refreshes for corporate Tableau server for better performance of the workbook reports.

Environment: Tableau 10.X, Excel, SQL, Oracle

Nov 14 – July 16

Sr. SAP-BI/BW/BODS. CONSULTANT, VEOLIA ENVIRONMENTAL SERVICES, MILWAUKEE, WI

Worked on two projects BODS & BI/BW (Multitasking)

SAP BODS

•Identification of Business Needs and Constraints.

•Compiling and translating user requirements into technical design and implementation plan.

•Designing and implementing data integration processes, including data quality and testing.

•Understanding and Addressing Customer Requirements, Areas of concerns and Issues.

•Establishing guidelines, communication with client managers & end-users.

•Preparing Solution/Application Design, Development and go-live execution.

•Worked on integration of BODS with SAP modules and Non-SAP data sources.

•Worked on external system for ETL between ECC and BI.

•Created Jobs, Work Flows, Data Flows, and Scripts, Transforms (Integrator, Quality and Platform) to successfully load data from multiple sources into a desired target.

•Extracted Data from Relational Databases which includes oracle, Microsoft Sql server and loaded in different environments which include BW, ORACLE, SQL SERVER, and .txt & .CSV files.

•Created and documenting logical data integration (ETL) strategies for data flows between disparate systems and / or the enterprise data warehouse.

•Perform other duties as assigned by manager to assist in the deployment and scheduling of solutions.

•Providing estimates for assigned tasks and work efforts.

•Providing project and task updates on a timely basis.

•Monitoring production job schedule and correct job failures in a timely manner.

•Creating projects, repositories, data sources in BODS.

•Creating data stores for source and target applications.

•Extracting data from flat files.

•Cleansing of data.

•Gathering further reporting requirements

•Supporting UAT activities

•Providing post Go Live support

SAP BI/BW (Report Writer)

•Identification of Business Needs and Constraints.

•Compiling and translating user requirements into technical design and implementation plan.

•Designing and implementing data integration processes, including data quality and testing.

•Understanding and Addressing Customer Requirements, Areas of concerns and Issues.

•Establishing guidelines, communication with client managers & end-users.

•Preparing Solution/Application Design, Development and go-live execution.

•Preparing Technical Specifications to carry out the reporting development.

•Migrated reports from PeopleSoft to SAP BEx.

•Writing BEx queries for infoproviders (YGIGL_M01/General Ledger, YCOOM_M05/Cost & Allocations, YCOOM_M01/Cost & Allocations-Actuals, YMM_M01/Procurement), for multiple business units (like IS, Energy, WaterMuni, Corporate, etc.,)

•Creating workbooks to support user reporting

•Updating and create key figure structures

•Creating row structure hierarchies in Bex queries.

•Performing month-end reporting closure activities.

•Developing report hierarchies and structures as per PeopleSoft Reports.

•Involving in group discussions with COE France Team.

•Developing Security/Authorization for reporting

•Formatting reports in workbooks.

•End users training in different business units (like Boston, Canada, Houston, Milwaukee, etc,).

•Involving in reconciliation.

•Creating Analyzer/Broadcaster variants.

•Monitoring the broadcaster process chain.

•Publishing reports to BEx broadcasters.

•Creating formatted queries in BEx for webfocus.

•Executing BI workbooks and creating lookup files for webfocus reporting.

•Providing support for webfocus.

•Confirming data models.

•Creating and documenting logical data integration (ETL) strategies for data flows between disparate systems and / or the enterprise data warehouse.

•Perform other duties as assigned by manager to assist in the deployment and scheduling of solutions.

•Providing estimates for assigned tasks and work efforts.

•Providing project and task updates on a timely basis.

•Monitoring production job schedule and correct job failures in a timely manner.

•Presenting reports to users

•Gathering further reporting requirements

•Supporting UAT activities

•Providing post Go Live support

Team Size: 13

Environment: SAP-BW/BEx 7.4 ECC 6.0, PeopleSoft, BODS, Webfocus, SQL, Oracle, HANA, HPQC,

Service Now.

SAP HANA Modeller/Analytics, INTERN-Emax Technologies Pvt. Ltd., Jan 14 - Aug 14

Jan - Mar : In India and later carried over in USA.

•Trained on SAP HANA 1.0 (SP07).

•Worked on self directed project.

•Good hands on experience on HANA Studio modeler.

•Created and Organized Schemas.

•Created Datastores;Data flows in BODS to load data from various sources like SAP & Non-SAP to SAP HANA.

•Designed Packages; Attribute ; Analytic & Calculation views.

•Designed Input Parameters/Variables for user entry in Analytic/Calculation views.

•Good hands on experience on SQL Scripting.

•Designed HANA Security which includes User Creations; User Management Roles & Privileges.

•Hands on experience in data replication from various SAP & non SAP sources leveraging SLT (Real time replication Server).

•Hands on experience on DXC (Direct Extractor Connection) - ERP -Embedded BW Architecture & HANA.

•Data Load via SAP BW extractors DXC to HANA from Legacy BW.

•Designed various dataflows in BODS to load data to HANA which includes SQL to HANA ; ECC to HANA ; BW to HANA ; CSV/Excel files to HANA.

•Build reports using reporting tools which includes : Lumira; BO Analysis For Office; Dashboards; BOBJ; Crystal Reports ; Excel Bases Reporting (Source as SAP HANA)

•Hands on experience on Transport Management - BODS ; HANA.

Environment: SAP-BW 7.X ECC 6.0; BO 4.0; HANA; BODS; Lumira;BO Analysis; SAP Crystal Reports

TECHNICAL LEAD - SAP BI/BW, EDWARDS (Part Of ATLAS COPCO GROUP),INDIA Oct 10 – Jan 14

•Taking part in RFPs (Request for Proposals) for various customers

•Helped Customers in Creating Business Cases for their BI/BW/BOBJ/HANA needs.

•Helped Customers to Upgrade SAP BW (from 3.x to 7.x including 7.3).

•Experience in Upgrade activities which includes requirement gathering; Full systems testing for development/quality/production boxes; Pre-requisites for before and post for upgradation; Alerting users; bux fixes; raised SAP OSS notes for critical issues.

•Understanding and Addressing Customer Requirements, Areas of concerns and Issues.

•Preparing Solution/Application Design, Development and go-live execution.

•Establishing guidelines, communication with client managers & end-users.

•Preparing Technical Specifications to carry out the development.

•Delivery of the tasks as per schedule with the required documentation.

•Involved in supporting and maintaining SAP BW landscapes including enhancements to existing scenarios for FI & SD, Process Chain Creation to automate data load, Data Load Monitoring, fixing issues related to loading etc.

•Involved in organizing the entire Reporting solution across the client's organization.

•Involved in implementing new business scenarios in BW for FI-AP, AR, GL and customized solutions like Extraction of Parked Documents,, Schedule Line, Global Cost Roll, Service Cost Roll etc.

•Involved in creating Reports & Web Dashboards for Top Management Reporting.

•Involved in creating roles and authorization objects for implementing various access rights and security in BW

•Optimized the efficiency of the BW systems and addressed performance issues.

•Involved in end-to-end implementation projects of combination of Non-SAP+ ECC.

•Involved in gathering business requirements from users for sizing and critical area of the business and the system.

•Analysis of data requirements and translation of these requirements into dimensional data models using extended star schema data modeling techniques, with an emphasis on actual implementation in BI.

•Worked extensively on standard and custom defined LO extractors. Installed relevant SAP business content. Used LO structures for extracting sales order, delivery information. Logistics Cockpit Configuration, Customization and enhancing Extract Structures transaction data, master data.

•Mapping all the required fields with the info objects in the BI system.

•Replicating the required data sources from ECC system to the BI system.

•Applying the transformations as per the business requirements in the infosources.

•Exporting the data sources and creating the data mart set up to meet the business functionality.

•Aggregates and the index creation for improving the query performance.

•Data Source enhancements, generic extractors, User Exits and customized delta built up for the data sources, V3 Updates..

•Created Transformations and applying routines for restricting and transforming data.

•Experience in ABAP/4 which includes, Update/Transfer Routines/Start Routines, End Routines and Expert Routines for Complex data transformation Requirements. Experience in creating DTP Filter Routines and Info package Routines User Exits.

•Involved with PSA in monitoring data transfer from source system into BW.

•Created data models and Data flows using the Wizards in BW 7.3 and proficient in designing hybrid Providers and Semantically Partitioned Objects.

•Experience in Open Hub Service

•Involved in performing unit testing in development server and transporting to Quality server.

•Involved in support work which includes Daily process chain monitoring, Background jobs, Support calls which needs to be fixed on priority basis.

•Maintaining Best Practices and Document Repository

•Demonstrated good/effective presentations on SAP HANA to SAP team members across all locations/branch offices in India.

Team Size: 9

Environment: SAP-BW 7.X ECC 6.0; ABAP/4;HANA; CRM, APO,HPQC.

SUBJECT MATTER EXPERT (SME), AMERICAN EXPRESS, PHEONIX,AZ & INDIA Mar 09 – Oct 10

•Worked as SME/Technical lead (onsite co-ordinator) at AMEX.

•Understanding and Addressing Customer Requirements, Areas of concerns and Issues.

•Preparing Solution/Application Design, Development and go-live execution.

•Establishing guidelines, communication with client managers & end-users.

•Preparing Technical Specifications to carry out the development.

•Optimized the efficiency of the BW systems and addressed performance issues.

•Involved in supporting and maintaining SAP BW landscapes including enhancements to existing scenarios for FI & SD.

•Extensive experience in implementing reporting solutions for FI-GL, FI-AP, SD,MM, CRM, Warehouse Management,

•Involved in implementing new business scenarios in BW for FI-AP, AR, GL and customized solutions.

•Creation of Info objects, Info cubes, DSO’s, ADSO’s,MultiProviders and Data Marts.

•Involved in Modeling, Extraction and Reporting.

•Worked extensively on standard and custom defined LO extractors. Installed relevant SAP business content. Logistics Cockpit Configuration, Customization and enhancing Extract Structures transaction data, master data.

•Worked on Routines in Transformations, Enhancement of Data sources.

•Designing and monitoring of Process chains for interdependent processes with tasks like Data loading, aggregate rollups, Cube Compression, Index maintenance, Master data & DSO activation in achieving the best possible performance & data integrity for various data flows.

•Created Analysis Process Designer.

•Design of Queries using restricted key figures, calculated key figures, Variables, Filter, Free Characteristics, Exceptions, Conditions.

•Created BEx queries for reporting on InfoCubes, DSOs and MultiProviders.

•Created Calculated and Restricted Key Figures, Structures, Conditions, Filters and Cell Definitions within queries, maintained Query settings and tuning.

•Used ABAP to create Start, End routines in transformations to facilitate various reporting requirements.

•Involved in resolving the Tickets (Incident & change request).

•Maintained Reconciliation's to verify the data in SAP R3 and SAP BW.

•Prepared Unit test scripts documents.

•Involved in performing unit testing in development server and transporting to Quality server.

Team Size: 5

Environment: SAP-BI/7.x; ABAP/4;ECC 6.0; HPQC

LOTUSNOTES CONSULTANT, ONSITE COORDINATOR, CHRYSLER, DETRIOT,MI & INDIA Mar 07 – Mar 09

•Worked as technical lead (onsite coordinator)

•Team Management

•Business meetings with Client.

•System requirement gathering.

•Requirement Analysis and Designing.

•Handling communication with onsite counter parts

•Modification of design elements of the application

•Involve in the development and implementation of System Reports.

•Enhancements/Reports generating for MS-Access DB application.

•System Study for MS-Access DB

•Migrating the Same application in LotusNotes.

•Change Requests/SR’s in NOP-II.

Team Size: 8

Worked on: Lotus Notes, Formula Language, Lotus Script, MS-Access

LOTUS NOTES CONSULTANT AMERIPRISE, PUNE, INDIA May 06 –Mar 07

•Involved in the pre-migration, remediation, migration & post-migration activities of databases.

•Team Management.

•Work initiation/assigning to the pre-migration team.

•Analyzed database for static and server dependencies.

•Remediation of the databases for new Production environment.

•Migrated to new Production environment.

•Contributed for remediating 2500+ templates.

•Proper and accurate maintenance of the database details.

•Involved in post-migration activities.

•Worked on enhancement requests raised by the users. This includes closing the user feedback calls raised by the users. (Production Support)

•Provide senior analyst and technical support function for various analyst/end users and IT Managers for applications used across the client organization.

•Hands on coding for prioritized tickets on Lotus Notes application maintenance and support.

•Evaluate estimation and sizing for project requests, and assist in query resolution raised by business clients.

•Creating K245 and doing requirements gathering for new enhancements.

•Evaluated security model, and ensured adherence as compliance standards and policies.

•Make data changes specific to requests, requirements gathering, and assist in creation of use cases, assist in application testing, monitor production jobs, document issues and resolution, attending meetings with business partners as necessary.

•Reviewing ACL/Group entries for verifying authorized and secure access.

•Team Track (Business Mashups) for use during issue and defect tracking.

Team Size: 18

Environment: Lotus Notes 6.5.5, Lotus SameTime, Lotus Script and Formula language, Team studio Windows XP, 2000.Lotus Notes, Formula Language, Lotus Script,

TELANGANA SECRETARIAT (Former AP SECRETARIAT) June 04 – May 06

LOTUSNOTES CONSULTANT, HYDERABAD, INDIA

•Worked with Tata Consultancy Services Team as a part of Designing, Maintenance & Enhancement of the application.

•Team Lead.

•Production Support to end-users.

•Enhancement /Change requests.

•Collecting requirements, giving effort estimates, Impact analysis, and coding.

•Implementation of CaringGov module at Client Side and handholding of users.

•Coordination with client and other administration teams.

•Closing user feedback calls on daily basis and if the problem severity is major analyzing the same and discussion with the team to resolve the issue on permanent basis.

•Trained the end users, which include State Ministers and IAS officers who are working in AP secretariat.

Team Size: 15

Environment: Lotus Notes, Lotus Workflow Architect, and Domino.Doc. Oracle 8i, MS-Word, MS-Excel Reports and Imaging Client.



Contact this candidate