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