SUMMARY

• 10 years of strong IT industry experience as a MS SQL Server 2014/ 2012/ 2008 R2/ 2008/ 2005, Data Warehouse Developer/BI Developer in various domains. Maintained positive communications and working relationship at all levels.
• Worked on automating the SSRSwork flows as per the day to day transactions.
• Experience in developing the applications usingT - SQL Programming (DDL, DML, and DCL).
• Conversant with various phases of Software Development life cycle (SDLC) including development, designing, analysis, coding, testing and implementation.
• Proficient with SQL Analysis Services 2008/2012 such as, building multi-dimensional cubes, Dimensions, fact tables, Hierarchies, levels, roles, performed drill-up, drill-down, and drill-through and applying cube security.
• Wrote Multidimensional Expression (MDX) queries to extract data from cubes.
• Extensive experience in MS SQL Server 2012/2008R 2/2008/2005/2000, BI tools like SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS).
• Highly Proficient in developing SSIS Packages to Extract, Transform and Load (ETL)/DTS data into the Data warehouse from Heterogeneous data sources such as Oracle, DB2, MS Excel, MS Access, CSV, Oracle, flat file.
• Proficient in creating, configuring and fine-tuning ETL workflows designed in DTS and MS SQL Server Integration Services (SSIS).
• Proficient in assortment of technologies including PowerShell, Windows OS, Mysql.
• Proficient in full life cycle design and development of Business Objects reporting Applications.
• Strong understanding ofdata warehousing concepts, OLTP, OLAP, Visual studio in CSharp, Normalization, Star and Snow Flakedata models.
• Worked on non-relational database.
• Environment Windows OS Professional, Visual Studio 2010, 2013 with bundled resources and tools, Team Foundation Server, scripting languages including python & PowerShell.
• Developed OLAP cubes using SSAS (SQL Server Analysis Services) and calculate the metrics that were revealed in the functional analysis.
• Expert in writing parameterized queries for generating tabular reports, formatting report layout, sub-reports using global variables, subtotals, expressions, functions, sorting the data, defining data sources for the reports using SSRS.

TECHNICAL SKILLS

Languages: SQL, MS SQL, Transact SQL, C, C#, Java, HTML 4.0,CSharp, Embedded SQL, PL/SQL, XML.

Databases: SQL Server 2012/2008 R 2/2008/20005, Oracle 9i/8.x, DB2 MS Access

Reporting Tools: SQL Server Reporting Service (SSRS), Tableau,COGNOS, Crystal Reports XI/10/9, Non-relational database, Power BI, Azure Data Factory.

ETL Tools: SSIS (SQL Server Integration Services), DTS (Data Transformation Services), Import Export Data, Bulk Copy Program (BCP), Informatica 8.6.1, BIDS.

Other Software: MS Office- 2010/2007, Adobe Professional, Windows OS.

Operating Systems: Windows OS/2003/XP, Agile

Database Tools: SQL Query Analyzer, SQL Enterprise Manager, Management Studio, SQL Server 2008 Query Editor, SQL Server Analysis Services (SSAS), TOAD

Methodologies: Logical and Physical Database Design, non-relational database, Database Design and Normalization, Data Modeling.

PROFESSIONAL EXPERIENCE

Confidential

Power BI Developer

Responsibilities:

• Developed the Azure ADFPipelines, which will take the data from various sources like Oracle 8i, Flat files, Excel and XML files and will perform the appropriate transformations over the data and will load the data onto targeted SQL Server Data mart.
• Worked with Data conversions, Merge Join tasks, and look up transformations, Execute SQL Task, OLEDB Command Task and Sequence containers and for Each Loop containers in the package development.
• Designing the modelling in Power BI.Involved in developing reports and dashboards in Power BI.
• Involved in creating data visualizations like Clustered Column Chart, Donut Chart, Line Chart, Slicer, Gauge Visualization etc. with Power BI.
• Create the Calculated columns and measures with the use of DAX Expressions.
• Involved in effectively used data blending, filters, actions feature in Power BI.
• Embedding Power BI reports to webpages. Created the Row Level Security in Power BI.
• Create the Schedule refresh for Datasets in Power BI Pro version.
• Interacting with Client to get requirements.
• Developed the SQL Agent Jobs in order to schedule the ETL packages on a scheduled basis.
• Managed the Reports by providing the access permissions to various report users like Admin/Report users/Browser Etc.

Environment: MS SQL Server 2014 R2/2014, Power BI, Azure Data Factory, T-SQL, MS Access, Windows Server 2008.

Confidential

ETL Developer

Responsibilities:

• Participated in gathering Business Requirements and System Specification from system users.
• Created and executed SQL Server Integration Service (SSIS) packages to populate data from the various data sources into the data warehouse
• Created SSIS Packages using SSIS Designer for importing heterogeneous data from OLE DB Source, Excel Spreadsheet, text files into Enterprise Data Warehouse.
• Various ETL Transformation tools were used for Control Flow and Data Flow tasks
• Experienced in creating reports (SSRS) in Drill mode using tables, matrix and charts in SQL SERVER 2008
• Created new database objects like Sequences, Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2000.
• Designed and implemented Parameterizedand cascading parameterized reports using SSRS
• Involved in implementing package configuration in SSIS packages that allowed transferring packages from one environment to another environment
• Involved in scheduling SSIS packages to run on routine basis and monitor the error log for any errors.
• Involved in C# coding developing SSIS Packages.
• Involved in writing C# scripts using script task transformation to create multiple reports based on providence Insurance client's information.
• Created SSIS Packages using Script Task and various Shell scripts, C#, VB script in BIDS.
• 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.
• Backing up, restoring system & other databases as per requirements, and also scheduled those backups.
• Developing stored procedures, triggers, views, and adding/changing tables for data load and transformation, and data extraction.
• Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
• Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.

Environment: MS SQL Server 2014 R2/2014, Visul studio Management Studio 2008, SSIS, SSRS, T-SQL, MS Access, Windows Server 2008.

Confidential, Charlotte NC

Sr. SQL BI/SSIS/SSRS Developer

Responsibilities:

• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Worked with Deploying the SSIS packages using SQL Server package deployment wizard to deploy the packages on the production server.
• Developed the SQL Agent Jobs in order to schedule the ETL packages on a scheduled basis.
• Trained the Line of Business people.
• Designed and developed packages for data warehouse using Integration services (SSIS) in BIDS.
• Planned and developed account migration process for a multi-domain e-mail migration from internal and external AD domains running Exchange 2003/2010 to Google Apps Mail. Migration scripts developed with PowerShell.
• Experience in Data migration from heterogeneous database like Excel, MS Access, Oracle, DB2 to MS SQL Server by using Import Export Wizard, DTS and SSIS.
• Involved in claim adjudication process of facets application.
• Created SSRSReport Model Projects in BI studio and created, modified and managed various report models with multiple model objects, source fields and expressions.
• Worked on different Tools in MS e.g.Powershell.
• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Update SPs / CUs using PowerShell scripts and troubleshoot Exchange 2010 related issues in server 2012 R2 / 2008 R2 virtualized environment as well as granular level restores when required.
• Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent in BIDS.
• Worked in Agile Scrum Methodology with daily stand up meetings and great knowledge in TFS (Team Foundation Server) 2010.
• Created OLAP models based on Dimensions and Facts for efficient loads of data.

Environment: MS SQL Server 2008 R2/2008, Visul studio Management Studio 2008, SSIS, SSRS T-SQL, MS Access, Windows Server 2008.

Confidential, Austin TX

Sr. SQL BI/SSIS/SSRS Developer

Responsibilities:

• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports.
• Writing queries to generate reports for analysis of data using SQL Server Reporting Services (SSRS), Report Builder.
• Generated Reports using Global Variables, Expressions and Functions for the reports in SSRS.
• Created SQL Scripts for data loads and upgrades for data migrations and data validations.
• Developed and scheduled DTS packages for each system Interface using SQL code in combination with VB ActiveX scripts and built-in DTS transformations.
• Created Indexes, Views, Triggers, Functions, and appropriate Stored Procedures to facilitate efficient data manipulation and Data Usage during MySQL and Tableau.
• Worked with T-SQL to create Tables, Views, and stored Procedures.
• Designed and created SQL extracts, supporting SSAS, Power BI, Tableau and other visualization tools reporting applications.
• Reviewed many T-SQL issues using management studio for better performance.
• Involved in implementing package configuration in SSIS packages that allowed transferring packages from one environment to other.
• Involved in C# coding developing SSIS Packages. Created SQL Scripts for data loads and upgrades for data migrations and data validations.
• Experience in training developers and advising technical groups on reporting best practices.
• Flexible and versatile to adapt to any new environment with a strong desire to keep pace with latest technologies.
• Created SSRSReport Model Projects in BI studio and created, modified and managed various report models with multiple model objects, source fields and expressions.
• Experience in Visual studio in Csharp db.
• Excellent problem solving, communication, analytical, interpersonal skills and ability to perform independently or as part of a team.
• Provided data analysis, verification, and load mapping of customer financial and clinical healthcare data related to medical, RX, eligibility, biometric and other types of data files using QlikView, Tableau
• Mapped raw customer financial and clinical healthcare data into standardized format to identify current and potential customers using Power BI and Tableau.

