SUMMARY:

• Dynamic, self - motivated and results oriented BI professional with a strong passion to enable Businesses to leverage the Power BI and IT via data mining and process improvements.
• Experienced in Health care, Energy services and logistics domains.
• Involved in moving databases between servers using attach/detach, backup/restore and import/export methods.
• Strong knowledge in Power BI on how to import, shape, and transform data for business intelligence (BI), Visualize data, author reports, schedule automated refresh of reports and create and share dashboards based on reports in Power BI desktop.
• Expertise in generating reports using SQL Server Reporting Services, Crystal Reports, and MS Excel spreadsheets. Created all kinds of reports like sub-reports, drill-down, drill-through, snapshot, cache, Linked-reports, Ad-hoc, Click through and Parameterized reports.
• Good working experience in Power BI for creating reports, Dashboard’s and publish them in Power BI web browser.
• Experienced in MS Power BI Desktop and Power BI Service.
• Published reports to Power BI services (Pro) and schedule subscription and various sharing options.
• Excellent knowledge in RDBMS concepts and constructs along with Database Objects creation such as Tables, User Defined Data Types, Indexes, Stored Procedures, Views and User Defined Functions.
• Moved databases across servers using Attach/Detach, Backup/Restore and Import/Export methods.
• Strong knowledge on Data Analysis Expressions (DAX) to create tabular model projects (cube).
• Experienced in ongoing maintenance and change management to existing reports and optimize report performance (SSRS).
• Created Calculated Columns and Tables based on DAX Formulas and Expressions.
• Day-to-day activities such as backups to the disk and restore the databases and transaction log on production/development servers as per business / IT needs.
• Has the ability to work in a fast paced environment, Good team player and can work independently. Helped the database developers on technical issues.
• Designing and Deployment of Reports for the End-User requests using Web Interface, Power-BI and Sql Server Reporting Services.
• Excellent communication, presentation, interpersonal skills, strong troubleshooting and organizational skills.

TECHNICAL SKILLS:

Operating System: Window 2000, Windows XP, Windows 2003, 2008, 2010

Languages: SQL, T-SQL, HTML, Pl/SQL, Hadoop-HIVE

Databases: MS-SQL Server 2000, SQL Server2005, SQL Server 2008, SQL Server 2012

Reporting Tools: SQL Server Management Studio, Profiler, Query Analyzer, TableauPower-BI, MS-Excel, Visual Studio.

Applications: Visual Studio 2012/2010/2008 , Excel, Word, PowerPoint

Miscellaneous: Stored Procedures, DTS Packages, SQL Functions, SSIS, SSAS and SSRS

PROFESSIONAL EXPERIENCE:

MSBI Developer

Confidential, Alpharetta, GA

Responsibilities:

• Creating and maintaining various databases on Production and development environments using SQL Server 2012/2008R2/2005.
• Involved in Planning, Defining and Designing data based on business requirements and provided documentation.
• Created Stored Procedures, Indexes, User defined Functions, Constraints etc. on various database objects to obtain the required results.
• Defined the report layout and identified datasets in all reports for the report generation.
• Writing SQL Server Integration Services packages and deploy it in Development/Testing and production server.
• Created reports like linked reports, sub reports and filters in SQL server reporting services.
• Generated and formatted Reports using Global Variables, Expressions and Functions for the reports.
• Work with the developers, data quality analysts and customer support and operations technicians to troubleshoot all databases.
• Deploy, upgrade and configure new database and Coordinate database migrations with developers and other stakeholders.
• Instrumental in development of BI solutions for complex business applications within HP that involves deep understanding of technical and business requirements.
• Creating jobs for scheduling the SSIS packages.
• Worked extensively on SSIS Packages for extracting the data of the file system and transformed that data and load it into OLAP.
• Extensively used various SSIS objects such as Control Flow Components, Dataflow Components, Connection managers, Logging, Configuration Files etc.
• Developed and implemented error handling logics in all the SSIS packages to handle bad data and avoid package failures.
• Extensively utilized SSIS packages to create complete ETL process and load data into database which was to be used by Reporting Services.
• Developed datasets to perform reporting and included interactive drill down reports, report models and ad-hoc reports
• Trouble shooting various SQL server 2012/2008/2005/2000 Database connectivity issues from the web applications.
• Experience on working in Agile/Scrum environments.

Environment: MS SQL Server 2012/2008R2/2005, T-SQL, SSIS, SSRS, Report Builder, SQL Server Analysis Services (SSAS), SQL Profiler, Windows XP/2000 and Windows 2003/2008 Server.

SQL/Reporting Analyst

Confidential

