PROFESSIONAL SUMMARY:

• Over 8+ years of IT Experience as MS SQL Server Database Developer with strong background in Data warehousing and ETL experience
• Extensive experience in Information Technology with special emphasis on design & development of Database/Data Warehousing/Client - Server/e-commerce applications and Software Development Lifecycle (SDLC).
• Experience Working in Agile, Scrum and Waterfall model
• Strong technical knowledge in MS SQL Server development including Integration Services, DTS, Microsoft Analysis Services, Performance tuning, Reporting, designing logical/physical databases and troubleshooting.
• Hands on experience in design and implementation of Database Schema and building stored procedures on SQL Azure
• Hands on Experience on Data warehouse concepts Normalization and Demoralization
• Proficient in creating Transact-SQL (DDL, DML, DCL and TCL), Indexes, Views, Cte, Complex Stored Procedures, User and System defined functions
• Experienced with adhoc reporting, Parameterized, Custom Reporting using SSRS for daily reports
• Efficient Experience working on OLTP, OLAP and ODS
• Experience in designing, developing, and delivering business intelligence solutions using SQL Server Integration Services (SSIS), Analysis Services (SSAS), and Reporting Services (SSRS).
• Extensive experience with SQL Server and T-SQL in constructing tables, triggers, user defined functions, views, indexes, user profiles, relational database models, data dictionaries and data integrity.
• Expert in writing T-SQL, working on DTS, SSIS, SSRS Data Cleansing, Data Scrubbing and Data Migration
• Experienced in creating Jobs, Alerts, SQL Mail Agent, and scheduling DTS Packages
• Designed SSIS Packages to extract data from various heterogeneous data sources such as Access database, Excel spreadsheet and flat files into SQL Server for further Data Analysis and Reporting by using multiple transformations provided by SSIS.
• Experienced in logical, physical, and dimensional data modeling, data mapping, and data normalization.
• Heavy experience in deploying and configuring packages, Error handling and batch logging, check points and troubleshooting Reports using SSRS.
• Experienced in creating various types of reports such as Complex drill down & drill through reports, Matrix reports, Sub reports and Charts using SQL Server Reporting Services (SSRS) based on Relational and OLAP databases.
• Hands on experience with performing various SSIS data transformation tasks like Lookup, Conditional Splits and Event Handlers, Error Handlers etc.
• Experience in designing enterprise reports using SQL Server Reporting Services, generated drill down reports, drill through reports, linked reports, sub reports, matrix dynamics and filters, charts in SSRS.
• Wrote parameterized queries for generating reports in SSRS.
• Built and partitioned cubes using SSAS with multiple fact tables.
• Proficient in designing and implementing SSAS Tabular & Multidimensional Cubes.
• Worked on DAX scripting to access data from Tabular Model and MDX for Multidimensional Cubes.
• Expertise in creating Row Level Security & Roles for SSAS Tabular Model & Multidimensional Cubes, as well as deploying them into SSAS.
• Experienced in creating complex SSAS Cubes with multiple fact measure groups and multiple dimension hierarchies based on the OLAP Reporting needs.
• Experience in publishing Power BI Desktop reports created in Report view to the Power BI service.

TECHNICAL SKILLS:

Languages: C/C++, JAVA, J2EE, C#, T-SQL, PL/SQL, ASP.NET, Visual Basic

Databases: SQL Server 2000/2005/2008/2012/2014, MS Access 2000, Oracle 9i/10g/11g

DWH / BI Tools: SQL Server Analysis Services, SQL Server Reporting Services.

Database Design: Enterprise Manager, Query Analyzer, SQL Server Configuration Manager

Tools: and Data: TOAD, Business Intelligence Development Studio (BIDS), SQL Server

Modeling: Surface Area Configuration, Database Engine Tuning Advisor, SQL Profiler

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

Tools: and Utilities: SQL Server Analysis Services, SQL Server Reporting Services, Export & Import (DTS), SSIS (Integration Services)

Operating Systems: Windows Server 2000/2003, Windows NT/98/XP/Vista, UNIX

Web Servers: Microsoft IIS, Apache, Apache Tomcat

PROFESSIONAL EXPERIENCE:

Confidential - New York

Sr. SQL/SSIS/SSRS/SSAS/Power BI Developer

Responsibilities:

• Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems.
• Worked independently on a Project Called Back Order Relief Process for IPR (Inventory Planning and Replenishment) to build ETL process by gathering the requirements and pull data from multiple sources (flat files and Access DB) to SQL to provide Useful SSRS reports and Dashboard to the Business users.
• Worked on Operations Visibility reporting project that helps the SCD (Supply Chain and Distribution) team to effectively utilize the resources within the distribution center
• Also worked on Order Age reporting project, which helps the business monitor the Order fulfillment process and use the calculated On-time percentage metrics to determine the performance within the distribution center
• Worked on Onboarding the WMS (Warehouse Management System) Oracle data and landed the data tables on our production SQL Server with process indexing and considering other constraints
• Then, worked on a project called Oversell for IPR (Inventory Planning and Replenishment) team to build them an ETL process where we upload the Skus (Storekeeping units) that are on sale in website and process and calculate sales related metrics using the sales data that pull periodically from a WCS (Warehouse Control System) that sits beneath the .COM to provide useful SSRS reports to business users who monitor the sales of individual Sku's and add or remove them off website based on the Available quantity
• Identified the dimension, fact tables and designed the data warehouse using star schema.
• Created volatile tables and partitioning the tables and Responsible for supporting existing projects using Teradata SQL assistant tool.
• Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non-clustered indexes.
• Developed and Optimized Stored Procedures, Views, and User-Defined Functions for the Application.
• Involved in Normalization of the database and bringing it to 3NF. Dealt with Fine-tuning Stored Procedures to improve performance with a Query plan using SQL Tuning advisor.
• Migrated data from Heterogeneous Data Sources to SQL Server databases using SQL Server Integration Services (SSIS) to overcome transformation constraints.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).
• Developed and responsible for development of Dashboards in Tableau
• Experience in creating reports and performing business analysis in Tableau
• Developed various operational Drill-through and Drill-down custom reports using .Net framework 3.5 within SSRS.
• Developed different kind of reports such a Sub Reports, Charts, Matrix reports, Linked reports. Used cascaded parameters to generate a report from two different Data Sets.
• Production support, troubleshooting and debugging in a high volume transaction processing environment.
• Support existing projects over the holiday season to ensure the business had all the data and reports available.

