Akshitha

MS SQL Server/SSIS/SSRS Developer

908-***-****

ac7g7m@r.postjobfree.com

Professional Summary

Over 8+ years of extensive experience in database design, development, and administration with MS SQL Server versions 2016/2014/2012/2008R2/2005/2000 using SSIS, SSAS, SSRS in Financial, Retail, Healthcare, Insurance, and Banking industries.

Experienced with all phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development, and Implementation.

Strong experience in logical and physical database design and development, Normalization and data modeling using CA Erwin and MS SQL Server Enterprise manager.

Excellent experience in migration of data from Excel, Flat file, Oracle to Microsoft SQL Server by using SSIS and DTS (Data Transformation Services) utility.

Experienced in designing high level ETL architecture for overall data transfer from the OLTP – Online Transaction Processing to OLAP – Online Analytical Processing with the help of SSIS.

Strong experience in designing and developing large number of reports in SSRS using the data from ETL Loads, MS SSAS Cubes and various heterogeneous data sources.

Worked with T-SQL, DDL, and DML Scripts and established relationships between tables using Primary Keys and Foreign Keys.

Expert in designing and scheduling complex SSIS Packages for transferring data manually from multiple data sources to SQL server.

In depth Knowledge in ER Modeling and Dimensional modeling (Star and Snowflake Schema) building Dimension, Data marts and Fact tables.

Expert in creating, configuring and fine-tuning ETL workflows designed in DTS and MS SQL Server Integration Services (SSIS).

Expert in transforming data from different source (CSV, Flat Files, Excel) to SQL Server databases.

Experience working with ActiveX data Objects.

Good Knowledge with VBA Excel.

Experienced in developing and modifying cubes using SSAS and transform into pivot table.

Experienced in developing and modifying multi-dimensional cubes using SQL Server Analysis Services (SSAS)

Good Knowledge on creating score cards and dash boards using MS Office performance Point Server (MS ProClarity Analytics) Dashboard Designer and integrated them with SharePoint Web Services.

Expert in Creating and Deploying SSRS Reports on the portal for user accessibility.

Expert in developing Drill through and Drill down reports using Crystal Reports and MS SQL Server Reporting Services (SSRS)

Highly proficient in the use of T-SQL for developing complex stored procedures, triggers, tables, user functions, user profiles, relational database models and data integrity, SQL joins and query writing.

Experienced in implementing Key Performance Indicator (KPI) Objects in SSAS 2005.

Efficient in upgrading and migration from SQL Server 2000 to SQL Server 2012/2008R2/2005.

Excellent inter personal skills and communication skills and ready to take challenges with proven ability.

Technical Skills:

SQL Server/BI Tools

SQL Server Management Studio (SSMS), MS Visual Studio 2010/2008, Business Intelligence development Studio (BIDS), Export & Import (DTS), Query Analyzer, SQL Server Reporting Services (SSRS), SQL Server Integrating Services (SSIS), SQL Server Analysis Services (SSAS), SharePoint 2010/2007

Databases

MS SQL Server 2017/2016/2014/2012/2008R2/2008/2005/2000, MS Access, Oracle11g/10g/ 9i

Languages

T-SQL, PL/SQL, C#, VB.Net, HTML, CSS, XML, VBA Excel

Operating Systems

MS-DOS, Windows 7/XP/NT 4.0/2000/2003/2008 Server, UNIX

Database Design Tools and Data Modeling

MS Visio 2008/2011, ERWIN r7/r4/r3.5, Star Schema/Snowflake Schema modeling, FACT & Dimensions tables

Database Tools and Utilities

SQL Server Management Studio, Enterprise Manager Query Analyzer, SQL Profiler, Data Base Engine Tuning Advisor

Version Control Tools

VSS, Sub version, TFS

Professional Experience:

Southern Glazers Wine and Spirits, Miramar FL June 15 – Till Date

Sr. SQL Developer/BI Developer

Responsibilities:

Worked with Business Analysts in gathering requirements and translating them to technical specifications.

Involved in the analysis and profiling of source data, creating prototypes and sample reports to help with requirements and design.

Using SQL Server Reporting Services (SSRS) delivering enterprise, web-enabled reporting to create reports that draw content from a variety of data sources.

Created jobs for automatically running stored procedures for day-end operations using SQL Server agent such as index rebuild, data loads and summary reports

Involved in Performance Tuning of Code using execution plan and SQL profiler and added Indexes to improve performance on tables

Using SQL Server Integration Services (SSIS) to design and maintain ETL Solutions.

Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS 2010, 2012, 2017.

