SUMMARY

• 7 years + of experience in Data Modeling, Database Design, Programming, Development and Implementation of Client - Server Applications & Database systems using SQL Server 2008/2008R 2/2012 /2014 .
• Extensive work knowledge in handling huge databases and worked on performance tuning and query optimizations.
• Extensive experience in using Microsoft BI studio products like SSIS,SSAS,SSRS for implementation of ETL methodology in data extraction, transformation and loading .
• Expert in Data Warehouse development starting from inception to implementation and ongoing support, strong understanding of BI application design and development principles.
• Highly experienced in whole cycle of DTS/SQL server integration services (SSIS 2008/2012) Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing Data transfers and ETL Purposes across different servers.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations
• Scheduling and Monitoring ETL Processes using DTS Exec utilities and batch files.
• Expertise in generating reports using SQL Server Reporting Services, Crystal Reports, and MS Excel spreadsheets and Power Pivot.
• Expert in designing Enterprise reports using SQL Server Reporting Services (SSRS 2008/2012) generated drill down reports, parameterized reports, linked reports, sub reports, matrix dynamics and filters, charts in SSRS 2008/2018.
• Experience in creating Ad-hoc reports, data driven subscription reports by using Report Builder in SSRS.
• Good knowledge of Data Marts, Operational Data Store (ODS), MDM, OLAP, Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling for FACT and Dimensions Tables using Analysis Services.
• Developed 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.
• Expertise in creating various Parameterized, Cascaded, Linked, Drill-through and Drill-down reports.
• Experience inTroubleshooting ReportProcessing, Subscription,Delivery and Configuration Problems.
• Writing MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.
• With the ease of TFS, managed user permissions among team projects and also, further made it easy to identify any missing permissions
• Experience on performing Data loads to Dimension, Fact tables, Data warehouse, Data marts, and OLAP cubes.
• Experience in Power BI, creating interactive visualizations, dashboards, reports based on business requirements.
• Has very strong background in a disciplined software development life cycle (SDLC) process and has excellent analytical, programming and problem solving skills.
• Good team player, Excellent interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.
• Expertise in defining the business process flow and gathering business requirements.

TECHNICAL SKILLS

Languages: T-SQL, PL/SQL 11g, Dynamic SQL, MDX, C, C++, C#,ASP (.NET), XML, HTML, DHTML, HTTP, Shell Scripting

Databases: MS SQL Server Denali,2014,2012,2008R2,2008,2005

DWH / BI Tools: SQL Server Integration Services ( SSIS ), SQL Server Reporting Services ( SSRS ), SQL Server Analysis Services ( SSAS ), Business Intelligence Development Studio (BIDS), Informatica, Visual Studio, Cognos, Crystal Reports.

Database Design Tools and Data Modeling: MS Visio, ERWIN 4.5/4.0, Star Schema/Snowflake Schema modeling, FACT& Dimensions tables, Physical & logical data modeling and De-normalization techniques, Kimball &Inmon Methodologies

Packages: MS Office, Microsoft Office Suit, Microsoft Office SharePoint Server (MOSS) 2007, Microsoft Performance Point Server 2007

Tools: and Utilities: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Visual Studio .Net, Microsoft Management Console, Visual Source Safe 6.0, DTS, Business Intelligence Development Studio (BIDS),Crystal Reports, Power Pivot, ProClarity, Microsoft Office(MS), Lotus Notes, Excel Power Pivot, Excel Data Explorer, Tableau.

Operating Systems: Windows Vista/XP/2003, NT & Windows 9x, MS-DOS and UNIX.

PROFESSIONAL EXPERIENCE

Confidential, Lincolnshire, IL

Power BI Developer (Oracle)

Responsibilities:

