Sql Server Data

SNEHA SINGH

Contact: 718-***-****

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

SUMMARY:

* ***** ** ** ********** in database design and development in Microsoft SQL Server Suite of Products.

Expert in working with the Business Intelligence Development Studio (BIDS), which includes SSIS, SSAS and SSRS.

Experience in SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment.

Good hands-on working experience with using all kinds of SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Checks, and Unique), Writing Transact SQL (T-SQL) Queries, & Dynamic-queries.

Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Bulk Insert, Data Replication, Data Transformation Services (DTS) and SQL Server Integration Services (SSIS).

Proficient in OLTP, OLAP and Data warehousing Design concepts.

Strong ability in defining query for generating drill down reports, handling parameterized reports and creating stylish report layouts in SSRS.

Experience in generating Drill through and Drill down reports with Drop down menu option, sorting the data, defining subtotals in SSRS.

Generated reports using SSRS, Excel (Pivot) that could be used to send information to diverse group of users.

Extensive experience in different type of reports including: Tabular forms, Matrix (cross Tab report) form, Conditional, List items, Charts and Sub reports.

Experience in Cube designing in Business Intelligence Development Studio (SSAS) to edit various properties of a cube, including the measure groups and measures, cube dimensions and dimension relationships, calculations.

Good Knowledge in OLAP Storage modes likes Rolap/Molap/Holap. Hands on experience in writing MDX queries in Analysis Services and Reporting Services.

Experience in Relational, Multi-Dimensional (Star) and Snowflake logical modeling.

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

Solid understanding of RDBMS database concepts and Experience in writing complex stored procedures, functions, Indexed views and triggers for data consistency and manipulation.

Expertise in Database Administration operations like Backup, Recovery, Replication and using SQL Profiler and excellent knowledge of DDL and DML in T-SQL.

Expert in implementing and planning Server Security and authentication, Database Normalization, designing and creating Indexes, Develop Queries and T-SQL Scripts in MS SQL.

Skilled in Query Optimization, Performance tuning, and providing database security by creating users, permissions, and role-based access to data.

Experience in developing SSAS projects using MDX in MSSQL Server 2005.

Experience in creating XML files and XSD schema files.

Developed reports using global variables, expressions and functions using SSRS.

Excellent knowledge on Object Oriented Analysis and Design concepts.

In depth knowledge and understanding of all the stages in Software Development Life Cycle (SDLC).

Experience in working in tight schedules, result oriented & committed to meet the goal.

Have relevant Technical, Analytical, Managerial, Interpersonal and Organizational skills.

Good team player and self-starter with excellent communication and written skills.

Excellent time management and strong team player.

TECHNICAL SKILLS:

Operating Systems

Windows 2008, 2003R2, 2003, 2000 Advanced Server, Windows NT, Windows 95/98/2000 XP/Unix

Databases

MYSQL Server 2000/2005/2008/2008R2/2012,MS Excel/MSWord/MS Access

Database Tools

SQL Enterprise Manager, SQL Profiler, Power Shell, DTS Import/Export, SQL Client Configuration utility, MS OLAP Services, SSMS, SQL Server BIDS/SSDT(SQL Server 2012)

Modeling Techniques/Tools

Flow Charts, Sequence Diagrams, Activity Diagrams, Use case diagrams, Data Modeling, ER Diagrams, MS Visio, Rational Rose

Data Warehousing/BI Tools

SQL Server Business Intelligence Development – SSIS, SSAS, SSRS, DTS, Performance Point Server

Testing

Manual Testing,QTP

ETL Tools

Experienced working with SSDT/BIDS-DTS, SQL Server Integration Services (SSIS), SQL Server Reporting (SSRS).

Reporting Tools

SQL Server Reporting Services (SSRS), Crystal Reports

Development skills

Transact SQL (T-SQL)

Languages

C, C++, HTML, XML/XSLT/.Net/C#,core java

PROFESSIONAL SUMMARY:

Assurant Solutions June 2014 - Till Date

Atlanta GA

