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 Microsoft Power BI reports.
• Worked on Power BI and 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.
• Experienced in creating multiple kinds of reports in Power BI and present it using Story 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 Referenced 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

WORK 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.
• Utilized Power BI for Office 365 to amplify data visualizations with collaboration and data management.
• Mapped millions of record over Bing maps from Excel data model and discovered actionable insights for strategic planning utilizing Power BI (Power Map).
• Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning.
• 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.
• Expertise in standard Sales force configuration that include workflow rules, page layouts, Record Types, Approval Processes, Assignment rules, Validation rules, bulk Triggers, etc.
• Design and implement the ETL processes using SSIS which involves collection of data from sources like SQL Server 2008 R 2/2012/2014/2016.
• Develop SSIS, SSRS / T-SQL Code and schedules jobs for Jobs Monitoring Automation.
• Developing and maintaining/modifying complex T-SQL queries, 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 in Power BI like Tabular Reports.
• Explore data in a Variety of ways and across multiple visualizations using Power BI.
• Created effective reports using visualizations such as Bar chart, Clustered Column Chart, Waterfall Chart, Gauge, Pie Chart, Tree map etc. in Power BI.
• 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 and SQL Server 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, PL SQL, DAX, OLAP and OLTP.
• Developed impactful reports using SSRS, MS Excel, Pivot tables and Tableau to solve the business requirements.
• Used Indexing strategies and query optimization techniques to optimize Stored Procedures and long running queries.

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

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.
• Utilized Sql Server 2012/2008 R2 / Visual Studio (VB) in development of a large ETL Process with over 1100 objects,
• Maintained existing Power BI reports and dashboards and made changes onto the same as per new and changing business requirements.
• Hands on Power BI View Tool. Created reports using the Power BI Tool.
• Created Tabular Models as a source to Power BI dashboards and scheduled jobs to refresh it in a timely manner.
• Deceased nightly load from 6 to 2 hours by implantation of delta processing
• Extensive Knowledge of TSQL, Stored Procedures, Views, and SSIS Scripting.
• Published Power BI Desktop reports created in Report view to the Power BI service.
• 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 production SQL Server objects. TSQL and SSIS Packages.
• Deployed SSIS package though SQL Server 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 though Power Pivot

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.

SQL BI Developer

Responsibilities:

• Gathered requirements to identify and create database objects such as tables, views, triggers and indexes.
• Created Stored Procedures for commonly used complex queries involving join and union of multiple tables.
• Developed custom reports using SQL Server Reporting Services (SSRS) to review score cards, business trends based on the data from different retail locations.
• Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel.
• Developed Power BI view reports using Tabular Models in SQL Server Data Tools.
• Created ad Hoc and parameterized various reports using SSRS with data from SQL Server 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: s: SQL Server 2008, Visual Studio, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), MS Access, Oracle, ASP.Net 3.0, Ado.Net 3.0, C#.Net.

SQL Server SSIS/SSRS/SSAS Developer

Responsibilities:

• Involved in the performance of data consistency and tuning effectively with SQL Profiler, Index Tuning Wizard.
• Involved in creating and maintaining database objects, Stored Procedures, Functions, Triggers, Cursors, Tables, Views and SQL Joins 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, Execute SQL tasks.
• Created packages to extract data from flat files with ragged right data mapping.
• Designed and created Report templates, bar graphs, pie charts based on the financial data.
• Created report models for ad-hoc reports using SSRS 2012.
• Generated periodic reports based on the statistical analysis of the data using SSRS 2012.
• 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 and Powerpivot
• Involved in cube partitioning and developed various calculations using SSAS.
• Created many Complex Queries using MDX Expressions.
• Used Performance Monitor and SQL Profiler 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 with developers on various aspects ranging from usage of utilities to SQL performance, test data and general troubleshooting

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

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 into SQL Server 2005.
• Implemented the developed database into SQL Server 2005 using T-SQL.
• Facilitated data retrieval and manipulation through implementation of Views, Procedures, Triggers and Cursors.
• Analyzed and tuned complex Queries/Stored Procedures in SQL Server 2005 for faster execution and developed database structures.
• Imported data from MS Excel and Text Files to SQL server 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: SQL Server 2005, SSIS, SSRS, BIDS, SharePoint 2010, Erwin

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 like Functions, Procedures, Packages, Triggers, Views, and Indexes using T-SQL in SQL Server 2005.
• Used SSIS transformation for Data Cleansing to remove unnecessary data.
• Created SQL SSIS and SSRS infrastructure that pulls data from data sources and provides a sample to use reporting environment.
• Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.
• 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 with coding, design and performance tuning.
• Developed and implemented database and coding standards, improving performance and maintainability of corporate databases.
• Created the DTS Package through ETL Process 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

Jr. MS SQL Developer

Responsibilities:

• Designing, Developing and implementing database systems based on requirements.
• Optimizing database queries and systems for efficiency.
• Developed complex stored procedures using T-SQL to generate Ad hoc reports within SQL Server Reporting Service (SSRS).
• Experience in transforming unstructured data from various data sources using SSIS.
• Used Vb.net and C# in Script task of SSIS 2015 Packages.
• 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 MS SQL Reporting.

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