Suresh Pathaneni

Email:acwxzj@r.postjobfree.com

Phone:214-***-****

Experience Summary

12+ Years of technical and functional experience in Information Technology, Database Administration, Architecture and Developer for very large and complex databases in SQL Server 2012, SQL Server 2008 R2, 2008 and 2005.

Microsoft Certified IT Professional – SQL Server Database Administrator 2008.

Microsoft Certified IT Professional – SQL Server Database Developer 2008.

Microsoft Certified Technology Specialist – SQL Server 2008 Business Intelligence Development.

Microsoft Certified Technology Specialist – MOSS 2007 Application Development.

Technical expertise in SQL Server 2000/2005/2008 and SQL Server BI Suite (SSIS, SSRS, SSAS)

Handled all aspects of Development Lifecycle including Architectural Design, Feasibility Studies, Scheduling, Release, Documentation and Support.

Development Projects in SQL Server 2000/2005/2008 and Microsoft.Net.

Interaction with Clients during requirements, Design, Acceptance.

Expertise in Administering SQL Server 2000/2005/2008/2012 and SQL Server Data.

Involved in Process Definition and Process Improvement.

Review of Specifications, Design, Code, Test Plans. Internal Auditing of the projects.

Generation of status reports and managing team to ensure delivery on time.

Technical Summary

Upgrade from SQL 2000 to SQL 2005, SQL 2008 and SQL 2012.

Handling all responsibilities in SQL Data Model (Logical and Physical) up to third Normal form.

Extensive usage of filegroups, Capacity Planning, Creating Indexes for better performance.

Designing, Setting up environments for Development, UAT, Production.

.Net Framework upgrade from 3.0 to 4.0.

SharePoint Portal migration from MOSS 2007 to MOSS 2010.

Expertise in publishing/deploying application along with SharePoint portals using SharePoint designer.

Created, Scheduled and monitoring jobs using Control M tool.

Developed web applications using C#.net, ASP.Net, ADO.Net, XML, AJAX.

Creating Master Data and Test Data. Creating & scheduling regular maintenance jobs.

Administering SQL Server High Availability and Disaster Recovery strategies.

Preparation of Project specific Coding Standards and Templates.

Expertise in writing Stored procedures, User Defined Functions and Creating Views, Triggers.

Creating Backups and Restoring Databases (Full and Transactional), USERs, Roles

Expertise in ETL process i.e., creating SSIS packages with error handling.

Designing solution framework for SSIS packages and Optimizing ETL Process.

Migrated data from different sources, Oracle, Excel files, Flat files, older version of SQL Server.

Used all typical features of SSIS like, FTP, Looping, Sequencing, File handling, XML tasks, Lookups, Scripting, Configuring packages, Logging events, Variables, Expressions and so on.

Integrated .Net assemblies with SSIS Packages.

Created Batch files to execute packages from DOS prompt.

Expertise in creating and deploying reports on Report servers using SSRS.

Optimization and tuning of report queries to improve performance. Integrating reports with .Net.

Knowledge in Datawarehousing Concepts, Data Mining, Data Marts, Facts, Dimensions, Cubes & SSAS

Helping out the development team in SQL Coding and Maintained Data Dictionary.

Created and maintained Database project in Microsoft.Net.

Preparation of Test Scenarios, Test Cases, Driving and executing Unit tests, Integration tests, System tests, User Acceptance tests.

Expertise in Debugging, Troubleshooting and resolving live, high-impact issues

Extensively used SQL Profiler to monitor the activities and for Index tuning wizard.

Certifications Summary

450

PRO: Designing, Optimizing and Maintaining a Database Administrative Solution Using Microsoft SQL Server 2008

451

PRO: Designing Database Solutions and Data Access Using Microsoft SQL Server 2008

448

TS: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance

433

TS: Microsoft SQL Server 2008, Database Development

432

TS: Microsoft SQL Server 2008, Implementation and Maintenance

542

TS: Microsoft Office SharePoint Server 2007 - Application Development

445

TS: Microsoft SQL Server 2005 Business Intelligence–Implementation and Maintenance

431

TTS: Microsoft® SQL Server™ 2005 - Implementation and Maintenance

300

Analyzing Requirements and Defining Microsoft .NET Solution Architectures

320

Developing XML Web Services and Server Components with Microsoft Visual C# .NET and the Microsoft .NET Framework

315

Developing and Implementing Web Applications with Microsoft® Visual C#™ .NET and Microsoft® Visual Studio® .NET