Role: SQL Server SSIS/SSRS/SSAS Developer

DESCRIPTION: Assurant Solutions is part of Assurant, a premier provider of specialty insurance products and related services in North America, Latin America, and Europe and select worldwide markets. Assurant safeguards clients and consumers when the unexpected occurs. Its four operating segments, Assurant

Solutions, Assurant Specialty Property, Assurant Health and Assurant Employee Benefits, partner with clients who are leaders in their industries to provide consumers peace of mind and financial security. Assurant’s diverse offerings include mobile protection products and services; extended service programs and related services for consumer electronics, appliances and vehicles; pre-funded funeral insurance; lender-placed homeowners insurance; property, appraisal, preservation and valuation services; renters insurance and related products; manufactured housing homeowners insurance; individual health and small employer group health insurance; group dental insurance; group disability insurance; and group life insurance.

RESPONSIBILITIES:

Data Analysis and Migration of Data

Involved in complete Software Development Cycle (SDLC).

Created SSIS packages to load data into Sql Server using various transformations in SSIS.

Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into Database and Billing Systems.

Capture business objectives and processes and design and develop a comprehensive application and solution.

Extract the data from various sources like SQL Server, Text files, and access into Data Warehouse.

Works with SQL Server, SSIS technologies and has a good Data Warehouse knowledge and tools

Extract Transform and Load (ETL) source data into respective target tables to build the required data marts.

Involved in the data mapping sessions and creation of Data dictionary

Migration of the data from one environment to other environment. Testing and analysis of the migrated data.

Identify and replace manual processes and exchange of data with an Automated System.

Implement the best design patterns in data migration to adapt for future changes.

Review several test plans and test scenarios with the QC team for each project worked on.

Involved in designing, developing, debugging and testing of reports in SQL Server Reporting Services (SSRS).

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

Generated multiple Enterprise reports (SSRS/Crystal/Impromptu) from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, Parameterized Reports.

Created report snapshots to improve the performance of SSRS.

Worked on Performance tuning of ETL transformations, data validations and Stored Procedures.

Worked with Business Analysts and Users to understand the requirement.

Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc.

To generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.

Created tabular, matrix, chart, drilldown reports, and parameterized, cascaded reports according to business requirement.

Involved in developing Cubes in Business Intelligence Development Studio using SSAS.

Documentation for all kinds of reports and SSIS packages.

Successfully conducted root cause analysis to identify the underlying issues and design solutions accordingly.

ENVIRONMENT: MSSQL Server, SSIS, TFS, SSMS, SSIS, SSRS, DTS, VSS, XML, MS Access visual studio etc.

Red box Sept 2013 - May2014

Oakbrook Terrace, IL

Role: SQL Server SSIS/SSRS/SSAS Developer

DESCRIPTION: Red box Automated Retail, LLC is a subsidiary of Outerwall, Inc. specializing in DVD, Blu-ray, and Video Game rentals via Automated Retail Kiosks. Redbox kiosks feature the company's signature red color and are located at convenience stores, fast food restaurants, grocery stores, mass retailers, and pharmacies The Business Intelligence Developer will report to the Business Intelligence team which is responsible for Data Warehouse modeling & design, ETL development, Enterprise reporting - analysis, requirements gathering and report development. The ideal candidate should demonstrate thorough knowledge of BI, data warehouse development, and data analysis.

RESPONSIBILITIES:

Contribute to the Software development lifecycle including gathering and understating of requirements.

Database and Report development using SQL Server 2008 Business Intelligence Development Tools

Develop Stored Procedures, Functions, Views and indexes for use in Analysis and Reporting Using Microsoft SQL Server.

Create Queries to provide ad-hoc reports and datasets based on business needs.

Created an SSIS package for reading multiple excel files from the source and added validation before loading into destination tables

Created an SSIS package which can load multiple sheets in an excel work book dynamically.

Did an end to end testing of the data in TEST and Production databases after loading the data.

Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL.

Perform Data analysis and data validation by writing SQL queries using SQL Server Management Studio.

