KUMAR SHANMUGHAM

ATLANTA, GA / ad2kbn@r.postjobfree.com / 678-***-****

Summary

Over fifteen years in business systems analysis and software development life cycle

(SDLC) as a software developer, including design, development, maintenance, and support of BI Applications like Power BI and IBM Cognos. Experienced personal in gathering data from various sources transforming it into insightful reports and dashboards. Proficient in data modeling and integrating reporting components from multiple data sources. Work Authorization: US Citizen

Technology Summary

Experience in creating Power BI Dashboards (Power View, Power Query, Power Pivot, Power Maps).

Extensive experience in Power BI, Cognos for data visualization, Reporting and Analysis;

Experience in Cross tab, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart

Used DAX functions for creating calculations and measures in the Tabular Models.

Experience in data cleaning, data validation, and data analysis using Data Analysis Expressions(DAX)

Experience in creating SQL datasets for Power BI and Ad-hoc Reports.

Experience with all phases of Software Development Life Cycle in environments like Healthcare, Banking, & Human Resources.

Good knowledge of Data Warehousing methodologies and concepts, including Star, Snowflake schemas, ETL processes, Dimensional modeling and Reporting tools.

Experience in developing ETL mapping, mapplet and workflow using InformaticaPowerCenter 7.1.

Programming experience using Python with PYPub library.

Performing reporting requirements, analysis, creating document specifications, providing technical recommendations, and evaluating the performance of current reporting solutions.

Experience in Agile Methodologies like attending daily Scrums, maintaining User Stories and Burn down Charts, Backlog Grooming and Retrospective.

Good knowledge of JavaScript, CSS, & HTML.

Technical Skills

BI Tools: Power BI, Cognos 11 and Analytics, Tableau, & Actuate. Programming: C, C++, Javascript & Python

Databases: Oracle 19c, Sql Server 15

Data Modeling: Star and Snowflake Schemas Modeling, Facts & Dimensions Operatic Systems: Windows and MacOS

KUMAR SHANMUGHAM

ATLANTA, GA / ad2kbn@r.postjobfree.com / 678-***-**** VITTAE Financial Services Pvt. Ltd., Chennai, India 11/2021 – 10/2023 Power BI Consultant

Vittae is a fintech company with software products that helps individuals by giving deep insights into each layer of their personal finance. It helps or assists to do financial planning by following best financial schemes, practices & principles. Built dashboards in Power BI from scratch that helps individuals get more insights on Financial Planning, Expense Management, Income Planning, Tax Saving, and Loan Management. Gathering and Analyzing requirements of clients, understand, and convert them into database solutions with solid exposure to architecture, analysis, design, testing, development, deployment, documentation and implementation. Worked closely with various teams across the company to identify and solve business challenges.

Import data from different data sources like Sql Server, MySQL, Postgres, Excel, to create Power BI reports and Dashboards.

Transformed, define, navigate the data from various data source and performed merge and append queries using Power Query.

Designed the data model and managed relationship between the tables in Power BI using Star Schema. Performed transformations like Pivoting, Unpivoting and splitting of the columns using Power Query. Designed and developed reports and dashboards and managed security based on requirements. Created measures, calculated columns, relationships and performed time series analysis using DAX in Power BI. Used different types of slicers available in Power BI using Star Schema and Snowflake Schema.

Implemented parameters to reports and dashboards to work across environments like DEV/QA/PROD without modifying them.

Worked with both live and import data in Power BI for creating reports and dashboards. Created different chart types and drill down reports using Power BI Created hierarchies in Power BI reports using visualizations like Bar Chart, Line Chart etc.

Experienced in developing several Details, Summary reports including line and pie charts, trend analysis reports and sub-reports per business requirements. Experienced in generating on-demand and scheduled reports for business analysis or management decision. Responsible for creating and changing the visualizations in Power BI reports and dashboards upon client requests. Published reports and visualizations to Power BI Service and thereby created dashboards.

Worked on resolving the performance issues which resulted in fixing the underlying SQL in KUMAR SHANMUGHAM

ATLANTA, GA / ad2kbn@r.postjobfree.com / 678-***-**** SQL Server database. Responsible for creating Row level Security (RLS) based on the business requirements.

CLOOBOT Labs, Chennai, India 11/2019 – 10/2021

Sr. BI Consultant

Cloobot workflow product provides automate followups, escalations and reporting. Tracks progress and utilizes the team resources efficiently. Provides dashboards that displays real- time visibility on the status of each assigned task for the management to act faster. Team Leaders can connect Cloobot to their various tools across functions & let Cloobot do the heavy lifting for them.