• As a Part of BI/Database team, involved in Requirement Gathering Technical Design, Development, Testing and Implementation of BI Analytics and Reports.
• Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
• Created packages using SSIS 2012 for Data Extraction from flat files, Excel files, OLEDB to SQL Server using ETL tools.
• Followed up with Microsoft Product team on schedule refresh issue for OData (having Organization Authentication) through Power BI Gateway, as it is not an option in Enterprise gateway.
• Designed ETL Packages dealing with different data sources (SQL Server, Flat Files, XMLs etc.,) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS). Writing SSIS Packages to load data into Facts and confirmed dim tables to build cubes.
• Writing parameterized queries for generating stylish tabular reports Drill down, Drill Trough, Cascading, click through, matrix chart, snap shot reports Formatting report layout, sub reports, using Global Variables, Expressions, functions, sorting the data, defining data source and subtotals for the reports using SSRS.
• Built and maintained T-SQL scripts, indexes, and complex queries for data analysis and extraction.
• Fine-tuned SQL queries using hints for maximum efficiency and performance.
• Developed ETL packages using SQL Server 2005 integration services to populate data from different sources like from flat files/SQL/Oracle Server to the staging database and then into the data warehouse. The packages created included a variety of transformation like slowly changing dimensions, look up, aggregate, derived column, conditional split, fuzzy lookup, and multicast and data conversion.
• Involved in implementing key performance indicator (KPI) Objects in SSAS 2008and created calculate member MOLAP cube using MDX in SSAS 2008.
• Designed and build the dimensions, cubes with star schema using SQL SSAS for analysing purpose.
• Performed complete impact analysis on system software due to suggested modifications/ enhancements and prepared detailed documents identifying program and database design changes required for successful implementation of change module.

Environment: MS SQL server Management Studio 17, MS SQL Azure,Oracle SQL Developer,Dax Studio 2.9.2, MS Excel, Power pivot, SSIS, SSAS, SSRS, Performance point, Dashboard Designer, MS SharePoint Designer 2010, TSQL, SQL, Windows.

Confidential - San Antonio, TX

SQL/ SSIS/SSRS/SSAS Developer

Responsibilities:

• Created different Dashboards and charts using Power BI that were published the business stake holders for analysis and customization using filters and actions.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
• Created/Updated database objects like tables, views, stored procedures, function, packages.
• Involved in designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the insurance data from various source systems feeds using SSIS.
• Created different views using SSRS that were published the business stake holders for analysis and customization using filters and actions.

Tools: and Technologies: MS SQL Server 2016, SSIS, SSAS, SSRS Oracle11g, OBIEE, Visual Studio 2015, VSS 2005, Erwin 7.3, Power BI, Tableau Microsoft .NET framework, C#, ASP.NET, XML.

SQL Server BI Developer

Confidential

Responsibilities:

• Actively participated in interacted with users, team lead, DBAs and technical manager to fully understand the requirements of the system.
• Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Optimized the database by creating various clustered, non-clustered indexes and indexed views in SQL Server 2008/2012
• Increased the performance necessary for statistical reporting by 25% after performance monitoring, tuning and optimizing indexes.
• Created adhoc reports using Import and Export Wizard.
• Used MS SQL Server 2012 SSIS to create SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging and before loading the data.
• Pulled the data from multiple database sources such as UDB/DB2/TeraData/SysBase and flat file sources that includes CSV, Excel, MainFrame (SAS).
• Used SSIS to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse
• Used python code to refresh datasets for power Bi using API
• Worked on python code to automate the creation of resource group on Azure cloud services
• Implemented streaming data sets in PowerBI using python rest API
• Strong experience in creating and publishing packages in Framework Manager.
• Experience in creating Multidimensional cubes using SSAS and designing DW schemas.
• Involved in implementing Key Performance Indicator (KPI) Objects in SSAS 2008. Create Calculate member in MOLAP cube using MDX in SSAS 2008.
• Created DSV, Cubes, and Dimensions, DMX/MDX for SSAS Reports.
• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task.
• Created SSIS Packages to export and import data from CSV files, Text files and Excel Spreadsheets.
• Designed and developed matrix and tabular reports with drill down, drill through and drop down menu option using SSRS and Created Ad-Hoc Reports, Summary Reports, Sub Reports.
• Used SQL Server 2008R2/2012 Reporting Services (SSRS) for generating reports which resulted in efficient decision making.
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer Representatives for various categories and regions based on business needs using SQL Server Reporting Services (SSRS)
• Created, maintained & scheduled various reports in SSRS like Ad-hoc Reports, Canned Reports, Master Reports & Parameterized Reports using SQL Server Reporting Services SSRS.
• Created multiple reports Power BI in Drill mode using tables, financial tables, crosses tabs and chart.
• Create reports in Power BI preview portal utilizing the SSAS Tabular.
• Published Power BI Desktop reports created in Report view to the Power BI service.
• Transformed and combined the data using Query Editor in the Power BI
• Created Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS).
• MDX queries and Data Mining Expression (DMX) queries for Analysis Services & Reporting Services were developed