229

Designing and Implementing Databases with Microsoft® SQL Server™ 2000 Enterprise Edition

#1 Project Title: S & OP Automation (Mar 2014 – Till Date)

Client : Alcon Labs, TX

Database : SQL Server 2008 / SQL Server 2012

Front-End : SQL Server 2005/2008 BI Suite, BI Express, MS.Net 2010, ASP.Net

Team Size : 11

Role : Sr Database Architect, Team Lead

Project Description

S&OP business is responsible for providing accurate demand planning and forecasting levels throughout the Alcon organization. The S&OP Analytics Tool provides a base statistical forecast to be further

enhanced throughout Affiliate/Regional and Global reviews. The supply tool takes the consensus demand

and determines the manufacturing requirements through a process of inventory netting. The S&OP Analytics Tool allows the collection of this data in order to accurately provide planning and forecasting number to affiliates to meet strategic organizational initiatives.

Responsibilities

Designed Schema, Database Normalization up to 3NF and created required Tables.

Coordinates with the Onsite/Offshore team with respect to build and maintenance releases.

Created SSIS Packages to extract data from excel sheets to SQL Database.

Helping out the development team in SQL Coding and Maintained Data Dictionary.

Maintaining the Databases across production and Development QA servers.

Coding views, stored procedures, triggers, functions and creating SSIS packages, SQL Agent jobs etc.

Deployment of SSIS packages to UAT and productions environments with configuration variables.

Reviewing all SQL code which is going to UAT and PROD and make required recommendations.

Prepared the project management and technical documentation.

Unit Testing the SSIS packages with respect to its flow and performance issues.

Responsible for installation and configuration of SQL server 2012 database on Dell Servers.

Extensively worked on SQL Server Integration Services (SSIS) and SQL Server Reporting Services. Extensively worked on DMVs, Performance dash board, Mirroring, database snapshots and tracking Performance Counters.

Rebuilding / Monitoring the indexes at regular intervals for better performance.

Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions.

Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.

Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files.

Extensively worked on SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor(DTA).

#2 Project Title: BA (Business Acquisition) (Sep 2012 – Feb 2014)

Client : BCBS, TX

Database : SQL Server 2005 / SQL Server 2008 / SQL Server 2012

Front-End : SQL Server 2005/2008 BI Suite, BI Express

Team Size : 8

Role : Database Administrator, ETL Lead

Project Description

Business Acquisition (BA) is an enterprise-wide HCSC initiative for automating prospecting, new business proposals and sales, set-up and enrollment, and renewals. The system is comprised of a suite of applications to address the various market segments i.e., Small Group, Mid-Market and Major/National, which collectively are designed to make the process of acquiring new business and servicing the customers easier and more efficient.

Responsibilities

Migrated database from SQL 2005 to SQL 2008 and to SQL 2012. Convert DTS packages to SSIS and equivalent T-SQL

Reviewing all SQL code which is going to UAT and PROD and make required recommendations.

Restructured the existing deployment process to make it fast and efficient.

Prepared the project management and technical documentation.

Unit Testing the SSIS packages with respect to its flow and performance issues.

Responsible for installation and configuration of SQL server 2005 database on Dell Servers.

Migrated SQL server 2008 to SQL Server 2012 in Microsoft Windows Server 2012 Enterprise Edition.

Migrated SSIS packages from SQL Server 2008 R2 to SSIS 2012.

Extensively worked on SQL Server Integration Services (SSIS) and SQL Server Reporting Services. Extensively worked on DMVs, Performance dash board, Mirroring, database snapshots and tracking Performance Counters.

Rebuilding / Monitoring the indexes at regular intervals for better performance.

Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions.

Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.

Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files.

Extensively worked on SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor(DTA).

Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.

Implemented Data partitioning, Error Handling through TRY-CATCH-THROW statement, Common Table Expression (CTE).

Eenforce Database Security by Managing user privileges and efficient resource management by assigning profiles to users.

Followed Agile model for the development activities.

Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.

Complete documentation about the database. Recovering the databases from backup in disasters.

#3 Project Title: EV Intelligence (May 2012 – Aug 2012)

Client : T-System

Database : SQL Server 2005 / SQL Server 2008

Front-End : SQL Server 2005/2008 BI Suite, BI Express

Team Size : 8

Role : Database Architect, ETL Lead

Project Description

