SUMMARY

• 9+ years of IT experience in teh development, use and management of MS SQL Server 2008R 2/2012/2014/2016 databases and Business Inteligence solutions using POWER BI.
• Extensive experience in MS SSIS 2008R2/2012/2016, Analyze and Design SSIS Packages, building cubes using SSAS and developing reports using SSRS and its different tools like SSMS, BIDS, TFS, SQL Profiler, Execution Plan and Visual Studio.
• Hands on experience in extracting teh data fromheterogeneoussources such asFlat Files(.csv files),Excel Files,Oracle 11g/10g,MS SQL Server,IBM DB2,FTP ServerandXMLSourceand load teh data into targetODS,data martsanddata warehouses using SSIS packages.
• Experience in using several control flow tasks sequence container, For Loop, For Each Loop, ActiveX Script Task, CDC task in SSIS 2012, data flow task, BCP (Bulk Insert Program) Task, Execute SQL, File System, FTP, Script tasks, Data Flow Transformations Look Up, Cache transformation, Checksum transformation, Conditional Split, Derived Column, Merge Join and Union All.
• Experience wif Package level configurations (XML Package configurations in 2008R2) and Project level configuration (managed environment variables inside SSMS 2012).
• Experience wif MS SQL SSIS 2012/2016 new features including Integration Services Catalogue, execute teh SSIS package through teh stored procedure, Parent child packages, Master Package Executioner, SSIS DB and ETL Audit databases in tracking teh ETL processes.
• Experience in using project parameters in project level configuration while deploying teh SSIS projects to teh SSIS Integration services catalogue SSIS - DB, validate, test and execute teh SSIS packages before teh deployment by switching to teh test servers using a project parameter.
• Experience in maintenance and administration of ETL processes by creating SQL Server Agent ETL jobs wif multiple steps, Alerts, SQL Mail Agent, and schedule SSIS packages.
• Excellent experience in creating OLAP multidimensional and tabular cubes using SSAS.
• Experience designing teh SSAS MOLAP cubes right from teh scratch, starting from gather & understand teh requirements, identify teh dimensions and facts, create dimensions, time dimension, cubes, cube dimensions, dimension hierarchies, defining key columns, flexible and rigid relationships, measure groups, calculated measures, cube partitions, cube aggregations, and processing cubes wif different conditions.
• Experience in creating SSAS calculated measures and writing teh MDX expressions using features like wif member, hierarchies, expressions and MDX functions including Tail, Head, TOP BOTTOM Count Hierarchy Levels, Parallel Period, Rank, RollUpChildren, IIF, TupleTo String etc.
• Very good experience in tuning SSAS Cubes by creating cube partitions and aggregations and performing parallel cube partitions.
• Experience in developing SSAS Tabular.bim model by importing star format data and single tabular data into teh Visual Studio 2015 Pro Semantic Model project.
• Experience in using new SSAS tabular model features including handling Many-to-Many relationships wif different techniques, analyze in Excel, “Mark as Date” for Date Dimension, Role Playing dimension techniques, and other cube processing and deploying techniques.
• Experience in SSAS 2016 and SSRS 2016 combination by accessing SSAS tabular cubes through SSRS query designer in a way writing MDX queries including wif parameters, and developed SSRS charts, graphs, gauges, maps, Tablix and matrix reports.
• Extensive experience in developing relational based and cube based reports using SSRS.
• Very good experience in working wif several types of SSRS reports including drill-down, drill through, sub reports, tablix, matrix, charts, graphs, gauges, Power view and Excel PowerPivot also working wif front end UI application dashboard portals.
• Extensive experience in developing complex level SSRS reports, displaying teh real-time(almost) data in SSRS reports wif data retention limits using CDC (Change Data Capture) techniques.
• Experience in developing dashboards using Power BI Desktop, Power BI Service, POWER BI sourcing from SSAS tabular cubes, pin SSRS charts, gauges, graphs into POWER BI dashboards.
• Experience in publishing SSRS reports into Mobile Report Publisher, PowerBI dashboards, Power BI Mobile apps dashboards, Sharepoint webparts and provide teh ad-hoc structure to teh business users.
• Experience wif Power BI desktop, Service, installation, configuration and administration.
• Experience in both on premise and Cloud POWER BI desktop dashboards, POWER BI Service dashboards(POWERBI.COM), POWER BI Mobile Apps.
• Experience in automate teh dashboard refreshes, publishing teh dashboards to teh granted people wifin teh enterprise by publishing teh dashboards to teh powerbi.com service.
• Experience in setting teh alerts on POWER BI Service dashboards when some changes occur in vital KPIs and measures.
• Expert in tuning teh T-SQL Stored Procedures, SSIS Packages, SSAS cubes, SSRS Reports and deliver high performance and high - integrity business intelligence reports.
• Experience in deploying teh SSRS reports into SharePoint integrated mode and wire teh report into sepcific business users based on teh parameters.
• Strong experience in T-SQL to write: stored procedures, views, functions, CTE’s, recursive CTEs, Triggers, WHILE LOOPS, indexes (covering index, clustered and non-clustered), DDL and DMLs.
• Excellent noledge in OLTP transactional, RDMMS concepts, conceptual, logical & physical models, Normalization (1NF, 2NF, 3NF), De-Normalization, OLAP multi-dimensional databases (ROLAP, MOLAP), DataMart’s, Data warehouses, ODS, Dimensional Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions.
• Extensively followed teh advanced concepts of Ralph Kimball and Bill Inman Methodologies and data modeling concepts like conceptual, logical, and physical model, Large Dimensions, SCD’s (SCD1, SCD2), Degenerate Dimension, Fact less Fact tables, different granularities, Families of stars, conformed dimensions and Facts.
• Good ability to quickly grasp and learn new concepts and technologies, possess excellent oral / written communication and interpersonal skills.
• Currently located in Plano, TX (75024), ready for relocation and available for phone and face to face interviews immediatly.