SQL/SSIS Developer

Confidential - pittsburgh, PA

Responsibilities:

• Created new database objects like stored procedures, Functions, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2008.
• Migrated DTS packages from SQL Server 2000 to SQL Server 2008 as SSIS Packages.
• Created efficient, robust SSIS packages for data movement and loading with error checking and well documented code.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
• Created SSIS Packages to integrate data coming from Text files and Excel files.
• 2Created SSIS packages to validate, extract, transform and load data to data warehouse databases.
• Built connections to/pulling data from AS400, mainframe/db2 and Oracle.
• Migrated old data from MS Access into SQL Server 2008 using SSIS Packages in Business Intelligence Development Studio.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups using SSIS tasks.
• Data management and data processing solutions using SSIS, this includes Error Handling and Slowly Changing Dimensions.
• Wrote many stored procedures for cleaning, manipulating and processing data between the databases.
• Worked with DBA team on Database Compression for different databases to save space across different environments.
• Extensively used Joins and Common Table Expressions to simplify complex queries involving multiple tables
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
• Experience in creating Multidimensional cubes using SSAS and designing DW schemas.
• Created DSV, Cubes, and Dimensions, DMX/MDX for SSAS Reports.

Environment: SQL Server 2008/2012 Enterprise Edition, ODBC,, BIDS, Crystal Reports 8.0, XML, ASP.Net, Visual Basic 6.0.

SQL Developer

Confidential

Responsibilities:

• Worked on extracting, transforming and loading data using SSIS Import/Export Wizard.
• Created Tables, Stored procedures and defined functions. Created SQL scripts for tuning and scheduling.
• Developed physical data models, data warehouse models and created DDL scripts to create database schema and database objects
• Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the package according to the advanced feature of SQL Server Integration Services.
• Provided Full Reporting Life Cycle support using SQL Server Reporting Service 2008.s
• Worked with T-SQL to create Tables, Views, Triggers and Stored Procedures.
• Created complex joins and implemented Constraints on tables for maintaining Data Integrity.
• Designed and developed custom .NET components and user controls using ASP.NET
• Wrote VB Scripts to create custom SSIS transformations, in addition to using built-in SSIS transformations.
• Involved in creating high level ETL architecture for overall data transfer to OLTP, ODS with the help of SQL Server 2005, 2008 Integration services.
• Involved in relational database modeling like, designing the tables, algorithmic diagrams for the input data (entity diagrams), indexes etc.
• Worked on retrieving data from Legacy sources, retrieve files on daily, weekly and monthly basis, file-transfers from one location to other.
• Created complex SSIS packages using appropriate control and data flow elements with SSIS Standards like error handling, logging and working with package config files.
• Exporting the database from Local server to the remote server and importing the current running database from remote server to the local DB Server using SSIS.
• Created Tablix reports, Tabular/Matrix reports based on requirements.
• Created Dashboards using SSRS.
• Reduced the overall ETL time by SQL Query performance Tuning. Discussed with user interface and external interface teams over the performance issues and provided solutions.
• Created databases, tables, and fields for data entry, performing database capacity planning.
• Enhanced and deployed the SSIS packages from development server to production server and scheduled jobs.
• Supported the production team when issues rose in the packages.

Environment: MS SQL Server 2008R2, SQL Server Reporting Services (SSRS), MS Access, MS Excel, SSIS, BCP, T-SQL