Environment: MS SQL Server 2012/2008R2, SQL Server Reporting Services (SSRS), SQL Server Analysis services (SSAS), SQL Server Integration services (SSIS), Business Intelligence Development Studio (BIDS), MS Excel, MS Access, Windows XP, SQL Server Management Studio (SSMS), TFS

Confidential - CA

SQL/SSRS/SSIS/SSAS Developer

Responsibilities:

• Involved in the Requirement Analysis, Design phase and Development phase of Agile SDLC model system.
• Developed various T-SQL objects such as Functions, Tables, Views, Triggers, Indexes, Constraints and created Dynamic and Static Stored Procedures and Queries to develop Decision Engine.
• Developed, monitored and deployed SSIS packages for Dynamic ETL flow to validate, extract, transform and load data into database.
• Performed Full load & Incremental load with several Data flow tasks and Control Flow Tasks using SSIS.
• Worked on OLAP Data warehouse, Model, Design, and Implementation.
• Maintained Batch logging, Error logging tables and handled errors using Event handlers.
• Created SSIS package to Export and Import data from SQL Server to Access, Text and Excel files and Configured SQL mail agent for sending automatic mails.
• Developed reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Developed Parameterized, Drill-through, and Drill-down Reports to get monthly customers account details and profits using SSRS.
• Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to analyze performance of Strategic Business Units as well as corporate centers
• Sound Experience and understanding of SSAS, OLAP and OLTP cube, Data mining and Architecture.
• Involved in deploying, configuring and managing reports using Report Manager and Report Builder.
• Formatted the reports using the Global variables and expressions.
• Scheduling the SSIS packages and Jobs.
• Improved Performance by creating Clustered and Non- clustered Indexes and by optimizing the T- SQL statements using SQL profiler.

Environment: MS SQL Server 2008, T- SQL, Power pivot, Microsoft SQL Server Integration Services (SSIS), Microsoft SQL Server Reporting Services (SSRS), Microsoft SQL Server Analysis Services (SSAS), SQL Server Business Intelligence Development Studio,), Visual Source Safe (VSS) .

BI Consultant

Confidential, Allen, TX

Responsibilities:

• Actively participated in design discussion and planning meetings as well as provided suggestion for further improvement of the designing process.
• Liaised with front end users, analyzed the needs, issues raised and accordingly modified the existing database for hassle free working environment.
• Created SSIS packages with different control flow options and data flow transformations such as derived column, conditional split, merge join, OLEDB command etc.
• Designed, built star and snowflake dimensional models creating facts, dimensions, measures, cube and established data granularity.
• Built new measures as well as changed aggregate function, format string and other properties of measures according to the need.
• Modified existing packages for logical change in data.
• Performance tuning of existing packages.
• Implemented SCD type 1 to eliminate the need of truncating tables.
• Documentation of packages.
• Updated backup database.
• Extensively used store procedures for updating data.
• Created jobs for automated executions of store procedures and SSIS packages.
• Designed and built star and snowflake dimensional models creating facts, dimensions, measures, cube and established data granularity.
• Involved in creating Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Designed SSAS Cube and build it from scratch.
• Modified data source view (DSV), added new named calculations, named queries and logical primary keys in SSAS.
• Changed aggregate function, format string and other properties of measures according to the need.
• Build new measures according to the need.
• Established dimensions and measure groups relationship in dimension tab, created partitions for large measure groups in SSAS.

Environment: SQL Server 2008 R2 Enterprise, WindowsEnterpriseServer2003, SSAS, SSIS, SSRS, Server 2004, Access, Share Point Portal Server 2003, IIS 6.0, .XML, Microsoft Visio 2003, MS Visual Studio, C#, ASP.Net 3.5, VB.Net.

Database BI Consultant

Confidential

Responsibilities:

• Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and Understanding the functional work flow of information from source systems to destination systems.
• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2005 and Flat files.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers and Fuzzy Lookups etc.
• Involved in ETL architecture enhancements to increase the performance using query optimizer.
• Implemented Event Handlers and Error Handling in SSIS packages.
• Created SSIS packages for Data Conversion using data conversion transformation.
• Configured the loading of data into slowly changing dimensions using Slowly Changing Dimension wizard.
• Advanced extensible reporting skills using SQL Server 2008 Reporting Services (SSRS).
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Developed various types of complex reports like Drill Down, Drill through, Cross tab reports.
• Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2008.
• Involved in designing Parameterized Reports for generating Ad-Hoc reports as per the client requirements.
• Coordinated with front-end for implementing logic in stored procedures and functions.
• Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non clustered indexes.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Involved in upgrading from SQL Server 2005 to SQL Server 2008.
• Advised optimization of queries by looking at Execution Plan for better tuning of the database.

Environment: SQL Server 2008, T-SQL, Windows XP, Enterprise Manager, SQL Server Management Studio 2008, SQL Server Business Intelligence Studio, SQL Server Profiler, IIS, SSRS, SSAS, SSIS, Visual Studio 2008.