Sql Server Service

AKHIL MAHAJAN

Cell Phone: - 248-***-****

Email Address: - ************@*****.***

Professional Summary

** ***** ** ************ ********** in Business Intelligence, Data Analytics, Client-Server, Web Development and Object Oriented Design /Analysis and Development, skilled at progressing from problem stated to well-documented design.

Experience in Health Care, Clinical Research, Automotive, Software, Service and Manufacturing industries.

4 years of experience in TIBCO Spotfire as Developer/Admin.

2 years of experience in Salesforce.com as Developer/Admin.

Extensive development experience in developing applications using .Net Technology (VB .Net, ASP.Net, C#, ADO.Net, Web Services) and VB 6.0.

Windows form (Client-Server and n-Tier) experience using VB.Net, C#, VB 6.0, VBA, Access. Experience in Web application development using ASP.Net, VB.NET, C#, ADO.Net, IIS, ASP, HTML, CSS, XML, XSLT, AJAX, VBScript, JavaScript, FrontPage and Microsoft Visual Studio.Net.

Strong RDMS skills including TSQL programming, Database Modeling, Performance Tuning, Database Administration skills using Microsoft SQL Server 2014/2012/2008 R2/2008/2000

Created ETL packages using SSIS/ DTS to extract data from relational database and then transform and load into the data mart. Worked with Microsoft Reporting Services (SSRS) to create reports. Also developer SQL Server Analysis Services (SSAS) to create cubes.

Extensive experience in full life cycle of the software design process including requirement definition, prototyping, proof of concept, design, interface implementation, testing and maintenance.

Excellent verbal and written communication skills. Highly organized and systematic, following proper coding and documentation standards.

Educational Background

Master of Science, Computer Science, Lawrence Technological University

Bachelor of Technology, Engineering

Technical Skills

Programming Languages

VB.Net, C#,VB6.0, .NET Framework 4.0/3.5/2.0/1.0, DotNetNuke (DNN)

Scripting and Server-Side Programming

ADO.NET, ADO, HTML, WCF Services, Web Services, ASP.NET, JavaScript, VBScript, ActiveX, CSS

Web Tools and Technologies

IIS, Dreamweaver, CSS, HTML, XML, XSLT, Knowledge of common Internet protocols

Operating Systems

Windows

Databases and related Technologies

SQL Server 2012/2008 R2/2008/2000, Oracle 9i/8, CLR, MS Access, ODBC, SQL, PL/SQL, Red Gate Source Control, Red Gate tools

Tools

MS Visio, E-R Diagram, Confluence, JIRA

Business Intelligence

SSIS, SSRS, SSAS, DTS Packages, Tibco Spotfire Server 3.0, 3.1, 3.2, 3.3, 4.0, 5.5

CRM

Salesforce.com

Development and Testing Tools

Team Foundation Server 2013/2010/2008, Visual Studio 2012/2010/2008/2005/2003/6.0, Microsoft Project, Visual Source Safe 2005/6.0, JIRA, PerForce, FogBugz, Robo Help, CCH Zip Software, Red-Gate, DevExpress, Infragistics, Telerik, BIDS

Awards/Acknowledgements

Special Citation from MAXIMUS Inc. for developing a customer web portal (CWP) that

Resulted in significant cost savings.

Nominated for the 2013 Travel Award program at Severstal NA.

Professional Experience

CRO, Cincinnati, OH Duration: Nov 2014 to Present

Manager – Business Intelligence and Database

Environment:, SQL Server SSAS, SSIS, SSRS, Power View, Power BI, Power Query, Tableau, ASP.NET 4.0/3.5/2.0, Visual Studio 2012/2010/2008, Team Foundation Server 2012/2010, ADO.NET, Web Service, SQL Server 2014/2012/2008R2, T-SQL, XML, DevExpress, Red Gate Source Control, Red Gate Tools

Responsibilities:

Working in partnership with the clinical operation team to create a clinical Data Warehouse which would help with the needs for Clinical Data, BI, and Reporting.

Leading full project life cycle development to provide an N- tier data and reporting solution.

Integrating and replacing current management metrics reporting with dashboards, ad-hoc querying and data analysis.

Technical leadership and hands on design, development, monitoring, tuning, and management of integrated ETL (SSIS), Aggregations\Cubes\MDX (SSAS), reporting (SSRS), Excel Pivot Tables, SharePoint.

Adaptation of an ETL Framework which is integrated into SSIS packages to control and track execution, time, number of records, control reports, and provide detailed error identification.

Advanced visualization tools and integrated BI\analytics through the use of Scorecards (Balanced Scorecards, Metrics, Dashboards and reports).

Designing, developing, and architecting complete and integrated BI on demand single version of clinical data that is being aggregated, highly indexed, partitioned and secured for use through SharePoint, Excel Services, and Excel Pivot tables through the use of SSAS cubes

Advanced development knowledge and hands-on skills in integrating SQL Server, T-SQL, passing parameters, automation and SharePoint Server and Services.

Working with the Infrastructure team to set up Clinical Data Warehouse infrastructure.

Installed SQL Server 2014 and Sharepoint 2013 Enterprise servers.

AK Steel (Severstal NA), West Chester, OH Duration: Jan 2011 to Nov 2014

BI and Applications Team Lead/SQL Server DBA

Environment:, ASP.NET 4.0/3.5/2.0, VB.NET, C#, Visual Studio 2012/2010/2008, Team Foundation Server 2012/2010, ADO.NET, AJAX, Web Service, WCF Service, CSS, SQL Server 2012/2008 R 2, T-SQL, XML, DevExpress, Infragistics, SSIS, SSRS, SSAS, Red Gate Source Control, Red Gate Tools, Tibco Spotfire, SalesForce.com, JIRA, Confluence

Business Intelligence

Sales Customer Dashboard, Supplier Scorecard, Cost Margin Analysis, CSP Analytics, Daily Report of Operation (DRO), JIRA Cube, Production and Delay Cube, Ad-Hoc Reporting

Responsibilities:

Installed, configured, Administered and deployed Spotfire Server, Spotfire Client, Enterprise Player and Web Player environment across 2 different locations.

Configured the Spotfire Application Server and the Web Player Server for optimal use Implemented best practices for the Information Model, Library setup, and group administration.

Upgraded Spotfire from 3.0 to 3.1, 3.2, 3.3, 4.0 and 5.5 Versions

Performed daily admin tasks of user registration, security configuration, usage monitoring, answering how to questions.

Performed daily tasks including group/library management, upgrades, monitoring log files, performance tuning, troubleshooting and reporting.

Optimized Information links and queries to increase performance

Created Dashboards, Reports, Information links, Marking, Bookmarking and Filters.

Collaborated with business personnel from Finance, Sales and Marketing to develop data sets for Dashboards and Reports.

Created Proof of Concept (POC) Dashboards and Visualizations for adoption of Spotfire across the company.

Designed ETL data flows using SSIS; creating mappings/workflows to extract data from SQL Server and Data Migration and Transformation from Oracle/Access/Excel Sheets using SQL Server SSIS. Created SSIS package to load data from Flat File to Data warehouse and Report-Data mart using Lookup, Derived Columns, Sort, Aggregate and Slowly Changing Dimension. Used various tasks and transformations like Execute Sql Task, Execute Package Task and conditional split, Script Component, Merge and Lookup while loading the data into Destination.

Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).