Gathering and Analyzing requirements of clients, understand, and convert them into database solutions with solid exposure to architecture, analysis, design, testing, development, deployment, documentation and implementation. Worked closely with various teams across the company to identify and solve business challenges. Import data from different data sources to create Power BI reports and Dashboards.

Transformed, define, navigate the data from various data source and performed merge and append queries using Power Query.

Implemented complex query techniques of passing multi-valued parameters and cascading parameters in MDX. Performed different types of contexts like Row context, filter context and query context using Power BI Desktop. Designed the data model and managed relationship between the tables in Power BI using Star Schema. Cleaning data by analyzing the data in removing unwanted columns and null values in certain columns resulted in data better that can give accurate analysis. Performed query folding using Power Query to filter data in the data source server. Performed transformations like splitting timestamp columns to date column to bring more efficiency in performance while refreshing data in Power Query. Designed and developed reports and dashboards and managed security based on requirements.

Created measures, calculated columns, relationships and performed time series analysis using DAX in Power BI. Used different types of slicers available in Power BI using Star Schema and Snowflake Schema.

Implemented parameters to reports and dashboards to work across environments like DEV/QA/PROD without modifying them.

Worked with both live and import data in Power BI for creating reports and dashboards. Created different chart types and drill down reports using Power BI Desktop.

KUMAR SHANMUGHAM

ATLANTA, GA / ad2kbn@r.postjobfree.com / 678-***-**** Created hierarchies in Power BI reports using visualizations like Bar Chart, Line Chart etc. Experienced in developing several Details, Summary reports including line and pie charts, trend analysis reports and sub-reports per business requirements. Experienced in Data Modeling used to define and analyze data requirements needed to support the business processes within the scope of corresponding information systems in organizations.

Using Power BI Gateways to keep the dashboards and reports up to date. Responsible for creating and changing the visualizations in Power BI reports and Dashboards upon client requests. Published reports and visualizations to Power BI Service and thereby created dashboards.

Optum - United Health Care, Atlanta, GA, USA 05/2017 - 11/2019 Data Analyst

FADS provides a suite of discovery components to help Medicaid agencies detect overpayments accruing from fraud, waste and abuse. Also, it supports data analysis including Peer group profiling, Focused analytics, Provider activity spike detection, Long-term care review, High-cost members, Browse & search of claims, and Case tracking. Coordinated testing, rollout & deployment of Cognos 11 Business Intelligence reporting solutions.

Worked closely with business users to define reporting requirements and documenting the requirements in order to design, develop and maintain and secure Cognos reports. Closely worked with ETL team to design Data Marts by understanding user requirements and increasing the reporting efficiency.

Developed Metadata models using Framework Manager and created filters, prompts, calculations, summaries and functions as per Functional Requirement Specifications. Implemented Framework Manager Security for row level access and package access based on the Department, Region Level.

Created simple to complex reports as well as dashboard like reports using Report Studio by applying various concepts and functionalities such as drill-through, conditional reporting, block, tables, charts, master-detail, maps, various calculations and joins under tabular sets and models.

Extensively worked on Active reports to create static reports for offline users. Performed burst of Reports against the region, districts, and stores for delivering by email; appropriate outputs to the concerned District Managers & Team Ambassadors in Cognos Connection.

Create several different types of Ad-hoc (simple list, grouped list, section heading, crosstab, and nested crosstab) reports and represented data graphically by charts using KUMAR SHANMUGHAM

ATLANTA, GA / ad2kbn@r.postjobfree.com / 678-***-**** Query Studio.

Implemented prompt validation and added various functionalities to prompt pages using JavaScript in order to extend and customize the reporting functionality, visualization and presentation experience.

Created agents and added tasks in Event Studio to run reports based on specific business criteria.

Performed scheduling and maintenance of reports using Cognos Connection and Microsoft SharePoint based support portals.

Technosoft Corporation: March 2014 – March 2016

Role: Software Consultant

Cloudmatters a Newgen Company: June 2014 – Nov. 2014 Role: Software Consultant

Yash Technologies: Oct. 2012 – Nov. 2013

Role: Solution Architect

NEC – May 2010 – Oct. 2012

Role: Tech Lead

Infor Global Solutions Inc. (May 2009 – May 2010)

Sr. Software Developer

SKY Solutions LLC (May 2008 – March 2009)

BI Consultant

Education

Bachelors in Computer Science, The Madras University, India. KUMAR SHANMUGHAM

ATLANTA, GA / ad2kbn@r.postjobfree.com / 678-***-****

Contact this candidate