More Related Content
What's hot (19)
Viewers also liked (15)
Similar to marutibabu (20)
marutibabu
- 1. MARUTHI PRASAD email id: maru.november13@gmail.com Phone No: +91-9742358668 Professional Experience:  I have 4 years 7 months of Experience in Business intelligence and Data warehouse.  Experience in Microsoft Power BI, SSRS, SSIS, SSAS.  Involved in implementation, Maintenance support and Enhancements projects.  Good at Understanding and analyzing of business requirement.  Experience in interacting with Business Users, Requirement Gathering and Requirement Analysis.  Well versed with MS Power BI Desktop and Power BI Services  Good experience in developing, maintaining and supporting operational reports Dashboards, and scorecards using Microsoft Power BI Desktop.  Worked with on premise and cloud data sources.  Expertise in design reports using Power Query, Power Pivot, Power View And Power Maps.  Have good exposure on publishing reports in Power BI Services.  Experience in creating dashboards, volume reports, operating summaries, Presentations and graphs.  Experience in creating groups and content packs.  Having good knowledge in Excel formulas.  Good knowledge in DAX Language used for calculations purpose in MS Power BI Desktop.  Experience in creating roles, groups and content packs.  Working with SQL Server Integration Services (SSIS) package development and Deployment.  Having experience in Extraction, Transformation and Loading (ETL) processes using SQL Server Integration Services.  Working with SQL Server Reporting Services (SSRS) to generate reports in different Formats.  Design Different types of reports services like drill down, drill trough, sub-reports, Parameterized reports and cascading reports.  Working with SQL server Job scheduling to execute Integration Services packages and To send reports to the client.  Having knowledge in Dimensional Data Modeling, Cube development and Manipulations in SQL Server Analysis Services (SSAS).  Well versed with Agile Methodology in executing the project.  Transform business requirements into technical design specifications, Identifying Key Performance Indicator (KPI's) as per business/stakeholders demand and designing the same. Studies:-  Graduated in Bachelor of Technology (B.Tech) from JNTU Kakinada-2011. Employment Details:-
- 2. MARUTHI PRASAD email id: maru.november13@gmail.com Phone No: +91-9742358668  Working as BI Consultant in Tata Consultancy Service Bangalore from Aug 2014 to Till Date.  Worked as Software Developer in Tech Mahindra Bangalore from April 2012 - July 2014 Technical Skills: BI Tools: Power BI, SSRS. RDBMS: SQL Server, Oracle 11g. ETL Tools: SSIS, SSRS, SSAS. Other Languages: C Language. Operating System: Windows and Linux. Projects Handled: BI Consultant Jul 2015 - Till Date Project: - Sales Information System- Electrolux. Project Description: - Electrolux is a global leader in home appliances and appliances for professional use, selling more than 40 million products to customers in 150 countries every year. Electrolux products include refrigerators, dishwashers, washing machines, vacuum cleaners and cookers sold under esteemed brands such as Electrolux, AEG-Electrolux, and Eureka. This project builds corporate Data to suit requirements of Data warehouse for providing sales analysis and purchase analysis for taking business decisions by identifying key financial metrics like amount sold, quantity sold and revenue. Key Tasks:-  Involving in Business Requirement gathering.  Perform detailed analysis of source systems and source system data and model that data  Developed reports using Power Query, Power View and Power Maps.  Developed reports and dashboards in Power BI Desktop and Server.  Worked on the process framework covering six end-to-end business process tracks: Opportunity to Order, Order to Cash, Issue to Resolve, Procure to Pay, Plan to Deliver and Record to Report.  Developed Order to Cash dashboard from the scratch having 0ne-to-one interaction with customer.  Figured out KPI’s using DAX functions.  Created slicers, groups and content packs.  Performed test cases and data validations.  Performed transformations in MS Power BI desktop on top of flat and excel files.  Involved in Custom Visuals and Groups Creation.  Involved in creating row level security Technologies used: – Power BI Desktop and Server, SQL Server2008R2, One Drive and Ms Excel. BI Consultant Aug 2014 - Jun 2015 Project: - EMS & worked on Advent Geneva/Axys Scripts and Reports– EXL Services PVT Ltd
- 3. MARUTHI PRASAD email id: maru.november13@gmail.com Phone No: +91-9742358668 (Empaxis). Project Description: - . EMS system maintains data for all financial analysts/CFA, this system shows the pending work of their respective agents, like one agent is working on one process and in their daily process some Price files or some securities files are missing, in that case SSRS report page will show the problems so that they can fix accordingly and after that they can final mail to the client. And also helps to make the SQL scripts for the Automation of their manual tasks. Key Tasks:-  Maintaining the existing system and developing new module as per the requirement of the Empaxis analyzing the impacts on the existing system.  Developing and Maintaining Integration and Reporting solution for this system.  Deployment of the SSIS reports and SSRS packages on the server.  Create ETL packages to move data from feed files (XML, CSV and TXT) to database.  Create parameterized reports to accommodate business required.  Create drill down and drill through reports.  Use of agile SDLC approach to complete and track tasks on time.  Involved in multiple projects at same time to accommodate resource shortage.  Update packages to accommodate business needs so that required data is available readily.  Debug Adhoc reporting issues.  Generated different SSIS packages using transformations such as fuzzy lookup, derived column and slowly changing Dimensions (SCD) to perform different business requirements.  Scheduled reports to run weekly, quarterly, monthly based on the data to be reviewed by the manager.  Used complex query statements like sub queries, correlated queries, derived tables, CASE functions to insert the data depending on the criteria into the tables of hub.  Designed and implemented stored procedures and triggers for automating tasks. Technologies used - SQL Server 2008R2, SSRS and SSIS Software Developer May 2013 - Jul 2014 Project: - CMS (Call Management System)/OMS (Overtime Management System) and Adhoc Reports – FIS Global Business Solution PVT Ltd. Project Description: - This project is for FIS BPO Employees, in which all Avaya data calculates the performance of every Employee, like how much time Agent is taking to solve customer problems, make reports for Avaya CM, VDNs and Vectoring. OMS helps to calculate and show the Agents/Manager/RTA overtime, anybody can raise the request for the extra time which would be approved by their seniors, on any level reports can be seen. Also involves in day to day activities using SQL, SSRS and SSIS Key Tasks:-  Developing and maintaining Integration and Reporting solution for this system. ETL solution to bring data from heterogeneous data sources and reporting solution to provide right
- 4. MARUTHI PRASAD email id: maru.november13@gmail.com Phone No: +91-9742358668 information to the management.  Hands on database designing, dimensional modeling to support the reporting in SSRS.  Developing SQL objects, scripts, indexes and complex business queries.  Identify the data issues and provided solution options for resolution.  Ensure data integrity is maintained through security and change management.  Debug and made Adhoc reporting issues.  Generated different SSIS packages using transformations such as fuzzy lookup, derived column and slowly changing Dimensions (SCD) to perform different business requirements.  Monitored user queries and stored procedures by database tracing using SQL Server.  Scheduled reports to run weekly, quarterly, monthly based on the data to be reviewed by the manager.  Configured snapshot replication for reporting, user acceptance and development servers. Technologies used: – SQL Server 2008R2, SSRS and SSIS. Software Developer April 2012 - March 2013 Project: - Health Care Service Research and Analysis - Mayo Clinic Project Description: - Mayo Clinic in Rochester is ranked nationally in 15 adult and 10 pediatric specialties. It was also high-performing in 1 adult specialty. Mayo Clinic is a 1,132-bed general medical and surgical facility with 62,400 admissions in the most recent year reported. It performed 50,918 annual inpatient and 21,035 outpatient surgeries. Its emergency room had 79,542 visits. It is also accredited by the Commission on Accreditation of Rehabilitation Facilities (CARF). Key Tasks:-  Understanding the business needs and provide the solutions accordingly.  Created Sub reports, Drill down reports, Drill through reports, parameterized reports and linked reports from queries in SSRS.  Report parameters included single valued parameters, multi-value parameters which also consisted of different parameter types.  Worked on all types of report types like tables, matrix, charts, sub reports etc.  Scheduled reports to refresh and run on daily, weekly and monthly basis in the report manager. Technologies used: – SQL Server 2008R2, SSRS and SSIS.