Developed many Tablix Reports, Tabular Reports, Matrix Reports, Drill Down Reports and Charts using SQL Server Reporting Services (SSRS).

Defined report layouts including report parameters and wrote queries for drill down reports, Conditional, Drill Through report, Sub report, Parameterized report using SSRS 2012

Designed and implemented Data Marts, facts, dimensions and OLAP cubes having star schemas using dimensional modeling principles in SSAS

Worked on Developing SSAS Cubes, Aggregation, KPIs, Measures and Deploying and Processing SSAS objects.

.Net Applications

Customer Portal, Order Management System (OMS), Live Incentive System, Sales Forecast Application, Phonebook, AD Admin Tool

Responsibilities:

Designing, developing and testing a Web Application (Customer Portal) which provides the customer one stop shop to get all their information.

Designing, developing and testing a client server ClickOnce application (OMS) that will help the company better serve customers in general and automotive needs specifically.

Leading a development team of 4 developers.

Working with an Agile, Scrum methodology to ensure delivery of high quality work with bi-weekly iterations.

Designed and developed an event driven messaging system. This system exchanges messages between SQL Server, Level 2 production systems (Oracle) and a third party shipping system.

Designed, developed and maintaining a web based intranet system to display incentive being earned by mill employees on an hourly basis. The data aggregation is done by a Window Service on an hourly basis. The web front end uses DevExpress Gauge control to display the incentive earned.