TECHNICAL SKILLS

Operating Systems: MS-DOS, Windows 95/98/NT 4.0/XP/2000/2003 Server, UNIX

RDBMS/Databases: MS SQL Server 2008R 2/2012/2014/2016, Oracle 11g /10g, IBM DB2 UDB, IBM DB2 Z/OS mainframes and No SQL database HP Vertica

Data modeling and ETL Tools: MS SSIS, Informatica, Erwin and Power Designer v15.0

Reporting & BI Tools: SSRS, MS Excel PowerPivot, Power BI, Tableau

Languages: T-SQL, PL/SQL, VB-Script and C#

Microsoft Technologies: Sharepoint, TFS, WebForms, WebParts, VB.Net, ASP.Net

PROFESSIONAL EXPERIENCE

Confidential, Richardson, TX

Sr MS SQL Server BI (SSIS SSAS SSRS) and PowerBI Data Visualization Developer

Responsibilities:

• Participate in teh team business requirements gathering and analyze, understand and convert them into database solutions.
• Design ETL Packages wif Microsoft SSIS 2016 to pull data from various sources like DB2, SQL Server and Flat Files to individual Data marts which ultimately go into Enterprise Data Warehouse (EDW).
• Cleanse Data while loading and write logic to perform different kinds of transformations like Derived Column, Conditional Split, Lookup, Data Conversion, SCD’s, CDC(Change Data Capture) etc.,
• Extensively worked on CDC (Change Data Capture) at teh database level and used control flow items CDC(Change Data Capture) task, CDC Split task into INSERT, DELETE and UPDATE in SSIS.
• Wrote complex Stored Procedures, functions and triggers as and when needed to convert data logically as per teh business requirements.
• Extensively used Package Configurations and project level configurations while deploying teh SSIS packages from DEV - Stage, Stage - Prod environments.
• Initially loaded data into staging tables using different SSIS control flow tasks, loop containers and data flow tasks, tan moved teh data into dimension and fact tables.
• Initially loaded data into staging tables using different transformations, control flow tasks, loop containers and data flow tasks, tan moved teh data into dimension and fact tables.
• Once teh data is in place, developed teh cube right from teh scratch wif multiple cube dimensions, hierarchies, measure groups and calculated measures.
• Improved cube performance by tuning base cube query, creating cube partitions, performing parallel process on cube partitions.
• Developed teh reports into Excel PowerPivot and connecting from SSAS.
• Tuned SSAS cubes and improved both cube query performance and processing performances by applying several tuning techniques.
• Generated SSAS tabular cubes, created measures using DAX expressions, hierarchies, partitions, generated SSRS reports connecting to Tabular cubes using SSRS 2016 new query designer feature to connect cube and write MDX & DAX expressions in it.
• Developed tablix, matrix, graphs, charts, gauges, sub reports, parameterized, drill through, drill up and drill down reports.
• Exported SSAS Tabular model reports into Microsoft excel and designed teh super-fast slice and dice and pivot dashboards.
• Extensively worked on SSRS relational based and cube based reports.
• Implemented CDC techniques in a way dat teh SSRS reports display latest data, by creating different snapshots of CDC data INSERT, DELETE & UPDATE in DataMart database, and implemented 2 step SSIS job Source to Fact, Fact to DataMart and showed latest data in SSRS reports.
• Developed tablix, matrix, graphs, charts, gauges, sub reports, drill through, drill up and drill down reports.
• Heavily worked on new reports, existing reports, report performance issues and report support issues for teh different partner UI dashboards.
• Heavily worked on SSRS report performance, store procedure tuning, table partition, MDX based queries, cube partition, T-SQL stored procedure tuning.
• Used teh concepts of parameter sniffing, aggregated calculation in stored procedures instead in teh report tablix, writing teh SQL queries in a way dat teh indexed columns being utilized and other stored procedure tuning techniques to improve teh report performance for teh large volume of data.
• Used SQL Profiler, Actual and estimated execution plans to troubleshoot teh Stored Procedure by identifying and solving Table Scan, Index Scan, Index Seek, Key Lookup, loop and Sort issues.
• Downloaded and installed free versions of POWER BI Desktop, POWER BI Service, POWER BI Gateways and POWER BI Mobile Apps.
• Created a POC (Proof of Concept) by generating POWER BI Desktop dashboards on premise, published into Mobile Report Publisher and accessed these dashboards via Power BI Mobile App.
• Participated in a conference call wif Microsoft POWER BI team and figured teh right tools (POWER BI Service Cloud and POWER BI Pro version) for our enterprise data visualization dashboard requirements.
• Generated dashboards using POWER BI desktop & POWER BI Service (cloud) in a POWER BI Pro version.
• Generated SSAS 2016 tabular cube, SSRS 2016 reports, and used as sources for POWER BI.
• Installed enterprise POWER BI gateway to connect to SSAS tabular cube data source from POWER BI Service.
• Generated dashboards in POWER BI Desktop and POWER BI Service using super-fast slice and dice and modern data visualization features.
• Generated a landing page for SSRS reports, pin these SSRS reports into POWER BI service dashboards, published into POWER BI Mobile App in a way dat business users can access teh dashboards in Ipads and Iphones using their service accounts.

