SUMMARY:

• A skilled software professional with 8 years of experience in SQL Development, Data Warehousing, Reporting and Business Intelligence solutions using MS SQL Server 2014/2012/2008 R 2/2008/2005.
• Experience with focus on Database design and Development using different tools of ER diagram, Normalization techniques, T - SQL (DDL and DML) Coding and installing, upgrading, configuring and implementation of SQL Server 2014/2012/2008 R2/2008/2005 on Windows Environment.
• Extensive experience in BI/ETL development using SSIS, SSRS and T-SQLusingSQL Server 2014/2012/2008 R2
• Experience with Microsoft .NET, C# development, BI tools, Windows services and web services.
• Experience in migrating DTS Packages to SSIS, migrating databases from SQL 2005 to SQL 2012/2008, and troubleshoot migration issues, Importing and exporting packages to SQL Server.
• Created a database fordatawarehousing in SQLand implemented an ETL process in
• SSIS to load data into the data warehouse with robust logging and exception handling.
• Handled hugefinancialdata, expert level query optimization and performance tuning experience.
• Experience in managing and automating Control flow, Data flow and Events using Microsoft .NET framework for SSIS packages.
• Experience in providing Error handling by using Event handler, and custom logging for SSIS packages and performance tuning in SSIS packages by using Row, Block and Unblock transformations.
• Created SSIS Packages for integrated data using OLE DB connection from sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union.
• Expertise in Developing and Extending MS SQL Server Analysis Server (SSAS) Cubes, Data mining models, Deploying and processing SSAS objects.
• Created and Designed data Source Views and also configured OLAP Cubes usingSSAS.
• Experienced in Enterprise data modeling (Dimensional & Relational) with a solid understanding of the data modeling concepts like Star-Schema modeling, Snowflakes modeling, and fact and dimension tables modeling of data.
• Created SSAS Tabular semantic model in directquerymode with multiple partitions, KPI's, hierarchies and calculated measures usingDAXas per business requirements.
• Proficient experience in deploying and configuring packages, Error handling and Batch logging, Check points and troubleshooting Reports using SSRS
• Developed Report Models using Report Builder and distributed Reports in Multiple Formats using Reporting Services (SSRS) in Business Intelligence Development Studio (BIDS).
• Created Parameterized Reports, Sub Reports, Drill Through, and Drill down Reports in SSRS and Ad-hoc reports using Report Builder.
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and MS Excel format using Reporting Services (SSRS).
• Involved in T-SQL programming and creating complex stored procedures, triggers, views and functions on SQL 2014/2012/2008 R2/2008 Servers to meet the requirement of the applications.
• Hands on experience in SQL performance tuning by query optimization, building database maintenance plans and database consistency check using DBCC commands.
• CreatedPL/SQLstored procedures, functions and packages for moving the data from staging area to data mart design development and testing ofETL using SSIS processes to in corporate source data into the Enterprise Data Warehouse.
• Experienced in creating complex mappings using various transformations, and developing strategies for Extraction, Transformation and Loading (ETL) mechanism using Informatica.
• Monitored and provided support for QA/Test environments for projects, maintenance requests, bug fixes, enhancements, data changes.
• Strong individual contributor and a good team player with proven ability and excellent verbal and written communication skills to interact with clients and peers.

TECHNICAL SKILLS:

Operating System: Windows Server 2003/2008/2008 R2, UNIX

Languages: Visual Basic 6.0, Visual Studio 2005/2008/2010 , ASP 3.0, VB.Net, C, C#.Net, HTML, JavaScript, T-SQL, PL/SQL

Data WareHouse Tools: BIDS (SSIS, SSAS, SSRS), Query Analyzer, Power BI

Databases: MS Access, MS SQL Server 2012/2008/2008 R2/2005, Oracle 9i

Tools: /Utility: Enterprise Manager, SQL Server Management Studio(SSMS), Database Tuning Advisor, DTS, Analysis Manager, SQL Profiler

Other Tools: MS Excel, Visio 2007, Informatica 7.1.1

Reporting Tools: SQL Server Reporting Services 2005/2008/2012 , Tableau 7.1

Version Control: Visual Source Safe(VSS)6.0, TFS

PROFESSIONAL EXPERIENCE:

Confidential, Jersey City, NJ

BI/SQL Server Developer

Responsibilities:

• Involved in complete SDLC requirement specifications, analysis, design development and testing business requirements.
• Maintenance of reports for marketing user group, which involved changes to the ETLs and Store Procedure.
• Data analysis of current market trends and research on targeted user groups, and development of reports helping marketing group on investment decisions.
• Resolved several SQL query performance issues by examining execution plans, tuning indexes, creating plan guides, and adding hint options.
• Migrating databases fromSQLServer 2005/2008R2 toSQLServer 2012/2014.
• Responsible for ETL Operation which extracts the data from heterogeneous sources to relational data warehouses and staging databases using complex stored procedures and SSIS.
• Developed dynamic packages using SSIS and Implemented incremental data loading.
• Created complex T-SQL Queries, Stored Procedures, Indexes, Functions, Views and Triggers to support efficient data storage and manipulation.
• Created traces using SQL server profiler to find long running queries and modify those queries as a part of Performance Tuning operations.
• Created SQL agent Jobs and Sending Alerts using SQL Mail, database backup, Recovery and Disaster recovery procedures.
• Created different schedules for report delivery to e-mails and shared directories; enabled snapshots, subscriptions, caching to improve the response times and reduce traffic to the report server.
• Created various ad-hoc SQL queries for customer reports, executive management reports and types of report types like tables, matrix, sub reports etc.
• Worked on transformations like Execute SQL Task, Execute Package Task and conditional split, Script Component, Merge and Lookup while loading the data into Destination.
• Analyze access patterns and propose the best combination of indexes, constraints, foreign keys, Primary keys and queries.
• Loading data from various sources like OLEDB, flat files to SQL Server database using SSIS Packages and created data mappings to load the data from source to destination.
• Used SQL Loader utility, PL/SQL Packages for Data extraction from Legacy to Oracle Database.
• Created reports inSSRSwith different type of properties like Chart controls, filters, Interactive Sorting,SQLparameters etc.
• Experience in configuring and deployingSSRSreports onto Microsoft Office SharePoint Server.
• Created interactive dashboards in PowerBIreports that were presented to Business users, Program managers, and End users.
• Transformed and merged data as per the requirement for ease of analysis in Excel by using Power Query in PowerBI.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.

Environment: MS SQL Server 2014/2012/2008 R2, PL/SQL, SSDT, SISS, SSRS, ETL, DB2, SQL Profiler, Share Point Server, C# .net, Power BI

Confidential, Nashville, TN

SQL/SSIS/SSRS Developer

Responsibilities:

• Involved in creation of functional requirement specifications and supporting documents for business systems, experience in database design process and data modeling process.
• Created Triggers to implement the User defined integrity to authenticate the transactions as per the business logics.
• Migrated SQL Server 2005 databases to SQL 2008R2/2012databases.
• Enhanced the functionality and performance of various SQL scripts and stored procedures by using UDFs, CTEs and system stored procedures along with usage of SQL Profiler.
• Analyzed different heterogeneous sources like DB2, Excel, Flat Files and SQL Server for ETL strategy that needs to be implemented with the help of SSIS packages.
• Implemented proper package configuration features and finally securing the packages by using password and encryption methods.
• Responsible for the management and migration of SSIS packages in the staging and pre-production environments.
• Designed several packages to schedule maintenance tasks, as well as to process SSAS cubes, and to import files from several location to the warehouse.
• Involved in writing MDX queries and performance optimization of theSSAScubes.
• Created report models from cubes and data warehouse to create ad-hoc reports and chart reports using Report Builder.
• Created Sub-Reports, Drilldown-Reports, Summary reports, parameterized reports, cascaded reports in SSRS by linking aggregate data to support summarized view as well as detailed view.
• Managed very large reports that return a huge volume of records and optimized their performance using techniques like cascading parameters and filters.
• Scheduled the delivery of reports in different formats such as PDF, Excel, using standard and data driven subscriptions in SSRS to generate all daily, weekly, monthly and quarterly reports including current status.
• Enhanced the old Excel files and Crystal Reports to new SQL Server Reports to fit new business requirement and implemented into SQL Server.
• Created Share Point solution to hostPowerBIMonitoring dashboards to indicate claims spend to date and visualization according to the requirements.
• Extensively used data blending, embed functionalities inTableau.
• DeployedTableauServer in clustered environment by mapping server nodes to primary machine.
• CreatedTableauscorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.

Environment: SQL Server 2012/2008R2/2008/2005, BIDS, SSIS, SSAS, SSRS, DB2, HealthCare database, SharePoint, Power BI, Tableau Server 7.1

Confidential, Iselin, NJ

BI Developer

Responsibilities:

• Created various database objects (tables, indexes, views, stored procedures and triggers) and implemented referential integrity constraints for enforcing data integrity and business rules.
• Designed and implemented processes for deploying, upgrading, managing, archiving, and extracting data for reporting.
• Advised optimization of queries by looking at Execution Plan for better tuning of the database.
• Responsible for rebuilding the indexes and tables as part of performance tuning.
• Extract, Transform and Load (ETL) source data into respective target tables to build the required data marts.
• Created SSIS packages for prophet application that would transfer data among servers and perform other data transformations.
• Experience in creating complexSSISpackages using proper control and data flow elements with error handling.
• Tested, Cleaned and Standardized data meeting the business standards using Fuzzy/exact lookups usingSSIStasks.
• Created SSIS Packages to pull data from SQL Server and exported to Excel Spreadsheets and vice versa.
• Fine-tuned SSIS packages, SSRS reports and stored procedures that take long time for execution.
• Created Cross-tab, Drill-Down, Drill-Through and Sub-Report using RDL, promoted RDLs to Reporting Service server.
• Deployed and uploaded the SSRS reports to SharePoint Server for the end users and involved in enhancements and modifications.
• Created expressions in SSRS to provide flexibility to users by providing them with variety of options for seeing the business information in tables/charts etc.
• Developed reports using complex formulas and to query the database to generate different types of ad-hoc reports usingSSRS.
• Created the dataset in SSRS for calling the stored procedures and passed the parameters to the dataset.
• Involved in designing partitions in Cubes on time for Improvement in performance using SSAS.

