SUMMARY:

• 8 years of IT experience in data design and development on Microsoft SQL Server 2016/2014/2012/2008, T - SQL, Performance Tuning, Troubleshooting, SSIS, SSRS, SSAS and Data-warehousing.
• Experience in managing and automating control flow, data flow, event management and logging programmatically using .NET framework for SSIS packages.
• Accomplished in developing dynamic packages and implementing ETL design for incremental loads and data cleaning in data warehousing using SSIS.
• Intensively worked on system analysis, design, development, testing and implementation of projects (SDLC) and capable of handling responsibilities independently as well as proactive team member.
• Worked on all activities related to high level design of ETL for integrating data from multiple heterogeneous data sources (Excel, CSV, Flat File, Text format Data) using SSIS.
• Proficient in Creating Dynamic reports, creating jobs, scheduling, alerts, SQL mail Agents, restore and back up of database using SSIS.
• Expert in Designing Ad hoc reports and different types of Cross tabs, Tabular Reports, Matrix reports, Drill Down reports, Drill Through Reports, parameterized reports in multiple data sets and creating charts using SQL Server Reporting Services 2016 (SSRS) in Data tools.
• Strong knowledge of Data Warehousing methodologies and concepts, including star and snow flake schemas, ETL processes, dimensional modeling and reporting tools.
• Extensive hands on experience in data warehouse maintenance, troubleshooting and automation of reports using complex TSQL queries and writing high level stored procedures.
• Experienced with analyzing heterogeneous data and apply business validations in various domains like Healthcare, Insurance and manufacturing environments.
• Extensive knowledge and experience in dealing with relational database managements systems, data base normalization, writing complex stored procedures, working with Entity Relational diagrams.
• Profound knowledge and good command with T-SQL statements in constructing triggers (DDL & DML), tables, applying constrains, variables, stored procedures, functions, views, User Defined Functions (UDF), and maintaining data integrity throughout the business environments.
• Experienced in monitoring, creating and updating Clustered Indexes using Index tuning Wizard, SQL profiler and Windows Performance Monitor to increase the ability to maintain SQL server performance tuning and query optimization.
• Expert knowledge of data extraction, transforming and loading (ETL) using SQL Server integration services (SSIS).
• Expert in designing of complex reports using SQL Server Reporting Services (SSRS) and excel pivot table based on OLAP cubes which make use of multiple value selection in parameters pick list, cascading prompts, matrix dynamic report and other features of reporting services.
• Developing reports on SSAS & SSRS on SQL Server ( 2016/2014/2012/2008 (R2)). Sound Experience and understanding of SSAS, OLAP cube and Architecture.
• Good Knowledge in managing Data and Transaction log files, Files Groups. Hands on experience in troubleshooting database issues.
• Experience in Developing and Extending SSAS Cubes, Dimensions and data source views SSAS-Data Mining Models, Deploying and Processing SSAS objects.
• Created complex SSAS cubes with multiple fact measure groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Created calculated measures and dimension members using Fact Tables and multi-dimensional expression (MDX) Tables.
• Creating and Maintaining Users roles groups and granting the privileges to users and Groups and maintaining security up to date.
• Excellent Communication and interpersonal skills and strong ability and experience in seeking solutions effectively and aggressively in challenging environments.

TECHNICAL SKILLS:

Database Tools: SQL Server Management Studio, Query Analyzer, Business Intelligence Development Studio, SQL Profiler

ETL Tools: SQL Server Integration Service (SSIS)

Reporting Tools: SQL Server Reporting Services ( 2016/2014/2012/2008 (R2)/2008,), MS Access, MS Excel.

Database: MS SQL Server 2016/2014/2012/2008, MS Access.

Programming: T-SQL, PL SQL, MySQL,Java.

Web Technologies: Html,Css, C#.

Other Tools: MS Office Suite (Microsoft Word, Power Point, MS Visio), ERwin, Visio, Team Foundation Server.

PROFESSIONAL EXPERIENCE:

Confidential, St. Louis, Mo

SQL BI Developer

Responsibilities:

• Optimized the performance of queries with modification in T-SQL queries, normalized tables, established joins and created indexes wherever necessary.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Responsible for creating constraints, Indexes, and Views.
• Extensively designed the packages and data mapping using Control flow task elements, Sequence container task, Dataflow Task, Execute SQL Task, For Each Loop Container, For Loop Container and Script Task in SSIS Designer.
• Experience in using different transformations like fuzzy lookup, derived column, Look up, Row count, OLEDB Command, Data conversion task transformations in SSIS
• Used various ETL tools like SSIS/DTS for data flow from source files like Excel, Tables, and Views to other databases or files with proper mapping.
• Experience in creating complex SSIS packages using proper control and data flow elements with error handling.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Loading data from various sources like Excel, flat files, to SQL Server database Using SSIS Package
• Using SSIS, building high performance data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing and also Scheduling the SSIS packages and Jobs
• Involved in daily loads (Full & Incremental) into Staging areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS) .
• Responsible for Deploying the SSIS packages and scheduling the package through Jobs in all Tiers including Dev, UAT and Prod, Setting the Configuration files which is done in the specified tables and created technical specs documents for all the enhancements.
• Converted Data Transformation Services (DTS) application to SQL Server Integrated Services (SSIS) as assigned.
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Performed data conversions from Flat files into a normalized database structure.
• Developed, modified, and optimized complex stored procedures, triggers to handle complex business rules, history data and audit analysis
• Designed SSRS reports using Single Value Parameters, Multi Value Parameters, and Cascading Parameters.
• Developed Queries for generating drill down, drill through reports in SSRS 2016.
• Created Sub-Reports, Drilldown-Reports using MS SQL Reporting Services (SSRS).
• Developed Queries for generating drill down, drill through reports in SSRS.

Environment: Windows 10, MS SQL Server 2016, SQL Server Management Studio (SSMS), T-SQL, SQL Server Report Services (SSRS), Microsoft Excel, Team Foundation Server (TFS).

Confidential, Wilmington, DE

MS SQL Server SSIS/SSRS Developer

Responsibilities:

• Created SSIS packages for Uploading of different formats of files (Excel, Access, dbf) and databases (SQL server, Flat files) into the SQL Server data warehouse using SQL Server Integration Services (SSIS).
• Extensively involved in designing the SSIS packages to export data from flat file source to SQL Server database.
• Created Report application to provide and view mortgage and loan payment history using SQL Server SSRS in SQL server 2014.
• Created SQL Jobs to schedule SSIS Packages.
• Imported the data from flat files and were transformed and placed in DB2, Teradata Databases as they were the target databases.
• Experience in using T-SQL for creating stored procedures, indexes, cursors and functions.
• Designed SSRS reports with Cascaded Parameters, Gauges and Interactive Charts, Tablix etc.
• Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS Visual Studio 2014.
• Creating Reports as per user requirements using MS Visual Studio 2010, Created different types of reports such as Cross-Tab, Drill-down, Drill Through and Sub reports.
• Implemented clustered and non-clustered index to improve performance.
• Used SQL Profiler to improve and implement performance turning for stored procedures and user defined functions.
• Working with complex SQL Stored Procedures, Triggers, cursors, and packages in large databases from various servers.
• Collecting requirements from business users and transforming them into logical and physical database designs.
• Loaded mortgage and loan payment history to data warehouse environment.
• Create and maintain clearly written technical, user, and system documentation.
• Scheduling & Maintaining ETL packages in terms of data validation and consistency.
• Created SSIS packages with error handling abilities.

Environment: MS SQL Server 2014, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Visual Studio 2014, T-SQL.

Confidential, Richmond, VA

SQL BI Developer

Responsibilities:

• Using SSIS built high performance data integration solutions, including extraction, transformation and loading (ETL) packages for data warehousing.
• Involved in implementing SSIS package security, protecting packages, executing, monitoring and managing them.
• Extracted the data from Oracle, Flat Files, transformed (Implemented required Business Logic) and Loaded into the target Data warehouse using SSIS.
• Experience in enhancing and deploying the SSIS Packages from development server to production server.
• Created T-SQL stored procedures, functions, tables, views and SQL joins and other statements for various applications, maintained referential integrity and implemented business logic.
• Designed and developed efficient SSIS packages for processing fact and dimension tables using transformations like Fuzzy lookup, lookup, merge, merge join, script component and Slowly changing dimension .
• Extensively designed the packages and data mapping using Control flow task, Sequence container task, Dataflow Task, Execute SQL Task, Data conversion task, Derived Column task and Script Task in SSIS Designer.
• Responsible for Deploying the SSIS packages and scheduling the package through Jobs in all Tiers including Dev, UAT and Prod, Setting the Configuration files which is done in the specified tables and created technical specs documents for all the enhancements.
• Designed different type of reports including: Tabular forms, Matrix (cross Tab report) form, List items, Charts and Linked reports.
• Designed SSRS reports using table filters, single value parameters, multi value parameters, and Cascading Parameters.
• Created Sub-Reports, Drilldown-Reports, and Cross Tab reports using MS SQL Reporting Services (SSRS).
• Experience in creating Ad-hoc and static reports using SSRS (SQL Server Reporting Services) from BIDS.
• Good understanding of Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.
• Experience in integrating Share Point Server with SSRS and deploying SSRS reports on to Share Point Server.
• Development of automated daily, weekly and monthly system maintenance tasks such as database backup, database integrity verification, indexing and shrinking of databases and regular monitoring.
• Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions in SQL Server.