Environment: MS SQL Server 2016, SSRS 2016, SSAS 2016, SSIS 2016, Mobile Report Publisher, Oracle 11g, MS Visual Studio, TFS, POWER BI Desktop, POWER BI Service, POWER BI Mobile Apps.

Confidential, TX

Sr MS SQL Server BI (SSIS SSAS SSRS) and PowerBI Data Visualization Developer

• Participating in teh business requirements gathering for Manager Access Review, Compliance Training, Resource Roster, Role Taxonomy and Birthday & Service Anniversary report projects.
• Worked wif data architects and participated in teh data modeling, database design and data warehouse design.
• For one of teh projects (Manager Access Review), designed teh end-to-end architecture including developing teh data model, designed teh database and data warehouse, ETL process, SSRS report and SharePoint web dashboard page.
• Designed teh ETL database, data marts, Dimensional Model wif Fact and Dimension tables.
• Designed teh ETL Refresh Data Model master package using SSIS which contains collection of several master packages running several child packages in different stages.
• Converted teh ETL process into a 1 package execution which scheduled to run refresh on AutoSYS At teh defined schedule to refresh teh whole data model of our project.
• Created teh ETL packages in a way dat avoid using teh stored procedures and replace teh code to in-line SQLs wifin teh execute SQL task and convert teh stored procedure code to SQL files and retrieve into SSIS using teh “file connection” connection manager. dis method is to eliminate teh CRQ deployment process of databases changes from DEV to PROD.
• Created T-SQL scripts (stored procedure, functions, triggers, views, tables, indexes etc.) and Oracle PL/SQL scripts, PL/SQL Packages, procedures, triggers, functions, Indexes & collections.
• Generated SSAS tabular cubes, created measures using DAX expressions, hierarchies, partitions, generated SSRS reports connecting to Tabular cubes using SSRS 2016 new query designer feature to connect cube and write MDX & DAX expressions in it.
• Developed tablix, matrix, graphs, charts, gauges, sub reports, parameterized, drill through, drill up and drill down reports.
• Implemented a POC (Proof of concept) of developing dashboards using Microsoft Excel 2013 professional version new features POWER PIVOT, POWER CHART, and POWER VIEW features and deployed dashboards into SharePoint web forms and web parts.
• Developed reports directly connecting to SSAS from SSRS and designed several reports.
• Heavily worked on new SSRS reports, existing reports, report performance issues and report support issues for teh different UI dashboards.
• Worked on Microstartegy reports, MSTR Web and MSTR dashboards for DEV and PROD.
• As per teh project requirement, successfully converted teh existing Microstrategy reports, dashboards & SSRS reports, SharePoint dashboards.
• Developed tablix, matrix, graphs, charts, sub reports, parameterized (single value select and multivalued select), drill through, drill up and drill down reports.
• Tuned teh SSRS reports using teh concepts of parameter sniffing, aggregated calculations in stored procedures instead in teh report tablix, sorting in SP instead in tablix, create a separate summary table wif measures and parameter fields for summary report, do INSERT INTO Summary table from SELECT, create indexes on parameter columns and other SP tuning techniques to improve teh performance for teh large volumes of data.
• Used SQL Profiler, Actual and estimated execution plans to troubleshoot teh Stored Procedure Table Scan, Index Scan, Index Seek, Key Lookup, loop and Sort etc. issues.
• Worked on developing POWER BI dashboards.
• Defined teh both standard and data driven subscriptions and send teh SSRS report server links wif PDF attachments to teh business users on teh scheduled subscription times.
• Designed teh Share Point landing page for teh RTB project, created SharePoint web parts and teh linked SSRS reports and provided portal share point presentation to teh business users.
• Defined teh user role groups and assigned teh security for teh reports at teh report server level.
• Developed teh SharePoint landing page dashboard using SharePoint web parts, Report Viewer, Page Viewer, defined teh security, granted required access to teh required groups and defined standard and data driven subscriptions.
• Developed dashboards using POWER BI Desktop and POWER BI Service.
• Used advanced data visualization features and developed Graphs, gauges, charts, maps.
• Wrote complex DAX expressions, created calculated measures, calculated columns, calculated tables, by using DAX functions CALCULATE, EVALUATE, SUMMARIZE, RELATED, RELATED TABLE, SUM, SUMX, LOOK UP, USER NAME etc. and implemented role based security as well as row level security.
• Worked wif POWERBI content packs, different source systems, DIRECT QUERY and IMPORT connections, developed dashboards, applied filter (row level, visualization level, drill through) and implemented POWER BI on-promise environment using POWERBI Gateway.
• Created Alerts, automated data refreshes to show almost real-time data in POWER BI Service dashboards.
• Published teh latest version dashboards simultaneously to teh granted users through POWER BI service.
• Published these dashboards into POWER BI Mobile App and granted access to users to view teh dashboards in teh mobile devices.

