SUMMARY:

• Over 6 years of experience in Microsoft BI Tools (SSIS/SSRS/SSAS) and T - SQL using SQL Server 2012/2014/2016 .
• Proficient in advance features of Oracle 11g for PL/SQL programming like Using Records and Collections, Bulk Bind, Ref. Cursors, Nested tables and Dynamic SQL .
• Experience in developing and debugging Stored Procedures and Triggers.
• Experience in T-SQL (DDL, DML and DCL), Creating, developing new database objects by like Tables, Views, Indexes, Complex stored procedures, function( UDF), cursors, and triggers, locking issues, BCP, common table expressions (CTEs), Backups, Recovery and SQL Server Agent profiler using SQLSERVER 2005/2008 R2/ 2012/2014/2016 .
• Experience in working with Self Service MS BI end user tools such as Excel 2010 (Power pivot) , Performance Point Server (PPS), Power view .
• Proficient Knowledge in dealing with RDBMS including E/R Diagrams, Normalization, Constraints, Joins, Keys and Data Import/Export.
• Expertise in Client-Server application development using Oracle 11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOAD and SQL*LOADER.
• Expert in Designing, Developing, Deploying and Supporting Interactive Tableau Dashboards.
• Experienced in Developing Power BI Reports and Dashboards from multiple data sources using Data Blending. Skilled at building and deploying multi-valued parameterized reports using Power BI, Tableau
• Used tools like MS SQL Profiler, Index Tuning Wizard, Pervasive and Windows performance for monitoring and tuning SQL Server performance.
• Developing SSIS packages for data migration between different sources such as flat file, excel, oracle, Sybase, DB2, MS accessing SQL Server SSIS 2008 R2/2012.
• Excellent hands on experience in ETL (Extraction Transformation and Loading) by extracting large volumes of data from various data sources using SSIS .
• Experience in by using Row Transformations, Block and Unblock Transformations for Performance Tuning in SSIS packages .
• Proficient in using various Informatica transformations like Filter, Expression, Rank, Sorter, Router, Aggregator, Joiner, Lookup, Sequence Generator and Update strategy to design and develop mappings as per the business requirements
• Hands on experience working with Logging, Error handling using Event Handlers pre and post for SSIS Packages.
• Creating SSIS Packages for integrating data using OLE DB connection from sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union .
• Experience in working with Data Cleansing technique in ETL procedures.
• Experience in creating reports such as Parameterized, Cascading, Drill through/Drill down Reports, Conditional, Table, Matrix, Charts, Ad-hoc Specialized in using Relational data warehouse and OLAP Cubes for producing Sub Reports.
• Creating and Deploying SSRS Reports on the portal for user accessibility.
• Experience in implementing surrogate key generation strategy in the Data warehouse.
• Experience in generating On-demand and Scheduled reports for management decision and business analysis by using SSRS.
• Proficient experience in deploying and configuring packages, Error handling and batch logging, check points and troubleshooting Reports using SSRS.
• Experience in developing OLAP Cubes by using SQL Server Analysis Services (SSAS), and defined data sources, data source views, Dimensions, Measures, Hierarchies, Attributes, Calculations using multi-dimensional expression (MDX), Perspectives and Roles.
• Experience in working with Self Service MS BI end user tools such as Excel 2010 (Power pivot) , Performance Point Server (PPS), Power view .
• Experience in performance tuning, processing and deploying the cubes.
• Experience in cube partitioning for better database performance.

TECHNICAL SKILLS:

Databases: MS SQL Server 2016/2014/2012/2008, ORACLE, MS Access.

SQL Server Tools: SSMS, Configuration Manager, Enterprise Manager, Query Analyzer Profiler, DTS, SSIS, SSAS, SSRS, Database Tuning Advisor, Cognos 10 BI tools (Report Studio, Analysis Studio, Query Studio, Cognos Connection), SQL* Plus.

ETL Tools: DTS, SQL Server Integration Services (SSIS).

Reporting Tools: SQL Server Reporting services (SSRS), Power BI, Tableau

RDBMS: SQL Server 2012/2014/2016, Oracle 11g/10/9i.

Programming: T: SQL,PL/SQL, Dynamic SQL, DAX, C# .NET, VB.NET, XML, Java, Hive.

Operating Systems: Windows 7/Vista/XP/2008/2003, Windows 10, UNIX.

PROFESSIONAL EXPERIENCE:

Confidential, Richmond, VA

Sr. SQL BI/SSIS/SSRS/Tableau Developer

Responsibilities:

