SUMMARY:

• Experienced as an IT developer with expertise knowledge in the areas of planning, analysis, design, development, testing and implementation of software.
• Extensive experience in Database design and development using SQL Server 2005/2008/SSIS/SSRS.
• Expertise in T - SQL (DDL, DML), Joins, indexes, views, stored procedures and database triggers to implement security and business logic.
• Extensive experience in using Extraction, Transformations and Loading (ETL) tools like SQL Server Integration Services (SSIS).
• Expertise in developing SSIS Packages and using data transformations and deploying them on various production servers.
• Experienced in developing different types of reports like Ad hoc reports, matrix reports, tabular reports and drill down reports using SSRS.
• Analyze and understand systems and applications in order to diagnose and resolve problems that occur with them.
• Experience in Query Optimization, troubleshooting procedures and T-SQL codes.
• Knowledge in database administration and maintenance activities such as Backup and Recovery, monitoring SQL Server, Replication, log shipping, managing and creating SQL agent jobs.
• Experienced in using tools like SQL Profiler for monitoring and Tuning Server Performance.
• Experienced in interacting with end users and gathering business requirements.

TECHNICAL SKILLS:

• MS SQL Server 2005/2008
• MS SQL Reporting Services 2005/2008
• MS SQL Server Analysis Services 2005/2008
• MS SQL Server Integration Services 2005/2008
• MS SQL Profiler
• SQL Query Analyzer
• VisualStudio2005/2008
• C#.NET
• HTML
• ASP.Net
• XML
• XSLT 1.0
• MS Access
• MS-Office
• MS Excel

PROFESSIONAL EXPERIENCE:

Confidential, Reston, VA

Technical Operations Engineer

Responsibilities:

• Analyze and understand systems and applications in order to diagnose and resolve problems that occur with them.
• Interact with Business users, Technology staff and Vendor partners to support and troubleshoot operations
• Assist in the development and maintenance of the procedures to manage and ensure successful operations of systems
• Support development efforts related to vendor data flows and operational data quality. Work with the business process owners, vendors, and Technology staff to ensure that data requirements are well understood and documented.
• Developed, enhanced, and maintained process and issue documentation. (AP Capstone).
• Performed proactive problem management and incidents trending to eliminate future incidents.
• Involved in the end to end analysis of AP Capstone workflow and feeds.
• Resolved several student/teacher related issues with AP Capstone Digital Portfolio application.
• Worked closely with Program, IT, DB teams to address and resolve issues via RFC’s.
• Resolved many student related issues with Different Programs including SAT and PSAT.
• Collected data from Various Heterogeneous database/files like MS SQL, DB2, ORACLE, Flat File, Access, EXCEL sheets, CSV format and used complex data conversion to target.
• Scheduling and monitoring the regular jobs and ETL packages.
• Wrote complex SQL queries using joins, stored procedures, and used defined functions to verify the data from the database to generate reports based on the business requirement.
• Wrote SQL Stored Procedure for checking Insert and Update on particular tables and created Transactions and Error Handling in it.
• Designed and Developed reports based on requirements using SQL Server Reporting Services (SSRS) and deployed them
• Extensively worked on Cross Tabbed and Matrix reports using SSRS
• Designed and implemented indexing to optimize transactional and reporting performance

Tools: &Technologies: Oracle, Mercury ITSM, Flux, Microsoft Visual Studio, SQL Server Management Studio, MS SQL Server, MS Excel, Share Point, T-SQL,CAT(internal,) PAT(internal), CSR-ADMIN(internal).

Confidential, Wilmington, DE

MS SSIS/SSRS

Responsibilities:

• Extracted and reviewed data from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) using SQL Server Integration Services (SSIS) from OLTP to OLAP.
• Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
• Involved in performing incremental loads while transferring data from OLTP to data warehouse using different data flow and control flow tasks in SSIS.
• Responsible for writing T-SQL Queries (DDL/DML), Stored Procedures, Views and Functions.
• Responsible for creating database tables, Views, Stored Procedures and Triggers to provide structure to Data warehouses, and capture updated and deleted data from OLTP systems.
• Designed and developed SSIS packages for loading data from ODS to Data Warehouse. Used various SSIS tasks 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.
• Recognized the fact and dimension tables in the OLAP database and created cubes using MS SQL Server Analysis Services.
• Created tabular, matrix, chart, drill-down, drill-through reports using SSRS and generated report models using report builder for the end users.
• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data from ODS to related destination databases for residential, business, large business users.