Designed and developed a web based intranet Sales Forecast application which helps the sales manager enter forecasts for their accounts. This system also allows the General Manager to approve the forecasts entered by the Sales Manager.

Set up automated builds for the OMS application.

Set up Branching for the projects in TFS2013.

Designed and developed a web service which lets application authenticate users against Active Directory (LDAP).

SQL Server DBA

Responsibilities:

Installed SQL Server 2008, 2008R2, 2012 and 2014.

Maintained database level and object level security best practice by creation of users, Configuring permissions and assigning different roles to Users.

Experienced in database Backup, Recovery, and Disaster Recovery procedures.

Experienced with database performance tuning, Query optimization, client/server connectivity and other network issues, database consistency checks using DBCC.

Actively involved in support for production applications.

Applied necessary SQL server service packs and CU's.

Experience in debugging and optimizing Triggers, Views, Functions, T- SQL queries and stored procedures.

MEIJER INC, Grand Rapids, MI Duration: Oct 2010 to Jan 2011

Sr. Software Developer

Environment: VB.Net 2005/2008, ASP.NET 2.0/3.5, C#, Visual Studio 2008/2010/Team Foundation Server, ADO.NET, AJAX, Web Service, WCF Service, CSS, SQL Server 2008 R 2/2008/2000, T-SQL, XML, Windows 7/2000/XP

Order To Store (OTS)

Order To Store is a web based intranet system to track orders being placed for pickup at different Meijer stores. It was developed using Visual Studio Team Foundation Server 2008, ASP.NET 3.5, C#, WCF service, SQL Server 2008 R2, IIS, ADO.NET, JavaScript, CSS, Master Pages, Grid View Control and Sql Server Reporting Services.

Responsibilities:

Developed and maintaining a web based intranet system to track orders being placed for pickup at different Meijer stores. It’s a 3-tier application with the business logic being implemented at the middle tier. Created new http based WCF service to interact with the database.

Consumed existing http based WCF service to get price information for the products.

Wrote a Report module (Store Orders, Aging Report, Store Liability, Return Orders) using Reporting Services (SSRS). Implemented .Net 3.5 concepts of Master Pages and used CSS to improve the maintainability of the application.

Used JavaScript for client-side validation and C# for server-side validation.

Created of new Stored Procedures, Views, User Defined Functions (UDF’s) and Triggers to implement Business Logic.

Wrote Unit cases to test the functionality of the application

Price Decision Manager (PDM)

Price Decision Manager is a Click-One desktop (client server) application used to create price Changes for future promotions, Sales and temporary price adjustments. The system is being developed using Visual Studio Team Foundation Server 2008, VB.NET, SQL Server 2008 R2, ADO.NET, Data Grid View Control, WCF service and Web Service.

Responsibilities:

Developing and enhancing an existing Click-One desktop (client server) application to create prices changes for future promotions, sales and temporary price adjustments.

Using .NET Data Grid View control extensively for manipulation of data (CRUD operations).

Changed existing Sql Server Integration Services packages to adjust new enhancements and changes, using Fuzzy Lookup, Derived Columns, Condition Split, Aggregate, Execute SQL Task, Data Flow Task, Execute Package Task etc to generate underlying data.

Created and designed stored procedures, triggers and tables.

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

MAXIMUS, Boston, MA Duration: Oct 2007 to September 2010

Sr. Software Developer (Health Care Call Center)

Environment: VB.Net 2003/2008, ASP.NET 2.0/3.5, Visual Studio 2003/2008, ADO.NET, VB 6.0, AJAX, ASP, ADO, Web Services, SQL Server 2008/2000, T-SQL, XML, JIRA, IIS, CLR, Sql Server Reporting Services 2008/2000 (SSRS), Sql Server Integration Services 2008 (SSIS), DTS, Windows 2000/XP