Environment: MS SQL Server 2008 R2/2008, Visul studio Management Studio 2008, SSIS, SSRS, T-SQL, MS Access, Windows Server 2008.

Confidential, North Carolina

Sr. SQL BI/SSIS/SSRS Developer

Responsibilities:

• Designed and developed packages for data warehouse using Integration services (SSIS) in BIDS.
• Hands-on experience on the various facets of the Hyperion Performance Suite.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2016.
• Managed the Reports by providing the access permissions to various report users like Admin/Report users/Browser Etc.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Used various sources to pull data into Power BI such as SQL Server, EC2
• Hands-on with T-SQL and Tableau for DW, data modeling, dashboards and reports to produce meaningful insights.
• Worked with installing, designing and managing MS SQL Server 2016.
• Experience in Data migration from heterogeneous database like Excel, MS Access, Oracle, DB2 to MS SQL Server by using Import Export Wizard, DTS and SSIS.
• Designed and developed Tableau graphical visualization solutions with business requirement documents and wireframes.
• Created reports using MS SQL Server Reporting Service (SSRS), Power BI and Power BI 2.0 as per client request
• Used excel sheets, Google Sheets, flat files, CSV files to generate Tableau ad-hoc reports and ETL data cubes
• 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.
• Involved with Transact SQL (T-SQL) Coding, writing queries, cursors, functions, views, & triggers.

Environment: SQL Server 2014/2012/2008 R2 Enterprise Edition,Tableau, Hyperion, FACETS, DTS packages, Visual studio 2012/2010, SSAS, SSIS, T-SQL, SSRS, ERWIN, Oracle 9i/10g, Agile.

Confidential, Baltimore, MD

SQL BI Developer

Responsibilities:

• Involved in creating SSRS reports from Different Databases like Oracle, Hyperion and SQL Server.
• Involved in Database modeling, ETL and creation of analytical processes, responsible for translating the Business requirements into technical specifications in business intelligence development studio(BIDS).
• Worked on configuring and deploying SSRS reports onto Microsoft Office SharePoint Server.
• Experience of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables using MS Analysis Services.
• Experience in using XMLA protocol for SQL Server Analysis Services 2008 for interaction between client application and instance of Analysis Services.
• Created financial reports utilizing SSRS, Excel, Google Sheets and deployed them on SharePoint Server.
• Documented design and development works for creating views, stored procedures or SSIS packages pertaining to Izenda or Tableau reports deployment, uploaded reports into SharePoint site.
• Worked with SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models.
• Deployed SSRS reports in native and SharePoint mode.
• Developed new Request for Quote System from old Access system by utilizing SharePoint, custom C# code for querying Exchange and automating processing excel documents.
• Designed & Developed multi-threaded SQL CLR SP's Services to execute Data Load Task and basket creation process.
• Enhanced the functionality in database and data warehousing concepts (OLAP, OLTP) Cube by creating KPI, Actions and Perspective using SQL Server Analysis Services 2008(SSAS).
• Worked with T-SQL to create Tables, Views, and triggers and stored Procedures.
• Designed and developed web pages using C#,MVC 3.0 and VS.Net..

Environment: SQL Server 2015/ 2014/2012/2008 R2 Enterprise Edition, Sharepoint,DTS packages, Visual studio 2012/2010, SSAS, SSIS, T-SQL, SSRS, Agile.

Confidential - Peachtree, GA

SQL BI Developer

Responsibilities:

• Developed reports by using SSRS and deployed them on web pages using ASP.NET using C#.
• Wrote custom tasks using C# within SSIS to enhance processing of both Excel and flat-files into SQL Server in Business intelligence studio (BIDS).
• Created very complex SSIS Packages with considering all the best practice like error handling, logging, configurations, deployments, and maintenance.
• Created schemas, keys and indexes considering the granularity of the data
• Iteration planning for new features and user stories in Agile Development methodology.
• Deployed SSIS packages and Reports to Production Servers.
• Worked on EIB Templates.
• Extract Transform Load (ETL) development using SQL Server Integration Services (SSIS).
• Created POWER BI Visualizations and Dashboards as per the requirements.
• Used various sources to pull data into Power BI such as SQL Server, Excel, Oracle, SQL Azure etc.
• Developed and scheduled DTS packages for each system Interface using SQL code in combination with VB ActiveX scripts and built-in DTS transformations.
• Responsible for Hyperion Admin works.
• Created Tvf’s to migrate the data from Hyperion to EDI Reports.
• Created Stored Procedures and Worked with Configuring the SSIS packages using XML & and SQL Server type configurations when the finalized ETL packages are need to be moved onto the Production box.

Environment: SQL Server 2012/2008 R2, SSIS, SSRS, DTS packages, Visual studio 2010/2008, Window 7 Professional, Agile.