Using SSIS to Create ETL packages to validate, Extract, Transform and Load Data to Data Warehouse databases.

Create Parameterized SSRS Reports and ETL packages using SSAS Cubes.

Create SSIS Package to provide Data feeds to Business users.

Work with Subject Matter Experts (SMEs) in Understanding, documenting and Deploying the Code Changes

Work with the Business teams to determine the Requirements and working on BI Solutions including developing, Modifying and Optimizing Database Objects.

Conduct Post Deployment and Analysis on Production Server for the new Code Change

Involve in Unit Testing, Integration Testing and System Testing and identifying the defects In the code and fix them to deliver better product for the business

Deployed and generated reports on to the server using the Reporting Services Report Manager.

Deployed and uploaded the SSRS reports to SharePoint Server for the end users and involved in enhancements and modifications.

ENVIRONMENT: SQL Server 2008/2012,SSMS, SSIS, SSRS, SSAS, DTS, VSS, XML,MS Access, SharePoint Server, Windows 2005/2008 Server, Visual Studio 2008,TFS 2013

SFO Health Plan, CA June 2011 – Aug 2013

Role: SQL Server SSIS/SSRS/SSAS Developer

DESCRIPTION: San Francisco Health Plan (SFHP) is a licensed community health plan that provides affordable health care coverage to over 130,000 low and moderate-income families. The project focused on maintaining and optimizing the existing databases, monitoring database Performance and growth, performance tuning, to create Reports according to the business requirement using SQL Server Reporting Service (SSRS) and populate data warehouse using SQL Server Integration Service (SSIS).

RESPONSIBILITIES:

Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.

Designed and tested (Unit, Integration and Regression) packages to extract, transform and load Data using SQL Server Integration Services (SSIS).

Transferred data from various OLTP data sources, such as Oracle, MS Access, MS Excel, Flat Files, CSV files into SQL Server 2008.

Designed packages which utilized tasks and transformations such as Execute SQL Task,

Execute Process Task, Send Mail Task, FTP task, Execute Package task, Xml Task, Data Flow Task, Sequence Container, For Each Loop Container, Lookup, Aggregate, Expression, OLE DB Command, and Derived Column.

Developed error handling routines for packages using both script tasks as well as in the error Handling environment.

Created a number of cubes, dimensions and business critical KPIs using SQL Server Analysis Services (SSAS) representing aggregations in several different ways - hierarchically and using Custom groupings that the company will use to analyze performance.

Created complex SSAS cubes with multiple fact measures groups, and multiple dimension

Hierarchies based on the OLAP reporting needs.

Created calculated measures, dimension members using MDX, mathematical formulas and user Defined functions, named calculations using SSAS for generation of cubes.

Implemented various notifications based upon the scheduling jobs, database monitoring,

Disaster recovery plans and wrote windows scripting scripts for automation of the tasks.

Developed reports by using SSRS and deployed them on web pages.

Administered interface to organize reports and data sources, schedule report execution and

Delivery, and track reporting history using SSRS.

Evaluated database performance and performed maintenance duties such as tuning, backup, restoration.

Responsible for creating parameterized, cascading, configuration, drill down, rollup reports using SSRS and deploying them into server using report builder.

Developed stored procedures, user-defined functions, triggers, indexes, cursors and views In SQL Server, DB2 databases.

Developed processes, automation of maintenance jobs, tuning SQL Server, data validations, locks and indexes configurations.

Tuned several slow running queries in Production. Implemented Indexes and re-indexed to

Achieve time performance.

Extensive Experience in Migrating Database from SQL Server 2005 to 2008 and 2005 to 2002.

Administered SQL Server security, SQL Server automatic e-mail notification and SQL Server

Backup strategy and automation.

ENVIRONMENT: Microsoft SQL Server 2000/2005/2008 Enterprise Edition, MS Access, ETL Packages(SSIS), SQL Server Analysis Services(SSAS), MDX, .Net, VB.Net, HTML, IIS, Visual Studio, Visual Source Safe.

