SUMMARY:

• Senior level experience in Designing and Implementing BI applications within various industries such as Insurance and Banking. Highly - proficient with Power BI and SQL Server BI Stack (SSIS, SSAS and SSRS) within large and small Development/Production teams. Experienced with all phases of SDLC involving Systems Analysis, Design, Development and Implementation. Excellent problem-solving skills with strong ability to efficiently implement Database Solutions to accomplish all critical Business Objectives.
• Experience in designing visual report solutions, including dashboards using SSRS and other data visualization/dashboard tools like Power BI.
• Used Power BI Desktop to connect various data sources and worked with different visualizations and created dashboards.
• Transformed and combined the data using Query Editor in the Power BI.
• Developed custom calculated measures using DAX in Power BI to satisfy business requirements.
• Involved in designing and publishing visually rich and intuitive Power BI dashboards.
• Experience in generating on-demand and scheduled reports for business analysis or management decision using (SSRS).
• Created weekly and monthly reports as per requirement using SSRS and Scheduled Reports to be delivered to Users on-demand Basis or run on daily, weekly and monthly basis in SSRS report Manager.
• Experience in Configuring and maintaining Report Manager and Report Server for SSRS, Deployed and Scheduled the Reports in Report Manager.
• Proficient in Extracting, Transforming and Loading (ETL) data from different type sources such as Excel, Oracle, and Flat file using SQL Server Integration Services (SSIS) from OLTP to OLAP
• Experience in SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment.
• 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, break points, check points and logging towards SSIS package execution in SSIS
• Great experience in Deploying SSIS packages, job scheduling, SQL mail agent
• Configured data partitioning/table partitioning on huge tables containing millions of rows for better performance.
• Experience in developing and maintaining T-SQL, PL/SQL Packages, Procedures, Functions, Joins, Sub Queries, Correlated Sub Queries, Views, Partitioning, and, Constraints, Transactions, Tables, and Indexes.
• Wrote T-SQL, PL/SQL procedures to generate DML and DDL scripts that modified database objects dynamically based on user inputs.
• Great skills in gathering requirements, understanding and analyzing the requirements.
• Worked in collaborative team environment with other developers, business analysts and with project management teams.
• Strong experience in database installation, capacity planning, implementing backup and recovery strategy for application and database.

TECHNICAL SKILLS:

Languages: T-SQL, PL/SQL, C, python, HTML5, CSS3, JavaScript

Operating Systems: Windows, MacOS

RDBMS/ Databases / Database Tools: MS SQL Server, MS Access, SQL Server Management Studio, SQL Server Data Tools, Business Intelligence Development Studio (BIDS), Visual Studio, SQL Profiler, Performance Monitor, DTS, Database

Data Warehouse Tools/Technologies: SSIS, SSRS, SSAS

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

Others: SharePoint, Team Foundation Server (TFS), Microsoft Office, LeanKit, Jira, MS Visio

PROFESSIONAL EXPERIENCE:

Confidential, QUINCY MA

Sr. BI Developer/ Power BI Developer

Responsibilities:

• Gathered requirements of project from business analyst, Analysis requirements, worked with developers, DBA and testers to execute task.
• Worked in Agile process having expertise in life cycle of a project from start to end
• Gathered and documented Power BI application requirement from the business users
• Designed, developed and implemented Power BI reports
• Strong understanding in creating Dashboards, Scoreboards in Power BI
• Used various sources to pull data into Power BI such as SQL Server, Excel, Web, Text/CSV etc.
• Using a Power Query in Power BI performed certain operations like fetching data from different file and performed ETL to get data into Table form
• Designed Monthly Project KPIs of Usage Statistics, Identity Compliance and Audit Reports in Interactive Dashboards/Storyboards using Tableau and Power BI
• Created many calculated columns and measures in Power Pivot (Power BI) using DAX to better evaluate quality
• Used various Data Visualizations with Power BI and published reports to Power BI Services
• Created matrix, Chart, Parameterized, Drill-down, Drill-through reports
• Deployed and uploaded the SSRS reports for the end users and involved in enhancements and modifications of Dashboards
• Created SSIS packages using control flow, data flow and error handling tasks and different data sources to the data mart using SQL Server Integration Services
• Worked with various containers in the control flow task such as For Loop, For Each Loop, Sequence
• Developed dynamic packages with variables and expressions. Able to load data from Excel, Flat Files, XML, different databases and SQL database
• Worked in using SQL execution task, and different Data transformations like Conditional split, Derived column, Look up, Union All, Aggregate, etc.
• Familiarity with OLAP cubes and relational database management systems
• Created Complex Stored Procedures, Joins and Views using T-SQL to evaluate result for the reports
• Worked with T-SQL Functions, Tables, Indexes and Views and other SQL joins and statements for applications
• Designed, developed, and tested stored procedures, views and complex queries for the creation of Reports