• Worked as a developer in creating and testing complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Created Grouping, Sorting columns and writing expressions according to the business requirements.
• Worked on performance tuning of Views, CTE’s, stored procedures.
• Data transfers between various servers using BCP, DTS and SSIS.
• Worked extensively on SSIS Packages for extracting the data of the customers from OLTP, transform that data and load it into OLAP
• Extensively used various SSIS objects such as Control Flow Components, Dataflow Components, Connection managers, Logging, Configuration Files etc.
• Extensively used SSIS to move data from heterogeneous data sources to SQL Server
• Created and modified various Stored Procedures used in the application using T-SQL.
• Develop data visualization reports and Tableau Dashboards. Build Dashboards, automated reports and report templates using advanced Tableau functions.
• Created dashboards in tableau using the various sources of data from Excel sheets, Teradata.
• Create and maintain executive dashboards in Tableau to track performance, support decision making and contribute to the continued development of report automation, self-service distribution through SSRS and Tableau.
• Develop SSAS Tabular Model using data from database and using DAX (Data Analysis Expressions) functions for reports and Tabular Models, Creating Relationships, Measures, Partitions, Calculations using DAX and KPIs in SSAS Tabular model
• Used star schema in designing datamarts for creating SSIS ETL packages.
• Used DAX operations that were used to create custom calculations in Power Pivot for Microsoft Excel workbooks and Analysis Services Tabular data warehousing.
• Created SQL Server Reports and developed query for generating drill down and drill through reports using SSRS.
• Identified and worked with Parameters for parameterized reports in SSRS 2012.
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Developed mapplets, reusable transformations, source and target definitions, mappings using Informatica.
• Involved in debugging Informatica mappings, testing of Stored Procedures and Functions, Performance and Unit testing of Informatica sessions, batches and target data.
• Building, publishing customized interactive reports and dashboards, report scheduling using SSRS 2012.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Deployed the generated reports directly on the client’s workstation.
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes.
• Used SSIS 2012 to create ETL packages to validate, extract, transform and load data to Data Warehouse databases.
• Used For-Each Loop Container, Sequence Container, Script task, Expressions, Execute SQL task, Variables, Send Mail Task, Package Execution task to achieve business needs
• Used Power BI Desktop to develop data analysis multiple data sources to visualize the reports.
• Used Power BI Custom visuals like Power KPI, Chiclet Slicer, InfoGraphic Designer, Spline Chart to make the visuals look and understand better.
• Embedded Power BI reports on SharePoint portal page and managed access of reports and data for individual users using Roles.
• Responsible for creating and changing the data visualizations in Power BI reports and Dashboards on client requests.
• Deployed Dashboards, Reports and Data sources in the Power BI Service .

Environment: MS SQL Server 2016/2012 Enterprise Edition, SQL Server Integration Services 2015/2012, MS SQL Server Reporting Services 2015/2012, SQL Server Analysis Services 2015/2012, Power BI, Tableau 10.0, Tableau Server, Windows 10.

Confidential, Baltimore, MD

SQL/ETL/Tableau Developer

Responsibilities:

• Responsible for gathering/refining requirements from the business for developing dashboards.
• Worked on Software life cycle development (SDLC) involving in all stages of development.
• Worked as a developer in creating complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Created Grouping, Sorting columns and writing expressions according to the business requirements.
• Worked on Views, cursors, CTE’s, schemas, permissions and performance issues with client/server database design.
• Created Power BI Dashboards and integrated them to share point.
• DAX operations were used to create custom calculations in Power Pivot for Microsoft Excel workbooks and Analysis Services Tabular data warehousing.
• Used star schema in designing cubes for creating SSAS packages.
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
• Involved in Tabular Data warehouse and DAX operations for SSAS 2012.
• Created bottom count, top count, cross join, non-ascendants and log MDX queries for creating Calculations and KPI’s on a cube.
• Developed Multi-Dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS).
• Created SQL Server Reports and developed query for generating drill down and drill through reports using SSRS.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Identified and worked with Parameters for parameterized reports in SSRS 2012.
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Building, publishing customized interactive reports and dashboards, report scheduling using SSRS 2016.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Implemented and enhanced existing reports like Group By, Drilldown, Drill Through, Sub-Reports, List, Tabular, Matrix, Navigation Reports, Standard Parameter, Cascading Parameter and Multivalve Parameters.
• Deployed the generated reports directly on the client’s workstation.
• Worked with latest ASP.NET MVC framework on visual studio 2012.
• Developed the application using C#, ASP.NET , and JavaScript with SQL Server as the back end.
• Implemented .NET classes for Business logic Layer using C#.
• Extensively used ASP.NET, C#.NET,VB.NET Validation Controls and JavaScript for client side validations in the Web Pages.

Environment: MS SQL Server 2012 Enterprise Edition, MS SQL Server Reporting Services, SQL Server Analysis Services, Power BI, Windows Server 2007, ASP.NET.

Confidential

SQL/ETL/SSIS/SSRS Developer

Responsibilities:

