SUMMARY

• Over 5 of IT Experience in Database Design, Implementation, Development and support in Information Technology field and solved many complex business problems.
• Proficient in gathering Business Requirements from business stakeholders, Analyzing documenting System Requirement specification, Functional Requirement specifications and maintaining Requirements.
• Experience in moderating Joint Application Design (JAD), Workshops, Checkpoint Meetings, Interviews, Seminars, Conference, Review Meetings, Brainstorming meeting.
• Excellent knowledge of Software Development Life Cycle (SDLC), Data Warehouse Life Cycle (DWLC)
• Hands on Experience on Data warehouse concepts Normalization and Demoralization.
• Efficient Experience working on OLTP, OLAP and ODS.
• Good understating of Ralph Kimball’s and Inman strategies in approach to design large data warehouses
• Strong experience in MS SQL Server with Business Intelligence in SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS).
• Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services ( SSIS ), Log Shipping, DTS, Bulk Insert and BCP.
• Expert in writing T - SQL, working on DTS, SSIS, SSRS Data Cleansing, Data Scrubbing and Data Migration.
• Proficient in handling parameterized reports in SSRS 2005.
• Expert in defining Query for generating drill down reports in SSRS 2005 and designing stylish report layout.
• Experienced in using global variables, expressions and functions for the reports.
• Experience in developing Custom Report and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Experienced in sorting the data, defining data source and subtotals for the reports.
• Experience in creating Jobs, SQL Mail Agent, and scheduled DTS Packages.
• Well versed in defining/creating and handling Data Sources, Data Source views and parameterized Reports in SSRS 2005.
• Expert in using Bulk Copy Program (BCP), Data Transformation Services (DTS) packages and SSIS (integration services) with MS SQL Server 2000/2005.
• Expert in working with Trace files and Execution logs.
• Highly Proficient in the use of T-SQL for developing complex Stored Procedures, Triggers, Functions.
• Experienced in creating Tables, Views, Indexes and other SQL joins and query writing.
• Expert in developing T-SQL (DDL, DML) statements, Data Integrity (constraints), Rules, Performance Tuning, Query Optimization and Validation issues.
• Knowledge in PERFORMANCE TUNING of SQLSERVER.
• Strong analytical and problem-solving skills coupled with excellent documentation, verbal and inter-personnel communication skills and ability to acquaint to fast changing skills.
• Effectively manages time spent on multiple projects to meet deadlines.
• Team player and self-starter with excellent communication skills, ability to work independently or as a part of team and capable of picking up new skills quickly.

TECHNICAL SKILLS

Operating Systems: Windows 2000/ NT/ XP/ Vista/98/ 95, UNIX, Windows 2003 server.

SQL Server Tools: Enterprise Manager, Profiler, Query Analyser, Export & Import

RDBMS: MS SQL Server 7.0/2000/2005 , MS Access

Data Modeling: Erwin

Databases: SQL Server 2008-R 2/2008/2005/2000 , MS Access 2000/2003/2007.

ETL: DTS, SSIS

Reporting: SQL Reporting Services (SSRS)

Programming Languages: SQL, PL/SQL, T-SQL, VB.Net, C and C++

Productivity Applications: MS Word, MS Excel, MS Access, MS Project, Visio

PROFESSIONAL EXPERIENCE

Confidential

SQL,SSIS, SSRS Developer

Responsibilities:

• Created and Executed Daily jobs by using SSIS which Loads and updates database from flat files, Excel files, txt files and move them to archive folder dynamically with date stamp on them .
• Develop BI requests within standardized reporting infrastructure using SQL and Microsoft products. Develop parameterized reports from a variety of data sources as well as any necessary and Updated SSRS reports according to user’s requirement and scheduled it in timely subscriptions.
• Generated SSIS dtsx packages which select data on monthly bases, and on request from database on given conditions and place them on share drive for automatically for users to access in 2005/2008 visual studios.
• Develop Ad-hoc Reports and Timely reports Using SSRS
• Created packages for specific user’s request, monthly standard requests where it creates datasheet with parameters on drive, load data and email users with it and then archive if before next load.
• Handled monthly refresh data loads where SSIS packages will loads data from TSYS systems on SharePoint and loads data on monthly bases then execute store procedures which update data for OLTP reporting.
• Handled all linked server Build jobs, where data is been pushed to different servers based on requirements.
• Extensively worked on SQL store procedure in creating different types of jobs, to calculate and generate reports.
• Creating SSRS validation report which shows the difference between values for every date and scheduled it.
• Handled backup and recovery for database ones a month, then carried on with monthly refresh loads.
• Created automatic jobs for many manually handled requests and atomized them for more dynamic approach.
• Managed all request in the mail box and assigned them to appropriate team members.
• Transform complex business logic into Database design and maintaining it by using SQL objects like Stored Procedures, User Defined Functions, Views, T-SQL Scripting and Jobs, database side for performance improvement
• Create and maintain SQL stored procedures, Indexes, views, triggers, scheduled tasks and DDL scripts. Investigate, Analyze and document all conversion process and reported defects.

Environment: SQL Server 2005/2008 R2 Enterprise, Bug tracker, SSRS,SSIS,C#, VB .NET, Notepad++

Confidential, CA

SQl, SSIS, SSRS Developer

Responsibilities:

• Taking Requirement’s from client to process SSIS Tasks
• Created SSIS Packages which would load Data from MySQL to Sql server
• Created two types of packages where one is Refreshing loadand other is incremental load
• Created staging area when in incremental loads
• Extensively worked on T-Sql when doing incremental and Full loads
• Involved in Designing and updating Table properties
• Deployed the packages
• Creating and scheduled Jobs which when scheduled would load into Sql server on daily and Hourly bases
• Deployed the generated reports directly on the client’s workstation.
• Looked at the reports and fixed bugs in stored procedures.
• Worked as a developer in creating complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Created Table, Stored procedures and defined functions. Created SQL scripts for tuning and scheduling.
• Involved in unit Testing

Environment: SQL Server 2005/2008 R2 Enterprise, MS VISIO, Windows Enterprise Server 2003, IIS 7.0, .XML, Microsoft Visio 2003, SFTP, SSRS,SSIS, VB .NET.

Confidential, Los Angeles, CA

SQL SSIS, SSRS Tester/ Developer

Responsibilities:

• Responsible for gathering/refining requirements from the customer for developing reports.
• Worked with continuous flow operation with XML data, and integrated the application with XML data used DTD/exemplar technique to parse the xml data.
• Developed ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Migrated Organization, Orders, Adjustments, Objectives data in various formats like text based files, Excel spreadsheets, to SQL Server databases using SQL Server Integration Services (SSIS) to overcome the transformation constraints.
• Migrated DTS 2000 packages to SQL Server Integration Services (SSIS) and modified the packages accordingly using the advanced features of SQL Server Integration Service Worked with handling the xml data and worked with querying the xml, and export/import xml data integration with SQL server.
• Identified the Data Source and defining them to build the Data Source Views.
• Developed Query for generating drill down reports in SSRS 2005.
• Designed and implemented stylish report layouts.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Deployed the generated reports directly on the client’s workstation.
• Looked at the reports and fixed bugs in stored procedures.
• Worked as a developer in creating complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.

Environment: SQL Server 2000, Windows 2000 Advance Server, Windows 2003 Server, XML, T-SQL, MS Excel, MS Access, VB.NET 3.0 and DTS.

Confidential

SQL Server Developer

Responsibilities:

• Created Database Diagrams. Defined relationship between tables and enforced the referential integrity constraints.
• Design and implement Stored Procedures, Complex Queries using Joins & Sub Queries for inserting the customer data, to get the customer details and get the Category Plans.
• Wrote (T- SQL) and fine-tuned complex stored procedures using control of statements (Case, if else and While).
• Designed Views that are frequently required for the application.
• Created the database objects like tables and related table constraints.
• Involved in performance tuning of TSQL queries and Stored Procedures.
• Wrote T-SQL statements for retrieval of data.

Environment: MS SQL Server 2000, T-SQL, DTS, Windows2003, MS Visio, Visual Source Safe and FTP Communication, Replication, DTS, SQL-DMO.