SUMMARY

• More than 8 years of experience as MSBI Developer in Database Design, Development & Support using SQL Server, SSIS, SSRS. Business Objects, Crystal Reports, Excel, and Oracle.
• Experience in Software Development Life Cycle (SDLC) Methodologies such as Waterfall, AGILE, SCRUM, RUP (Rational Unified Process), Extreme Programming, Iterative Development, System Analysis & Design concepts.
• Experience with Relational Database Management Systems including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Import/Export, Triggers & Cursors.
• Working knowledge of Data warehousing, Data marts and OLAP technologies including Star Schemas, Snowflakes using Erwin Tool and Microsoft Visio ETL processes, dimension modeling and reporting tools.
• Experience working with ETL tools, including SQL Server Integration Services (SSIS), Data Transformation Services (DTS), and DataStage and ETL package design, and RDBM systems like SQL Servers, Oracle, and DB2.
• Expertise in RDBMS Database Design, Installation, Configuration, Performance Tuning, Optimization, Backup - Recovery and Maintenance activities.
• Proficient in creating SSIS packages, migrating DTS Packages to SSIS, data extraction from various data sources using Flat file, Excel, ADO.NET, ODBC, OLEDB connections.
• Expertise in native tools like Index Tuning Wizard, Database Tuning Advisor, Profiler, Performance Monitor, Activity Monitor, and Event Viewer for Query performance analysis.
• Experience in developing Custom Report and different types of Tabular Reports, Matrix Reports, and drill down reports in multiple formats using SQL Server Reporting Services (SSRS) in Business Intelligence Development Studio (BIDS).
• Built & deployed CUBES using SQL Server Analysis Services (SSAS) Built dimensions, measures, hierarchies, calculated attribute, KPI, perspective, partitions, and MDX query.
• Experience in data migration (using tools like DTS, BULK INSERT, BCP and Replication) between different homogeneous/heterogeneous systems and SQL Server.
• Expert on creating multiple type of reports using tools like Power BI, SSRS, Tableau, Excel (Pivot Table, Matrix, Power Map) and SAP Business Object.
• Experience in creating Power BI Desktop reports in Report view to Power BI service.
• Experience in disaster recovery with Backup & Restore Strategies. Created Scheduled Tasks for regular Database Backup and Maintenance Activities.
• Extensively used tools like SQL Profiler, Index Tuning Wizard, and Windows Performance Monitor for monitoring and tuning MS SQL Server performance.

TECHNICAL SKILLS

Operating Systems: Windows Server, Unix, Linux

Languages: T-SQL, PL/SQL, ASP.NET, .Net Framework, C#, XML

Data Warehouse: SSIS, SSRS, SSAS, BIDS (Business Intelligence Development Studio), Data tools, DTS, Informatica Cloud, TFS, Erwin, Business Process Automation, Data Quality Service, MDM (Master Data Management)

Databases: MS Access, SQL Server, Oracle, Teradata, MySQL, DB2

Reporting Tools: SSRS, Qlikview, Cognos Report Studio, Report Builder, Power BI

Other Tools: SQL Sentry Power Suite, VSS, TFS, HP Quality Center, GitHub

PROFESSIONAL EXPERIENCE

Confidential, Richardson, TX

Sr. MSBI Developer

Responsibilities:

• Expertise in analysis, design, and development of end to end business intelligence solutions using theMSBIsuites such as SQL Server Integration Services(SSIS), SQL Server Analysis Services(SSAS) and SQL Server Reporting Services(SSRS).
• Implemented and enhanced existing reports like Drilldown, Drill Through, Sub-Reports, List, Tabular, Matrix, Navigation Reports, Standard Parameter, Cascading Parameter and Multi-Value Parameters in SSRS.
• Perform database development dat includes Schema development, Stored Procedures dat could be used by different Windows Services.
• Used SSIS variables, parameters, and expressions to implement dynamicity of Master ETL Package, connection managers, tasks, containers, Send Mail, Row Count, Script tasks, etc.
• Monitored and maintained existing ETL packages and Reports to fix issues and bugs and troubleshooting.
• Created dashboards for Sales, Marketing, Finance and Production using benchmarked data to provide an analytical snapshot of point in time data
• Created variousMSBI(SSIS) packages using data transformations like Merge, Aggregate, Sort, Multicasting, Lookup, Conditional Split, and SCD (Slowly Changing Dimension) and Derived column, transformation of XML based on XSD File Experience with designing the ETL process, including data read/write, data transformations, error handling, process design, logging, and Development
• Creation of ETL packages to load data from files into database by performing different kinds of transformations using SSIS
• Involved in writing T-SQL programming to implement Stored Procedures and Functions for different tasks and created Triggers to enforce data and referential integrity.
• T-SQL development included queries using joins, sub queries, Ranking functions, Derived tables, common table expressions (CTEs), stored procedures, views, constraints, and Database triggers.
• Used to connect different data sources like SQL DB (SQL Query), Tabular Model (DAX Query), Web Trends to Power BI and generate reports with different visualizations.
• Involved in development &Deployment of SSAS Cubes and Monitor Full and Incremental loads and support any issues.
• Creating SSIS packages and scheduled them as jobs to run automatically to Process the cube, load data etc.
• Experienced in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous System using SQL tools like SSIS, Data Transformation Services (DTS), Bulk Insert, BCP, and XML.
• Extensive reporting skills using SQL Server Reporting (SSRS).
• Created Data Models for each module of the current OLTP system and participating in the brain storming session to nail possible design challenges.
• Performed unit and system testing, troubleshooting and bug fixing in development and QA environments.
• Worked on TFS for performing tasks

Confidential, Riverwoods, IL

Sr. MSBI Developer

Responsibilities:

• Responsible for data modeling, designs and development, oversight of implementation, testing, and managing the relationship between the client and the development team.
• Worked with User Defined Functions & Triggers to store data in tables and created indexes in least updated tables to improve the query performance.
• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables from different databases
• Created complex SSIS package to automate complete process and deployed them to File Share & Server to enable users execute these processes using SQL Server 2016.
• Prepared the complete data mapping for all the migrated jobs using SSIS.
• Created Data Models for each module of the current OLTP system and participating in the brain storming session to nail possible design challenges.
• Designed configurations tables & ETL templates to maintain consistency in all the solutions.
• Configured SSIS Catalogs for Development and UAT environments and using parameters to drive all configurations changes and deployments.
• Maintained existing Power BI reports and dashboards and made changes onto the same as per new and changing business requirements.
• Developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
• Wrote T-SQL programming to implement Stored Procedures and Functions for different tasks and created Triggers to enforce data and referential integrity.
• Interacting with the users and troubleshooting the problems involved with the development of stored Procedures, triggers and problems related to the privileges.
• Developed database objects such as SSIS Packages, Tables, Triggers, and Indexes using SQL Analyzer and Enterprise Manager.
• Designed facts and dimension tables and defined relationship between facts and dimensions with Star Schema and Snowflake Schema in SSAS.
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and analyze multi-dimensional reports.
• Developed automation scripts which used REST APIs to extract data from blob storage of Azure Cloud Services.
• Set-up Enterprise Gateway & SSAS Connector on AzureVM for Power BI Report deployment.
• Used SSIS tasks like Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Database.
• Used Team Foundation Server (TFS) to check-in/check-out SSRS reports & SSIS packages.

Confidential - Atlanta, GA

SSIS/SSRS/SSAS Developer

Responsibilities:

