PROFESSIONAL SUMMARY:

• Specialized SQL/BI Developer with 7+ years of experience in reporting with strong skills in SQL development, SQL Server, data warehousing in domains such as finance, logistics, insurance, and retail.
• 3+ Years of hands on experience as Business Intelligence Analyst creating beautiful and intuitive visualizations, proficient with Power BI, and QlikView.
• Extensive experience in creating reports such as drill down reports, drill through reports, grouped reports, linked reports, sub reports, matrix reports and chart reports using SQL Server Reporting Services (SSRS).
• Created report snapshots and caches to improve Performance, Deployment and Scheduling of SSRS.
• Firm grasp in designing and building dashboards and reports from a wide array of static as well as dynamic data sources.
• Designed and developed Power BI graphical and visualization solutions with business requirement.
• Extensive use of Data Analysis Expressions (DAX) functions in creating Power BI dashboards, reports and Tabular Models.
• Embedded Power BI reports on front end portal page and managed user level access using roles.
• Expert in data Extraction, Transformation, and Loading (ETL) using SQL Server Management Studio (SSMS) and SQL Server Integration Services (SSIS).
• Efficient with Data Manipulation Language (DML), Data Definition Language (DDL) for creating Tables, Stored Procedures, Views, Indexes, User Defined Functions.
• Created stored procedures, functions and packages for moving the data from staging area to data mart.
• Expert in debugging, logging, error handling and event handling for SSIS Packages.
• Expertise in problem - solving and trouble-shooting capabilities, creating and implementation of Key Performance Indicator (KPI)s as per business requirements.
• Proficient in requirement gathering, Gap Analysis and Root Cause Analysis (RCA).
• Adept in deploying SSIS projects using integration services catalogs and SQL Server Agent and deploying SSRS projects to production servers.
• Experience in Data modeling, Data mining, Dimensional modeling (Star Schema, Snowflake) for data movement, data cleansing and data integrity processes.
• Quick learning capability, delivering solutions as an individual and a good team player.
• Having a zeal for reporting, out of the box thinking competence.
• Good understanding and exposure to Software Development Life Cycle (SDLC) methods like Water and Agile, Process Documentation, Data Organization, System Documentation, and Report Writing.

TECHNICAL EXPERTISE:

Tools: MS SQL Server Data Tools, MS Visual Studio, Power BI, QlikView

SQL Server Data Tools: SSIS, SSAS, SSRS, SQL Management Studio

Languages: T-SQL, Python, Ruby, JavaScript, VBA (Excel)

Databases: MS SQL server, Oracle

Office Tools: MS Office Suite/Access/PowerPoint

Operating System: Windows Enterprise, Windows Server

WORK EXPERIENCE:

Confidential, Irving, TX

MSBI DEVELOPER (SSIS/SSRS/Power BI)

Responsibilities:

• Responsible for accurately reporting on the financial and logistics aspect of the company’s national operations using SQL Server Reporting Services (SSRS).
• Coordinated with various teams to develop reporting solutions for Sales, HR, and Marketing and Purchasing departments. Scheduled and support daily/weekly/monthly sales and operational reports.
• Developed and rendered daily/weekly/monthly reports as per the requirement and gave roles, user access with respect to security in Report Manager.
• Developed complex SQL queries using common table expressions (CTEs), temporary table to support Power BI and SSRS reports.
• Utilized Power BI to design multiple scorecards and dashboards to display information required by different departments and upper level management.
• Developed, designed, and build dashboards per business requirements using SSRS.
• Developed Drill through Dashboard reports which allowed users to drill between Summary to detail Reports, templates and personalization.
• Embedded Power BI reports on SharePoint portal and managed access of reports and data for individual users using Roles.
• Created reports utilizing SSRS, Excel services, Power BI and deployed them on SharePoint Server as per business requirements.
• Developed and optimized Stored Procedures, Views, and User-Defined functions for transforming data performed by the batch process flow.
• Worked regularly with a geographically diverse teams in acquiring accurate data and reduce noise
• Accountable for creating and presenting Key Performance Indicator (KPI) to upper management with reports and visualization
• Worked on reviewing existing applications and clean up redundant data sources.
• Scheduled and monitored SSRS report subscriptions and deliveries such as Email Delivery and File Share Delivery as required by the business.
• Created Ad Reports like Gross Margin, Account Query, Aging receivables, Balance Sheet, Income Statement, Bad Debt and Payment Reports in response to requests from Business Units.
• Developed, and performed forecasting using existing reports for Clients showcasing their costs and extraction for monthly, quarterly, and yearly timeframes.
• Created User Conditions and Filters to improve report generation & readability and SQL tuning of report and displayed the summary of data by creating Charts.
• Created Dashboard Reports using Data mart as data Provider.
• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications about the financial system.

Environment: Windows Server, SQL Server, Microsoft Visual Studio, Windows, MS Office, SQL Server Integration Services, SQL Server Reporting Services, SharePoint, Power BI

Confidential, Atlanta, GA

MSBI Developer (SSIS/SSRS)

Responsibilities:

