﻿

E-mail:anil.mishra3@gmail.com; Phone:+91-9986660401/WhatsApp(+91-9986660401)
Sr. Data Modeler, SAP BOBJ/HANA, Tableau/Power BI Technology Lead Consultant

ANIL KUMAR MISHRA
Senior Technology Savvy IT Professional with nearly 17+ years of experience (Including 5 Years in USA) in Data Modeling, SAP BOBJ/HANA, Tableau, Power BI, Spark, Erwin, Hive, Scrum Master also taking initiatives for business excellence through Agile Development Models.
Targeting senior level assignments in Data Modeling/Data Analytics/Data Scientist &amp;amp; as Scrum Master/Business Analyst
     Profile Summary 

Comprehensive experience in leading teams to design &amp;amp; implement successful projects that align business &amp;amp; its objectives and deliver rapid results using Agile &amp;amp; Scrum Methodologies
Certified as Scrum Master (SMC Certificate ID &ndash; 97252)
Expert in establishing &amp;amp; building next-generation Data Modeling, Data Analytics &amp;amp; Visualization platform for IDS (Integrated Data Solutions) business unit via insightful data mining &amp;amp; analysis, the creation of actionable data for all the financial activities
Having strong experience in Tableau, Power BI/SSRS, 5 E2E SAP BOBJ Implementation, SAP HANA Data Modeling using Attribute Views, Analytic Views and Calculation Views
Almost 3+ years of work experience in Big Data with good knowledge of Data Modeling using ERWIN, HIVE in Hadoop and Spark framework, HDFS and parallel processing implementation.
Proven track record of winning number of appreciations from both offshore &amp;amp; onsite managers for the commitment and successful delivery of each project; worked with client as Report Lead for 5 years in USA (Onshore)
Scrum Master: Facilitated meetings (daily scrum, sprint planning, sprint demo and retrospective), shielding the team, providing conflict resolutions and creating communication channel (Team, Product Owner &amp;amp; Stakeholder)
Acting as an Escalation Gate to resolve critical issues of the team members; expert in mapping client&rsquo;s requirements, custom designing solutions &amp;amp; troubleshooting for complex Information Systems Management  
Skilled at gathering business requirements, analyzing business process, Identifying Gaps, Design and Build, Unit/Integration testing and Go-live
Unique blend of leadership skills wherein leading end-to-end service delivery management and ensuring effective management of various resources to client requirements
     Notable Accomplishments Across the Career

Received Best Employee Excellence Award for Working as Role Model in Team
Attained as Best Tools Method &amp;amp; Best Practices Award (Thrice) for creating and using tools
Successfully won APEX Award for 2017 &amp;amp; STAR Award 2020 for Technical Capabilities 
     Work ExperienceSince Dec&rsquo;22: Nexperia, Malaysia as Data Modeler.
