Venkata

PROFESSIONAL SUMMARY:

Over * years of Information Technology experience in Database Design, Development and Testing, ETL (SSIS) and

strong reporting experience using SQL server 2012/2008r2/2008/2005/2000 in various domains like Healthcare, Airline,

Finance, Insurance and Telecommunication

Has depth knowledge in analyze and creating end to end test plan to make sure functionality, performance, reliability,

stability and compatibility of developing application

Developed, documented and maintained functional test cases and other test artifacts like the test data, data validation and

automated scripts by using MTM tool and also involved in backend database testing in Microsoft SQL environment

including validating stored procedures, views and jobs

Created program specifications and unit test plans, developed codes. Implemented testing, transition and support

activities and ensured that validated deliverables meet functional and design specifications and requirements

Was involved in migration of data from source to destination (Staging to main DBs)

Was involved in migration of data from SQL server 2008/2008r2 to 2012

Created and modified tables, views, user defined functions, cursors, derived tables, common table expressions (CTEs)

and triggers to facilitate efficient data manipulation and data consistency based on the functional requirements by using

SQL SERVER.

Created and modified sub query, correlated sub query, complex stored procedures and ad hoc TSQL statements, Creates

and maintains Cluster Index and Non Cluster Index based on the functional requirements by using SQL SERVER.

Backup and Restore Databases in different environments using production Dump, creating, designing and building data

migration processes by using SSIS for Data Warehouses

Encapsulates Ad hoc TSQL statements into Store Procedures for Optimization

Writes ad hoc queries utilizing Dynamic SQL and SQLCMD command line utility

Generated on demand and scheduled reports for business analysis or management decisions using SQL Server Reporting

Services 2010/2008/2005

Configured report server and report manager scheduling, gives permissions to different level of users

in SQL Server Reporting Services (SSRS)

Schedules and deploys reports and uploads files to a report server catalog from the report manager

Implemented ETL Packages using DTS (Data Transformation service) and SSIS 2012/2010/2008/ 2005, creating SSIS,

DTS packages for large data transfers between MS SQL Servers and automating using SQL jobs

Created master and child packages, package configurations and logging

Extracts, transforms and loads data (ETL) between Homogenous and Heterogeneous System using SQL tools (SSIS,

DTS, Bulk Insert, BCP, and XML)

Created Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages

Possesses excellent technical and analytical skills with a clear understanding of data architecture, metadata, design goals

of ER modeling for OLTP and dimension modeling for OLAP

Designs, creates and processes cubes using SSAS

Calculates measures and dimension members using multidimensional expression (MDX), mathematical formulas, and

user defined functions

Worked with Microsoft VSTF (2013, 2012), MS Share point and MTM (Microsoft test manager)

Converted project specifications and procedures to detailed logical flow charts in technical specification documents.

Designs and implements relational database model as per business needs

Technical Analysis, Code Review, Implementation and support as a team member.

Analyzes, designs, develops, tests and implements systems following the SDLC (Agile methodology)

TECHNICAL & FUNCTIONAL SKILLS:

Experiences in Quality Management Software and Processes, Knowledge and experience in technical aspects of software

solution being tested, Business process understanding Enterprise Manager.

Microsoft VSTF ( 2013 & 2012), MTM tool, Profiler, Query Analyzer, MS SQL Server 7.0/2000/2005/2008/2012, MS

Access, DTS, SSIS,SSRS,SSAS, SQL, T SQL, VB.Net, C#, and Oracle, HTML, XML, CSS, My SQL, Software

Development Life Cycle, ERVIN data modeler (7.1),Windows 2000/NT, Windows 2000

Server/Windows95/98/2000/XP/Vista/Windows7/Windows8.

EDUCATION & CERTIFICATIONS:

Bachelors

PROFESSIONAL EXPERIENCE:

Client: Microsoft, Redmond WA Duration: 03/2014 Present

Role: SQL BI Developer

Microsoft is world leading company in software, services. Its mission to discover, develop, manufactures and licensing new

software’s that help people and businesses to realize their full potential and also it has new business vision in mobile

technology. Scope of the project was create DB of transactional sales data of eligible business partner and calculate their

incentives based on their transaction to increase sales of Microsoft products to drive business.

Responsibilities:

Worked with project lead and business users to understand business processes, gather and document project

requirements and translate them into functional and non functional specifications for applications & BI purpose

