SUMMARY:

• 9+ years of expertise experience in Business Intelligence(BI),Data Warehouse (DWH)and Data Analytics related consulting projects
• Experience in Database design, development and administration of applications with MS SQL Server using Integration Services (SSIS), Reporting Services (SSRS), and SQL Server Analysis Services (SSAS), Tableau, Power BI in diverse industries.
• Implementation and support of various applications in OLTP, data Warehousing and OLAP applications.
• Extensive knowledge and Experience in dealing with Relational Database Management Systems including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers and Cursors.
• Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc.
• Experience with all phase of software development life cycle (SDLC), Scrum and Agile methodologies
• In depth knowledge in T - SQL (DDL and DML) statements, RDBMS, data dictionaries.
• Worked on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SSIS 2008.
• Experience in Power BI, creating interactive visualizations, dashboards, reports based on business requirements.
• Extensive experience in Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau 6, Tableau 7 and Tableau 8
• Experience in developing Custom Reports and different types of Tabular, Matrix, Ad-hoc and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) also expertise in working with Crystal Reports.
• Knowledge of SQL Server tools (Profiler, DTA, SSMS, SAC, SSCM, Perfmon, DMVs, system sprocs).
• Delivered BI reporting solutions in Power BI, Reporting Services (SSRS), Tableau and MicroStrategy
• Experience in creating Dashboards using QlikView.
• Developed ETL process using SSIS with Various Control Flow, Data Flow tasks and Store Procedures for Work Order Validation process.
• Created a cube using multiple dimensions and modified relationship between a measure group and a dimension, created calculated members and KPI’s, using SSAS
• Excellent knowledge in performance tuning, query optimization, writing complex SQL Queries using functions, and stored procedures in T-SQL
• Experience in creating and deploying SSIS (ETL process) packages using various Transformations such as Slowly Changing Dimension, Multicast, Merge Join, Lookup, Fuzzy Lookup, Conditional Split, Aggregate, Derived Column, and Data Conversion Transformations.
• Hands on experience working with SSIS, for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations.
• Worked in Data modeling, creating star and snowflake schemas in SSAS. Also used tools like Erwin.
• Experience in Developing and Extending SSAS Cubes, Dimensions and data source views SSAS-Data Mining Models and Deploying and Processing SSAS objects.
• Extensive experience in delivering OLAP solutions by developing Corporate Dashboard Reports using SQL Server Reporting Services (SSRS), Report Model and Ad Hoc Reporting using Report Builder functionality.
• Creates new objects in the form of calculated fields, dynamic parameters, filters, etc. in order to enhance and optimize the report viewing experience.

TECHNICAL SKILLS:

Languages: T-SQL, C, Visual Basic 6.0, VB.Net, C#, .NET, ASP.NET, HTML.

Databases: SQL Server 2016/2014/2012/2008 R 2/2008/2005/2000, MS Access

Analysis/Reporting Tools: SQL SSIS, Server Reporting Service (SSRS), SQL Server Analysis Service (SSAS),Azure

ETL Tools: DTS, SSIS, DataStage

Data Modeling Tools: Erwin, Visio

Other Software: MS Office- 2013/2010/2007/2003/2000

Operating Systems: Windows / 98/2000/2003/ XP/Vista/2010

Database Tools: SQL Query Analyzer, SQL Enterprise Manager, Management Studio, SQL Server 2005 Query Editor, Solution Explorer, Analysis Manager, Reporting Server

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

SQL BI / Tableau Developer

Responsibilities:

• Responsible for logical and physical data modeling, database design, star schema, data analysis, programming, documentation and implementation.
• Server for design, development, Performance testing, and production rollover of reporting and analysis projects within Tableau Desktop
• Designed and Developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop
• Created various complex SQL Queries, Stored Procedures, CLR Procedures, Views, Cursors and User Defined Functions to implement the business logic.
• Worked on creating Stored Procedures, Triggers, Tables, Views, User Defined Functions, Cursors, Relational Database Models and Data Integrity by using T-SQL, PL/SQL.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the updated data accurately
• Designed complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
• Involved in development and implementation of SSIS, SSAS and SSRS application solutions for various business units across the organization.
• Used SQL Server Integration Services (SSIS) and its tools to Extract, Transform and Load data into Data Ware House and for OLTP side
• Utilized Azure data warehouse for storing the data.
• Used SQL Profiler, Execution Plan, Database Tuning Advisor, Performance Monitor and DBCC Commands.
• Hands on experience in implementing Key Performance Indicator (KPI) Objects in SSAS.
• Responsible in designing, developing and deploying reports in MS SQL Server environment using SSRS in Business Intelligence Development Studio (BIDS).
• Extensively used tools like SQL Profiler, Index Tuning Wizard, and Windows Performance Monitor for monitoring and tuning MS SQL Server performance.
• Worked on creating dashboards and data visualizations using Power BI.
• Created SSIS Packages using Lookup, Merge, Sort, Derived Columns, Condition Split, Aggregate, Execute SQL Task, and Data Flow Task, Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel, Text file, XML file to different data Marts.
• Analyzed Query Optimization and SQL Server Profiler for tuning report queries and improved performance in SQL Server.
• Designed, developed, and managed reporting and Tableau Business Intelligence solutions to meet the business needs.
• Worked closely with client to understand the business requirements, data analysis and identify final deliverables.
• Oracle Analysis Cloud (OAC) Collecting, consolidating, and transforming data, and creating transactional and analytical reports, dashboards and Empowering users to visualize and discover data
• Data pull from ORACLE to SQL databases using SSIS packages.
• Key role in team of 4 in bringing 2005 SQL database environment to SQL 2008R2 by migrating, converting and re-writing DTS packages and updating them to SSIS packages.
• Providing users with service capabilities in modeling and analysis with Oracle Hyperion Essbase on the Oracle backend (OAC)
• Extensively worked on Data Flow tasks like For Each Loop Container, Execute process task, Transfer SQL Server Objects task, Transfer Jobs task, Transfer Logins task.
• Used Power BI Power Pivot to develop data analysis reports and used power view and power map to visualize the reports.
• Involved in implementing Key Performance Indicator (KPI) Objects in SSAS 2008. Create Calculate member in MOLAP cube using MDX in SSAS 2008.
• Have hands on experience on creating dashboards and reports using Hyperion Financials SQR Production reporting, Interactive reporting (Brio) and Web Analysis.
• Expert in T-SQL for developing complex Stored Procedures, Triggers, Tables, User Defined Functions, views, indexes, user profiles, Relational Database models, Data integrity, query writing and SQL joins.
• Performed DBA tasks like Backup, restore of tables and Stored Procedures and Refreshing Database on weekly basis.

Environment: MSSQL Server 2012/2014/2016 Developer Edition, Power BI, Visual Studio 2012/2015, ASP .Net, SSMS, SQL Server Integration Services (SSIS), MVC, SQL Server Reporting Services (SSRS), Team Foundation Server

Confidential, Virginia, VA

SQL BI Developer / PowerBI Data Analyst

Responsibilities:

