SQL Server/SSIS/SSRS Developer

Parita Patel

Id: ******.****@*****.***

Phone:973-***-****

C2C or CTH

Professional Summary:

●Over 8+ years of professional experience in development, implementation and administration of database systems using MS-SQL Server 2012/2008R2/2008/2005/2000 for both OLTP & Data Warehousing Systems applications in Financial, Insurance, Telecommunication industries.

●Extensive knowledge in design of logical and physical data modeling using Erwin tool and consistency check using DBCC utilities.

●Adept in RDBMS concepts and constructs along with Objects creation such as Database, Table, Normalization, UDF, User Defined Data Type, Indexes, Stored Procedures, Views, Cursors and Triggers.

●Excellent understanding of full Software Development Life Cycle (SDLC), Procedures, and user defined functions, cursors, indexes and triggers using Management Studio.

●Extensive experience in Data Extraction and Transforming and Loading (ETL) using DTS package in MS SQL Server 2000 and SQL Server Integration Services (SSIS) in MS SQL Server 2008/2005 with .NET, Import/Export data, Bulk insert and BCP.

●Expert in Database Normalization, Optimization and Tuning, Backup/Restore, Data Import/Export, Troubleshooting, and Database Objects authorization.

●Strong experience in creating various reports like Drill through, Drill down and Ad-hoc according to the user requirement using SQL Server Reporting Services (SSRS). Strong knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, ETL processes, dimensional modeling and reporting tools.

●Experienced in SSAS storage and partitions, and Aggregations, calculation of queries with MDX.

●Excellent experience in creating Indexes, Indexed Views in observing Business rules and creating effective functions and appropriate Triggers.

●Expert in Database Normalization, Optimization and Tuning, Backup/Restore, Data Import/Export, Troubleshooting, and Database Objects authorization.

●Experienced in report generation using Crystal Reports, XML, and MS Access and Excel spreadsheet.

●Organized professional with excellent oral and written communication skills, excellent presentation, interpersonal skills, problem solving skills, fast learner and also adept quickly new technology with ability to take new roles in minimum time and little training.

Education:

Bachelor of Science

Technical Skills:

SQL Server 2012/2008R2/2008/2005, SQL Server Enterprise Manager, Transact-SQL (T-SQL), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), MS SQL Server Integration Services (SSIS), Data Transformation Services (DTS), SQL Server Management studio (SSMS), Business Intelligence Development Studio (BIDS) MS Access, MS Visual Studio, Microsoft Office, MS Visio 2003/2007/2010, ASP.NET, C#, VB.Net, HTML, XML, Perl, VBScript, Java Script, XSL, Oracle 11g/10g, Crystal Reports 8.5/9/10/11, Erwin Data Modeler 7.3/4.1/4.0, Experience with ASP. Net, C# and VB .Net

Professional Expereince:

Client: Chamonix, Edison. NJ

Duration: Aug 2014 to Present

Role: SQL Server/SSIS/SSRS Developer

The project is about getting data from different sources and creating and loading data into data warehouse using SSIS. Also Created Reports for business users to view call center data with advance search using cascading parameter.

Responsibilities:

●Planned, Defined and Designed data based on business requirement and provided documentation.

●Developed complex T-SQL code such as Stored Procedures, functions, triggers, Indexes and views for the application.

●Attended meetings with business analysts and business users to understand the Data warehouse design.

●Involved in designing the data model for the Data warehouse tables.

●Create process load documentation using MS Visio.

●Wrote and modified various Stored Procedures used in the application using T-SQL.

●Schedule and maintain packages by daily, weekly and monthly in SQL Server Agent.

●Involved in creating partition function and schema for the table partitioning.

●Responsible for creating SSIS packages to load the data into Type 1 and Type 2 dimension tables and applied various transformations accordingly.

●After uploading the data into dimension tables, created SSIS packages to load the data into Fact tables.

●Created the Date dim to keep the track of Start Date and End Date.

●Used script task to get the update row counts and insert row counts for the Type 2 Dimension tables.

●Wrote C-shape scripts in the script task to calculate the final update and insert row counts for the table. Used XML Configuration to make the package dynamics.

●Used SQL server table for logging of the SSIS packages and maintain the details of the run time and rows affected and update row counts and insert row counts.

●Implement Event Handlers and Error Handling in SSIS packages and notify process results to various user communities.

●Test, Clean and Standardize data meeting the business standards using Fuzzy /exact lookups using SSIS tasks.

