Junior Data Analyst and SAP BI Consultant Resume

SUMMARY

Data Analyst with experience in Business Intelligence, Data Warehousing using SAP BI products, SAP Data Services and SAP BW and experience in ETL and Reporting tools like Talend and Tableau.
Very good experience with SAP BusinessObjects BI 4.x product suite - Web Intelligence, Lumira - Designer/Discovery, Crystal reports with desperate data sources - SAP BW, S/4 HANA.
Extensively worked on creating HANA Data Models, Attribute views, Analytic Views, and Calculation views.
Excellent knowledge of SAP Data Services - Data Integrator, Data Quality and Information Steward
Worked on Data cleansing using Information Steward and Data Services
Experience in Migration and Transformation of Data to S/4 HANA from other systems using SAP Data Services
Worked on Data Profiling and Analysis. Performed ETL and Data profiling. Identified the business rules embedded in the legacy data flow.
Created Dashboards using SAP Web Intelligence, SAP Lumira, Design Studio 1.3, Microsoft BI, Tableau
Worked on creating visual reports on SAP Analytics Cloud.
Good knowledge in Core Data services (CDS Views).
Good understanding of end-to-end development lifecycle - Blueprinting, Design, Realization, Testing and Go Live support
Very strong and enthusiastic team player, excellent communicator with exceptional interpersonal skills.
Fast and willful learner and passionate about varied technologies.

TECHNICAL SKILLS

Reporting Tools: SAP Web Intelligence, MS Power BI 2016, Tableau 9.3, SAP Predictive Analytics, SAP Lumira

ETL Tools: SAP BW 7.x, Business Objects Data Services XI 4.1\4.2, Talend, Informatica, SSIS

Meta Data Tools: SAP EIM, SAP Information Steward 4.1\4.2, SAP RDS Solution for Data Migration, Core Data Services (CDS) views

Databases: Confidential, SQL-Server, MySQL, SAP HANA, MongoDB/NoSQL

Languages: Java, J2EE, Python 3, SQL, PL/SQL

J2EE Technologies: Servlets, JDBC, JSP, JSF, JMS, EJB

Mark-up/XML Technologies: HTML, CSS, JavaScript, AJAX, JQuery, AngularJS, Bootstrap, XML, Confidential

Tools: & Framework: Spring, Hibernate, Spring MVC, Spring Security, MavenNumPy, Pandas, Seaborn, Plotly, Cufflinks

Web services: SOAP, Restful, WSDL, AWS ( Confidential Web Services)

IDEs: Eclipse, IntelliJ, PyCharm, Jupyter

OS & Environment: Windows, Win 2k Server, Sun Solaris, UNIX, Linux

PROFESSIONAL EXPERIENCE

Junior Data Analyst and SAP BI Consultant

Confidential

Responsibilities:

Gathered information about the company’s data structure and functional business environment
Responsible for Data Migration strategy
Developed and implemented Data Cleansing and Governance strategy using IVM
Generated Rules and Jobs in SAP Data Services for extraction and transformation of the data according to the business.
Designed various views such as Attribute Views, Analytical Views and Calculation views on SAP HANA Database.
Modelled all calculations into HANA Analytical and Calculation Views.
Defined strategy to migrate sensitive data
Created Profiling rules on SAP Information Steward for data profiling and de-duplication
Automated analytics using SAP Predictive Analytics Tool by creating predictive models and advised on determining future data strategies
Provided end to end model management, maintain peak performance for different predictive models and schedule updates
Created advanced visualization and reports for the sales team using Tableau

Environment:, SAP HANA SP10, SAP Data Services 4.2, SAP Business Objects 4.1, SAP Information Steward, Tableau, IVM

Confidential

SAP BI Consultant

Responsibilities:

Analyzed the existing OLTP system and designed and managed universes based on the Business Requirements
Gathered information about the company’s data structure and functional business environment
Responsible for Data Migration strategy
Developed and implemented Data Cleansing and Governance strategy using IVM
Created rules for migration of all Master Data from ECC to S/4 HANA.
Generated Rules and Jobs in SAP Data Services for extraction and transformation of the data according to the business.
Designed various views such as Attribute Views, Analytical Views and Calculation views on SAP HANA Database.
Modelled all calculations into HANA Analytical and Calculation Views.
Defined strategy to migrate sensitive data
Created Profiling rules on SAP Information Steward for data profiling and de-duplication Automated analytics using
Designed standard analytic reports using SAP WebIntelligence
Designed customized reporting solution to generate different invoices sent to the customers and Adhoc reporting solution to cater the needs of finance and budgeting team

Environment: SAP HANA SP10, SAP Data Services 4.2, SAP Business Objects 4.1, SAP ECC,