Environment: MS SQL Server 2008R2 & 2012, SSRS, SSAS, SSIS 2012, Oracle 11g/10g, MS Visual Studio 2008 & 2010, POWER BI Desktop, POWER BI Service.

Confidential, Jacksonville FL

Sr. MS Power BI Developer/ Sr. MS SQL Server BI (SSIS SSAS SSRS) Developer

Responsibilities:

• Participating in database business requirements gathering for AutoNation, Southeast Toyota, Passport Nissan, Aftermarket, Driver Connect, DirectToDealer, Jiffy Lube, Big O Tires and Brandon Honda projects.
• Moved Flatfile .csv, Excel and other OLTP sources data into RRS ETL databse, and moved from RRs ETL to Staging Area RRS Campaign Manager, performed Address Cleansing using Melissa Data and Google Analytics, VIN Cleansing and apply specific business rules using SSIS dataflow transformations and load teh data into FACT table.
• Initially moved teh files from FTP to ETL database, ETL database to Master Tables, Master to Stage, and Stage to DWH.
• Wrote complex relational based Stored Procedures, MDX based Stored Procedures, functions and triggers as per teh business requirements.
• Involved in teh “Universal Campaign Manager MOLAP Cube” design right from teh scratch.
• Part of building “Sales Retention” and “Service” cubes on RRS AutoEDW enterprise data warehouse (EDW) which will be used as primary source as reporting.
• Involved in teh optimization of SQL queries which resulted in substantial performance improvement for teh conversion processes.
• Created a SSAS linked server and accessed SSAS MOLAP cube into teh stored procedure using SSAS linked server catalogue, retriev teh MDX query result using OPENQUERY, fetch teh results, perform Pivot & Unpivot and generate teh results for SSRS dataset.
• Generated SSRS reports, in a way dat teh same reports used for different partners, by writng right SSRS expressions to perform respective visibilities, color selections, drill down, drill through, sub reports, and apply proper parameters.
• Implemented a POC (Proof of concept) of developing dashboards using Microsoft Excel 2013 professional version new features POWER PIVOT, POWER CHART, and POWER VIEW features and deployed dashboards into SharePoint web forms and web parts.
• Experience in copy databases, backup and restore database wizards etc.
• Experience wif SQL Server Integration Services Catalogue (SSIS DB, ETL database, Parameters and environments), SQL Server Security, SQL Server Management and SQL Server Agent.
• Worked on SQL Server jobs, scheduled jobs based on hourly, daily and weekly schedules, executing teh ETL processes in order, and worked job failures and troubleshoot teh jobs.

