SUMMARY:

• MS SQL Certified professional with Over 7+ years of experience in working with projects driven on SQL Microsoft Business Intelligence tools, Data Warehousing and ETL processes.
• Expert in T - SQL (DDL, DML), functions, views, triggers, cursors, stored procedures on SQL Server.
• Experience in SQL Server Integration Services (SSIS), Data Transformation Services (DTS) and SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS)
• Experience with ETL processes, worked extensively on data extraction, data integration and loading from different data sources using SSIS.
• Designed, developed and implemented various SSIS Packages and deployed using Deployment wizard.
• Knowledge in Dimensional Data Modeling and analyze Data warehouse by building multidimensional cubes using SQL Server Analysis Services (SSAS)
• Responsible for creating SQL datasets for Power BI and Ad-hoc Reports.
• Using Microsoft SQL Server to model datasets into datasets for business intelligence software.
• Knowledge in optimization of cubes for better query performance.
• Conducting statistical analyses of data using standard statistical techniques.
• Experience on performance tuning of SQL server for handling transactions at high volume.
• Experience in generating on-demand and scheduled reports for business analysis or management decision using SSRS. Developed parameterized, linked, matrix, drill down and aggregation reports with various parameters and filters using SSRS.
• Experience in creating Power pivots, Power views and SSRS reports using tabular model (DAX), Cubes (MDX) and SQL queries. Experience in writing MDX queries to access cubes data in SSAS.
• Extracted data from various sources like SQL Server 2008, Oracle, CSV, Excel and Text file from Client servers and through FTP.
• Experience in creating Power BI Dashboards and visualizations.
• Hands-on experience in BMC Control-M &TWS Scheduler tool for scheduling ETL/ELT Jobs and UNIX Scripts.
• Experience in gathering functional specification requirements for the development of dashboards and reports.
• Interactive data visualization products focused on business intelligence such as MICROSOFT POWER BI.
• Extract and analyze data using PowerQuery, PivotTables, MS Excel, POWER BI and SSAS
• Developed confidential proprietary analytical tools and reports with Microsoft Excel, and POWER Pivot, and POWER Point.
• Experience with management of data to produce accurate and consistent longitudinal datasets.
• Used DAX (Data Analysis Expressions) functions for the creation of calculations and measures in the Tabular Models.
• Knowledge on Tableau Desktop, Tableau Reader and Tableau Server.
• Building and publishing Tableau reports utilizing complex calculated fields, table calculations, filters, parameters.
• Generation of Dashboards with Quick filters, calculated fields, Groups, Parameters and Sets to handle views more efficiently in Tableau.
• Experience with software development life cycle (SDLC), Agile, Scrum and Project Management Methodologies.
• Publishing Power BI reports from Power BI Desktop to Power BI service.
• Hands on experience in using version control software like VSS, Rational clear case and (TFS) Team Foundation Server, and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.

WORK EXPERIENCE:

MSBI Developer

Confidential, CA

Responsibilities:

• Prepares performance Dashboard, Jobs Failure stats, Data Volume check using SSRS, SSIS, SQL and Excel and gives PPT presentation near client for this on daily basis.
• Creating and managing schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements.
• Develop and deploy SSIS packages, configuration files, and schedules job to run the packages to generate data in CSV files.
• Create and manage Reports subscriptions and schedules SSRS reports.
• Troubleshooting reports issues, ETL job failures, optimizing query performances.
• Design and implement the ETL processes using SSIS which involves collection of data from sources like SQL Server 2008 R2/2012.
• Involved in Tabular Data warehouse and DAX operations for SSAS 2012 and 2008 OLAP databases.
• Automated file transfer processes and mail notifications by using FTP Task and Send Mail task in packages.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Used excel sheet, flat files, CSV files to generated Tableau ad-hoc reports.
• Create reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector.
• Configuration and Deployment of all the Reports (RDL, RDS) across various SDLC environments.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production)
• Created Write back functionality in SSAS to write the data back into the cube to make changes to the data those changes return back in to the cube.
• Designed and built up high performance ETL packages to migrate and manipulate data from MS Excel and SQL Server by using SSIS.
• Developed Data Source, Data Source View to create a logical view of the data to be placed in OLAP Cubes using SQL Server Analysis Services (SSAS) projects.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Responsible for debug, performance checks and performed index tuning and query optimization.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Built a Tabular Model cube from scratch data and by MDX queries fetched data to SSRS and PowerBI reports.
• Create DAX and VB scripts for Excel reporting and calculated members.
• Developed impactful reports using SSRS, MS Excel, Pivot tables and Tableau to solve the business requirements.
• Used Oracle tools like Oracle Enterprise Manager, TOAD, SQL*Plus for database PL/SQL code development and performance monitoring.
• Building Ad-Hoc reports in Power BI depending on Business requirements is one of the major responsibilities.
• Created Jobs using TWS tools will run at regular intervals of time if the given condition is satisfied and then refreshes the database with new data.
• Used Indexing strategies and query optimization techniques to optimize Stored Procedures and long running queries.
• Utilized experience in user analytics, email marketing, and data segmentation strategies in order to report.

Environment: MS SQL Server 2012/2008R2, MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), MS SQL Server Analysis Services (SSAS), Visual Studio 2010/2008, Agile, C#.NET, T SQL, SQL Profiler, XML, Team Foundation Server (TFS), MS Excel, Toad, TWS, DAX, Excess, Windows 8.

MSBI Developer

Confidential, Franklin Lakes, NJ

Responsibilities:

• Used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Optimized the database by creating various clustered, non-clustered indexes and indexed views in SQL Server 2008 and 2012.
• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports.
• Created AD-Hoc reports using Report Builder and maintained Report Manager for SSRS.
• Developed critical SSRS reports using T-SQL stored procedures and complex SQL queries with custom coding for dynamic parameter change and formatting.
• Developed various trend reports using matrix reports and cascading prompts with charts and graphs to analyze the earned revenue and accounts receivables over a period of times.
• Deployed and shared the reports with rules and permissions defined on the report manager for data driven subscriptions.
• Participating in the SCRUM meetings and providing the updates and successfully delivering on the work in the sprint.
• Involved in developing and maintaining multiple Power BI dashboards/reports and content packs.
• Used SSIS to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse
• Experience in designing and developing multiple analytical reports from multiple data sources by data blending on a single worksheet in Tableau Desktop.
• Published the created dashboard reports in tableau server.
• Experience in creating and publishing packages in Framework Manager.
• Experience in creating Multidimensional cubes using SSAS and designing DW schemas.
• Designed different visualizations in Power BI according to the requirements.
• Involved in implementing Key Performance Indicator (KPI) Objects in SSAS 2008.
• Implemented user based subject selection (Role based security) in Power Views, Power Pivots and SSRS using DAX, MDX and SQL queries.
• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task.
• Experience in Creating and managing relationships between tables in Power BI to calculate accurate results.

Environment: Server Data Tools, T-SQL, SSIS, SSRS, SSAS, Tableau Desktop 9.3, Tableau Server 9.3, Excel 2013, Power view, Agile, Power pivot, Performance Point, MDX, Report Builder 3.0, Windows Server 2008, ASP .Net

SQL BI Developer

Confidential, Rosemont, IL

Responsibilities:

• Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems.
• Created SSIS packages for Data Conversion using data conversion transformation.
• Configured the loading of data into slowly changing dimensions using slowly Changing Dimension wizard.
• Advanced extensible reporting skills using SQL Server Reporting Services (SSRS) and Crystal Report.
• Developed various types of reports like Drill Down, Drill through, Crystal Report.
• Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2008.
• Created Databases, Tables, Cluster/Non-Cluster Index, and Unique/Check Constraints, Views, Stored Procedures, Triggers and functions.
• Involved in using Team Foundation Server (TFS) to check in and check out SSRS reports and SSIS packages.
• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2012 and Flat files.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production)
• Used various Transformations in SSIS Data flow, Control Flow using for loop Containers and Fuzzy Lookups etc.
• Implemented Event Handlers and Error Handling in SSIS packages.
• Involved in designing Parameterized Reports for generating Ad-Hoc reports as per the client requirements.
• Conducted data import and export operations using the DTS wizard.
• Coordinated with front-end for implementing logic in stored procedures and functions.
• Experienced in writing complex SQL Queries, Stored Procedures, Views, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non-clustered indexes.
• Database and Transaction log backups & restoration, backing up user databases and restoring them whenever necessary.
• Developed T-SQL Queries and Stored Procedures, Triggers, Views and Adding/Changing Tables for data load and transformation, and data extraction for processing business logic in the database.
• Created User Defined Functions to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible.
• Maintain referential integrity, domain integrity and column integrity by using the available options.
• Reviewed many T-SQL issues using management studio for better performance.
• Involved in requirement gathering, analysis, design, development, change management, deployment and user .

Environment: MS SQL Server 2012/2008R2, MS Visual Studio 2012, MS Azure, MS SQL Server Reporting Services (SSRS), MS SQL Server Integration Services (SSIS), XML, T-SQL, SQL *Profiler, XML, Erwin r7, DTS and TFS, Windows.

SQL developer

Confidential, CA

Responsibilities:

• Have used SQL Server 2008 Integration Services (SSIS) transformations in the data flow of a package to aggregate, merge, distribute, and modify data. Performed Data Cleansing and Profiling using Transformations in Packages.
• Involved in complete SDLC including Requirement Specifications, Analysis, Design, Building a Dimensional Data Model, Testing, Implementation, Debugging & Maintenance of applications
• Created Tabular reports, Matrix reports, List & Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment.
• Deployed reports to Report Manager and Troubleshooting for any error occur in execution.
• Scheduled the Reports to run on daily and weekly basis in Report Manager and also email them to director and analysts to review in Excel Sheet.
• Responsible for implementing robust Disaster Recovery Plan.
• Involved created Database Maintenance Plan for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Participated in testing during the UAT (QA testing) . Mentored and monitored team development and status.

Environment: MS SQL Server 2012, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Visual Studio 2013, Azure, Business Intelligence Development Studio (BIDS), MS Excel, Windows 8, TFS and SSMS, Power BI, Power Pivot.

SQL Developer

Confidential

Responsibilities:

• Used SSIS to create ETL Packages to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Generated packages using different Transformations like Lookups, Derived Column, Merge Join, Fuzzy Lookup, For Loop, For Each Loop, Conditional Split, Union all, Script component, etc.
• Providing Logging, Error handling by using Event Handler and Custom Logging for SSIS Packages.
• Used Report Designer as well as Report Builder for report creation using Microsoft Reporting Services (SSRS)
• Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS)
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS)
• Created Drill-down, Parameterized and Sub-Reports using RDL and promoted RDLs to Reporting Service Server.
• 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 manner and created stored Procedures for the business logic using T-SQL.
• Responsible for performing T-SQL tuning, multi-tasking and optimizing queries for reports which take longer time in execution with SQL Server 2008/2005.

Environment: Microsoft SQL Server 2008/2012, OLAP, ROLAP, Visual Studio 2005/2008, Windows 2007/XP, T-SQL, SSIS, SSRS, SSAS.