●Convert Actuate reports to SSRS reports using SQL Server Reporting Services.

●Maintained the documentation for the all reports to keep track of users of the reports and to get sign off from them to move the developed reports to Production.

●Perform quality assurance checks and update databases to ensure data integrity.

●Performance optimization of the data warehouse by identifying and assisting in correcting EDW/BI performance bottlenecks and debug database, application or data content related issues.

●Actively participate in review meetings with Project Manager to ensure that the development of projects meet business and system requirements.

Tools & Technologies:

Microsoft SQL Server 2012, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Query Analyzer, Microsoft SharePoint, Erwin

Client: francesca’s,Houston,Texas

Duration: Jan 2013– July 2014

Role: MS SQL Server Developer/SSIS/SSRS

The aim of the project was to design and develop Enterprise Data warehouse and migrate the data from different sources into the databases using SSIS and generating customer profile reports and customer transaction reports using SSRS.

Responsibilities:

●Planned, Defined and Designed data based on business requirement and provided documentation.

●Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple homogeneous and heterogeneous information sources (CSV, FTP Server, Excel, DB2 and SQL 2008R2).

●Developed Custom Logging so user can know when a row is inserted in custom logging table by every SSIS package that executes.

●Filtered data from Transient Stage to EDW by using Complex T-SQL statements in Execute SQL Query Task and in Transformations and implemented various Constraints and Triggers for data consistency and to preserve data integrity.

●Used For-Each Loop Container, Sequence Container, Script task, Expressions, Execute SQL task, Variables, Send Mail Task, FTP Task Package Execution task to achieve business needs.

●Created SSIS packages to Extract, Transform and load data using different transformations such as Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension, Merge Join and Union all.

●Wrote and modified various Stored Procedures used in the application using T-SQL.

●Scheduled and maintain packages by daily, weekly and monthly using SQL Server Agent.

●Responsible for creating partition function and schema for the table partitioning.

●Involves in creating counter logs and trace logs using windows server 2008 for advanced performance analysis and data logging over a period of time.

●Developed complex Stored Procedures to generate various Drill-through reports, Parameterized reports, Tabular reports, Matrix reports and linked reports using SSRS.

●Created various jobs using SQL Server Agent.

●Created Documents of understandings and Remedy Tickets for Deployment process.

●Used SQL Server Profiler to trace the slow running queries and the server activity.

●Actively participated in review meetings with Project Manager to ensure that the development of projects meet business and system requirements.

Tools & Technologies:

SQL Server 2008R2, SSIS, SSRS, Report Builder, Java Script, Oracle, T-SQL, ETL, ASP.Net, C#.Net, Erwin r 7.3,.Net 4.0/4.5.,TFS 2010.

Client: Progressive Insurance,Cleavland,OH

Duration: Mar 2011 - Dec 2012

Role: MS SQL Server Developer/SSIS/SSRS

The Project is to extract data from various sources like DB2, Oracle and load into SQL Server 2008 using various transformations in SSIS. Project was to develop and load data warehouse and maintain ace of it.

Responsibilities:

●Designed data architecture, data model and Mapping Process to load data based on business requirement and provided documentation.

●Implemented Table, Views, Function, Stored Procedures and Triggers for load data and validation purpose.

●Worked with Agile Methodology tracking the product backlog and resolved the defects/Solution assigned in daily scrum.

●Created SSIS package to load data from XML Files, Excel, CSV file, Ftp server and SQL Server to SQL Server 2008 by using Derived Columns, Condition Split, Data Conversion, Ole DB Command, Term Extraction, Aggregate, Pivot Transformation, Execute SQL Task and Script Component Task.

●Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Transaction and Data Ware House.

●Converted DTS Package to SSIS package for synchronizes existing process (DTS migrations).

●Used Team Foundation Server to retain Project code during deployment process.

●Part of Code review during Production deployment and QA deployment.

●Designed SSIS Package step process to load data, validate data and Recommending task to resolve performance issue with loading data in to the Data Ware House.

●Designed Console application to generate Single .CSV and text file from Different relational Database table using SSIS and C#.

●Created Process for Error Details in Application system, Control-M Job, SQL agent Job to easily identify Issue for Support and Solution.

● Identified slow running query and optimization of stored procedures and tested applications for performance, data integrity using query optimization tools.

●Monitored and explained plan assessment, SQL scripts, stored procedures for databases.

