SUMMARY

• Over 5+ years of experience in Data Modeling, Database Design, Programming, Development and Implementation of Client - Server Applications & Database systems using MS SQL 2008/2012/2014 .
• Proficient in Relational Database Management Systems (RDBMS).
• Expertise in Transact-SQL (DDL, DML, DCL) and in Design and Normalization of the database tables.
• Created and updated database objects like Complex stored procedures, joins, tables, User Defined functions (UDF’s) for business logic.
• Created Clustered and Non Clustered Indexes on tables for performance optimization of complex stored procedures.
• Migrated old data from MS Access into SQL Server 2012 using SSIS Packages.
• Designed and developed ETL packages to validate, extract, transform and load data from OLTP systems to the Data warehouse.
• Worked on all activities related to thedevelopment,implementationand support of ETLprocesses for large-scale Data Warehouses usingSQL Server SSIS.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Worked with control flow and data flow tasks like Containers, Precedence Constraints, and Execute SQL task in SSIS.
• Used Script task for Data Flow and Error Handling in SSIS.
• Extracted, transformed andloadeddata from various heterogeneous data sources and destinations likeAccess,Excel,CSV,Oracle,flat files using connectors,tasksandtransformationsprovided bySSIS.
• Created SSISpackages using Conditional Split, Aggregate, Merge, Multicast, Term extraction Data Conversion, Fuzzy Lookup, Pivot, Lookup.
• Created logging for ETL load at package and task level to log number of records processed by each package and task in a package using SSIS.
• Implementation experience in running and scheduling SSIS.
• Experience in monitoring SQL Server Performance using SQL Profiler, Index Tuning Wizard and Windows Performance Monitor.
• Transformation of data from one server to other servers using tools like bulk copy program (BCP), data transformation services, data conversions from legacy systems to SQL server.
• Hands-on in development ofDrill down ReportsinSSRSand Generateddaily, weekly and monthly reportsfor the manager.
• Developed Sub Reports, Matrix Reports, and Charts usingSQL Server Reporting Services (SSRS).
• Extensive experience deliveringOLAPsolutions by developing Corporate Dashboard ReportsusingSQL Server Reporting Services (SSRS), Report ModelandAd Hoc Reportingusing Report Builder functionality.
• Strong experience in design and construction of data views. Experience in Building Multi-Dimensional Cubes, Data Modeling, and OLAP Cubes using SSAS.
• Involved in building Dimensional Cubes with SQL Server Analysis Services (SSAS) and querying the data with MDX script.

TECHNICAL SKILLS

Operating systems: UNIX, Windows (XP, 7, 8 & 10), IOS

Applications: Visual Studio, Eclipse

RDBMS: MS SQL Server 2008/2012/2014 , MS Access2003/2010

Programming Languages: SQL, T-SQL, MSSQL

Web Technologies: HTML, XML

Productivity Applications: MS Word, Excel, Access

SQL Server Tools: SSMS, Enterprise Manager, Profiler, Query Analyzer, SharePoint

Data warehousing/ ETL Skills: SQL Server Integration Services (SSIS) 2008/2012

BI Reporting Tools: SQL Server Reporting Services (SSRS) 2008/2012, Tableau

Analysis Tools: SQL Server Analysis Services (SSAS) 2008/2012

PROFESSIONAL EXPERIENCE

Confidential, Oak brook, IL

SQL/BI Developer

Responsibilities:

• Experience in working with Business Analyst in order to gather requirements for design and implementation of database.
• Created Data model enhancements and design for different location, supplier, and HR systems to consolidate and provide a single interface to any downstream consuming system.
• Designed and developed SSIS ETL packages to validate, extract, transform and load data from OLTP systems to the Data warehouse.
• Integrated ETL (batch processing) as well as real time processes using web services that were both subscribed and fed as information into the database.
• Experience in Creating Tables, Views, Complex Stored Procedures to facilitate efficient data manipulation, data integrity and other T-SQL (DDL, DML) statements for various applications.
• Experience in creating Packages, Jobs and Experience in migration of Data from Excel, Flat file, Oracle to MS SQL Server.
• Created SSIS packages for Dynamic ETL flow to validate, extract, transform and load data into data warehouse using Aggregate, Sort, Multicasting, Lookup, Fuzzy Lookup, Derived Column, Conditional Split to perform Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Reviewed and fine-tuned stored procedures and triggers before production migration.
• Experienced in creating jobs, Alerts, SQL Mail Agent, and Scheduling SSIS Packages using SQL Server Agent job.
• Created XML and SQL Server package configuration to make package dynamic using SSIS package Configuration Wizard and deploy packages to production Server.
• Designed and developed different type of reports including Tabular forms, Matrix (cross Tab report) form, Conditional, List items, Charts and Sub reports, custom report, Drill down reports using SSIS.
• Developed complex stored procedures using T-SQL to generate Ad hoc reports within SSRS 2012

