SUMMARY

• Over 8 years of Experience in Data Warehousing and Business Intelligence applications design, development, and Maintenance of Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analytical Services (SSAS) and Data Transformation Services (DTS).
• Extensive experience in Database Design, Data Modeling, T - SQL Development, Developing and Implementing ETL Packages.
• Expert in all areas of SQL Server development including tables, user defined functions, views, indexes, Stored procedures, functions, triggers, clustering, relational database models, data dictionaries, and data integrity.
• Expert in using all kinds of SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Checks, and Unique), Writing Transact SQL (T-SQL) Queries, & Dynamic-queries.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Bulk Insert, Data Replication, Data Transformation Services (DTS) and SQL Server Integration Services (SSIS).
• Well versed in Normalization/De-normalization techniques for optimum performance in relational and dimensional database environments.
• Expertise in solving Dead Locks/Long running queries using Performance Monitor and SQL Profiler.
• Design, Develop and Deploy MicrosoftPowerBIreports.
• Worked onPowerBIand created reports and dashboards and published them on service.
• Performed several transformations and data cleansing on data including fuzzy lookup, slowly changing dimension, union all, merge join and check points/break points.
• Experience in creating automated administrative functions such as backing up and restoring databases, copying SQL Server databases and the objects they contain, copying SQL Server objects, and loading data using SSIS.
• Expert in configuring and creating SSIS solutions for high performance Data Integration, Data Migration and Business Intelligence Process that includes Merging Data from various Heterogeneous Data Stores, Populating Data Warehouses and Data Marts, Cleaning, and Standardizing Data.
• Excellent experience in developing stylish Drill Down, Cascading, Drill through, Parameterized, Sub reports and Charts using Global Variables, Expressions and Functions using SSRS.
• Expert in writing Parameterized Queries for generating Tabular reports and Sub reports using Global variables, Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS.
• Experience in Troubleshooting Report Processing, Subscription, Delivery, and Configuration Problems.
• Proficient in building Cubes, defining d Relationships and creating Hierarchies in SSAS.
• Expertise in creating Cell Level Security in cubes using SSAS.
• Expertise in creating Perspectives, Partitions and Design Aggregations in cubes using SSAS.
• Expertise in creating Dashboard Reports to support end users using SSAS.
• Good understanding and designing of Star and Snow Flake Schema used in relational, dimensional, and multidimensional data modeling.
• Expertise in implementing efficient Disaster Recovery Strategies and High availability like Replication, Log shipping, clustering (Active/Passive) and Database Mirroring.
• Worked on administration tasks such as data loading, batch jobs, data unloading, backup & Recovery, user and application table management, upgrades, creating databases/File groups/files/Transaction logs.
• Strong team player with leadership, interpersonal, presentational, and communicational skills. Excellent problem resolution skills with ability to work under pressure. Exceptional ability to learn and master new technologies and to deliver output in short deadlines.

TECHNICAL SKILLS

Languages: SQL, T- SQL, HTML, XML, PL/SQL, Oracle 9i/10g/11g, MySql, data warehouse, DB2

Databases: SQL Server 2014/2012/2008/2005/2000/7.0 , MS Access

Analysis/Reporting Tools: SQL Server Reporting Service (SSRS), SQL Server Analysis Service (SSAS)

ETL Tools: SSIS (SQL Server Integration Services), DTS (Data Transformation Services), Import Export Data

Web technologies: .Net, ASP.Net, Ado.Net, JavaScript

Data Modeling Tools: Erwin, Visio

Testing: Unit Testing, Performance Testing, Integration Testing, Stress Testing

Other Software: MS Office- 2013/2010/2007/2003

Operating Systems: Windows 2003/XP/Vista/8.0/8.1/10

Database Tools: SQL Query Analyzer, SQL Enterprise Manager, Management Studio, SQL Server Query Editor, Solution Explorer, Analysis Manager, Reporting Server

PROFESSIONAL EXPERIENCE

Confidential, Fort Worth, TX

SQL/SSIS/SSRS/SSAS/POWER BI Developer

Responsibilities:

• Prepares performance Dashboard, Jobs Failure stats, Data Volume check using SSRS, SSIS,SQL and Excel and gives PPT presentation near client for this on a daily basis.
• Creating and managing schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements.
• Develop and deploy SSIS packages, configuration files, and schedules job to run the packages to generate data in CSV files.
• Involved in writing UNIX shell scripts for InformaticaETLtool to automate sessions.
• Held discussions withETLArchitect to make sureETLdesign is as per industry standards and best practices are followed.
• Experienced working on Star and Snowflake Schemas and used the fact and dimension tables to build the cubes, perform processing and deployed them toSSASdatabase.
• Involved in development &Deployment ofSSASCubes and Monitor Full and Incremental loads and support any issues.
• Trained on multiple computer systems Including using a scan gun forDAXprograms, DSD, and inventory.
• Create and manage Reports subscriptions and schedules SSRS reports.
• Designing and implementing a variety of SSRS reports such as Parameterized, Drilldown, Ad hoc and Sub-reports using Report Designer and Report Builder based on the requirements.
• Troubleshooting reports issues, ETL job failures, optimizing query performances.
• Design and implement the ETL processes using SSIS which involves collection of data from sources likeSQLServer 2008 R 2/2012/2014/2016.
• Develop SSIS, SSRS / T-SQLCode and schedules jobs for Jobs Monitoring Automation.
• Developing and maintaining/modifying complex T-SQLqueries, stored procedures and SSIS packages to load the data into warehouse.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities
• Created, Maintained & scheduled various reports inPowerBIlike Tabular Reports.
• Explore data in a Variety of ways and across multiple visualizations usingPowerBI.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Designed and built up high performance ETL packages to migrate and manipulate data from MS Excel andSQLServer by using SSIS.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Responsible for debug, performance checks and performed index tuning and query optimization.
• Solid knowledge of Relational Database Management System (RDMS), Data Warehouse Concepts, PLSQL, DAX, OLAP and OLTP.
• Developed impactful reports using SSRS, MS Excel, Pivot tables and Tableau to solve the business requirements.

Environment: MSSQLServer 2016/2012/2008 R2, MSSQLServer Reporting Services (SSRS), MSSQLServer Integration Services (SSIS), MSSQLServer Analysis Services (SSAS), DAX, Agile, C#.NET, TSQL,SQLProfiler, XML, Team Foundation Server (TFS), MS Excel, Excess, Windows 8.

Confidential, Lockport, NY

Sr. SQL BI Developer

Responsibilities:

• Designed and developed Two large BDE, (bulk data extract) ETL Processes.
• ETL project consisted of Ebcdic data files the other remote access to Oracle 11G.
• UtilizedSqlServer 2012/2008 R2 / Visual Studio (VB) in development of a large ETL Process with over 1100 objects,
• Designed, configured and deployed MicrosoftAzurefor a multitude of applications utilizing the stack (Including Compute, Web & Mobile, Blobs, Resource Groups,AzureSQL, Cloud Services, and ARM), focusing on high-availability, fault tolerance, and auto-scaling.
• Performed unit testing at various levels of theETLand actively involved in team code reviews.
• Assisted the team in the development of design standards and codes for effectiveETLprocedure development and implementation.
• Deceased nightly load from 6 to 2 hours by implantation of delta processing
• Extensive Knowledge of TSQL, Stored Procedures, Views, and SSIS Scripting.
• Created Resource pools and processes to limit system impact by adhoc report users.
• Ensure continuous 24x7x365 database operation (on-call rotation)
• Experience with data encryption at the column and database level.
• Code approved productionSQLServer objects. TSQL and SSIS Packages.
• Deployed SSIS package thoughSQLServer and DTUTIL
• Ensured that all objects conform to company standards and that all audit procedures have been followed prior to production integration. Approved requests, verified code check in, conducted code review, and completed testing.recoverability and performance
• Installed configured and Deployed SSRS
• Database Installation, Configuration, Maintenance, Monitoring, Backup and Disaster Recovery procedure
• Management of OLAP Cube environments
• Assisted end users in configuration of data access thoughPowerPivot

Environment: SQL Server 2008/2012, Enterprise Edition, SQL, Enterprise manager, SSRS, SSIS, Spotlight, MS SharePoint, MS Access 2000 & Windows 2003/2000 platform, C#, VB.NET, ASP.NET.

Confidential, Virginia Beach, VA

SQL BI Developer

Responsibilities:

• Gathered requirements to identify and create database objects such as tables, views, triggers and indexes.
• Worked on MicrosoftAzure(Public) Cloud to provide support to client.
• Manage and Create Storage Account and Affinity Group inAzurePortal.
• Clear Understanding of MicrosoftAzureSubscription Components like EA Administrator, Account Owner, Service Admin and Co-Administrator.
• Created Stored Procedures for commonly used complex queries involving join and union of multiple tables.
• Developed custom reports usingSQLServer Reporting Services (SSRS) to review score cards, business trends based on the data from different retail locations.
• Created ad Hoc and parameterized various reports using SSRS with data fromSQLServer and MS Access as data sources.
• Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to analyze performance of Strategic Business Units.
• Identified Dimensions and Facts, Used MDX to extract data from cubes and created MDX script for representing Cube Calculation.
• Troubleshoot databases and custom application issues involving existing database objects.