●Designed index, statistics and optimized queries by using execution plan for performance tuning of the database.

●Created Tabular and Matrix Reports with all aggregate functions and expressions in SSRS.

●Created dashboard SSRS reports under report server projects and publishing SSRS reports to the reports server.

● Developed functional and technical documentation to assist in the design, development and/or maintenance of deliverables.

Tools & Technologies:

MS SQL Server 2008, SSIS Package, SQL BI Suite(SSMS,SSIS, SSRS,SSAS), XML, MS Excel, MS Access 2007 & Windows Server 2008, SQL Profiler, Erwin r 7.3,.Net 4.0/4.5.,TFS 2010.

Client: American Capital,Bethesda,MD

Duration: Sep 2009-Feb2011

Role: MS SQL Server/SSIS/SSRS Developer

This project is involved in building a data warehouse to analyze transactions across all the departments. Data is sourced from oracle, flat files and Access database.

Responsibilities:

●Defined and Designed data based on business requirement and provided documentation.

●Worked with Agile Methodology tracking the product backlog and resolved the defects assigned in daily scrum.

●Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse.

●Developed Validation Plans for SSIS packages for checking the functionality of each component and Code review.

●Planned and executed SSIS Package step process to load data, validate data and Recommending task to resolve performance issue with loading data in to the Data Ware House.

●Modified the existing SSIS packages, Script Component Task to meet the changes specified by the users and adding column to the newly design table and to the existing table.

●Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis using SQL Server Agent.

●Involved in creating alerts for successful or unsuccessful completion of scheduled jobs.

Job overlap alert

●Worked in setup auditing, logging environment to track the status of the events like error raise, task fail.

●Designed tool to Automatic added Derived column, Parameter and Configuration value to the package.

●Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2008.

●Generated Sub-Reports, Cross-tab, Conditional, Drill down reports, Drill through reports and Parameterized reports using SSRS 2008

●Created reports to retrieve data using function, views, cube and Stored Procedures using parameters.

●Created various database objects like stored procedures, functions, tables, views, triggers.

●Configured the report viewing security for various users at various levels using Report Manager

●Fine-tuned SQL Queries for maximum efficiency and performance using SQL Profiler and Database Engine Tuning Advisor.

●Provided documentation for all kinds SSIS packages.

●Designed and implemented Stored Procedures and Triggers (DDL & DML) for automating tasks.

Tools & Technologies:

MS SQL Server 2008, SQL BI Suite (SSMS,SSIS, SSRS), XML, MS Excel, MS Access 2007 & Windows Server 2008 Access 2003 & Windows Server 2003, SQL Profiler, Data Analyzer, Erwin r 7.3,.Net 4.0/4.5,TFS 2005/2008/2010

Client:EMC Corporation

Duration: Nov 2007 – Aug 2009

Role: MS SQL Server Developer

The project is about to create logical model as per business requirement and creating solution regarding it and create different types of reports and creating cubes.

Responsibilities:

●Gathered user requirements to develop the business logic and analyzed and designed database solutions.

●Defined Technical Design Specifications, ETL workflows and Source to Target Mapping (STTM) spreadsheets for each Vendor system interfacing with the High Point system.

●Designed, developed and deployed complex SSIS packages based on STTM conversion rules for the transformation of Pre-staging data from AS400 systems to subsequent target layers in SQL Server 2005.

●Optimized queries and tuned performance using SQL Server tools including SQL Profiler, SQL Performance Monitor and Execution Plan.

●Generated SQL Server Database objects including Tables, Views and Indexes.

●Created and modified stored procedures, triggers and queries for automating various interface tasks using T-SQL.

●Designed, deployed, and maintained of various SSRS Reports in SQL Server 2005.

●Wrote Parameterized Queries for generating Tabular reports and Sub reports using Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS 2005.

●Defined report layouts including report parameters and wrote queries for drill down reports using SSRS 2005.

●Developed complex reports using multiple data providers, user defined objects, aggregate aware objects, charts, and synchronized queries.

●Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2005.

●Created Tabular reports, Cross Tabs, Drill down, Charts, Functions and Maps.

●Customized reports by adding Filters, Calculations, Prompts, Summaries and Functions.

●Performed maintenance duties like performance tuning and optimization of queries, functions and stored procedures.

●Supports the development, implementation and daily administration of SQL Server databases, performs database design, modeling and implementation of new database structures, as required.

Tools & Technologies:

SQL Server 2005, SSIS, SSMS.

Contact this candidate