Develop, document and maintain functional test cases and other test artifacts like the test data, data validation,

harness scripts and automated scripts

Analyzed, designed, executed test cases based on end to end various test case scenarios based on functional

requirements by using MTM tool

Review functional and design specifications to ensure full understanding of individual deliverables

Backend database testing in Microsoft SQL environment including validating stored procedures and jobs

Identify test requirements from specifications, map test case requirements and design test coverage plan.

Ensured that validated deliverables meet functional and design specifications and requirements.

Isolate, replicate, and report defects and verify defect fixes (bugs)

Developed & modified various T SQL stored procedures, views, and adding/changing tables for data load and

transformation, and data extraction from sources DBs

Wrote Stored Procedure, Queries, User defined functions as per the business requirements

Optimized existing stored procedures and various T SQL queries

Wrote Dynamic Store Procedure to move data from Staging to Application

Used Execution Plan a and Database Engine Tuning Advisor to optimize queries and enhance the performance of

databases

Managed index, statistics and optimize queries by using execution plan for tuning the database

Improved Performance by creating Clustered and Non clustered Indexes and by Optimizing the T SQL statements

using SQL profiler

Modified ETL Packages using DTS(Data Transformation service) and SSIS 2012/2010/2008/ 2005, creating for large

data transfers between source DBs ( Staging ) to destination DBs (MS SQL Servers )

Scheduled jobs to call the packages and Stored Procedures as per business requirement

Deployed, tested and scheduled SSIS packages using SQL Agent

Added more audits and alerts in SSIS Packages in case of package failure

Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and

Linked reports

Deployed and scheduled Reports using SSRS to generate all reports including current status

Was involved in daily scrum ( daily stand up call ), sprint planning & tech review monthly to understand requirement

from business

Tools & Technologies:

Microsoft VSTF ( 2012, 2013 ), MS SQL Server 2012, T SQL, BI tools 2010 ( SSIS, SSRS), MS SQL Profiler, SQL Query

Analyzer, SQL Server Index Tuning Wizard, Erwin v7.1, Windows 7 & 8, Office 365 & MS office, MTM tool

Client: Bristol Mayer’s Squibb, Syracuse NY Duration: 01/2013 – 02/2014

Role: MS BI developer

Bristol Myers Squibb is a global Pharmaceutical company firmly focused on its mission to discover, develop and deliver

innovative medicines that help patients prevail over serious diseases. A market leader for more than 40 years, industry

expertise and advanced technology to deliver the most accurate perspectives and in depth analytics on healthcare dynamics.

Scope of project was extracting data from different sources and loading into DW and generating reports for business users.

Responsibilities:

Migrated data from Heterogeneous data Sources (Excel, Flat file, CSV file, Oracle ) to centralized SQL Server databases

using SQL Server Integration Services (SSIS) to overcome transformation constraints

Created package to transfer data between OLTP and OLAP database using Lookup, Derived Columns, Condition Split,

Aggregate, Execute SQL Task, Data Flow Task, Execute Package Task etc to load underlying data in to the tables from

Text files, Excel file and CSV file

Developed packages to handle data cleansing, loading multiple files and executing tasks multiple times (using For Each

Loop )

Developed Master Child Package using Execute Package Task and Parent Package Variable Configuration

Modified the Existing SSIS Packages and added more audits and alerts in case of package failure

Designed, developed and deployed reports in MS SQL Server environment using SSRS 2008

Used SSRS to generate sub reports, drill down , drill through , tabular , and parameterized reports

Generates on demand and scheduled reports for business analysis or management decisions using SQL Server Reporting

Services

Schedules and deploys reports and uploads files to a report server catalog from the report manager

Worked with T SQL to create Tables, Function and Stored Procedures, sub query, correlated sub query, complex Stored

Procedures and ad hoc TSQL statement

Created Views and Synonym to reduce complexity of end user

Performance monitored and tuned TSQL queries using SQL Profiler and database engine tuning advisor

Created Cluster and Non Cluster Index to optimize performance of TSQL queries

Scheduled job using SQL Server Agent for SSIS Packages and Store Procedure as per requirement

Stored all versions of data using team foundation server (TFS) & Share point for documentation

Developed and wrote documents for Stored Procedures, SSIS Packages and SSRS Reports

Tools & Technologies:

MS SQL Server 2012/2008, T SQL, SSIS 2010, SSRS 2010, MS SQL Profiler, Microsoft VSTF ( 2010 ), SQL Query

Analyzer,, Erwin v7.1, SQL Server Index Tuning Wizard, Windows XP, MS Office 2003/2007/2010, MS Access, Business

Objects.

Client: Jet blue airways, Queens, NY Duration: 05/2012 – 12/2012

Role: MS BI Developer

JetBlue Airlines is one of the largest airline company in USA, it provides domestics as well international flight services. The

project goal was to design and develop ODS (Operational data store) and to develop a daily basis feed for the Customer

Loyalty using SSIS. Reports have been generated using SSRS & BO.

Responsibilities:

Works with Project Manager and Business Analyst to understand business requirement and created FDM for

business intelligent purpose from heterogeneous sources of data.

For FDM purpose was migrated data from SQL server 2008 to 2012.

Designs, develops SSIS (ETL) packages to load data from OLTP system, DSR Staging Database to DW.

Develops Package Configuration by using SQL Server type for making Package dynamic.

Modifies the existing SSIS packages and adds audits and alerts in case of package failure.

Writes documentation for each package with definitions, tables, and logic behind the packages.

Schedules job using SQL Server Agent for SSIS Packages and Store Procedure as per requirement.

Successfully tests all tasks in staging and stores all versions of data using team foundation server (TFS).

Designed, developed and deployed reports in MS SQL Server environment using SSRS 2008.

Used SSRS to generate sub reports, drill down , drill through , tabular , and parameterized reports.

Generates on demand and scheduled reports for business analysis or management decisions

using SQL Server Reporting Services.

Generates SSRS Report through SSIS Package using script component as per business requirement.

Schedules and deploys reports and uploads files to a report server catalog from the report manager.

Creates database objects like Table, Store Procedure, Triggers, Functions using T SQL to provide structure to store

data and to maintain database efficiently.

Performance monitors and tunes TSQL queries using SQL Profiler and database engine tuning advisor

Creates Index to optimize performance of TSQL queries.

Develops and creates documents for Stored Procedures, SSIS Packages and SSRS Reports.

Tools & Technologies:

MS SQL Server 2012/2008,2008r2, T SQL, SSIS 2008r2, SSRS 2008r2, MS SQL Profiler, SQL Query Analyzer, SQL

Server Index Tuning Wizard, Visual Studio 2010, ER Studio 9.5, Windows XP, MS Office 2003/2007/2010, MS Access,

Business Objects.

Client: Sallie Mae, INC, Newark, DE Duration: 08/2011 – 04/2012

Role: Sr SQL Database developer

Sallie Mae provide financial services to hundreds of college campuses as well as to federal and state governments. They

providing private education loan, Insurance services and also they work on collection services behalf of government

agencies. For this project, worked as a part of the team responsible for the development of Billing and Customer

Relationship Management system.

Responsibilities:

Create data mappings and data dictionaries by understanding business data relationships by working with Business

Analyst & Project Manager.

Writing views, function and ad hoc queries in an effort to enhance the testing automation framework in support of various

application like MBT (Model Base Testing) also enhancements for maintained health care upgrades (HIPPA 5010, ICD 10

etc.)

Wrote complex store procedure in order to map ICD 9 to ICD 10 codes as well as auto generation of claims.

Involved in performance monitoring and trouble shooting issue in SQL Server database and validating transactions. Also

scheduled maintenance job using SQL Server Agent.

Used SQL Server Profiler, Database Engine Tuning Advisor and Execution Plan to improve performance of existing sql

code.

Responsible for creating cluster and non cluster indexes and maintain indexes with help of fragmentation percentage as

well as used table partitioning to handle huge tables like Claims, Enrollments and MBT Results.

Create SSIS Packages using Business Intelligence & Development Studio in order to move data between development,

staging and production database on different servers.

Developed packages and procedures to get data from DB2, X12 and FCR and load into SQL Server DB.

Responsible for generating ad hoc reports for MBT testing using SQL Server, MS Excel and MS Access, SSRS also

develop and maintain VBA code within Excel templates and MS Access.

Generates SSRS Report through SSIS Package using script component as per business requirement.

Successfully tested and stored all history versions of TSQL codes, SSIS Packages as well as reports using Team

Foundation Server.

Involved in backup and recovery strategy planning.

