| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Email: EMAIL AVAILABLE Phone: PHONE NUMBER AVAILABLEProfessional Summary:12+ years of experience in Business Intelligence using Reporting and Data Warehousing tools in Insurance, Government, Healthcare, Retail, Finance, Accounting, and pharmaceutical applications.Strong experience in development of standard reports, visualizations, dashboards, and ad hoc reports using SQL Server Reporting Services (SSRS), Power BI, SSAS, SAP Business Objects, Tableau, and Crystal Reports.Experience with data ingestion, transformation and data pipeline development using SSIS, Informatica and Azure Data Factory and AWS Glue.Extensive experience in gathering requirements from users and transforming them to technical specifications.Experience in maintenance and support of data warehouse applications, resolution of production incidents and continual service improvements.Good experience in writing and tuning complex SQL queries, incorporating them into reports and optimizing them for performance.Experience working as a Business Intelligence Lead and providing support to developers for solution design and peer reviewing the code.Implemented Row-Level Security for the reports and dashboards to restrict the data based on permissions and access levels.Strong knowledge of database design, OLAP, OLTP data platforms and dimensional data modeling using Star, Snowflake schemas.Experience in the development of Business Intelligence applications in cloud environments with Microsoft Azure, Power Platform and Snowflake.Experience with workflow automation using Microsoft Power Automate and integration of Power Apps with Power BI.Good understanding of Artificial Intelligence and Machine Learning concepts like regression, clustering models, classification and predictive modeling using R, Python and Scikit-learn.Experience in analysis, scheduling, and monitoring of SSIS packages, data analysis at source and target systems for ensuring data quality and accuracy.Extensive experience in Unit/ Integration/ Regression and User-Acceptance testing.Strong knowledge of Incident, Problem, Change and Release Management processes.Extensive experience in interacting with clients and providing training to end users.Excellent interpersonal, business communication and documentation skills.Technical Skills:Business Intelligence Tools: Microsoft BI Stack (SSRS, SSAS, SSRS), Power BI, SAP Business Objects, Crystal Reports Tableau, SSIS, Informatica PowerCenter 9.1/9.6, Azure Data Factory, Alteryx, SnowflakeLanguages: C#, SQL, T-SQL, PL/SQL, HiveQL, PowerShell, PythonDatabases: Microsoft SQL Server 2008 R2/ 2012/2014/2016, Azure SQL, SAP BW/4 HANA, Oracle 10g/11g/12c, IBM DB2, Redshift, Netezza, Teradata, HadoopData Modeling Tools: ERwin Data Modeler, Microsoft VisioScripting: VB, C#Configuration Tools: TortoiseSVN, JIRA, GIT, Microsoft Tools (Team Foundation Server, SharePoint, Power Automate, Power Apps)Office Tools: Microsoft Word, Excel, PowerPointWork Experience:Client: Aramark Philadelphia, PA (January 2024- Present)Role: Consultant- Sr. Microsoft BI/Power BI DeveloperResponsible for development and maintenance of analytics solutions in a cloud-environment consisting of Azure, Power BI, SSRS, Snowflake, Oracle and SharePoint.Developed semantic models, dashboards, dataflows for enterprise analytical reporting applications using Microsoft Power BI, for modules like Point of Sales (POS), Revenue and Weekly Financials.Maintenance and supporting of existing production applications involving incident management, change management and enhancements to existing reports and semantic models.Created Calculation Groups for critical financial reporting measures using Tabular Editor and performed bulk updates to the measures.Improved the UI/UX for the reports utilizing bookmarks, buttons and implemented drill through functionality.Coordinated with offshore team on the reporting deliverables, delegation of tasks and provided updates to senior leadership.Triaged the production issues and worked with Oracle and Snowflake data engineering teams for the resolution of data issues.Performed data analysis and multiple stages to validate data accuracy and ensure data quality.Tuned the performance of existing DAX measures using external tools like DAX studio and significantly improved the refresh times.Client: Commonwealth of Pennsylvania (December 2021 January 2024)Role: Consultant- Sr. Microsoft BI/ Power BI DeveloperDeveloped Power BI Dashboards, Datasets and Paginated reports in Azure Government cloud environment for the Online application system for the general government delivery center.Designed and developed custom tables for reporting, created data pipelines using Azure Data Factory for data ingestion from multiple sources and created transformations required for reporting.Created reports and dashboards with Power BI Embedded and incorporated into the .NET & Angular based web application.Worked on the data re-structuring to design the data into a reporting-friendly format, created several views, Power BI Data Flows, and stored procedure to consolidate the data as per the requirements.Successfully handled and validated the migration of the reporting platform from Microsoft Dynamics CRM to Power BI in coordination with project team comprising Application Developers, Database Developers and API/Middleware team.Developed the reporting and dashboard solutions in Azure environment using Microsoft 365, Azure Analysis Services, Azure Active Directory and Power Platform (Power Apps and Power Automate).Created ad-hoc datasets in Power BI for the super users to create their own ad hoc queries in Power BI Service.Implemented Row-Level Security for the reports and dashboards using the security tables and created the access groups based on user permissions.Designed canned reports using Microsoft Power BI Report Builder (SSRS) for the invoice style reports.Set up the workspaces in Power BI Service and configured the data gateways for better control of the cloud data sources.Created custom SQL specific for reports to improve the performance and significantly improved the report run times.Worked with web application developers to embed the report content into the application and established connections to SharePoint data sources.Worked with end users to provide training and support on using the Power BI platform and prepared a user guide for accessing canned reports and creating reports using published datasets.Client: Albertsons (November 2020- December 2021)Role: Consultant- Sr. Microsoft BI/Power BI Developer - LeadWorked on the development of reporting solutions using Power BI Desktop and Report Builder (paginated reports) for multiple modules for the retail operations reporting in a cloud environment using Snowflake and SharePoint data sources.Worked on critical reporting modules like Profit & Loss, Workforce Management, EBITDA (Earnings Before Interest, Taxes, Depreciation, and Amortization) Sales and Self-Checkout etc., for enhancements, production bug fixes and data issues.Worked with Product Owners and Subject Matter Experts to gather requirements, create dashboard mockups, and understand the underlying details for the calculation of measures.Led a team of 2 offshore BI developers and delegated the tasks for individual report modules as required for the overall reporting application development.Created bridge tables to implement Row-level Security and created connections in the model with the corresponding Fact tables.Implemented Row-Level security at Division/District/Store & Department levels.Created custom views in Snowflake for data aggregations for desired granularity at daily/weekly/period/quarter levels. Also worked on restructuring dimension tables for product hierarchy, calendar, facility, and locations for modeling in Power BI.Developed critical consolidated dashboard encompassing metrics from multiple modules for a holistic overview of the retail operations, the modules include workforce management, net promoter system, store added orders, self-checkout, service efficiency and units per labor hour.Created dashboards for monitoring productivity at the summary and detail level on a weekly basis with 6 weeks of rolling data using gauge charts (actuals & targets), area charts with 6-week trend and department wise metrics.Worked on multiple modules to dynamically filter out the store details based on effective start and end dates using custom views and modify queries in Power Query.Supported data engineering teams for data validations and creating test reports to validate the output for critical finance modules.Client: Blue Shield of California San Francisco, CA (April 2019- October 2020)Role: Consultant- Sr. Microsoft BI/Power BI Developer - LeadCreated visualizations, datasets and dashboards using Power BI for the super users and senior leadership from multiple business units.Created custom measures, expressions, and calculations using DAX as per the functional requirements.Designed and maintained data pipelines in SQL Server environment for the creation of reports and visualizations for multiple reporting applications.Designed and developed tabular models using SSAS as per data requirements and deployed them with tabular server mode configurations.Set up the security tables in coordination with DBA teams for implementation of Row-level Security.Managed connections using XMLA endpoint for Power BI datasets to heterogenous data sources.Designed and developed transactional and analytical reporting solutions for Claims, Membership, and Data Services areas using SQL Server Reporting Services (SSRS).Triggered flows from Power BI reports using Power Automate by selecting pre-defined list of fields and created dynamic scenario-based flows.Integrated custom and existing Power Apps into the Power BI reports based on the functional requirements.Performed data analysis using Power Pivot and presented the data insights to senior leadership.Worked on report, visualization, and dashboard development in Azure environment.Managed users, folders and groups and implemented row-level data security based on access level.Fixed the code issues in the existing SSRS reports and incorporated new functionality into the reporting applications as per the business requirements.Worked with data architects and data engineers on the migration of Informatica PowerCenter to PySpark.Deployed the code to multiple environments and provided support during code migrations. Worked with the QA team to resolve the defects and the re-deployment of code.Provided training sessions to offshore team and business users on the reporting applications.Client: Geisinger Health Plan Bloomsburg, PA (October 2017- March 2019)Role: Consultant-Sr. Business Intelligence DeveloperDesigned complex reports in SAP Business Objects and SSRS using drill-down, parameter, linked and sub-report functionalities.Created visualizations and dashboards in Power BI for performance management applications using KPIs and Scorecards.Created critical reports for the finance teams to identify the potential groups (multiple members) that require reconciliation and follow up every month regarding the health insurance premium amounts.Designed tabular models and created datasets as per the requirements and created technical design documents.Tuned the performance of existing reports (SQL queries) and resolved the production incidents related to reporting applications. Peer reviewed the code of team members and provided feedback/ suggestions as needed.Incorporated detail and summary information tabs into the reports and implemented drill down functionality and input controls.Created calculated fields, measures and formulas using DAX in Power BI environment, based on the reporting requirements.Created customized schedules for the reports by passing multiple input parameters to the reports at run time, thereby ensuring only a single report is used to generate multiple instances.Coordinated with ETL teams regarding the data loads and ensured the data quality and accuracy at multiple stages. Monitored SSIS jobs, handled errors and set up ad hoc schedules for failed jobs.Worked with database admins for the creation of custom DB objects needed for reporting.Created reports to identify errors within business processes, based on specific criteria, for the teams to identify and correct the health insurance claims and membership data.Migrated code to multiple environments as per standard procedures and in coordination with Admins and migration team. Provided post- production support for reporting applications.Conducted knowledge transition sessions for team members and training sessions for business users.Client: Blue Shield of California San Francisco, CA (August 2015- September 2017)Role: Consultant-Sr. Microsoft BI/ Power BI DeveloperDeveloped standard and ad-hoc reports using SSRS for mission critical applications of Blue Shield of California.Created interactive data visualizations and dashboards for claims, accounting, enrollment, and membership areas using Power BI for senior leadership.Worked with business users across multiple functional areas (Accounting, Billing, Claims, Finance, Membership Network and Customer Service) and created technical design documents.Created complex reports in SSRS using multiple data sources (Database, lists and CSV files), crosstabs and parameters.Tuned the performance of the existing report SQL queries having multi-joins, and multiple sub-queries. Reduced the report execution times to 4% of the actual run time for long running queries.Automated multiple data extraction, collation, consolidation, and reconciliation processes and reduced the manual efforts by 95%.Collaborated with ETL teams, Database Admins for resolving issues involving multiple dependencies.Successfully handled multiple projects at the same time by prioritizing the tasks and triaging issues.Worked extensively on root cause analysis of issues and implemented code changes for resolution.Created design documents and user training documents.Client: State of Illinois, Department of Human Services Springfield, IL (March 2015- Aug 2015)Role: Consultant- Sr. Business Intelligence DeveloperDeveloped reports using Business Objects and Crystal Reports for the clinical reporting system used by Primary Health and Mental Health centers.Designed and developed Business Objects Universes as data providers for the reporting system using derived tables, cascading list of values, custom hierarchies and @Functions.Gathered the requirements from the business users, analyzed the requirements and created a data model used for the development of Universes. Participated in ICD-10 project meetings with project lead, business analyst and business users to implement architectural changes to the existing reporting system and to accommodate the new disease codes into the reports.Created KPI Dashboards using Tableau for performance evaluation.Proposed and successfully implemented new security logic to include users windows AD account in place of database account and managed the credential mapping using the admin tool.Provided trainings to users on the reporting environment to get them up to speed using the new features of the reporting system.State University of New York at Binghamton Binghamton, NY (March 2014- February 2015)Role: Network and Data AnalystCreated a set up to capture the network data using network packet capture tools for data analysis.Created Tables, Views and stored procedures and loaded the captured network data into the database for analysis and reporting.Created Dashboards and Visualizations of the data related to network activity using Tableau Desktop.Created KPI reports to track the network data traffic and identify the network data patterns.Tech Mahindra Limited Hyderabad, Telangana, India (May 2011- January 2014)Role: Business Intelligence DeveloperDesigned and developed 70+ transactional and analytical reports using Business Objects, Crystal Reports for Online Planning and Authorizations Lifecycle applications.Created Business Objects Universes for multiple functional areas by designing data models and implemented security logic in coordination with the BO Admin team.Facilitated meetings with Data Architects, Project Managers, Business Analysts and ETL teams in delivering end-to-end reporting solutions.Extensively used formula fields, parameter fields, group selection and conditional formatting in Web Intelligence and Crystal Reports.Worked with DBA teams for creation of Tables, Views, Materialized Views, and indexes for reporting purposes.Provided maintenance and support services for the Crystal reports and out-of-the-box (OOTB) reports.Resolved production issues like slow running reports, bounced servers whenever required and made enhancements to the existing reports. Managed user accounts, groups, and folders of the BO Enterprise system.Worked with business users, gathered requirements, prepared technical documents, and provided design, development estimates to higher management.Education:Master of Science (MS) - Computer Engineering - State University of New York at Binghamton, NYBachelor of Technology (B.Tech.) Electrical & Electronics Engineering - Jawaharlal Nehru Technological University-Hyderabad, IndiaReferences: Furnished upon request |
