SUMMARY

• Over 7+ years of working experience in MS SQL Server in various domains like Finance, HealthCare, Retail and Insurance with expertise in MS SQL Server 2016/2014/2008/2005 , SSIS, and SSRS. Experienced in handling multiple tasks under strict deadline and capable of handling responsibilities independently as well as a proactive team member.
• Highly proficient in using T - SQL, writing Stored Procedures, Triggers, Functions, XML and Cursors in SQL Server.
• Expert in Data conversion, Data modeling, Normalization and SQL Server Enterprise manager.
• Expert in Migration of data from Oracle, Sybase and DB2 to SQL Server.
• Involved creating ETL process, Data warehousing, Operations Data Store concepts, data marts and OLAP technologies, MOLAP cubes, Including Star and Snowflake schema.
• Expert in Creating, maintaining and Configuring SSIS packages.
• Involved working with heterogeneous data source like Excel, Flat file, Oracle, DB2, and SQL Server.
• Expert in Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Involved creating operational reports in SSRS 2008/2008r2/2012 i.e. Drill-Down, Drill-through, Dashboard, Sub-Report, and Matrix reports for various domains.
• Expert in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC Utilities.
• Involved in Data Scrubbing, Data Staging and Data Validation in preparation of pushing data to production environment.
• Experience in scripting languages like C#, JQuery and JavaScript and utilizing them on designing and developing ASP.net based UI.
• Expert in Database Backup, Recovery and applied necessary SQL Server database Service packs, hot fixes and Security Patches.
• Defined and administered database standards, controls, procedures and documented the same.
• Extremely diligent strong team player with an ability to take new roles and ability to work under pressure in a highly visible role and 24x7 on call support.
• Experienced in Create report by using Power BI Desktop.

TECHNICAL SKILLS

• MS SQL Server 2012/2008r2/2008
• Visual studio 2010/2008 (SSIS/SSRS)
• Microsoft Access 2007/2003
• MS SQL Profiler
• SQL server Query Analyzer
• Index Tuning Wizard
• Oracle 11g 10g and 9i
• MySQL
• Cognos report
• Informatica
• Windows Server
• Microsoft SharePoint
• Erwin
• SSMA
• MS Access
• PHP
• Java
• C++
• MS Office

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

SQL BI/SSRS Developer

Responsibilities:

• Involved in the completeSDLCincluding Requirement Specifications, Analysis, Design, Development using .Net framework 4.5,5.0, VB.NET/C#, MVC, WCF Visual Studio 2012/2015
• Created front end UI for the reports using MVC web by creating views,Reportdetial views, Report controller, layout views and various WCF for landmark Atlas database
• Created various packages for loading landmark database into Atlas data abase by using
• Various kinds of transformations like look up, merge, copy etc. and also using different source and destination connection managers
• Created different kinds of fact tables and dimensions tables like lm tab landmark,facility details and company contacts, project contact tables, LM TAB ACTIVITIES, LM TAB PROJECT DATES
• Wrote complex T-SQL queries, stored procedures, and Views
• Created different types of store procedures for revisions,, remodel and new store data of the Publix
• Extensively used transformations, control flow tasks, data flow tasks, containers and event handlers.
• Created ETL controller process for controlling the monthly and daily process of loading by using ssis packages and configuration tables
• ImplementedSlowly Changing Dimension(SCD) type 2 to maintain Historical Data.
• Designed Package to do ETL Auditing and designed Stored Procedure to keep track of Daily Load. Worked on SSRS extensively to create and design reports.
• Worked with Report Builder to build Ad-hoc Reports.
• Worked on SSRS extensively to create and design reports.
• Created various kinds for reports like drill down, drill through using visual studio 2012/2015 like
• Revision reports, new store reports, remodel reports, submittals reports and landmark reports
• Performance Tune the Stored Procedures, User Defined Functions and long running queries.
• Used Team foundation server (TFS) for storing the store procedures, tables, indexes from development environment and used that for deploying into test and production environment.
• CreatedMaintenance Plansto do Backups, and setup log files to monitor jobs.
• DevelopedUI/Components/Classes/Methods/Functionsfor the application and also Functionalities such as Data retrieval using disconnected record sets, usingADO.NET / ASP.NET /Windows Forms / Web Forms / Server controls.
• Worked in ASP.NET /C# application development environment to use SQL Server Databases as backend database
• Used SQL Server Reporting services for creating, editing and scheduling various reports by using data driven subscriptions and SQL Server Agent

Confidential, New York, NY

SQL BI/SSRS Developer

Responsibilities:

• Interaction with clients while business requirements, design & implementation phases.
• Generating on-demand, ad-hoc, custom reports for business analysis or management decision using SQL Server Reporting Services.
• Created and maintained existing dynamic SSIS packages to load data from and to MS SQL Server and Oracle, Excel files, and flat files.
• Worked on SSMA for transferring data from Oracle to MS SQL Server.
• Design, develop & test the ETL processes according to industries best practices using SSIS.
• Extensively used various SSIS Objects such as Dataflow Components, Control Flow Elements, Connections Managers, Runtime Events, Log Providers & import/export wizard while developing packages.
• Used Script task for Data Flow and Error Handling in SSIS.
• Worked with T-SQL to create database objects such as Tables, Views, Functions, Triggers and Stored Procedures.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
• Used SQL profiler, and indexes for performance tuning & debugging issue whenever necessary.
• Documented for all kinds of reports and SSIS packages.
• Created reports such as Matrix Report, Drill-Down and Drill-Through Reports, Parameterize Reports, Dash Board Report, and Link report using SSRS 2016 and Cognos Reporting tool.
• Worked on performance tuning by creating indexs, batch execution and query rewriting.

Confidential, NY

MS SQL Server/SSIS/SSRS Developer

Responsibilities:

• Defined and designed the data sourcing and data flows, data quality analysis
• Identified the data source and defined them to build the data source views.
• Involved in extracting the data from OLTP to OLAP using SSIS.
• Review developer SQL code to ensure adherence to client standards and general best coding practices.
• Designed ETL packages dealing with different data sources (SQL Server, CSV, Flat Files etc) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Used SQL Server Agent to automate the SSIS 2012/2008r2 package execution.
• Developed stored procedures to transform the data from enterprise data warehouse to SQL server and load data to fact tables.
• Transferred data from various sources like MS Excel, MS Access and SQL Server using SSIS 2012/2008r2 and then created reports using this data using SSRS.
• Tested and managed the SSIS 2012 packages and was responsible for its security.
• Configured and maintained Report Manager and Report Server for SSRS.
• Identified and added the report parameters and created the reports based on the requirements using SSRS 2012/2008r2.
• Developed reports using efficient data retrieval techniques and tested the reports.
• Designed stylish Report Layouts and Deployed the Reports using SSRS 2012/2008r2.
• Wrote Complex Stored Procedures, Triggers, Views and Queries.
• Created indexes, Constraints and rules on database objects.

Confidential, Boston, MA

MS SQL Server / SSIS/SSRS Developer

Responsibilities:

• Involved in Planning, Defining and Designing data based on business requirements and provided documentation.
• Created effective functions, appropriate Triggers to facilitate efficient data manipulation and data consistency.
• Transformed complex business logic into Database design and maintaining it by usingSQLobjects like Stored Procedures, User Defined Functions, and Views.
• Successfully implemented indexes on tables for optimum performance.
• Extensively used Joins and Sub-queries for complex queries involving multiple tables from different databases.
• Use various SSIS transformations such as Conditional Split, Derived Column etc., which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Applied ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Created ETL packages with different data sources (SQLServer, Flat files, Excel source files, Oracle) and loaded the data into target tables by performing different kinds of transformations using SSIS 2008r2.
• Created SSIS packages to extract data from OLTP to Data warehouse systems and scheduled Jobs to call the packages and Stored Procedures.
• Performed Documentation for all kind of SSIS packages.
• Developed logging for ETL load at the package level and task level to log number of records processed by each package and each task in a package using SSIS 2012/2008r2.
• Involved in creating various reports like Drill through, Drill down and Ad-hoc according to the user requirement using SQL Server Reporting Services (SSRS).
• Experienced in implementing the JavaScript framework for processing the web server request client side rather than server side.
• Used MS Ajax, JQuery, JavaScript to develop rich user interface with unobtrusive JavaScript.

Confidential, Shevychase, MD

Jr.MS SQL Server/SSIS Developer

Responsibilities:

• Involved in creating various Tables, Views and Functions based on the requirement specified by EDW team and wrote complex Join statements for combining data from various Databases and tables.
• Involved creating complex stored procedure based on business requirements.
• Proficient in tuning SQL queries using execution plan, index and DMV.
• Created SSIS packages with different data sources (SQLServer, Flat files, Excel files, CSV files) and loaded the data into target tables by performing different kinds of transformations using SSIS.
• Applied various data transformations like Slowly Changing Dimension (SCD), Aggregate, Sort, Multicasting, Conditional Split, Derived column etc.
• Use Packages by testing and cleaning the Standardized Data by using tools in Data Flow.
• Involved in scheduling SSIS packages in multiple servers using SQL Server Agent.
• Logged various packages as well as individual tasks using SQL server log providers like text file, SQL server database, trace file, xml file.
• Responsible for database tuning using normalization and application tuning.
• Documentation for all kinds of reports and SSIS packages.
• Schedule and maintain Full, Differential, Transactional Log backup and restore the data using restore with recovery and restore with no recovery option.
• Worked on locking, blocking and dead lock issues.
• Involved in developing application using ASP.NET and C#.
• Created a large number of Class and Interface to implement Business Logic and Data Manipulation in C#.
• Integrated Active Directory with C# to use existing user data.
• Gathered data from distribution lists and copied to our Data warehouse using SSIS.
• Involved in performance tuning of slow running queries using execution plan and index tuning wizard.
• Scheduling jobs and alerts using SQL Server Agent and configured database mail for any job failure.