PROFESSIONAL SUMMARY:

• Over 6 years of Experience in Data Warehousing and Business Intelligence applications design, development, Maintenance of Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analytical Services (SSAS).
• Experienced in logical and physical database design and development, normalization, data modeling and SQL Server Enterprise Manager/SQL Server Management Studio.
• Experience on performing Data loads to Dimension, Fact tables, Data warehouse, Data marts, and OLAP cubes.
• Expertise in MDX to create Named Sets, Named Members, Calculated Members and other calculations.
• Experience in managing Alerts, Operators and Scheduled Jobs through SQL Server Agent.
• Hands on experience on different version of QlikView 10/11/12 suite of Products. ETL, OLAP Experience Integration Services (SSIS):
• Expertise in configuring and creating SSIS solutions for ETL and Business Intelligence Process for Data Integration and Migration services.
• Experience on Merging data from various Heterogeneous Data sources, Populating Dimension and Fact tables in Data warehouses and Data Marts, Cleaning and Standardizing data loaded into OLTP and OLAP databases using SSIS.
• Expertise in creating and managing Package Configurations, Logging, System and User - defined Variables for SSIS Packages.
• Experience in managing and automating Control flow, Data flow, Events and Logging programmatically using Microsoft .NET framework for SSIS packages.
• Extensive knowledge of using System Variables and creating User-Defined Variables for SSIS Packages and Project Configuration wizard to configure SSIS Projects.
• Expertise in Cozy Roc Parallel Loop Process for Optimizing the Run time of SSIS Job. Reporting Services (SSRS):
• Extensive knowledge of Designing, Developing and deploying various kinds of reports using SSRS using relational and multidimensional data.
• Experience in creating various Parameterized, Cascaded, Linked, Drill-through and Drill-down reports. Analysis Services (SSAS):
• Expertise in upgrading or migrating Analysis Services.
• Proficient in building Star schema and Snow Flake schema depending on business requirements.
• Experience on working with Multidimensional Expressions (MDX).
• Expertise in Configuring and managing data sources, data source views, cubes, dimensions, mining structures, roles and creating hierarchies with SSAS.
• Microsoft certified Power Bi Developer.
• Worked on Data Analysis Expressions (DAX) for accessing data directly from tabular SSAS database.
• Did lab work on designs and process flow on to how standardize Power BI Dashboards to meet the requirements of the business.
• Hands on calculated columns and measures using DAX in Power BI based on report requirements.
• Created reports using visualizations such as Bar chart, Clustered Column Chart, Waterfall Chart, Gauge, Pie Chart, Tree map etc. in Power BI.
• Used several types of visualization Like (Stacked bar Chart, Clustered bar Chart, Scatter Chart, Pie Chart, Donut Chart, Line & Clustered Column Chart, Map, Slicer, Time Brush etc.).

TECHNICAL SKILLS:

Operating Systems: Windows (All Versions)Unix, Linux.

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

Database Design Tools and Data Modeling: Star Schema, Snow Flake Schema, Dimension Data Modelling, Fact Tables, Dimension Tables, Normalization, Denormalization.

Modelling Techniques/Tools: Flow Charts, Sequence Diagrams, Activity Diagrams, Use case diagrams, Data Modelling, ER Diagrams

BI Tools: SQL, SQL Server Integration Services (SSIS 2012), SQL Server Analytical Services (SSAS 2012), Visual Studio, Power BI.

Languages: C, XML,.Net,Core Java.

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

Sr. SQL BI Developer

Responsibilities:

