SUMMARY

• Extensive experience in building and delivering SQL Server and MSBI solutions following Software Development Life Cycle (SDLC) from Analyzing and understanding requirements thru user acceptance testing and go - live activities in Agile environments.
• Strong knowledge in database design, data modeling, creating database objects, and reusable DB scripts using MS SQL according to Business Logic.
• Expertise in implementing T-SQL Database objects like Indexes, Triggers, User-defined Functions, and Stored procedures using Dynamic SQL.
• Highly experienced in creating and executing SSIS packages to extract, transform and load data. Worked extensively on various data sources and different transformations in SSIS.
• Experience in error handling and event handling: Precedence constraints, breakpoints, and checkpoints towards SSIS package execution.
• Expert in using various report formats such as tables, pie, charts, gauges, maps, and indicators and developing various reports like Drilldown, Multi-level Drill down, Cascading, Parameterized, and Sub-reports using SSRS.
• Knowledge in creating cubes, maintaining, and deploying using SSAS.
• Strong knowledge in Power BI to create interactive and analytical visualized reports and dashboards to provide insights into data-driven business decision-making.
• Extensively used DAX functions in Power Pivot to write complex calculations, measures, and functions to support report and dashboard requirements.
• Strong knowledge in Software Testing Life Cycle and Bug life cycle, defects by severity, nature, and priority.
• A well-organized, goal-oriented, highly motivated, and effective team player with excellent analytical, troubleshooting, and problem-solving skills.

TECHNICAL SKILLS

Databases and Tools: MS SQL Server 2012/2014/2016/2017 , MS Visual Studio, SQL Server Management Studio, Oracle, MySQL, Azure SQL, JIRA, Power BI

SQL Server Data Tools: SSIS, SSRS

Languages: C#, T-SQL, Python

MS Office Tools: Microsoft Office Suite/ Access/ Excel/ Visio/ Project/ Teams

Collaboration Tools: Subversion (SVN), GitHub, SharePoint, Team Foundation Server (TFS)

PROFESSIONAL EXPERIENCE

Confidential, Detroit, MI

Power BI Developer

Responsibilities:

• Created analytical dashboard and reports with slicers to enable end-user to make filters.
• Created navigation pane with button bookmarks in Power BI reports maneuvering.
• Designed and Developed Power BI dashboards from multiple sources like SQL Server and IPG axis.
• Build various Power BI reports and dashboards for GM to monitor sales, after-sales, and redemption points using Charts, Tables, KPI, Slicers, Maps, and custom visualizations.
• Utilized Power query in Power BI for data cleansing and data massaging entry of teh ticket and resolved time before making visualization according to teh requirement.
• Implemented Visual Level, Page-level, report level filters, and pinning in dashboards.
• Created a paginated report in Power BI report builder for teh client to print all teh table data.
• Created a scheduled automatic refresh for teh client by connecting teh lineage to get teh latest data.
• Published Power BI Reports and dashboards in Power Bi premium workspace and scheduled automatic refresh weekly for teh client to access it.
• Created a guide for teh Power Bi reports for teh client to understand teh report and uses of teh report like filters and slicers in navigation.
• Worked with teh UAT/QA testing team, creating test scripts to validate Dax queries and data against Hadoop data.
• Embedded Power BI reported on teh One Drive and SharePoint portal and managed access to reports.

Environment: MS SQL server2017/19, SQL Server Management Studio, SharePoint, One Drive, Power BI Report Builder, Power BI Desktop, Power BI Desktop Report Server

Confidential

SQL BI Developer (SSIS, SSRS, Power BI)

Responsibilities:

• Understood and analyzed teh requirements for teh user stories allocated during each sprint, worked with Business Analysts, Testers, and other developers, and designed teh solutions with an eye on how these might affect other work.
• Modified database scripts and maintained database objects (stored procedures, triggers, views, and functions) according to user stories.
• Designed and developed ETL (Extract, Transformation, and Load) strategy to populate teh data from various sources using SQL Server Integration Services (SSIS).
• Developed and designed complex packages using data transformations (Lookup, Expressions, Variables, Derived column, Aggregator) to get reliable and quality data.
• Developed Tabular, Matrix, Drill-down, and parameterized reports using SSRS for claim details, claim rejections, and inventory overviews daily, monthly, quarterly, and yearly.
• Created Power BI visualizations using Ole DB, Excel, and other remote facility sources.
• Extensively used DAX functions in Power Pivot to write complex calculations, measures, and functions to support report and dashboard requirements.
• Build various Power BI reports and dashboards to monitor teh data for claims, inventory, replenishment, and reimbursement using Charts, Tables, Maps, and custom visualizations.
• Published Power BI Reports and dashboards, scheduled automatic refresh in Power BI portal, and made them available for web and mobile apps.
• Worked closely with UAT/QA to resolve teh bugs by changing and updating teh codes and store procedures to get teh required functionality.
• Participated in teh standup meeting daily to give status and regular meetings to autanticate teh requirement matches database design.
• Worked with teh Product Manager and Business Analyst to identify requirements and develop user case stories.

