SUMMARY:

• MS SQL Server Developer with over 7+ years of experience in various domains like Financial, Healthcare, Insurance and Retail with expertise in MS SQL Server version 2016/2 r2/2005.
• Designed Logical and physical Database of database using Erwin.
• Expert in Data conversion, Data modeling, Normalization and Enterprise Manager.
• Wrote complex Stored Procedures, User Defined Functions, Views and creating other database objects.
• 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 DTS and 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 2012/2014/2016 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.
• Highly Proficient in Agile, and Waterfall software development life cycle
• Strong knowledge in creating reports by using Power BI Desktop.
• Expert in Database Backup, Recovery and applied necessary SQL Server database Service packs, hot fixes and Security Patches.
• 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.

TECHNICAL SKILLS:

Programming Languages: T-SQL, PL/SQL,HTML, SELENIUM,XML

Business Intelligence tools: Business Intelligence Development Studio (SSIS/SSRS/SSAS), Erwin, Power BI Desktop, DTS

Database: MS SQL Server 2016/2 r2/2005, MYSQL, Sybase, DB2, MS Access 2007/2003, Teradata

Operating Systems: XP, Windows Server2008R2/2008/2003

SDLC tools: HP Quality center, Team foundation Server(TFS)

PROFESSIONAL EXPERIENCE:

Confidential, NY

MS SQL Server Developer/BI Developer

Responsibilities:

• Wrote T-SQL query for creating and maintaining existing store procedures.
• Involved in writing views, triggers, cursors, and functions for day to day data retrieval.
• Involved in implementing different types of reports & schedule them for reporting purposes using SSRS.
• Generating on-demand, ad-hoc, custom reports for business analysis or management decision using SSRS.
• Developed and deployed Table, Chart, Matrix, Parameterized report and Sub-Reports.
• Populated dimension and Fact tables of Data Warehouse which were later used to create SSAS Cube.
• Design, develop, configured & 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.
• Interaction with clients regarding business requirements, design & implementation phases.
• Used TFS for source control and SSIS package deployment.
• Converted PL/SQL queries to T-SQL queries

Tools: & Technologies: Microsoft SQL Server 2016/2014/2012 , Erwin, SSMS, SSIS, SSRS, T- SQL, TFS, Oracle, Sybase, PLSQL

Confidential

T-SQL/SSIS developer

Responsibilities:

• Interaction with clients while business requirements, design & implementation phases.
• Created and maintained existing dynamic SSIS packages to load data from and to MS SQL Server and Oracle, Excel files, and flat files.
• Involved in Extraction, Transformation and Loading (ETL) of the data in the table for Oracle database.
• 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.
• Migrated data from Informatica to and from SSIS.

Tools: &Technologies: MS SQL Server 2012/2008, SSIS 2012/2008, SSRS, Power BI Desktop, T-SQL, Excel

Confidential

MS SQL Server /SSRS/SSIS Developer

Responsibilities:

• SQL Server 2012,2008 database development using T-SQL programming, queries, stored procedures, views.
• Improved existing Stored Procedure by creating indexes and changing logic.
• Using SSRS creating well-formed reports and web-based reports for health related applications and transactions.
• Generated matrix, drill down, drill through, sub reports, chart reports, and dashboard reports.
• Generated multi parameterized reports in MS SSRS 2012 allowing users to filter data before executing reports.
• Worked on migrating ad-hoc reports from SSRS 2005 to SSRS 2012 using TFS server.
• Used Erwin data modeling tool to design logical and physical database.
• Worked on Stored Procedures to fix the errors and modifications of existing reports.
• Created SSIS packages to import data from Excel and Flat file to SQL Databases using SSIS component like Slowly Changing Dimension, Merge, Merge Join, Union All and Lookup.
• Deployed and configured SSIS package.
• Developing reports on SSRS on SQL Server (2012).
• Worked on OLAP Data warehouse, Model, Design, and Implementation.
• Sound Experience and understanding of OLAP cube, and multi-dimensional modeling on Multi-terabytes database.
• Involved creating interactive report using Power BI Desktop.

Tools: &Technologies: MS SQL Server 2005/2012, MS Windows Server 2003/2008, SSIS, SSRS, Report Builder, TFS, Visual Studio 2012, T-SQL, XML.

Confidential, Northbrook, IL

MS SQL Server/SSIS Developer/DBA

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 (SQL Server, Flat files, Excel files, CSV files) and loaded the data into target tables by performing different kinds of transformations using SSIS.
• 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(Isolation Level)
• 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.

Tools: &Technologies: MS SQL Server 2008/2005, T-SQL, SSIS 2008r2/2008/2012, Microsoft visual studio and, Windows server 2008 .

Confidential

MS SQL Server Developer

Responsibilities:

• Wrote T-SQL queries for day to day task.
• Created tab delimited text files according to the general requirements for load ready files.
• Converted the data from its original format into the target (SAP) format
• Executed the load ready files into the specified client.
• Executed the objects in the respected sequence according to the LSMW configured steps.
• Created an excel log of all object information including the number of entries in each object, the start time and end time.
• Created scripts to create new tables, views, queries is Oracle Databases for new enhancement in the application using TOAD.
• Used an extended computer aided test tool (ecatt) for objects with larger data size.
• Tested objects in the development client, multiple times in a day.
• Tested objects into the Quality environment, before loading it to production.
• Loaded all legacy data into ECP (production).
• Involved in requirement gathering/analysis, Design, Development, Testing and Production rollover of Reporting and Analysis projects
• Analysis the metric dashboard reports and identified the formulas and functionality of the dashboard reports and digitizing the metric dashboards to Tableau application.
• Published the dashboard reports to Tableau Server for navigating the developed dashboards in web.
• Extracted data from Oracle database using SSIS.
• Scheduled the published dashboards from Tableau Server on weekly basis.
• Sending the dashboards to users by emails with the help of admin team with subscriptions.
• Performance tuning of Reports by creating Linked Universes, Joins, Contexts, Aliases for resolving loops and checked the integrity of the universes using Business Objects Designer module during development.

Tools: and technologies: Microsoft SQL Server 2008/2005, SSIS, SAP LSMW, T- SQL, SSRS