Not Available
User

Power BI Developer

BMT Score
76
76%
  • Remote

Available for

About Naresh

Proven experience in IT industry with business analysis, development and implementation of Database focusing on Requirement Analysis, Development, Testing, Administration and Implementation of BI Solutions in various verticals such as Health care, Retail, Finance.
10 years of experience in the field of Business Intelligence tool like MicroStrategy, Power BI with core skills in the following areas:
Extensive experience in BI Reporting tool suite such as MicroStrategy 10.x expertise in playing multiple roles.
Strong experience in documenting BRD, TDD and implementing Proof of Concepts to valuable clients.
Involved in all phases of project lifecycle covering Requirement Gathering, Analysis, Report Design, Report optimizations.
Excellent understanding of Data modelling (Dimensional & Relational) on concepts like Star-schema, Snowflake schema using fact and dimension tables and relational databases and have been working with various data sources such as Oracle, SQL Server, Hive – Spark SQL, Databricks, Amazon Red shift, ODBC and flat file sources.
Expertise in Creating Schema Objects (attributes, facts, Hierarchies, Transformations), Public Objects(Filters, Prompts, Metrics, Custom Groups, Consolidations, Drill Maps, Templates), designing & creating Report Service Documents, Intelligent Cubes and I Cube reports.
Worked on modifying the context of data calculations using Level Metrics and Pass through functions (Apply Simple, Apply Comp).
Extensive Experience on Designing and development of Dynamic Dashboards and Mobile Dashboards in MicroStrategy which helps in better understanding of the Business trends.
Well Experienced in Debugging, Optimizing the Dashboards/Mobile Dashboards/ Reports and Performance Tuning of Dashboards / Reports in MicroStrategy and effectively worked with VLDB settings and report tuning techniques in MicroStrategy to meet client requirements and applying best test approaches before delivering the product.  
Worked on Various MicroStrategy components like Object Manager, Command Manager, Integrity Manager and System Manager.
Good in report developing, testing, deploying reporting solutions, scheduling the reports in MicroStrategy Server and manage the application’s users and user groups.
Designed Dashboards with Quick filters to handle views more efficiently.
Worked on all kind of reports such as Yearly, Quarterly, Monthly, and Daily.
Experience in training end users/vendors through Application/Tool.

Tech Stack Expertise

  • Tech Stack Expertise

    Oracle

    Oracle

    5 Years

Work Experience

Images

Software Developer

  • January 2018 - November 2022 - 4 Year
  • India

Projects

Images

AU Reporting

  • May 2020 - May 2022 - 25 Months
Technologies
Role & Responsibility
    AU Reporting Project is one of the key business areas of S&P Global Company, using this project Australian Analysts will get public issue pdfs for Australian Banks, Major Entries in varieties of combinations (Loans, Pool, Performance, Demographic). This project has more than 100 users, from there reports will be published to S&P hub Pages, Public. Standard template Reports starting from Page 1 – Page 9 will give full information on – Prepayment Rates, Interest Rates, Several Calculated Measures for business use.
    • Interacted with business users for requirement gathering
    • Interacted with business stakeholders to understand their requirements, analysing the available data to build Micro strategy.
    • Created numerous MicroStrategy objects which used features like pass through functions. 
    • Extensively worked on conversion of legacy Oracle SQL scripts to SPARK compatible SQL scripts. Utilized extensive data moulding using SQL.
    • Extensively worked in creating and integrating Micro Strategy reports, and Objects (Attributes, Filters, Metrics, Facts, Prompts, Templates, Consolidations, Custom Groups, Drill Maps, Transformations, etc.).
    • Extensively worked in both Ad-hoc and standard reporting environments and involved in creating Reports scalable to large volumes of data.
    • Extensively worked on Dashboards and have utilized the new features to convert the dashboards into Presentation mode.
    • Worked closely with Business users. Interacted with ETL developers, Project Managers, and members of the QA teams.
...see less
Images

IDF Consumption Layer

  • May 2020 - May 2022 - 25 Months
Technologies
Role & Responsibility

    Integrated Data Framework (IDF) holds data from multiple sources of S&P Global (Core, CMP, Hugans, Reuters, US Public Finance), Consumption Layer is built on top of this well architected data model to serve purpose of adhoc reporting using Microstrategy, this project holds thousands of attributes from various categories useful in reporting. We developed this framework using Microstrategy Architect.
    Roles/Responsibilities:
    Interacted with business users for requirement gathering
    Interacted with business stakeholders to understand their requirements, analysing the available data to build Micro strategy.
    Extensively worked in creating and integrating Micro Strategy reports, and Objects (Attributes, Filters, Metrics, Facts, Prompts, Templates, Consolidations, Custom Groups, Drill Maps, Transformations, etc.).
    Extensively worked in both Ad-hoc and standard reporting environments and involved in creating Reports scalable to large volumes of data.
    Worked extensively on Microstrategy Architect with 2000+ Attributes.
    Administered user, user groups, and scheduled instances for reports in Micro strategy 
    Extensively worked on Microstrategy Library, Dossiers and have utilized the new features to convert the dashboards into Presentation mode.
    Worked closely with Business users. Interacted with ETL developers, Project Managers, and members of the QA teams.

      