Environment: MS SQL Server 2014, SSIS, SSRS, SSAS, T-SQL, OLAP, OLTP, Share Point server, ETL, MS Office 2008.

Confidential, Bowie, MD

SQL Server BI Developer

Responsibilities:

• Developed Stored Procedures in SQL Server 2012 and modified existing stored procedures as needed.
• Developed Stored Procedures, functions and database triggers and maintained referential integrity and implemented complex business logic.
• Designed and created views for security purposes, implemented rules, defaults, and user defined data types.
• Involved in optimizing the procedures and triggers to be used in production and also involved in Performance tuning and Query Optimization.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and T-SQL code from developers and QA.
• Created List reports, Standardized Reports, On-Demand Reports, Cross tabs Reports, Drill-down Reports, Ad hoc Reports, Charts, Functions and Formulas using SQL Server Reporting Services (SSRS).
• Developed drill down/Tree view report, Drill through reports and sub reports for organizing and efficient display of data.
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server 2014/2012.
• Conditional formatted the reports for applying different styles to report items or properties, based on the data.
• Custom coded the report as per the necessity by embedding the code directly in the report.
• Experience with using Team Foundation Server (TFS).
• Deployed the reports and Created subscriptions for the reports in report manager.
• Developed data extraction and output specifications for reports based on analysis of end user’s requirements.
• Gathered specifications from internal customers to understand requirements, analyze data and provide valid report designs.
• Worked on parameters to generate cascaded parameterized reports along with that extensively used global variables, expressions and functions.
• Implemented report subscriptions and methods for report distribution based on agreed timelines and according to specifications.
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Experience in creating packages to transfer data between ORACLE and FLAT FILES to SQL SERVER using SSIS
• Created Package for capturing error data, sending the error data in flat file attached to the corresponding mail ids using Sent Mail Task, and correcting error data.
• Created Jobs in SSIS and was responsible for ETL job scheduled to run daily. Solved the issues associated with ETL Data Warehouse Failure.
• Designed and developing SSIS packages using different transformations like Conditional Split, Multicast, Union-All, Merge, Merge Join and Derived Column.
• Utilized event handling effectively to generate audits and logs for the generated packages.

Environment: Windows 10, MS SQL Server 2012, SQL Server Management Studio (SSMS), T-SQL, SQL Server Report Services (SSRS), Microsoft Excel, Team Foundation Server (TFS).

Confidential

MS SQL SERVER DEVELOPER

Responsibilities:

• Created Tables, indexes and constraints.
• Created backups for databases.
• Created T-SQL stored procedures, functions, tables, views and SQL joins and other statements for various applications, maintained referential integrity and implemented business logic.
• Optimized SQL statements for customer summary reports.
• Monitored user accounts, user permissions and backup.
• Involved in analysis and Design Documentation, User Requirements and maintained good documentation.
• Developed physical data models and created DDL scripts to create database schema and database objects.
• Used T-SQL to create various queries.
• Carried out a Developer’s role on MS SQL Server 2008, MS Access Databases (Stored Procedures and Views).
• Involved in designing and implementing the Stored Procedures and Triggers for automating tasks.
• Daily Database backups and integrity checking.
• Developed SQL Scripts to Insert/Update/Delete data, satisfying the referential integrity constraints.
• Partly involved in Performance Tuning.
• Performance tuning to optimize SQL queries using query analyzer.

Environment: MS SQL Server 2008, MS Access,Team foundation service, sharepoint 2010.