Sql Server Developer Data Manager .Net Experience

Madhavi

SUMMARY

Over * years of experience in IT Industry this includes experience as a Microsoft BI developer (SSIS, SSRS) with business analytical skills.

1. Highly proficient in the use of T-SQL for developing stored procedures, triggers, tables, user defined functions, relational database models and data integrity, SQL joins.

2. Extensive experience in data migration between homogenous and heterogeneous system using various tools (Data Transformation Services (DTS), SSIS, BCP, Bulk Insert, ActiveX).

3. Had a major role in business requirements analysis, logical Data modeling, application development, testing, production support and Project review with client.

4. Involved in migration from MS SQL Server 2000 to 2005, 2005 to 2008, running and scheduling SSIS packages, Look-up for cleaning bad data, validating data using SSIS.

5. Designed and mapped using various SSIS Transformations like OLEDB Command, Conditional Split, Aggregate, Multicast and Derived Column.

6. Experience in creating Packages, Jobs and Experience in migration of Data from Excel, Flat file to MS SQL Server by using BCP and DTS utility.

7. Expert in designing reports using Crystal Reports and SQL Server Reporting Services 2005/2008 (SSRS).

8. Experienced in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using SSRS 2005/2008.

9. Extensive experience in different type of reports including Matrix (cross Tab report) form, Drilldown, Drillthrough, Conditional, List items, Ad-hoc, Charts and Sub reports.

10. Experience in deploying Reports to Report Server using SSRS, Configure and maintain Report Manager and Report Server for SSRS.

11. Experience in using SQL Profiler, Database Engine Tuning Advisor, Performance Monitor and Index Tuning Wizard to improve the performance of queries

12. Visual Source Safe was used for managing source code changes

1. Experience in developing applications using .Net Framework 3.5, 2.0, Visual Studio, ASP.NET, ADO.NET, C#.NET, VB.NET, SQL Server.

2. Experience in providing high quality application support on data integration and data management projects.

3. Excellent written and oral communication skills with a results-oriented attitude. Good in Collecting, Analyzing and Interpreting Data in an organized way.

4. Ability to grasp and apply new concepts quickly and effectively.

CERTIFICATION

1. Microsoft SQL Server 2008, Database Development

2. Designing and Developing ASP.NET Applications using Microsoft .NET Framework 3.5

3. Microsoft .NET Framework 3.5, ASP.NET Application Development

4. Microsoft .NET Framework - Application Development Foundation

5. Microsoft Certified Professional ID: 7383289

1. Certificate Course in programming languages “Unix, C, C++ & Oracle” from CMC Limited, India

EDUCATION

1. Bachelors of Technology from Jawaharlal Nehru Technological University in the year 2002, India.

SKILL SET

Operating System

Windows XP, Windows 2000/98/95/NT, Windows Vista

RDBMS

MS SQL SEVER 2008/2005/2000, Oracle 9i, 10g

ETL Tools

SSIS 2008/2005

Reporting Tools

Crystal Reports, SSRS 2008R2/2008/2005

Programming Languages

C#.NET, C, Unix, C++,VB.NET, ASP.NET, PL/SQL

Version Control

Visual Source Safe, Team Foundation Server

Documentation Tools

MS Office

Internet Tools

Internet Information Server (IIS), TCP/IP, LAN, WAN

Data Modeling

Erwin

WORK EXPERIENCE

Client: Orcawave, Seattle, WA/ Atlanta, GA Dec’10 - Present

Role: SQL BI Developer (SSIS, SSRS)

Orcawave is a telecommunications industry which brings extensive experience both as a prior operator of a global wholesale telecom carrier and now as a provider of elegant. The project is to collect data of Customer, Supplier, Destination, rates, costs etc and to create Traffic, Revenue and General reports using SSRS.

Responsibilities:

1. Responsible for Conceptual, logical and physical design with a significant effort towards application using ERWIN.

1. Designed SSIS Packages to handle data migration (ETL Processes) from transaction System to Dimensional Model.

2. Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.

3. Performed activities like analyzing and improving the architecture of databases, creation and indexing of the tables.

1. Created the Staging tables, successfully migrated old data from legacy system into SQL Server using SSIS Packages.

2. Used Sequence Container in Control Flow for linking all dimension tables.

3. Extensively used SSIS transformations such as Slow Changing Dimension, Lookup, Conditional split, Sort, Merge Join, Aggregate, and Execute SQL task etc.

4. Created SQL Server Reports using SSRS. Identified the Data Source and defined them to build the Data Source Views.

5. Used complex expressions to Calculate, Group, Filter, Parameterize, and Format the contents of the report.

6. Involved in Report Design and Coding for Standard Tabular type reports, including Drill down and Drill through functionality and Graphical presentations such as Charts and Dashboard type metrics using SSRS

7. Created Cross-Tab and Sub-Report using RDL and promoted RDLs to Reporting Service Server.

