SUMMARY

• Business Intelligence developer with strong SQL Server development and reporting and ETL experience.
• Expertise in MS SQL Server 2012/2008R2 and later versions and Business Intelligence including SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).
• As a part of the team, extensively involved through the Software Development Life Cycle (SDLC) from initial planning through implementation of the project.
• Worked extensively on Database Design, Development, Implementation, ETL and Reporting in MS SQL Server with expertise on Data Normalization.
• Good knowledge of data design methodology including logical and physical data modeling.
• Involved in analysis of source systems, data profiling and identification of business rules in building a DataWarehouse.
• Good knowledge in Database Backup using custom scripts and creating regular backup plans.
• Proficient in performing data transformations like Fuzzy Lookup, For Each Loop, For Loop and Sequence Container using SSIS.
• Hands on experience in using Business Intelligence Development Studio (BIDS) graphical user interface (GUI) to design SSIS packages for data management applications.
• Extensive experience in generating different type of reports including parameterized reports, formatted reports, tabular forms, matrix forms, cached reports, drill - down reports, drill through reports, charts and sub reports using SSRS 2008R2/2012.
• Experienced in SQL Server Analysis Services (SSAS) to deliver online analytical processing (OLAP) and data mining functionality for business intelligence applications.
• Strong troubleshooting skills in Error and Event Handling: Precedence constraints, Break Points and Check Points.
• Worked on Proof of concept and implementation of Azure Data Factory (ADF), Azure Data Lake (ADLS), Azure Synapse.
• Proficient in Query tuning, query optimization and knowledge of handling Deadlock situations in SQL server.

TECHNICAL SKILLS

Development Tools: MS Visio 2015/12/08, SSIS, SSRS, SSAS, Arc GIS, SQL Server 2014/12/08R2, Azure Data Factory GEN1, Azure Data Lake, Key Vault, Azure Synapse.

RDBMS: MS SQL, Oracle, MS Access, MS Office Excel, SQL Profiler, ODBC, OLAP, OLTP, OLEDB

Data Modelling Tools: MS Visio, ER-WIN, Information Design Tool, MS Project

Reporting Tools: Tableau Desktop & Server, Power BI, SSRS

Web Technologies: HTML5, XML, PHP

Programming Languages: C, C#, Core Java, Python, T-SQL

Version Control: TFS, VSTS, Share Point, Agile, Kanban, GIT, Azure Devops

PROFESSIONAL EXPERIENCE

Confidential

Power BI/Azure Developer

Responsibilities:

• Designed complex mappings and reviewing technical documentation with business logic.
• Understanding healthcare industry terminology and coding (e.g., NDC11, ICD9/ ICD10, HIPPA, CPT, LOINC).
• Performed various data cleansing and validation on the data to ensure the data integrity.
• Used various tasks like execute SQL task, notify operator task, execute process task in the ETL packages.
• Implemented transformations like Derived column, OLEDB Command, Multicast, Lookup, Sort and tasks like to implement the business logic while loading the data to target destinations.
• Written Stored Procedures for commonly used complex queries involving join and union of multiple tables.
• Created tables for Data Warehousing Applications (OLAP system) and populated the tables from the OLTP database using SSIS packages.
• Created, Scheduled, published many visualizations and complex executive dashboards like Sales, regulatory and other mobile view dashboards for store managers etc.
• Well experienced in writing DAX functions and utilized it to achieve maximum functionality for the dashboards and reports.
• Experienced in Translating business needs and data related concepts to both technical and non-technical audiences throughout the organization creating UI/UX if required.
• Utilized bookmarks and switches to create new functionality and visualizations in the reports.
• Developed reports in PBIX and used PBIX Templates to save it in the version control for easy access.
• Implemented roles and rules in role-based security (RLS) for hierarchical data such regional managers and sales executives.
• Worked with Configurations in Azure Data Factory to execute the SSIS Packages in Azure.
• Created custom visualizations for regulatory reporting leveraging Python libraries like Matplotlib, Plotly and Pandas.
• Worked on setting up Gateways and scheduling refreshes of the datasets.
• Worked on Import, direct and live models and created data models for better utilization of existing data.
• Created calculated columns, measures, filters, slicers, variable, maps, tool tips and many functionalities in PBI Desktop.
• POC on new updates and custom visuals when needed to bring more understanding to the reports with my visualizations.

