Sql Server Data
Resume:
Sruti Marepally
*****************@*****.***
Professional Summary
7+ years of hands on experience in Database Design, T-SQL, Integration Services, Reporting,
Analysis and Support of Microsoft SQL Server 2005/2008/2008R2/2012.
Hands on experience in installing, configuring, managing, upgrading, monitoring and troubleshooting
SQL Server 2005/2008/2012.
Extensive work experience on system analysis, design, development, testing and implementation of
projects with full SDLC (Software Development Life Cycle).
Good experience in both OLTP and OLAP database designs and implementation strategies.
Good experience in Dimensional modeling using Star Schema/Snowflake modeling concepts and
Kimball/Inmon strategies.
Worked with end users/customers to understand business requirements, recommended technical
solutions and documented functional requirements.
Excellent communication skills bridging Client Interaction and Team Management.
Ability to handle multiple tasks, Initiative and Adaptable. Self-motivated, organized team player with
strong problem solving and analytical skills and total commitment to the organization goals.
Experience in creating macros, spreadsheets and pivot tables using Excel.
T-SQL
Strong Transact-SQL query writing skills (DDL, DML, and DCL).
Experience in writing T-SQL Queries, Dynamic-queries, sub-queries and complex joins for generating
Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
Experienced in creating Databases, Indexes, Functions, File groups and Transaction logs.
Experienced in SQL Optimizing by using SQL Profiler, Index Tuning Wizard, Database Tuning Advisor
and Query Execution Plans.
SSIS
Experienced in migrating Organizational, Orders, Adjustments and Objectives in various formats like
text based files, Excel spreadsheets, to SQL Server databases using SQL Server Integration Services
(SSIS) to overcome the transformation constraints.
Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as Data
Transformation Services (DTS), MS SQL Server Integration Services (SSIS) packages, Bulk
Insert/ BCP utility.
Experience in creating and deploying SSIS packages using various Transformations such as
Slowly Changing Dimension, Multicast, Merge Join, Lookup, Fuzzy Lookup, Conditional Split,
Aggregate, Derived Column, and Data Conversion Transformations.
Skilled in error and event handling, Precedence Constraints, Break Points, Check points and
Logging.
Hands on experience in extracting data from various source(flat files, OLEDB, Excel) and loading it to
different destinations like (FTP,SFTP, SharePoint, OLEDB)
SSRS
Designing, Development and Deployment of Reports in Business Intelligence Development Studio
(BIDS).
Strong Experience in creating parameterized reports, drilldown reports, drill-through reports and
Snapshots in SSRS 2005/ 2008/2008 R2.
Experienced in creating various SSRS Reports involving variety of features like Charts, Filters, Sub-
Reports, Multi-valued parameters etc.
Worked with Dimensional modeling, Data Mapping, Data Migration/Conversion, OLAP/Data
Warehouse/Data Mart (ETL Process, Star/Snowflakes schema), Dashboards and Layers
(Data/Business/Presentation). Created tables, fact tables, dimensions, views and cubes.
Effectively maintained positive and productive working relationships in internal/external team
environments.
Team player and self-starter with excellent communication skills, ability to work independently or as a
part of team and capable of picking up new skills quickly.
TECHINCAL SKILLS:
Operating Systems Windows XP, 2003/2008 Server, UNIX, LINUX
Databases MS SQL Server 2005/2008/2012, Oracle, Access
SQL Server Tools Management Studio(SSMS), Business Intelligence Development Studio(BIDS), Enterprise
Manager, Query Analyzer, Profiler,
Performance Monitor
ETL Tools DTS, SQL Server Integration Services (SSIS)
Reporting/Analysis Tools SQL Server Reporting Services(SSRS), Analysis Services(SSAS),
Cognos(Basics)
Development Skills SQL, Transact SQL(T-SQL), PL/SQL
Configuration
Management Tools Visual Source Safe, Team Foundation Server, Zena, SalesForce
and others
Professional Experience:
Database Analyst/Developer
Sruti Marepally
*****************@*****.***
BenefitMall (Insurance/Payroll), Dallas, TX Nov, 2014 – April, 2015
BenefitMall provides benefit and payroll products and services designed to help more than small and
medium-sized businesses. As a Database Analyst/Developer I was responsible for the review, analysis,
design, modification and execution of routine tasks to support platform databases. Prepared and
presented reports to senior management that helped in determining business and functional requirements
and making business decisions.
Deliverables:
Used relational database concepts and data structure to design and develop database applications.
Created and modified complex Store procedures for automation of certain daily and weekly jobs.
Implemented SSIS (ETL) to extract and transform data from RDBMS and Flat files/CSV, SQL Server
2008 and 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 and also using C# scripting.
Extracted data from complex flat files transformed them according to business requirements and
exported them to clients SFTP site.
Reviewed and analyzed business requirements and processes with business analyst and clients that
resulted in objectives for data analysis and business rules incorporated into system design and
defining reporting criteria.
Queried and analyzed data from (applications like Salesforce) to extract report and isolate data after
recognizing issues within the dataset.
Created monthly reports and dashboards using SSRS for stakeholders.
Created pivot tables and summary sheets in Excel for the accounting department.
Created logical data maps and data dictionaries that defined data integration process.
Created system and data analysis documentation.
Created MS Visio flow diagrams for presenting data models and process flow.
Created fact and dimension tables and cubes using SSAS (star schema) that was used by finance
department.
Performed primary and secondary on-call duties, which included trouble shooting job failures,
implementing change management activities, and working with DBA to monitor and resolve any
production outage events.
Worked with the QA team to insure that the project’ functionality and development meets the
standards for the company’s production systems.
Communicated effectively both verbally and in writing with both internal and external personnel.
Managed multiple responsibilities simultaneously
Environment: MS SQL Server 2008R2/2012, Windows XP, Visual Source Safe, MS Visio, Salesforce, C#
scripting.
Database Developer
BCBS, Richardson, TX May, 2014 – Sep, 2014
Provided technical support in developing and maintaining database applications, with a primary focus on
complex SQL joins, data cleansing, data extracting, data conversation and data integration; worked with
business and IT leads to determine business and functional requirements and identify solutions to resolve
those needs.
Deliverables:
Responsible for designing, modeling, developing and supporting Database Management Systems
(DBMS)
Analyzed the data requirements for application and processed architectures, data dictionaries, and
database schema(s), and then based on that designed, developed, amended, optimized, and certified
the database schema design to meet system(s) requirements
Gathered, analyzed, and normalized relevant information related to, and from business processes,
functions, and operations to evaluate data credibility and determine relevance and meaning
Developed database and warehouse designs across multiple platforms and computing environments
Developed an overall data architecture that supports the information needs of the business in a
flexible but secure environment
Worked with Application team and made sure all their requirements are met in terms of data
provisioning.
Created and Modified complex Store procedures for automation of certain daily jobs
Created and Edited Jobs using Sql Server agent and learnt the use of Zena for scheduling works.
Worked on slow performing queries and improvised performance using Execution Plans, SQL profiler
and Index Tuning Wizard.
Implemented SSIS (ETL) to extract and transform data from RDBMS and Flat files/CSV, SQL Server
2008 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.
Configured SQL Mail agent for sending automated alerts/email.
Created indexes on selective columns to speed up queries and analyses in SQL Server Management
Studio.
Modified existing databases by adding/removing tables there by altering referential integrity, primary
key constraints and relationships according to requirements.
Worked on data analysis, problem diagnosis and database performance tuning/optimization.
Environment: MS SQL Server 2008R2, Windows XP, Visual Source Safe, Zena, Cognos.
Sruti Marepally
*****************@*****.***
SQL Server SSIS/SSRS ETL Developer
United Health Care, Rockville, MD Nov, 2012 – April, 2014
United Health Care aka United Health Group, is the largest single health carrier in united states, serving
about 80 million Americans. The Scope of the project was to full-fill the IT application team’s T-SQL data
integration and reporting requests. Follow agile methodology in delivering the solutions for the
requirements. Manipulation of data for application display, Data retrievals’ and data loads. Maintaining
and documenting the developed code. On-call support for production releases.
Deliverables:
Worked closely with Business SME’s and discuss about data related documents and maintain
documents related to Health Insurance Data.
Involved in Logical & Physical Data modeling, data architecture design.
Worked with Data Analysts in slicing and dicing the data as per requirements.
Worked with Application team and made sure all their requirements are met in terms of data
provisioning.
Created necessary tables and adjusted the existing data model to the changes made.
Created views to facilitate easy user interface implementation, and triggers on them to facilitate
consistent data entry into the database.
Automated and enhanced daily administrative tasks including database backup and recovery.
Designed SSIS Packages in SQL Server 2008 to handle data migration (ETL Processes) from
transaction System to Dimensional Model.
Implemented SSIS (ETL) to extract and transform data from RDBMS and Flat files/CSV, SQL Server
2008 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.
Configured SQL Mail agent for sending automated alerts/email.
Provided documentation for all kinds of reports and SSIS packages.
Scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks.
Generated parameterized reports, sub reports, tabular reports using SSRS 2008.
Developed and maintained Stored Procedures, Views and Functions.
Worked on XML creation using Stored Procedures and straight T-SQL.
Involved in Quality Assurance of Data using application at all environments.
Worked closely with Report developers and testing team to help them necessary with data extracts for
analysis.
Implemented triggers, stored procedures and manipulated data using DDL and DML functions.
Designed and developed a project plan and a checklist of all tasks that need to be done before
Production Releases.
Involved in fine-tuning of database objects and server to ensure efficient data retrieval.
Created Indexes, Constraints and Views as per design needs.
Provided DB Production support for IT Code releases.
Environment: MS SQL Server 2008, Windows XP.
SQL Server SSIS/SSRS ETL Developer
Vanguard, Valley Forge, PA Sep, 2011 – Oct, 2012
Vanguard is the client-owned investment company that has been helping investors for decades in
reducing costs and complexity’s in investments. The company is owned by the Vanguard funds, which in
turn are Client owned and hence it is the company of the client.
Scope of the project includes manipulation of data for application display, data retrievals’ and data loads.
Maintaining and documenting the developed code. Front end being built of Java plat platform and back
end being supported by SQL server 2008. The scope of the contract was also to provide support and
development from back end SQL server perspective.
Deliverables:
Actively participated in interaction with users, team lead, DBAs and technical manager to fully
understand the requirements of the system.
Wrote several SQL Scripts such us finding tables that have Identity Columns, finding tables that do
not have primary key.
Used Joins, correlated and non correlated sub-queries for complex business queries involving
multiple tables from different databases and implemented triggers and stored procedures and
enforced business rules via checks and constraints.
Created indexes on selective columns to speed up queries and analyses in SQL Server Management
Studio.
Reduced the T-SQL overhead successfully by avoiding unnecessary use of the UNION, statement &
using the TOP operator to limit the Select Statement in certain Queries.
Created views to restrict access to data in a table for security.
Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence
Development Studio.
Created SSIS packages using various Data transformations like conditional splitting, Fuzzy Lookup,
Foreachloop, Multi Cast, column conversion, Fuzzy Grouping, Script Components.
Handled slowly changing dimensions to maintain the history of the data.
Used BCP to transfer the data file to other server.
Schedule Jobs to run SSIS package in night feed to DSS system for fresh day data.
Generated server side T-SQL scripts for data manipulation and validation and created various
snapshots and materialized views for remote instances.
Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2008.
Used complex expressions to Calculate, Group, Filter, Parameterize, and Format the contents of the
report.
Sruti Marepally
*****************@*****.***
Involved in Report Design and Coding for Standard Tabular type reports, including Drill down and Drill
through functionality and Graphical presentations such as Charts and Dashboard type metrics using
SSRS
Created Cross-Tab and Sub-Report using RDL and promoted RDLs to Reporting Service Server.
Worked on querying data and creating on-demand reports using Report Builder in SSRS reports and
send the reports via email.
Developed Stored Procedures and views to generate various Drill-through reports, parameterized
reports and linked reports using SSRS.
Enhanced performance using optimization techniques-normalization, indexing and Transaction
Isolation levels, monitoring logs to ensure the completeness of batch processes and scripts.
Environment: SQL Server 2008, MS Analysis Service, SSAS Developer 2008, MS Project, Windows XP
platform.
SQL Server SSIS/SSRS ETL Developer
Hartford Health Care, Middletown, CT Aug, 2010 - Aug 2011
Hartford Hospital is one of the largest medical centers in New England. It is a Major tertiary care and
community health care center, serving a state wide patient population. Scope of the project was to
provide BI Solutions based from an existing Data warehouse.
Deliverables:
Worked on the Supply and Distribution module of the project as a developer on MS SQL Server 2008.
Developed complex SQL code’s for data retrieval.
Worked on several Ad-hoc Data Extraction requirements that were submitted by the business as part
of the BI solutions.
Used ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data
warehouse.
Created SSIS packages using various Data transformations like conditional splitting, Fuzzy Lookup,
Foreachloop, Multi Cast, column conversion, Fuzzy Grouping, Script Components.
Used BCP to transfer the data file to other server.
Schedule Jobs to run SSIS package in night feed to DSS system for fresh day data.
Generated server side T-SQL scripts for data manipulation and validation and created various
snapshots and materialized views for remote instances.
Modified existing databases by adding/removing tables there by altering referential integrity, primary
key constraints and relationships according to requirements.
Designed and implemented of Stored Procedures and Triggers for automating tasks.
Worked on creating data Extraction using SQL and creating data dump files, for moving data from one
environment to other.
Responsible for transferring the data from different servers using SSIS packages.
Generated reports using SQL Server Reporting services.
Designed and created Views for security purposes.
Environment: SQL Server 2008 Enterprise Edition, MS Access, Query Analyzer, SQL Server reporting
Services, SQL Profiler, Windows XP.
SQL Developer
Verizon Wireless, Irving, TX May 2009 – July2010
Deliverables:
Created, maintained and tuned various Database Objects such as Tables, Indexes and views using
DDL, DML and DCL.
Developed stored procedures, Views and triggers using T-SQL as per the business need.
Designed and developed OLAP models. Developed Dimension and Facts based on business
requirements.
Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies
based on the OLAP reporting needs.
Created SSIS process design architecting the flow of data from various sources to target.
Constructed Cubes based on data volumes mostly adhering to Star Schema.
Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data
warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP
databases.
Reviewed and fine tuned stored procedures and triggers before production migration.
Fine tuned database objects and server to ensure efficient data retrieval.
Assisted the front end application developers with their queries.
Involved in project status report updates/creation of issue items for reviews/updates of technical and
transformation files on timely basis.
Environment: MS SQL Server 2005, MS Analysis Services 2005, MS Access, Import & Export Data,
Windows XP.
SQL Server Developer
Florida Crystals Corporation, Florida Mar 2008 – April 2009
Deliverables:
Responsible for requirements gathering from business users.
Wrote user requirement documents based on functional specification.
Designed data models using Erwin.
Developed physical data models and created DDL scripts to create database schema and database
objects.
Developed source to target specifications.
Developed stored procedures, functions, views and triggers.
Sruti Marepally
*****************@*****.***
Created and scheduled SSIS packages for running AM and PM feeds from various departments
and multiple servers and resources to Development Servers.
Extracted required mapping fields from different sources (schema, CDW) to data Warehouse for
Staging Table.
Tested the data with complex queries, joins, sub queries and temp tables.
Created SSIS Packages by using advanced tools (i.e. pivot Transformation, Derived Columns,
Condition Split, Term extraction, Aggregations, Multicasting).
Developed stored procedures to transform the data from enterprise data warehouse to APT data mart
to build dimensions and load data to fact tables.
Created DTS package to schedule the jobs for batch processing. Performance tuning to optimize
SQL queries using query analyzer.
Created indexes, constraints and rules on database objects.
SQL Server Developer
Pacific Investment Management Co. LLC,
Newport Beach, CA Jan 2007- Feb 2008
Pacific Investment Management Co LLC (PIMCO) is a privately owned investment manager with
approximately $642 billion in assets under management. The firm provides its services to high net worth
individuals, banking or thrift institutions, investment companies, pension and profit sharing plans, pooled
investment vehicles, charitable organizations, corporations, state or municipal government entities,
foreign clients, and pooled vehicles.
Deliverables:
Worked as a developer on databases like MS SQL Server 2005.
Tested to optimize the Stored Procedures and Triggers to be used in production.
Maintained the client relationship by communicating the daily statuses and weekly statuses of the
project.
Designed and implemented the Logical and Physical model of the database using Erwin.
Planed, defined and designed data flow processes for data migration to the Data Warehouse using
DTS.
Created Database Objects – Tables, Indexes, Views, User defined functions, Cursors, Triggers,
Stored Procedure, Constraints and Roles.
Developed complex T-SQL code for the application.
Worked in Enterprise Manager for job scheduling and batch queries.
Installed and maintained MS SQL Server 2005.
Monitored performance and optimized SQL queries for maximum efficiency.
Implemented fine tuning of database objects and server to ensure efficient data retrieval.
Managed and monitored the use of disk space.
Planned Backup strategy based on projects requirements.
Maintained the consistency of the client’s Database using DBCC.
Environment:
MS SQLServer2005, MS Access, Query Analyzer, DTS, BCP, SQL Profiler, Import & Export Data.
Contact this candidate