Sql Server Data
Resume:
Akshitha
Sr. SQL Server Developer
********.***@*****.***
4815
Professional Summary
. Over 8 years of extensive experience in database design, development,
and administration with MS SQL Server versions 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 and Fact tables.
. Expert in creating, configuring and fine-tuning ETL workflows designed
in DTS and MS SQL Server Integration Services (SSIS).
. 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 SQL Server Management Studio(SSMS),MS Visual Studio
Tools 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 2012/2008R2/2008/2005/2000, MS Access,
Oracle11g/10g/ 9i
Languages T-SQL,PL/SQL, C#,VB.Net, HTML, CSS, XML
Operating Systems MS-DOS, Windows 7/XP/NT 4.0/2000/2003/2008 Server, UNIX
Database Design MS Visio 2008/2011, ERWIN r7/r4/r3.5, Star
Tools and Data Schema/Snowflake Schema modeling, FACT & Dimensions
Modeling tables
Database Tools SQL Server Management Studio, Enterprise Manager Query
and Utilities Analyzer, SQL Profiler, Data Base Engine Tuning Advisor
Version Control VSS, Sub version, TFS
Tools
Professional Experience
Blue Cross Blue Shield, Washington, DC
Jan 14 - Present
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).
. 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
Wisconsin Medical College, Milwaukee WI
Mar 11 - Nov 12
Sr SQL Server Developer/ETL Developer
Responsibilities:
. Designing Data Model and implementing changes in the earlier phase of
the project to accommodate business logic and dynamic nature of the
front-end application.
. Designed and developed Microsoft SQL Server 2008 R2 data warehouse and
data marts, including the modification of existing Microsoft SQL
Server 2005 data warehouse and data marts.
. Used SSIS packages to roll out data to Live Tables and to Processing
Database.
. Developed database objects such as Tables, Triggers, and Indexes using
T-SQL, SQL Analyzer and Enterprise Manager
. Develop the Documents for Logging/Error Handling for SSIS Packages
. Schedule Package using SQL Server Job for daily/weekly/monthly feeds.
. Used Checkpoint as part of SSIS packages to rerun the package from the
closest point of failure.
. Develop the Slowly Changing Transformation to maintain the Historical
Data.
. Handling the errors during data moving and Sequencing the task as per
requirements.
. Developed packages using fuzzy task for data cleansing.
. Handling the orphan rows in Dimension and Fact tables.
. Participated actively in analysis and discovery phases of data
warehouse implementation.
. Perform T-SQL tuning and optimizing queries for Reports, which take
longer, time in execution SQL Server 2008.
. Developed interface and reporting stored procedures, views, UDF for
efficient data storage and manipulation
. Migrated some Crystal reports to SSRS reports manually
. Used XML result set from Stored Procedures to create custom XML file
for third party data export.
. Extensive work on SSIS creating all the interfaces between front end
application and SQL Server 2008 database, then from legacy database to
SQL Server Database and vice versa.
Environment: MS SQL Server 2008 R2, SSRS, T-SQL, SSIS, Win 2003 Advanced
Server, Erwin v7.2
General Motors, Atlanta, GA
Oct 09 - Feb 11
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
Mar 07 - Sep 09
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