SUMMARY

• Over 7 Years of experience in the areas of analysis, design and development of SQL Server Databases & Business Intelligence solutions using Microsoft BI suite (SSAS, SSIS, and SSRS, Power BI) tools in Data warehousing applications.
• Database Design, Development, Data Modeling, and Implementation of business applications with RDBMS, Data Warehouse/Data marts, ETL, and client/server environment in various domains, on MS SQL Server 2008/2012/2014/2016/2017 , SSIS/SSRS/SSAS for both OLTP and OLAP Systems.
• Developed a thorough knowledge and maturity in all the phases understanding business processes, gather requirements, and coordinate ongoing iterative development of Software Development Life Cycle (SDLC).
• Experienced in working inAgileScrum, Waterfall andSDLCmethodology environments.
• Developed Tableau visualizations and dashboards using Tableau Desktop.
• Experience in maintaining the Log and Audit information in SQL tables, and providing Logging, Error Handling by using Event Handler for SSIS Packages.
• Experience in SQL server administrative skills including backups, disaster recovery, database maintenance, user roles, authentication and authorizations and database creation.
• Highly proficient in the use of SQL for developing complex stored procedures, triggers, tables, user profiles, user functions, relational database models and data integrity, SQL joins and query writing.
• Skillful in ETL - Extraction Transformation Loading, from heterogeneous sources (Excel, Flat file, .CSV file, Access DB, DB2) by using multiple transformations provided by SSIS. Such as Data Conversion, Conditional Split, Lookup, Derived Column, Sort, merge and union all.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using Power BI.Good in Analytical thinking for translating data into informative visuals and reports.
• Experience in creating and managing fragmentation of Indexes to achieve better query performance. Experience in SQL Profiler, Performance Tuning and Query Optimization.
• Optimizing the speed of database with tuning SQL queries, configuring database, changing database structure and redefining database.
• Strong experience in writing R and SQL scripts to manipulate data for data loads and extracts.
• Extensively worked on Table Design creating Clustered Indexes, Non-Clustered Indexes, Primary key Foreign Key Relationships, Highly complex joins and SQL Scripts for Views and Materialized Views.
• Adept in writing code in R and SQL scripts to manipulate data for data loads and extracts.
• Highly proficient in packages to extract, transform and load data (ETL) using SSIS, designed packages which are utilized for tasks and transformations Data Conversion and Pivot tables.
• Expertise inPower BI, Power BI Pro, Power BI Mobile.Expert in creating and developing Power BI Dashboards in to rich look.
• Have good knowledge in prototyping,designing and requirement analysis.
• Have good knowledge onAzure Data Lake,Azure Data Factory, SQL Data Warehouse Azure Blob, Azure Storage Explorer.
• Have a good knowledge on R and Python Programming.

TECHNICAL SKILLS

Languages: T-SQL, C, C++, HTML, CSS, JavaScript, XML,PL/SQL,DAX,MDX

Operating Systems: MS-DOS, Windows Server 2016/2012/2008/2003/ XP, UNIX/LINUX

RDBMS/ Databases / Database Tools: MSSQLServer 2017/2016/2014/2012/2008 R2/2005,R2/2008, Oracle 11g/10g/9i/8i, MS Access, SQL Server Management Studio, SQL Server Data Tools, Business Intelligence Development Studio (BIDS), Visual Studio, SQL Profiler, Performance Monitor, DTS, MySQL, SQL Query Analyzer, Management studio Index Analyzer, DTS Import/Export, Backup Server, Replication server, SQL Agents, SQL Alerts, SQL Jobs, Visual Source Safe

Data Warehouse Tools/Technologies: SSIS, SSRS, SSAS (VS - 2017,2015,2013)

Data Modeling Tools: Power Designer, MS Visio

Reporting Tools: MS Reporting Server (SSRS), Excel Power View, Tableau, Power BI,QlikSense

Microsoft Technologies: SharePoint, VB.Net,C#, ASP.NET

PROFESSIONAL EXPERIENCE

Confidential, Minneapolis,MN

SQL BI/PowerBI Developer

Responsibilities:

• Responsible for development of SSIS packages in accordance with business requirements.
• Create Database Objects - Tables, Indexes, Views, Stored Procedures and User defined functions according to the requirements of the project.
• Confidential is a health insurance provider for Medicare. My project is claim web apps for design, development and modify applications with the Product Owner and the business.
• Design SSISPackagesto transfer data from flat files to SQL Server using Business Intelligence Development Studio.
• Agile scrum team environment, 2-week sprints, daily stand up, team player, and collaborative.
• .MaintainAzure Devopsfor Task allocation and tracking the tasks to closure.Extensive use of ADO to organizeuser stories, tasks, defects and tests plan and track iterationssprintsand releases.
• Use ADO for making the development organization faster, leaner and moreagileand to get on the track with theUser storiesand to improve iteration planning practices.
• Develop reports and dashboards using Power BI based on the requirements on historical for healthcare data.
• Work with Azure, data bricks, Azure Data Factory for Code Pipeline, Code Build, Code Deploy and WinSQL for direct queries.
• Develop Datasets for the Reports and Dashboards. Write Stored Procedures for Reports / dashboards to pull data into Power BI query editor. Write the DAX Functions in Power BI and Power Pivot.
• Create reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector.
• Develop and test various Power BI visualizations for the dashboard and ad-hoc reporting solutions by connecting from different data sources and databases.
• Develop custom calculated measures using DAX in Power BI to satisfy business needs.
• Responsible to handle the entire deployment life cycle of the dashboard from DEV to PROD, created the Power BI Service level datasets, scheduled the refreshes nightly and implemented row level security on each report.
• Develop Analytical Dashboards, PBI Dashboards and Paginated Reports using Power BI.
• Responsible to refactor and optimize the code based on the analysis for the T-SQL objects, SSIS packages and Power BI reports.
• Develop a Power Apps app which was used to insert, update and delete data in a Sql Server db.
• Perform Index analysis for tables and come up with more efficient solutions to use Clustered and Non-Clustered Indexes.
• Enable Row Level security for the tables on DW, so that not every user can see the confidential data.
• Embed Power Apps in a Power BI report to Perform Data Manipulation.
• Use Power BI gateway to schedule daily job to refresh data and establish RLS (Row Level Security).Use custom visuals, third party connectors, Power Query, Power Apps, CDS as part of Power BI project.
• Create user-friendly and dynamic dashboards and reports with KPIs, heat maps, scatterplots, bar charts, slicers, Drilldown and drill through features.
• Create DAX Queries to generate calculated columns and measures in Power BI.
• Create Azure Blob Storage for Import/Export data to/from CSV File
• Publish Power BI Reports on Service and provided access in Web clients and mobile apps.
• Use Power BI report builder to publish paginated reports.
• Using Execution Plan,SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
• Work on SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages using checkpoints and scripting with VB.net in SSIS.
• Create package configuration file with connection information source, staging databases and send mail task connection information and log directory path value.
• Perform the Unit testing after the development.Support QA and UAT testing as requested.

Environment: SSIS, SSMS 2018,2012 Visual Studio 2019,2017,2015, BIDS, GIT Bash, Azure DevOpsPower BI Desktop

Confidential, Des Moines, IA

Report Developer

Responsibilities:

• Responsible to work as a leader inside Data Management to improve scalable Microsoft based ETL using SSIS and reporting solutions using Power BI to meet the business needs of the organization for its data warehouse.
• Work with the Enterprise Reporting team and the business, performing analysis of bank data and build a data model.
• Involved in preparing ad-hoc analysis, run reports related to specific sales, promotions and events, and perform financial analysis that will enhance business decision-making.
• Work on creating Qlik Sense reports according to the client’s requirement.
• Responsible for development of SSRS or Power BI reports in accordance with business requirements. Use multiple data sources like Salesforce,SAP,SQLServer,Oracle.
• Review report document specifications, clarify requirement ambiguity, develop report output, and unit test the reports to confirm data accuracy.
• Work with Business Intelligence Analysts, internal customers, and external consulting teams to understand reporting requirements and mapped business requirement documents.
• Build the Source to target mapping document based on Subject areas for ETL Data Integration initiative.
• Scripting T-SQL and PL/SQL Queries, Stored Procedures, Triggers and user defined functions
• Data Extraction, Transforming and Loading (ETL) using SSIS, BCP, Bulk Insert, DTS, and XML between Sales Force and Access to MS SQL server database.
• Create SQL Stored Procedures to implement SCD Type2 functionality which captures history per each batch run on ETL Control.
• Monitor and fix data quality issues of various Front-End and Data Warehouse applications.
• Create reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector.
• Develop and test various Power BI visualizations for the dashboard and ad-hoc reporting solutions by connecting from different data sources and databases.
• Develop custom calculated measures using DAX in Power BI to satisfy business needs.
• Responsible to handle the entire deployment life cycle of the dashboard from DEV to PROD, created the Power BI Service level datasets, scheduled the refreshes nightly and implemented row level security on each report.
• Develop Analytical Dashboards, PBI Dashboards and Paginated Reports using Power BI.
• Responsible to refactor and optimize the code based on the analysis for the T-SQL objects, SSIS packages and Power BI reports.
• Developed a Power Apps app which was used to insert, update and delete data in a Sql Server db.
• Embedded Power Apps in a Power BI report to Perform Data Manipulation.
• Provide recommendations to the internal customers with reporting choices based on future-state reporting needs.
• Develop custom and parameterized SSRS reports and SSIS packages as assigned, and unit test all reports to confirm data accuracy. Create various visualizations like waterfall, funnel, matrix visualization, scatter plots, combo charts, gauges, cards and KPI.
• Publish the Power BI Desktop models to Power BI Service to create highly informative dashboards, collaborate using workspaces, apps, and to get quick insights about datasets.
• Used Power Query to acquire data and Power BI desktop for designing rich visuals.
• Controlled, coordinated installations (Security Patches, Service packs) and evaluated the performance before deployment.
• Support QA and UAT testing as requested.Support and trained business users on reports and overall HUB data content.
• Ensure reporting solution development is documented in accordance with Data and Reporting Team standards.

