Sql Server Data
Resume:
Pradeep K. Vishal
**************@*****.***
Summary:
Over 10 years of professional experience on Design, Development and Maintenance of Database using tools of MS SQL Server 2005/2008/2012/2014 for both OLTP and OLAP Systems.
Excellent skills in MS SQL Server business intelligence tools SSIS, SSRS and SSAS.
Excellent in Data and statistical analysis.
Expertise and experience in designing and developing RDBMS, including Stored Procedures, Constraints, Joins, Keys, Indexes, Data Import/Export, Triggers, cursors, Database objects such as Tables, Schema, Indexed Views and User Defined Functions for data definition, manipulation and access.
Expert in Query Optimization and Performance Tuning using tools SQL Profiler, Index Tuning Wizard and Database Engine Tuning Advisor.
Highly proficient in migrating data from heterogeneous and legacy system to SQL Server 2008 using DTS and Microsoft SSIS 2005/2008.
Involved in Agile Sprint methodologies to do requirements gathering, analysis and planning.
Expert in development, implementation, administration and support of ETL processes for large-scale Data Warehouses using Data Transformation Services (DTS) and SSIS with MS SQL 2005/2008.
Experienced in working with different data sources like OLE-DB, flat files and Excel in SSIS. Experienced in handling change data capture, late arriving facts and complex mappings in SSIS.
Experienced in defining queries and generating drill-down report using Crystal Reports.
Strong in creating reports using Grouping and Sorting and creating Sub Reports, Cascading parameters Report, Report Snapshot, Drill-Through Reports, Parameterized Reports, and ad hoc reports using SQL Server Reporting Services 2005/2008 R 2 (SSRS).
Involved in different Environment setups and executed operations related tasks.
Used Angular JS for client while server validation through Expression Language.
Expertise in performance tuning and trouble shooting on database objects and Expert in defining and deploying Cubes using SQL Server Analysis Services (SSAS).
Lead offshore team of Developers and Software tester during the whole lifecycle of the software from development to deployment.
Outstanding oral and written communication skills. Ability to handle multiple tasks and demonstrate initiative and adaptability.
Capable of handling responsibilities independently as well as a proactive team member.
Education: Bachelor’s in Electrical engineering, Punjab, India
Skill Set :
MS SQL 2008 R2,MS SQL Server 2012/2014,MS SQL Server Management Studio, SQL Server Business Intelligence Development Studio (BIDS), SSIS(SQL Server Integration Services), SSRS(SQL Server Reporting Services), SSAS(SQL Server Analysis Services),Test Director, MS Visio 2007, ORACLE,Netezza (IBM),Talend,TFS, SharePoint,BCP,T-SQL, PL/SQL,ASP.NET, MS Excel,MS ACCESS,.rdl, Normalization, DeNormalization, VB script, XML,SVN,Crystal Report,C++, Data Transformation Services (DTS).
Bank Of America,NY 08/2016 – Present
Sr. DataBase Developer/SSIS Developer
Bank of America (BofA) is an American multinational banking and financial services corporation headquartered in Charlotte, North Carolina. It is the second largest bank holding company in the United States by assets.The main objective of this project is to support and maintain EVERST Application. EVEREST is an interactive user friendly interace which provides credit risk exposure and other information to BofA’s wholesale porfolio.
Responsibilities :
Responsible for deploying codes in lower lanes on daily or adhoc basis using HP DMA Tool.
Initiated and followed up all lower lane environment related requests i.e. creating NEXUS tickets for DB refreshes on regular basis and cooridnated DB refresh with the DBA’s on off bussiness hours.
Implemented data purging and archiving, weekly database maintenance scripts for reorg, reindex, update statistics as part of performance management and platform stability.
Responsible for manually depoying JIL Scripts, .sql scripts and Talend Jobs.
Rssponsible for extracting BACAR,Country of Risk etc. files from different SORs (System Of Records) e.g PEAKS using Hive views on Hadoop platform and make files available for various downstream systems e.g IRR using SFTP.
Optimized various database codes based on best practices to reduce batch cycle time.
Worked on the migration project from legacy system using Netezza servers to MS Sql server .
Trouble shoot automated pre-validation to capture many source data discrepancies to avoid batch delays and SLA.
Performed code reviews and testing to make sure database codes are developed as per standard, identify potential performance impacted code segments and recommend changes.
Understand the requirements, intergrate various data points by implementing automated distributed Jobs.
Work with operation’s team to impliment the autimated scheduled jobs in Auto Sys with the workflow.
Analyse and provided solution to production issues and job failures.
Environment : Netezza (IBM), MS SQL 2008 R2/MS SQL 2012,MS SQL Server Management Studio, MS Visual Studio,SSIS(SQL Server Integration Services),Talend,Hadoop,Unix,Auto Sys, HP DMA,SVN,JIRA,Oracle 11g,MS Excel,Toad for Oracle .
Vetstreet Inc/Vetstreet.com 01/2016 to 07/2016
ETL Developer/Reporting Developer
Projects Summary:
Vetstreet, Inc., is a leading software as a service (SaaS) provider of marketing solutions and health information analytics to veterinary practices and animal health product manufacturers. Vetstreet, Inc., offers integrated online and offline educational products, communication programs, and custom designed marketing solutions for veterinary professionals seeking to influence pet owner behavior in a medically appropriate and measurable way. Vetstreet's automated marketing and communications provide pet owners with highly personal, relevant, and timely communications that enhance the bond with their veterinarian and results in improved compliance and increased revenue for the practice.
Responsibilities :
Using SSIS as ETL Tool to create data warehouse getting structured and unstructured data from PMS(Practice management system) from source systems.
Created different ad hoc reports SSRS (.rdl) reports (monthly/Weekly) with excel output in pivot tables and excel with multiple sheets.
Created customize and standard Trend reports with MAT (Moving Annual Totals), YTD (Year To Date) and Monthly calculations for various Manufacturers (Elanco,Zoetis etc.)
Developed Java Script and Action Script, VB Script macros for Client Side validations.
Migrated various legacy reports from BIDS 2008 R2 to visual studio 2012 and automated them.
Compiled, analyzed and validated data; reinforce and maintain compliance with corporate standards.
Analyze raw data, drawing conclusions & developing recommendations.
Perform Data Validation to ensure the integrity of client data.
Using SQL developer created store procedure, functions which in turn consumed by SSRS reports.
Created SOP (Standard Operating procedures) for different SSRS reports and SSIS packages.
Working in Agile environment with constantly changing requirements.
Responsible for uploading SSRS reports output on to SharePoint with different versions.
Coordinating with all the other team members on daily basis with the change requirements.
Weight Watchers International, Inc. 09/2015 to 01/2016
Reporting Developer
Projects Summary:
Weight Watchers is an international leader in healthy lifestyle change. Weight watchers is transforming their half-century old company by leveraging technology and leading the way in the health and wellness arena with a new emphasis on analytics, mobility and digital solutions to help its members reach their goals.
Weight Watchers has teamed up with few insurance companies to provide free and discounted access to eligible members of the health plan. The project was to create different reports like some performance guarantees (threshold levels) related to member engagement and member weight loss that must be met by the members in order to get discount. Also as a part of project, we migrated reports (.rdl) from SSRS 2008 R2 to SSRS 2014 reporting server.
Responsibilities:
Using SSMS 2014 created stored procedures and functions to bring the data from various Dimensions and Measures in the desired format for different reporting needs.
Migrated already existing legacy reporting service from SQL Server 2008 R2 to SQL Server 2014.Migrated over 100 rdls and their subscriptions from legacy to SQL Server 2014.
Created several tables, views, temporary tables, T-SQL codes and indexes using SQL Server 2014.
Installed SQL Server 2014 and Management tools.
Responsible for collecting requirements from the business users and designing and implementing all those changes in the reports.
Responsible to communicate with QA team using, JIRA for ticketing and resolving the issues very fast.
Modify already existing SSIS packages in MS Visual Studio 2012 according to the changing requirements.
Coordinate with offshore team for the whole software lifecycle.
VIACOM INC, MANHATTAN, NY 03/2013–09/2015 ETL DEVELOPER/ DATA WAREHOUSE DEVELOPER
Viacom is a leading Media Company with an extensive portfolio of cable TV & film production assets. Its MTV Networks unit runs such cable networks as Comedy Central, Nickelodeon, and the family of MTV channels (MTV, MTV2, and VH1). Viacom also owns Black Entertainment Television, which airs programming on BET, BET Gospel, and BET Hip Hop. In the film business, Viacom operates through Paramount Pictures, which includes imprints Paramount Pictures and Paramount Vantage.
Project 1: ADAPT
The project was to develop an in-house application for Ad Sales team for Deal maintenance and Liability Management called ADAPT. I was part of MTS (Media Technology Service) Team responsible for all the transition. The main objective was to ingest data from various systems into ADAPT staging and then to the main database which is MS SQL server 2008 using SSIS. My responsibility was to bring data to staging from different data source in different format to SQL server 2008 target database. Once the data is staged I was responsible for bringing the data to data warehouse for various BI needs like reporting and analysis.
Project 2: NAVIGO
Navigo is basically a MDM (Master Data Management) tool which also provides mechanism to replace any 3rd party vendor comes in future. Currently it is replacing Gabriel with Wide Orbit (WO), both are traffic systems. Gabriel uses Oracle & WO uses MSSQL. Navigo comprises of a common platform called HUB, which handles Integration and Mapping of Reference Data (part of Deals/Traffic Systems) in order to support all downstream systems to work effectively in parallel until Gabriel sunsets. HUB being used as a central repository for all the systems in Ad Sales like PlanIT, PTS, IPM, Evolve, ADAPT, NOC & Nielson.
Responsibilities :
Designed various SSIS Packages to transfer data from various sources like Text Files, XML Files, SQL Server, Excel and Oracle to MS SQL Server 2008 using BIDS.
Created Stored Procedures and functions for high performance of packages.
Created several tables, views, T-SQL codes and indexes using SQL Server 2008 R2.
Used VB.net and C# to customize SSIS packages.
Developed web service using ASP.NET which pushes the data for vendor applications.
Worked on various SSRS reports to enhance performance in terms of execution time.
Used different types of transformations like Derived column, Lookup, SQL command, RowCount, Union all etc. to achieve the ingestion of data based on the requirements.
Migrated SSIS package from SQL Server 2008 to MS SQL server 2012 as a part of upgrades.
Worked with DBA to configure the SS Agent jobs to run the packages as a job in MS SQL server for every 15 minute, On demand and Once a day .
Used Variables and expressions in the packages to generate custom PL/SQL, TSQL code and to make package tasks dynamic.
Used SVN as versioning tool to check in and check out all the script though out the project which were used .
Lead offshore team of Developers and Software tester during the whole lifecycle of the software from development to deployment.
Experience with HP Quality center for addressing defects and patches with the QA team.
Excellent communication with the business users, QA team from Designing to the Testing in UAT.
Environment : MS SQL 2008 R2/MS SQL 2012,MS SQL Server Management Studio, SQL Server Business Intelligence Development Studio (BIDS), SSIS(SQL Server Integration Services),SharePoint Quality Center,SVN,JIRA, Source Tree,GIT, Oracle 11g,MS Excel,Toad for Oracle .
GLAXCO SMITH KLINE (GSK), King Of Prussia,PA 09/2011 –03/2013
Report Developer
GSK is a leading pharmaceuticals company focusing on research, development and makes available medicines that treat a variety of serious and chronic diseases. The main objective of the project was migration from Microsoft SMS (Software Management Server) to Symantec Client Management Suite. They have over 100,000 clients and Servers which are being managed by End Point Management team. They have cluster of server in hierarchal which in turn manages different GSK site across the World. All the data related to all the clients and server information get stored in these server. They had different users which make their decisions based on the report which I generate from database using SSRS.
Responsibilities :
Using SSRS as Reporting tool created several reports and deployed on the server for all the users to view and make decisions.
Converted various existing reports from SMS to CMS for different user with excel 2007.
Created various Cubes using BIDS and creating reports from Cubes.
Involved in Analyzing, designing, building & testing of OLAP cubes with SSAS 2008 and in adding calculations using MDX.
Used TIBCO Spotfire for data mining & visualization.
Created report through the console of Symantec Management Platform and also responsible for performance tuning of the reports if they were talking more time to execute.
Also enhanced the custom cubes and trouble shoot processing of the cubes like handling with deadlocks etc.
Created different type of reports including Cross-tab, Conditional, Drill-down, Sub reports also parameterized reports.
Developed several Ad-hoc reports and automated some of these Ad-hoc reports based upon business demand.
Environment: MS SQL Server 2008 (Query Analyzer, SQL Profiler), MS SQL Integration Services (SSIS), MS SQL Reporting Services (SSRS), MS SQL Analysis Services (SSAS),Dashboard,TIBCO spotfire, Oracle 9i, MS Excel, MS Visio 2007, Windows Server 2003.
AT&T, MIDDLETOWN, NJ 02/2011-07/2011 ETL Developer
AT&T is the largest telecommunication company in the US. It serves customers nationwide with a broad range of wireless voice and data services besides serving with wired services, including broadband (DSL), long distance and local voice services.
The company has huge database including employee, products and customer’s information. The Project was to Manage and Maintain their Database System. They wanted to manage their sales information, product’s details, survey details and to submit Reports to Higher management.
Responsibilities:
Used SSIS 2008 as ETL Tool to create a Full Fledged Data Warehouse by consolidating data from various sources like Flat Files, Excel, MS Access and SQL Databases.
Designed and developed various Service management reports, sub-reports, charts, and parameterized reports.
Performed System Study and Requirements Analysis, prepared Data Flow Diagrams, Entity Relationship Diagrams, Data Diagrams, Table Structures.
Developed web service using ASP.NET, VB.NET and C#.NET
Designed SSIS Packages in ETL Process to transfer data from various sources like Text Files, XML Files, SQL Server, Excel, OLEDB and Access to MS SQL Server 2008
Installed SQL Server 2008 and Management tools using SQL Server Setup Program.
Created SSIS Logging to enrich the Auditing purposes and to track various Log acts of the package.
Cleansed bad data from legacy system using Derived column, Lookups, Fuzzy Lookups, Conditional split.
Used slowly changing dimensions methodologies to maintain the history of the data using SSAS.
Involved in Designing and deploying cubes in SSAS environment using Snowflake and Star Schema Designs for the operational data.
Created trace in SQL Profiler and used Data base engine tuning advisor for Performance tuning on stored procedures and Scripts.
Created different reports (Tabular Reports, Matrix Reports, Pie-Charts & Bar Diagrams) based on the requirements for survey information and product details.
Worked with business users, analysts and QA team members in design, development and test the report .
Environment: MS SQL Server 2008 (Query Analyzer, SQL Profiler), MS SQL Integration Services (SSIS), MS SQL Reporting Services (SSRS), MS SQL Analysis Services (SSAS),Dashboard, Oracle 9i, MS Excel, MS Visio 2007, Windows Server 2003.
First Care, MD 08/2009 –01/2011
MS SQL Server BI Developer
First Care is a health insurance company, which provides prepaid medical, hospital, and related comprehensive health care services to HMO subscribers and their enrolled dependents.
The key goals of this project was to redesign the existing ETL, Reporting application to get claims information for its policy holders. Project provided summarized reports to the Business Users about most visited facilities along with procedures performed to re-negotiate coverage details.
Responsibilities:
Exhaustive 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 2005, Import/Export data, Bulk insert and BCP.
Developed Triggers, Stored Procedures and Functions for the custom database objects using SQL Server 2008.
Responsible for optimizing all indexes, SQL queries, store procedures to improve the quality of software.
Created Stored Procedures and functions, and experienced in writing high performance code.
Created physical and logical structure of the new data warehouse (SQL database) and process work flow by using MS Visio 2007.
Migrated already existing legacy reporting service from SQL Server 2005 to SQL Server 2008.
Created SSIS Packages using Pivot Transformation, Fuzzy Lookup and Derived Columns, to export cleansed data from SQL Server 2008, Oracle, Excel Spreadsheets, Text files and CSV files to data warehouse.
Created configuration files in order to deploy packages in different environments.
Created VB.NET scripts in the Script component of SSIS to create and load data dynamically from tables .
Successfully managed Extraction, Transformation and Loading (ETL) process by pulling large volume of data from various data sources using BCP in staging database from MS Access, MS Excel.
Created various ETL Packages to load data from transactional system DB2 to staging (ODS) and staging to Enterprise Data-warehouse.
Used Sequence Container, Execute SQL Task, Send Mail Task, Precedence Constraint, Script Task to achieve business requirement in the control flow.
Environment: MS SQL Server 2005/2008, MS SQL Server Reporting service 2005/2008, Sharepoint, MS SQL Server Analysis Service 2005/2008,MS Access, MS Excel,MS Visio 2007, and T-SQL.
Wells Fargo Bank, Sacramento, California 03/2008 – 07/2009
MS SQL Server SSIS/SSAS Developer
Wells Fargo provides a broad range of asset management, wealth management, mortgage services and loans, besides providing retail, commercial and corporate banking services through banking offices and over the Internet.
The key goal of the project was the migration of databases from SQL Server 2005 to SQL 2008 server to fulfill requirements for Reporting .
Responsibilities:
Developed, implemented and maintained various database objects such as Stored Procedures, Triggers, Functions, Cursors, Indexes and Views.
Designed both logical and physical data models in Erwin r7.2.
Involved in Planning, Defining and Designing data based on business requirements and provided documentation.
Created and Managed configuration files for package migration from SQL Server 2005 to SQL Server 2008.
Troubleshoot ODBC driver issues used for migration of data from the Top Speed database to SQL server 2008 .
Used SSIS and T-SQL stored 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 were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
Experience in creating Jobs, SQL Mail Agent, and schedule SSIS Packages.
Identified the database tables for defining queries to generate reports for analysis of data using SQL Server Reporting Services in Report Builder.
Responsible for creating reports based on the requirements using SSRS 2008 and scheduled them to run automatically on a monthly/weekly/daily basis.
Responsible for Weekly Full/Differential backups and restoration, partial server maintenance, SQL Server maintenance /service pack updates.
Implemented Star Schema for OLAP cubes using SSAS.
Environment: MS SQL Server Management Studio, SQL Server Business Intelligence Development Studio (BIDS), T-SQL, MS SQL SERVER 2008/2005/2000, Import/Export Data, Bulk Insert MS ACCESS, Data Transformation Services (DTS), ), SSIS(SQL Server Integration Services), SSRS(SQL Server Reporting Services), SSAS(SQL Server Analysis Services), Crystal Reports, XML, ERWIN, MS VISIO.
Hewlett-Packard, Houston, TX 07/2005 – 02/2008
MS SQL Server SSIS Developer
Hewlett-Packard is an information technology company specializes in building personal computers, notebook computers, Servers, Printers and Software.
An existing data mart provides Software Global Business Unit data and reports of HP supports engineer’s performance and HP Customers survey results. However with the purchase of Mercury, Mercury engineers performance and Mercury Customer surveys were also of an interest to Software Global Business Unit.
Responsibilities:
Performed gathering & analyzing of requirements including design & development of Technical documentation.
Created User Defined Functions, Triggers, Indexes.
Identified data sources, provided data flow diagrams and documented the process.
Designed, developed and tested complex SSIS packages as per the business requirements mapping document.
Built SSAS packages for processing fact and dimension tables with complex transforms, type 1 and type 2 changes.
Extensively used most of the Control and Data Flow tasks, created XML configuration files to enable portability of packages.
Enabled check point restart ability feature in SSIS packages, Created DOS Scripts to execute SSIS packages.
Conducted performance tuning T-SQL code and SSIS packages, reviewed existing packages
Created new tables, views, indexes, functions and Stored Procedures.
Deployed Packages using file system method on a 64-bit application server.
Environment: MS SQL Server 2000/2005,, SSIS(SQL Server Integration Services), SSAS(SQL Server Analysis Services)T-SQL, Windows 2000, MS Project.
Contact this candidate