• Led the development of reporting solution suite containing Power Bi Reports for Century Link using Microsoft latest in memory database technology.
• Participated in requirements meeting and data mapping sessions to understand business needs. Identified and documented detailed business rules
• Developed complex SQL quires using stored procedures, common table expressions (CTE), temporary table to support Power Bi and SSRS reports.
• Developed Data Mart for budget and services department along with analysis of existing data warehouse for performance improvements.
• Developed complex calculated measures using Data Analysis Expression language (DAX)
• Involved in project planning also schedule for database module with project managers.
• Performed server installation and configuration using SQL server2012.
• Design, Implement and maintain Database Schema, Entity relationship diagrams, Data modeling, Tables, Stored procedures, Functions and Triggers, Constraints, Indexes, Functions, Views Rules, Defaults and complex SQL statements.
• Extensive use of Data Analysis Expressions (DAX) expressions in tabular models as per business requirements.
• Experienced in using DAX to creating custom calculations in PowerPivot for Microsoft Excel workbooks and Analysis Services tabular model projects. Responsible for creating the reports based on the requirements using SSRS
• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logins and security checks
• Maintained the database schema in source code control (MS Team Suite Database Edition preferred).
• Involved in mock testing and Unit Testing and Integration testing in SSIS, SSAS.
• Implemented fine tuning of database objects and server to ensure efficient data retrieval.
• Developed Enterprise wide cascading reports in SSRS that were used throughout the agency to monitor the performance the cube, logging of the ETL loads and also to monitor most active users of the cube.
• Planned Backup strategy based on projects requirements.
• Worked with DTS packages and MS OLAP Services.
• Maintained the consistency of the client’s Database using DBCC.
• Responsible for developing processes, automation of maintenance jobs, tuning SQL Server, locks and indexes configurations, administering SQL Server security, SQL Server automatic e-mail notification and SQL Server backup strategy and automation.
• Responsible for testing to optimize the procedures and triggers to be used in production.
• Created Report Subscription and Data Driven Subscription using SSRS 2008.
• Used SSIS to create ETL packages to validate, extract, transform and load data into data warehouse and data marts.
• Generated Custom ETL scripts using SSIS 2008R2 and unit test SSIS load processes for performance check.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Utilizing capabilities of Tableau such as Forecasting, Table Calculations, Basic Arithmetic Calculations, String Manipulations, Custom Aggregations and Dashboard actions

Environment: SQLServer2012, 2008/2008 R2, Tableau Desktop/Server, Business Intelligence Studio (SSAS, SSIS, SSRS), SharePoint 2007, T SQL, Erwin, TFS, MDX, Oracle 10g, ProClarity, MS Excel, DB2, Oracle 9i/10g, Visual Studio 2008, XML, XSLT, MS Office and Visual source safe.

Confidential

SQL Server Developer/SSIS/SSRS/SSAS

Responsibilities:

• Involved in Database design and Data modeling various databases.
• Worked with development team and business users to understand business processes, gather and document project requirements and translate them into functional and non-functional specifications
• Performed System Study and Requirements Analysis, prepared Data Flow Diagrams, Entity Relationship Diagrams, Data Diagrams, Table Structures.
• Developed all the required stored procedures, user defined functions, triggers using T-SQL.
• Created and maintaining SSIS Package (ETL) to Extract and Transform data from, Flat File or CSV, and to load into Staging Database.
• Extracted Data from various Heterogeneous Databases such as Oracle Analysis Cloud and Access database, DB2, flat files to SQL server 2008R2 using SSIS.
• Created SSIS packages to Oracle Analysis and other SQL Server instances in SSIS2008.
• Worked on Cube structure optimization for MDX query performance in Analysis Services 2012(SSAS)
• Configured and maintained Report Manager and Report Server for SSRS. Deployed reports in the Report Server.
• Designed Cubes with Star Schema using SQL Server Analysis Services 2012 (SSAS), Created several Dashboards and Scorecards with Key Performance Indicators (KPI) in SQL Server 2012 Analysis Services (SSAS).
• Developed Dashboard reports using Power view and Power Pivot.
• Used SQL Server Package Configuration technique to make Dynamic configurations.
• Worked on maintenance of web applications using C# and ASP.Net
• Effectively using various control flow and data flow tasks provided by SSIS such as Data Conversion, Lookup, Conditional Split, Slowly Changing Dimension, Merge and Union all.
• Scheduled and maintained various daily, weekly and monthly ETL packages and jobs through SQL Server Agent in SSMS.
• Created new database objects like Tables, Procedures, Functions, Triggers, and Views using T- SQL