Confidential

SSIS/SSRS/Power BI Developer

Responsibilities:

• Worked with Product Owners to identify requirements for the dashboards and reports and develop design Specifications, Data Dictionaries and Source to Target Mapping documents.
• Worked with Multiple Data Sources for Development of Dashboards in Power BI
• Developed a Data Model and E-R diagrams for the Analytics Data mart using Microsoft.
• Visio and knowledge in implementation of Star, Snowflake and Hybrid Schemas.
• Developed ETL Pipelines, Data Flows, Control Flows using Azure Data Factories.
• Worked on Identifying Slow running Stored Procedures and tuning them using Performance tuning techniques and optimizing the queries by Identifying bottlenecks.
• Worked on Complex Stored Procedures, User Defined Functions and building indexes.
• Used Oracle, SQL Server, Excel, Azure Synapse as Data sources and prepping data (SQL) at the background to create reports suggested users about visualizations, colors, themes and following best practices to make a dashboard look the best.
• Experience in working with both DB2 and T-SQL queries and wrote complex Stored Procedures using Dynamic SQL.
• Well versed with Time Intelligence functions for creating reports based on Historical Data such as YTD, MTD, Previous Year etc.
• Wrote Advanced Calculations in DAX and Power Query to support the Dashboard requirements.
• Experience Creating Build and deployment pipelines using Azure Dev ops for SSIS, Azure Data factories, SSRS and Database Deployments.
• Worked on Database Admin Tasks such as Backup and Restoring the Databases, Installation of SQL Server and Build Agents, Migration of Database, and log Shipping.

Confidential

BI Developer

Responsibilities:

• Designed and developed Power BI graphical and visualization solutions with business requirement documents for creating interactive dashboards.
• Created Power BI dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts etc.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes, and views using T-SQL in SQL Server 2005.
• Assisted in various Ad hoc query requests. Integrated custom visuals based on business requirements using Power BI desktop for better clarity of information.
• Experienced across entire MSBI Suite of products including SQL server, SSIS, SSAS, SSRS and Power BI SDLC from prototyping to development.
• Developed custom calculated measures using DAX in Power BI. Developed Microsoft Power BI Dashboards to showcase the result of data analysis from the database.
• Used various sources to pull data into Power BI such as MS Excel, SQL Server.
• Connected Power BI to various databases and performed live data connections, query auto updates on data refresh.
• Handled clients for payments, job status, reminders, Inter-Company invoices, Future dated invoices and VMD requests.

Confidential

SQL Developer

Responsibilities:

• Actively involved in JRD sessions to understand the business logic and available resources.
• Created mapping documentation and mapped the required business elements from sources to pre-staging and staging.
• Extensively used SSIS to extract wide range of data from different sources like flat files, Excel, Oracle, Teradata into SQL server databases.
• Conducted ETL and data integration process in SQL Server environment using SQL Server Integration Services (SSIS) and performed transformations like Fuzzy Lookup, Conditional Split, Aggregate and bulk insert task depending on business requirement.
• Worked extensively troubleshooting SSIS packages with checkpoints, breakpoints, and data viewers.
• Involved in identifying the queries which are running slow using SQL Server profiler and tuning them by different methods like evaluating the joins, indexes, updating statistics and code modifications.
• Performed UAT testing on packages to verify the business logic.
• Experienced in project deployment and coordinating with production environment.
• Generated snapshot reports based on the statistical analysis of the change data from various time frame using SSRS.
• Experienced in generating report elements for consolidated financial statements for the annual report using claims and under writing data.
• Generated various reports like parameterized reports, bar graphs using stored procedures in SSRS.
• Involved in creating Database objects - tables, views, and functions and developing procedures for implementing application functionality at the database side for performance improvement.