SUMMARY

• Over 6 years of experience with database development and business intelligence applications as a BI developer.
• Strong Communication & Management skills with excellent role - playing capabilities.
• Experience with strong skills in MS SQL Server2012/2008R2/2008/2005 including Microsoft Business intelligence tools like SSIS and SSRS.
• Experience in writing and executing complex queries in Database such as Stored procedures, Functions, Triggers, Cursors, Joins, PL-SQL, T-SQL.
• Thoroughly involved in the various phases of SDLC including waterfall and agile models.
• Worked on optimizing different databases by integrating SQL Server DBAs, architects, and application developers.
• Worked on business requirements, designing & implementation of ETL strategies.
• Extensive experience in Writing Transact SQL (T-SQL) Queries, Dynamic-queries and implementing SQL Server Indexing.
• Good experience in using performance monitor/SQL profiler for handling Performance Tuning of long running queries and dead lock issues.
• Involved in unit testing, performance, and system testing.
• Excellent ability to solve adhoc requests with ease in the project and execution, troubleshooting and fixing errors as required.
• Developed ETL packages using SSIS with various transformation tasks.
• Experience in using Precedence Constraints, Break Points, Check Points, and Logging using SSIS.
• Good experience in designing and scheduling complex SSIS Packages for data migration from various sources like SQL Server, Oracle Database, Excel, and Flat file.
• Experience with SSIS performance tuning using counters, error handling, event handling.
• Worked extensively on SSRS reporting tools using various reports such as Charts, Drill Down, Drill-Through Filters, Reports, Multi-valued parameters, Sub-Reports, SSRS tabular, matrix reports.
• Experience in Performance Tuning in SSIS packages using Block and Unblock Transformations.
• Extensively used SSIS transformations such asMerge, Derived column, Data conversion, Aggregate, Conditional split, Multicast, Union All, Sort, Fuzzy lookups, and Lookups.
• Worked on designing SSRS reports based on the project requirement.
• Working experience on mainframe file uploads and downloads.
• Experience on troubleshoot of various packages during execution.
• Troubleshoot of issues related to package configurations and connection managers.
• Worked on various connection managers, control flow tasks and data flow tasks.
• Involved in database backup and restorations in SQL Server.
• Configured Package security by providing password protected

TECHNICAL SKILLS

Relational databases: SQL Server 2016/2 R2/2008/2005, Oracle11g/12c.

ETL Tools: SQL Server Integration Services (SSIS), Import Export Data, Data Transformation Services (DTS)

Database Tools: SQL Server Enterprise Manager, Query Analyzer, SQL Profiler, SSIS, SSAS, SSRS, DTS, ODBC, SQL OLEDB, DBCC, ADO.NET, Business Intelligence Studio, SSRS Reports.

Reporting Tool: SQL Server Reporting Service (SSRS)

Languages: T-SQL, PL/ SQL, C, VB.Net, CSS, JavaScript.

Web Technologies: HTML, XML.

Operating systems: Windows98/NT/2000/XP, Windows Server 2003/2008.

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

SQL /MSBI Developer

Responsibilities:

• Upgraded SQL Server 2014 to SQL Server 2016 and migrated data from old systems to new systems.
• Worked with Business requirements analyst to identify and understand source data systems and Developed Mappings between source systems and warehouse components.
• Involved in developing database objects such as procedures, triggers, constraints, indexes, and views using SQL Server 2016.
• Involved in development and implementation of SSIS, SSAS and SSRS application solutions for various business units across the organization.
• Used SSRS to create Customized, Sub-Reports, Drill down/Drill Through, Summary Reports, Parameterized, on-demand, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Created various complex reports and manage those using SQL Server Reporting Services (SSRS ).
• Created Tabular reports, Matrix reports, List & Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment.
• Created SSIS packages to extract data from OLTP and transformed to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Created reports using SSRS from OLTP and OLAP data sources and deployed on report server.
• Created Jobs, Alerts and scheduled DTS Packages and SSRS to generate reports.
• Documentation of Technical specification, business requirements, functional specifications for the development of Informatica Extraction, Transformation and Loading (ETL) mappings to load data into various tables.

