Sql Server Project Manager

GAUTHAM NARASIMHAPRASAD

Email: *******.*@*****.*** Richardson, Texas

Ph: 972-***-****

Summary:

* + years of strong IT experience in SQL Server 2008 R2/2008/2005/2000 development &

application support

Familiarity with Oracle PL/SQL Procedures, TOAD and Informatica Power Center 8.6.1

Experience in handling 24X7 Production Support Teams at onshore and offshore

Highly experienced in SDLC and Agile methodology

Strong experience in preparing and delivering drill down, slice and dice reports,

parameterized reports, Linked reports, and Snapshots using SQL Server Reporting services

(SSRS)

Strong Experience in creating report server model designer

Extensively used ETL methodology for performing Data Migration, Extraction,

Transformation and Loading using SQL Server Integration Services SSIS and designed data

conversions from wide variety of source system.

Expertise in working on all activities related to the development, implementation,

administration and support of ETL processes for large-scale Data Warehouses using SSIS

with MS SQL 2005/2008R2.

Experienced in installing, configuring and deploying MS SQL Server suite of products that

includes SQL Server Integration Services, SSRS, SSAS

Experience in migration of Data from Excel, Flat file, Oracle to MS SQL Server by using SSIS

and the DTS utility. Extracting, Transforming and loading of data using SSIS and DTS

Dimensional Data Modeling and Cube Development in SQL Server

Experience in data normalization and data modeling using Erwin

Strong knowledge in SQL Server disaster recovery, backup/restore, migration and upgrade

participated in disaster recovery drills

Hands-on working experience with analyzing query plans, using extended Stored

Procedures, managing indexes and troubleshooting deadlocks in SQL Server2008/2005

Database consistency checks using DBCC Utilities

Experience in using SSIS tools like Import and Export Wizard, Package Installation, Job

Scheduling and SSIS Package Designer

Transformed data from one server to another using Conversion, Audit, Derived Columns,

Lookups, Merge, Merge Joins, Slowly Changing Dimension

Familiarity in defining data warehouse (star and snow flake schema), fact table, cubes,

dimensions, measures using SQL Server Analysis Service

Excellent multi-tasking capabilities including multiple client interaction

Excellent communication, analytical, interpersonal, presentation, project management skills

and ability to work with minimum supervision in large and small teams

Extensively worked and handled multiple offshore teams globally located in India & Mexico.

Education:

Bachelor of Engineering in Computer Science & Engineering, RNS Institute of Technology,

Bangalore, INDIA [Affiliated to Vishweshwaraya Technological University, INDIA].

Technical Skills:

Database : MS SQL Server(2000, 2005, 2008), MS Access, Oracle

Programming : SQL/ PLSQL, UNIX Shell scripting, HTML

SQL Tools : SSIS, SSRS

Scheduler Tools : Autosys, SQL Server Job Scheduler

Source Control : Perforce, Visual Source Safe

ETL Tool : Informatica Power Center 8.6.1

Other tools : Microsoft Office suites (Visio, Project, Word, PowerPoint, Access,

Excel, Outlook, Project)

Operating Systems : Windows 7, XP, 2008

Methodologies: Possess familiarity with both Waterfall and Agile Methodologies including

SCRUM

Professional Experience:

Bank of America, Addison TX.

Job Title: Technical Business Analyst - SQL Server/SSIS/SSRS Developer (Dec 2011 -

Present)

Working on multiple applications on the ATM Data Channel which involves reporting the

Debit/Credit transactions from the ATMs, Installation & de-installation of the ATMs,

Ordering parts and payment tracking for the vendors and Inventory management of ATMs.

Project Responsibilities:

• Gathered requirements and designed normalized and de-normalized tables and

relationships using agile methodology including Data Modeling with Erwin

• Designed complex T-SQL queries, User Defined Functions; Stored Procedures and

Triggers in SQL Server followed by analysis and testing of those database objects before

deployment to the production server

• Writing complex stored procedures and User defined functions and enforced business

rules via Checks and Constraints

• Maintained Change Control and Release Management process for all database objects like

Tables, Views, Procedures and Triggers

• Identified, tested, and resolved performance issues of poorly running queries and

performance of database itself by using Index Tuning Wizard, SQL Profiler, and Query

Analyzer. Also monitored Deadlocks in SQL server using SQL Server Profile in SQL Server

2008 R2/2008/2005

• Updated the statistics info and managed Clustered and Non-Clustered Indices for

improved database performance

• Improved the Scalability and Manageability of large tables by creating Table Partitions

and maintained Data Consistency and Data Integrity by applying various constraints like

Primary Key, Foreign Key, Unique, Check, and Default

• Designed and developed Data Warehouse processes. Mapped disparate data sources - flat

files, Excel spreadsheets, Comma Separated Value files and Tab delimited text files using

various transformations to target schema

• Designed Extraction Transformation and Loading (ETL) process to source and scrub data

in a landing temporary table as well as legacy data sources using SSIS in SQL server

• Well versed with different components of SSIS (Control Flow, Data Flow and Connection

Manager) while extensively using different kinds of Containers, Control Flow Tasks and

various Transformations under data flow tasks