Environment: MS SQL server2017/19, SQL Server Management Studio, SSIS, SSRS, MS Visual Studio, Power BI, JIRA, SVN

Confidential

Power BI Developer (SSIS, SSRS, Power BI)

Responsibilities:

• Extensive knowledge in database concepts, data modeling, modifying scripts, tables, views, and stored procedures using SQL.
• Developed complex mapping using SSIS to transform and load data received from teh marketing department into teh Promotion data warehouse.
• Created and modified streamlined ETL process for Data transformation, Data Manipulation, and Data migration as per changing requirements of teh business.
• Modernized legacy reports and enhanced existing reports by updating embedded scripts to teh Stored Procedures.
• Expertise in developing various reports like Drilldown, Multi-level Drill down, Cascading, Parameterized, and Sub-reports using SSRS.
• Expertise in DAX functions in Power Pivot and created complex Calculated Columns and Measures in Power BI desktop to show data analysis.
• Utilized Power maps to display insights and build-in Drilldown report in Power BI.
• Designed and Developed Power BI dashboards from multiple sources and made them available for web and mobile apps.
• Deployed Power BI reports and dashboards using teh SharePoint portal to manage access based on teh user roles.
• Participated in a weekly meeting and interacted with team, team lead, and technical managers to understand teh requirements.

Environment: MS SQL server2016/17, SQL Server Management Studio, SSIS, SSRS, MS Visual Studio, Power BI, SharePoint, Teams

Confidential

SQL Developer (SSIS, SSRS)

Responsibilities:

• Created SSIS package using ETL process to extract, transform and load data into teh data warehouses.
• Developed and designed mapping using data transformations (Lookup, Expressions, Variables, Derived column, Aggregator) to get quality data.
• Extensively used control flow tasks to provide structure, functionality, and constraint to join flows.
• Worked on SSIS performance tuning using counters, error handling, event handling, and re-running failed SSIS packages using checkpoints.
• Created, designed, and deployed multiple reports like Parameterized, Drill-down, and Drill through reports in SSRS.
• Developed and analyzed Ad-hoc reports using SSRS to present information about teh clients.
• Improved teh performance reports by using teh report cache and optimizing data sets.
• Created modern data visualization based on business requirements using Power BI desktop.
• Created analytical dashboard and reports with slicers to enable teh end-user to apply teh filter.
• Published Power BI Reports in teh required destination and scheduled automatic refresh.
• Handled a problem-solving scenario and provided technical assistance with troubleshooting reports by responding to inquiries and questions.
• Participated in a meeting with teh team lead, business analytics, and end-users to test data warehouse applications.

Environment: MS SQL server 2016/14, SQL Server Management Studio, SSIS, SSRS, MS Visual Studio, Power BI, Team Foundation Server (TFS)

Confidential

Report Analyst (SSIS, SSRS)

Responsibilities:

• Installed, updated, and configured MS SQL server 2012/8R2/8.
• Designed and developed databases, tables, views, and stored procedures.
• Created ETL packages using SSIS, focusing on teh performance issue and data cleansing.
• Developed and analyzed Ad-hoc reports using SSRS to present information about teh clients.
• Created a Cascading parameter and Drilldown reports showing customer information detailly.
• Designed reports demonstrating teh claim process, filed date, teh status of teh claim, and invoicing process of teh patients.
• Created KPI and monthly reports to help billing identify gaps in teh claim process.
• Exported data from SSRS report to several file formats like PDF and Excel according to requirements.
• Participated in meetings and created a summary report with actionable decisions.
• Effectively participated with team lead to ensure database and software solutions.

Environment: MS SQL server 2012/8R2/8, SQL Server Management Studio, SSIS, SSRS.