PROFFESIONAL 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), Statistical modeling 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.
• Experienced with full life Cycle phase of SDLC involving Systems Analysis, Design, Development and Implementation.
• Excellent knowledge in RDBMS concepts and constructs along with Database Objects creation such as Tables, User Defined Data Types, Indexes, Stored Procedures, Views, User Defined Functions, Cursors and Triggers.
• Experience in OLTP and OLAP design, development, testing, implementation and support of enterprise data warehouse.
• 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.
• Installed and configured MS SQL Server VM in Azure Database and worked on cloud services, storage accounts, service buses, event hubs, app service plans and Azure active directory and SQL Azure.
• 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.
• Experience in ability to debug and write C# code for various SSIS script tasks.
• 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 .
• Experience in developing custom reports and creating various types of reports like On demand, drill down , Drill-through , Parameterized, Cascading, Conditional, Table, Matrix, Chart, Sub Reports, Ad hoc Reports, dynamic grouping, Cross-Tab, graphical, distributed Reports in multiple formats using SQL Server Reporting Services (SSRS) and Business Intelligence Development Studio (BIDS).
• Experience in report writing using SQL Server Reporting Services (SSRS) and Created analytical reports and visualizations with Microsoft Excel 2013 Power BI tools (Power View, Power pivot and Mapping) for exploratory analysis by data analysts.
• Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.
• Proficient in tools like Index Tuning Wizard , SQL Profiler and Windows Performance Monitor for monitoring and tuning MS SQL Server performance.
• Experience in Interacting with Business users to analyze the business process and transforming requirements into performing ETL, documenting and rolling out the deliverables.
• Experience in Error handling and debugging coding issues and troubleshoot production problems.
• Experience in Configure and maintain Report Manager and Report Server for SSRS , Deployed and Scheduled the Reports in Report Manager.
• Expertise in implementing efficient Disaster Recovery Strategies and High availability like Replication, Log shipping, clustering (Active/Passive) and Database Mirroring.
• Worked in ASP.NET /C# application development environment to use SQL Server Databases as backend database.
• 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:

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), Tableu, Power BI

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

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, Miami, FL

Sr.SQL/SSIS/SSRS/SSAS 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.
• 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.
• Extract data from SharePoint document library and load into Azure SQL server.
• Used angular JS frame work and integrated with SQL Server DB.
• 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.
• Developed a HTML5 and Angular JS dashboard with SSAS power pivot view, SSRS Reports, KPI's, Uploader, Downloader and user administration.
• 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.
• Worked on Azure cloud in spinning of new resources under resource group.
• Created SQL Server always on cluster on AZURE cloud environment.
• 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.
• Experience working with Azure Data warehouse, created TSQL code to use poly base external tables in order to load data from ADL to ADW.
• 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.
• 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.
• Applied hypothesis testing and advanced statistical methods in R (clustering, random forest, regressions) to characterize and predict suspicious user behaviors.
• Enhance SSIS packages to perform dynamic functionalities from static configuration and changed many of the packages by using C# coding for generic usage within the organization.
• Developed console application Refreshing Cube with parameters Cube Name and SSAS Server Name application was in VBA and converted in C#.
• Formulated assumptions simulated their performance by analyzing large sets of financial data in R.
• Performed data cleaning and imputation of missing values using R.

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, Angular, T SQL, SQL Profiler, XML,Azure, Team Foundation Server (TFS), MS Excel, Excess, R, Windows 8.