Environment: MS SQL Server 2008/2008R2, 2005 and 2000, MS SQL Server 2005, MS SQL Server Reporting Services, MS SQL Server Integration Services, SSAS, ProClarity, MS SQL Server Analysis Services 2000, C#, ASP.NET, VB.NET, OLAP, UML, Erwin, DTS/SSIS, BIDS.

Confidential

SQL/ Database Developer

Responsibilities:

• Worked with Technical Architects and Database Analysts for the Design of Summary tables required for efficient Report Design.
• Created complex SQL stored procedures using Microsoft SQL Server 2008 and 2008 R2
• Designed the functional and technical documents, report templates and reporting standards for the developers to work on the report development.
• Experience in developing reports using SSRS 2008 and SSRS 2008 R2
• Created cubes and dimensions and measures and calculated measures according to the business requirements.
• Created SSIS packages to Oracle and other SQL Server instances in SSIS2008.
• Performed the task of data transfer from files in remote server to folders in another server using FTP.
• Using SSIS, loaded XML data to the Database tables and Extracting Data using SSIS into Excel Files for Marketing purpose
• Generated reports from the cubes by connecting to Analysis server from SSRS.
• Developed the SQL Server Integration Services (SSIS) packages to transform data from SQL 2000 to MS SQL 2005 as well as Created interface stored procedures used in SSIS to load/transform data to the database.
• Created cubes for production application, Partitioned Cubes to decrease the processing time and increase the performance of the queries running on front end application using SSAS2008.
• Responsible for logical and physical data modeling, database design, star schema, data analysis, programming, documentation and implementation.
• Experience in Developing and Extending OLAP Cubes, Dimensions and data source view.
• Extracting the data from the different sources (CSV files, oracle, and MS SQL) and stored the data into the intermediate Staging Database using the SSISETL tool.
• Developed complex stored procedure using T-SQL to generate Ad hoc reports using SSRS.
• 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.
• Build database queries and test cases for the testing team to test the reports.
• Prepared the reports for the day-to-day as well as weekly/monthly purposes in various formats like MS Excel, PDF, HTML, and XML etc.
• Lead the team of developers to write efficient code.

Environment: SQL Server 2008/2008 R2, 2005, 2000, Business Intelligence Studio (SSAS, SSIS, SSRS), SharePoint 2007, T SQL, Erwin, TFS, MDX, Oracle 10g, ProClarity, MS Excel.

Confidential

Database Developer

Responsibilities:

• Involved in the System study, analysis and Design for creating a robust MIS Reporting System.
• Involved in initial study, design of Data Warehouse for better Reporting for Inventory and Procurement Systems.
• Designed the Sales and Manufacturing Summary reports in SSRS 2005 from the requirement document.
• Used SQL*Loader to load flat files data to various tables.
• Created database objects like Tables, Indexes, Stored Procedure, Triggers, Functions, Constraints and Views.
• Fine-tuned Stored Procedures to improve performance that was achieved by removing unnecessary Cursors and Temporary Tables.
• Worked on Linked Servers to run distributed queries between SQL server and other data sources like excel using ODBC, OLE DB Drivers.
• Responsible for Design and Normalization of the database tables.
• Prepared Data Flow Diagrams, Entity Relationship Diagrams and Table Structure.
• Created and Migrated DTS packages from SQL Server 2000 to SQL Server 2005 Integration Services (SSIS).
• Gathered requirements for the creation of Data Flow processes for the SSIS packages.
• Used various Control Flow Tasks in the development of various complicated packages.
• Experience in Developing and Publishing Reports in SQL Server 2005 using SSRS (SQL Server Reporting Services).
• Generated and formatted Reports using Global Variables and Expressions for the reports. Designed and implemented stylish report layouts.
• Identified and worked with Parameters for Parameterized Reports in SSRS 2005/2008.
• Experienced in performance tuning using SQL profiler and Monitored SQL Server Error Logs and Application Logs.

Environment: SQL Server 2005, SSIS 2005, Management Studio, DTS, Windows 2003/NT.