Environment: MS SQL Server 2000/2005/2008, MS SQL Server Integration Services (SSIS), MS SQL Server Integration Services (SSAS), MS SQL Server Reporting Services (SSRS), MS SQL Management Studio, Transact-SQL, MS Excel, Windows XP/2003.

Confidential, Glen Mills, PA

MS SQL BI Developer

Responsibilities:

• Worked closely with business unit(s) to understand key business drivers and then identify the individual business metrics and key measures that support them
• Designed and configured, including parameters, settings, metrics, data elements and objectives
• Worked with management to develop strategies to support company needs
• Resolved data conflicts and inappropriate use of data.
• Created /modified and maintained the ETL packages- Extraction, Transformation and Loading of data from various Database tables i.e., from Source Tables to Mapping the Target table in respective databases.
• Collected data from Various Heterogeneous database/files like MS SQL, DB2, ORACLE, Flat File, Access, EXCEL sheets, CSV format and used complex data conversion to target.
• Scheduling and monitoring the regular jobs and ETL packages.
• Wrote complex SQL queries using joins, stored procedures, and used defined functions to verify the data from the database to generate reports based on the business requirement.
• Wrote SQL Stored Procedure for checking Insert and Update on particular tables and created Transactions and Error Handling in it.
• Utilized SSRS reports from different source formats and satisfying clients by representing reports and presentations
• Generated matrix reports, tabular, drill-down, drill-through, sub reports, chart reports, multi parameterized reports
• Created ad Hoc and parameterized various reports using SQL server 2008 reporting Services
• Implemented multiple grouping into several reports using visibility and toggle options
• Used XSLT 1.0 to customize xml reports being fed to the PDF engine.

Tools: &Technologies: MS SQL Server 2008R2, SQL server Reporting Services 2008R2, SQL Integration Services 2008R2, SQL Analysis Services 2008R2,Microsoft Visual Studio, SQL Server Management Studio, MS Excel, T-SQL,Xml spy.

Confidential

MS SQL Server Developer

Responsibilities:

• Installed SQL Server on Windows 2008R2 Server.
• Assisted in the Analysis and Design of database.
• Created Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
• Defined relationship between tables and enforced the referential integrity constraints. Created Clustered and Non-Clustered Indexes.
• Tuned the SQL queries using SQL profiler. Involved in tuning the database.
• Trouble shooting Problems by using SQL server profiler. Pre-actively identifying the problems before user complaints.
• Created Stored Procedures which generated the necessary Fact and Dimension tables and Functions that allowed performing necessary calculations depending upon the requirements
• Migrated heterogeneous databases to MS SQL Server 2008R2.
• Developed logical and physical data model using MS Visio and mapped the data into database objects
• Designed and created different ETL packages using SSIS from Oracle source to SQL server 2008R2
• Created SSIS Packages to export and import data from Text files, CSV files and Excel Spreadsheets
• Designed and implemented SSIS packages for data integration
• Designed and Developed reports based on requirements using SQL Server Reporting Services (SSRS) and deployed them
• Extensively worked on Cross Tabbed and Matrix reports using SSRS
• Designed and implemented indexing to optimize transactional and reporting performance.

Environment: Windows OS, MS SQL Server 2008R2, MS SQL Server Reporting Services 2008R2, MS SQL Integration Services 2008R2, T-SQL, ERWIN, Microsoft Visio , SQL profiler.

Confidential

Responsibilities:

• Annalise needs of clients and designing a system to meet the needs.
• Presenting ideas for system improvements, including cost proposals reducing detailed specifications and writing the program codes
• Testing the product in controlled, real situations before going live
• Preparation of training manuals for users
• Maintaining the systems once they are up and running

Environment: ASP.Net-C#/Visual Studio 2010, SQL Server