• Responsible for gathering/refining requirements from the customer for developing reports.
• Worked on Software life cycle development (SDLC) involving in all stages of development.
• Involved in working with Server side State Management Techniques like Session state to maintain state between ASP.NET pages.
• Implemented AJAX Update Panel with the Script Manager Control for group by option to enable partial page rendering
• Worked as a developer in creating complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Created Grouping, Sorting columns and writing expressions according to the business requirements.
• Transferred the data using SSIS packages.
• Worked on Views, cursors, CTE’s, schemas, permissions and performance issues with client/server database design.
• Worked in Extracting, Transforming and Loading (ETL) data from Sybase database to MS SQL Server by using SSIS 2012.
• Used SSIS to create ETL packages to validate, extract, transform and load data to Data Warehouse databases.
• Worked with EDI transactions like 270, 271, 276, 277, 835 and 837I/P/D.
• Created Power BI Dashboards (Power View, Power Query, Power Pivot, Power Maps) and integrated them to share point.
• DAX operations were used to create custom calculations in Power Pivot for Microsoft Excel workbooks and Analysis Services Tabular data warehousing.
• Used star and snow flake schema in designing cubes for creating SSAS packages.
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
• Involved in Tabular Data warehouse and DAX operations for SSAS 2012 and 2008 OLAP databases.
• Created bottom count, top count, cross join, non-ascendants and log MDX queries for creating Calculations and KPI’s on a cube.
• Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes.
• Developed Multi-Dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS).
• Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation. Developed, monitored and deployed SSIS packages.
• Supported development of Access applications for product management group, involving analysis, design, coding, and testing of components.
• Migrated old data from MS Access and Excel into SQL Server 2014 using SSIS Packages in Business Intelligence Development Studio.
• Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Lookup.
• Used SSIS 2012 to create ETL packages to validate, extract, transform and load data to Data Warehouse databases.
• Created SSIS packages to Export data from text file to SQL Server Database.
• Implemented SSIS data transformation scripts, created maintenance procedures and provided data integrity strategies.
• Administered and enhanced SQL Server Integration Services (SSIS) data loads.
• Created SQL Server Reports and developed query for generating drill down and drill through reports using SSRS.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Identified and worked with Parameters for parameterized reports in SSRS 2012.
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Implemented and enhanced existing reports like Group By, Drilldown, Drill Through, Sub-Reports, List, Tabular, Matrix, Navigation Reports, Standard Parameter, Cascading Parameter and Multivalve Parameters.
• Deployed the generated reports directly on the client’s workstation.
• Managed index, statistics and optimizing queries by using execution plan for tuning the database.
• Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler.

Environment: MS SQL Server 2012/2014 Enterprise Edition, MS SQL Server Reporting Services 2012/2014, SSIS 2010/2012, SSAS, Power BI, Pervasive, Windows Server 2007,Tableau.

Confidential

Jr. SQL BI Developer

Responsibilities:

• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple homogeneous and heterogeneous information sources (CSV, Excel, Sybase, DB2 and SQL 2014).
• Worked with latest ASP.NET MVC framework on visual studio 2012.
• Developed the application using C#, ASP.NET , and JavaScript with SQL Server as the back end.
• Implemented .NET classes for Business logic Layer using C#.
• Created Configurations to make package portable and created Event handlers for handling package error.
• Used For-Each Loop Container, Sequence Container, Script task, Expressions, Execute SQL task, Variables, Send Mail Task, Package Execution task to achieve business needs.
• Created SSIS packages to Extract, Transform and load data using different transformations such as Lookup, Used Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension, Merge Join and Union all in transformation of SSIS Packages.
• Created and modified various Stored Procedures used in the application using T-SQL.
• Designed Cubes with star schema and snow flake schema in SSAS and Executing Analysis Services Processing Task in SSIS for processing cubes in packages.
• Scheduled and maintain packages by daily, weekly and monthly using SQL Server Agent in SSMS.
• Developed complex Stored Procedures to generate various Drill-through reports, Parameterized reports, Tabular reports, Matrix reports and linked reports using SSRS.
• Created Project Expense Statements in all Data marts and other Financial Reports using SSRS.
• Define reporting requirements and gather data, using MS Access, and MS PowerPoint to create and maintain management reports, also export data from MS access to MS Excel to create Pivot table for management do more analysis.
• Developed yearly and quarterly company expense reports.
• Responsible for Deployment of the report using SSRS and used Report subscription (Data Driven and Email) to publish reports.
• Tuning SQL query for better performance using SQL Profiler.
• Actively supported business users for change requests.
• DAX operations were used to create custom calculations in Power Pivot for Microsoft Excel workbooks and Analysis Services tabular data warehousing.
• Created bottom count, top count, cross join, non ascendants and log MDX queries for creating Calculations and KPI’s on a cube.
• Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes.
• Developed Multi-Dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS).

Environment: SQL Server 2012/2014, Enterprise Edition, SQL, Enterprise manager, SSRS, SSIS, SSAS, Spotlight, MS Access 2000 & Windows 2003/2000 platform, ASP.NET.