• Involved in complete SDLC process by analyzing business requirements and functional work flow of information from source systems to destination systems.
• Designed and monitored construction of the ETL processes and provided the ETL mappings in the design document.
• Conducted and automated the ETL operations to extract data from multiple data sources; transform inconsistent and missing data to consistent and reliable data; and finally load it into the Multi-dimensional data warehouse.
• Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts.
• Wrote complex queries, stored procedures, functions and views to ensure data integrity, data consistency and to meet the business rules.
• Implemented various SSIS tasks such as conditional split, data validation checks during Staging, before loading the data into the Data warehouse.
• Used XML & environment variables in package configuration for Deploying SSIS packages.
• Wrote Parameterized Queries for generating Tabular reports and Sub reports using Global variables, Expressions, Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS.
• Generated Drill down, Drill through, Ad-hoc, Matrix Reports, Parameterized reports in SSRS.
• Deployed and scheduled reports using SSRS to generate all daily, weekly, monthly and quarterly reports including current status.
• Involved to planning and designing SSAS Cubes and building attribute relationships for optimal MDX query performance of Hierarchies and Fact Dimensions.
• Used SSAS MDX to extract data from cubes & created MDX script for Cube Calculation.
• Used Power BI Power Pivot to develop data analysis prototype and used Power View and Power Map to visualize reports.
• Deployed and uploaded the SSRS reports to Report Manager and called reports through a URL from .Net API for the end users and involved in enhancements and modifications.
• Deployed and uploaded SSRS reports to SharePoint server for end users to look at them.
• Converted Excel reports into SSRS reports and also into other required formats.
• Integrated SQL Server reporting services with Microsoft SharePoint Portal Server to deliver automatically generated reports to the Share Point portal.
• Reviewed Third Party tools so as to help automate routine tasks such as monitoring, blocking and consolidate status of scheduled jobs.
• Involved in migrating SQL Server databases to SQL Azure database using SQL Azure Migration Wizard.
• Used TFS to manage different versions of new and existing reports and code, branching and merging into production.
• Developed functional and technical documentation to assist in the design, development, and maintenance of deliverables.

Confidential - Charlotte, NC

MSBI Developer

Responsibilities:

• Involved in reviewing BRD, FRD, use cases, test scenarios, test cases for testing the functional/non-functional aspects & suggested changes from Data Integrity perspective.
• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables from different databases.
• Created SSIS packages to extract data from OLTP and transformed to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Used SSIS tasks like Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Audited and cleaned data with Conditional Split, Derived Column, and Fuzzy Lookup transformation tasks.
• Migrated different kinds of records using Reporting Services Migration Tool by performing necessary steps to prevent loss of reports.
• Created different Parameterized Reports consisting of Report Criteria in various reports to minimize the report execution time and to limit the no of records required.
• Created views in Tableau Desktop dat were published to internal team for review and further data analysis and customization using filters and actions.
• Created action filters, sets, parameters and calculated sets for preparing worksheets and dashboards in Tableau.
• Created Materialized Views and Indexes for better performance of summary tables, Autonomous Transactions, Coding Dynamic SQL Statements.
• Planned complete Back-up of Database and Restored the Database from Disaster Recovery.
• Database Integrity checks, Database Statistics update and Re-indexing.
• Created check constraints to maintain data integrity.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Worked as a developer in creating complex T-SQL, stored procedures, cursors, tables, and views and other SQL joins and statements for applications.
• Performed backup and restore by using SQL Server tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Used indexes to enhance the performance of individual queries and enhance the stored procedures reading the Execution Plan.

Confidential - Charlotte, NC

SQL BI Developer

Responsibilities:

• Created a Database and normalized the database into small tables by applying rules of Normalization, defined Check Constraint and applied Business Rules.
• Written Complex and Extended T-SQL Stored Procedures for application developers and some User Defined Functions.
• Created and executed SSIS 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 export heterogeneous data from OLE DB Source (Oracle), Excel Spreadsheet to SQL Server.
• Migrated DTS packages to SSIS and modified the packages accordingly using the advanced features of SQL Server Integration Service.
• Studied the existing OLTP system and created facts, dimensions, and Star Schema representation for the data mart.
• Responsible for identifying and defining Data Source and Data Source views.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, XML) and loaded data into target data sources by performing different transformations using SSIS.
• Created multiple reports in Drill mode using tables, financial tables, crosses tabs and charts using Reporting Service (SSRS).
• Designed, deployed, and maintained of various SSRS Reports in SQL Server. Assisted in migrating denormalized report DB into a Star Schema design.
• Designed & 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.
• Hands on Experience in Filtered Indexes and Data Compressions for Performance and Optimum space utilization in SQL Server.
• Developed database objects using Common Language Runtime (CLRs) to interact with .NET application.
• Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.
• Provided production support for the ETL jobs and also to the code deployed into the production environment.
• Used Microsoft Team Foundation Server (TFS) to get the lists of bugs dat do not have test cases, regressions on previously passing tests.