SUMMARY

• Over seven years of Experience in developing Business Intelligence applications, Data analytics using Microsoft BI tools and data visualization tools such as Tableau and Microsoft Power BI.
• Extensive experience in implementing BI and DW solutions in domains like Health Care, Insurance, Logistics, and Banking.
• Created query functions by understanding relationship between teh business functions and its datasets to analyze teh data and to find teh powerful insights.
• Deep understanding of Power BI tool capabilities and appropriate use cases to extract teh right value from teh data.
• Can efficiently use Power BI and Tableau for reporting, modelling and transforming teh data based on teh requirements.
• Expertise in creating dashboards, reports, stories wif visualization tools wif forecasting and optimization of data and by proficiently writing sql queries, user defined functions, views, indexes and stored procedures.
• Meticulous in analyzing complex data using data visualization tools like SSRS, Tableau, Microsoft Power Bi to find teh insights to improve decision making.
• Generated various types of reports like Tabular, Matrix and Charts using SSRS and created maps, animations, LOD dashboards using tableau.
• Created templates in SSRS and embedded KPI’s in web portal.
• Strong experience in Business and Data Analysis, Data Profiling, Data Cleansing, Data Migration, Data Integration and Metadata Management Services.
• Excellent in High Level Design ofETL DTSPackages& SSISPackages for integrating data usingOLE DBconnection from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided bySSIS.
• Can trouble shoot technical issues during teh ETL process, isolate teh root cause and take appropriate action to amend teh problem.
• In depth use of Data warehouse concepts, OLTP, OLAP, ETL, Star Schema, Snowflake, data modelling and SQL.
• Strong experience in SQL server integration services to integrate data from multiple heterogeneous data sources and to accelerate internal business processes.
• Experience in tableau report server development and deploying reports in tableau server and reporting services configuration.
• Experience inPerformance TuningandQuery Optimization.
• Exceptional analytical, qualitative, problem solving and critical thinking skills.
• Knowledge and aware of HIPAA privacy rules, ICD and CPT codes in healthcare domain.
• Implemented solutions using agile methodology by taking active part in sprint planning, Daily Scrum Stand Up, and Sprint Retrospective.
• Cultivated strong technical and soft skills to establish respect for teh real - time data and importance of probability.

TECHNICAL SKILLS:

• T-SQL
• SQL Server 2008/2012/2014/2016
• Tableau 8.1/9.0/10.2
• Power BI 2.53
• VS 2008/2012/2014/2015
• SSIS
• SSRS
• SSAS
• MDX
• DAX
• R Programming
• Oracle
• Teradata
• MS Excel
• MS Access
• Tidal
• Team City
• Octopus.

PROFESSIONAL EXPERIENCE

Confidential, Dayton, Ohio

BI Developer

Responsibilities:

• Interacted wif teh business users and business analyst to understand teh requirements and develop reports by following all teh reporting standards.
• Created and modified existing stored procedures to extract teh data and to develop reports.
• Developed SSIS packages to load all lines of business data into a single table and use that data to populate dashboard.
• Modified existing Power BI dashboards based on teh business user’s requirements.
• Worked on research stories to create STM for converting existing reports from Teradata to sql server.
• Developed SSRS reports in tubular, matrix and validated teh reports. Trouble shoot teh errors to break fix teh report issues.
• Actively involved in Agile methodology by participated in story grooming sprint planning, Daily Scrum Stand Up, and Sprint Retrospective, JAD sessions, Peer review.
• Identified teh factors involving teh performance of teh reports and coordinated in creation of indexes, statistics to improve teh query turnaround time efficiently.
• Deployed teh SSIS Packages and SSRS reports into all teh environments using team city and octopus.

Environment: SQL Server, Teradata, Visual studio, MS Office Tools, Tidal, Team City, Octopus, Agile Methodology.

Confidential, Eden Prairie, MN

BI Developer

Responsibilities:

• Interacted wif Business users, Business Analysts to understand business requirements and transform them into technical specifications.
• Involved in teh data migration from Teradata server to MSSQL Server of other reporting Systems.
• Created stored procedures, user defined functions, views, tables and T-SQL scripts for complex business logic
• Cleaned teh data source using SSIS and MS SQL Server using conditional splits and Stored procedures.
• Used audit batch process to track number of rows inserted or updated on teh tables.
• Grouped bunch of activities into one using sequence container and to organize things better.
• Generated a metadata for reporting using complex joins, Custom SQL, split and data blending.
• Designed, developed and managed metadata schema in regular intervals.
• Created a visualization dashboard which includes table calculations, calculated fields, filters, parameters, toggling, trend lines, clusters to meet teh business requirements.
• Leveraged teh power of visualization by making them interactive by creating groups and controlling them wif parameters.
• Deployed reports onto teh reporting server configuration.
• Deployed teh workbooks and live data sources to Tableau Server under row-level security environment.
• Modulated reports performance by recording and analyzing performance workbook on timeline and execution query, tuned andoptimized analysis, calculated fields, layout and data source
• Troubleshoot errors and find teh insights to solve teh business problems.