Environment: MS SQL Server, SQL Server Data tools (SSIS), Power BI

Confidential, Pittsburgh, PA

MS SQL Server/SSIS/SSRS developer

Responsibilities:

• Worked with business stakeholders, application developers, and production teams and across functional units to identify business needs and discuss solution options
• Determined the SQL Server installation. Installed and configured SQL Server Management tools using SQL Server setup program
• Maintained Tabular, Linked, Chart, Parameterized, Sub reports, Drill-down, Drill-through reports according to business requirements in time-restricted environment
• Created various SSIS packages by extracting data from various sources according to the requirements
• Worked with various containers in the Control Flow task such as For Loop, For Each Loop, Sequence
• Worked with various sources in the data flow tasks and used various transformations. Some of the transformation are merge, merge join, union, Look up transformation, audit, aggregate
• Worked extensively on bad data with configuring the error output, conditional split, derived column transformation
• Deployed the packages in catalog method and worked on job scheduling and send mail task
• Physical implementation of database into SQL Server using T-SQL
• Created views to facilitate easy and user interface implementation and triggers on them to facilitate consistent data entry into the database
• Created stored procedures and functions to support efficient data storage and manipulation
• Created check constraints to maintain data integrity

Environment: SQL Server, Excel, Access and Windows, MS SQL Integration Services (SSIS) and MS SQL Reporting Services (SSRS).

Confidential, Troy, NY

MS SQL Server/ SSRS Developer

Responsibilities:

• Actively participated in gathering user requirement and system specifications
• Designed and developed BI Reporting solution, enabling users to effectively utilize the tool and create Analytical Reports, Dashboards, and Scorecards, align KPIs performance metrics to strategic drivers and priorities
• Provided software product design and - developed technical roadmap for the required solution through the project lifecycle and beyond
• Created different Parameterized Reports ((SQL Server Reporting Services)) which consisted of criteria in various reports to minimize the report execution time and to limit the number of records required
• Built SSRS project to generate reports with desired formats (Word, PDF, Excel, etc.) to present statistical information according to business requirements
• Created subscriptions to provide a daily basis report. Used reporting services to schedule reports to be generated on predetermined time
• Created various types of reports such as sub reports, parameterized, Tablix and Matrix by using SSRS
• Involved in performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard
• Created reports using stored procedures and was involved in scheduling, creating snapshots and subscriptions for the reports
• Modified Migration of stored procedures and database objects between development and test environments
• Maintained complex Stored Procedures and views to generate various drill-through reports, parameterized reports and Sub reports using SSRS
• Tested reports and performed data validation on dashboards
• Setup SSRS to integrate with Team Foundation Server (TFS) to develop/build/deploy reports using TFS

Environment: MS SQL Server, SSRS, MS SQL Profiler, MS Access, MS Excel, Tableau

Confidential

Database Developer

Responsibilities:

• Designed, Developed and maintained Relational databases using waterfall scrum methodology
• Developed, maintained and executed T-SQL queries and validated completeness, integrity, and accuracy of data.
• Implemented triggers, functions, stored procedures and enforced business rules via checks and constraints.
• Created indexes on selective columns to speed up efficiency of queries and analysis in SQL server management studio.
• Used MS SQL Server profiler for auditing and analyzing the events which occurred during a particular time horizon and stored in script.
• Used advanced features of T-SQL in-order to design and tune T-SQL to interface with the database and other applications in the most efficient management

Environment: MS SQL Server, SQL Server Management Studio (SSMS), MS SQL Server profiler