Participating in defining ETL strategies, preparing transformation rules and mapping data from source to target

Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.

Implemented security to restrict the access to users and to allow them to use only certain reports.

Designed and developed efficient SSIS packages for processing fact and dimension tables with complex transformations.

Extracted large volumes of data from various data sources and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).

Created SSIS packages for Uploading of different formats of files (Excel, Access, dbf) and databases (SQL server, Flat files) into the SQL Server data warehouse using SQL Server Integration Services (SSIS).

Experienced using Visio database design.

Migrated data from Heterogeneous Data Sources and legacy system (DB2, Access, Excel) to SQL Server databases using SQL Server Integration Services (SSIS) to overcome transformation constraints

SQL Server Index Maintenance and Performance Tuning for Large Tables

Rewrote and tuned long-running SQL queries to cut execution time, ease database load and improve scalability.

Experienced working with Autosys scheduler for reporting and monitoring jobs.

Experience in ETL Data Warehouse environment. Created Jobs in SSIS and was responsible for ETL job scheduled to run daily.

Designing and implementing a variety of SSRS reports such as Parameterized, Drilldown, Ad hoc and Sub-reports using Report Designer and Report Builder based on the requirements.

Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.

Developed, monitored and deployed SSIS packages.

Creating Reports as per user requirements using SQL Server Reporting Services 2012.

Written complex T-SQL queries and created Stored Procedures, Triggers, Functions and Views using SQL Server 2017, 2016, 2014, 2012.

Experience in SQL DBA.

Environment: MS SQL Server 2008 R2/2012,2014,2016,2017 Excel 2010, Microsoft Integration Services (SSIS), Microsoft Reporting Services (SSRS), Visual Studio 2010, Windows 7, PowerShell, ASP.Net, C#, UNIX

Blue Cross Blue Shield, Washington, DC Jan 14 – May 15

Sr. SQL Server Developer

Responsibilities:

Worked with Business Analysts in gathering requirements and translating them to technical specifications.

Involved in the analysis and profiling of source data, creating prototypes and sample reports to help with requirements and design.

Using SQL Server Reporting Services (SSRS) delivering enterprise, web-enabled reporting to create reports that draw content from a variety of data sources.

Created jobs for automatically running stored procedures for day-end operations using SQL Server agent such as index rebuild, data loads and summary reports

Involved in Performance Tuning of Code using execution plan and SQL profiler and added Indexes to improve performance on tables

Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS 2008.

Participating in defining ETL strategies, preparing transformation rules and mapping data from source to target

Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.

Implemented security to restrict the access to users and to allow them to use only certain reports.

Designed and developed efficient SSIS packages for processing fact and dimension tables with complex transformations.

Extracted large volumes of data from various data sources and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).

Created SSIS packages for Uploading of different formats of files (Excel, Access, dbf) and databases (SQL server, Flat files) into the SQL Server data warehouse using SQL Server Integration Services (SSIS).

SQL Server Index Maintenance and Performance Tuning for Large Tables

Rewrote and tuned long-running SQL queries to cut execution time, ease database load and improve scalability.

Used Script task to write custom code using C#

Experience in ETL Data Warehouse environment. Created Jobs in SSIS and was responsible for ETL job scheduled to run daily.

Designing and implementing a variety of SSRS reports such as Parameterized, Drilldown, Ad hoc and Sub-reports using Report Designer and Report Builder based on the requirements.

Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.

Developed, monitored and deployed SSIS packages.

Creating Reports as per user requirements using SQL Server Reporting Services 2008 R2.

Created different types of reports such as Cross-Tab, Drill-down, Drill Through, OLAP and Sub reports, and formatting them using both SSRS 2008 R2.

Written complex T-SQL queries and created Stored Procedures, Triggers, Functions and Views.

Created data driven subscriptions for different users using Report Manager.

Environment: MS SQL Server 2008 R2/2012, Team Foundation Server, Microsoft SharePoint Server (MOSS 2007), Crystal Reports, SQL Server Integration Services (SSIS), C#, SQL Server Reporting Services (SSRS), Visual Studio 2010, Windows 7, T-, Erwin v8.0, ASP.Net, C#.

McKesson, Tulsa, OK Dec 12 – Jan 14

Sr. SQL Developer/BI Developer

Responsibilities:

Worked on Migration from SQL Server 2000/2005 to SQL Server 2008R2 and SQL Server 2012.

Worked on upgrading SQL Server 2000 and 2005 databases to SQL Server 2008 R2 and SQL Server 2012.

Experience in moving data from heterogeneous data sources to SQL Server using DTS/SSIS.