8. Scheduled the monthly/weekly/daily reports to run automatically. Worked on querying data and creating on-demand reports using Report Builder in SSRS reports and send the reports via email.

9. Responsible for scheduling the subscription reports with the subscription report wizard. Deployed the generated reports directly on the client’s workstation.

10. Used Query Optimization and SQL Server Profiler for tuning report queries and improves performance in SQL Server.

11. Created Views and Indexed Views to reduce database complexities for the reports.

12. Visual Source Safe was used for managing source code changes.

13. Enhancing and deploying the SSIS Packages from development server to production server.

14. Involved in developing test cases for Unit Testing.

Environment: MS SQL Server 2008/2005, SQL Server Integration Services (SSIS) 2005, SQL Server Reporting Services (SSRS) 2005, T-SQL, Erwin 4.2, MS Office, Windows Vista.

Client: CSES, Columbia, SC Jan’10 – Nov’10

Role: SQL BI Developer (SSIS, SSRS)

The Child Support Enforcement System (CSES) is federal, state and local partnership that helps families by encouraging self-sufficiency which includes supporting their children. CSES is the Government program responsible for the collection and distribution of payments and medical support enforcement to support children in single parent families.

Responsibilities:

1. Gathered business requirements, definition and design of the data sourcing and data flows.

2. Used Dimensional Modeling Techniques to identify parameters necessary to create Dimensions, Fact and Aggregate tables.

3. Creating staging database for temporary processing of data, consolidating data and Loading into Target database using SSIS

4. Developed SSIS Packages by using different data Transformations like Derived Column, Lookup, Conditional Split, Merge Join, Union All, Sort and Execute SQL Task to load data into Database

5. Transferred data from heterogeneous database & different files format (Text File, Spread Sheet) to SQL Server.

6. Written the Stored Procedures

7. Scheduling Jobs to execute SSIS packages

8. Created SQL Server Reports using SSRS. Identified the Data Source and defined them to build the Data Source Views.

9. Designed and implemented stylish report layouts. Generated Reports using Global Variables, Expressions and Functions for the reports.

10. Involved in Report Design and Coding for Standard Tabular type reports, including Drill down and Drill through functionality and Graphical presentations such as Charts and Dashboard type metrics using SSRS

11. Identified and worked with Parameters for parameterized reports in SSRS.

12. Responsible for scheduling the subscription reports with the subscription report wizard. Deployed the generated reports directly on the client’s workstation.

13. Uploaded reports on to the report manager and organized them into folders.

14. Actively involved in System Performance by tuning SQL queries and stored procedures by using SQL Profiler.

15. Used SQL Profiler and Query Analyzer to optimize SSIS package queries and stored procedures.

16. Used Visual SourceSafe for source control and versioning

17. Restored the database on production server or development servers as per requirements.

18. Unit tested the packages

Environment: MS SQL Server 2005, SSIS 2005, SSRS 2005, T-SQL, Query Analyzer, SQL Profiler, Erwin 4.2, Windows Vista, MS Office.

Client: State Of Tennessee (Nashville) Feb’09-Dec’09

Department of Finance and Administration

(Integrated Data warehouse)

Role: SQL BI Developer (SSIS, SSRS)

Tennessee Consumer Finance is a leader in providing credit services to retailers and consumers. The objectives of the iDW are to integrate the atomic data from multiple product lines in a given local business and also to offer an integrated access point for multiple business functions. The aim of this project is transferring of data using SSIS, tuning on existing jobs and creating reports.

Responsibilities

1. Gathered business requirements, definition and design of the data sourcing and data flows.

2. Developed the Logical and Physical Design models as per business requirements.

3. Used Joins, correlated and non correlated sub-queries for complex business queries involving multiple tables from different databases and implemented triggers and stored procedures and enforced business rules via checks and constraints.

4. Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.

5. Used SQL Profiler and Query Analyzer to optimize queries and stored procedures.

6. Used custom logging to have more detailed information of the work flow.

7. Developed SSIS packages to load data from Excel file to SQL Server Database.

8. Extensively used Script Component to do row by row processing, performs validations as per the requirement.

9. Responsible for analyzing/gathering the user requirements to generate the reports using SSRS.

10. Developed Parameterized, Drill-down, Drill-through, Sub-Reports and Charts in SSRS.

11. Identified the Data Sources and defining them to build the Data Source Views.

12. Developed Query for generating drill down and drill through reports in SSRS.

13. Formatted SSRS reports using Global Variables, Expressions and Functions for the reports.

14. Configured Report Model for developing ad-hoc reports by the end-users.

15. Uploaded reports on to the report manager and organized them into folders.

16. Validate the User Credentials against Active directory from Excel Source using Script Component Transformation.

17. Responsible for troubleshooting and problem solving during package development and deployment.

18. Involved in documentation of whole project majorly which helps the supporting team.

Environment: MS SQL Server 2005, SSRS 2005, SSIS 2005, T-SQL, SQL Profiler, Windows Vista, MS Office.