Since Mar&rsquo;22: Mphasis, Bangalore as Project Manager/Senior Data Modeler.
Since Feb&rsquo;19: NTT Data, Bangalore as Software Development Senior Specialist.
Since Mar&rsquo;06: Accenture, Bangalore as System Analyst/Team Lead.
Key Result Areas:
Working on Spotfire/Tableau/SSRS/PowerBI and MySQL/Oracle/HANA, designing, developing, testing &amp;amp; maintaining Tableau Dashboard, functional reports based on user requirements, deploying rich graphic visualizations with drill down &amp;amp;drop-down menu option based on parameters using Tableau.
Performing advance analysis actions, calculations, parameters, background images, maps, trend lines, statistics and table calculations also managing multiple POC for clients for various applications and projects
Implementing Data modeling (Dimensional &amp;amp; Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension table normalization/de-normalization, data extraction, data cleansing &amp;amp; data manipulation.
Administering functions related to SAP BOBJ 3.1/4.0/4.1 &amp;amp; SAP HANA-gathering the business requirement also building Universes in the Designer &amp;amp; IDT from various sources of retrieving data
SKILL SET
Data Modeling, Data Analytics and Reporting
Data Visualization
Tableau, Power BI, SSRS, SAP BOBJ
SPOTFIRE, TDV, TDS
SPARK, ERWIN, HIVE QL SQOOP(basics)
SAP HANA Data Modeling 
Certified Scrum Master
Business Intelligence
Project &amp;amp; Product Management
Requirements Gathering &amp;amp; Analysis
Service Delivery &amp;amp; Capacity Planning
Disaster Recovery Mgmt.
Team Building &amp;amp; Leadership
Risk, Incident &amp;amp; Change Mgmt.
Power BI Tools-IDT,UDT &amp;amp; Design Studio of SAP BOBJ Suites
Data Base
Oracle 9i/10g, SQL Server, Sybase, DB Visualizer
ACADEMIC DETAILS
MCA (Computer Application) 
BCA (Computer) 
PERSONAL DETAILS
Date of Birth: 3rd December 1979
Languages Known: English &amp;amp; Hindi
Address: A207, Midtown Opulent Sorahunase Road, Varthur, Bangalore- 560087
Facilitating functions such as scheduling &amp;amp; publication the reports also dealing with various databases like Oracle 9i/10g, SQL Server
Steering activities as Single POC for Agile certification for projects and mentoring the team for agile practices at DU level
Suggesting appropriate technology-based solutions for enhancing functional efficiency and achieving business excellence
Establishing &amp;amp; enforcing standard test processes / deliverables within the gated process for streamlining testing, support automation and manual testing efforts
Providing technical leadership while estimating &amp;amp; evaluating the effort/ schedules 
Building &amp;amp; maintaining healthy business relations with clients/customers and ensuring high customer satisfaction matrices by achieving delivery &amp;amp; service quality norms
     Projects Completed
Project: Data &amp;amp; Analytics
Duration: 1 year 2 months;      Client: Nexperia  
Tool: ERWIN, BigData, Spark, Spotfire, TDV, TDS, SAP S4/HANA, JIRA
Position: Data Modeler/Data Architect
Key Result Areas:
Worked as a key member of the Data &amp;amp; Analytics team in ideating, framing &amp;amp; implementing the Data Strategy of the organization.
Pioneered the development of the semantic data model that integrates organizational data into a singular Big Data Platform. It enables scalability by driving re-use and presenting a singular truth of data. 
Have been involved in data quality stability that involved all spheres of governance, data quality enhancements and data profiling.
Involved in Implementing the data platform using a hybrid Data Vault enabled progressive growth of the platform and helped achieve stability.
Successfully implemented the data model for manufacturing unit like yield, PQE, LOH, MCT and etc along with R&amp;amp;D unit data model. Monitored E2E implementation. 
Project: HR &amp;amp; Learning Management System (HR Analytics)
Duration: 2 year 2 months;       Client: Morgan Stanley
Tool: Tableau 10.5/SAP BO4.2, DB2,Sybase, JIRA
Position: Software Development Senior Specialist
Lead the Reporting Visualization Team (Involving Tableau/PowerBI/SSRS/SAP BOBJ) 
Gathering reports requirement and collaborating with the business users
Designing Data Modeling &amp;amp; deploying rich graphic data visualizations with drill down and drop-down menu option based on parameters using Tableau.
Developing Tableau Data Visualization using Cross Tabs, Heat Maps, Box, Whisker Charts, Scatter Plots, Geographic Map, Pie Charts, Bar Charts and Density Chart
Performing advance analysis actions, calculations, parameters, background images, maps, trend lines, statistics and table calculations.
Working as a SME for Tableau and IDT Universe Development.
Projects: Proactive Stock Management (PSM), Real Estates Inventory System, NASA, STP, GOLDMINE and LOS
Duration: 2 years 1 month        Client: Mondelez/AT&amp;amp;T
Tool: Erwin r7.1/Hive, Hadoop, Oracle11g
Position: Sr Data Modeler.
Gather all the Sales analysis report prototypes from the business analysts belonging to different Business units.
Reverse engineered the reports and identified the Data Elements (in the source systems), Dimensions, Facts and Measures required for new enhancements of reports
Conduct Design discussions and meetings to come out with the appropriate Data Mart at the lowest level of grain for each of the Dimensions involved
Designed a STAR schema for the detailed data marts and Plan data marts involving confirmed dimensions
Ensured the feasibility of the logical and physical design models
Developed Data mapping, Data Profiling and Data modeling including logical and physical model with ERWIN and Hive respectively.
Successfully created Subject area, Notation, naming convention as per Business rules.
Other Projects:
Project: BPC Implementation 
Duration: 12 months;                 Client: Energy Queensland
Tool: BW4 HANA, SAP Lumira2.0, WEBI
Position: SAP Lumira Developer/BO Consultant
Projects: NMIC, PMR, Billing Payment System, SHARP, Business Direct, AIMOS, Real Estates, Payroll, JOBS, Learning and Management System- CWAC &amp;amp; SORTS, MyWizard, PLE, Billing Payment System, NMIC Phase 3, Datahub &amp;amp; APLAUSE
Duration: 9 years 10 months; Client: AT&amp;amp;T
Tool: SAP BOBJ4.1(WEBI, IDT, UDT),Crystal report 2008/2013, Mercury Quality Center, Oracle 11g, SAP BW 7.3, Bex Query &amp;amp; Rally
Position: SAP BO Developer/BO Consultant~ Maintained more than 700 BO reports for the SAP HR System