• Designed high level ETL/SSIS architecture for overall data transfer from the OLTP to Data warehouse with SSIS and prepared ETL/SSIS mapping processes and maintained the mapping documents.
• Created numerous efficient Stored Procedures to perform data cleansing and loading task when data is loaded into staging area.
• Well experienced in design, development & Administration of QlikView from various data sources.
• Strong understanding of Star Schema, Snow flake Schema, Fact and Dimensional tables, Section Access, Set Analysis in QlikView and DW concepts.
• Experience with QlikView sheet objects including Pivot, List, Multi box, multiple charts types, Trends, KPI's, custom requests for Excel Export, and Fast Change and objects for Management Dashboard reporting.
• Developed Custom dashboards/reports using QlikView.
• Experience in QlikView Functions (Date and Time, Keep, Join, Apply Map, String and input Fields etc).
• Created SSIS packages for Dynamic ETL/SSIS flow to validate, extract, transform and load data into database using Lookup, Fuzzy Lookup, Derived Column, Conditional Split, Slowly Changing Dimension (SCD) to perform Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Involved in Data Extraction, Transforming and Loading (ETL) using SSIS, BCP, Bulk Insert, DTS, and XML between Oracle, DB2, and Access to MS SQL server database.
• Developed SSIS packages for File Transfer from one location to the other using FTP task.
• Involved in building SSIS packages (.dtsx) involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server.
• Created SSIS Packages to integrate data coming from Text files and Excel files.
• Migrated old data from MS Access into SQL Server 2008 using SSIS Packages in Business Intelligence Development Studio.
• Designed and Developed Cozy Roc Parallel loop for the Existing Nightly Process SSIS Projects to optimize the runtime to half of it pervious runtime.
• Rewritten the stored procedures for the ETL processes, while adding the cozy roc parallel loop Function in SSIS.
• Involved in creating jobs Alerts, Alerts, SQL Mail Agent, and Scheduling SSIS Packages using SQL Server Agent job.
• Used VB.Net and C# script task to download the flat files from FTP to Shared Folder and Tracked Different Error scenarios and logging for SSIS .
• Used SSRS to Create Tabular, Matrix, and Drill down, Drill through reports, Summary Reports, and Parameterized Reports, Charts and graphs as per customer requirements.
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Build regular ad-hoc reports using SSRS SQL Server Reporting Services with help of various tools such as Group by , Drill-down, Cascading, Summarized , Matrix, Map and Cross-join
• Created Advanced Reporting Services Programming Using the Reporting Services Web Service.
• Created Ad-Hoc Reporting with Report Builder and Programming Reporting Services .
• To analyze performance, used: Calculation, KPI, Derived column and hierarchy. Also, created MDX Multidimensional Expressions scripts and built reports on top of cubes.
• The created cubes were analyzed using MDX and DAX . I also analyzed and modified data using Power Pivot, created pivot tables and charts for presentation and decision making purposes.
• Integrated custom visuals based on business requirements using Power BI desktop .
• Provided maintenance and development of bugs fixes for the existing and new Power BI reports.
• Installed and configured Enterprise gateway and Personal gateway in Power BI service.
• Scheduled Automatic refresh and scheduling refresh in Power BI service.
• Create reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector.
• Developed and maintained multiple Power BI dashboards/reports and content packs.
• Responsible for building Power BI Dashboards using Tabular and Multi-Dimensional Models. Design and model data sets with Power BI desktop based on measure and dimension requested by customer and dashboard needs.
• Provided production support on the existing Power BI Dashboards and other ETL processes to resolve the issues quickly and published Power BI Desktop reports created in Report View to the Power BI service.
• Published reports to Azure based Power BI services (Pro) and schedule subscription and various sharing options (workspace, content pack, and Apps).
• Well versed in data extraction (Azure blob and Web services) and data ingestion for raw data to clean, process and to conduct trend and sentimental analysis.
• Expertise in using Cloud based managed services for data warehousing/analytics in Microsoft Azure (Azure Data Lake Analytics, Azure Data Lake Storage, Azure Data Factory, Azure Table Storage, U-SQL, Stream Analytics, HDInsight, etc.)

Environment: SQL Server 2014, Microsoft Visual Studio 2012, Windows 7, MS Office, Windows Server, Dax, SQL Server Integrated Services SSIS, SQL Server Analysis Services SSAS, SQL Server Reporting Services SSRS, SharePoint, Oracle 8, Tableau, Power pivot, Power view, Power BI, Python.

Confidential, Nashville, TN

Jr.BI Developer

Responsibilities:

• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Created Complex ETL Packages using SSIS which upserts data from staging table to database tables.
• Used VB.Net and C# script task to download the flat files from FTP to Shared Folder.
• Designed, Created and Tested SSIS packages for data transformation, cleansing, caching, aggregation, staging , backup, update and transfer in support for the main Project.
• Worked with SSIS Variables , Scripting , event-handlers, Package configurations and deployment to production.
• Created 3 Tier architecture to load the data into Qlikview application.
• Eliminated synthetic keys using concatenation and/or Qualify based on the nature of synthetic keys.
• Developed QlikView Dashboard using Drill Down & Cyclic Grouping in charts, Pie chart, Line charts Scatter chart, Sliders, KPI's and Date Island for a self-service.
• Worked closely with Business to design, develop and enhance the Qlikview Dashboards.
• Developed SSIS Packages to Consolidate date from various data Sources and Data loads from various types of sources files ( EXCEL, Access, Flat files, CSVs ) and converted to SQL reporting.
• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers, and Fuzzy Lookups
• Implemented Custom Logging , Auditing and custom Email notifications using SSIS.
• Created sophisticated SQL Server database to responsively handle complex queries (T-SQL, DTS, triggers, stored procedures, functions, and optimization) and .NET data access components.
• Involved in scheduling , creating snapshots and subscriptions for the reports using SSRS .
• Wrote T-SQL Stored Procedures, Inline Queries for SSRS Reports Shared Dataset and Embedded Dataset with Query Parameters. Deployed and Managed SSRS Reports.
• Designed and developed the reports according to the requirements using Tableau and Power Map .
• Extensively worked on reports using SQL Server Reporting Services (SSRS 2008, 2012) and creating various types of reports like drill down, Parameterized, Cascading, Table, Matrix, Chart Sub Reports and Dashboards using Sparkline, Gauge and Bars etc.
• Scheduled the reports to run on daily, weekly basis in the report manager. Create reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector.
• Provided production support on the existing Power BI Dashboards and other ETL processes to resolve the issues quickly and published Power BI Desktop reports created in Report View to the Power BI service .
• Deployed and uploaded the SSRS reports to SharePoint Server for the end users to look at them.
• Involved in Designing, Building the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS) for analyzing purpose.
• Managed Power BI Portal - Data refreshes / User management and set up gateway data refresh.
• Published reports to Azure based Power Bi services (Pro) and schedule subscription and various sharing options (workspace, content pack, and Apps).

Environment: MS Visio 2008, SQL Server 2012, Microsoft Visual Studio 2010, Windows 7, SQL Server Integrated Services (SSIS) , SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS) , Oracle 8, Power pivot, Power view, Power BI .

Confidential, Dover, NH

Jr.BI Developer

Responsibilities:

• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Created Complex ETL Packages using SSIS which upserts data from staging table to database tables.
• Used VB.Net and C# script task to download the flat files from FTP to Shared Folder.
• Designed, Created and Tested SSIS packages for data transformation, cleansing, caching, aggregation, staging , backup, update and transfer in support for the main Project.
• Worked with SSIS Variables , Scripting , event-handlers, Package configurations and deployment to production.
• Developed SSIS Packages to Consolidate date from various data Sources and Data loads from various types of sources files ( EXCEL, Access, Flat files, CSVs ) and converted to SQL reporting.
• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers, and Fuzzy Lookups
• Implemented Custom Logging , Auditing and custom Email notifications using SSIS.
• Created sophisticated SQL Server database to responsively handle complex queries (T-SQL, DTS, triggers, stored procedures, functions, and optimization) and .NET data access components.
• Involved in scheduling , creating snapshots and subscriptions for the reports using SSRS .
• Developed Dashboard showcasing different KPI's involving QlikView objects like Containers, Charts, Text objects, List boxes, Buttons, Bookmarks.
• Designed and developed QlikView(TM) desktop applications and server-based QlikView (TM) dashboards from scratch to support BI initiatives.
• Wrote T-SQL Stored Procedures, Inline Queries for SSRS Reports Shared Dataset and Embedded Dataset with Query Parameters. Deployed and Managed SSRS Reports.
• Designed and developed the reports according to the requirements using Tableau and Power Map .
• Extensively worked on reports using SQL Server Reporting Services (SSRS 2008, 2012) and creating various types of reports like drill down, Parameterized, Cascading, Table, Matrix, Chart Sub Reports and Dashboards using Sparkline, Gauge and Bars etc.
• Scheduled the reports to run on daily, weekly basis in the report manager. Create reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector.
• Provided production support on the existing Power BI Dashboards and other ETL processes to resolve the issues quickly and published Power BI Desktop reports created in Report View to the Power BI service .
• Deployed and uploaded the SSRS reports to SharePoint Server for the end users to look at them.
• Involved in Designing, Building the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS) for analyzing purpose.

Environment: MS Visio 2008, SQL Server 2012, Microsoft Visual Studio 2010, Windows 7, SQL Server Integrated Services (SSIS) , SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS) , Oracle 8, Tableau, Power pivot, Power view, Power BI .

Confidential, Grand Haven, MI

Jr.SQL/BI Developer

Responsibilities:

• Gathered business requirements, defined and designed the data sources, data flows, data quality analysis, worked in conjunction with the data warehouse architect on the development of logical data models.
• Created various Stored Procedures, triggers, cursors, tables, views, joins and statements for applications. Developed complex T-SQL code for the application.
• Created SSIS process design architecting the flow of data from various sources to target.
• Created SSIS packages to Extract, Transform and load data using different transformations such as Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation, For-Each loop container, Merge Join and Union all.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Created Complex ETL Packages using SSIS which upserts data from staging table to database tables.
• Used VB.Net and C# script task to download the flat files from FTP to Shared Folder.
• Designed, Created and Tested SSIS packages for data transformation, cleansing, caching, aggregation, staging , backup, update and transfer in support for the main Project.
• Worked with SSIS Variables , Scripting , event-handlers, Package configurations and deployment to production.
• Developed SSIS Packages to Consolidate date from various data Sources and Data loads from various types of sources files ( EXCEL, Access, Flat files, CSVs ) and converted to SQL reporting.
• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers, and Fuzzy Lookups
• Implemented Custom Logging , Auditing and custom Email notifications using SSIS.
• Worked on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SSIS .
• Extensively imported data from various sources such as MS Excel and MS Access using Import Export Wizard and using SSIS.
• Created ETL packages using SSIS to move data from various heterogeneous data sources.
• Created logs for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Implemented error handling and roll back process in ETL load.
• Configured SSIS packages using Package configuration wizard to allow packages run on different environments.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases.
• Used XML and environmental variables in the package configuration for Deploying SSIS packages.
• Created Cross-Tabs, Drill-down and Sub-Reports using SSRS. Deployed RDLs to Report Server.
• Created Jobs Performance report that queries system tables to track the duration of each job and weekly-average duration using SSRS.
• Created reports in SSRS using different types of properties like chart controls, filters, Interactive Sorting, SQL parameters etc.
• Involved in Designing, Building the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS) for analyzing purpose.
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).

Environment: MS SQL Server, SSIS, SSRS , SSAS, Business Intelligence Studio, Visual Studio 2008/2005.

Confidential

Jr. SQL Developer

Responsibilities:

• Extensive participation in logical and physical database design and normalizing the database to accommodate possible changes in OLTP & created data flow diagrams and enforced all referential integrity constraints.
• Created Stored Procedures and functions.
• Created and Implemented triggers in T-SQL to facilitate consistent data entry into the databases.
• Created new database objects like tables, synonyms, Packages, Triggers, Indexes and Views using T-SQL in Development, Test and Production environment for SQL Server.
• Created complex stored procedures and functions to support efficient data storage and manipulation as well as database Replication.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
• Designed and implemented data access stored procedures and Triggers for automating tasks.
• Involved in performance tuning using indexing (Clustered Index, Non Clustered index) tables.
• Transforming and validating data using SSIS Transformations like Conditional Split, Lookup, Merge Join and Sort and Derived Column for unstructured and redundant data.
• Created SSIS packages for transferring the data from different systems such as SQL/Oracle server, Flat Files, CSV Files and xml files.
• Involved in Job scheduling and alerts.

Environment: Microsoft SQL Server, Business Intelligence Development Studio (BIDS) 2008, SSIS, SSRS, Windows Server.

Confidential

Jr. SQL Developer

Responsibilities:

• Extensively involved in designing the SSIS packages to export data of flat file source to SQL Server database.
• Involved in creating SSIS jobs to automate the reports generation, cube refresh packages.
• Involved in creating Tablix Reports, Matrix Reports, Parameterized Reports, Sub reports using SQL Server Reporting Services.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Created Drill-down, Drill-through and Sub-Report using RDL. Promoted RDLs to Reporting Service Server.
• Developed the chart type, Tablix, matrix reports in SSRS (SQL Server Reporting Services) like enrollment status, Financial Aid, Degree Objective from the OLAP system.
• Wrote the expressions in SSRS wherever necessary.
• Created reports with different features like drill through capabilities, jump to another report, use of pie charts and bar charts.
• Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.
• Developed data model based on the BA's and the reporting Team using SSAS, SSRS.
• Created derived columns on the final fact and dimension tables as per the business requirements.
• Understanding the OLAP processing for changing and maintaining multi-dimensional data warehousing, Optimizing Dimensions, Hierarchies and adding aggregations to the OLAP Cubes.
• Played a major role in production support of SSAS (cube refresh), SSIS jobs.

Environment: SQL Server, T-SQL, Oracle, PL/SQL, SSIS, SSRS, Visual Studio, SQL Server Data Tools, SQL Server Management Studio, TOAD.