Business Intelligence Project Management

Sumitharani Chinnasamy

Union, Kentucky • 908-***-**** • ***********.***@*****.***

https://www.linkedin.com/in/sumitharanichinnasamy

Data Strategy & Analytics, Business Intelligence & Advanced Analytics Core Skills:

Attention to detail

Tactical and strategic thinking

Business Intelligence

Leadership

Agile Methodology

Scrum framework

Project Management

Project management tools and

methodologies (e.g. Microsoft

tools, Google tools, Smart

sheets, Jira, Devops, Confluence,

Lucidchart, ServiceNow)

Process improvement &

Standardization

Planning, Development &

Delivery

Technical Skills:

PowerBI(Power Query/M/DAX)

Tableau

ETL, SSIS, SSRS

Informatica

SQL, PL/SQL

C, C++

Snowflake, SAP

Weka, R, Python

Oracle, MySQL

Netezza

Data Visualizations

Data Governance

Data modeling

Data Mining

Data Manipulation

Predictive analytics

High-performing professional who is passionate about leveraging data to shape the strategy across a growing organization with multidisciplinary blend of critical thinking, analytics rigor and data warehousing and visualization capabilities, business acumen, and stakeholder management, all applied in tandem to discover key insights. A professional with over 10+ years’ success in working with data throughout its life cycle.

Experience engaging with leaders and stakeholders across business, analytics, and technical teams to deliver data enabled solutions and a part of an agile multi-disciplinary team of engineering and analytics professionals building best in class data solutions. Experience directing all data & analytics operations and technical solutions that enhance mission- critical business operations. Recognized for implementing cost-effective solutions and process improvements with a focus on automation and efficiencies. Leading multiple high-profile projects with demanding deadlines, changing requirements, & working with limited resources. Ability to estimate required effort & prioritize work items appropriately. Advocate and experience maintaining and developing best-in-class analytical expertise, developing standards and scaling self-serve data analytics.

Technical and business knowledge across the functional areas of Merchandising, Sales, Supply chain and Finance. Ability to translate vision to strategy to outcomes-based road maps. Experience managing multiple levels of direct & indirect reports Naturally collaborative with experience working in an Agile environment, including with remote teams, both on and offshore.

Collaborate well, encourage, and empower my team, and have a hunger for problem solving. Bring passion to work and operate with a sense of purpose that motivates those I work with. Intellectually curious, take initiative, and love learning new skills and share that knowledge with others.

I Believe, having the ability to make mistakes, admit and learn from them is more important than being a perfectionist.

Sumitharani Chinnasamy

CAREER PROGRESSION

LEVI RAY & SHOUP, (Client ADM), Erlanger, KY Apr 2023 – Present Senior Data Consultant – Power BI

Responsible for accelerating the Digital transformation at the Quality Center of Excellence, in order to build a data driven culture and promoting business intelligence within the organization. Expertise in Power BI Desktop, Power BI Service, Power Query, DAX, Power BI dashboards, and report publishing. Created dataflows and complex data models.

• Power BI Report & Dashboard Development: Design, develop, and deploy interactive and visually appealing Power BI reports and dashboards based on business requirements and KPIs.

• Data Modeling & Transformation: Create and optimize complex data models in Power BI, ensuring data is clean, accurate, and structured for analysis.

• Data Integration & ETL: Integrate data from various sources, including SQL Server, Excel, cloud-based platforms, and other APIs. Develop ETL (Extract, Transform, Load) processes to ensure smooth data flow into Power BI.

• DAX & Advanced Calculations: Write complex DAX queries to perform advanced calculations, aggregations, and business logic for reporting.

• Collaborate with Stakeholders: Work closely with business users and stakeholders to understand reporting needs and provide insights that align with their objectives.

• Performance Optimization: Ensure that Power BI reports and dashboards are optimized for performance, with an emphasis on query efficiency and report load times.

• Data Quality Assurance: Conduct thorough testing and validation of data reports and dashboards to ensure data accuracy and consistency.

• Documentation & Training: Document the data models, reports, and processes, and provide training or guidance to end users to enhance their understanding of Power BI.

• Continuous Improvement: Stay up-to-date with the latest Power BI features, best practices, and industry trends, and continuously improve reporting capabilities and user experience.

• Proactively drive the vision for Business Intelligence across a Global SME process or Business Unit vertical, and define and execute a plan to achieve that vision