• Highly experienced in developing SSIS complex and multistage SSIS packages using

various tasks such as For-each-loop, Execute Process Task, Data Flow task, Execute SQL

task, Custom Script Task, Analysis Services Task, Data Mining Task, FTP Task, File System

Task, Send Mail Task, Bulk Insert Task

• Created Master SSIS packages in order to execute a set of packages on a timely basis and

deployed those packages using Manifest Files and Import/Export Wizard so that the

packages were available for use to other team members;

• Implemented data warehouse design principles and Best Practices for maintaining

dimension and fact tables

• Developed analytical and transactional reports using SSRS 2008 such as open rates,

bounce rates, click rates, invalid rates, duplicate rate, opt out rate. Developed reports

based on OLAP cubes. Developed ETL process monitoring reports. Used Report Builder to

develop ad-hoc reporting

• Used SSRS Reporting services to write complex formulas and to query database to

generate different types of reports (Drill Down, Drill Through, Linked, Sub-reports, and

Parameterized) for Business Intelligence

• Created, updated and maintained ETL Technical Documentation for future reference by

other team members

• Worked with SQL Server Agent to create the job and monitor closely for job run

• Worked in a team of 6 which includes Business Analysts, Data Architect, Database

Developers, .Net Developers, and Project manager.

Environment: MS SQL Server 2008 R2, SSIS, SSRS, T-SQL, ER Win, .Net, Windows XP, 7

Bank of America, Dallas TX.

Job Title: Programmer Analyst - SQL Server (Mar 2008 – Nov 2011)

Worked on applications for Banking Center Control Review and dashboard reporting

application for various metrics on the banking center performance. The reports were shared

with 3-dot\4-dot managers in the Bank.

Project Responsibilities:

Analyzed requirements and designed normalized and de-normalized tables and

relationships using SDLC methodology including Data Modeling with Erwin

Designed complex T-SQL queries, User Defined Functions; Stored Procedures and

Triggers in SQL Server followed by analysis and testing of those database objects before

deployment to the production server

Writing complex stored procedures and User defined functions and enforced business

rules via Checks and Constraints

Maintained Change Control and Release Management process for all database objects

like Tables, Views, Procedures and Triggers

Updated the statistics info and managed Clustered and Non-Clustered Indices for

improved database performance

Designed and developed Data Warehouse processes. Designed and developed stage

data model and dimensional data model for data warehouse. Mapped disparate data

sources - relational Databases and text files onto target schema

Designed Extraction Transformation and Loading (ETL) process to source from Oracle

applications as well as legacy data sources. Developed ETL processes to source data

from flat files using SSIS 2008. Designed ETL processes to load fact and dim ension

tables in data warehouse

Developed T-SQL functions and stored procedures. Developed SSIS complex and

multistage SSIS packages using For-each-loop, Execute Package, Data Flow task, execute

SQL task, Custom Script Task, Analysis Services Task, Data Mining Task

Developed Transformations using Data Conversion, Audit, Derived Columns, Lookups,

Merge, Merge Joins, Slowly Changing Dimension transformation. Scheduled the ETL

processes on SSIS server and managed integration server

Designed indexes to tune the ETL process performance. Developed, modified, and

optimized complex queries and stored procedures to data retrieval and modification.

Developed analytical and transactional reports using SSRS 2008. Developed reports

based on OLAP cubes

Developed ETL process monitoring reports. Used Report Builder to develop ad-hoc

reporting for ETL QA as well as for DW UAT process

Created, updated and maintained ETL Technical Documentation for future reference by

other team members

Worked with SQL Server Agent to create the job and monitor closely for job run

Environment: MS SQL Server 2005/2008, SSIS, SSRS, SSAS, T-SQL.

Infosys Ltd, Bangalore, INDIA.

Job Title: Software Engineer (Jul 2005 – Mar 2008)

Worked on application supporting the Client Sales activity reporting.

Project Responsibilities:

• Experience in working with clients on-site, analyzing software requirements and

developing solutions and procedures.

• Involved in creating database objects like tables, views, procedures, packages using

Oracle tools like PL/SQL, SQL*Plus, Toad.

• Wrote PL/SQL functions, cursors, triggers and embedded them in PL/SQL packages

• Involved in creating SQL queries for online report accessed by the end user via the

dashboard

• Involved in creating monthly reports for the activities happening across the sites and

sending them to clients.

• Involved into updating procedures, functions, triggers, and packages based on the change

requests.

• Used Informatica Power Center to load data into database

• Involved in creating shell scripts to send emails and to invoke PL/SQL scripts.

• Involved in unit testing, System Integration testing and User Acceptance Testing of the

oracle Objects

• Provided Test Data to QA team to validate front end application. Also performed unit

testing for online reports.

• Performed tuning and optimization on SQL queries using SQL Trace and explain Plan.

• Tested the original and optimized codes thoroughly for failures before exporting to other

environments

• Involved in Production support monitoring the Autosys jobs for processing the data.

Environment: Windows XP, UNIX, Oracle, PL/SQL, SQL, TOAD 12, SQL Developer,

SQLLOADER, Shell scripting.

Contact this candidate