Sql Server Data
Resume:
PARESH PATIL
*****.*****@*****.***
Professional Summary:
●Over 7 years of professional experience in development, implementation and administration of database systems using MS-SQL Server 2014/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
●Worked on Excel 2010, Power Pivot for providing ad-hoc reporting for the clients..
●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:
Master of Engineering
Technical Skills:
SQL Server 2014/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 Report 8.5/9/10/11, Erwin Data Modeler 7.3/4.1/4.0, Experience with ASP. Net, C# and VB .Net
Professional Expereince:
Citibank, Dallas TX August2014 – Present
MS SQL Server/SSIS/SSRS Developer
Citi Bank is one of the largest Finance group. Citi Bank provides the Banking services like Finance, Savings, Checkings, Investment, loans to the customers.
The main objective of the project was to improve performance and collect data from various database sources to perform analysis and then integrate them with the existing systems and creating reports in SSRS.
Responsibilities:
●Involved in Planning, Defining and Designing data based on business requirements and provide documentation.
●Optimized Indexes, Views, Store Procedures and Functions using T-SQL.
●Used SSIS jobs for importing data from the flat files that brings the data to the application tables.
●Monitored and killed processes that create deadlocks within the database.
●Wrote complex Stored Procedure, Queries, Triggers, Functions, Indexes, User-defined functions and Cursors for the application.
●Used SSIS and T-SQL store procedures to transfer data from OLTP databases to staging area and finally transfer into data warehouse.
●Used various SSIS tasks such as Conditional Split, Derived Column, lookup which are used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
●Developed and deploy data transfers packages to the appropriate destinations using SSIS.
●Experienced in SQL Agent to create Jobs, Alerts, SQL Mail, and schedule SSIS Packages.
●Created SQL server configurations for SSIS packages.
●Used SSIS transformations to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
●Responsible for creating reports based on the requirements using SSRS 2014.
●Defined the report layout and identified Datasets for the report generation.
●Created different type of reports including matrix, Conditional, Drill-down, Sub reports also parameterized reports.
●Generated reports on wealth information, account information, research reports using ad-hoc reporting to be used by the clients and advisors.
●Designed and create report templates, bar graphs and pie charts based on the financial data.
●Developed implement and maintain various database objects such as Stored Procedures, Triggers, Functions, Indexes and Views.
●Developed and implement procedures to ensure the quality, usability and accuracy of reports.
●Created Packages to group logically related column types and to transfer data.
●Designed both logical and physical data models in Erwin.
Tools & Technologies:
SQL Server 2014/2012/2008R2/2008, Server Integration Services 2008, SQL server Reporting Service 2008, Microsoft Visual Studio, SQL Server Management Studio, MS Excel, T-SQL,ERWIN 7.2, C#
Cablevision New York, NY May 2013 - Aug 2014
SQL Server/SSIS/SSRS/ETL Developer
Cable vision is one of the largest Digital Media Company. Cablevision today offers television, phone and Internet services to millions of households and businesses in the New York and nearby metropolitan area
The project goal was extracting, transforming, and loading data from different sources into new SQL server 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.
●Increased system performance and query optimization By creating and rebuilding appropriate indexes.
●Had used Sql Profiler As well As Database Engine tuning Advisor for troubleshooting Performance related issues.
●Also Used Execution plan For slow running query.
●Used other query Optimizing techniques like such as avoiding needless joins, groupings, and scalar user defined functions.
●Wrote and modified various Stored Procedures used in the application using T-SQL.
●Scheduled 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.
●Involved in Performance tuning of SSIS By using Max Concurrent Executables property And By Avoiding Asynchronous transformation.
●Have also worked on MaxBuffer Size And Fast Load option.
●Wrote C# 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.
●Implemented Event Handlers and Error Handling in SSIS packages and notify process results to various user communities.
●Tested, Cleaned and Standardize data meeting the business standards using Fuzzy /exact lookups using SSIS tasks.
●Have done performance tuning of SSRS.
●Eliminated unused calculation from the report will boost your query optimization and reduce the time required to generate the report.
●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.
●Performed quality assurance checks and update databases to ensure data integrity.
●Actively participated 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
ALLY Financial, Detroit MI March 2012 - May 2013
MS SQL Server Developer
The ALLY financial bank has more than 15 million customers worldwide and provides a range of financial services including auto financing, corporate financing, insurance, mortgage services, and online banking
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:
●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.
Or 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 2012/2008R2, 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
Horizon BlueCross BlueShield, Newark NJ Oct 2011 - March 2012
MS SQL Server Developer/SSAS/SSIS/SSRS Developer
Horizon Blue Cross Blue Shield of New Jersey, headquartered in Newark, New Jersey is the only licensed Blue Cross and Blue Shield Association plan in New Jersey, providing health insurance coverage to over 3.2 million people throughout all of North, Central, and South Jersey.
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 2008R2 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 team 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 2008R2, 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.
Unisys Global Technologies Dec 2008 - Sept 2011
Jr. SQL Server Developer
Unisys Global Technologies is a leading privately traded engineering, procurement, construction, maintenance and project management company. Unisys Global Technologies is combining global strength with local focus for clients in India to provide businesses with world class remote and on-site IT management and related services. The project is about to create logical model as per business requirement and creating solutions 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.
●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 2008.
●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.
Tools & Technologies:
SQL Server 2008, SQL Server 2005, SSRS, SSMS.
Contact this candidate