Vivek P

Mobile: 408-***-****

E-mail: acydd6@r.postjobfree.com

Summary:

Over 8 years of experience in IT industry as a SQL Server Developer with specialized skills in SSIS, SSAS and SSRS.

Extensive experience in BI Solutions (ETL & Reporting) using SSIS, SSAS, SSRS and T-SQL Programming using DDL, DML, DCL commands for various business applications and Worked with ProClarity Analytics server.

Experience in Mapping Server/parallel Jobs in Data Stage to populate tables in Data warehouse.

Expert at developing ETL interfaces using SSIS, Data marts/cubes using SSAS and enterprise reports using SSRS utilizing latest versions (2005/2008) & features.

Data modeling experience focusing on high-activity, normalized transaction systems (OLTP), highly-usable de normalized reporting systems (OLAP) as well as staging areas and data marts.

Good experience and understanding of database design, relational integrity constraints, OLAP, OLTP and Normalizations.

Experience with self-service BI tools, Designing and Developing Dashboards using Tableau.

Create visuals quickly and switch between types easily to find the model that best represents the message using Tableau.

Extensively worked in OLTP and OLAP environment that includes Production (24x7), QA and development databases in SQL Server.

Excellent understanding of Relational Database Systems, Normalization, logical and physical data modeling for OLTP and dimensional modeling for OLAP.

Worked on ProClarity to create OLAP data sets and queries are created directly from the unified dimensional model.

Involved in writing complex Stored Procedures, Functions, Views, Triggers, and Cursors for various business applications.

Having strong and working knowledge on Cogno’s Connection, used Cogno’s Scheduler to schedule the Reports.

Experience in using XMLA protocol for SQL Server Analysis Services 2005 for interaction between client application and instance of Analysis Services.

Experience in Error handling and debugging coding issues and troubleshoot production problems.

Extensive Experience in RDBMS concepts such as Tables, User Defined Data Types, Indexes, Indexed Views, Functions, CTE’s, Table Variables and Stored Procedures.

Experience in SQL Optimizing by using SQL Profiler, Index Tuning Wizard, Database Tuning Advisor, DBCC Commands, DMV’s, DMFs and Query Execution Plans.

Expert in Extracting and Transforming data (ETL) from various heterogeneous sources and creating packages using SSIS/DTS, Import, Export Data, Bulk Insert and BCP utilities.

Hands on experience with performing various SSIS data transformation tasks like Look-ups, Fuzzy Look-

ups, Conditional Splits and Event Handlers, Error Handlers etc.

Great Expertise in creating and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages.

Experience in conversion of packages from legacy systems (DTS SSIS) and migrating, deploying the packages across Dev/UAT/Prod environments.

Expert in automating process by creating jobs and error reporting using Alerts, SQL Mail Agent, FTP and SMTP.

Created various SSRS Reports involving variety of features like Reports, Charts, Filters, Sub-Reports, Drill Down, Drill-Through, Multi-valued parameters etc.

Experience in Error handling and debugging coding issues and troubleshoot production problems.

Worked with end users/customers to understand business requirements, recommended technical solutions and documented functional requirements.

Ability to work on multiple tasks in a fast paced environment independently and in a team, mentor to other team members to c follows same techniques and standards.

Excellent analytical/Communication Skills, Team Play and very much result Oriented.

Technical Skills:

Operating systems

Windows 98/NT/2000/XP/Vista/Windows7/8

Databases

MS SQL Server 2000/2005/2008/2012, MS Access

Database Tools

SQL Enterprise Manager, SQL Profiler, DTS Import/Export, SQL Client Configuration utility, Backup Server, Replication Server, OLAP Services, SQL Server Management Studio, SQL Server Business Intelligence Development Studio (BIDS)

ETL Tools

DTS, SQL Server Integration Services, SQL Server Analysis

Reporting Tools

SSRS, Crystal Reports, Cogno’s, Micro Strategy

Development Skills

Transact SQL (T-SQL), PL/SQL

Languages