Environment: SQL Server 2008/2012/2014 , Enterprise Manager, Management Studio, Profiler, Query Analyzer, SQL Server Integration Services (SSIS), SSRS 2008/2012, MS Excel, TFS, Visual Studio.

Confidential, Virginia Beach, VA

Sr.BI Developer

Responsibilities:

• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
• Created and updated database objects like Complex stored procedures, joins, tables, User Defined functions (UDF’s) for business logic.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Experience in Creating and Updating Clustered and Non Clustered Indexes to keep up the SQL Server Performance.
• Created logging for ETL load at package and task level to log number of records processed by each package and task in a package using SSIS.
• Worked with control flow and data flow tasks like Containers, Precedence Constraints, and Execute SQL task in SSIS.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Responsible for ongoing maintenance and change management to existing reports and optimize report performance in SSRS-2012.
• Used Reporting objects like Tabular, Matrix, Sub Reports, Parameterized reports using SSRS 2012.
• Designed and developed monthly, Bi- Weekly, Tax Reports for our Clients.
• Created DSV, Cubes, and Dimensions, MDX for SSAS Reports.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Developed Tableau visualizations and dashboards using Tableau desktop 9.1.
• Reviewed and developed data models and database designs with development teams.
• Interacted with the Business Admin and gather the requirements and analyzed them.

Environment: MS SQL Server Management Studio 2012/2014, Query Analyzer, SQL Profiler, Index Tuning Wizard, MS SQL Server Integration Services (SSIS), TFS, MSSQL Server Analysis Services (SSAS), MS SQL Server Reporting Services (SSRS), Tableau.

Confidential

BI Developer (SSIS/SSRS)

Responsibilities:

• Participated in gathering the business requirements and Database Specifications.
• Install and maintain MS SQL Server 2008. Created databases, tables, indexes, views, triggers, constraints, stored procedures.
• Implemented SSIS packages to load the Data into Staging and dimensional model.
• Created Clustered and Non Clustered Indexes on tables for performance optimization of complex stored procedures.
• Monitored performance and optimized SQL queries for maximum efficiency.
• Created indexed views and appropriate indexes to reduce the running time for complex queries.
• Transferred data from flat files, Excel spreadsheets and heterogeneous data to SQL Server using DTS and also used BCP and Bulk Insert and even the other way.
• Filtered and cleansed bad data from legacy system using complex T-SQL statements in staging area, and implemented various constraints and triggers for data consistency.
• To keep track of data manipulations using Audit functionalities.
• Generated custom and parameterized reports using SSRS.
• Configuration and Deployment of all the Reports (RDL, RDS) across various SDLC environments.
• Actively involved in developing Complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs.
• Responsible for creating datasets using T-SQL and stored procedures.
• Scheduled the packages to keep extracting the data from OLTP at specific time intervals.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Responsible for rebuilding the indexes as part of performance tuning.
• Designed, deployed, and maintained various SSRS Reports in SQL Server 2008.
• Scheduled Reports to run the reports Hourly, Daily, Monthly According to End user requirements.
• Worked with DBA Team and Data Warehouse Team to perform data imports on a scheduled basis usingSQLScripts and also SSIS Packages.
• Responsible for version control of all Database Objects like Tables, Stored Procedures, Views, Functions using Visual Studio.

Environment: SQL Server 2008, Windows Server 2008/2008 r2, T-SQL, SSMS, SQL Profiler,Visual Studio 2008, Business Intelligence Development Studio (SSIS, SSRS), MS Office 2007, DTS.

Confidential

Jr. SQL Developer

Responsibilities:

• Involved in translating business requirements into technical design specifications.
• Followed the different phases of Data Warehouse development lifecycle (converting business requirements to logical design and translation to physical design)
• Designed and implemented stored procedures, views and triggers for automating tasks in T-SQL.
• Created permanent tables, temporary tables, variables and indexes.
• Created Complex Stored Procedures, User Defined Functions, Views, and Alter, Insert, Update statements for the User Interface, Reports and SSIS Packages.
• Developed and executed several optimized queries in SQL.
• Involved in the tuning of the existing Database Objects.
• Developed and tested ETL Packages usingSQL Server 2008 BIDevelopment tools - Integration Services & Reporting Services
• Designed and developed various SSIS packages to import data from Excel and Flat files to SQL Server 2008.
• Prepared Documents of each process involved, developed complex stored procedure using T-SQL to generate reports using SSRS 2008.
• Involved in writing scripts and transactions to manipulate data in the database.
• Involved in documentation of Reports, SSIS Packages, Tables, Triggers, Stored Procedures, and User Defined Functions.

Environment: Windows server 2008, MS SQL server 2008, MS SQL Server 2008, Windows 7, SQL server management studio, SQL server Data Tools, SQL Server Integration Services (SSIS), MS Reporting Services, T-SQL, MS Excel 2007, MS office 2007.