SUMMARY:

• Around 6+Years of Extensive Experience in Business Intelligence Applications Design, Development and Maintenance of Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analytical Services (SSAS).
• Expert in working with the Business Intelligence Development Studio (BIDS), which includes SQL server Integrated Services (SSIS), SQL Server Analytical Services (SSAS) and SQL Server Reporting Services (SSRS).
• Four years of IT experience as a BI developer working with Microsoft BI Tools Power BI, SSIS, SSRS, SSAS and T - SQL using SQL Server 2005/2008R2/2012 in Telecom, financial and nonprofit industry.
• Experience in various states of System Development Life Cycle (SDLC).
• Good experience in Agile Scrum Methodology and Waterfall Model Projects.
• Experience in creating Power BI dashboards/reports using tabular models and good in managing Gateways and content packs.
• Experienced in Developing Power BI Reports and Dashboards from multiple data sources using Data Blending.
• Explore data in a variety of ways and across multiple visualizations using Power BI.
• Created reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector.
• Experience in publishing Power BI Desktop reports created in Report view to the Power BI service.
• Used DAX (Data Analysis Expressions) & MDX functions for the creation of calculations and measures in the Tabular Mode & multi-dimensional Cubes.
• Excellent experience in writing T-SQL Queries using various objects like views, tables, Joins, Sub Queries, triggers, stored procedures, and other advanced SQL concepts.
• Expertise in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting SQL Server 2014/2012/2008/2005.
• Experience in Writing TSQL (DDL, DML AND DCL), developing/creating new database objects such as Tables, Views, Indexes, Complex stored procedures, functions(UDF), cursors, and triggers, locking issues, BCP, common table expressions (CTEs), Backups, Recovery and SQL Server Agent profiler using SQL SERVER 2005/2008 R 2/2012/2014.
• Solid understanding of RDBMS database concepts and Experience in writing complex stored procedures, functions, Indexed views and triggers for data consistency and manipulation.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.
• Expert in working with SSIS for creating packages to transform data from different OLEDB Provider like DB2, MS Access, Flat File, Excel, Oracle and Automate the ETL.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Bulk Insert, Data Replication, Data Transformation Services (DTS) and SQL Server Integration Services (SSIS).
• Experience in creating/deploying Data Transformation Services (DTS), Knowledge of Integration Services (SSIS) packages, Analysis Services (SSAS) and Reporting Services (SSRS).
• Expertise in Extraction, Transformation and Loading data from Oracle, DB2, AS400, Teradata, SQL Server, Access, Excel, Flat Files and XML using DTS, SSIS.
• Strong Experience in all areas of SQL Server development including tables, user functions, views, indexes, Stored procedures, functions, Joins, triggers, clustering, T-SQL, SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Checks, and Unique), relational database models, data dictionaries, and data integrity.
• Explore data in a variety of ways and across multiple visualizations using Power BI.
• Responsible for creating SQL datasets for Power BI and Ad-hoc Reports.
• Expert on creating multiple kinds of Power BI Reports and Dashboards.
• Created, Maintained & scheduled various reports in Power BI.
• Published Power BI reports from Power BI desktop to Power BI service.
• Created different visualization in Power BI according to the requirements.
• Create reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector.
• Performed data cleaning, data validation, and data analysis using data analysis expressions (DAX), power query and P ower Pivot.
• Experience in Cube designing in Business Intelligence Development Studio (SSAS) to edit various properties of a cube, including the measure groups and measures, cube dimensions and dimension relationships, calculations.

TECHNICAL SKILLS:

Data Warehousing & BI: SQL SERVER Business Intelligence Studio (SSIS, SSAS, SSRS, DTS), MS Access, Oracle, DB2, PostgreSQL

Reporting Tools: SSRS 2016/2014/2008 R2/2005, Crystal Reports 13/11/08/XI, Excel, POWER BI Desktop, SAP Lumira, and Tableau.

Database: MS SQL SERVER 2016/2012/2014/2008 R2, Oracle 12c/11g/10g/9i, MS-Access.

Programming: JavaScript, Java, HTML, PHP, ASP.Net, VB6.0, C#.Net, VB.Net, PL/SQL.

Database Design Tools: Erwin 9.6, MS Visio 2010/2013, ER Studio Rational Rose(UML), Kimball & Inmon Methodologies

