SUMMARY:

• Over 8 years of extensive experience in database design, development, and administration with MS SQL Server versions 2012/2008R 2/2008/2005/2000/7.0 using SSIS, SSAS, SSRS in Financial, Airlines and Insurance industries.
• Experienced with all phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development, and Implementation.
• Strong experience in logical and physical database design and development, Normalization and data modeling using CA Erwin and MS SQL Server Enterprise manager.
• Extensive experience in MS SQL Server 2008/2005, Business Intelligence technologies like MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), and MS SQL Server Analysis Services (SSAS).
• Excellent experience in migration of data from Excel, Flat file, Oracle to Microsoft SQL Server by using SSIS and DTS (Data Transformation Services) utility.
• Experienced in designing high level ETL architecture for overall data transfer from the OLTP - Online Transaction Processing to OLAP - Online Analytical Processing with the help of SSIS.
• Strong experience in designing and developing large number of reports in SSRS/Business Objects using the data from ETL Loads, MS SSAS Cubes and various heterogeneous data sources and Creating and Deploying SSRS Reports on the portal for user accessibility.
• Expert in designing and scheduling complex SSIS Packages for transferring data manually from multiple data sources to SQL server.
• Expert in creating, configuring and fine-tuning ETL workflows designed in DTS and MS SQL Server Integration Services (SSIS) AND used different data transformation including transformation of XML based on XSD FILE.
• Experienced in developing and modifying cubes using SSAS and transform into pivot table.
• Expert in developing Drill through and Drill down reports using Crystal Reports and MS SQL Server Reporting Services (SSRS)
• Highly proficient in the use of T-SQL for developing complex stored procedures, triggers, tables, user functions, user profiles, relational database models and data integrity, SQL joins and query writing.
• Experienced in Database Installation, Configuration, Maintenance, Monitoring, Backup and Disaster Recovery procedure and Replication.
• Excellent inter personal skills and communication skills and ready to take challenges with proven ability.

TECHNICAL SKILLS:

• MS SQL Server 2012/2008R 2/2008/2005/2000/7.0
• MS SQL Server Integration Service (SSIS)
• MS SQL Reporting Services (SSRS)
• MS SQL Server 2008/2005 Analysis Services (SSAS)
• Microsoft Access 2010
• Erwin 8.0/7.3/4.2/4.1/4.0
• Microsoft Visio 11.0/10.0
• T-SQL
• PL/SQL
• ASP.NET 3.5
• C# 4
• VB.Net
• DHTML
• HTML
• XML 1
• XSLT
• JavaScript
• AJAX
• Oracle 10g/9i
• Crystal Reports 11/10/9/8.5
• Visual source safe 2005
• MS office 2007/2003
• Windows 2003/2000 Advanced Server/Professional
• Windows NT 4.0 Server/Workstation
• Oracle D2K
• Toad
• Sql and PL/Sql.

PROFESSIONAL EXPERIENCE:

Confidential, Troy, MI

MS SQL Developer

• Worked with product owners, application developers, production teams and across functional units to identify product and client specific needs and discuss solution options.
• Involved in Planning, Defining and Designing database diagram using Erwin 8.0 on business requirements and provided documentations.
• Worked in the Agile methodology using Scrum which has its primary focus on the management part of the software development, dividing the whole development period into small iterations (of thirty days) called "sprints."
• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
• Created/Updated database objects like tables, views, stored procedures, function, packages.
• Created VB.Net Script for Data Flow and Error Handling using Script component in SSIS.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Rigorously tested and debugged the Stored Procedures and used Triggers to test the validity of the data after the insert, update or delete.
• Generated Drill down, Drill through, Adhoc, Matrix Reports, parameterized reports using SSRS.
• Designed and developed monthly, quarterly and yearly reports at product and client level.
• Involved in table and index partitioning for performance and manageability.
• Monitored the overall performance of the database to recommend and initiate actions to improve/optimize Performance.
• Used SQL Server Profiler to trace the slow running queries and the server activity.
• Automated and enhanced daily administrative tasks including database backup and recovery.
• Helped create process logging and new monitoring tools, integrity reports, and mapping tools.
• Involved in setting up SQL Server Agent Jobs for periodic Backups with backup devices, database maintenance plans and recovery.

Tools: and Technologies: Microsoft SQL Server 2008, T-SQL, SQL SSIS, SSRS, SSAS, Windows server 2003 Visual Source Safe, SQL Profiler, Visual Studio 2008, Visual Intercept Enterprise Edition, Oracle 10g, VB.Net

Confidential, Baltimore, MD

MS SQL Developer/SSIS/SSAS/SSRS Developer

Responsibilities:

• Involved in Planning, Defining and Designing database using Erwin 8.0 on business requirements and provided documentations.
• Configured, Managed, Administered, and Developed all components of SQL Server
• Designed MS SSIS Packages to extract data from various OLTP sources, Text Files, XML (Extensible Markup Language) Files, MS SQL Server 2008, Excel and MS Access 2000 to OLAP system like SQL Server.
• Created various SSIS packages using data transformations like Merge, Aggregate, Sort, Multicasting, Conditional Split, and SCD (Slowly Changing Dimension) and Derived column, transformation of XML based on XSD File.
• Wrote T-SQL queries, Store Procedures and used them to build packages and maintain the history of the data.
• Worked and created databases using VB.Net and inserted data in sql with vb.net
• Involved in Design and Developed OLAP cubes for the end user analysis purpose using MS SSAS 2005. Identified fact and dimension tables in the Cube.
• Developed reports in MS SQL Server environment using stored procedures, functions and report development using MS SSRS-2012 in Business Intelligence Development Studio (BIDS).
• Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using MS SSRS for the end user requirements.
• Performed daily tasks including backup and restore by using MS SQL Server 2012 tools like MS SQL Server Management Studio, MS SQL Server Agent, and Database Engine Tuning Advisor.
• Scheduled report and exported in PDF format
• Used MS SQL Server profiler for auditing and analyzing the events which occurred during a particular time horizon and stored in script.

Tools: and Technologies: MS SQL Server 2012, SSRS, T-SQL, SSIS, Visual SourceSafe, Win 2003 Advanced Server, PowerBuilder 5, Erwin v8.0, ASP.Net, C#, MS Access 2010,IIS 7.0.

Confidential, Newark, NJ

MS SQL Server Developer/SSIS/SSRS Developer

Responsibilities:

• Involved in Planning, Defining and Designing data based on business requirement and provided documentation.
• Engaged in gathering data and documenting it for further reference.
• Involved in installation and configuration of MS SQL Server 2008.
• Expert in designing database using ERWIN.v7.2
• Upgraded the server from MS SQL Server 2005 to MS SQL Server 2008.
• Created SSIS packages to extract data from OLTP to Data warehouse systems and scheduled Jobs to call the packages and Stored Procedures.
• Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split, Derived column, and etc.
• Created SSIS packages for data Importing, Cleansing, and Parsing.
• Developed Unit Test Plans for SSIS packages.
• Modified the existing SSIS packages to meet the changes specified by the users.
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on daily basis.
• Designed, developed, and deployed reports in MS SQL Server environment using SSRS 2008.
• Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS.
• Created reports to retrieve data using Stored Procedures that accept parameters.
• Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard
• Responsible for monitoring and tuning report performance.
• Involved in the design and development of web forms for the application using ASP.Net to take care the cosmetic works of the reports deployed on the server.
• Fine-tuned SQL Queries for maximum efficiency and performance.
• Designed and implemented Stored Procedures and Triggers for automating tasks.
• Provided documentation for all kinds of reports, Stored Procedures and SSIS packages.

Tools: and Technologies: MS SQL Server 2008, SSIS, SSRS, SSAS, Oracle11g, Visual Studio 2005, VSS 2005, Erwin 7.3, Windows NT/2003,Microsoft .NET framework 3.5, C#, JavaScript, ASP.NET, XML.

Confidential, Cincinnati, OH

SQL Developer/SSRS Developer

Responsibilities:

• Involved in module testing and development. Defined testing cycle documents.
• Created various tables, views, indexes and Sequences.
• Developed database triggers.
• Development of forward port, creation of tests Scripts and Execution of White box testing and integration testing.
• Created many packages, procedures and functions for reports. Data was populated in the reports using these routines.
• Managed users including creation/alteration, grant of system/database roles and permission on various database objects.
• Tested and configured automated routine maintenance tasks like performance tuning, indexes and stored procedures, checked deadlocks and created jobs and scheduled them.
• Involved in module design
• Developed stored procedures, triggers and functions to account for some automated insertion of records in some of the tables.
• Creation of complex business scenarios
• Used SSRS to create reports, customized reports, On-Demand reports and Ad-Hoc reports and involved in analyzing multi-dimensional reports in SQL Server Reporting Services 2005.
• Performed daily tasks including backup and restore by using MS SQL Server 2005 tools like MS SQL Server Management Studio, MS SQL Server Agent, and Database Engine Tuning Advisor.
• Used MS SQL Server profiler for auditing and analyzing the events which occurred during a particular time horizon and stored in script.

Tools: and Technologies: Oracle 8i, Toad, MS SQL Server 2005, MS Access 2000, Excel, SQL Profiler, Windows XP, Erwin 7.1, VSS 2005

Confidential, Addis Ababa, ET

MS SQL Server Developer

Responsibilities:

• Developed system standards, architecture, scenarios, detailed screen specifications and documented logical and physical data model using Erwin Data Modeler.
• Involved in designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the insurance data from various source systems feeds using SSIS.
• Worked Extensively with MS SQL Server Integration Services (SSIS) to import, export and transform the data between the linked servers.
• Created packages using MS SQL Server Integration Services (SSIS) for data extraction from Flat Files, Excel files, OLEDB source to data warehouse.
• Used SSRS to create reports, customized reports, On-Demand reports and Ad-Hoc reports and involved in analyzing multi-dimensional reports in SQL Server Reporting Services 2005.
• Developed stored procedures, triggers and functions to account for some automated insertion of records in some of the tables.
• Used BCP utility and Bulk Insert to load data from different data sources to SQL Server.
• Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.
• Managed users including creation/alteration, grant of system/database roles and permission on various database objects.
• Tested and configured automated routine maintenance tasks like performance tuning, indexes and stored procedures, checked deadlocks and created jobs and scheduled them.

Tools: and Technologies:MS SQL Server 2005/7.0, Windows Server, Windows NT, Erwin, Crystal Reports