Analyzed the error output and error log of an automated process in case of failure of the process.

Responsible for documentation including design consideration, assumptions, functional and technical description, data

model with execution flow diagrams.

Tools & Technologies:

MS SQL Server 2005/2008/2008R2, SSIS 2008r2, SSRS 2008r2, Quick Test Professional 11.0, HP ALM 11, SRTS (Team

Track), Rocket Shuttle, Web Sphere 5.1, MQ Series, XML, SOAP, VB script, HTML, IIS, Web Services, DB2, Windows

XP,MS Word, MS Excel, MS Access, 4010 & 5010 HIPAA EDI, ICD9 & ICD10 Diagnosis and Procedure Codes,

Mainframes (Cobol, DB2)

Client: Discover Financial Services, River woods, IL Duration: 01/2011 07/2011

Role: MS SQL Server Developer

Discover Financial provides credit cards, Loans and banking service since 1985. Discover credit cards are third largest credit

card brand in USA. For this project, wrote SQL scripts and created packages to transfer the data from different systems and

altered the process to meet the new business requirements.

Responsibilities:

Designed and developed Logical, Physical of the DSR for the DW using Erwin.

Migrated data from Heterogeneous data Sources (Excel, Flat file, CSV file) to centralized SQL Server databases using

SQL Server Integration Services (SSIS) to overcome transformation constraints.

Created package to transfer data between OLTP and OLAP database using Lookup, Derived Columns, Condition Split,

Aggregate and Execute SQL Task Data Flow Task, Execute Package Task etc to load underlying data in to the tables from

Text files, Excel file and CSV file.

Developed packages to handle data cleansing, loading multiple files and executing tasks multiple times (using For Each

Loop).

Developed Master Child Package using Execute Package Task and Parent Package Variable Configuration.

Modified the Existing SSIS Packages and added more audits and alerts in case of package failure.

Worked with T SQL to create Tables, Function and Stored Procedures, sub query, correlated sub query, complex Stored

Procedures and ad hoc TSQL statement.

Created Views and Synonym to reduce complexity of end user.

Performance monitored and tuned TSQL queries using SQL Profiler and database engine tuning advisor.

Created Cluster and Non Cluster Index to optimize performance of TSQL queries.

Designed, developed and deployed reports in MS SQL Server environment using SSRS 2008.

Used SSRS to generate sub reports, drill down , drill through , tabular , and parameterized reports.

Scheduled job using SQL Server Agent for SSIS Packages and Store Procedure as per requirement.

Stored all versions of data using team foundation server (TFS).

Investigated and fixed several issues and proactively suggested new output formats to satisfy the statistician’s

requirements.

Developed and wrote documents for Stored Procedures, SSIS Packages and SSRS Reports.

Tools & Technologies:

MS SQL Server 2008, T SQL, SSIS 2008, SSRS 2008, MS SQL Profiler, SQL Query Analyzer, SQL Server Index Tuning

Wizard, Visual Studio 2005, Erwin v7.1, Windows XP, MS Office 2003/2007, MS Access, Business Objects.

Client: HCA Holdings, Nashville, TN Duration: 09/2009 – 12/2010

Role: MS SQL Server database Developer

Since1968, Nashville based Hospital Corporation of America was one of the nation's first hospital companies. Today, we are

the nation's leading provider of healthcare services, a company comprised of locally managed facilities that includes about

162 hospitals and 113 freestanding surgery centers in 20 states and England and employing approximately 199,000 people.

Scope of project was extracting data from different sources and loading into DW and generating reports for business users.

Responsibilities:

Worked with project lead and business users to understand business processes, gather and document project requirements

and translate them into functional and non functional specifications for BI reports and applications.

Developed various T SQL stored procedures triggers, views, and adding/changing tables for data load and transformation,

and data extraction.

Wrote complex Stored Procedure, Queries, Triggers, User defined functions as per the business requirements.

Optimized existing stored procedures and various T SQL queries.

Wrote Dynamic Store Procedure to move data from Staging to Application.

Wrote User Defined Function to calculate Single Target Ratio, Product Element ratio and Element Product ratio.

Improved Performance by creating Clustered and Non clustered Indexes and by Optimizing the T SQL statements using

SQL profiler.

Added more audits and alerts in SSIS Packages in case of package failure.

Created package to transfer data between OLTP and OLAP database using container, task and transformation to load