The T-System EV is the nation’s leading emergency department information system (EDIS). Increased workflow efficiency and documentation quality unburden the clinician, it includes Nursing, physician and clerk modules. The T System EV Tracking module makes patient management more efficient by monitoring patient location and status from anywhere in the ED.

Responsibilities

Responsible for installation and configuration of SQL server 2005 database on Dell Servers.

Involved in data modeling for the application and created ER diagram using ERWin.

Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions for this project. Upgrade from SQL 2005 to SQL 2008.

Implemented database standards and naming convention for the database objects.

Developed SSIS packages to extract, transform and load into the database from source system.

Query optimization and performance tuning.

Documented Tech Spec and HLD, LLD Documents.

Maintaining the Databases across production and Development QA servers.

Backup/Restore between different environments.

Provided relevant documentation such as install guides, implementation plans etc.

Coding stored procedures, triggers, functions and creating SSIS packages, SQL Agent jobs etc.

Creating Jobs to pull data from OLTP database to External Interfaces.

Creating SSRS Reports, Publishing Reports, and Deploying to report Server.

Helping out the development team in SQL Coding and Maintained Data Dictionary.

Maintaining the Databases across production and Development QA servers.

Coding views, stored procedures, triggers, functions and creating SSIS packages, SQL Agent jobs etc.

Deployment of SSIS packages to UAT and productions environments with configuration variables.

#4 Project Title: SCUSA - DataDev (Sep 2011 – Apr 2012)

Client : Santander Consumer USA

Database : SQL Server 2005 / SQL Server 2008

Front-End : SQL Server 2005/2008 BI Suite, Control M

Team Size : 23

Role : Database Analyst, Onsite Lead

Project Description

Historically, Drive Financial Services used to be one of the leading Auto Loan providers to below average credit score customers. Enterprise Data warehouse team is responsible to maintain the Database and related development for all the applications used by SCUSA. They are responsible for generating various reports and metrics based on the data. SCUSA IT has currently 50+ applications under Application Development area. SCUSA IT team uses RALLY for SCRUM based project development and tracking. As of now, most of the requirements are captured in the CALIBER but it would soon be discontinued and everything would be worked under RALLY.

Responsibilities

Migrated database from SQL 2005 to SQL 2008 and Convert DTS packages to SSIS and equivalent T-SQL

Managing team of 4 at offshore. Documented Tech Spec and HLD, LLD Documents.

Coordinates with the Onsite/Offshore team with respect to build and maintenance releases.

Created SSIS Packages to extract data from excel sheets to SQL Database.

Helping out the development team in SQL Coding and Maintained Data Dictionary.

Maintaining the Databases across production and Development QA servers.

Coding views, stored procedures, triggers, functions and creating SSIS packages, SQL Agent jobs etc.

Deployment of SSIS packages to UAT and productions environments with configuration variables.

Created, Scheduled and monitoring jobs using Control M tool.

Daily Status report with Offshore Project manager and Onsite manager on SCRUM meetings.

#5 Project Title: LED U-Verse (Mar 2008 – Aug 2011)

Client : AT&T, U.S

Database : SQL Server 2005 / SQL Server 2008

Front-End : SQL Server 2005/2008 BI Suite (SSIS)

Team Size : 6

Role : Database Administrator, Module Lead

Project Description

LED is the project for Data validation and versioning of various connections and services maintained by AT & T. A data transformation process requires built-in logic to respond dynamically to the data it accesses and processes. Input files will be processed with all the validation rules available and are stored into SQL 2008 database which is normalized. When request raised by the user, for a particular version, report will be generated in the same format of the input file. Comparing any two versions and highlighting the differences between the versions and generating reports into excel 2007 format is the key functionality of admin team.

Responsibilities

Designed Schema, Database Normalization up to 3NF and created required Tables.

Migrated database from SQL 2005 to SQL 2008.

Migrated application from .Net framework 3.0 to 4.0.

Designed system architecture and developed web application using C#.net, ASP.Net and AJAX.

Deployed Web application along with SharePoint portal using SharePoint designer.

Documented Tech Spec and HLD, LLD Documents.

Coordinates with the Onsite/Offshore team with respect to build and maintenance releases.

Created SSIS Packages to extract data from excel sheets to SQL Database.

Helping out the development team in SQL Coding and Maintained Data Dictionary.

Maintaining the Databases across production and Development QA servers.

Coding views, stored procedures, triggers, functions and creating SSIS packages, SQL Agent jobs etc.

