Summary

• 3+ years of IT experience in System Analysis, Design, Development and Testing in Software Development, MS SQL Server 2005/2008 in Production. Proficient in BI Suite, including SSRS, SSIS and SSAS of MS SQL Server 2005/2008.
• Efficiently used T-SQL in constructing Triggers, UDFs, Views, Stored Procedures and Indexes.
• Expert in Extracting, Transforming and Loading data using ETL Strategy.
• Excellent in High Level Design of ETL & SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, SQL Server, Oracle, Flat File, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Lookup, Bulk Insert, Merge and Union all.
• Created package configurations to provide an easy solution to migrate through ETL packages across environments.
• Developed and implemented strategies for improving and further leveraging existing reports in order to transfer / convert to SQL Server Reporting Service
• Extensively worked on three stages of enterprise reporting like Authoring, management and delivery using SSRS.
• Created several reports using SSRS like drill down, drill through, parameterized, linked and sub reports.

Technical Skills

Windows 95, 2000,
Server 2003, XP, NT

Databases/Data Access

MS Access, OLAP, OLTP,SQL Server 2000/2005/2008, SQL Reporting Services 2005/2008, SQL Integration Services 2005/2008, SQL Analysis Services 2005/2008

Languages/Tools

T-SQL, PL\\SQL,
Erwin,
MS Visio 2003 MS Visio 2003 T-SQL, PL\\

Experience

Confidential,California
SQL Database Developer

Feb’12- Current

Responsibilities:

• Converted complex business logic into SQL Stored Procedures and user-defined functions to achieve functionality required by end users.
• Involved in gathering requirements to implement business logic into high performance stored procedures.
• Migrated mainframe to SQL Server 2008 for taxes, title and order for different states and counties.
• Created new and modified existing stored procedures for better performance and also for documentation.
• Analyzed the index fragmentation and created SQL Scripts to handle the index fragmentation of various tables as a part of performance tuning.
• Perform query optimization and database optimization on daily bases.
• Created scripts to analyze data between Mainframe and SQL server in staging and production environments.
• Created county specific property taxes reports to support business requirements and analysis.
• Optimized existing and new queries to improve performance with the use of SQL Profiler, DTA and Execution Plans.
• Developed complex stored procedures to assist with migration from Mainframe to SQL server 2008 R2.
• Responsible for all scripts, stored procedures and database development for DB Tax related issues.
• Created managerial reports using SSRS to our tax and title database and support business needs.
• Promptly and efficiently responding to issues related to data, performance tuning and or SQL scripts for Production, Stage and DEV through ICP’s requested through IssueView.

Environment: SQL Server 2008 R2, TSQL, SSIS, SSRS, BIDS, TFS, Visual Studio 2010, Management Studio, SharePoint, Issue View, Microsoft Excel

Confidential,Minnesota
Reports Developer/Data Analyst

Jul’11–Jan’12

Responsibilities:

• Developed functional/technical specifications such as Business Scope Document and High Level Design Document.
• Worked closely with Business Owner, Project manager, subject matter experts and system architecture to define business requirements and create business requirements documents for signoff and agreement.
• Created complex SQL scripts and Stored Procedures to extract the data from the relational sources for SSIS Packages.
• Involved in scheduling packages through SQL Server Agent and setting up shared schedules.
• Created XML and SQL Table package configurations to provide an easy solution to migrate the ETL packages from different business environments such as development to testing or testing to production.
• Administrated interface to organize reports and data sources, schedule report execution and delivery, subscription of reports and track reporting history
• Expertise in creating both forms of reporting like ad-hoc reporting as well as enterprise reporting. Extensively worked on three stages of enterprise reporting like Authoring, management and delivery using SSRS.
• Developed Sub Reports, Matrix Reports, Charts, and Drill down reports using SQL Server Reporting Services (2008).

Environment: SQL Server 2008/2008 R2, TSQL, SSIS, SSRS, BIDS, TFS, Management Studio, Sybase, SharePoint

Confidential,Georgia
SQL BI Developer

Jun’10–Jun’11

Responsibilities:

• Extensively involved in gathering business requirements that will facilitate the planning and the implementation phase of a data warehouse.
• Designed and implemented OLTP database using Microsoft SQL Server 2008.
• Created objects such as: Stored Procedures, Triggers, User define functions, Indexes, Views, and Indexed views.
• Involved in scheduling packages through SQL Server Agent and setting up shared schedules.
• Involved in full life cycle of Reporting starting from the Authoring phase, the Management phase all the way to the Delivery phase
• Handled the reporting server and was actively involved in creation of various types of complex reports
• Responsible for identifying and defining the Datasets for the report generation, writing the queries for the drill down reports, and identifying and adding the report parameters.

Environment: SQL Server 2008/2008 R2, SSIS, BIDS, Management Studio, Server Agent, Windows Server 2003

Confidential,Georgia
ETL Developer

Jun’09–Mar’10

Responsibilities:

• Created several tables, views, stored procedures, functions using SQL Server 2005 T-SQL. These objects were created based upon the functional specification.
• Generating scripts and schemas by using reverse engineering through Erwin Data Modeler.
• Created the structure of the model and cube in Analysis Services.
• Involved in extracting the data using SSIS from OLTP pre-staging to OLAP staging.
• Responsible on making weekly backup databases by using SQL Server 2005 and restore these databases in a standby server.
• Responsible for configuration, security, and maintenance of SSIS and SSRS.
• Designed, developed and deployed reports in MS SQL Server environment using SSRS-2005.
• Migrated data from different sources including flat files, MS Access, Oracle 8i/9i to SQL Server 2005 by using SSIS.

Environment’s SQL Server 2005, Erwin 7.0, Excel and Access 2007, SSIS, SSRS, Microsoft Server 2003

Education

Bachelors in Science