...see less
Images

Conduent INC

  • September 2018 - July 2019 - 11 Months
Technologies
Role & Responsibility

    Conduent Inc. is a technology-led business process Services Company headquartered in New Jersey which employs about 85000 people in more than 40 countries. It was formed in 2017 as a divestiture from Xerox. The company offers digital platforms for businesses, Health care services for below poverty people and governments.
    Roles/Responsibilities:
    Interacted with business users for requirement gathering
    Interacted with business stakeholders to understand their requirements, analysing the available data to build Micro strategy.
    Created numerous MicroStrategy objects which used features like Dimensional metrics, Transformation metrics, Conditional Metrics, Relationship filter, pass through functions. 
    Extensively worked in creating and integrating Micro Strategy reports, and Objects (Attributes, Filters, Metrics, Facts, Prompts, Templates, Consolidations, Custom Groups, Drill Maps, Transformations, etc.).
    Extensively worked in both Ad-hoc and standard reporting environments and involved in creating Reports scalable to large volumes of data.
    Good experience in constructing I-Cubes and derived elements on cube reports. 
    Administered user, user groups, and scheduled instances for reports in Micro strategy 
    Extensively worked on Dashboards and have utilized the new features to convert the dashboards into Presentation mode.
    Worked closely with Business users. Interacted with ETL developers, Project Managers, and members of the QA teams.

...see less
Images

Sutter Health

  • December 2017 - August 2018 - 9 Months
Technologies
Role & Responsibility

    Sutter Health is a not-for-profit health system in Northern California, headquartered in Sacramento which employs about 67000 people around the world. It includes doctors, hospitals and other health care services in more than 100 Northern California cities and towns.  We compassionately care for more low-income Medical patients in Northern California than any other health system. Sutter Health proudly funds and partner with community programs to help ensure those in need have access to care and social services.
    Roles/Responsibilities:
    Led multiple teams for new initiatives, enhancements and support of BI in Corporate Office of Technology.
    Interacted with business stakeholders to understand their requirements, analysing the available data to build MicroStrategy.
    Reverse engineered and optimized reports and dashboards.
    Created numerous Micro Strategy objects which used features like Dimensional metrics, Transformation metrics, Conditional Metrics, Relationship filter, pass through functions. 
    Extensively worked in creating and integrating Micro Strategy reports, and Objects (Attributes, Filters, Metrics, Facts, Prompts, Templates, Consolidations, Custom Groups, Drill Maps, Transformations, etc.).
    Used Administrator tools like Command Manager and object Manager to move the objects from one environment to another environment and worked with command manager scripts for cube publishing, security filters creation etc.
    Extensively worked in both Ad-hoc and standard reporting environments and involved in creating Reports scalable to large volumes of data.
    Good experience in constructing I-Cubes and derived elements on cube reports. 
    Administered user, user groups, and scheduled instances for reports in Micro strategy 
    Training the users on Micro strategy.
    Configuring I-Server, Project and Web Preferences Settings, Database connectivity, Project Duplication Activity.

...see less
Images

Quantiful NZ

  • April 2017 - November 2017 - 8 Months
  • India
Technologies
Role & Responsibility

    Quantiful are market leaders in the use of social and search data for analytics, marketing and demand planning optimisation. Our social analytics capability provides clients with market opportunity and threat analysis, reputation management, social marketing campaign optimisation and influencer identification and management.

    • Gathered user requirements and analysed and designed software solution and database.
    • Involved in all phases of the project life cycle.
    • Analysis of Requirements and Preparing the Technical Design Document.
    • Designing the Report/ Document as per TDD and performing Unit Testing.
    • Creation of interactive dashboards using new selectors like radio buttons, check boxes, panels, slider and button bar etc.
    • Responsible for creating Metrics, Filters, Prompts using MicroStrategy Desktop and Web.
    • Created different Transformations like YTD, QTD and MTD.
    • Optimized Query Performance by using VLDB settings at report level.
    • Involved in migration of objects to testing Environment using Object Manager.
    • Involved in creating security filters to end users to access data based on their privileges.
    • Hands on experience in Report service document creation Dashboards.
    • Providing support to QA and Production Defects
...see less
Images

Reckitt Benckiser

  • July 2016 - January 2017 - 7 Months