Responsibilities:

• Involved in gathering user requirements, application design and analysis of hardware requirements to meet business needs.
• Extensively managed and administered SQL Server 2008/2005 and 2000 servers.
• Analyzing and Understanding the business requirements.
• Developed Employee scorecard reports which track all the employees hours spent in different projects, track time, break span and all other major information needed for the business.
• Designed new SSIS packages and deployed them.
• Converting SQL Server 2000 DTS packages to SQL Server 2005 SSIS packages.
• Used SSIS to populate data from various data sources, creating packages for different data loading operations for applications.
• Extensively worked with SSIS tool suite, designed and created mapping using various SSIS transformations like OLEDB command, Conditional Split, Lookup, Aggregator, Multicast and Derived Column.
• Created Power-BI reports for the customers which are related to employee’s performance and published them in Power-BI web.
• Expertise in creating various types of reports such as complex drill down reports, drill through reports, parameterized reports, matrix reports, sub reports, non-parameterized reports and charts using reporting services based on relational and OLAP databases.
• Configured SQL mail agent for sending automatic emails on errors and developed complex reports using multiple data providers, using defined objects, chart.
• Scheduled and executed SSIS Packages using SQL Server Agent.
• Development of automated daily, weekly and monthly system maintenance tasks such as database backup, database integrity verification, indexing and statistics updates.
• Involved in design, development, data analysis, identifying and gathering business requirements, user testing and maintenance of BI applications and information systems including database management systems like MS SQL Server.
• Transferred data (ETL) to Data warehouse environment using SSIS.
• Monitoring SQL server performance using profiler to find performance and deadlocks.
• Worked on database design for Query optimization, performance tuning and Indexing.
• Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the package according to the advanced feature of SQL Server Integration Services

Environment: MS SQL Server 2012/2008R2/2005/2000, T-SQL, SSIS, SSRS, BCP, SQL Profiler, Replication, Log shipping, Mirroring, Windows XP/2000 and Windows 2003/2008 Server

SQL DBA/Developer

Confidential

Responsibilities:

• Developed T-SQL (DDL, DML) statements using SQL and defined Referenced relationships with the measure groups and fact tables.
• Good in Developing SSIS Packages to Extract, Transform and Load (ETL) data into the Data warehouse from Heterogeneous databases such as Oracle, Sybase and MS Access.
• Writing Stored Procedures, Triggers, cursors and creating indexes.
• Integrated SQL traces with Performance Monitor to have better graphical analysis to find system bottlenecks to analyze CPU, Memory and Disk usage patterns.
• Planned the complete backing up of Databases and Disaster Recovery /Restore procedures
• Improved Performance of the database by creating Clustered and non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler.
• Configured monitoring jobs to monitor CPU usage, Blockings, Login tracking, Tempdb utilization on Production servers.
• Responsible for database development in SQL Server 2008, worked on T-SQL functions and SQL syntax.
• Transferred SQL Server Objects from QA to Production Using SSIS Packages.
• Used DTS Packages to move logins and jobs from one server to another server.

MSBI Developer

Confidential

Responsibilities:

• Installation of SQL Server 2005/2008 on production, development and testing environments.
• Extracted and reviewed data from heterogeneous sources from OLTP to OLAP using SQL Server Integration Services (SSIS) 2005.
• Generated multiple Enterprise reports using SSRS from SQL Server Database (OLTP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports (Hyperlink), Parameterized Reports(single valued parameters, multi-value parameters) etc.
• Created Stored Procedures, DTS packages, tables, views and SQL joins and statements for applications.
• Developed SSIS Packages to Extract, Transform and Load (ETL) data into the Data warehouse from Heterogeneous databases such as Oracle
• Performing day to day DBA core responsibilities, maintaining and supporting high paced production environment.
• Meeting with Application Folks and Clients and gather information regarding business requirements, changes and up gradations.
• Promoting the daily script changes requested from developers to meet the business requirements.
• Planning and implementations of Backup for all important databases and Restorations as per requirements.
• Performed Transactional Replication, Setup, configuration and monitoring.
• Good knowledge of Windows Azure and Always On concept for high availability.
• Expertise in generating reports using SQL Server Reporting Services, Crystal Reports, and MS Excel spreadsheets. Created all kinds of reports like sub-reports, drill-down, drill-through, snapshot, cache, Linked-reports, Ad-hoc, Click through and Parameterized reports.
• Defined the report layout and identified datasets in all reports for the report generation.
• Created reports like linked reports, sub reports and filters in SQL server reporting services.
• Generated and formatted Reports using Global Variables, Expressions and Functions for the reports.