Sql Server Data
Resume:
SWETHA
Senior SQL/BI Developer
********@*********.***
Professional Summary:
> 7 Years of extensive experience in SQL Server Development (2012,
2008R2, 2005) including writing T-SQL Programming, SSIS and SSRS.
> Experienced in creating Databases, Tables, Stored Procedure, DDL/DML,
Triggers, Views, User defined data types, Cursors, Indexes, Derived
Tables and Common Table Expressions (CTEs) using T-SQL programming to
facilitate efficient data manipulation and data consistency.
> Good knowledge in Normalizing and De-normalizing the tables and
maintaining Referential Integrity by using Primary Keys and Foreign
Keys.
> Experience in Extracting, Transforming and Loading (ETL) data from
Flat File, Raw File, XML and any OLE BB Data Source to Excel, Flat
File, Raw File, any OLE DB or MS SQL Server Destinations by using SSIS
services.
> Expertise in Creating, Deploying and managing SSIS package.
> Monitored and Optimized SSIS package performance to reach the expected
time frame for data loading.
> Expertise in Creating, Deploying and managing Reports through SQL
Server Reporting Services (SSRS).
> Strong ability in defining query for generating drill down reports,
handling parameterized reports and creating stylish report layouts in
SSRS.
> Developed Standard Reports, Sub Reports, Cross Tab Reports, Used
various Charts and graphs like Bar Chart and Line graphs in SSRS.
> Expert in Query Optimization and tuning the query, creating Indexes to
improve the query performance.
> Expertise in Data Extraction, Transforming and Loading (ETL) between
different Systems using SQL tools (SSIS, DTS, Bulk Insert, and BCP)
> Good knowledge of Data Warehousing methodologies and concepts,
including star schemas, snowflakes, ETL processes, dimensional
modeling and reporting tools.
> Experience in SQL Profiler to monitor the server performance, debug T-
SQL and slow running queries.
> Experience in database Designing/Modeling of new applications and
database changes to existing applications.
> Upgraded the existing environments from SQL Server 2005 to 2008.
> Experience in creating jobs, Alerts, SQL Mail Agent, Database Mails
and Scheduled DTS and SSIS Packages.
> Participates in Disaster Recovery exercises, QA Stress tests and
testing and reporting during hardware/software upgrades.
> Knowledge on Replication Models such as Transaction, Snapshot and
Merge in SQL Server 2005.
> Good in implementing SQL Server Security and Experience in Creating
Roles and Assigning Permissions to the users.
> Extensive experience in developing, enhancing and maintaining web
application.
> Participated in all phases of SDLC starting from Analysis to Delivery
of the application development projects and also supported
enhancements and maintenance of existing applications.
> Strong development experience in Classic ASP/VBScript.
> Good analytical and programming skills in C#, ASP, ASP.NET, VB Script
and Java Script.
> Experience on working in Production Support team and providing support
on 24x7 bases.
> Excellent analytical, high level and low level design and problem
solving skills.
> Hands on experience in project management tools like Team Foundation
Server (TFS), Clear case and VSS.
> Strong analytical skills with ability to quickly understand client's
business needs.
> Involved in meetings to gather information and requirements from the
business and created Business requirement document (BRD) and
Functional requirement document (FRD).
> Research-oriented, motivated, proactive, self-starter with strong
technical, analytical and interpersonal skills.
Education:
Master of Computer Applications, India
Technical Skills:
Relational MS SQL Server 2000/2005/2008/2008R2/2012, Oracle
Databases 8i/9i/10g, SQL Server Management Studio (SSMS), MS
Access.
Tools and SQL Server Management studio, Enterprise Manager,
Packages Profiler, SSIS, SSRS, Microsoft Visual Source Safe,
Visual Studio .Net.
Languages T-SQL, PL/SQL, C, C#, ASP.Net
Operating Systems Windows vista/XP/2003/2000/NT 4.0/9x, MS-DOS
Web Technologies HTML, XML, XSL,, IIS(4.0/5.0/6/0)
Operating Systems Windows 2008, Windows 2000/2003 Server, data center,
Windows NT, Windows 95/98/2000 XP, UNIX, LINUX.
Data Modeling ETL, Visio, Microsoft Office Suite.
Tools
BI Tools SQL Server Integration Services(SSIS), SQL Server
Reporting Tools (SSRS), Crystal Reports
Configuration Visual Source Safe, Team Foundation Server
Management Tools
Professional Experience:
Blue Cross Blue Shield - Richardson, TX
Apr 2014 - Present
Senior BI Developer
Blue Cross and Blue Shield of Texas have been around for more than 80
years, and the cross and shield has come to represent the most experienced
health care coverage organization in the state and the nation. Our mission
is still focused on providing financially sound health care coverage to as
many Texans as possible.
Our BI team was developing the new version of the application that the
medical staffs (Doctors, AC, Medical manager, Billing Manager, Coding
Manager etc.) of the company use for the patient's record keeping, entering
charges, billing and so on.
Responsibilities:
> Involved in system analysis & design of the Enterprise data warehouse
implementation
> Created various database tables and procedures to update and clean the
old data.
> Actively involved as part of a team for gathering and analyzing the
needs of End User Requirement and System Specifications
> Created various complex SQL Queries, Stored Procedures, CLR
Procedures, Views, Cursors and User Defined Functions to implement the
business logic.
> Designed SSIS Packages in SQL Server 2012 to handle data migration
(ETL Processes) from transaction System to Dimensional Model.
> Performed activities like analyzing and improving the architecture of
databases, creation & indexing of the tables.
> Involved in designing the data warehouse and core Database for the
system including tables, Stored Procedures, Indexes, UDF and triggers.
> Performed operations such as Fine-tuning queries and stored procedures
and providing consultation to other developers.
> Implemented SSIS (ETL) to extract and transform data from RDBMS and
Flat files/CSV, SQL Server 2012 instances and to load into staging and
then to DW for further Data Analysis and Reporting by using multiple
transformations provided by SSIS such as Data Conversion, Conditional
Split, Bulk Insert, merge and union all.
> Created SSIS Packages using Lookup, Merge, Sort, Derived Columns,
Condition Split, Aggregate, Execute SQL Task, and Data Flow Task,
Execute Package Task etc. to generate underlying data for the reports
and to export cleaned data from Excel, Text file, XML file to
different data Marts.
> Scheduled and maintained nightly and weekly loads of data by creating
the corresponding job tasks.
> Developed functional and technical specifications documents such as
the Business Scope Document and High Level Design Document.
> Configured and scheduled packages to be deployed out to a production
environment using SQL server Table file configurations in SSIS.
> Configured packages for development, QA and Production environments
> Created tabular, matrix, Drill down and drill through reports, multi
value parameter reports.
> Generated Daily, Weekly, Monthly, Subscriptions, Dashboard reports for
the analysis of managers and end users by using SSRS.
> Deployed the SSRS Reports to the server for the use of end users.
> Created views to facilitate easy user interface implementation, and
triggers on them to facilitate consistent data entry into the
database.
> Used Query Optimization and SQL Server Profiler for tuning report
queries and improved performance in SQL Server.
> Worked closely with DBA team to regularly monitor system for
bottlenecks and implement appropriate solutions
Environment:
Microsoft SQL Server 2012, SSMS, SSIS, SSRS, Microsoft Visual studio 2012,
Team foundation server, C#
Maximus, NYC
Aug 2012 - Mar 2014
Senior BI Developer
SESIS provides coaching, support, and technical assistance to school
districts based on an identified district need. Specific needs have been
determined based on data collected by NYSED related to educational programs
and academic performance of students with disabilities within each
district. SESIS works collaboratively with local school administrators and
teachers to assess their staff development needs and develop and/or align
programs to meet the needs of students with disabilities. The focus of
SESIS is to provide technical assistance that will result in system wide
school improvement.
Responsibilities:
> Worked on the analysis of the Design Specification documents for the
Packages and coordinated with team members at the time of changes in
Business requirements and changes in Data Mart Schema.
> Designed, reviewed, and created primary objects based on logical design
models, user requirements and physical constraints.
> Upgraded the data from one server to another server (SQL Server 2008
to SQL Server 2012) for the SSIS Packages and SSRS reports.
> Created SSIS (SQL Server Integration Service) packages to extract data
from OLTP to OLAP systems with different transformation and scheduled
Jobs to run the packages on a daily basis.
> Implemented the changes in the existing ETL process to move data back and
forth from ODS to all the integrated systems.
> Developed SSIS Packages to extract data from Excel spreadsheets,
Microsoft Access database and flat files, load them onto SQL server
2012 for Data Analysis and Reporting by using multiple data flow
transformations such as Data Conversion, Conditional Split, Bulk
Insert, Merge and Union All.
> Optimized queries by looking at Execution Plan for better tuning of
the database.
> Created Clustered and Non-clustered Indexes for Query Optimization and
also involved in Database Tuning.
> Used SQL Profiler for monitoring and troubleshooting performance
issues in T-SQL code and stored procedures.
> Created/modified complex stored procedures to fit to the changing
requirements and to enhance performance and developed custom
functions, indexes to ensure accuracy, quality and consistency of the
database.
> Created triggers that capture the customer updates and made the required
transformations to move the customer preferences to ODS.
> Created Tables, Stored Procedures, Views, Constraints and User Defined
Functions.
> Involved in the design, development and deployment of customer purge,
mass consolidation process in ODS.
> Created Database Maintenance Plans for the Performance of SQL Server,
which covers Database Integrity Checks, Update Database Statistics and
Re-indexing.
> Worked on the performance optimization of the ODS import jobs.
> Worked on the analysis of test cases with the team members and make the
necessary changes.
> Designed, developed the customer comparison reports in MS SQL Server
environment using SSRS 2008.
> Responsible for optimizing all indexes, SQL queries, stored procedures to
improve the quality of software.
> Providing the client with documentation, with component and task level
details.
> Performed the Unit testing for packages developed to ensure that it
meets the requirements.
> Used SQL Server profiler for auditing and analyzing the events which
occurred during a particular time horizon and stored in script.
> Used the SQL Profiler, query execution plans to trace the performance
of TSQL Statements, procedures and functions.
Environment:
MS SQL Server 2012/2008, SQL Server Reporting Service (SSRS) 2012/2008, SQL
Server Integration Service (SSIS) 2012/2008, T-SQL, PL/SQL, Excel.
ALLTEL, Little Rock, AR Jan
2012- July 2012
SQL Developer
Alltel is owner and operator of the nation's largest wireless network and
has more than 11 million wireless customers .I was involved in the SQL
server development activities and administrative activities for the project
designed for their HR department for enrollment of medical benefits
provided by the company.
Responsibilities:
> Gathered all the requirements from the end users for design and
development of the WAS Application.
> Developed the star schema and the snow flake schemas depending on the
requirements while designing the database.
> Involved in the enhancement of existing database schema by adding new
tables, views, indexes and defining the relations.
> Develop and implement database design documentation, including
database diagrams, data mapping documents, data dictionaries etc.
> Imported data from many heterogeneous elements like SQL Server, flat
files, Excel, DB2 etc into SQL Server using SSIS 2008/2005.
> Used different tasks like scripts task, lookup, fuzzy grouping,
conditional splits etc to load the accurate data into the central data
warehouse and also Implemented Event Handlers and Error Handling in
SSIS packages to notify the process results to various user
communities.
> Involved in the development/testing of the web-based application OLP
using the ASP and C#.NET by maintaining the different layers for
different operations of the application.
> Developed different types of reports for the WAS application like
drill-down, matrix, charts etc with different types of parameters
using SSRS 2008.
> Integrated the reports with the documentum by providing the facility
to pass the parameters through URL of the corresponding reports.
> Scheduled many jobs job to run on a daily basis to import and export
data at nightly basis.
> Created new indexes for better performance of the database, and
maintained data integrity by using foreign key relationship.
> Developed many stored procedures which acts as data source for the all
the web-based and reporting applications here in this project.
Environment:
MS SQL Server 2008, SSRS 2008, SSIS 2008, SSMS, VSS, VB.NET, C#.NET,
ASP.NET, T-SQL, Access and Excel.
NETAPP, Sunnyvale, CA Oct 2010- Dec
2011
SQL Developer
NetApp creates innovative storage and data management solutions that help
accelerate business breakthroughs and deliver outstanding cost efficiency.
Responsibilities:
> Gathered requirements from the business users, created technical
specification documents.
> Defined relationship between tables and enforced the referential
integrity constraints.
> Gathered the data from different sources using SQL Server Integration
Services (SSIS) 2008 using different transformation, constraints,
checkpoints and configuration settings.
> Used C#. Net and VB.NET to develop different modules of the end-user
interfaces and different SSIS packages.
> Used ADO.NET technology such as Data Adapter, Data Reader, Dataset and
Data View, for consistent access to the data store to connect Business
Layer to SQL Server 2000 database in Data Layer.
> Integrated the reporting services with MS Share Point while deploying
the reports and implemented the report subscriptions to run on
daily/weekly/monthly basis and email the results to the business users
in the required format.
> Worked with SQL Profiler, Tuning Wizard, Execution Plan and
Performance Monitor in order to analyze and optimize the queries,
procedures.
> Added/modified Users, Groups, folders, rights and involved in the
implementation of log shipping, mirroring to maintain the high
availability of the servers.
> Created/modified SQL Joins, sub-queries, indexes, stored procedures,
triggers and other T-SQL, PL/SQL code to implement business rules and
automate the tasks.
> Involved in documenting the project steps and presenting to the team
members.
Environment:
MS SQL Server 2008, SSRS 2008, SSIS 2008, SSMS, TFS, VB.NET, C#.NET, T-SQL,
PL/SQL, Oracle 10g, MS Share Point, Access and Excel.
Genpact, Hyderabad, India
Dec 2009 - Sep 2010
Customer-centric database SQL Developer
Responsibilities:
> Involved in Planning, Defining and Designing database depending on
business requirements and provided the documentation.
> Created complex Stored Procedures, User Defined functions, Triggers,
Indexes, Tables, Views, SQL joins and also defined roles and
privileges to implement business rules and control access to database.
> Designed high level ETL architecture for overall data transfer from
the source server to the Enterprise Services Warehouse with different
transformations in order to get the accurate data using SSIS 2008/2005
and deployed the SSIS packages to different environments by
maintaining the configuration settings in the XML files and variables.
> Developed many scripts while designing the SSIS package using C#,
VB.NET in order to perform various transformations while getting the
data from different sources and also resolved the issues with ActiveX
scripts and query driven tasks while migrating the DTS packages to
SSIS.
> Provided statistical information through different reports in order to
explain business conditions and scheduled the reports to run on
daily/weekly/monthly basis and email the results to the business users
in the required format.
> Created parameterized reports and ad hoc reports using Report builder
and developed dashboards with different KPIs, scorecards for the
users/management.
> Used ASP.Net controls like Dropdown list, Button, Textbox controls
while developing the user interface and developed complex web forms
and business components.
> Extensively worked with the SQL Profiler, Database Tuning Wizard and
query execution plans to identify the slow running queries and to test
different application for performance.
Environment:
MS SQL Server 2005/2008, SSRS 2005/2008, SSIS 2005/2008, SSMS, ASP.NET,
VB.NET, C#.NET, T-SQL, PL/SQL, Oracle 10g, MS Share Point, Access and
Excel.
Cytel Solutions, Bangalore, India
Oct 2007- Nov 2009
SQL Developer
Responsibilities:
> Involved in gathering requirements from business users.
> Involved in transformation of data from various sources and legacy
systems like Teradata, SQL Server 2000 and Excel into SQL Server 2000
using DTS.
> Created triggers that capture the claims and wrote complex formulas
that calculate the amounts related to those particular claims.
> Created number of complex formulas to calculate the amounts related to
different claims in sub reports using different types of variables
like shared variable and retrieved them from master report
> Created complex stored procedures to fetch and manipulate data in the
databases.
> Created Tables, Stored Procedures, Views, Constraints and User Defined
Functions.
> Wrote and Optimized Triggers, Stored Procedures and Queries in T-SQL.
> Managed SQL user logins, database user accounts, server roles,
database roles and its permissions.
> Customized reports by adding new features such as report alerts, cross-
tabs, running total, sub-reports and drill-down fields.
> Modified report content and exported reports in multiple formats based
on user input.
> Designed/modified database schema objects to support existing and new
business related application development for a global-application.
Write/test SQL scripts to perform application specific data
manipulation
Environment:
MS SQL Server 2000, T-SQL, DTS, Teradata, Excel.
Contact this candidate