underlying data in to the tables from Text files.

Managed index, statistics and optimize queries by using execution plan for tuning the database.

Developed packages to handle data cleansing and scrubbing using Derived Column, Conditional Split, Script task etc. to

clean data.

Developed Master Child package using variables and Execute package task in SSIS.

Scheduled jobs to call the packages and Stored Procedures as per business requirement.

Deployed, tested and scheduled SSIS packages using SQL Agent.

Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and

Linked reports.

Deployed and scheduled Reports using SSRS to generate all reports including current status.

Used Execution Plan and Database Engine Tuning Advisor to optimize queries and enhance the performance of

databases.

Documented all kinds of SP’s and SSIS packages.

Tools & Technologies:

MS SQL Server 2008R2, T SQL, SSIS 2008R2, SSRS 2008R2, MS SQL Profiler, SQL Query Analyzer, SQL Server Index

Tuning Wizard, MS Visual Studio 2005,Windows XP, MS Office 2003/2007, Erwin v7.1.

Client: BB&T Corp, Winston Salem, NC Duration: 11/2007 – 08/2009

Role: SQL Server Database Developer

Since 1872 Branch banking & Trust continues to offer clients a complete range of financial services including banking,

lending, insurance, and trust and wealth management solutions. For this project, wrote SQL scripts and created packages to

transfer the data from different systems and altered the process to meet the new business requirements.

Responsibilities:

Worked with project lead and business users to understand business processes.

Created new logical and physical design of database to fit new business requirement and implemented new design

into SQL Server 2008.

Worked with T SQL to create Tables, View and stored Procedures.

Created triggers on DML actions for security purpose.

Worked with Scalar and Table value User Defined Function as per business requirement.

Used complex query statements like sub queries, correlated queries, derived tables, CASE functions to insert the

data depending on the criteria into the tables.

Encapsulated frequently used SQL Statements into stored procedures and reduced the execution time.

Wrote Merge Statement to handle insert, update and delete within single statement between source and destination

table.

Performance monitored and tuned TSQL queries using SQL Profiler and database engine tuning advisor.

Scheduled jobs to call the packages and Stored Procedures as per business requirement.

Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple heterogeneous

information sources (Oracle).

Created packages in SSIS with error handling and worked with different methods of logging in SSIS.

Created SSIS Packages to move the data from tab delimited flat flies into SQL database.

Made dynamic SSIS packages which did data scrubbing, including data validation.

Implemented OLAP Cubes, Facts, and Dimensions for providing summarized and aggregate views of large sets of

data and used Multi Dimensional Expression (MDX) to access them.

Developed Cascading, Drill down Reports to get monthly card details and profits using SSRS 2008.

Deployed, configured and managed reports using Report Manager and Report Builder.

Created Cross Tab and Sub Report using RDL.

Promoted RDLs to Reporting Service Server.

Used Visual Source Safe (VSS) for version control.

Tools & Technologies:

Microsoft SQL Server, SQL Server Integration Services tools (SSMS, BIDS and SQL Server Manager), SSRS, SSAS,

Business Objects, Windows Server, MS Visio, Oracle, MS Excel.

Client: IDEA Cellular, India Duration: 05/2006 – 10/2007

Role: Database Developer

Idea Cellular is an Aditya Birla Group Company, India's first truly multinational corporation. Idea Cellular is India's largest

Telecom Business operator. Idea offers a range of high speed mobile broadband devices and broadband Internet in India.

For this project, worked as a part of the team responsible for the development of Billing and Customer Relationship

Management system.

Responsibilities:

Worked with Sr. Developers to convert verbal requirements into technical format.

Modified code and provide extremely complex logic to the code for best results and better performance.

Used SQL Profiler to monitor the performance of SQL Server.

Scheduled replication on the databases.

Actively participated in meetings to decide the backup policies for the database and perform backup operations on

databases.

Performed Join operations using on large scale database tables.

Maintained table performance through normalization, creating indexes and collecting statistics.

Worked on MS SQL Server tasks such as batch jobs, BCP, DTS linked servers and indexes.

Created Indexes on database tables to perform the Read operations of the database.

Wrote extremely complex Stored Procedures with the use of Cursors, Triggers, and UDFs to provide best performance of

the application.

Tools & Technologies:

MS SQL Server 2000, T SQL, ER Win v4.0, Windows 2000

Contact this candidate