Sql Server Data

SNEETHA THIMMANAGARI (SQL DEVELOPER)

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

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

SUMMARY

Over seven plus years of MS SQL Server Development experience in Banking, Finance, Telecommunications, and Health Insurance domains with expertise in MS SQL Server 2000 and MS SQL Server 2005/2008 suite of products like SSIS, SSAS, DTS and SSRS

Involved in Source Data Analysis, Design and creation of Data Mappings for Extraction of bulk data from heterogeneous sources like Flat Files, Excel and other OLEDB, ODBC data sources.

Designed and Developed SSIS Packages using various Control Flow and Data Flow items to Transform and Load the Data using SQL Server Integration Services (SSIS).

Experience in designing and developing Data Warehouses, Data Marts using multi-dimensional data models such as Star Schemas and Snowflake Schema

Developing Cubes using Multi-Dimensional Expressions (MDX)

Experience in using data mining tools to validate the reporting solutions for accuracy and completeness.

Involved in all phases of software development life cycle: design, implementation and testing.

In-depth knowledge of working and implementation of SSRS Reports, converting Crystal reports to SSRS Reports and in upgrading crystal reports 8.5/9.0/10 to XI.

Expert in database creation, maintenance, monitoring, backups and recoveries.

Specialized in analyzing, coding, implementing and creating complex query reports using Oracle 8i/ 9i/ 10g, SQL Server 2000/2005/2008/2012, Sybase and DB2.

Excellent interpersonal communication, problem solving, documentation and business analytical skills.

Extracted, transformed and loaded data from various heterogeneous data sources and destinations like Access, Excel, CSV, Oracle, flat files using connectors, tasks and transformations provided by SSIS.

Knowledge on tableau which is used to connect to almost any database, drag and drop to create visualizations, and share with a click.

Excellent experience in developing stylish Drill Down, Cascading, Parameterized, Drill through, Sub reports and Charts using Global variables, Expressions and Functions for the business users.

Excellent communication skills, presentation, interpersonal skills, strong troubleshooting and organizational skill and also has a work experience to work offshore.

AREAS OF EXPERTISE

Operating Systems - Windows NT/98/2000/XP/2003 Server, Unix, Linux, Sun Solaris.

Languages - T-SQL, CSS, HTML, ASP.NET, C#, .NET Framework, C.

Data Warehouse Tools - SSIS, SSRS, SSMS, Business Intelligence Development Studio, DTS,

Databases - MS Access, MS SQL Server 2000/2005/2008/2012, Oracle 8i/9i/10g.,Tools/Utility, Enterprise Manager, SQL Server Management Studio (SSMS), Database Tuning Advisor, DTS, Analysis Manager, BCP, SQL Profiler, Teradata, DB2.

Reporting Tools - Excel, SQL Server Reporting Services 2012, 2008, 2005.

Other Tools: MS Office, Visio, MS Excel, MS-Project 2000.

EXPERIENCE

GOOD CENTS, Alpharetta,GA October 2015-Now

Responsibilities:

Installing and configuring SQL server 2005/2008/R2/2012.

Created tables, Cluster/Non-Cluster Indexes and Stored Procedures.

Wrote efficient stored procedures for the optimal performance of the system.

Designed and developed SSIS Packages to import the data from multiple flat files located on the FTP site to the SQL Server database using various SSIS transformations like script task, For each loop container, Execute SQL task and Execute Process task.

I have decrypted the files present on the FTP site and loaded the data into the database.

Involved in migrating the data from legacy system VCR6 to new system OR4.

Extensively worked on migrating all the jobs, packages and stored procedures which has references to legacy system to new system.

Rewritten the stored procedures for the ETL processes where monthly billing data is sent to the client.

Created a local environment for the ETL processes to validate and test the data.

Involved in testing the ETL processes by using the front end Oracle application (Oracle Field Services) to schedule and route the workorders.

Working experience with SVN where the latest files are checked in and checked out.

Added few columns and tables to a Enterprise datawarehouse that were present in a datamart but were missing in the EDW.

Demonstrated migrated ETL processes and reports to the client explaining the new ETL processes and value.

Worked with intenal and external stakeholders to understand the business requirements of each report.

Worked on migrating the existing SSRS reports that were being generated from the datamarts so that they are now being generated from a Enterprise datawarehouse.

Created dynamic SQL queries to retrieve data for tabular reports, parameterized reports and sub reports based on user input.