Experience in Bulk Copy (BCP), Script task and Script component for complex SSIS transformations.

Experience in Data Conversion and Data Migration using SSIS and DTS services across different databases like Oracle, MS access and flat files.

Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart, Ad hoc, Sub Reports and created report subscriptions.

Created Reports with complex formulas and to query the database for business Intelligence.

Developed Drill Down, Cascading, Drill through, Sub reports and Charts using Global variables, Parameters Expressions and Functions for the Business Users

Experience in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS).

Participated in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema for developing Cubes in SQL Server Analysis Services (SSAS).

Migrated DTS packages into SSIS packages.

Experience in working and fixing defects on upgrades to systems from SQL Server 2005 to SQL server 2012.

MS SQL Server Configuration, Performance Tuning, Client-Server Connectivity, Query Optimization, Database Maintenance Plans and Database Consistency Checking DBCC commands.

Experience in using profilers, IndexTuning Wizard and performance monitor to monitor SQL Server.

Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance

Worked with test and production teams to Promote Stored Procedures, SSIS packages and Reports into production.

Skilled at assessing client needs, working in groups, suggesting ideas that enhance efficiency and performance, implementing technology solutions, and training end users.

Environment: SQL Server 2012/2008R2 Enterprise Edition, Windows Enterprise Server 2008R2, IIS 7.5, C#, SSRS, SSIS, Excel 2007/2010

General Motors, Atlanta, GA Oct 11 – Nov 12

SQL/SSRS/SSIS Developer

Responsibilities:

Participate in being a member of ICIS team helping users create data, monitoring and resolving issues in the area of Data Management and Integration Services.

Perform System and Requirement Analysis, design and writing technical design documents and test plans.

Design/Build Extract Transform Load procedures in SQL Server Integration Services

Worked on creating SSIS packages to upgrade SQL Server 2005 to SQL Server 2008.

Troubleshooting ODBC and OLEDB connection issues in SSIS packages.

Design and develop mappings, sessions and workflow as per the requirement and Wells Fargo standards

Design and develop SQL Server 2008 Database, Tables, Indexes, Stored procedures, Views, Triggers.

Develop the application based on Wells Fargo enterprise architecture framework, which includes Understanding and implementing the Enterprise Architecture Best Practices, Guidelines and Standards, ETL framework and Enterprise Scheduling.

Utilized a combination of stored procedures and Integration Services to enable required data extract, transform and load procedures and packages (ETL).

Creating reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries.

Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).

Developed various operational Drill-through and Drill-down reports using SSRS in SSIS and T-SQL (SQL Server).

Review code delivery and manage the version in Team Foundation Server.

Design/Build Extract Transform Load procedures in SQL Server Integration Services.

Technical Documentation and Perform reviews, design and data manipulation.

Production Support and resolving the issues.

Environment: SQL Server 2008 Enterprise Edition, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS), Microsoft Office Share Point Server, XML, MS Visual Source Safe and Windows Server 2003.

Polaris, Hyderabad India Feb 10 – Sept 11

SQL Server Developer

Responsibilities:

Implemented a well-planned backup and restore strategy that protects databases against data loss

Responsible for design, development and implementation of mappings/transformations based in source-to-target specifications, defining ETL (extract transform, load).

Developed complex SQL queries, stored procedures, and DTS packages

Involved in complete SDLC, which includes requirement gathering, analysis, design, development, Implementation

Involved in designing and writing Stored Procedures, functions and packages using T-SQL for SQL Server 2005

Used DBCC utilities to fix data corruption in application databases

Development of Business rules implemented as Constraints, Triggers and or Stored Procedures

Actively involved in Normalization & De-normalization of database.

Installed and Configured SQL Server 2005 on servers.

Designed DDL and DML for MS SQL Server 2005.

Using SQL Server Integration Services (SSIS) to populate data from various data sources

Optimized query performance by creating indexes.

Involved in writing SQL batch scripts.

Created scripts for tables, stored procedures and DTS.

Writing T-SQL statements for retrieval of data and Involved in performance tuning of TSQL

Involved in merging existing databases and designed new data models to meet the requirements.

Create joins and sub-queries for complex queries involving multiple tables.

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

Taking Database full Backup, Transaction log backup & differential backup in daily Routine

Monitor production Server Activity

Worked with DTS packages to load the massaged data into Data warehousing system

Tuned the SQL queries using SQL profiler and involved in tuning the database

Environment: SQL Server 2005 Enterprise, Windows Enterprise Server 2003, Erwin, Microsoft Visio, DTS, SQL Profiler, Query Analyzer.

Contact this candidate