• Strategically partner with multiple internal teams including Recall, Supplier Quality, Food safety, Audit and CAPA management, Legal, Compliance, Quality Control, Data Science, and Customer quality, among others

• Responsible for data governance in digital quality team ensuring the single source of truth of data and KPIs

• Developed dataflows and pipelines for extracting, cleaning, transforming data and consumed to develop analytical reports and dashboards.

• Developed a complete Microsoft sites communication website for the Global Quality team in a short period of time. STRYKER, Kalamazoo, MI May 2022 – Aug-2022

IT Global Data & Analytics Manager

Responsible for product management, defining product requirements for a set of global analytical solutions and implementing them across different Business units and Medical divisions along with the ERP migration from multiple legacy systems to SAP S4. Responsible for multiple Advanced Analytics solutions like Demand Forecasting, Anomaly detection, Product recommendation, etc. Focused on enhancing user experience and solution value by partnering with business partners, gathering data, formulating business cases, identifying requirements, setting priorities, and communicating cross-functionally to ensure execution from inception to delivery.

• Provide insights into data & analytics product, technology and market trends

• Serve as the agile owner, driving the culture of Succeed or Fail FAST

• Manage feature lists, user stories, and roadmaps. Uses data to drive decision making

• Accountability for establishing a robust Data & Analytics Governance and measurement framework

• Prioritize and manage the product backlog, and perform release planning

• Gather and manage product(Power BI reports) feedback through surveys, concept testing, and analytics tools

• Be a champion of the MVP concept, distilling the product down to what is desirable, viable and feasible

• Define, monitor and communicate product KPIs to assess business impact and mature products.

• Creating the vision and strategy for enterprise data and analytics and bring it to life ensuring scalability of systems processes and talent

• Strategic partnerships to deliver value for key partners(stakeholders) Sumitharani Chinnasamy

WHIRLPOOL CORPORATION, St. Joseph, MI Feb 2020 – May 2022 Analytics & Development Associate Manager – Commercial Analytics Responsible for driving the data strategy for Whirlpool’s commercial business including Merchandising, Sales, Category Management and Finance consuming SAP data. Leading the delivery of aligned key KPIs, enabling business insights through data connectivity across multiple platforms and analytics, accountable for the overall stability and day by day management and continuous improvement of the dashboards, data views, etc. Developing the analytics roadmap, developing and maintaining new dashboards and tools to support Commercial business data needs and business partners. Maintain, scale, and drive adoption of existing tools, dashboards, and reporting. Hire, manage, and develop a team of technical analysts.

• Embed analytical capability within product marketing and commercial business groups by bringing right tools, right functionality by synthesizing data sets of SAP data and producing reporting frameworks, dashboards and use cases.

• Responsible for the strategic design, development, implementation, management and support of mission critical enterprise Business Intelligence solutions to meet identified business needs.

• Define a clear data strategy with a robust roadmap and deliver against it.

• Drive advanced analytics initiatives to move towards predictive and prescriptive analytics from descriptive and Diagnostic analysis. Implemented an end-to-end data science project for measuring Price Elasticity which has saved millions of dollars from optimal pricing and reducing promo spend year over year.

• Assist in the design, management, governance and implementation of metrics and dashboards to monitor Value based Key Performance Indicators and individual performance to productivity goals for local and global business units. Also support embedment and change management.

• Query and visualize data from SAP to unlock insights that drive the team forward. Create data visualizations using enterprise tools such as Excel, Tableau, and Power BI with appropriate data governance, consistency and data accuracy.

• Analyze and understand business needs to define and recommend solutions that deliver value to stakeholders.

• Help Commercial business owners to make informed business decisions.

• Responsible for maximizing analytics efficiency across use cases, managing flexibility to support S&OP cross-functionally.

• Ability to lead data stewardship activities and implement data governance policies for responsible use of data

• Demonstrated success influencing senior level stakeholders on strategic direction based on recommendations backed by in- depth analysis.

• Coach and mentor project team members to complete high-caliber projects. IMPACT BUSINESS GROUP(Client Whirlpool), St. Joseph, MI 2019 Data Analyst - Strategy

Report standardizing and improving all of sales reports to drive more effective dashboards and metrics that will deliver predictive & easily accessible insights (400+) users. Created a centralized system for all reporting consuming SAP data, across the sales department and reduced the number of dashboards/reports and locations from hundreds to a handful and more than twenty to one respectively.

