Aditya Sharma

Client : Cummins

Roles & Responsibilities:

As a BI Lead, I oversee the development of assigned requests within each sprint cycle in Jira, ensuring alignment with project objectives. Responsibilities include:

• Analyzing the description of requests and coordinating clarification calls with clients to gather necessary information.
• Proficiently working with SQL Server, serving as both a developer and administrator, to manage data and database structures effectively.
• Expertise in SSAS development, including building multidimensional models and creating relationships for optimized data analysis.
• Utilizing SSIS for ETL processes, seamlessly loading data into SQL Server from various sources and transforming it as required.
• Implementing data modeling techniques to design efficient structures and relationships within SSAS models.
• Conducting thorough performance testing prior to deployment, ensuring the reliability and efficiency of developed solutions.
• Deploying SSAS cubes and Power BI visuals to production servers, adhering to best practices and deployment protocols.
• Creating and scheduling jobs for SSIS packages to automate data integration processes and ensure timely execution.
• Managing Confluence pages for each request by meticulously crafting System Integration Test (SIT), Rollback Plan, and Production Deployment Guide documentation to ensure comprehensive project oversight and seamless implementation.

This comprehensive skill set enables me to effectively lead BI initiatives, ensuring the delivery of high-quality solutions that meet both client requirements and organizational objectives.

Client : BCBSMN

Roles & Responsibilities:

• Developed Microsoft Power BI Dashboards to showcase the result of data analysis from the database
• Integrated custom visuals based on business requirements using Power BI desktop for better clarity of information
• Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards
• To create a single location of all commercial material (inventory) for leaders Create an Executive P&L dashboard of commercial markets that include, Financial Metrics, Enrollments, Win/Loss %, Market Share, Claims & Utilization Performance
• As Dashboard Developer, primary activities included designing technology roadmap for Power BI; product installation and implementation development of insightful dashboards; serving as SME point of contact for Power BI and delivery of solutions adhering to BI industry best practices.
• Involved in publishing Power BI Desktop reports to the Power BI service from QA server to Prod Server
• Experienced in creating complex SSIS packages using proper control and data flow elements with error handling
• Designed and developed SSIS packages to move data from various sources into destination flat files and databases
• Created tables, running ETL jobs, writing dynamic scripts to generate stored procedure, creating tables etc
• Use Azure DevOps as agile software development.
• Creating packages in the solution explorer (In EXTRACT, TRANSFORM AND LOAD) and writing SQL query in data flow task, creating variable, error handling process and writing functions.
• In adherence to agile principles, I meticulously execute User Acceptance Testing (UAT) and System Integration Testing (SIT) on the client's specified document, guaranteeing its preparedness for smooth deployment to production.

• Conduct comprehensive data collection, analysis, and reporting of various Key Performance Indicators (KPIs) to meet business needs.
• Utilize advanced analytical techniques to identify, analyze, and interpret trends or patterns in complex datasets.
• Generate daily, weekly, and monthly reports to provide insights and support decision-making processes.
• Collaborate with management to prioritize business and information needs, establishing new reports as required.
• Execute ad-hoc reporting to facilitate critical business decisions.
• Leverage expertise in MSSQL, Advanced Excel, MS Power BI, and other client-specific data analysis tools to create reports.
• Coordinate with cross-functional teams and project clusters to understand business needs and deliver tailored reporting solutions.
• Act as the primary liaison with vendors and clients for data assignment, changes, and report modifications.
• Take ownership of documentation and propose innovative solutions to address emerging business needs.

• Extract, load, and transform data from the enterprise data warehouse (SAP Business Objects) and other sources
• Quality check the data
• Analyse financial and non - financial data to identify trends
• Build data visualizations, including infographics, to help executives consume and leverage the data
• Perform ad hoc financial analysis as needed and take on assigned strategic initiatives
• Design, develop, implement, and maintain data models to be used by various reporting and data discovery tools
• Ensure that data is available to decision makers through reports that you create, as well as self-service methods.

• Involved in managing new customer acquisition and existing customer relationships under Trust Association Societies & Clubs
• Producing business from existing accounts and achieving higher profitability levels & sales growth by offering them different products and solutions like: Fee management solutions 2) Cash management solutions 3) Cheque truncation system 4) Corporate user group cards
• Understand client requirement and prepare business required document contains client financials, product costing, estimation of the turn around time to deliver the required solution
• Offering of Fee management solution helps the client smooth running of all fee collections processes by providing services like CUSTOMIZED REPORTS and RECONCILATIONS.

• To study the B2B marketing of Software Solutions in US Market and have to do research on eastern and central U.S region and find out IT people through different web tools also find out those organizations to which Bitwise can offer services like BUSINESS INTELLIGENCE.