Environment: SQL Server 2016/2014/2012 , SSRS, SSIS, SSAS, BCP, DTS, SQL Mail, SQL Server Management Studio, T-SQL, XML, MS Excel, and MS Access, DTS, visual studio 2005/2008/ 2012 , TFS 2008/2010

Confidential, Boston, MA

SQL /MSBI Developer

Responsibilities:

• Actively participated in interaction with users, team lead, and DBA’s and technical manager to fully understand the requirements of the system.
• Writing queries to create stored procedures, User Defined Functions, Views, Triggers and CTEs (Common Table Expressions).
• Using all kinds ofSQLServer Constraints (Primary Keys, Foreign Keys, Defaults, Check, Unique etc.)
• Writing Complex T-SQLQueries, Sub queries, Co-related sub queries and DynamicSQLqueries.
• Created logins, users and configuring permissions and assigning roles to users.
• Created indexes on selective columns to speed up queries and analyses inSQLServer Management Studio.
• UsedSQLServer 2005 to design, implement and manage data warehouses OLAP cubes and reporting solutions to improve asset management, incident management, data center services.
• Created new SSIS package to extract date from legacy toSQLServer Objects using Business Intelligence Development Studio (BIDS) and Visual studio 2008.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases and data mart databases.
• Developed SSIS Templates which can be used to develop SSIS Packages in such a way that they can be dynamically deployed into Dev, Test and Production Environments.
• Generated reports using SSRS and Excel (Pivot) that could be used to send information to diverse group of users, clients, and managers.
• Responsible for creating the reports based on the requirements using SSRS 2008.

Environment: MSSQL Server 2005/2008, SSIS, SSRS, BIDS, Visual studio 2008, MS Visio 2007 and XML.

Confidential

SQL BI Developer/SSIS Developer

Responsibilities:

• Involved in the development of SSIS Packages & SSRS reports using BIDS
• Created and executed SQL Server Integration Service (SSIS) packages to populate data from the various data sources, created packages for different data loading operations for different applications.
• Developed Stored Procedures, Functions, Triggers, Tables, Views, SQL joins and statements for applications using T-SQL.
• Used CTEs for recursive functionality to bring the organization structures.
• Built table valued functions, scalar valued functions to suffice the needs for business rules and for the implementation in stored procedures.
• Created new jobs or using the existing jobs, reviewing the results to determine success/failure, documents success/failure, troubleshoots failures, provides up-to-date communication, and maintains documentation.
• Designed dimension modeling for data warehouse. Developed data warehouse to generate OLAP cubes and identified measures and dimensions according to different requirements.
• Extensive experience in Extracting, Transforming and Loading (ETL tools) using SSIS, DTS, Import/Export Data, Bulk Insert, BCP, DTS Packages and SSIS packages.
• Created reports using SSRS from OLTP and OLAP data sources and deployed on report server.
• Created user defined functions in SSRS using VB script.
• Worked on row and column grouping, filtering, and sorting the data in the repots using SSRS.

Environment: MS SQL Server 2005/2008, MS Reporting Services 2005/2008, SQL Server Integration Services 2005, T-SQL, Windows Server 2003, Windows XP Professional, MS Excel 2003, Team Foundation Server.

Confidential

SQL/SSIS Developer

Responsibilities:

• Worked extensively on the major enhancements to the dotnet existing code.
• Design and execution of SQL queries, stored procedures, functions, and indexes.
• Worked on Database tables, views, joins for analyzing the data.
• Prepared the technical documentation for the new business requirements for the upcoming portal enhancement.
• Delivered the project required targets weekly on time and given extensive trainings to the new joiners in the project.
• Involved in Design, Development, and maintenance of new Installs and Existing SSIS Packages, including creating technical specifications for new SSIS requirements.
• Analyzed the requirements and framed the business logic for the ETL process.
• Developed T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server 2008 from different environments.
• Implemented complex business requirement in backend using efficient stored procedures and flexible functions and facilitated easy implementation to the front end of the application.
• Loading source files into raw tables for data mining and data ware housing tasks.
• Used Merge function to check against old records and load only new records.

Environment: SQL Server 2008/2005, SSIS, SSRS, T-SQL, VB Script.Net, MS-Excel, Visual Studio.