• Worked collaboratively across different channels to set overall data strategy for sales on SAP data.

• Designed operational process for driving efficient continuous improvements and monitoring.

• Ability to independently analyze data, generate relevant insights, present to diverse audiences, and convey sophisticated findings in a clear and impactful way.

• Ability to engage optimally with the technical teams and chip in to design of robust solution designs to address business needs

• Collaborated with cross functional teams across the organization to translate business needs into technical solutions.

• Analyzed and processed complex datasets using advanced querying, visualization and analytics tools.

• Worked with infrastructure/security to make sure that the data is legally compliant with laws like SOX, PCI etc. THULASIRAM CHEMICALS, Erode, TN 2014 - 2018

Data Scientist/Data Specialist

Led high profile data science projects in a fast-paced, high performing environment. Analyzed terabytes of data and built complex data science solutions. Worked across multiple business units and teams to define and develop data science solutions for products that take the organization to the next level. Resolved issues with unclean data including metrics for data quality.

• Analyzed and processed complex datasets using advanced querying, visualization and analytics tools.

• Data mining using state-of-the-art methods.

• Processed, cleansed, verified the integrity of data for analysis. Sumitharani Chinnasamy

• Exploratory data analysis (e.g. clustering/segmentation) to generate new insights & inform business.

• Done feature selection, built and optimized classifiers using machine learning techniques.

• Applied/Developed appropriate statistical, machine learning algorithms based on deep drive statistical analysis and predictive data modeling to large scale, high-dimensional and streaming data that were used to improve the business results.

• Interpreted and communicated analytical results to non-analytical and analytical executive business decision makers and partners. Worked with stakeholders throughout the organization to build proof of concepts for new business solutions.

• Efficiently explore new data sources and assess data gathering techniques.

• Helped to conceptually frame and refine relevant business questions.

• Coordinated with different functional teams to implement and productionize models while monitoring the performance. IBM Pvt Ltd, Chennai, TN 2013 -2014

Data Engineer

ETL developer in an agile, demanding environment and driven to understand and meet customer expectations, deliver defect free software, and follow architectural best practices. Involved in the design and development of all stages of the ETL lifecycle, including Linux scripting for automation and batch processing, working with large amounts of data in disparate formats.

• Data warehouse implementations using Informatica PowerCenter 9.x/8.x/7.x, Oracle 11g/10g/9i, Netezza, MS SQL SERVER 2008/2005, DB2

• Fetched data from legacy sources (different flat files) using ETL Informatica Power Center and loading into the data warehouse, monitoring and automating it with unit testing.

• Proficiency in utilizing ETL tool Informatica Power Center 9.x/8.x/7.x for developing the Data warehouse loads.

• Expertise in designing ETL Architecture involving Source databases Oracle, Flat Files ( fixed width, delimited),DB2, SQL server, XML and Target databases Oracle, SQL server, XML and Flat Files ( fixed width, delimited). Have Good understanding of ETL/Informatica standards and best practices, Slowly Changing Dimensions (SCD1, SCD2, and SCD3).

• Strong knowledge of Dimensional Modeling, Star and Snowflake schema. Designed Fact and Dimension Tables as per the reporting requirements and ease of future enhancements.

• Extensive Experience in designing and developing complex mappings applying various transformations such as lookup, source qualifier, update strategy, router, sequence generator, aggregator, rank, stored procedure, filter joiner and sorter transformations. Extensive experience in developing the Workflows, Worklets, Sessions, Mappings, and configuring the Informatica Server using Informatica Power Center.

• Excellent knowledge in identifying performance bottlenecks and also in tuning the Mappings and Sessions by implementing various techniques like partitioning techniques and pushdown optimization.

• Experience in creating Sessions, Workflows and Worklet by using the Workflow Manager tools like Task Developer, Worklet and Workflow Designer. Experience in optimizing query performance, session performance and fine tuning the mappings for optimum performance.

• Strong Knowledge in Relational Database Concepts, Entity Relation Diagrams, Normalization and Denormalization Concepts. EDUCATION

The UNIVERSITY of Cumberlands, Williamsburg, KY AMRITA SCHOOL OF ENGINEERING, Coimbatore, TN Masters in Information Systems Security (2018-2019) Bachelors in Computer Science (2009-2013) CERTIFICATION

Microsoft Technical Associate in Database Management Systems (DBMS) Cognizant certified in IT Foundation Skills

Contact this candidate