Technologies
Role & Responsibility

    Reckitt Benckiser Group plc (RB) is a British multinational consumer goods company headquartered in Slough, England, and has operations in around 60 countries. RB organizes most of its products into three main categories – health, hygiene and home. The company's strategy is to have a highly focused portfolio concentrating on its 19 most profitable brands, which are responsible for 70% of net revenues. The company supports Save the Children. RB has also implemented an environmental initiative called Carbon 20. The initiative, which was announced in November 2007, aimed to cut the total carbon footprint of its products—from creation to disposal by 20% by 2020
    Roles and Responsibilities:
    Analysis of Requirements and designing the Technical Design document.
    Involved in creating( Attributes, Facts, and Hierarchies)
    Developing the objects like Reports, Dashboards in MicroStrategy.
    Responsible for creating (Metrics, Filters, Prompts using MicroStrategy Desktop and Web.
    Created different Transformations for using in comparative reports like sales this year to previous year, Quarter to Month etc.
    Creation of interactive dashboards using selectors like radio buttons, check boxes, panels, slider and button bar etc.
    Optimized Query Performance by using VLDB settings at report level.
    Creating various Interactive Dashboards using different visualizations like (Heat map, Line, Funnel, Cylinder Graphs etc.) in MSTR Desktop as well as Web environment.
    Involved in Unit testing and preparing the Unit Test Results Document.
    Moving the project from development environment to QA environment.

...see less
Images

Reporting Services Application, Canada

  • January 2015 - April 2016 - 16 Months
Technologies
Role & Responsibility

    Unitrax is a record-keeping platform used by large mutual funds to keep track of customer accounts belonging to Citigroup Fund Services Canada Inc (CFSC). The objective of the Fox program is to cleanse, standardize and integrate the data from legacy systems and load it into the proposed ODS database which will facilitate operational reporting. This will drastically reduce the current stress on the legacy systems to manage both the business operations and the operational reporting during the same time frame. MicroStrategy – Business Intelligence reporting system will fetch the required data from ODS and prepares reports based on Ad hoc/ canned/ dashboard requirements.
    Roles and Responsibilities:
    Understanding Business, Functional and System Requirements.
    Involved in all phases of the project life cycle.
    Analysis of Requirements and Preparing the Technical Design Document.
    Designing the Report/ Document as per TDD and performing Unit Testing.
    Creation of interactive dashboards using new selectors like radio buttons, check boxes, panels, slider and button bar etc.
    Responsible for creating Metrics, Filters, Prompts using MicroStrategy Desktop and Web.
    Optimized Query Performance by using VLDB settings at report level.
    Involved in migration of objects to testing Environment using Object Manager.
    Involved in creating security filters to end users to access data based on their privileges.
    Hands on experience in Report service document creation Dashboards.
    Providing support to QA and Production Defects
    Creating Reports with OLAP services.

...see less
Images

Perfetti Van Melle.

  • December 2012 - November 2014 - 24 Months
  • India
Technologies
Role & Responsibility

    Perfetti Van Melle is a privately held Italian-Dutch global manufacturer of confectionery and gum. It was formed in 2001 with the acquisition of Van Melle of Netherlands by the Perfetti group of Italy. Its corporate headquarters is in Schiphol, Netherlands. Perfetti Van Melle is the third largest confectionery manufacturer in the world after Mondelez International and Mars, Incorporated. 30 subsidiaries companies and distributes its products in over 159 countries. Their US headquarters is in Erlanger, Kentucky, a suburb of Cincinnati.
    Roles and Responsibilities:

    • Understanding the client requirements by coordinating with the onsite technical team.
    • Identified and created schema and application objects like attributes, facts, Hierarchies in MicroStrategy Desktop.
    • Creating different types of Metrics, filters, Prompts, Documents based on client requirements.
    • Designed Filters to generate Reports in grid and graph mode. 
    • Created Drill maps for the existing reports to define custom drilling options.
    • Created Consolidations, Custom Groups and Transformations required for reports.
    • Created Reports using complex Filters and Compound Metrics and Prompts.
       
...see less
Images

Pampered Chef

  • January 2011 - October 2012 - 22 Months
Technologies
Role & Responsibility

    Doris Christopher founded Pampered Chef in 1980 with the belief that quick tips and powerful tools can fuel a faster, no-fuss cooking experience. But today, many of us don’t even have the time to sit down for an entire meal, let alone make one. That’s why at Pampered Chef we help you press pause on life and take in the most important moments with easy, everyday cooking built for today’s world. We exist to help you enjoy the moments most important to you and yours by inspiring satisfying, stress-free meals fit for the way you live. We use the power of cooking to bring people together as the cornerstone of realizing each person’s full potential–in the home and in life.
    Roles and Responsibilities:
    Understanding the client requirements by coordinating with the onsite technical team.
    Identified and created schema and application objects like attributes, facts, metrics and prompts in MicroStrategy Desktop.
    Designed Filters to generate Reports in grid and graph mode. Auto prompt filter feature gave end-user choice of different filtering criteria each time they run the report.
    Created Drill maps for the existing reports to define custom drilling options.
    Created Consolidations, Custom Groups and Transformations required for reports.
    Created Reports using complex Filters and Compound Metrics and Prompts.
    Used Advanced Prompts, Non-Aggregatable Metrics, Conditional, Transformation metrics and Level Metrics for creating complex reports.
    Created Interactive Dashboards by using different types of Widgets like Micro charts, Gauges, Time Series Slider, Fisheye Selector, Bubble graphs and Controls like Selectors, and Panel Stacks & Layouts.

...see less

Industry Expertise

Our Suggestions