Sql Server Data

Vikas Jhanjhari

813-***-**** v acz6b3@r.postjobfree.com San Jose - SFO Bay Area, CA

https://in.linkedin.com/in/vikasjh

PROFESSIONAL SUMMARY:

● 13 years of professional IT experience in analysis, design, development and testing of Client/Server, Webform, Single Page Applications with Object Oriented Designs, SOA, SaaS and Multi- tenant architecture

● 8+ years of IT Experience in Database Design, Development and business intelligence of Microsoft SQL Server 2005,2008, 2012 & 2014 in Development, Test, and Production Environments with various business domains like healthcare, financial, pharmaceutical and manufacturing.

● Hands on experience in developing web applications in C# .NET 3.0, 3.5, 4.0, ASP .NET, MVC .NET ADO.NET, ADO.Net Entity Framework, LINQ, WCF using in M icrosoft Visual Studio .NET IDE

● Exposure to SCRUM and Agile based development

● Good leadership experience in both onshore and offshore

● Expertise in writing, testing and optimizing T -SQL Queries, Dynamic-queries, subqueries, and complex joins for generating C omplex Stored Procedures, Triggers, User-defined Functions, Views, and Cursors.

● Hands on experience in performance optimization techniques by analyzing Q uery Execution Plans

● Experience in using recursive CTEs, CTE, temporary tables and effective DDL/DML Triggers to facilitate efficient data manipulation and data consistency as well as to support the existing applications.

● Experience in i mporting/exporting d ata between different sources like Oracle/Access/Excel etc. using SSIS/DTS utility.

● Experience in Extracting, Transforming and Loading ( ETL) data from E xcel, Flat file, Oracle to MS SQL Server by using B CP utility, D TS and S SIS services.

● Experience in ETL processes involving migrations and coordinated processes between multiple databases. Hands on data synchronization exposure using third party tools like RedGate synch.

● Experience in creating SSIS packages using A ctive X scripts and with Error Handling.

● Experience in managing and automating control flow, data flow, events and logging programmatically using Microsoft C #.NET framework for SSIS packages.

● Skilled in error and event handling: precedence Constraints, Break Points, Check points and Logging.

● Experience in creating configuration files to deploy the SSIS packages across all environments.

● Expertise in enhancing and d eploying the SSIS Packages from development server to production server.

● Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), and SQL Server Integration Services (SSIS) (2005/2008).

● Exposure in a nalyzing, designing, developing, installing, configuring, and deploying MS SQL Server suite of products with Business Intelligence in SQL Server Integration Services.

● Experience in maintaining one to many and many to one relationships while moving data between two databases.

● Monitored and Tuned MS SQL Server databases with tools like I ndex Tuning Wizard, S QL Profiler, and Windows Performance Monitor for optimal Performance.

● Hands on experience on all phases of Software Development Life Cycle (S DLC) of Data warehousing, including requirement gathering from business users, analysis, design, creation of mapping documents, specification writing, development, testing, and implementation.

● Ability to handle M ultiple tasks, I nitiative and A daptable. S elf-motivated, organized team player with strong problem solving and analytical skills and total commitment to the organization goals.

● Good ability to quickly grasp and master new concepts and technologies TECHNICAL SKILLS:

RDBMS SQL Server 2014/2012/2008R2/2005, SQL, PL/SQL, MS Access, MySQL

Database Tools SQL Query Analyzer, SQL Enterprise Manager, Management Studio, SQL Server 2005, Query Editor, Reporting Server, SQL Server Agent, MySQL Workbench

ETL Tools Data Transformation Services (DTS), MS SQL Server Integration Services (SSIS).

Reporting tools Izenda BI tool, SSRS, Qlikview, Crystal Reports Data Modeling MS Visio 5.0

BI Tools MS SQL Business Intelligence, Business Objects Programming

Language

C#.NET with ASP.NET, MVC.NET, VB.NET, Classic ASP, VB6 Microsoft .NET .Net Framework 4.0/3.5/ 3.0/2.0/1.x, Web Forms, Win Forms, ASP.Net, MVC

ADO.Net, 4.0/3.5/3.0/2.0, Web Services, WCF Services, Web API LINQ, Entity Framework

Web Development HTML, CSS, XML, XSLT, SOAP, Javascript, JQuery, Ajax, Angular JS Third party tools

/libraries/APIs

Telerik Rad controls, Fusioncharts, redgate data synchronization APIs and database monitoring tools, OpenXML components, Drawloop APIs, Amazon AWS SES services, Salesforce SOAP API Web Development

Tools

Visual studio 2013/2012/2010

Web Servers IIS 7.5/7.0/6.0

Version control TFS, VSS, SVN, CVS, GIT

