SRAVANTHI K

Email: acqx54@r.postjobfree.com

Phone: 757-***-****

OBJECTIVE

Challenging position in an Organization, where continuous learning and diverse expertise is needed so that I can enhance my skills and strive for the growth and increased value of the Organization.

PROFICIENCY

7+ years of strong experience in creating database, tables, indexes, stored procedures, views, triggers and T-SQL using Microsoft SQL Server 2012/2008.

Experience in extracting, transforming, and loading (ETL) data from Oracle, excel, flat file and from more sources to Microsoft SQL Server by using SSIS.

Extensive working experience in normalization and de-normalization techniques for OLTP and OLAP systems in creating database objects using DDL, DML and DCL commands.

Experience in enhancing and deploying the SSRS Reports from development server to production server.

Excellent T-SQL development skills to write complex queries involving multiple tables, great ability to develop and maintain stored procedures, triggers, user defined functions.

Extensively used Report Wizard, Report Builder and Report Manager for developing reports and deploying reports in SSRS.

Expertise in report writing according to the business requirement in SSRS.

Expert in creating SQL Server Reports using SSRS 2008 in designing stylish report layout parameterized, performance, Chart Reports, ad-hoc reports.

Experience in managing and automating control flow, data flow, events for SSIS packages.

Transferred data from various data sources/business systems including MS Excel, MS Access, Flat Files etc. to SQL Server using SSIS various features like multitasking, conditional split, union, union all, merge, lookup, fuzzy lookup, data conversion etc.

Knowledge on all phases of Software Development Life Cycle (SDLC) of Data warehousing, including requirement gathering from business users, analysis, design, creation of mapping documents, specification writing, development, testing, and implementation.

Experience in different type of reports including Tabular forms, Matrix (Cross /tab Report) form, Drill down, Drill through, cascading, List items, Charts and Sub Reports.

Good knowledge of data marts, data warehousing, and operational data store (ODS), data modeling like dimensional data modeling, star schema modeling, and snow-flake modeling.

Scheduled and monitored all maintenance activities of SQL Server to meet business requirement activities including database consistency check.

Possess strong troubleshooting, organizational, communicational, and self-managing skills.

Ability to work in groups as well as independently with minimal supervision.

TECHNICAL SKILLS

Operating Systems:

Windows 8, Windows 7, Windows XP

Databases:

MS SQL Server 2012/2008/2005, Oracle, MS Office Access.

ETL TOOLS:

SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Data transformation services (DTS)

Database Tools:

SQL Server Management Studio, Business Intelligence Development Studio.

Data Modeling Tools:

Visio 2003, Office Visio 2007.

Programming Languages:

SQL, T-SQL, C/C++, Java, HTML scripts, java script

Applications:

Microsoft Office Suite, Adobe Photoshop, Acrobat Reader/Writer.

PROFESSIONAL EXPERIENCE

DirecTV, New York (Satellite communication domain)

Role: BI Developer Feb’2014 - Till date

Responsibilities:

Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing different kinds of transformations using SSIS packages.

Worked as a SQL Developer in creating complex stored procedures, triggers, tables, views and SQL joins and statements for applications.

Working experience in BI Solutions (ETL & Reporting) using SSIS, SSRS and T-SQL Programming using DDL, DML, and DCL commands for various business applications.

Deployed and generated reports on to the server using the Reporting Services Report Manager.

Created indexes, constraints on database objects.

Used event handling techniques in SSIS to handle the events at package and task level using on error, on warning, and configured it using script task and send email task.

Scheduled SQL agent job on daily basis to run the SSIS packages and send email in case of any failure.

Worked on internal project to create matrix reports with drill through, drill down and multi-parameters using SSRS.

Created SSIS packages to import data from Excel, flat files and other OLEDB sources.

Created SSIS packages to load the data into SQL table using union all transformation, merge, data conversion, derived column, join, merge join and slowly changing dimension.

Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2008.

Environment:

MS SQL Server 2008/2012, T-SQL, SSIS 2008, SSRS 2008/2005, Windows XP, MS Excel.

ViSalus, Michigan (retail & healthcare based firm)

Role: SQL BI Developer Nov’2011-Dec’2013

Responsibilities:

Created various database objects (tables, indexes, views, stored procedures and triggers) and implemented referential integrity constraints for enforcing data integrity and business rules.

Utilized SSIS (SQL Server Integration Services) to produce a Data Mart for reporting.

Extract, Transform and Load (ETL) source data into respective target tables to build the required data marts.

Created Cross-Tab, Drill-down, Drill-through and Sub-Report using RDL. Promoted RDLs to Reporting Service Server. Wrote the queries for the drill down reports.

Extensively used SSIS Import/Export Wizard, for performing the ETL operations.

Worked on the Reports module of the project as a developer on MS SQL Server 2008 (using SSRS, T-SQL, scripts, stored procedures and views).

Supported team in resolving SQL Reporting services and T-SQL related issues and Proficiency in creating different types of reports.

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

Created and executed SQL Server Integration Service packages to populate data from various data sources, created packages for different data loading operations for many applications.

Created and when required, modified already existing stored procedures, triggers, views, indexes.

Extensively used SSIS Import/Export Wizard, for performing the ETL operations.

Created SSIS packages to pull data from SQL Server and exported to Excel Spreadsheets and vice versa.

Developed ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).

Designed and implemented Parameterized and cascading parameterized reports using SSRS.

Environment:

MS SQL Server 2008, Windows XP, SSIS, SSRS, T-SQL, OLAP, OLTP, Data Mart, ETL, MS Office 2003.

Assurant Specialty Property, Ohio (Insurance domain)

Role: SSIS, SSRS Developer Apr’2010-Aug’2011

Responsibilities:

Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.

Highly Proficient in developing SSIS Packages to Extract, Transform and Load (ETL)/DTS data into the Data warehouse from Heterogeneous data sources such as Oracle, DB2, Sybase, Excel and MS Access CSV, Oracle, flat file.

Involved in creating Stored Procedures, views, tables, constrains.

Expert in writing parameterized queries for generating tabular reports, formatting report layout, sub-reports using global variables, subtotals, expressions, functions, sorting the data, defining data sources for the reports using SSRS.

Developed the SQL Server Integration Services (SSIS) packages to transform data from SQL 2005 to MS SQL 2008 as well as Created interface stored procedures used in SSIS to load/transform data to the database.

Generated reports from the cubes by connecting to Analysis server from SSRS.

Designed and created Report templates, bar graphs and pie charts based on the financial data.

Worked on Sub Reports, chart report, Data Drill-Down, and Data drill through etc.

Environment:

MS SQL Server 2008, T-SQL, SSIS 2008, SSRS 2008/2005, Windows XP, EXCEL Reports, MS Access, Visual Studio 2005

United Health Group, India Sept’2007-Feb’2010 (Healthcare domain)

Job Role: BI Developer

Responsibilities:

Created SSIS packages to extract data from OLTP to OLAP systems and scheduled jobs to call the packages. Applied various data transformations like union all, data conversion, character map, merge etc.

Worked on the Reports module of the project as a developer on MS SQL Server 2005 (using SSRS, T-SQL, scripts, stored procedures and views).

Extensively used joins and sub queries to simplify complex queries involving multiple tables.

Used DDL and DML for writing triggers, stored procedures, and data manipulation.

Write T-SQL statements for retrieval of data and involved in performance tuning of TSQL queries.

Loading data from various sources like OLEDB, flat files to SQL Server database Using SSIS Packages and created data mappings to load the data from source to destination.

Creating Reports as per user requirements using SSRS.

Involved in designing ETL as a part of Data warehousing and loaded data in to Fact tables using SSIS.

Write T-SQL scripts for database backup jobs and daily/weekly jobs.

Created databases, tables, indexes, views and coded stored procedures, functions, triggers.

Conducted data migration from Oracle database and flat files into SQL Server 2008 using SSIS Packages.

Created complex stored procedures and functions to support the front-end application.

Optimized SQL queries for improved performance and availability.

Environment:

MS SQL Server 2008, SSIS 2008, SSRS 2008/2005, Windows XP, SQL Server Management Studio (SSMS), T-SQL, SQL Server Integration Services (SSIS), Microsoft Excel.

EDUCATION

Bachelors in Technology

REFERENCES WOULD BE PROVIDED UPON REQUEST

Contact this candidate