Deployment of SSIS packages to UAT and productions environments with configuration variables.

#6 Project Title: Anvil - KATANA (Jan 2008 – Feb 2008)

Client : Microsoft, U.S

Database : SQL Server 2005

Front-End : SQL Server 2005 BI Suite (SSIS)

Team Size : 25

Role : Module Lead

Project Description

KATANA project is to improve the performance in the current system which deals with various Microsoft products. All the details of Microsoft products from various vendors will be collected from different external interfaces and integrated to a centralized database. From that database data will be flown to downstream interfaces in a different structure. The AS-IS process takes couple of days to transfer data from upstream to centralized database and from there to downstream. The main objective is to improve the process so as to reduce the time taken by the process.

Responsibilities

Provided solutions for the process improvement. Documented Tech Spec and HLD, LLD Documents.

Coordinates with the Onsite/Offshore team with respect to build and maintenance releases.

Upgrade from SQL 2000 to SQL 2005, Backup/Restore between different environments.

Maintaining the Databases across production and Development QA servers.

Maintaining/Designing Production and Pre-Production environments.

Refreshing data between interfaces for internal reporting tools.

Creating Views for external Interfaces.

#7 Project Title: Architecture Information System (AIS) (Aug 2007– Dec 2007)

Client : Boeing, U.S

Database : SQL Server 2005

Front-End : SQL Server 2005 BI Suite (SSIS, SSRS), .Net

Team Size : 25

Role : Database Administrator, Module Lead

Project Description

The Architecture Information System is a critical business application for IT to support Boeing its Airplane programs. AIS, is IT Architecture, workflow and tracking system and was being maintained by MIIRS as part of Boeing Information Services Group for managing the applications within. System provides enabling the visibility of De-Activation of applications, and Interfaces and external access, Facility for addition of Internal Delivery Channels, Copying Partner application requirements. Migration part includes integrating data of various Programs like 737-NG, 747-8, 777-F and so on.

Responsibilities

Generating Weekly Status Reports. Managing team of 11 members and to ensure delivery on-time.

Maintaining/Designing Production and Pre-Production environments.

Coordinates with the Onsite/Offshore team with respect to build and maintenance releases.

Helping out the development team in SQL Coding and Maintained Data Dictionary.

DB Design for Integrated system. Upgrade from SQL 2000 to SQL 2005.

Maintaining the Databases across production and Development QA servers.

Creating SSIS Packages to automate few data imports and also for data Migration.

Backup/Restore between different environments.

Provided relevant documentation such as install guides, implementation plans etc.

Coding stored procedures, triggers, functions and creating SSIS packages, SQL Agent jobs etc.

Creating Jobs to pull data from OLTP database to External Interfaces.

Creating SSRS Reports, Publishing Reports, and Deploying to report Server.

#8 Project Title: ACATS (Automatic Customer Account Transfer System) (Apr 2007– July 2007)

Client : ADP, U.S

Database : SQL Server 2005

Front-End : SQL Server 2005 BI Suite (SSIS, SSRS), .Net

Team Size : 20

Role : Database Administrator, Developer

Project Description

ADP is a leading full-service outsourcing provider to the global financial industry, capable of meeting the most demanding requirements for efficient, secure and scalable operational support.

ADP is in the process of designing a suit of workflow products to facilitate brokerage operations. One of the products is ACATS which helps customers transfer or move their assets from one brokerage firm (contra firm) to another. When a brokerage firm becomes a member of NSCC (National security clearing corporation), the firm automatically becomes ACAT (Automated customer account transfer system) eligible firm.

Responsibilities

DB Design in SQL Server 2005.

Created SSIS Packages to parse flat files with variable length coming from NSCC.

Handled Complex Stored Procedures and Queries.

Optimized stored procedures for better performance.

Created SQL Jobs and Scheduled as per the requirements.

Backup/Restore between different environments

Provided relevant documentation such as install guides, implementation plans etc.

As a part of support analyst, Analyze and fix the .NET code issues on time

Helping out the development team in writing Stored Procedures, explaining the Data Model and Maintained Data Dictionary.

#9 Project Title: QuICK (Quality Integrated Cubed Knowledge) (Dec 2006 – Mar 2007)

Client : NORTEL Networks, Canada

Database : SQL Server 2005

Front-End : SQL Server 2005 BI Suite (SSIS, SSRS, SSAS)

Team Size : 7

Role : Database Administrator, Module Lead

Project Description