Guaranty Bank, Austin, TX Oct 2009- May 2011

Role: SQL Server SSIS/SSRS/SSAS Developer

DESCRIPTION: Guaranty Bank and its affiliates are owned by Temple-Inland Inc., a Fortune 500 Company. Using its online banking, the clients can pay bill and transfer money easily and conveniently. The clients can also view balances, statements and transactions anytime. My Responsibilities involved in designing, implementing, managing and troubleshooting databases for Mission-critical business applications.

RESPONSIBILITIES:

Wrote complex SQL statements using joins, sub queries and correlated sub queries.

Involved in creation of data modeling techniques.

Analyzed complex queries and tune the same to optimize application and system performance.

To set up SQL Server configuration settings.

Designed and developed monthly, quarterly and yearly reports at branch and bank level.

Coordinated with DBA in creating and managing tables, indexes, triggers.

Created SSIS Packages using Derived Columns, Condition Split, Aggregate, Execute SQL Task, Data Flow Task, Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel

Spreadsheets, Text file, MS Access and CSV files to data warehouse.

Extensively used SSIS transformations such as lookup, merge, derived column, data conversion And aggregate etc.

Optimized long running Stored Procedures and Queries for effective data retrieval.

Involved in converting DTS to SSIS and development and implementation of SSIS on an Enterprise level.

Involved in database design to create star schema using Dimensional and Fact

Involved in developing Cubes in Business Intelligence Development Studio using SSAS.

Creation of tables, views, Indexes and establishing the relationships between the tables and design the star schema using SQL Server 2012.

Created SSIS packages to implement complex business logic.

Published SSIS packages and SSRS repots in testing and production

Created Jobs to execute SSIS packages, on daily, weekly and monthly time periods.

Involved in creating complex table, matrix, sub reports and chart reports using SSRS.

Mentor offshore team for any technical aspects and test offshore deliverables on both SSIS packages and SSRS reports.

Involved in requirements analysis and attended requirements review meetings.

Managed offshore team

Facilitated meetings involving Development, QA and Business Teams in resolving high priority issues.

ENVIRONMENT: SQL Server 2000/2005, T-SQL, Windows Server 2003, SQL Profiler, SQL Server

Reporting services, Visual Studio.

ECIL

July 2007- Aug2009

Hyderabad, India

Role: SQL Server Developer

DESCRIPTION: Electronics Corporation of India Limited, Government of India Enterprise was established to create strong indigenous base in Electronics. The software package ‘Materials Management System (MMS)’ is developed to suit the requirements of a general Manufacturing functions of the Indian industry especially, the government sector, taking Into consideration the different procedures and approvals in a hierarchical and step by step Process.

RESPONSIBILITIES:

Designed the database to fasten certain daily jobs

Created Table, Stored procedures and defined functions. Created SQL scripts for Tuning and scheduling.

Performed data conversions from Flat files into a normalized database structure

Developed, modified, and optimized complex stored procedures, triggers to

handle complex business rules, history data and audit analysis

Responsible for creating constraints, Indexes, and Views

Optimized the performance of queries with modification in T-SQL queries,

normalized tables, established joins and created indexes wherever necessary

Rebuilding the indexes at regular intervals for better performance

Created triggers, views, user defined functions to incorporate the flow of

business and called various stored procedures from DTS (ETL)to make the flow of

DTS effective

Performance tuning of SQL queries and stored procedures using Index Tuning Wizard

Used Database Maintenance Wizard to make necessary changes and to keep the

performance of the server at acceptable levels

Configured Server for sending automatic mails to the respective people when a DTS

process fails or succeeds

Transformed data from various data sources using OLE DB connection by creating various DTS packages

Created Crystal Reports on daily, weekly and monthly basis for manger’s review

Involved with Unit testing of the code developed on Dev and Prod environments.

Involved with the Query performance using Query plan.

ENVIRONMENT: MS SQL Server 2000, T-SQL, DTS, MS-Excel, MS-Office, Oracle8i and C.

Contact this candidate