Sql Server Data

SWAPNA

Email: ***************@*****.***

Ph#: 561-***-****

Professional Summary:

A Microsoft certified Professional with 9+ years experience in Data modeling, database design, Programming, Development and Implementation of Client-Server Applications & Database systems using MS SQL Server 2012/2008/2005.

A Oracle certified Professional with 5+ years experience in oracle PLSQL development and UNIX technologies.

Extensive experience in Using Microsoft BI Studio products for implementation of ETL methodology in data extraction, transformation and loading

Expert in data Warehouse development starting from inception to implementation and ongoing support, strong understanding of BI application design and development principles

Using Normalization and De-Normalization techniques

Generating complex Transact SQL (T-SQL) queries, Sub queries, Co-related sub queries, Dynamic SQL queries etc. Programming in SQL Server - Using the stored procedures, Triggers, User-defined functions and Views, Common table expressions (CTEs)

Involved in Writing heavy stored procedures, Audit triggers views, creating SQL scripts for data loads and Upgrades for data migrations and data validations

Proficient in Performance Tuning/Query optimization using indexes

Assisted with automation of manual processes by writing VBA code and using macros and formulas to speed processes and maximize accuracy.

Tuning the performance of stored procedures and large T-SQL Queries using Clustered indexes, efficient coding standards

Involved in Backing up databases and refreshing Data across environments

Huge Data transfers from & to SQL Server Databases using utilities/ tools like DTS, SSIS, BCP, Bulk Insert

Involved in addressing Batch process issues, Job scheduling, Code Debugging, Maintenance and Bug Fixes.

Experienced in using Block, Unblock and Row Transformations for Performance Tuning in SSIS packages.

Experienced in whole cycle of DTS/SQL Server Integration services Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing Data transfers and ETL purposes across different servers.

Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.

Excellent knowledge of using variables and expressions in packages of SSIS.

Worked with Flat file, Excel file, and SQL server OLEDB destinations for loading data.

Involved in handling Enterprise wide reporting needs using SQL Reporting Services, Crystal Reports.

Creating large enterprise reports, sub reports using charts, report parameters, dropdowns and images using SSRS 2008/2000/2005.

Expert in designing reports using SQL Server Reporting Services (SSRS2000/2005), operating and troubleshooting with data sources.

Involved in Installation, Configuration, Development, Deployment and Troubleshooting Reporting services using SSRS across various environments.

Expert in developing and deploying cascading parameterized, Drilldown, Adhoc reports with linking sub reports in various file formats with respect to client requirement.

Experience in writing Queries using SQL Server Analysis Services (SSAS).

Created and Configured Data Source &Data Source Views, Dimensions, Cubes, Measures, Partitions.

Vital Knowledge in OLAP Storage modes likes Rolap/ Molap/ Holap.

Hands on experience in Creating Star Schema and Snow Flake Schemas.

A well-organized, goal-oriented, highly motivated and effective team player with excellent analytical, troubleshooting, and problem solving Skills.

Excellent Verbal & Written Communication skills and strong in Documentation.

Flexible, enthusiastic and project oriented with excellent communication and leadership skills to develop creative solution for challenging client needs..

Ability to write complex SQL queries to analyse the production environment and also to write strong PLSQL procedures, functions, triggers, packages.

Strong experience in performance tuning techniques in coding PL/SQL blocks.

Ability to debug the functions, procedures and packages.

Strong experience in Advanced PLSQL concepts.

Experience in SQL and PL/SQL tuning and query optimization tools like SQL Trace, Explain Plan, and DBMS_PROFILER.

Strong knowledge in Oracle utilities like SQL*Loader, Export/Import and data pump utilities like EXPDP/IMPDP.

Extensively used package like DBMS_STATS, UTL_FILE, DBMS_SCHEDULER and UTL_SMTP.

Strong knowledge with PL/SQL Wrapper to protect the PL/SQL procedures or packages.