Customer Web Portal (CWP)

Customer Web Portal (http://masshealth.ehs.state.ma.us/) is a web system designed for State of Massachusetts (MassHealth) providers to perform transactions electronically. Providers can submit Provider Transportation (PT-1) request's for the members, enroll in courses, download and order publications. CWP runs some background .Net services and SQL Server DTS packages to maintain database synchronization with other databases. CWP also sends e-mail notifications to the Providers when certain events are triggered. The system is designed in Visual Studio 2008, ASP.NET 3.5, VB.NET, SQL Server 2000, IIS, ADO.NET.

Responsibilities:

Responsible for design, development, implementation and maintenance of ASP .Net based web application (VB.NET code behind) to be used by Providers.

Extensive ASP .Net, VB.NET programming to implement various Web Interfaces, Web User Controls and Template Pages for the application.

Implemented the MVC (Modal View Controller) design Pattern.

Wrote a Data Access Layer (DAL) to interact with the database.

Significantly improved system performance by implementing .Net Caching concepts.

Implemented .Net 3.5 concept of Master Pages to improve the maintainability of CWP application.

Perform day to day Database Maintenance tasks -- Database Monitoring, Backups, Space Management, Resource Utilization, responsible for performing object migration between all production database Servers.

Managed SSIS packages, stored procedures, jobs, and utilize Server Side tracing to identify performance issues with deadlocks & other locking issues.

Designed a backup and recovery solution based on the link between disk design, database layout, backup retention, database performance for efficient backup and restore.

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

Reporting System (Ad-Hoc Reporting)

Ad-Hoc Reporting is an Intranet Application used by the Call Center to generate ad-hoc reports. This system was developed in Visual Studio 2008, ASP.NET 3.5, VB.NET, ADO.NET, Excel, IIS.

Responsibilities:

Principal Developer for development and deployment of a reporting System using VB.NET, ASP.NET and ADO.Net components in VB.Net.

Designed the SQL Query Generation Framework to generate the dynamic SQL Queries based on the dynamic search criteria and report output configurations selected by the users. Reports could be generated in XML, Excel, Word and PDF formats. Also added the functionality for users to email the reports.

Implemented a Security module, to maintain different access layers for the users.

Deployed and scheduled Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports.

NewMMIS Data Extract

NewMMIS Data Extract is an automated file processing system implemented as a Windows Service. Every day State of Massachusetts (MA) sends a XML feed for the member and provider information. This system reads and uploads different databases with the information from the XML files. The system has been developed in VB.Net, Visual Studio 2005, ADO.NET.

Responsibilities:

Responsible for Design, Development, Implementation and Maintenance of the system.

Implemented a File processing module, which copies, processes and Deletes files. If a file size is greater then 2 GB, then the file is split into smaller files and processed.

Implemented an Email Module, which sent out emails to the management and the call center employees, updating them about the status of the daily file extract

Extensively used T-SQL for Database programming to create stored procedures, triggers and views to update different databases.

Created ETL packages using SSIS to extract data from relational database and then transform and load into the datamart database.

US Maintenance, Norwood, MA Duration: Jan 2007 to Oct 2007

Software Developer (Call Center)

Environment: VB.Net, VB6.0, ADO.NET, ADO, Web Services, SQL Server 2000, T-SQL, XML, MSFlexGrid, FogBugz, FAC Sys, CCH Zip Sft, Windows 2000/XP

Service Works

Service Works is a CRM Package, which is used to handle service calls. Service Calls can be loaded in to the system manually, emails and XML Files.

Responsibilities:

Designed and developed GUI Components using Visual Basic 6.0, MSFlexGrid, SSTab Control.

Wrote a Report module (Vendor Compliance, Margin, Sales, Employee reports) using Crystal Reports. This module connects to the SQL Server using an ODBC (DSN) connection to retrieve data and generate user-defined reports.

Implemented a Compliance system to keep tracking of the compliance of the customers.

Wrote a module to implement billing for all completed calls. This automated process fills the information to different accounts in Great Plains financial software.

Automated the process of sending Notes, Updates, Invoices and Quotes to the customer. These are automatically sent to the customer via an email, after certain business rules are fulfilled.

Used CCH Zip Software for calculating the distance of a vendor from the store location.

Set up an Excel Report template to import Service Orders, Vendors Pricing and Customer Rates in to the system. VBA code is used to do a lot of calculations once the report is opened.

Automated the process of sending out the invoices and service work orders to the vendors by fax, once the service order is created using FAC Sys.

Responsible for writing the functional specification, user test cases and the design document. Responsible for interface design, writing data access layer, backend database development, and a windows service that would be used to talk to the backend system.

Used SQL Server Enterprise Manager & Query Analyzer Extensively. Wrote Stored Procedures, Functions and Views to implement business logic and restrict data access. Was also involved in database design, backups, maintenance and E-R modeling.

File Processing

File Processing is a system for processing files. Customers and vendors can upload quotes or updates on service calls.

Responsibilities:

The file parsing programs would adhere to a common interface. At run time, depending on the type of file to be parsed, appropriate dll’s would be loaded.

The GUI was designed using VB.NET, DataGrid Control.

Implemented file parsers for parsing XML, Excel and CSV formats.

Implemented module to read the uploaded files to SQL Server 2000 database using ADO.NET.

XML files are generated to write out the errors.

Automated Order Entry System (AES)

Automated Order Entry System is a system for processing service orders sent via emails.

Responsibilities:

The Automated Order Entry System parses emails sent by customers for service orders. Duplicate Service Orders are differentiated and moved to a Duplicate folder. If some emails cannot be parsed then those are moved to Manual folder.

This functionality has been implemented using VB.NET, ADO.NET, SMTP, String Builder, SQL Server and SMTP.

IVR Check-In/Check-Out

IVR Check-In/Check-Out is a system for processing vendor’s Check-in/Check-out times at the customer site.

Responsibilities:

IVR Check-In/Check-Out System reads a XML file, which contains information about the vendors Check-In/Check-Out times at the customer location. This functionality is developed using VB.NET, ADO.NET, XML, Datasets and SQL Server 2000.

ATX II LLC (CCH), Caribou, ME Duration: Mar 2006 to Dec 2006

Application Programmer

Environment: VB.Net, VB6.0, ADO.NET, Visual Studio 2003, ADO, SQL Server 2000, T-SQL, Access, XML, Farpoint Grid Control, Perforce, MSFlexGrid, VMWare, Robo Help, Windows 2000/XP

TaxCut Business

TaxCut Business is a Tax Software, which helps individuals and CPA’s to file taxes. It is owned by H&R Block.

Responsibilities:

Responsible for Designing and developing GUI components in Visual Basic 6.0 using Web Browser Control (IE 6.0/7.0), Link View, Fairpoint control (Grid, List), VB Tab Pro and ActiveX Controls.

Wrote a module for error checking in the user Tax return before it can be made ready for E-filing. The errors are shown in a Farpoint Grid control, with different colors.

Wrote a module to convert Database data into XML files and then the XML files are fed into the system and shown to the user as interviews for different forms. This module was developed using VB.NET, ADO.NET, XML and SQL Server 2000.

Implemented changes for the Internet Explorer 7.0 for the web browser control.

Wrote CSS style sheets (CSS) for the positioning of the Data and the controls on the Web Browser control in the GUI.

Wrote a wrapper class for the Farpoint Grid and List controls.

Played active role in planning, detailed requirements analysis, designing, development and testing based on information gathered from company user groups. Wrote technical and functional documentation. Reviewed design documents and source code.

Help Macro

Help Macro is used to generate the help documents of the software.

Responsibilities:

Wrote a Word macro using VBA and Visual Basic Editor, which reads the Doc file generated from Robo Help Project and convert into 3 DAT files. The DAT files are the Content, Links and Program text. Content DAT stores the information about the headings and sub headings. Links DAT file sores the internal and external links for the help file. Program DAT file stores the text, which is shown when help is called.

Douglas Autotech Corporation, Bronson, MI Duration: Mar 2004 to Mar 2006

Software/Database Developer

Environment: VB.Net, VB6.0, ADO.NET, ADO, AS/400, SQL Server 2000, T-SQL, Access, XML, Farpoint Grid Control, Visual Source Safe, Mapics, iSeries Navigator, Windows 2000/XP

Request For Quote (RFQ), Engineering Design Change (ECR), Quality (CRA)

RFQ System keeps track of the requests coming from automotive/truck customers. ECR System keeps track of the request for engineering drawing changes. CRA System keeps track of the quality returns and issues

Responsibilities:

Designed and implemented an interface to track requests for quotes from Automotive and Truck Customers. It’s a 3-tier application with the business logic being implemented at the middle tier. It was designed using Visual Basic 6.0, VBA, ADO, AS/400, Crystal Reports, Data Reports, Excel and Data Grid Controls.

Wrote a Data Class to interact with AS/400 (Release Accounting) to get the information.

Wrote a module to import data from AS/400 to SQL Server 2000.

On the Database side wrote Stored Procedures, Functions and Views to implement business logic and restrict data access in SQL Server 2000. Also scheduled DTS packages to take back ups of the database on a daily bases. Was also involved in database design, backups, maintenance and E-R modeling. Used SQL Server 2000 Enterprise Manager & Query Analyzer Extensively.

Played active role in planning, detailed requirements analysis, designing, development and testing based on information gathered from company user groups.

Created help files, user manuals and conducted user-training sessions as part of the software implementation.

Designed a reporting engine to generate reports, to track the progress for RFQ’s and

ECR’s.

Automated the process of emailing once the ECR is generated using VB6.0 and Outlook.

Designed and implemented an interface to export information to Excel sheets.

Designed a mechanism to track the progress of the ECR.

Ceridian

This is a Time Clock system, which is used by all the employees to fill in their daily time sheets. It calculates the hours spent by the employees on daily and weekly basis. Access to various menus in the system is restricted based on the group to which the employee belongs.

Responsibilities:

Developed a Desktop application that would serve as a time clock for the employees to clock in and out during working hours in VB.NET, ADO.NET, Crystal Reports and SQL Server 2000.

Designed the employee time sheets. Designed and implemented several administrative and statistical reports using Crystal Reports.

Designed the backend database and the system. Also responsible for maintaining and administration of the SQL Server 2000 databases.

Designed the application to be served as a central repository for the employee information.

Ranger Data Technologies, Royal Oak, MI Duration: Dec 2002 to Feb 2004

Software Programmer

Environment: VB 6.0, ADO, SQL Server 2000, MS Excel, MS Access, HTML, CSS, Crystal Reports, Data Reports, Windows 2000/XP.

Outbound Ranger

Outbound Ranger System is a newspaper call center system.

Responsibilities:

Designed and developed GUI components using Visual Basic 6.0, third party ActiveX controls (Fairpoint Grid control) for lead assignment, which displays all the leads available.

Developed an Event File Handler that tracks the activity of the Ad-rep at different locations based on time interval and sends the information to the manager.

Implemented a “Reports Module” using Visual Basic, SQL Server 2000, and Crystal Reports. This module connects to the SQL Server 2000 using an ODBC (DSN) connection to retrieve data and generate user-defined reports. Created Reports (Bar Charts, Pie Charts) using Crystal Reports.

Wrote Stored Procedures and Triggers that deal with complex newspaper business rules. These were written with focus on performance, optimization, error trapping and maximum usability of the software. Created SQL Scripts to update/insert leads coming from the front-end system.

Optimized the database by re-configuring parameters, creating/rebuilding indexes and recompiling stored procedures.

Created sample forms for presentation and demos to the client.

Developed Testing Plans for the software.

Gallagher Fire Equip. Comp., Livonia, MI Duration: Jan 2002 to Dec 2002

Application Developer

Environment: VB 6.0, ADO, SQL Server 2000, MS Excel, MS Access, HTML, CSS, Crystal Reports, Data Reports, Windows 2000/XP.

Lawrence Tech. University, Southfield, MI Duration: Mar 2001 to Feb 2002

System Support

Environment: Visual Basic, ADO, Oracle8, MS Access, MS Excel, FrontPage, HTML,

DHTML, JavaScript, CSS, Windows NT/98.

Contact this candidate