PROFESSIONAL SUMMARY:

• Designed and developed Power BI graphical and visualization solutions with business requirement.
• Integrated Custom Visuals based on business requirements using Power BI desktop.
• Set up Power BI Environment, creating app workspaces, publishing apps and setting up Power BI Gateway.
• Skilled in importing, shaping and transforming data in Power BI.
• Embedded Power BI reports on front end portal page and managed user level access using roles.
• Used Data Analysis Expressions (DAX) functions to create measures in data model in Power BI.
• Experienced in creating reports various kind of 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.
• 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.
• Adept in deploying SSIS projects using integration services catalogs and SQL Server Agent and deploying SSRS projects to production servers.
• 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, Madison, NJ

Power BI Developer

Responsibilities:

• Developed data mapping document to create a connection between the source and target tables or attributes and identifying Bottlenecks of sources.
• Installed and configure ODBC driver in the system to get access to data modelling.
• Worked on both live and import data in Power BI for creating reports.
• Designed and developed interactive reports in Power BI in accordance with business requirement documents.
• Developed and maintained multiple Power BI dashboards/reports.
• Published reports and dashboards using Power BI.
• Coordinated with onsite and offshore team to keep track of updates and development in the reports.
• Involved in Installation, Configuring and Publishing various types of Power BI reports to service
• Knowledge on connecting various Data Sources in Power BI Service using On-Premises Gateway connection.
• Created New Reports by using SSRS & did the performance of SSRS Reports
• Worked on formatting SSRS reports using the Global variables and expressions.
• Administered minor databases of the facility using SQL Management Studio
• Conducted and automated the ETL operations by extracting data from multiple data sources to transform inconsistent data to consistent and reliable data
• Transformed business requirements into functional and technical requirements.
• Worked together with senior management, subject matter experts, and IT teams to define business requirements

Environment: Power BI, Windows, SQL Server, MS Office, SQL Server Integration Services, SQL Server Reporting Services

Confidential, Irving, TX May

MSBI DEVELOPER (SSIS/SSRS/Power BI)

Responsibilities:

• Utilized Power BI to design dashboards to display information required by different departments and upper level management
• Embedded Power BI reports on SharePoint portal and managed access of reports and data for individual users using Roles.
• Created User Conditions and Filters to improve report generation and displayed the summary of data by creating charts.
• Installed, Configured and Published various types of Power BI reports to service.
• Developed Drill through Dashboard reports which allowed users to drill between Summary to detail Reports, templates and personalization.
• Responsible for accurately reporting on the financial and logistics aspect of the company’s national operations.
• 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, designed, and build dashboards per business requirements using SSRS.
• Worked regularly with a geographically diverse teams in acquiring accurate data and reduce noise
• Worked on reviewing existing applications and clean up redundant data sources.
• 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.
• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications about the financial system.

Environment: 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:

• Experience in generating Drill through and Drill down reports with drop down menu option, sorting the data, and defining subtotals in Power BI.
• Integrated Custom Visuals based on business requirements using Power BI desktop.
• 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
• 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.
• 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.
• Trained end users to use the reports effectively, to build and customize their ad-hoc reports.
• Participated and interacted with users, team lead, DBAs and technical manager to fully understand the requirements of the system

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

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
• 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 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.
• 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.
• Gathered business requirement and communicated with end users for report layout.
• Wrote T-SQL, designed and modified database objects to meet the business specifications.
• Organize and facilitate inter team meetings to consolidate knowledge from subject matter experts.

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