SUMMARY:

• 10+ years of IT experience in the 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 the data from heterogeneous sources such as Flat Files (.csv files), Excel Files, Oracle 11g/10g, MS SQL Server, IBM DB2, FTP Server and XML Source and load the data into target ODS, data marts and data 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 in reading multiple excel files with multiple sheets in each file, loaded the filed into the table including with file name and sheet names using SSIS script task and C# code.
• Experience working with SSIS Logging using Script Task and c# code by defining rows processed variable and track the rows effected in each step.
• Experience in writing C# code to upload the output from a SQL table to notepad.
• Experience with Package level configurations (XML Package configurations in 2008R2) and Project level configuration (managed environment variables inside SSMS 2012).
• Experience with MS SQL SSIS 2012/2016 new features including Integration Services Catalogue, execute the SSIS package through the stored procedure, Parent child packages, and Master Package Executioner, SSIS DB and ETL Audit databases in tracking the ETL processes.
• Experience in using project parameters in project level configuration while deploying the SSIS projects to the SSIS Integration services catalogue SSIS - DB, validate, test and execute the SSIS packages before the deployment by switching to the test servers using a project parameter.
• Experience in maintenance and administration of ETL processes by creating SQL Server Agent ETL jobs with multiple steps, Alerts, SQL Mail Agent, and schedule SSIS packages.
• Excellent experience in creating OLAP multidimensional and tabular cubes using SSAS.
• Experience designing the SSAS MOLAP cubes right from the scratch, starting from gather & understand the requirements, identify the 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 with different conditions.
• Experience in creating SSAS calculated measures and writing the MDX expressions using features like with member, hierarchies, expressions and MDX functions including Tail, Head, TOP BOTTOM Count Hierarchy Levels, Parallel Period, Rank, RollUpChildren, and IIF 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 the Visual Studio 2015 Pro Semantic Model project.
• Extensive experience in using new SSAS tabular model features including handling Many-to-Many relationships with 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 with 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 with several types of SSRS reports including drill-down, drill through, sub reports, tablix, matrix, charts, graphs, gauges, Power view and Excel PowerPivot also working with front end UI application dashboard portals.
• Extensive experience in developing complex level SSRS reports, displaying the real-time (almost) data in SSRS reports with 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 automate the dashboard refreshes, publish the dashboards to POWERBI.com and define the subscriptions to the granted people within the enterprise.
• Experience in utilizing the power BI import, Direct Query and live connection methods based on the business scenario.
• Experience in configure the role-level security in Power BI dashboards and provide/restrict the access to the respective business users based on the privileges.
• Experience in set the alerts on POWER BI Service dashboards when some changes occur in vital KPIs and measures.
• Expert in tuning the T-SQL Stored Procedures, SSIS Packages, SSAS cubes, SSRS Reports and deliver high performance and high - integrity business intelligence reports.
• Experience in deploying the SSRS reports into SharePoint integrated mode and wire the report into sepcific business users based on the 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 knowledge 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 the 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.
• Experience with Azure Cloud environment and implementing SQL data warehouse and BI platform in the Azure cloud environment.
• Experience with HDFS master/slave architecture, Hadoop Big Data platform and pipeline concepts Spark and MapReduce algorithms.
• 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, TX

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

Responsibilities:

• Participating in the business requirements gathering and worked with Subject Matter Experts and identified the requirements for Letters-To-Borrowers, INVMGMT (Investor Management), RDO, EXTOUTs, Investor Transfer Balancing, and Repurchase Amortization Processes.
• Worked with data architects and participated in the data modeling, database design, ETL Process and data warehouse design.
• Design ETL Packages with Microsoft SSIS 2016 to pull data from various sources like Oracle, Excel, SQL Server & Flat Files to individual Data marts which ultimately go into Enterprise Data Warehouse.
• Designed an ETL process to load source data from Oracle MDX ACA2 environment to our local SQL Server environment.
• Used the Script Task within a for each loop container to read multiple excel files with multiple sheets in each file and implemented c# code to read each excel file names and sheet names with the data into the database.
• Implemented SSIS Script tasks to access connection managers within the Script Task using c# SqlConnection and used c# methods System.IO etc.
• Implemented raising events with in the Script Task by calling C# methods on the Evnets property of the DTS object (FireError, Fire Information, FireQueryCancel and Fire Warning) to report errors, warnings and other information.
• Prepared the stored procedures to read the data from local source environment, apply the business rules and load the data into target within our local SQL Server environment.
• Designed the SSIS packages, implicitly calling the stored procedures using Execute SQL task, pass the parameter values, execute the rules and export the excel output to shared folder where users can access.
• Heavily used SSIS Script Task, C# coding and ASP.NET coding for the functionalities to convert the Excel .xlsx output to Excel.csv output, read the input from .csv notepad file, EBCDIC file, ASCII notepad files, apply the specific business rules specific to the EXTOUT file types, BULK Insert, implement specific rules with the specific “Delimiter”, and developed a centralized SSIS package which can be used to extract the data from several input file types to SQL Server tables.
• Deployed the SSIS project to Integration Services Catalogue -> SSISDB, parameterized the connection environments using a project parameters, validate and execute before the actual deployment, and schedule this SSIS package execution within the scheduling tool AuyoSys.
• Implemented the SSIS package execution from SSISDB through a Stored Procedure and scheduled these jobs via AutoSys, and export the excel output to the Users Shared folder.
• Worked on support issues on data warehouse data issues, memory issues, production support issues, provide the ad-hoc dashboard environment for the business users.
• Heavily worked on SSRS report performance, store procedure tuning, table partition, MDX based queries, cube partition, T-SQL stored procedure tuning.
• Used the concepts of parameter sniffing, aggregated calculation in stored procedures instead in the report tablix, writing the SQL queries in a way that the indexed columns being utilized, create column-store indexes, and other stored procedure tuning techniques to improve the report performance for the large volume of data.

Environment: MS SQL Server 2016, SSRS 2016, SSAS 2016, SSIS 2016, C#, VB.NET, HTML, XML, Oracle 11g, MS Visual Studio, TFS.

Confidential, 1525 S Belt Line Road, Coppell, TX

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

Responsibilities:

• Participate in the business requirements gathering for the servicing Datamart.
• Analyze the existing data warehouse, existing reports, present reports performance issues, semantics layer requirements, discuss with the architecture team and developed a high level conceptual model for the assigned business area.
• Gather the business requirements for the assigned business areas Borrower, Property and ARM.
• Prepared a “Universe of Fields” excel-sheet from the existing serving department SSRS reports.
• Load the “Universe of Fields” excel-sheet into a SQL table, gather and analyze the list of “Universe of Fields” for the Borrower, Property, ARM, Loan Filters, Loan Dates, Loan Details dimension tables and Loan Fact table.
• Design the dimension tables, follow naming standards, follow the semantic layer requirements, apply column-store indexes for large volume dimension tables and arrange the columns in logical group order.
• Prepared t-SQL stored procedures, load the dimension tables & facts from raw sources, handle the SCD2 scenarios using MERGE statement (INSERT and UPDATES), monitor the changes using HASHKEYs, UPDATE the HASHKEYs.
• Worked on a POC (Proof of Concept) for selecting the right visualization tool on Power BI vs Tableau and developed sample dashboards on both POWER BI and Tableau, developed a presentation on Pros and Cons of POWER BI and Tableau.
• After the business decision to go for the Power BI, developed visually appealing Power BI dashboards.
• Loaded the SQL Server data warehouse using SSIS packages and developed SSAS tabular cubes on top the SQL Server data warehouse, generated SSRS reports pointing to SSAS tabular cubes from SSRS 2016 query designer, wrote drag-drop DAX queries with parameters and generated SSRS DAX datasets and generated reports in SSRS.
• Pinned these SSRS reports to POWER BI tile and developed the POWER BI Dashboards.
• Developed the visually appealing and attracting data visualization dashboards which can enlighten a large audience with some advanced POWER BI features ArcGIS maps for POWER BI, maps, tree-map, sand-dance, waterfall chart, pie chart, Card, KPI, Slicer and different kinds of filters.
• Developed Power BI dashboards sourcing the data from SSAS tabular cubes using live-connection, download and install the POWER BI Data Gateways for SSAS server, add the SSAS server connection string (with Admin account) to powerbi.com, configure SSAS server to live connection and build the real-time Power BI dashboards with live refreshes.

Environment: MS SQL Server 2015, SSRS 2015, SSAS 2015, SSIS 2015, MS Visual Studio 2015, TFS, POWER BI Desktop, POWER BI Service, POWER BI Pro, POWER BI Mobile Apps, Tableau.

Confidential, Plano, TX

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

Responsibilities:

• Participating in the business requirements gathering for Manager Access Review, Compliance Training, Resource Roster, Role Taxonomy and Birthday & Service Anniversary report projects.
• Worked with Subject Matter Experts and identified the requirements.
• Worked with data architects and participated in the data modeling, database design and data warehouse design.
• For one of the projects (Manager Access Review), designed the end-to-end architecture including developing the data model, designed the database and data warehouse, ETL process, SSRS report and SharePoint web dashboard page.
• Designed the ETL database, data marts, Dimensional Model with Fact and Dimension tables.
• Designed the ETL Refresh Data Model master package using SSIS which contains collection of several master packages running several child packages in different stages.
• Converted the ETL process into a 1 package execution which scheduled to run refresh on AutoSYS at the defined schedule to refresh the whole data model of our project.
• Created ETL packages to extract the data from disparate data sources, Microsoft Excel files with data in multiple sheets, .CSV files, Oracle RDR source, Safe net files, corner stone files, SharePoint list etc., apply transformation logic using Containers (For Each loop, Sequence and For Loop), control flow tasks and dataflow tasks and load the data into target tables.
• Created the ETL packages in a way that avoid using the stored procedures and replace the code to in-line SQLs within the execute SQL task and convert the stored procedure code to SQL files and retrieve into SSIS using the “file connection” connection manager. This method is to eliminate the CRQ deployment process of databases changes from DEV to PROD.
• 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.
• As per the project requirement, converted the existing Microstrategy reports into SSRS reports.
• Developed tablix, matrix, graphs, charts, sub reports, parameterized (single value select and multivalued select), drill through, drill up and drill down reports.
• Tuned the SSRS reports using the concepts of parameter sniffing, aggregated calculations in stored procedures instead in the report tablix, sorting in SP instead in tablix, create a separate summary table with 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 the performance for the large volumes of data.
• Used SQL Profiler, Actual and estimated execution plans to troubleshoot the Stored Procedure Table Scan, Index Scan, Index Seek, Key Lookup, loop and Sort etc. issues.
• Defined the both standard and data driven subscriptions and send the SSRS report server links with PDF attachments to the business users on the scheduled subscription times.
• Designed the Share Point landing page for the RTB project, created SharePoint web parts and the linked SSRS reports and provided portal share point presentation to the business users.
• Defined the user role groups and assigned the security for the reports at the report server level.
• Developed the SharePoint landing page dashboard using SharePoint web parts, Report Viewer, Page Viewer, defined the security, granted required access to the required groups and defined standard and data driven subscriptions.

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

Confidential

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

Responsibilities:

• Participating in the business requirements gathering for Manager Access Review, Compliance Training, Resource Roster, Role Taxonomy and Birthday & Service Anniversary report projects.
• Designed the ETL database, data marts, Dimensional Model with Fact and Dimension tables.
• 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.
• Developed dashboards using POWER BI Desktop and POWER BI Service.
• Used data visualization features and developed Graphs, gauges, charts, maps.

Environment: MS SQL Server 2008R2 & 2012, SSRS, SSAS, SSIS 2012, Oracle 11g/10g, MS Visual Studio 2008 & 2010, POWER BI Desktop, POWER BI Service, C#, C++, VB.NET, XML, HDFS.

Confidential, Jacksonville FL

Sr.MS 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 the data into FACT table.
• Wrote relational based Stored Procedures, MDX based Stored Procedures, functions and triggers as per the business requirements.
• Involved in the “Universal Campaign Manager MOLAP Cube” design right from the scratch.
• Experience with SQL Server Integration Services Catalogue (SSIS DB, ETL database, Parameters and environments), SQL Server Security, SQL Server Management and SQL Server Agent.

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

Confidential, VA

MS SQL Server Developer

Responsibilities:

• Working with the Business Analysts and Business Users to identify information needs as per our project requirements.
• Design ETL Packages with 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 the productivity of the 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 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).
• Created complex SSAS cubes named “Reporting Consolidated BIWarehouse” with multiple fact measures groups (Invoices, Opportunities, Pending Sales and GLTransaction) and multiple dimension hierarchies based on the OLAP reporting needs.
• 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, C#, C++, VB.NET, XML, HTML, C.

Confidential, Tonawanda, Buffalo, NY

Oracle PL/SQL Developer

Responsibilities:

• Worked on T-SQL queries, triggers, functions, CTEs and stored procedures.
• Worked on Oracle PL/SQL queries.

Environment: SQL Server 2008, T-SQL, Oracle 11g/10g, PL/SQL, SQL Profiler.