Environment: MS SQL Server 2012/2008/2005 , SSIS, SSRS, T-SQL,ETL, SharePoint Designer 2010, Visual Studio 2010, MS Office 2007.

Confidential, Columbus, OH

SQL/SSIS Developer

Responsibilities:

• Effectively used SDLC methodologies to define the project; this included defining business and technical requirements and specs.
• Designed and planned specifications for coding & unit testing, integration as well as maintenance.
• Created several materialized views, stored procedure, indexes, joins and UDF’s to be accessed by the new front end applications.
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration.
• Conducted Performance tuning/MS SQL server development - SQL Profiler and Performance monitor, SQL scripts, replication, stored procedures, triggers, functions and transactions analysis.
• Performed all aspects of database administration, including data modeling, backups and recovery.
• Configured SSIS packages using Package configuration wizard to allow package run on different environments.
• Experience in SSIS script task, look up transformations and data flow tasks using T- SQL and VB scripts.
• Involved in ETL Loads using DTS Packages from various heterogeneous source systems into the databases for Dashboard Reporting on a daily basis
• Implemented Error handling and utilized Event handlers for automated notifications using SSIS.
• Experience with SSRS to author, manage, and deliver both paper-based and interactive Web-based reports.
• Scheduled Cube Processing from Staging Database Tables using SQL Server Agent.
• Created partitions and designed various storage modes to increase the performance of cubes using SSAS.
• Migrated and recreated existing Dimensions and Cubes using Star schema on 2008 Server to achieve the efficiency of SQL Server Analysis (SSAS).

Environment: MS SQL Server 2008R2, SSRS, SSIS, SSAS, SQL Query Analyzer, SQL profiler, Enterprise Manager, SSMS, Windows 2003 Server, ETL, TFS, HealthCare database, Oracle 9i

Confidential

SSIS/SSRS Developer

Responsibilities:

• Developing Stored Procedures and Functions used for inserting, updating, or transforming data.
• Developing complex T-SQL queries used for data investigation.
• Creating table indexes and constraints to ensure data integrity and enhance query processing.
• Sourced data from various types of relational databases, flat files, excel files.
• Developed SSIS packages with various tasks like - FTP, file system, for each loop, execute package, data flow task, execute SQL task, custom script task, data mining task.
• Creating SSIS packages for transforming data from warehouse to mart, to import data from source systems, or transfer data from one server to another.
• Created new reports from the scratch for new requirement and modifies some of the existing reports using SSRS.
• Provided documentation of reports and the development process in order to support the system.
• Fine-tuned SSRS reports, SSIS packages and stored procedures that take long time for execution.
• Created requirement documents, technical design documents and knowledge sharing documents.
• Involved in complete Software Development Life Cycle (SDLC) including system study, interaction with users & management, designing, coding, testing and deployment of the system.
• Created expressions in SSRS to provide flexibility to users by providing them with variety of options for seeing the business information in tables/charts etc.
• Creating data sources and subscriptions for SSRS reports.

Environment: MS SQL Server 2008, T-SQL, SSIS, SSRS, Business intelligence development studio (BIDS), Excel, OLAP, OLTP, Windows 2003 server.

Confidential

SQL Server Developer

Responsibilities:

• Involved in various stages like development, system Analysis and design, and creating stored Procedures.
• Designed and developed Interfaces which were used for connecting to SQL Server database.
• Validated and coded the application using VB.
• Designed the Logical and Physical databases of SQL Server.
• Performed database testing & maintaining the data by using the procedures.
• Designed and validated the forms according to client requirement by using VB.
• Created DTS packages to get data from different sources, consolidate and merge into one single source.
• Imported and Exported database using DTS utility.
• Wrote SQL stored procedures to implement business logic.
• Developed and coded applications in T-SQL.
• Designed a report on the monitoring of Server Performance using Task Manager and Performance monitor
• This report gives a detail report to the management on the Performance of the server.
• Maintained SQL Script for creation of Database Objects.

Environment: SQL Server 2008, SQL Enterprise Manager, Windows 2003, MS Access, MS Excel, VBScript, DTS.

Confidential

SQL Server Developer

Responsibilities:

• Requirements gathering.
• Involved in design, development and testing.
• Created classes/modules in C# using Visual Studio.Net.
• Developed web services, user interactive web pages for viewing/purchasing movie tickets using ASP.Net / C#.
• Applied CRUD (Create, Retrieve, Update, Delete) operations on the SQL Server database through ASP.Net using ADO.Net.
• Implemented Stored Procedures, Triggers, and Views in SQL Server 2005.
• Maintained code check-in /check-out efficiently using Visual SourceSafe (VSS).

Environment: MS SQL server 2005, C#.Net, ADO.Net, HTML, JavaScript, MS-SQL, VSS.