Created mock-up drafts of the reports, presenting them first to management then to the clients for approval.

Migrated the stored procedures that are used in the reports, changed the datasources and datasets to point to the new system.

Deployed the migrated reports on to the sharepoint location.

I prioritize and manage own workload, with proactive communication on work items and work collaboratively as a team.

Worked as a lead developer onsite, coordinating and distributing the work load with the team members in India.

Environment: SQL Server 2012/2008/2005 Enterprise Edition, SQL Server Data Tools, Power BI, SQL Server Business Intelligence Development Studio (SSIS, SSRS, SSAS),SVN, Power Pivot, Powerview, Sharepoint 2010,TSQL,C#, .Net framework, Azure.

UHY Advisors, Atlanta, Georgia March 2015 – September 2015

SQL Server BI Developer (SSIS, SSAS, SSRS)

Clients- Safe Guard, The Home Depot

Responsibilities:

Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems.

Installing, Configuring and Administering SQL server 2005/2008/R2/2012.

Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2012 and Flat files.

Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).

Used various Transformations in SSIS Dataflow, Control Flow using For loop, For each loop, Sequence Containers and Fuzzy Lookups etc.

Moving all existing DTS packages to SSIS by adding extra SSIS task.

Proven track record in troubleshooting of Data Stage jobs and addressing production issues like performance tuning and enhancement.

Involved in ETL architecture enhancements to increase the performance using query optimizer.

Have extensively worked in developing ETL program for supporting Data Extraction, transformations and loading using Informatica Power Center.

Implemented Event Handlers and Error Handling in SSIS packages.

Created SSIS packages for Data Conversion using data conversion transformation.

Configured the loading of data into slowly changing dimensions using Slowly Changing Dimension wizard.

Advanced extensible reporting skills using SQL Server 2010 Reporting Services (SSRS).

Involved in developing reports and moving reports from development environment to test environment.

Involved in deploying the reports on the development server.

Designed and created Report templates, bar graphs and pie charts based on the financial data and tabular reports and exported them to a spreadsheet (Excel files).

Developed various types of complex reports like Drill Down, Drill through, Cross tab reports.

Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2008.

Involved in designing Parameterized Reports for generating Ad-Hoc reports and stored procedures as per the client requirements.

Coordinated with front-end for implementing logic in stored procedures and functions.

Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non-clustered indexes.

Involved in upgrading from SQL Server 2008 R2 to SQL Server 2012.

Environment - SQL Server 2012/2008/2005 Enterprise Edition, SQL Server Data Tools, SQL Server Business Intelligence Development Studio (SSIS, SSRS),TSQL,C#, .Net framework, XML, MS Visual Source Safe and Windows Server 2008, Teradata, Informatica, Data stage,DB2.

Hanger Inc., Austin, TX May 2014 - Feb 2015

SQL Server BI Developer

Responsibilities:

Wrote various stored procedures for the purpose of application development.

Performed backup/restore, database objects such as tables, procedures, triggers, constraints, indexes and views.

Installing, Configuring and Administering SQL server 2005/2008/R2.

Responsible for creating the reports based on the requirements using SSRS tool.

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

Thorough Software Development life cycle (SDLC) experience including development, designing, analysis, coding, testing and implementation.(i.e. Agile/Scrum, Waterfall)

Created SSIS process design and architected the flow of data from various sources to target.

Developed, monitored and deployed SSIS packages.

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

Implemented SSIS data transformation scripts, created maintenance procedures and provided data integrity strategies.

Used multiple join statements to retrieve data from multiple tables.

Created stored procedures, views, triggers, user defined functions to incorporate the flow of business and called various stored procedures from DTS to make the flow of DTS effective.

Continuously interacted with users to gather business requirements.

Wrote parameterized queries for generating reports in SSRS.

Converted Logical Database Diagram into Physical Schema using the balanced Normalization in 2nd and 3rd Normal Form.

Defined Check constraints, Business Rules, Indexes, and Views.

Successfully migrated a huge amount of data from heterogeneous source using BCP and Dynamic DTS Packages.

Improved Data qualities in order to ensure the quality and accuracy of the master data by using business rules which will automatically update data, send email, start workflow validation, Audit records which prevent from making changes, lock down models and also by sending notifications.

Done research and suggested new methods to further enhance performance, compatibility.

Developed third party Advanced reporting components for the storage, retrieval and querying of a database across multiple servers. Also served as the administrator of SQL client/server for applications.