• Developed different types of charts Bar charts and pie chart.
• Experience in creating multiple reports such as drilldown reports, drill through, and parameterized report
• Developed User Interactive Sheets & Reports as per the business needs and requirements.
• Worked with report parameters and performed parameterized and cascading parameterized reports
• Experience in generating Drill through and Drill down reports with drop down menu option, sorting the data, and defining subtotals in Power BI.
• Created sub reports, bar charts and matrix reports using SSRS.
• Integrated Custom Visuals based on business requirements using Power BI desktop
• Generated periodic reports based on the statistical analysis of the data using SSRS
• Gathered data from multiple data sources such as ADO.net, OLEDB, Excel & Flat files in developing the logical Data Models.
• Worked on Data Transformation Services (DTS) in SSIS for transferring data from Heterogeneous Database (Access database and xml format data) to SQL Server
• Involved in maintenance of ETL Packages in SSIS according to changing business requirements to support the existing ETL strategy.
• Developed complex database objects like Stored Procedures, Functions, Packages using SQL to gain better Performance
• Created custom logging and error handling SSIS packages.
• Monitoring of the files and user accounts for the usage of the applications.
• Participated and proposed new business analysis for data which has no prior reports.
• Designed index, statistics and optimized queries by using execution plan for Performance tuning of the database
• Designed and implemented comprehensive Backup plan and disaster recovery strategies.
• Troubleshooted, monitored, optimization of SQL Server and non-production database code as well as T-SQL code from developers
• Trained end users to use the reports effectively, to build and customize their ad-hoc reports.

Environment: SQL Server Management studio, SQL Server Integration Services, SQL Server Reporting Servers, SQL, Excel, .CSV Files, Windows, Power BI

Confidential, New York City, NY

MSBI Developer (SSIS/SSRS)

Responsibilities:

• Exported data from SSRS report to several file formats likes PDF and Excel according to the needs of management.
• Enhanced the Reports by updating the embedded Scripts in SSRS to the Stored Procedures
• Improved the Performance of SSRS reports by optimizing data sets, making use of report caching and snapshots.
• Created dashboard style of layouts using different components of SSRS like List-boxes, Multi-boxes, slider, current selections box, buttons, charts, text objects, bookmarks, etc.
• Developed several BI applications using SSIS platform connecting to and integrating data from several databases using an ETL load script and standard expressions for calculated dimensions on charts and tables
• Responsible for all DB work including: Stored Procedures, SQL statements, views, DTS, scheduling DTS packages.
• Designed, developed, implemented, tested, and supported solutions using SSIS functionality
• Extracted information from disparate data sources like excel files, OLEDB, flat files, etc. by using different scripts like add, concatenate, resident, concatenate etc.
• Work with the development team to produce a data model that will support the team to prototype, test, and debug reports to meet business requirements
• Created and executed test plans/scripts to find errors and confirm reports meet specifications
• Provided technical assistance with troubleshooting reports/cubes by responding to inquiries and questions
• Designed and implemented comprehensive Backup and Restore Strategy for point in time recovery and prepared documentation for Disaster Recovery Plan.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard

Environment: SQL Server Integration Services, SQL Server Reporting Services, SQL Server Management studio, SQL, MS Access, Excel, Visual Studio, QlikView

Confidential, Burr Ridge, IL

SQL Developer (SSIS/SSRS)

Responsibilities:

• Created reports having actions like URL and bookmarks which helped to easily navigate through the report using SSRS
• Monitored performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Enhanced performance using optimization techniques-normalization, indexing and transaction Isolation levels.
• Created Views, Functions and developed Stored Procedures for implementing application functionality at the database side for performance improvement
• Used DTS/SSIS and T-SQL/PLSQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts and performed action in XML
• Extensively used joins to connect multiple tables from different databases.
• Experienced in Error and Event Handling: Precedence Constraints, Break Points, Check Points, Logging
• Developed and executed several SQL queries as a part of Backend testing and involved in data validation and verifying data-integrity
• Created Logins and Roles and managed security and permission on different database objects.
• Monitored logs to ensure the completeness of batch processes, scripts and processes.
• Modified Job/Package to use Distributed File System (DFS) namespace instead of using file s for configuration and logging
• Worked with Team Foundation Server (TFS) for configuration management of development scripts including ETL, SSRS and Database scripts.
• Gathered business requirement and communicated with end users for report layout.
• Organize and facilitate inter team meetings to consolidate knowledge from multiple subject matter experts.
• Backing up master & system databases and restoring them when necessary.
• Created a utility to do multiple packages deployment from Visual Studio GUI.
• Enabling SQL Trace for Deadlock analysis and SQL profiler for analysis of long running queries.

Environment: T- SQL, MySQL, Windows, SQL Server Management Studio, SQL Server Integration Services, SQL Server Reporting Services, SQL Profiler, Visual Studio

Confidential, Eldorado, AR

Jr. SQL Analyst

Responsibilities:

• Participated and interacted with users, team lead, DBAs and technical manager to fully understand the requirements of the system
• Wrote T-SQL, designed and modified database objects such as Tables, Views, Indexes, Stored Procedures, to meet the business specifications.
• Performed JOIN operations between Master and Transactional Tables.
• Wrote T-SQL statements for retrieval of data and involved in performance tuning of T-SQL.
• Used DTS/SSIS to perform the ETL tasks from source to target.
• Created Index on tables to improve the performance of query.
• Performed PIVOT operations on tables to transpose columns and rows to get effective view of data.
• Conducted and automated the ETL operations by extracting data from multiple data sources to transform inconsistent data to consistent and reliable data
• Created datasets using stored procedures and reports using multivalued parameters
• Implemented and Scheduled Replication process for updating our parallel servers.
• Automated email services for task completion, success or failure.
• Optimized queries using SQL Profiler to enhance the performance of database servers.

Environment: T-SQL, MySQL, SQL Server Management Studio, Windows, Data Transformation System, SQL Profiler