Environment: Visual studio 2014/2015, MS SQL Server 2014, MS Office Tools, Control M.

Confidential, Bloomington, IL

ETL Developer

Responsibilities:

• Understand business initiatives including technical and none technical requirements.
• Development, support and monitorof SSIS packages using Visual Studio.
• Created SQL queries, Store Procedures, Functions, Views, Triggers and other DB objects in different phases as per required.
• Extracted data from multiple sources like DB2, Oracle, Access, MySQL etc.
• Scrubbing and monitoring data to make sure that it meets legal requirements.
• Developed SSRS reports in tubular or matrixand deploy them onto teh server.
• Generated interactive reports by using cascading parameters, drill down and book marks.
• Involved in development of Dashboards like line graphs, bar graphs, area charts in Power BI using filters, drill down and drill through features.
• Transformed teh data wif teh help of DAX, Power pivot and power query for teh analysis using Power BI.
• Involved in assisting and assigning works to interns related to Power BI.
• Translated complex concepts in ways that can be understood by none technical audiences.
• Conduct code review to ensure delivery of high quality standards.
• Optimized teh reports performance by understanding teh end user’s interaction wif teh reports.
• Used TFS during development process to collaborate wifin teh team members.
• Used agile methodology for SDLC and actively participated in sprint planning.

Environment: SQL Server 2012, Visual Studio 2012, Power BI, Team Foundation Server, Oracle, MS Access, MS Excel

Confidential, Charlotte, NC

BI Developer

Responsibilities:

• Understood teh objectives that make a project scope and helped in improving overall efficiency of teh business functions.
• Performed data cleansing, data staging and transfer, and integrating and consolidating data from many usually disparate information systems and technologies.
• Created metadata for reporting services using joins, Custom SQL, split and data blending.
• TEMPEffectively involved in teh maintenance of Data Server, metadata management, creating shared Data sources and publishing them to Server.
• Created multi-dimensional models using SSAS.
• Implemented a process of continuous review to reaffirm, adjust or replace metrics and see to it that teh metrics measured are always optimal for achieving teh missions for which they are aligned.
• Reviewed Business requirements and prepared teh data and teh reports as per teh requirements.
• Developed various types of charts using SSRS to provide better visualization and to extract teh noledge from teh data.
• Created Ad Hoc Reports, Frequency Reports, Summary Reports, Drill-down, Dynamic grouping, graphical, aging reports using SSRS.
• Deployed and configured SSRS reports in SQL Reporting Services Server.
• Guided end users to interact wif reports to find insights.

Environment: Visual studio 2010, MSSQL Server 2008, MS Excel

Confidential, IL

BI Developer

Responsibilities:

• TEMPEffectively Involved in gathering teh requirements of teh project and analyzing them. And interacted wif teh client to analyze requirements in-depth.
• Extracted data from various sources and performed data joins and data blending.
• Developed crystal reports based on teh business requirement.
• Created different type of charts Like tabular, matrix, list, bar, pie charts.
• Created worksheets and dashboards using custom queries and multiple tables.
• Developed interactive reports using Cascading parameters, Embedded reports and bookmarks.
• Created templates in SSRS, placed into teh directory and modified teh templates as per requirement.
• Validated teh data for each report and reviewed teh reports before deploying.
• Executed and tested required queries and reports before publishing.
• Deployed reports on to teh server.
• Designed OLAP cube(s) and created facts, dimensions and star schema representation for teh data mart and warehouse systems to meet reporting requirements.

Environment: Visual studio 2010,2012, MS Office Suite, SQL Server 2008, MS Excel

Confidential

SQL Develope

Responsibilities:

• Understand teh business requirement document and supported team in designing database model.
• Created queries to store teh application’s data into teh database tables.
• Involved in developing conceptual and logical data base model to visualize database structure.
• Created database triggers for automation wif teh help of stored procedures for logging and storing information on table access, imposing security authorizations and preventing invalid transactions.
• Created indexes to improve database performance.
• Reviewed teh query performance and to optimize teh code.

Environment: SQL Server 2008, Share Point, MS Excel 2008