Operating System Windows 2010/2012 server, Win 7

Domain Professional Employer Organization (PEO), Pharmaceuticals and Healthcare, Healthcare law compliances, E-Commerce, Automotive aftermarket, online legal education, Market research & analysis, Multi-level marketing, Inventory & accounting, Supply chain Procurements

PROFESSIONAL EXPERIENCE:

Client : Google Inc., Mountain view CA

Role : MySQL database developer

Project : RACS - Supply Chain Procurement System (Feb 2017 – till date) Work location : Mountain view, CA

Description:

The project is developed to support the procurement functions of supply chain management team of one of the top most organization. This Mac OSx based client server application supports the cost, allocation and projection needs of hardware parts for the procurement. The projections are based on various data inputs sourced from multiple sources like - ERP systems, Spreadsheet uploads, and manual entries. This is a data intensive application where most of the business logic is places in the data layer and stored procedures.

Responsibilities:

● Database development in MySQL using Workbench 6.2 client

● Develop Data layer for the application

● Write data load scripts to pull the data from multiple data sources like SQL Server database, spreadsheets uploaded on a SFTP etc.

● Develop stored procedure to support database operations of application and generate various complex reports

● Write data validation scripts for data integrity and quality check

● Code reviews

Environment: MySQL, SQL Server, Python, Objective C, Mac OSx Client : Polaris Management, NYC

Role : SQL database developer with web dev.

Project : Izenda reporting customization and integration (May 2016 – Feb. 2017) Work location : East Brunswick NJ

Description:

The project needed to generate the data from multiple data sources so that it can be used to create views. These views were used in the reports to generate the customized BI reports Izenda Reporting is a business intelligence platform built for ISVs, solutions providers, and enterprise users. This embedded software solution gives users the ability to analyze data in real-time, providing self-service BI to organizations.

Responsibilities:

● Designed database architecture to enable data fetching frommultiple data source connections in a multi-tenant environment

● Worked as a sole developer for the customization of MVC.NET Razor based application

● Created Data layer to be used in web forms and web components in ASP.NET, C#.NET for the integration

● Involved in R&D and POC creation for the feasibility check of the BI tools

● Created feasibility analysis reports matching them with the product requirements

● Developed various complex stored procedures, functions to fetch data from different source systems

● Partially used Angular JS framework for code behind / server side code

● Responsible for code review and design documents

● Client interaction that included verbal and written communication, status updates and progress reporting

Environment: MS SQL Server 2012, SSIS, C#.NET, ASP.NET Web forms, MVC.NET Client : CoAdvantage Inc. Tampa, FL

Role : SQL database developer

Project : Datamart design and reporting (Feb - April 2016) Work location : Tampa, FL

Description:

The project involves creating various data marts sourced from different data warehouses with an objective of improved efficiency in generating standard report and providing true visibility to the management. These data marts enabled client to generate the intuitive business metrics. The design includes data extraction from multiple data sources using SSIS ETL Packages in de-normalized format. Responsibilities:

● Involved in presales activities which includes effort estimation, creating WBS, project plan and BRS document

● Analyzed existing payroll system, assisted the data architect with datamart schema design in Star flex schema

● Developed various complex stored procedures, functions to fetch data from different source systems

● Developed SSIS packages to load data from different sources to data warehouse database on an incremental basis

● Designed packages using Control Flow Tasks like foreach loop container, sequential container, execute SQL task and data flow task and transformations like data conversion, derived columns, lookup, conditional split, aggregate, union all, merge join and multi cast transformations

● Created event handlers for the packages using event handler for error handling based on client requirement

● Maintained logging information in SQL table for tracking errors and recording package execution status

● Worked on Qlikview to analyze the payroll datamart

● Assisted team to work on SSIS & SSRS

● Responsible for code review and design documents

● Client interaction that includes verbal and written communication

● Providing day to day support and maintenance for the datamart application Environment: SQL Server 2012, SSIS, SSRS

Client : Borderless Access Systems, Redmond, WA

Role : Data Architect/Tech lead

Project : Panel Management System (Sep 2012 – Jan 2016) Description:

Panel Management System is a suite of web portal, web application, desktop application, web services, console application and mobile app. It helps in all stages of panel management - recruitment, engagement, sampling, and incentive management - for any panel size. Designed to support any number of languages, currently works in 12 different languages for 14 countries. Optimized to support large data volume and thousands of parallel hits. Current accessibility 200K+ daily hits, 1 Million+ records processing every day and 100K+ email send outs per day. Responsibilities:

● Helped with pre-sales by analyzing RFP, understanding the proposed system, providing effort estimations and providing technical write up for the sales proposals

● Helped in creating functional requirement specifications document by detailing down the system level requirements, creating wireframes and providing functional insights to the team