Confidential, Brentwood, TN

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.
• Implementing and controlling the flow of data to and from AWS and Azure.
• Developed many Tabular Reports, Matrix Reports, Drill down Reports, and Dropdown Reports, Sub Reports, Bar Graph Reports, and Cascading Parameters Reports using SQL SSRS 2010/2012.
• Experience in creating Multidimensional cubes using SSAS and designing DW schemas.
• Worked on Data factory in order to load the data from on premise to Azure Data Lake.
• Converted complicated Crystal Reports to Standard SSRS reports by creating stored procedures and mapping parameters thus by enabling Business Users easy access to one stop Reporting Solution via SSRS.
• Used SSIS to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse
• Involved in lot of installations/upgrades/deployments of new/updated tools and applications.
• Documented all the procedures for Crystal Reports Conversions, SSRS On boarding and other Application updates.
• Experience with on-site / off-shore coordination by attending daily sync-ups and ensuring the deadlines are met.
• Interactive data visualization products focused on Business Intelligence such as MICROSOFT POWER BI.
• Extract and analyze data using Power Query, PivotTables, MS Excel, and POWER BI.
• Created relationships between tables in Power BI using Star and Snowflake schemas.
• Created Power BI Dashboards using different type of Slicers and different Visualizations like Bar Charts, Line Charts, Graphs, and Pie Charts etc.

Environment: Microsoft SQL Server 2005/2008/2014/2016 , SSIS-2012, SSRS-2012, Power BI, Crystal Reports, Periscope Data, Tableau Server.

Confidential, Dallas, TX

SQL BI Developer

Responsibilities:

• Worked with web application development team, supported the backend to performing frontend enhancements.
• Worked on Full life cycle development (SDLC) of the project involving in all stages of development.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL join for SSRS report.
• Designed and developed ETL process using SSIS to load data from various sources like MS Access and SQL Server
• Created SSIS packages with Error handling, notifications, and package configurations.
• Worked on Control Flow tasks like for each loop, execute process tasks, execute package tasks, script tasks, and Data Flow tasks.
• Deployed SSIS packages for after working on complex enhancements.
• Proficient in MS SQL Server suite of products like TSQL, SSRS, and SSIS of MS SQL Server.
• Proficient in creating SQL Server reports, handling sub reports and defining a query for generating drill down reports using SSRS.
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
• Regenerating reports on weekly or monthly bases using SSRS 2012.
• Evaluated database performance and performed maintenance duties such as tuning, backup, and restoration.
• Involved in Data Modeling to develop the database design using Erwin and created database diagram in MS Visio and SQL Server Management Studio (SSMS).
• Extensive experience in designing, creating and deploying SSIS packages for transferring data and Converted existing DTS packages to SSIS Packages and
• Gained working knowledge of Data modeling, creating a star and snowflake schemas in SSAS.
• Created Dashboards and Ad-hoc reports in Tableau and published on Tableau server.
• Developed complex calculated members, Named Sets using MDX expressions for OLAP reporting requirements.

Environment: SQL Server2014/2016, Enterprise Manager, Query Analyzer, SQL Profiler, Index Tuning Wizard, SSIS, SSRS, SSAS, Visual Studio 2013/2015, Crystal Reports 8.0, Data Analyzer, XML, ASP.Net, MS Word, Excel, SQL Profiler, Azure, Business Intelligence Development Tools, MS Visio

Confidential, White Plains, NY

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, snap shot 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 Power pivot
• 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

Confidential, Woodbury, MN

SQL BI Developer

Responsibilities:

• Analyzed business requirements and build logical data models that describe all the data and relationships between the data.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in SQL Server 2005.
• Validated change requests and made appropriate recommendations. Standardized the implementation of data.
• Promoted database objects from test/develop to production. Coordinated and communicated production schedules within development team.
• 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.
• Involved in the development of a normalized database using Data Definition Language (DDL) in T-SQL.
• Performed job scheduling in the SQL Server Environment.
• Used Data Modification Language (DML) to insert and update data, satisfying the referential integrity constraints and ACID properties.
• Modified database structures as directed by developers for test/develop environments and assist with coding, design and performance tuning.
• Managed user access. Created and managed new security accounts.
• Backup and restore databases.
• Developed and implemented database and coding standards, involved in improving performance and maintainability of corporate databases.

Environment: SQL Server 2000/2005/2008 , T-SQL, DTS Designer, MS-Office, Ms-Excel, VSS

Confidential

SQL Server Developer

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