Client: Lincoln Financial Group, Edison, NJ Mar’08 – Jan’09

Role: .NET Developer (Security and Hierarchy Application)

Various applications at Lincoln had its own login authentication system that makes users to supply a specific login/password for that application every time they want to use it. The Security and Hierarchy Application was devised to centralize the login authentication process to gain access to all these various applications with single sign-on approach. This was part of the Enterprise Wide Architecture implementation.

Responsibilities:

1. Designed and developed asp.net web application(C# code) that is an interface used by all the applications in the organization.

2. Involved in designing the front-end for the Hierarchy Application.

3. Maintaining a web application using IIS6.0.

4. Created classes to use in the web application.

5. Involved in creating user controls required for the design of front-end for Hierarchy application.

6. Created HTML scripts in order to validate HTML form's data that was submitted by the user.

7. Used Java scripting and AJAX for client side scripting

8. Designed database for the application, part of Hierarchy application.

9. Used different Validation Controls like Required Field Validator, Range Validator, Compare Validator.

10. Involved in numerous logo designs using Dreamweaver and Flash and PhotoShop.

11. Programming ADO.NET for communication between application and the SQL Server database.

12. Working Experience with SSIS, SSRS and DTS.

13. Involved in designing a user friendly interface to test the web application.

1. Involved in System Unit Testing and Integration testing in development environment.

Environment: .NET Framework 2.0/3.0, ASP.NET 2.0, Web Services, C#, JavaScript, HTML, XML, CSS, SQL Server 2000/2005, IIS6.0, T-SQL, Agile software development, Visual Source Safe, Windows XP

Client: InfoTech Enterprises Ltd, India. Jan’05 to July’06

Role: .NET/SQL Server Developer

Medical Inventory Management System (MIMS) is a web-based application developed for Doctors and Small Hospitals to maintain the Inventory of the drugs.

Responsibilities:

1. Actively involved in analyzing the old database system and mapping tables, relationships, columns to SQL Server 2000. Efficiently worked in installation, configuration, design, implementation of staging database for data migration and data entry.

2. Developed SQL scripts to Insert, Update and Delete data in MSSQL database tables in OLTP environment.

3. Successfully managed Extraction, Transformation and Loading (ETL) process by pulling large volume of data from various data sources using DTS, BCP.

4. Assisted in designing and creating website utilizing ASP and .Net technologies for the system using ADO.Net, HTML, XML in designing form, validating inputs and connecting to backend database

5. Performed data consistency and performance tuning effectively with SQL Profiler, Index Tuning Wizard

6. Performed rigorous Performance Tuning of queries written in middle layer and backend to gain huge performance gain of webpage loading.

7. Prepared scripts to upgrade the software from one version to another and make sure the client’s production data has been correctly populated after the up gradation.

8. Data migration (import & export – BCP) from Text to SQL Server.

9. Used Crystal Reports to generate ad-hoc reports Filtered bad data from legacy system using complex T-SQL statements, and implemented various constraint and triggers for data consistency. Wrote complex stored procedures to process driver’s record and balanced the processing load between front end and back end. Developed and created data dictionary, stored procedures, advanced queries, triggers, views, indices, and functions for databases.

10. Developed windows based applications in C#.Net for interacting and retrieving data from SQL Server, also made applications for entering criterion and opening reports from Crystal Reports Created complex reports in Crystal Reports using procedures from SQL Server by passing in stored procedure parameters.

11. Involved in testing and debugging business logic in Store Procedures with Application Development Team.

Environment: MS SQL server 2000, DTS, Oracle, ASP, C#.Net, Windows2000/NT, Crystal Reports

Client: InfoTech Enterprises Ltd, India Mar’03 – Dec’04

Role: SQL Developer /DBA

This project mainly deals with equipment maintenance and its spare parts, utilization of man-hours, machine hours and calculating the cost of maintenance. It deals with preparing automatic scheduling for machines and their maintenance after its installation and based on its first frequency date. The project ultimately aims to prevent breakdowns by preparing perfect schedules for machines in time. This also deals with indents, issues, purchases and returns from various depts. It also aims to produce reports on total cost of consumption, machine hours, man-hours, spare parts for calculating the idle time of each equipment etc.

Responsibilities:

1. Used Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.

2. Created Database Maintenance Planner for the Performance of SQL Server which covers database Integrity Checks, Update Database Statistics and Re-indexing.

3. Transformation Services, Crystal Reports

4. Created stored procedures and triggers for maintaining SQL Server, Written Stored Procedures for Application Developers.

5. Data Transfers between various servers using BCP and Managing Disk space on NT systems.

6. Designed different kinds of Transactions for the application.

7. Interacting with the users and troubleshooting the problems involved with the development of stored Procedures, triggers and problems related to the privileges.

8. Created Stored Procedures, Triggers, Views and Functions for the Application.

9. Extensive testing on the performance of the stored procedures.

Environment: SQL Server 2000, Transact-SQL, Excel, Windows 2000 Server.

Contact this candidate