Nortel’s Global Hardware and Supply Chain Quality organization has taken the decision to align all their reporting and data analysis tools under a single platform. A prototype, called “Quality Integrated Cubed Knowledge” (QuICK) has been built on SQL2005 database & MS Analysis

Services tools. The purpose of this Request for Proposal is to evolve the prototype into a production ready system supporting Nortel’s 3 out of 5 Product Lines, namely: Optical, Wireless CDMA and Wireless GSM & UMTS (G&U). A data transformation process requires built-in logic to respond dynamically to the data it accesses and processes. The data may need to be summarized, converted, and distributed based on data values.

Responsibilities

Database Analysis and Administration.

Created SSIS Packages to migrate and integrate Data from Oracle and other sources.

Creating SSRS Reports, Publishing Reports, and Deploying to report Server.

#10 Project Title: TRACS Niku Upgrade and Portfolio Management (Jul 2006 – Nov 2006)

Client : Warner Bros. Entertainment Inc, US

Database : SQL Server 2005

Front-End : Niku, Actuate 7.0, BO Reports, SSRS

Team Size : 8

Role : Database Administrator

Project Description

The project deals with upgrading Niku from version 6.15 FP08 WB2 to version 7.53 ensuring that all existing functionality is migrated into the new version. The upgrade includes configuring NIKU to work within WBEI’s enterprise environment. The implementation is intended to utilize Web sphere version 5.1 or 6 working within Warner Bros enterprise platforms, Windows server version 2003 enterprise operating under VMware and Microsoft SQL server working within WB’s VMware enterprise solution. This includes providing a working Development, QA and Production environment.

Responsibilities

Administered the Database for the whole System.

Migration of database from 2000 to 2005.

Data Analysis and Index rebuilding

Performance Tuning of Procedures and Views.

#11 Project Title: UNEX 2006 (Dec 2005 – Jun 2006)

Client : Research International Inc, UK

Database : SQL Server 2000

Front-End : C#.Net 2.0, ASP.Net, SQL Server BI Suite (SSIS, SSRS)

Team Size : 20

Role : Database Administrator, Module Leader

Project Description

UNEX 2006 is an International Postal Survey System used to allocate the test items to the panelist and delivering the test items from one location to another location. The aim is to help International Post Corporation and Local Postal Authorities to monitor and improve the service they provide their customers with regards to delivery of international mails. Generation is the part of the system which will generate ‘conceptual’ items, by using the targets to pre-define the detailed volumes needed, and a specific item profile for each item. The allocation process will assign items to certain panelists and ‘random’ variables to the items at the same time. Reports would be generated using SQL Server Reporting services to be displayed on the Web Application.

Responsibilities

Administered the Database for the whole System.

Interacted with Client for Requirements Collection and analyzed those requirements.

Designed Schema, Database Normalization up to 3NF and created required Tables.

Database Migration and Performance Tuning.

Creating SSRS Reports, Publishing Reports, and Deploying to report Server.

Helping out the development team in writing Stored Procedures, explaining the Data Model and Maintained Data Dictionary.

#12 Project Title: WEB Portal (Mar 04- Nov 2005)

Client : The Morpheus Group

Database : SQL Server 2000

Front-End : ASP.NET, C#.NET

Team Size : 5

Role : Database Administrator, Project Leader

Project Description

This Portal is used for Receiving Job Postings from Various Clients and Submitting Suitable Candidate Resumes to the Clients for Job Postings. The Admin will be Creates Login to Clients according to Client Request. The Client can Post a Job according to their Requirements. The Recruiters will search suitable Candidates by searching from various Jobsites and they will send that Candidates to Interview to their Clients. The Selected candidate will be Work as Consultant for the Clients. The Payments will be done by Recruiters to the Consultant. This software is also used for storing the Candidate details and Job Postings until the Job exists. If the Job doesn’t exist, it will be deleted automatically from our Database.

Responsibilities

Interacted with Client for Requirements Collection and analyzed those requirements.

Being a Project Leader, Assigning work to team members and delivery on time

Provided solution for the flow of recruiting process.

Documenting HLD, LLD for all the modules.

Designed Schema, Database Normalization up to 3NF and created required Tables.

Helping out the development team in writing Stored Procedures, explaining the Data Model and Maintained Data Dictionary.

Education Summary

Masters in Computer Applications from Andhra University, India with an aggregate of 72%.

Bachelor of Science from Osmania University, India.

Contact this candidate