ParamInfo
Total years of experience :17 years, 0 Months
ReportingMD is a product based company from healthcare doman and which is helping practices meet the challenge of data aggregation, reporting, and submission for pay for performance programs. MIPS is the newly structured program that pulls activities and requirements from 3 known pay-for-performance programs and reassembles them into 1 cohesive program made up of 4 categories, which are: Quality, Advancing Care Information (ACI), new Improvement Activities (IA), and Cost. Below is the payment adjustments schedule for MIPS as well as a summary of each MIPS performance category.
Responsibilities:
•Interacted with onsite client technical architect to understand the requirements and work closely with client’s technical architect.
•Design, Develop SSAS Tabular model for ReportingMD to facilitate reporting capabilities.
•Responsible for designing Data model and dimensional model.
•Responsible for data analysis and recommendation for SSAS design as per best practices followed across the globe.
•Design SSAS solutions as per best practices which include desiging model, DAX based measures, desiging model relationships.
•Responsible for Tuning DAX queries for better query performance
•Responsible for designing metadata as per Power BI requirements
•Responsible for performance tuning wherever required.
CHS Inc. is a Fortune 100 business owned by United States agricultural cooperatives, farmers, ranchers, and thousands of preferred stock holders. Based in Inver Grove Heights, Minnesota, it owns and operates various food processing and wholesale, farm supply, Cenex brand fuel, financial services and retail businesses, and is a co-owner of Ventura Foods, a vegetable oil processor.
It is ranked 1st on the National Cooperative Bank Co-op 100 list of mutuals and cooperatives (ranked by 2012 revenue), and 69th (by 2012 revenue) in the Fortune 500 2013 list of United States corporations.
Responsibilities:
•Interacted with BA and client SME team understands the requirements and prepares the design documents.
•Design; develop SSAS metadata structure as per client requirements accomplishing business requirements followed by all the best practices designed by Microsoft.
•Worked on designing business intelligence solution for CHS Inc to facilitate data analaysis and business needs.
•Responsible for designing Data model and dimensional model.
•Responsible for data analysis and connect with SME’s to understand requirements.
•Responsible for designing data model and dimensional model schema.
•Design SSAS solutions as per best practices which include desiging dimensions, measures, and calculated measures.
•Responsible for Tuning SSAS structure in order to get efficient processing as well as reporting performance.
•Responsible for creating SSRS report using MDX
•Responsible for Performance Tuning of MDX queries in order to make efficient reporting performance.
•Responsible for designing Cube processing strategy in order to refresh cube data as early as possible to business users.
•Responsible for creating SSIS package to automate creation of cube partitions.
•Responsible for datavaloidations.
•Responsible for performance tuning wherever required.
The ETP Solution provides seamless integration across all customer touch points. It enables brands to interface with personalized physical and digital retail channels that help to engage better with and create extraordinary value for both the retailer and the end consumers. ETP Omni-channel Store Solution enables true integration between the business back-end operations, supply and demand channels. This ensures the customer can peruse, pick, purchase, like, promote, review, search, seek information and provide feedback from anywhere at any time.
Responsibilities:
•Interacted with BA and client SME team understands the requirements and prepares the design documents.
•Design; develop SSAS metadata structure as per client requirements accomplishing business requirements followed by all the best practices designed by Microsoft.
•Responsible for Tuning SSAS structure in order to get efficient processing as well as reporting performance.
•Responsible for creating SSRS report using MDX
•Responsible for Performance Tuning of MDX queries in order to make efficient reporting performance.
•Responsible for designing Cube processing strategy in order to refresh cube data as early as possible to business users.
•Responsible for creating SSIS package to automate creation of cube partitions.
•Responsible for writing AMO.Net and ADOMD.Net managed code for establishing connection between Front end UI and SSAS cube as well as for fetching data from cube using managed code.
•Worked on data validation between source and cube.
•Worked on designing dimensional model/schema design.
•Worked on designing business intelligence solution for Retail so upper management can analyze data and take decisions for business.
•Responsible for Dimensional model design and Architecture.
•Design SSAS solutions as per best practices which include desiging dimensions, measures, and calculated measures.
•Worked on complex MDX solutions in order to deliver business reporting requirements.
•Created reports using in house application using MDX
Project: JEDI
Description: Synechron is an IT services company, successful completed many MSBI based Integration projects with various clients. Company is mainly into global software solution provider and having lot of client base out of which Asurion is one of the biggest client companies working for.Synechron has developed several applications for asurion which involves various technologies like Microsoft BI, Javaand Microsoft.Net
Asurion LLC is first, mobile protection provides cell phone users with rapid replacement coverage, device location and data management tools, along with ongoing live tech support to care for your privacy, productivity, socializing and even entertainment. Secondly, home-product protection provides repair and replacement coverage for all things electronic, from appliances to treadmills, tablets to TV’s; we keep your home and lifestyle in harmony.
JEDI (Japan Enterprise Development) is a BI solution asurion use for their insurance development and progress trend analysis. Solution is mainly build using .Net and Microsoft BI tools like SSIS, SSAS and reporting was done using SSRS, Power Pivot, and SharePoint Performance Point server. Overall data for JEDI is huge and hence need a SSAS cubes for fast data retrieval, SSRS reports are used for trend analysis, performance and progress analysis of business.
Responsibilities:
•Interacted client SME team understands the requirements and prepares the design documents.
•Worked with the business analysts to understand the business requirements to be translated into design considerations.
•Responsible for designing dimensional modeling from the data marts to design SSAS solutions.
•Designed Unified Dimensional Model (UDM) with all the best practices.
•Designed and develop SSAS solution with all the best practices recommended by Microsoft whitepaper.
•Responsible for writing complex MDX calculated measures in order to fulfill business reporting requirements.
•Responsible for writing MDX SCOPE statements in order to handle calculations dynamically.
•Designed Partition strategy in order to make cube data available to end users with least latency.
•Responsible for assisting DBA’s with SSAS server configuration settings wherever required.
•Responsible for designing SSAS security as per business requirements specified by SME’s.
•Responsible for designing Test Plans and Test cases.
•Responsible for data accuracy between data marts and cube.
•Designed and developed SSIS packages for automating cube processing and Synchronization from processing server to query server.
•Responsible for building SSAS solutions with all the best practices.
•Performance optimization using SQL Server Profiler and MDX Studio.
Environment: SQL SSAS2008R2, SQL Server 2008, Windows Server 2008
Project: CubeBuilder
Description: PowerPlan is an IT services company, successful delivering their BI product across various clients. Company do have mainly four products i.e. CubeBuilder, PowerLink, PowerPlan (desktop), WebViews (Web version of PowerPlan). PowerLink is used for loading data into warehouse which is ETL tool used for data extraction, transform and load. Once data load is done, Cubebuilder builds cube and reporting happens using PowerPlan desktop and web version i.e. (WebViews)
Cube Builder is OLAP (On-Line Analytical Processing) based product. An OLAP Cube is a data structure that allows fast analysis of data.
There are some limitations of relational database so to overcome those limitations OLAP provides best solutions.
OLAP also provides best solution for a wide variety of possible views, which helps managers, analysts for analysis and Planning for their Enterprise. Purpose of CubeBuilder is building an Analysis Services Database.
Responsibilities:
•Interacted client SME team understands the requirements and prepares the design documents.
•Worked with the business analysts to understand the business requirements to be translated into design considerations.
•Responsible for designingDimensional Model from the data marts to design SSAS solutions.
•Designed; Developed metadata structure, dimensions, partions, cube as per best practices specified by Microsoft Whitepaper.
•Responsible for designing application UI as per business requirements.
•Responsible for building SSAS solutions using AMO, ADOMD.Net managed code.
•Designed and developed cube partitions in order to make cube data available to business with least latency.
•Designed SSAS Server Architecture as per best practices followed across the globe.
•Responsible for writing managed code to Warm Cache in order to make efficient reporting performance.
•Created calculated complex measures in order to fulfill business requirements.
•Responsible for writing .Netmanaged code using AMO and ADOMD.Netto retrieve cube data on .Netreporting application.
•Responsible for creation of application using .Net managed code as per Product requirements specified by SME’s
•Designed and developed SSIS packages for automating cube processing and Synchronization from processing server to query server.
•Responsible for creation of Test Plans, Test Cases.
•Responsible for Quality Assurance of data between cube and data warehouse.
•Responsible for Performance Tuning of MDX queries
Project: Advertisement Tracker
Description: It is a service based company and majorly works in .Net based projects with various clients. Company is mainly into custom software development, mobile apps development, Web applications. Company is mainly expertise in the design and development of robust and scalable web and mobile applications development
Booking project, Dimple Cine Avenues is a company, which is related to Advertisement Industry, they are having their branches all over India. The Application delt with Booking Advertisements slots for their clients in various Theatres across India and to keep track of the Advertisements and the Billing of the Clients and the tracks of theatres across India and they’re showing. We have developed one application for them in which they can keep the records of their Employees, Clients, and Date of Advertisement, Repetition of advertisement and their benefits, Size and cost of advertisement.
Responsibilities:
•Interacted client SME team understands the requirements and prepares the design documents.
•Worked with the business analysts to understand the business requirements to be translated into design considerations.
•Designed; Develop UI application and business code for the same using .Net managed code.
•Responsible for writing stored procedures for data retrieval from database.
•Responsible for overall look and feel of front end application.
•Responsible for designing Data model in order to make efficient data retrieval.
•Developed database dll for data retrieval from SQL server using .Net managed code.
•Created Test Plan, Test cases.
•Responsible for Quality Assurance of data.
•Responsible for Unit and regression testing.
•Responsible for Peer reviews.
Responsible for communication with Business, SME’s, BA’s for requirement gathering along with data and requirement analysis, development, qualityassurance, documentations
•Worked as a On-site co-ordinator from USA and worked as a bridge between client and offshore team which was working from India
•Worked on all phases of SDLC i.e. Requirements understanding, Creating Technical Design Document, Data modeling, Development, Testing, Implementation and Production Support.
•Worked extensively on Power BI and created several interactive reports and dashboards
•Experience writing complex DAX queries for Power BI model and SSAS Tabular model.
•Worked extensively on SSAS (SQL ServerAnalysis Services) which involves creating optimized SSAS cubes for efficient processing as well as reporting performance.
•Expertise in developing complex MDX solutions using Calculated measures, Scope statements.
•Extensive work experience creating complex SSAS Tabular model using SQL Server 2017
•Good knowledge on Data Warehousing Concepts like Ralph Kimball Methodology, Bill Inmon Methodology, OLAP, OLTP, StarSchema, Snow Flake Schema, Fact Table and Dimension Table.
•Expertise in preparing Technical Design Documents, Coding, Dimensional models representation using Visio, Unit Test Cases and reviewing code and design doc.
•Extensively worked on AMO (Analysis Management Objects) for building cube solutions using .Net managed code.
•Experience in automating SSAS cube processing using SSIS code thru daily SQL job in order to keep cube data recent.
•Responsible for maintaining Cube Partitionsstrategyby automating creation using AMO and ADOMD assemblies
•Responsible for automating Synchronization of cube between processing and query server in 3-Server architecture.
•Experienced in PerformanceTuning for complex MDX calculations using SQL Server Profiler and MDX Studio.
•Experience in writing complex MDX queriesrequired to create SSRS reports.
•Experienced in PerformanceTuning to identify the bottleneck and improving the performance of Cube processing.
•Developed Many to Many dimension relationship logic to browse cube data.
•Experience in designing and maintaining cube Partitions as per best practices used widely.
•Experience in designingSSASSecurity using standard roles and dynamic security.
•Performed Quality Assurance of data loading between cube and warehouse using MS-Excel.
•Good knowledge on BIDS (Business Intelligence Development Studio), SSDT to build SSAS solutions and to extract SSAS structure from existing cube database.
•Good experience in Relational Databases like SQL Server with hands on Working knowledge in SQL.
•Responsible for Build process, movement of code from Development to Test and Test to Productionservers using different deployment options available.
•Experienced in developing Test Plans, Test and Test Cases for Data validation between Data Warehousing and cubes.
•Experience in automating Structural changes of the cube using SSIS Script task.
•Good exposure to development, testing, debugging, implementation, documentation, & production support.
•Thorough knowledge of Software Development Life Cycle including Planning, Analysis, Design, Implementation, Maintenance and Onshore/Offshore model.
•Responsible for executing the project from Scope Phase to Production run phase.
Emaar Properties is a real estate development company located in the United Arab Emirates (UAE). It is a public joint-stock company and is listed on the Dubai Financial Market and has a valuation of $9.7 billion USD as of June 2018. The company operates internationally providing property development and management services. With six business segments and 60 active companies, Emaar has collective presence in 36 markets across the Middle East, North Africa, Pan-Asia, Europe and North America. Emaar Properties Dubai is one of the largest real estate developers in the UAE and is known for various large-scale projects such as developing Burj Khalifa, the tallest building in the world.
Responsibilities:
•Responsible for creating Power BI reports
•Responsible for writing DAX queries for better query performance
•Responsible for designing metadata as per Power BI requirements
Ahold USA is organized into four regional divisions - Giant Carlisle, Giant Landover, Stop & Shop New England, and Stop & Shop New York Metro - along with Peapod, the nation’s leading online grocery shopping and delivery service, which together operate around 770 supermarkets and 210 pick-up points in 14 states and the District of Columbia.
Responsibilities:
•Interacted with BA and client SME team understands the requirements and prepares the design documents.
•Design; develop SSAS metadata structure as per client requirements accomplishing business requirements followed by all the best practices designed by Microsoft.
•Responsible for Tuning SSAS structure in order to get efficient processing as well as reporting performance.
•Responsible for creating SSRS report using MDX
•Responsible for Performance Tuning of MDX queries in order to make efficient reporting performance.
•Responsible for designing Cube processing strategy in order to refresh cube data as early as possible to business users.
•Responsible for creating SSIS package to automate creation of cube partitions.
•Responsible for writing AMO.Net and ADOMD.Net managed code for establishing connection between Front end UI and SSAS cube as well as for fetching data from cube using managed code.
•Worked on data validation between source and cube.
•Worked on designing business intelligence solution for Retail so upper management can analyze data and take decisions for their business.
•Design SSAS solutions as per best practices which include desiging dimensions, measures, and calculated measures.
•Worked on complex MDX solutions in order to deliver business reporting requirements.
•Created few reports using SSRS and MDX
Meaningful Stage 2
Description: Client provides smarter clinical, financial and administrative solutions that help businesses effectively compete in an evolving value-based healthcare system and deliver quality care that leads to improved population health outcomes. There clinically driven revenue cycle management™ services and comprehensive suite of interoperable solutions improve financial performance and automate clinical and administrative workflows, so medical providers can spend time on patients instead of paperwork.
Responsibilities:
•Worked on designing business intelligence solution for healthcare so doctors can check the trend of medications and improvement on patients.
•Design SSAS solutions as per the facts and dimensional attributes doctors are interested in for analyzing the improvements in their patients.
•Worked on complex MDX solutions in order to deliver business reporting requirements.
•Responsible for performance tuning wherever required.
•Interacted with BA and client SME team understands the requirements and prepares the design documents.
•Design; develop SSAS metadata structure as per client requirements accomplishing business requirements followed by all the best practices designed by Microsoft.
•Responsible for Tuning SSAS structure in order to get efficient processing as well as reporting performance.
•Write complex MDX queries as per the reporting requirements by BA and SME team.
•Responsible for Performance Tuning of MDX queries in order to make efficient reporting performance.
•Responsible for designing SSAS server architecture as per best practices recommended by Microsoft and widely used across the globe.
•Responsible for designing Cube processing strategy in order to refresh cube data as early as possible to business users.
•Responsible for creating SSIS package to automate creation of cube partitions.
•Responsible for writing AMO.Net and ADOMD.Net managed code for establishing connection between Front end UI and SSAS cube as well as for fetching data from cube using managed code.
•Responsible for doing code review.
•Responsible for writing Test Plans and execution of test cases accordingly.
•Worked on data validation between source and cube
Power plan is product, which basically work on financial budgets system. PowerPlan’s business performance management solution provides powerful budgeting, in-depth analysis, and flexible reporting Features that replace spreadsheets and cumbersome, error-prone tools. Perform capital expenditure budgeting and payroll budgeting, including salary and benefits, on a per-employee basis. Execute driver-based planning by using parameters and costs that "drive" your business. Support the assumptions and overall budget by incorporating line item budget details and notes. Improve decision-making with. Monitor Key Performance Indicators (KPIs) with the management dashboard.
Responsibilities:
•Interacted client SME team understands the requirements and prepares the design documents.
•Worked with the business analysts to understand the business requirements to be translated into design considerations.
•Developed windows based product using Microsoft .Net framework.
•Responsible for writing .Net managed code as per requirements specified by product design team.
•Responsible writing stored procedures in order to fetch data from data base and to show that on front end application.
•Designed and developed UI as per SSAS metadata requirements specified by SME’s.
•Responsible for designing SSAS UDM (Unified Dimensional Model) as per best practices.
•Responsible for designing partition strategy and optimization of the same.
•Created SSIS package for automating cube processing and synchronization.
•Responsible for Performance Tuning.
•Responsible for writing MDX queries as per reporting requirements.
•Designed and developed dimensions and attributes
•Responsible for designing Test plans and test cases.
•Responsible for Quality assurance of the product.