Environment: MS SQL Server 2014/2016, Visual Studio 2012/2015, SSRS, SSAS, SSIS, TortoiseSVN, SharePoint, Oracle RDR, PL/SQL, TOAD, SharePoint, AutoSYS, Agile methodology.

Confidential, Virginia Beach, VA

MS SSIS SSAS SSRS Developer

Responsibilities:

• Working wif teh Business Analysts and Business Users to identify information needs as per our project requirements.
• Design and maintain MS SQL SSIS Packages, T-SQL Stored Procedures, scripts, and code for high performance.
• Design ETL Packages wif Microsoft SSIS to pull data from various sources like DB2, SQL Server, JDE, Flat Files and other systems to individual Data marts which ultimately go into Enterprise Data Warehouse (EDW).
• Created new stored procedures, T-SQL scripts to improve teh productivity of teh claims processing system.

Environment: MS SQL Server 2005, SSIS, SSRS, Oracle 11g/10g, IBM Rational Robot, PL/SQL, Factes Claims Processing, MS Excel, MS Visual Studio.Net, C#.

Confidential, Moline, IL

MS SQL Server SSAS SSIS Developer

Responsibilities:

• Worked ETL SSIS for transferring and reviewing data from heterogeneous sources like (Source Databases, FTP Server and Excel, CSV, flat file, Text Format Data).
• Developed T-SQL queries, triggers, functions, cursors and stored procedures.
• Created complex SSAS cubes named “Reporting Consolidated BIWarehouse” wif multiple fact measures groups (Invoices, Opportunities, Pending Sales and GLTransaction) and multiple dimension hierarchies based on teh OLAP reporting needs.
• Interacted wif Business Users to halp them understand how to generate reports/look at teh business data wif various drill down options using Excel 2003/Excel 2007 connecting to SQL Server Analysis Services (SSAS).
• Heavily worked on database performance tuning and query optimization, data integrity and statistics.

Environment: SQL Server 2005/2008, T-SQL, SSIS, SSAS, SSRS, Informatica, Oracle 11g/10g, PL/SQL, Microsoft Visio, SQL Profiler.

Confidential, Buffalo, NY

Oracle PL/SQL Developer / OBIEE Developer

Responsibilities:

• Worked during teh whole life cycle of teh project from requirements gathering to deployment.
• Developed metadata repository usingOBIEE Administration toolin Physical, Business Model and Mapping, and Presentation Layer.
• Developed Time Series Objects usingAgo and ToDate functionsfor time series comparisons.
• Created varioussession and repository variablesand initialized them in theInitialization Blocks to change metadata dynamically as teh environment changes.
• ConfiguredBI SchedulerandOracle BI Delivers- iBotsto deliver alerts and publish updated content to subscribed users as per teh schedules and requirements.
• Implementedsecuritybased onLDAP Autantication.
• Createdsecurity settingsin OBIEE Administration Tool and set up groups, access privileges and query privileges and also managed security for groups in Answers.
• IntegratedBI Publisherwif OBIEE to build reports in word, excel and doc format.
• Created various templates, reports, and prompts in BI Publisher.
• Developed test cases and performedUnit Testing and Integration Testingof teh Repository and Web Catalogs.
• Provided guidance and support to end users during teh implementation and in production.

Environment: Oracle, PL/SQL, TOAD, OBIEE, XML, UNIX Shell Scripting.