● Designed database to support high data volume and with high system availability

● Created data migration strategies to enable the seamless system upgrade

● Developed Data migration scripts considering the high volume data movement from the legacy system to the new system

● Designed multi-tiered system architecture and created detailed design specifications document

● Implemented Indexing and Security Management

● Used skin and themes for the design of web pages

● Programmed Data Access Layer using ADO.NET which involved in accessing data from the Database using connected architecture which requires the strong OOPS concepts

● Used WCF and .NET web services to communicate between DAL and other business components.

● Used .NET localization to enable multi-lingual support

● Used APIs for sending SMS through application, Geo tracking, send bulk emails etc.

● Worked on integration with Facebook, LinkedIn, Gmail to retrieve contacts info, friends list.

● Involved in writing complex queries using T-SQL programming. Created stored procedures, user defined functions and views in SQL server.

● Utilized ADO.NET technology extensively for data retrieving, querying, storage and manipulation

● Usage of EDMX, LINQ to SQL for invoking database objects like stored procedures, functions.

● Implemented code behind in C#.NET

● Used caching, CSS compression and other best practices to improve the page load time of the application

● Created deployment packages and hosted application on IIS 7.5

● Created SOPs for the release and deployment procedures

● Responsible for day to maintenance and support of the application

● Involved in code reviews and code refactoring

Environment: SQL Server 2012, C# .NET 4.0, ASP.Net, WCF Web service, WPF win forms, Windows services, Telerik controls, XML, XSL, ADO.NET, Javascript, JQuery Client : ALM Media LLC, NYC

Role : .NET web and database developer

Project : E-Commerce web application (Oct 2011 – Aug 2012) Description:

This e-commerce web portal is the premier provider of online Continuing Legal Education programs that can be completed for MCLE credit in more than 40 states in the USA. The portal involves listing of various product offerings, cataloging, shopping cart and order management. It allows users to view the educational contents uploaded in audio and video formats and earn their CLE credits. It serves as a powerful backend tool for the management to view various data and financial reports and control the contents of customer facing portion. Support team can use it to place back door orders, start various marketing campaigns, generate discount coupons, manage customer’s data and track customer trends.

Responsibilities:

● Involved in presales activities includes effort estimation, creating WBS, project schedule and plan

● Created multi-tiered architecture in .NET 4.0 and helped technical writer with creating detailed designed document

● Defined database schema and designed data flow architecture

● Worked with database developer in creating data migration from the Oracle based legacy system

● Define scope of requirements & participate in requirement specification reviews

● Developed screens using ASP.Net server controls & did form field validations server side validations using ASP.Net validation controls

● Designed & developed web user interface using ASP.NET, C#, HTML, JavaScript, server controls such as Data Grid, Data List, Validation controls

● Client side validations are done using JavaScript

● Implemented application logic under the Microsoft .NET framework using C#, ASP.NET to use

.NET features powered with CLR

● Worked on .Net 4.0 framework and used SQL Server 2008 database as backend

● Created large number of XML documents to represent the Charts data

● Responsible for writing Stored Procedures to perform database activities in the SQL Server

● Integrated PayPal payment gateway

● Deployed application on IIS 7.0, was responsible for application and IIS level configurations

● Involved in day to day client communication and status reviews Environment: C# .Net 4.0, ASP.Net, SQL Server 2008, Adobe Flash Action Scripting, XML, XSLT, CSS, ADO.NET, web service, Javascript, JQuery

Client : Covectra, Boston, MA

Role : Technical Lead/senior .NET Web and DB developer, support engineer Project : e-Track and Trace (April 2008 – Sept 2011) Description:

The application involves serialization and supply chain tracking for Pharmaceutical drugs based on compliance standards set by the FDA. It has been developed as a product for companies that need an end to end solution for their product’s supply chain to serialize and track individual items from the manufacturer to the end consumer. The entire process of configuring of the product, generating the serial numbers, printing them on manufactured units and then tracking them can be done from a single user interface.

Responsibilities:

● Designed SOA based system architecture, with the ability to serve multiple clients from the same application

● Designed database schema with multi- tenant architecture

● Created data archiving application to limit the database size on the servers placed at factory floor

● Developed data synchronization console app for daily synchronization between cloud server and onsite servers

● Helped DBA to define the Log Shipping based failover technique in SQL Server

● Defined policies and procedures for interfacing with third party printers like HAPA, PTS installed at factory floor.

● Used entity data model XMLs to create the Entity layer

● Developed WCF web services as a part of business logic layered and exposed web methods to be accessible for the UI layer

● Webform and module development using C#.NET 3.5 and SQL Server 2008

● Used XSLT to parse the HTML for generating the web page controls on the fly

● Developed user controls for code reusability