Tools: & Technologies: Performance Point Server 2007(ProClarity), Enterprise Manager, SSMS, EMC Networker, Database Tuning Advisor, DTS, Analysis Manager, BCP, Visual Studio, QTP, Microsoft Office SharePoint Server 2010, MS Office Suite (Microsoft Word, Power Point, MS Visio), OLAP & OLTP, Adobe Photoshop, Adobe Flash, Adobe illustrator, Adobe Animator

Operating System: Windows Vista/NT/XP/ 2010/2008/2007 , Windows 2016/2012/2008 Server, UNIX.

Application Servers: Microsoft IIS 10/8.5/8, Apache.

PROFESSIONAL EXPERIENCE:

Confidential, Jacksonville, FL

SQL/SSIS/SSRS/SSAS/POWER BI Developer

Responsibilities:

• Developed stored procedures, functions and database triggers and maintained referential integrity and implemented complex business logic.
• Created and executed SQL SERVER Integration Service packages to populate data from the various data sources, created packages for different data loading operations for many applications.
• Created SSIS Packages using SSIS Designer for exporting heterogeneous data from OLE DB Source, Excel Spreadsheet to SQL SERVER.
• Migrated DTS packages to SSIS packages and modified the packages with new features of SQL SSIS.
• Designed ETL packages dealing with different data sources (SQL SERVER, Flat Files, and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations using SQL SERVER Integration Services (SSIS).
• Created effective reports using visualizations such as Bar chart, Clustered Column Chart, Waterfall Chart, Gauge, Pie Chart, Tree map etc. in POWER BI.
• Created Roles and implemented Row level security for user Authentication in POWER BI.
• Developed and maintained multiple POWER BI dashboards/reports and content packs.
• Installed On premise data gateway and scheduled daily data refresh in POWER BI.
• Involved in designing, developing, and deploying reports in MS SQL Server environment using SSRS in Business Intelligence Development Studio (BIDS).
• Defined report layouts and created Parameterized, Drill down, Drill through and Aggregation reports in MS SQL environment using SSRS.
• Migrated existing self-service reports and Ad-hoc reports to POWER BI
• Developed custom calculated measures using DAX in POWER BI to satisfy business needs
• Used Team Foundation Server(TFS) for source control and sprint planning
• Built Ad-Hoc reports in POWER BI depending on business requirements was one of the major responsibilities
• Defining relationships between Dimensions and Measure groups. Involved in the design and development of the SSAS cubes and MDX queries
• Designed databases and relevant objects through preparation of tables, groups, and indexes.
• Created Dimensions and cubes with star schema using SQL SERVER Analysis Services (SSAS).
• Created multiple reports (SSRS) in Drill mode using tables, financial tables, crosses tabs and chart.
• Design, deployment, and maintenance of various SSRS Reports in SQL SERVER.
• Designed and implemented Parameterized and cascading parameterized reports using SSRS.
• Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL SERVER and non-production database code as well as T-SQL code from Developers and QA.
• Developed Star schema using SSAS cubes.

Technical Environment: MS SQL Server- 2016/2014/2008 Enterprise Edition, SSIS, SSRS, SSAS, T-SQL, SSDT, TFS-Team Foundation Server Version Manager, Ceridian HR Tool, SQL Agent, Office-2013, MS Excel, SharePoint, Power BI, Power-Pivot, .Net (C#, VB), Service Now, Erwin r7.3, ER Studio

Confidential, Libertyville, IL

SQL/SSIS/SSRS/SSAS Developer

Responsibilities:

• Worked with business Team to collect data for the conceptual design of the system and Interacted with Development Teams and Managers to Analyze Business needs and developed technical specifications.
• Monitored and scheduled existing/new jobs on production environment.
• Troubleshooting and fixing bugs/issues, error handling, debugging, error logging for production support in SSIS.
• Production support responsibilities for all daily, weekly and monthly SQL Agent jobs.
• Monitor production error logs to fix the issues on day-to-day basis.
• Actively ensuring the production implementation of the new enhancements with smooth transition of the project by adding value to the team in filling the gap where required as an analyst, programmer and QA tester.
• Created various database objects such as Stored Procedures, Triggers, Functions, Indexes and Views.
• Creation of Clustered and Non-Clustered Indexes for Query Performance and Generated various reports using complex stored procedures.
• Wrote complex T-SQL batches with Common Table Expressions (CTE's) for recursive operations.
• ETL implementation using SQL Server Integration Services(SSIS) in OLTP and Data warehouse Environment
• Worked with SSIS packages which involved tasks like Execution SQL, FTP tasks, Dataflow, File system, Script and Various Data Flow transformations like Lookup, Merge, Pivot, ROW Count and Sort.
• Created SSIS (SQL Server Integration Service) packages to extract data from OLTP to OLAP systems with different transformation and scheduled jobs to run the packages on a daily basis.
• Involved in designing of complex ETL solution based on the Customer needs, which involves various stages of the data flow from Flat File/SQL server source to staging area, cleansing the data, loading to the fact tables and then aggregating the data for reporting purposes.
• The SSIS packages involve various transformations like SCD (Slowly Changing Dimension), Merge, Look-up, derived column, data conversion, multicast, union all transformations etc.
• Generated Drill down, Drill through, Matrix Reports, Parameterized reports, cascading parameterized reports using SSRS
• Excellent report creation skills using Microsoft SQL Server 2008/2012 Reporting Services(SSRS) with proficiency in using Report Designer as well we Report Builder
• Writing queries to generate reports for analysis of data using SQL Server Reporting Services, Report Builder.
• Generated Daily, Weekly, Monthly, Subscriptions, Dashboard reports for the analysis of managers and end users by using SSRS.

Environment: MS SQL Server 2012/2008R2, SQL Server Reporting Services (SSRS) 2012/2008, SQL Server Integration Services (SSIS), T-SQL, PL/SQL, Excel, XML

SSIS/SSRS/SSAS/POWER BI Developer

Confidential, Findlay, OH

Responsibilities:

• Created complex Stored Procedures, Functions, Triggers, Cursors, Tables, Views, Indexes and other SQL joins and T-SQL statements.
• Worked on MS SQL Server tasks such as data loading, batch jobs, BCP, Linked Servers.
• Designed and implemented Stored Procedures and Triggers for automating tasks.
• Used Try catch and @@error for exceptional handling.
• Developed, deployed and monitored SSIS Packages for new ETL Processes and upgraded the existing DTS packages to SSIS for the on-going ETL Processes.
• Extracted data from various sources like SQL Server, Oracle, CSV, Excel and Text file from Client FTP servers.
• Successfully migrated SSIS packages from development to test to Production environments using SSIS Configuration files and deployment wizard.
• Used various SSIS transformations such as Conditional Split and Derived Column which were used for Data Scrubbing, data validation checks during Staging, before loading the data into Production tables.
• Configured SQL mail agent for sending automatic emails when a SSIS package is failed or succeed.
• Actively involved in developing Complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs.
• Configured and maintained Report Manager and Report Server for SSRS.
• Created Drilldown and Drill through reports, Summary Reports, and Sub-reports in SSRS.
• Designed and implemented Parameterized and cascading parameterized reports using SSRS.
• Worked on performance tuning on existing stored procedures and existing reports for the faster processing of reports.
• Worked on modeling the data in Power BI involving creating measures, calculating columns, etc.
• Used Data Analysis Expressions (DAX) for accessing data directly from tabular SSAS database.
• Worked on importing and displaying Key Performance Indicators (KPIs).
• Created and managed relationships between tables in Power BI in order to calculate accurate results.
• Transformed and combined the data using Query Editor in the Power BI.
• Created Power BI Visualizations and Dashboards as per the requirements.
• Published Power BI Desktop reports created in Report view to the Power BI service.
• Worked on Power View and Power Map to visualize reports.
• Involved in project status report updates/ creation of issue items for reviews/ updates of technical and transformation files on a timely basis.
• Performed DBA tasks like Backup, Restore of tables and Stored Procedures, and Refreshing Database on a weekly basis.

Environment: SQL Server 2012/2014, SSIS, SSRS, SSAS, Power BI, SharePoint, TFS, ASP.Net, Visual Studio 2013

SQL Developer

Confidential, Vernon Hills, IL

Roles & Responsibilities

• Interacted with end users to gather Requirements. Created technical, user documentation.
• Studied and designed the system.
• Install, Update, Configure and Maintain the MS SQL Server.
• Created database objects like tables, views, indexes, stored-procedures, triggers, and user defined functions.
• T-SQL queries for the retrieval of the data.
• Created a report interface using Visual Basic 6.0, which allowed users to select reports and dynamically filter reports.
• Tuning front-end applications like Visual Basic, which query the SQL Server databases.
• Written Various ASP codes for user interactions.
• Written Java Script for different validations
• Used SQL Statements to Present Query responses.

Environment: SQL Server 2005, T-SQL, UNIX, .NET, VB Script, JavaScript, ASP, Microsoft Excel, FrontPage 2005.