C, C++, HTML, XML, VB.Net, Asp.Net(C#)

Application Packages

Microsoft Office Suite

Education: Bachelor of Technology in Computer Science from JNTU University.

PROFESSIONAL EXPERIENCE:

Weltman, Weinberg & Reis (WWR), Cleveland, Ohio Aug2012 to till date

Role: SQL/ETL/SSIS/SSRS Developer Domain: Financial

WWR has Full service bankruptcy, consumer and commercial collection, compliance, litigation and real estate default services. It has experienced representation in retail, real estate default, commercial and collection matters involving bankruptcy, foreclosure, evictions, probate recovery, compliance & defense litigation, collection recovery, collection litigation & post-judgment executions, complex collections & litigation, contract review, insurance subrogation, and corporate & financial services

Roles and Responsibilities:

Responsible for creation and maintenance of tables, indexes, stored procedures, triggers, and UDF’s

Debugging of stored procedures, Indexes, Triggers, Views, User Defined Functions and Cursors

Tuned Poor performing SQL Queries with SQL Profiler Trace and Query Analyzer

Conversion / Migration of SQL Server 2005 to SQL Server 2008

Formulated and documented ETL process design based on business requirements and system specifications including source to target mappings, data dictionaries and transformations.

Responsible for the Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse.

Used DTS/SSIS for ETL processes, SSRS for Reporting needs and SSAS for Analytics reporting including SharePoint integration

Used various script tasks, look up transformations, control flow tasks like FTP, bulk insert task, transfer job task etc. and different data flow tasks using T- SQL and Visual Basic (VB) scripts

Extensively used stages available to redesign Data Stage jobs for performing the required integration.

Created and scheduled SSIS packages to pull data from SQL Server database and export the data to various data sources like excel spreadsheets, flat file etc. and vice versa

Created SSIS Packages using the concepts of incremental loading and slowly changing dimensions

Worked on performance tuning of SSIS packages using error handling, event handling, re-running of failed SSIS packages using checkpoints.

Implemented free text parser for FTP and web data feed in C# .Net

Generated Custom ETL scripts using SSIS 2005 and unit test SSIS load processes for performance check.

Designed OLAP cubes with star schema and multiple partitions using SSAS.

Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.

Involved in writing MDX queries and performance optimization of the SSAS cubes for calculated members and measure groups.

Used the ETL Data Stage Director to schedule and running the jobs, testing and debugging its components & monitoring performance statistics.

Involved in migration and conversion of Reports from SSRS 2005 to 2008

Created Parameterized, Cross-Tab, Drill Down & Drill Through reports by using SSRS 2005/2008

Created report models for the ad-hoc reporting of the end users using Report Builder

Deployed SSRS reports in share point for web based access for multiple end users

Documented all the migration process documents for future reference

Designed XML stages for reading XML log files for capturing data stage jobs audit data.

Involved in complete Software Development Life Cycle (SDLC), which includes requirement gathering, analysis, design, development, and Implementation

Successfully tested all task in staging and stored all versions of data using team foundation server (TFS).

Responsible for developing processes, automation of maintenance jobs, tuning SQL Server, locks and index configurations, administering SQL Server security, SQL Server automatic e-mail notification and SQL Server backup strategy and automation.

Environment: SQL Server 2005/2008/2012 Enterprise Edition, .Net 3.5,SQL BI Suite (SSAS, SSIS, SSRS),OLTP, OLAP, Enterprise manager, PPS, XML, MS PowerPoint, MS Project, MS Access 2003 & Windows Server 2003, Oracle, Crystal Reports, Cogon's, Business Objects,SharePoint, MOSS 2007,

Ironside, Lexington, MA Jan 2011 to July 2012

Role: SQL/SSAS/SSIS/SSRS Developer Domain: Finance

Ironside is a leading innovator in the rapidly evolving world of business analytics; help organizations ranging from Fortune 500 members to startups solve core business challenges through best-of-breed analytics technology. To meet the diverse needs of the clients, it specialize in all facets of business analytics, including business intelligence, performance management, predictive analytics, information management, big data, and more.

Responsibilities:

Created and managed stored procedures, indexed views, user defined functions, triggers, database constraints to meet business requirements and policies.

Project involved maintenance of existing OLTP databases as well as designing SSIS packages for custom warehousing needs.

Involved in the data analysis and database modeling of both OLTP and OLAP environment.

Involved in extracting the data using SSIS from OLTP to OLAP.

Used ProClarity for accessing and analyzing cubes and dimensions, and also worked on integration of sharepoint with SSRS.

Created highly complex SSIS packages using various Data transformations like conditional splitting, Fuzzy Lookup, For Each Loop, Multi Cast, column conversion, Fuzzy Grouping, Script Components, error handling.

Generated Custom ETL scripts using SSIS 2005 and unit test SSIS load processes for performance check.

Created various complex reports and manage those using SQL Server Reporting Services (SSRS 2008/2005) according to ERLC.

Involved in migration and Conversion of Reports from SSRS 2005 to 2008.

Created Tabular reports, Matrix reports, List & Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment.

Highly involved in creating, structuring, formatting using Report Designer and Report Builder.

Wrote and integrated stored procedures to generate the special reports according to client’s need.

Worked on various complex requirements of developing monitoring dashboards with multiple KPIs in Performance Point Monitoring Server 2007, Share point.

Environment:

SQL Server 2005/2008, BIDS 2005, Reporting services 2005, Integration Services 2005, Analysis Services 2005, Windows Server 2003, Infomatica, HealthCare database, Oracle 9i, 10g, DB2, TFS,

Broadridge Financial Solutions, Jersey city, NJ May 2008 to Dec 2010

Role: SQL/ETL/SSIS/SSRS Developer Domain: Finance

Broadridge is the leading provider of investor communications and technology-driven solutions for wealth management, asset management and capital markets firms, help clients drive operational excellence to manage risk, accelerate growth and deliver real business value. Broadridge provides transparency into the distribution of over 90% of mutual fund and ETF assets.

Responsibilities:

Created SSIS packages to clean and load data to data warehouse and package to transfer data between OLTP and OLAP databases.

Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, 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 ware house.

Extracted data from XML to SQL server.

Created SSIS packages for data Importing, Cleansing, and Parsing etc. Extracted, cleaned and validated.

Created complex queries to automate data profiling process needed to define the structure of the pre staging and staging area.

Scheduled Cube Processing from Staging Database Tables using SQL Server Agent.

Generated reports using SQL Server Reporting Services 2005/2008 from OLTP and OLAP data sources.

Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports.

Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.

Created several materialized views and UDF’s to be accessed by the new front end applications.

Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases

Optimized the performance of various SQL scripts, stored procedures and triggers by using embedded UDFs, CTEs and System stored procedures.

Successfully tested all task in staging and stored all versions of data using team foundation server (TFS).

Environment: SQL Server 2005/2008 Enterprise Edition, .Net 3.5,SQL BI Suite (SSAS, SSIS, SSRS), Enterprise manager, PPS, XML, MS PowerPoint, MS Project, MS Access 2003 & Windows Server 2003, Oracle, Share Point, MOSS 2007, OLTP, OLAP,

Bajaj Auto Ltd, Pune, India May 2006 to Apr 2008

Role: SQL Server DBA/Developer

The Bajaj Group is amongst the top 10 business houses in India. Its footprint stretches over a wide range of industries, spanning automobiles (two-wheelers and three-wheelers), home appliances, lighting, iron and steel, insurance, travel and finance.

Responsibilities:

Wrote complex queries, stored procedures, UDFs in support of the ETL processes, front end applications and reports.

Designed staging database as intermediate stage for population recovery Data Mart to perform various ETL data massaging operations such as data profiling, data cleansing and data verification.

Created ETL process using SSIS for populating data store in SQL Server.

Successfully transferred old data from various sources like flat files, MS Access, and Excel into MS SQL Server 2008R2 using SSIS.

Filtered bad data from legacy system using Derived column, lookup, Fuzzy Lookup, Fuzzy Grouping and Conditional Split.

Performed various transformations like conditional split, sorting and included data about the environment using the audit transformation.

Created Complex SSIS Packages implementing Master-child packages with properties like package configurations, SSIS loggings as well as custom loggings (using Event handlers).

Involved in implementing proper package configuration features and finally securing the packages by using password and encryption methods.

Implemented transactions in SSIS by appropriately setting Transaction Option property to Supported, Not-Supported and required based on the type of strategy being implemented.

Enabled Checkpoints on already implemented transactions to optimize entire ETL strategy so as to start the package execution from latest point of failure.

Created the design documents for the entire project including table structures and design logic of stored procedures, packages and Reports.

Developed data access queries/programs using SQL Query to run in production on a regular basis and assists end users with development of complex Ad Hoc queries.

Involved in designing of shift based reports, chart reports (line and column), parameterized reports for performance analysis.

Set up report delivery schedules and report back up schedules by configuring subscriptions and snap shot respectively.

Environment: SQL Server 2000 Enterprise Edition, T-SQL, Enterprise manager, VBS, MS Office & Windows 2K platform.

Contact this candidate