● Developed console application using Red Gate API for synchronizing the data between multiple servers placed at different geographical locations.

● Wrote algorithms to access verification and validation information form Vision cameras

● Supported various tests and validations e.g. FAT, IOQ, SAT conducted at the client end

● Change control management and documentation for the incremental builds

● Defining product road map for forth coming release, planning product version Environment: C# .Net 3.5, ASP.Net, SQL Server 2008, WCF, MS Reporting, Red Gate tools Client : Web Link Solutions LLC, FL

Role : Web Developer

Project : Auto parts e commerce portal - January 2006 to March 2008 Description:

A web based Product developed for a leading e-commerce solution provider for aftermarket automotive industry. This web application provides a web extension to legacy business systems and enables distributors and jobbers to create self-branded web stores featuring custom graphics, content and functionality. The system has capabilities to easily integrate various third party catalog, order and payment processing providers.

Responsibilities:

● Supported the product conversion from .NET version 1.1 to 2.0

● Helped the system architect for the SaaS based multi-tenant architecture design

● Converted product from a customized application to a SaaS based portal

● Implemented the architecture to connect to Catalog Servers and place order information to the legacy platforms

● Involved in data tier design and development

● Developed UI management module to provide ability to change the UI of application with style sheets using Themes and Skins of .NET 2.0 on the fly

● Implement master page and template page based UI architecture leveraging the newly introduced feature in .NET 2.0.

● Designed the database tables and created SQL Server stored procedure to interact with database

● Integrated many third-party gateways and web services including shipment providers, catalog providers, order placement services & payment gateways and designed the model to provide ability to add more as plug-in in C#

● Worked as a deployment engineer for product release and version controlling across multiple servers and client installations

Environment: Microsoft C#& ASP.NET 2.0 with ADO.Net using SQL Server 2000 as backend Client : Various jewelry stores and retail chains in India Role : Software developer - Desktop

Project : Inventory and Stores Management System (Jan 2005 – Jan 2006) Description:

A desktop application to manage large scale stores and showrooms. It maintains the record of customers, inventory mgmt., billing, HR mgmt., customer balances information Keeps track of order placements, repairs booking for customers, approvals, labor charges details, customer accounts and credits etc.

Responsibilities:

● Designed architecture for the desktop application

● Development in Visual Basic 6 and SQL Server 2000 using PL/SQL procedures and functions

● Used client server technology to support multiple client installations within the local area network

● Designed database using SQL Server 2000

● Developed major modules, COM components of the application

● Reports development using Crystal Reports version 7.0

● Database server configuration and client installation on multiple systems Environment: MS VB 6.0, SQL Server 2000, Crystal Reports 7.0 Client : Various hospitals across the India

Role : Software developer - Desktop

Project : Hospital Management System (Jun 2003 – Jan 2005) Description:

Product for the hospital information system installed at hundreds of hospitals in India. It is an ERP based solution for providing on-line information to the different levels of management in Hospitals. The product has been designed modularly for ease of implementation, integration and linkage. It helps in managing patient history records for the various medical branches. Responsibilities:

● Development in Visual Basic 6 and using PL/SQL procedures and functions

● Used client server architecture to support multiple client installations within the local area network

● Designed database using SQL Server 2000

● Developed major modules and COM components of the application using VB 6.0 and SQL Server 2000

● Reports development using Crystal Reports version 5.0

● Database server configuration and client installation on multiple systems

● Worked as a support engineer for providing onsite support Environment: MS VB 6.0, SQL Server 2000, Crystal Reports 5.0 Other Projects

● Live Dashboard for Market Research Analysts (Role – Technical Lead) – February – 2014 – September 2014

● Survey Programming Optimizer (Role – Technical Manager) – December 2013 to March 2014

● Common Services for SSO (Role – SQL Developer) – March 2008 to June 2008

● Diagnostics Centre Management System (Role – VB Developer) – August 2004 to January 2005

● Multi-level Marketing System Management System (Role – VB Developer) – January 2005 – May 2005

● Order processing and Job Control system (Role – VB Developer) – June 2003 – August 2003 CERTIFICATIONS:

● Microsoft Certified Professional Developer (MCPD) – .NET Framework 4, Service Communication Applications

● Microsoft Certified Professional (MCP) – MCP 2.0 EDUCATION:

● Masters of Science in Information Technology, Guru Ghasidas University, India – equivalent to M S in IT i n the United States

● Masters of Commerce from DAVV University, Indore, India (M.Com.) - equivalent to M BA in Accounting and Taxation emphasis in the unites states.

● Post Graduate Diploma in Computer Applications (PGDCA)

● Bachelor of Commerce from DAVV University, Indore, India (B.Com.)

Contact this candidate