Environment - SQL Server 2000/2005/2008, T-SQL, Data Transformation Services (DTS), Advanced Reporting Services (SSRS), Integration Services (SSIS), BCP, SQL Profiler.

Home Site Insurance, Boston, MA July 2012 - May 2014

MS SQL Server BI Developer (SSRS/SSAS/SSIS)

Responsibilities:

Developed logical and physical data models, designed data access strategies and wrote SQL code to access and manipulate data stored in relational databases.

Implemented MS Analysis Services setup, tuning, cube partitioning, dimension design including hierarchical and slowly changing dimensions.

Created calculated measures and dimension members using multi-dimensional expressions (MDX), mathematical formulas, and user-defined functions.

Created different type of reports including Cross-tab, Conditional, Drill-down, OLAP and Sub reports using SQL Server Reporting Services (SSRS).

Gathered user requirements, drafted specifications, designed, documented and wrote test script for testing of all the report.

Involved in writing SQL Queries, Views and Stored Procedures on SQL Server 2005/2008.

Designed databases for applications with requirements for large numbers of transactions, heavy access and high availability.

Optimized the stored procedures to improve the performance of the query.

Involved in peer review and validating the dashboard solutions for accuracy and completeness using data mining and data analysis tools.

Used various SSIS tasks such as Conditional Split, Derived Column etc. which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.

Extracted and reviewed data from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) using SQL Server Integration Services (SSIS) from OLTP to OLAP.

Environment - T-SQL, MS SQL Server 2005/2008, MS SQL Server Analysis Services 2008, MS SQL Server Integration Services 2008,MS SQL Server Reporting Services 2008.

Freight Quote, KS Sep 2010 - July 2012

SQL Server BI Developer

Responsibilities:

Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers.

Wrote efficient stored procedures for the optimal performance of the system.

Monitored performance and optimized SQL queries for maximum efficiency.

Responsible for Creating and Modifying T-SQL stored procedures/ triggers for validating the integrity of the data.

Created indexed views and appropriate indexes to reduce the running time for complex queries.

To keep track of data manipulations using Audit functionalities.

Generated custom and parameterized reports using SSRS.

Created reports that call sub reports in SSRS.

Configuration and Deployment of all the Reports (RDL, RDS) across various SDLC environments.

Actively involved in developing Complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs.

Responsible for creating datasets using T-SQL and stored procedures.

Created several packages in SSIS.

Scheduled the packages to keep extracting the data from OLTP at specific time intervals.

Used various transformation tasks to create ETL packages for data conversion.

Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.

Responsible for rebuilding the indexes and tables as part of performance tuning.

Used SQL Server Agent for scheduling jobs and alerts.

Performed Query optimization & Performance Tuning.

Optimized queries using SQL Profiler and Database engine tuning advisor

Environment - SQL Server 2005 Enterprise Edition, SQL Server Agent, SSIS 2005, SSRS 2005, C#,T-SQL, Windows 2000/2003 Server, XML, MS Excel, MS Access.

Syntel, Pune, India Aug 2008 - Sep 2010

SQL Server BI Developer

Responsibilities:

Created and Modified DTS/SSIS packages, complex views, stored procedures and functions

Integrate the SSIS package, converting all existing DTS packages of MS SQL 2000 to 2005 by adding extra SSIS task.

Involved in development, enhancement, testing and performance tuning of the application.

Analyzed the bottlenecks in the stored procedures, SQL queries and tuned them for improving the performance of the application and data migration, creating new stored procedures and SQL scripts as part of the enhancements.

Creating clustered and non-clustered indexes for improved performance.

Perform optimization of SQL queries in SQL Server.

Worked on Data Transformation Services (DTS) to download data from ftp, transform data from text files to SQL Server database tables and update certain table in database using SQL Server DTS packages.

Develop backup & restore scripts for SQL Server as needed.

Data Migration from SQL Server 2000 to 2005.

Create SQL Server Integration Services (SSIS) Packages.

Working in SQL Server Reporting Services (SSRS) for reports generation.

Participated in meetings with Business Partners & Business Analyst for development of the application.

Environment - SQL Server 2005/2000, Visual SourceSafe, .Net Framework, T-SQL, Stored Procedures, VB script, .Net, SSIS and SSRS.

Educational Qualifications: Bachelors in Computer Science from Jntu, Hyderabad.

Contact this candidate