Experience in SQL and PL/SQL tuning and query optimization tools like SQL Trace, Explain Plan, and DBMS_PROFILER.

Strong knowledge in Oracle utilities like SQL*Loader, Export/Import and data pump utilities like EXPDP/IMPDP.

Extensively used package like DBMS_STATS, UTL_FILE, DBMS_SCHEDULER and UTL_SMTP.

Strong knowledge with PL/SQL Wrapper to protect the PL/SQL procedures or packages.

Developed various scripts to extract the data from the source systems and scheduled all the SQL and PLSQL scripts using Unix CRONTAB scheduler.

TECHNICAL SKILLS

RDBMS:MSSQL Server 2012, 2008, 2005, 2000 &7.0 MS ACCESS 2000, 2003, 2007,ORACLE

PLSQL 10g,11i.

Database Utilities: Enterprise Manager, SQL Server Management Studio, BI Development, Studio, Visual Studio, Configuration Manager, SQL Server Profiler SQL Query Analyzer, SQL Refractor, SQL Server Agent, Toad.

ETL Tools: Data Transformation Services (DTS), SSIS, ODI, Import/ export wizard, Bulk Insert, BCP

BI Tools: SSRS, SSAS,SSIS, ODI, OBIEE.

Office Tools: MS Word, MS Excel, MS PowerPoint, MS Outlook

Management Tools: SharePoint, Team Foundation Suite (TFS), Microsoft Office Communicator.

Languages: T-SQL, PL/SQL, MS SQL, MDX, C/C++, Java, VB, VBA, HTML, XML.

Web Technologies: HTML, DHTML, XML.

Architecture: Relational DBMS, Client-Server Architecture, OLAP, ROLAP, MOLAP and OLTP

O/S:Windows 2008/2003/2000/NT Servers, XP, Vista, UNIX.

PROFESSIONAL EXPERIENCE

Client: Atlantic Telecom LLC, Boca Raton,FL. Apr 2015 – Till Date

Description:

Atlantic Telecom deals with selling calling cards globally. The application allows users to use cards to make calls all over the world. It supports VOIP calls over the internet. Users can register and make one time payments or use the option of a monthly recharge. The application supports a set of schemes to attract different age groups with price flexibilities to capture a better market. It supports several features for service subscription and notification.

Responsibilities:

Creating Database objects – Tables, Views, and Functions and developing procedures for implementing application functionality at the database side for performance improvement.

Performing query plans and making sure each and every query is using appropriate useful Indexes.

Understanding the report design Requirements and Constraints.

Creating and Modifying T-SQL Stored Procedures/Triggers for validating the integrity.

Used SSIS to create ETL Packages to validate, extract, transform and load data to data warehouse databases, data mart databases

Deployed the created SSIS packages in Development and Testing environments.

Generated packages using different Transformations like Lookups, Derived Column, Merge Join, Fuzzy Lookup, For Loop, For Each Loop, Conditional Split, Union all, Script component and etc.

Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.

Developing and maintaining ETL jobs for the Data Warehouse using SQL Server Agent.

Developed tabular, matrix, chart, Drill-down, parameterized and cascading reports (SSRS).

Excellent report creation skills using Microsoft Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.

Developed Custom/Conditional formatting reports and deployed them on server using SQL Server Reporting Services (SSRS).

Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).

Created Drill-down, Parameterized and Sub-Reports using RDL.

Promoted RDLs to Reporting Service Server (SSRS).

Created Adhoc reports and data exploration using Power View.

Implemented business Intelligence dashboards using MOSS 2007 Report Center and Excel services producing different summary results based on user view and role membership.

Created scorecards with executive summary dashboards using MS Office Performance point server 2007 Dashboard designer that display performance monitoring measures.

Scheduled Backups and performed Restore operations for system test data.

Environment:

MS SQL Server Management Studio 2012, Query Analyzer, SQL Profiler,

