PROFESSIONAL SUMMARY:

• Over 8 years of strong experience as MS SQL server developer in various domains including telecommunication, health insurance, banking, insurance and pharmacy with expertise in Confidential - SQL, SSIS and SSRS for versions 2017/2016/ 2014/2012/2008 r2.
• Proven ability to handle multiple tasks and demonstrate initiative and adaptability and capable of handling responsibilities independently as well as a proactive team member.
• Designed conceptual, logical and physical model of database
• Expert in data conversion, data modeling, normalization and SQL server 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
• 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 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
• 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

BUSINESS SKILLS/TECHNICAL SKILLS:

MS SQL Server 2017/2016/ 2014/2012/2008 r2, Visual studio 2010/2008 (SSIS/SSRS), MS SQL Profiler, SQL server Query Analyzer, Index Tuning Wizard, MySQL, Windows Server, Erwin, SSMA, C++, MS Office, big data clouding (Hive), and Python.

PROFESSIONAL EXPERIENCE:

Confidential, Bradenton, FL

MS SQL/SSRS Developer

Responsibilities:

• Increasing more prescribed patients and implementing coupons and working with physician data information
• Work on SSMS for transferring data from Oracle to MS SQL Server.
• Interaction with clients while business requirements, design & implementation phases.
• Create and maintain existing dynamic SSIS packages to load data from and to MS SQL Server and Oracle, Excel files, and flat files.
• Design, develop & test the ETL processes according to industries best practices using SSIS.
• Generating on-demand, ad-hoc, custom reports for business analysis or management decision using SQL Server Reporting Services
• Extensively used various SSIS Objects such as Dataflow Components, Control Flow Elements, Connections Managers, Runtime Events, Log Providers & import/export wizard while developing packages.
• Script task for Data Flow and Error Handling in SSIS.
• Utilizing Confidential -SQL to create database objects such as Tables, Views, Functions, Triggers and Stored Procedures.
• 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.
• Report for all kinds of reports and SSIS packages.
• Create reports such as Matrix Report, Drill-Down and Drill-Through Reports, Parameterize Reports, Dash Board Report, and Link report using SSRS 2008r2 and Cognos Reporting tool.

Tools: MS SQL Server 2017/ 2014/2012/2008 r2, SSIS 2008r2/2008, SSRS 2008r2/2008 (remedy ticketing dashboard, ETL), Confidential -SQL, Power BI, and Hive (optional).

Confidential, New York

MS SQL Server / SSIS/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 Confidential -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 2008r2 and Cognos Reporting tool.

Tools: Windows XP, MS SQL Server 2014/2012/2008 r2, SSIS 2008r2/2008, SSRS 2008r2/2008 (remedy ticketing dashboard), Confidential -SQL, Excel, and Acrobat Reader.

Confidential, MD

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 using SQL objects 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 (SQL Server, 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 Confidential the package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Involved in creating various reports like Drill through, Drill down and Ad-hoc according to the user requirement using SQL Server Reporting Services (SSRS).

Tools: MS SQL Server 2012/2008r2, SSIS 2008r2/2008, Confidential -SQL, Visual Studio, Windows XP, MS Office 2007/2010, MS Access.

Confidential, NewYork, NY

MS SQL Server/SSIS and SSRS 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 (SQL Server, 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 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: MS SQL Server 2008r2 Confidential -SQL, SQL server Integration service 2008r2/ Microsoft visual studio, Windows server 2008.

Confidential, New York, NY

MS SQL Server/SSIS and SSRS Developer

Responsibilities:

• Involved in planning, defining and designing data and provided documentation
• Developed and Implemented UNIX shell scripts through command task to handle requirements like dropping and building indexes, flat file archiving/dropping process etc.
• Involved in creating alerts for successful or unsuccessful completion of scheduled jobs
• Used various SSIS tasks such as conditional split, derived column, which did data scrubbing, including data validation checks during staging, before loading the data into the data warehouse
• Created error and performance reports on SSIS packages, Jobs, stored procedures and triggers.
• Created sub-reports, drilldown-reports, summary reports, and parameterized reports in SSRS
• Performed Confidential -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 2005
• Generated reports using SSRS that could be used to send information to different primary vendors, clients, and managers
• Involved in documentation for all kinds of reports, DTS and SSIS packages
• Designed and implemented stored procedures and triggers for automating tasks
• Maintained the table performance by following the tuning tips like normalization, creating Index and ensured best practices are applied and integrity of data is maintained through security and documentation.

Tools: MS SQL Server 2008r2/2005 Confidential -SQL, SQL server Integration service 2008r2/2005 Microsoft visual studio, Windows server 2008.