Aditya Rajawat

Aditya Singh Rajawat Senior Data Analyst (Business Intelligence) Email:-Mobile: - Technical Experience Summary Total 7+ years of experience in the field of Business Intelligence development, SQL, Data Warehousing, ETL, Analytics and Visualization. Expertise in Business Objects tool suite, MicroStrategy, Tableau, Lumira based on Excel, SQL Server and Oracle databases. Worked to 2 end to end SAP BO implementation projects and 1 MicroStrategy and 1 tableau project from requirement analysis, Universe design, creating reports, performance tuning. Well versed in Business Objects XI R3.1 and 4.1 Enterprise suite tools like UDT/Designer, Rich Client, Report Conversion Tool, Migration Tool, Upgrade Management Tool, Infoview, CMC. MicroStrategy Desktop, Web, Architect, Administrator, Intelligence Server in Created schema, metrics, reports, and documents supporting client business goals. Responsible for designing and executing Application objects and Schema objects using MicroStrategy Desktop. Create, maintain and modify Attributes, Metrics, Filters, Facts, and Hierarchies. Good knowledge on data warehousing and ETL concepts, Snowflake schemas, Star schema, fact and dimension tables, logical and physical modeling. Frequently interacting with the clients for analyzing the requirements of business process and translate them to technical specification, verifying mapping availability, derivation logic, feasibility, creating report blue prints for designing reports. Work closely with ETL/DBA teams to troubleshoot data issues and enhance database performance. Engagement Overview SAP BO & MicroStrategy Lead Accenture, Pune January 2017 to Present   Tools and Technology - SAP BO, MicroStrategy, Oracle, Excel VBA, SharePoint, Confluence, Jira, Git, Bamboo. Roles and responsibilities: End to end responsibility of MIS releases by Agile methodology. Analyzing requirements thoroughly, understanding DB and creating Data models for schema objects, Universe design/changes and working with the BAs to clarify all design queries, get answers to all Business questions in the design phase. Getting agreement from Business about data, formatting, prompts etc. Verifying the feasibility of all requirements with respect the data in DB and derivation logics provided by the Business. Development of all Database views, Universe and MicroStrategy schema/application objects and reports changes required. Peer reviewing all the changes ensure defect free deliveries. Verifying all the deliverables with proper documentation and checklist. Conducting BA and QA walkthroughs to ensure these is no gap in Business expectation and development. SAP BO Developer CSC Technologies (now DXC), Indore July 2011 to January 2017 Tools and Technology - SAP BO, Universe design, Webi, Deski, Migration tools, Oracle, Lumira. Roles and responsibilities: Project requirement analysis and feasibility study. Universe designing and maintenance, objects creation, joins, context, access restrictions and resolving universe design issues to ensure right SQL is generated. Identifying missing tables/columns and get them approved by the DB team.  Create the reports with prompts, alerts, sections, breaks, cross tabs, complex variables etc Review the changes made to the Universe, existing reports and new reports by other Team members.  Developed SAP Lumira visualization and story boards POC.   Education and Certification Degree College / University / Institution Year BE (IT) IET DAVV, Indore 2011 12th MP Board 2006 10th MP Board 2004 MicroStrategy Certified Designer(MCD) MicroStrategy 2017 Personal Details   Name: Aditya S Rajawat. Marital Status: Married.  Date of Birth: 21/04/1988  Languages known: English, Hindi. Current Location: Pune, India