Environment: SSIS, SSRS, SSMS 2017, Visual Studio 2017, GIT Bash, Share Point, Azure DevOps,PowerApps,Power BI Desktop,Power BI Service,PowerBI Reporting Server,QlikSense,Beyond Compare

Confidential, New York, NY

SQL MSBI Developer

Responsibilities:

• Created visualizations to make data easily accessible across the organization.
• Prepared ad-hoc analysis run reports related to specific sales, promotions and events, and perform analysis that will enhance business decision-making.
• Scheduled and monitored ETL processes using DTS Exec utilities and batch files. Designed and implemented ETL job restart ability using checkpoints and optimal package design techniques in SSIS.
• Identify data quality issues and support Data governance by participating in necessary activities.
• Wrote complex T-SQL Queries, Stored Procedure, Triggers, Views & Indexes using DML, DDL commands and user defined functions to implement the business logic.
• Implemented Copy activity, Custom Azure Data Factory Pipeline Activities.
• Primarily involved in Data Migration using SQL, SQL Azure, Azure storage, and Azure Data Factory, SSIS, PowerShell.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Imported data from SQL Server DB, Azure SQL DB to generate Power BI reports.
• Created Azure Blob Storage for Import/Export data to/from .CSV File.
• Installed and configured Enterprise gateway and Personal gateway in Power BI Services.
• Involved in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snowflake Schema for developing CUBES using MDX.
• Worked individually from scratch and developed the entire mechanism for Writeback using Power BI and Power Apps.
• Scheduled the packages to keep extracting the data from OLTP at specific time intervals.
• Worked on formatting SSRS Reports using Global variables and expressions.
• Created various Power BI Reports that includes Charts, Filters, Scorecards, Drilldown and Drill-Through, Cascade, Parameterized reports that involved conditional formatting.Implemented row level security on each report.
• Developed custom calculated measures using Data Analysis Expression Language(DAX).
• Mentored business power users to create reports/dashboards using Power BI.

Environment: SSIS, SSAS, SSRS, SSMS 2016, Visual Studio 2015, GIT HUB, Share Point, Business Intelligence Development Studio (BIDS), Power BI,Azure,C#,Jira

Confidential, Murfreesboro, TN

Database(SSIS/SSRS) Developer

Responsibilities:

• Assisted with the development of the data model(s) for the data warehouse. Provided recommendations for all data strategies and out of scope processes.
• Followed SDLC methodologies in performance of all development activities, including design, development, test and quality assurance support.
• Independently created or assists in the creation of tracking performance metrics.
• Created source to target mappings and ETL design for integration of new/modified data streams into the data warehouse/data marts.
• Created new tables, written stored procedures, triggers for Application Developers and some user defined functions. Created SQL scripts for tuning and scheduling.Tuned and Optimized SQL Queries using Execution Plan and Profiler.
• Worked on CompleteBacking upof the Database andRestoredthe Database fromDisaster Recovery.Configured and Managed Database High Availability: Replication, Database Mirroring, Log Shipping, and Clustering.Rebuild Servers Restore Recover from backups.
• Configured Server for sending automatic mails to the respective people when a SSIS process failure or success.
• Created SSIS Packages to migrate slowly changing dimensions.
• Worked on all types of transformations that are available in Power bi query editor
• Prepared Tableau dashboards indicating the key performance metric and developed customized reports using SSRS.
• Designed and created data extracts, supporting SSRS, POWER BI, Tableau or other visualization tools reporting applications.
• Detected anomalies in transactional data to determine root cause behind failure of SSIS DTS packages bringing in data from Access and SQL server databases which lead to the restoration of the reports associated with sales.

Environment: SSIS, SSRS, SSMS 2014, Visual Studio 2013, TFS, AWS Data Pipeline, Tableau,PowerBI

Confidential

BI/Report Analyst

Responsibilities:

• Generated database design to the highest level of scalability and performance.
• Worked closely with the project management team to analyze and consolidate request requirements to improve the decision planning process and meeting project deadlines.
• Developed numerous ad-hoc queries and reports to collect and present information that satisfied clients and contributed to achieve organizational goals.
• Created numerous processes through MS Visual Studio (SSIS, SSAS, SSRS and Power BI) and MS SQL Server 2008 to develop a data warehouse project.
• Communicate with customers and managers of other departments to define business intelligence requirements and then lead initiatives to deliver solutions accordingly.
• Develop, document, and support the web based corporate reporting and troubleshoot existing reports.Created new Power BI reports as per clients requirements.
• Improved the performance of existing SSRS reports. Ran the stored procedure from SSMS and viewed the query, checked and eliminated unnecessary joins, unneeded selected columns etc.

Environment: SSMS 2008,Visual Studio 2012,SSRS,SSIS,Rally,Power BI