Environment: Confidential: SQLServer 2008, Visual Studio,SQLServer Integration Services (SSIS),SQLServer Reporting Services (SSRS),SQLServer Analysis Services (SSAS), MS Access, Oracle, ASP.Net 3.0, Ado.Net 3.0, C#.Net.

Confidential, White Plains, NY

SQL Server SSIS/SSRS/SSAS Developer

Responsibilities:

• Involved in the performance of data consistency and tuning effectively withSQLProfiler, Index Tuning Wizard.
• Involved in creating and maintaining database objects, Stored Procedures, Functions, Triggers, Cursors, Tables, Views andSQLJoins and other statements for various applications.
• Expertise in exporting and importing data using SSIS and using check points in SSIS packages.
• In SSIS packages used various Control Flow Tasks like For each Loop, For Loop containers, ExecuteSQLtasks.
• Created packages to extract data from flat files with ragged right data mapping.
• Involved in creating user Variables, Script tasks and involved in creating dynamic SSIS packages.
• Analyzed existing SSIS packages to improve performance.
• Improved SSRS reports performance by creating summary reports, reducing not useful columns, caching, snapshot and schedule subscriptions.
• Used SSRS for creating, editing and scheduling various complex reports and sub reports in various formats like MS Excel, PDF, HTML, and XML etc.
• Delivered reports for day-to-day as well as weekly/monthly purposes using Report Builder andPowerpivot
• Involved in cube partitioning and developed various calculations using SSAS.
• Created many Complex Queries using MDX Expressions.
• Used Performance Monitor andSQLProfiler to optimize queries and enhance the performance of database servers.
• Provided 24x7 on call support for various projects and ensure that all critical database problems are resolved in timely manner.
• Interacted withdeveloperson various aspects ranging from usage of utilities toSQLperformance, test data and general troubleshooting

Environment: SQLServer 2012, XML,SQLServer Integration Services (SSIS),SQLServer Reporting Services(SSRS),SQLServer Analysis Services(SSAS),SQLProfiler, Visual Studio 2010, .Net Frame Work 4.0,PowerPivot, Index Tuning Wizard, Performance Monitor, SharePoint 2010, Windows 7, Microsoft office 2010

Confidential, Charlotte, NC

Sr. SQL BI Developer

Responsibilities:

• Gathered system requirements through end-user collaboration.
• Designed, developed and implemented ETL framework using SSIS, stored procedures, functions for extractions intoSQLServer 2005.
• Implemented the developed database intoSQLServer 2005 using T-SQL.
• Facilitated data retrieval and manipulation through implementation of Views, Procedures, Triggers and Cursors.
• Analyzed and tuned complex Queries/Stored Procedures inSQLServer 2005 for faster execution and developed database structures.
• Imported data from MS Excel and Text Files toSQLserver 2005 using SSIS.
• Provided back-end support for functional testing and performance testing
• Drafted all system documentation along with user manual, flowcharts, and source code.
• Data Migration with MS Access, Excel and Text files and scheduling tasks using SSIS.

Environment: SQLServer 2005, SSIS, SSRS, BIDS, SharePoint 2010, Erwin

Confidential

SQL Server Developer/DBA

Responsibilities:

• Built logical models to describe all the date and relationships between them depending on business requirements.
• Created new database objects likeFunctions, Procedures, Packages, Triggers, Views,and Indexes usingT-SQLinSQL Server 2005.
• Standardized the implementation of data, validated change requests and made appropriate recommendations.
• Promoted database objects from test/develop to production. Coordinated and communicated production schedules within development team.
• Modified database structures as directed by developers for test/develop environments and assist withcoding,designandperformance tuning.
• Developed and implemented database and coding standards, improving performance and maintainability of corporate databases.
• Created theDTSPackagethroughETLProcess to vendors in which records were extracts from Flat file and Excel sources and loaded daily at the server.
• Updated the statistics info for both the old and new servers.
• Assisted with various ad hoc query requests.
• Provided back-end support for functional testing and performance testing.

Environment: SQL Server 2005, T-SQL, DTS Designer, MS-Office, MS-Excel, VSS

Confidential

Jr. MS SQL Developer

Responsibilities:

• Designing, Developing and implementing database systems based on requirements.
• Optimizing database queries and systems for efficiency.
• Created tables, views and indexes based on requirements.
• Testing database and perform bug fixes.
• Performed database backup and archived on regular basis.
• Created complex functions, Scripts, Stored Procedures and Triggers to support application development
• Identifying issues in database and troubleshooting.
• Reporting database by tool MSSQLReporting.

Environment: MSSQLServer 2008/2005, T-SQL, MSSQLServer Reporting tools, Microsoft visual Source safe.