Index Tuning Wizard, Microsoft Visual source Safe, MS SQL Server Integration Services (SSIS),

MS SQL Server Reporting Services (SSRS), MS Office 2007.

Company: Tata Consultancy Services, INDIA

Client: Project: Tata Tele Services LTD Mar 2011 to Mar 2015.

Description:

TTSL is a Telecom based BI team. Reporting from various source systems like Billing, CRM, Metasolv, Crystall Ball, Empower. Data from various source systems is mapped and reported to the user.

Responsibilities:

Extensively involved in the full lifecycle of ETL software development - analysis, design, build documentation and testing for the project using SQL Server Integration services.

Created packages using SSIS for data extraction from Flat files, OLEDB to SQL server using ETL tool.

Extensively designed the packages and data mapping using Control flow task, Sequence container task, Dataflow Task, Execute SQL Task, Data conversion task, Derived Column task and Script Task in SSIS Designer.

Moved the static data from various text files to SQL Server 2012 DB using Import Export Wizard.

Developed SSIS packages not only for initial data loads but also for incremental/delta loads.

Created log tables to capture the SSIS events and used it to perform debugging of the packages.

Generated the data validation report in SQL server reporting services (SSRS).

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

Created Tabular reports, Matrix reports, Parameterized reports, Sub reports, Ad-hoc reports, Cascading reports, Drill down reports.

Created user groups in Report Manager for limited access to the users in SSRS.

Involved in unit testing of SSIS packages, query verifications in SSRS.

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

Maintaining the documents and packages in Team Foundation Server as a version control.

Environment:

MS SQL Server 2012, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Microsoft Dynamics, SharePoint, Team Foundation Server,MS Excel, MS Visio, Windows 7, VBScript

Company: Tata Consultancy Services, INDIA

Client: Project: American International Groups Mar 2007 to Mar 2011.

Description:

American International Workers Compensation System (“AIWCS”) is a policy issuing system. It supports quotes, issuance, endorsements, renewal quotes, renewal issuance and audit of policies for both Voluntary and Assigned Risk market types in Workers Compensation and Ocean Marine Lines of Business (“LOB”).

Responsibilities:

Coding at all the levels of the application.

To generate the report for policies with / without Anniversary Rate Date endorsement using OBIEE.

Handling additional responsibilities like source code control, team management etc.

Created stored procedures and functions.

Written complex SQL queries to analyze the data from various sources.

Written stored procedures, functions, triggers, packages to transform the data from various data sources.

Used advanced concepts in PLSQL and SQL like cursors, dynamic SQL, composite data types, hierarchical retrieval of data.

Involved in partitioning of tables to improve performance.

Involved in performance tuning techniques for fast extraction and transformations and loading of data in to our oracle database.

Unit Testing.

Developed Physical Layer, Business Model & Mapping and Presentation Layer using OBIEE Analytics Administration Tool.

Creation of Dimensional Hierarchies to analyze the business trends in various ways.

Created logical joins between fact and dimension tables in business model layer.

Organizing the presentation layer in a format that is easy for end user to use as basis for reporting.

Designed and Configured Intelligent Dashboards in Analytics for different groups of users.

Created the Requests and view the results in different views like Table, Compound Layout, Chart and Pivot Table.

Developed different brand level Reports, Filters, and Prompts using Siebel Analytics Web.

Created various reports to fulfill the marketing needs and customized the views using OBIEE Answers.

Developed complex programs in T-SQL, writing Stored Procedures, Triggers, Views and Queries with best execution plan

Environment:

Oracle Business Intelligence 10.1.3x Windows XP, oracle 10g, SQL, PL/SQL, TOAD, MS SQL SERVER 2008.

TRAINING & CERTIFICATIONS

Microsoft SQL Server certification.

Oracle SQL,PL/SQL developer certification.

Education: BTECH- ELECTRONICS AND COMMUNICATION – JNTU(2003-2007).

Contact this candidate