Sravan V Email and Phone Number

Responsibilities: • Requirement gathering and analyzing data sources, Assisted in design and implementation of Data base. • Experienced in Data Extraction, Transforming and Loading (ETL) using various tools such as Data Transformation Service (DTS), SSIS, SSRS, and Bulk Insert. • Created numerous sub reports, drill down reports as part of the project according to business requirements using Reporting Services (SSRS 2012). • Designed Data Mapping documents, DDL scripts, and Data Dictionary and Meta data of the models and maintained them, Created Error and Performance reports on SSIS Packages. • Highly proficient in using T- SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Functions, User profiles, Relational Database Models and Data Integrity, SQL joins and Query Writing. • Used SSIS jobs for importing data from the flat files that brings the data to the application tables. • Wrote complex Stored Procedure, Queries, Triggers, Functions, Indexes, User-defined functions and Cursors for the application. • Used SSIS and T- SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts. • Created SSIS packages to extract data from OLTP and transformed to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures. • Created Alerts for successful or unsuccessful completion of Scheduled Jobs.

Responsibilities: • Requirement gathering and analyzing data sources, Assisted in design and implementation of Data base. • Worked and maintained SQL Stored Procedures, functions, and triggers for updating customer usage information in the database • Merge tables and created views to support reporting requests using SQL Server • Troubleshoot data and functionality issues related to reports, and SSIS packages • Used several transformations in Data Flow including Derived-Column, Script, Lookup, Data Conversion, and Conditional-Split to categorize data for other departments • Created complex SSIS packages using proper control and data flow elements with error handling • Designed Data flows, Workflows and jobs to load data from source to target • Performed Documentation for all kinds of reports and SSIS packages • Involved in the analysis and profiling of source data, creating prototypes and sample reports to help with requirements and design (SSRS) • Design daily table reports, matrix reports, sub-reports based on business needs using SSRS • Created Reports using SSRS. Identified the data source and defined them to build the data source views • Created reports in SSRS with properties like chart controls, filters, Interactive Sorting, SQL parameters etc. • Designed and created report templates, bar graphs, and pie charts based on financial data for analyzing performance counters using SSRS • Created reports using features like drill down, drill through, parameterized reports. Developed yearly, quarterly, monthly sales reports and scheduled the reports to run on daily and weekly basis in report manager and also email them to project manager to review in Excel sheet

• Requirement gathering and analyzing data sources, Assisted in design and implementation of Database. • Created SQL Server Reports and designing stylish report layout parameterized, performance, Ad-hoc reports. • Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables. • Worked with Stored Procedure, Queries, Triggers, Functions, Indexes, User-defined functions • Used SSIS and T- SQL stored procedures to transfer data from source databases to staging area and finally transfer into data warehouse. • Developed and deployed data transfers packages to the appropriate destinations using SSIS. • Created SQL server configurations for SSIS packages. • Expert in transforming complex business logic into Database design and maintaining it by using SQL tools like Stored Procedures, User Defined Functions, and Views. • Expert in Developing SSIS Packages to Extract, Transform and Load (ETL) data into the Data warehouse from Heterogeneous databases such as Oracle, DB2, Sybase and MS Access.

• Gathered the requirements from Business Users and passed on the requirements to the team. • Created custom SQL procedures to read data from flat files to dump to database using SQL * Loader. • Installation and configuration of SQL Server 2012. • Took over the designing of newer data warehouse and produced data models using Erwin. Considered different ways of approaching the designing of database and documented all the possible ways before building the data warehouse. • Discussed and documented the building of data warehouse at every step. • Exported the existing data from a legacy database to a newer database. • Optimized the existing stored procedures and automated them for various tasks. • Created new Database objects like Tables, Views, indexes and functions. • Developed a new set of complex stored procedures for newer business requirements. • Imported data from various sources like Excel, Access. • Experience in SQL joins, sub queries, tracing, indexing strategies and query/index tuning and performance tuning for better running of queries. • Used SQL Server Profiler to trace the slow running queries and the server activity. • Developed ETL packages using multiple data sources (SQL Server, Flat Files, Excel source files, XML files) and then loaded the data into destination tables by performing different kinds of transformations using SSIS transformations. • Experience in SQL joins, sub queries, tracing, indexing strategies and query/index tuning and performance tuning for better running of queries.

• Design & Develop ETL packages at different Stages (Acquire, Stage, ODS). • Contribution in the Design & Development of Audit Balance control frame for ETL. • Design & Develop Error handling & Email notification components. • Involved in Enhancements and Fixing Issues. • Identifying detailed analysis of data sources. • Preparing data mapping document from source to target. • Involved in preparing business transformation rules that should be applied to source data. • Designed Data Migration Logic between source and Target Systems. • Identifying data issues with data in the source systems. • Loading data from the various data sources like Flat files, CSV's, SQL Server and My SQL etc. • Created SSIS Packages by using different data Transformations like Derived Column, Lookup, Conditional Split, data conversion and Execute SQL Task to load data into Database. • Performance tuning of SSIS packages. • Implementing new functionality in the existing ETL packages. • Monitoring the jobs and providing production support. • Communicate effectively to management, business and technical roles to meet the deliverables and schedule • Created Functional and Technical Specification document. Environment: Windows 2008 R2, SQL Server 2008 R2, SSIS, SSAS, SSRS.

AGL Resources, an Atlanta-based energy services holding company, serves 2.3 million customers in six states (Florida, Georgia, Maryland, New Jersey, Tennessee and Virginia) through its utility subsidiaries - Atlanta Gas Light, Elizabethtown Gas in New Jersey, Virginia Natural Gas, Florida City Gas, Chattanooga Gas, and Elkton Gas in Maryland.The project scope was to implement Enterprise Learning Management 9.0 and provide support to the existing PeopleSoft HRMS 8.9Responsibility:My responsibilities include: • Interacting with the client for gathering the business user requirement • Understanding the Business requirement in the Functional Specification and Preparing the Technical Design Document.• Involved in developing test plans and test scenarios to ensure proper business compliance.• Involved in unit testing, peer testing and user acceptance testing.