Sql Server Project
Resume:
Avnish Katoch
************@*****.***
Professional Experience Summary
Extensive experience of 15 years as an IT professional.
Possess experience in working with United Health Group (Insurance), State government, PA Department of Education, PA Department of Transportation, PA Department of Labor and Industry, State Government of Mississippi, Pennsylvania House of Representatives, Maruti Suzuki, Ingram Micro etc.
Conceptualized, analyzed, designed, developed, tested, implemented and maintained over a dozen projects in platforms ranging .NET, Java, Oracle, SQL Server, GIS (GeoMedia/Google maps), and IBM Rational Tools.
Expertise in ITIL, UML, User Case Scenario and ER Diagram.
Expertise in using tools like Visual Studio 2010, TFS 2010, SSRS, Crystal Reports, IIS, SSIS, TOAD, SQL Developer, SharePoint 2010 and Informatics’ Power Center.
Expertise in Microsoft SQL Server and Oracle 9i/10g.
Extensive experience in Performance Tuning with reference to Security, Performance and Optimization.
Extensive experience in Database programming using T-SQL and PL / SQL - Stored Procedures, Triggers and Views.
Experienced of Microsoft Patterns and Practices.
Worked in Agile Methodology Using SCRUM and Test Driven Development environments.
Experience in .Net 2.0, 3.5, 4.0, Windows Communication Foundation (WCF)s, Windows Services, Custom Controls (Telerik) and User Controls. Expertise in developing WebForms and WinForms applications using C# and VB.Net.
Work History (current to oldest):
Start Date: December 2011 to Present
Employer: Modis Inc.
Client: United Health Care (United Health Group)
Title: Sr. Architect
High Level Responsibilities:
Managed a team of 10 (2 Business Intelligence developers (Micro strategy), 5 Senior Developers and 2 data architects) for a ETL development using SSIS/C#.
Description:
United HealthCare's (United Health Group) Marketing division needed design and development for their Data Mart using SQL Server 2008 R2. Business Intelligence is using this data mart, which is refreshed via weekly uploads from centralized Data Warehouse.
Responsibilities:
Worked with Data modeler to design the data model.
Worked with business to understand current model which comprises of Cognos, DB2 and Oracle.
Designed the Database architecture (tables, stored procedures and functions for ETL).
Developed the ETL model using SSIS and C#.
Built a scheduling service which brings data on weekly basis from various sources.
Used SSIS, C#, SQL Server 2008 R2, Erwin data modeler and SSAS.
Prepared complete test plans for Unit testing, QA testing and presentation for higher management. Performed walk through for QA and development team.
Worked in Agile based methodology with unit test driven approach and delivered the product in short time frame.
Start Date: May 2011 to November 2011
Employer: Pension Pro Software LLC, Title: Technical Team Leader
High Level Responsibilities:
Managing complete SDLC cycle from Requirements Gathering , Analysis, Design, Project Planning and Execution, Risk Analysis, Creating Functional Specification documents, Development and Quality Management processes.
Description: Pension Pro developed the first TPA (third party administrator) workflow software using WPF (for desktop version), Silverlight for website, WCF, SSRS, SSIS, .NET 4.0, Visual Studio 2010 and SQL Server 2008.
Workflow handles, templates for annual administration, distributions, loans, and other processes will allow rapid implementation of projects for admin plans. It also allow to monitor the flow of work through your office, track time associated with your services, reassign tasks to keep the work flowing and run reports to analyze your progress and profitability. The Plan Sponsor portal allows annual data collection process and annual report delivery. The secure website is customized to contain client logo and firm name allowing seamless integration with clients’ existing website. Firm’s clients securely and electronically enter, edit and approve annual data collection packet online. The data collection process integrates with the projects in Workflow allowing Firm’s staff to monitor the progress of clients as they complete the process online.
Responsibilities:
Actively involved in the Release from Requirements gathering to post implementation support.
Efficiently managed and mentored the application team members in development and testing of the Release changes.
Using Agile software development methodology.
Expert Scrum Master.
SCRUM based sprints with multiple teams delivered on time.
Managed the automatic builds to for testing team and automated testing using VS 2010 for development team.
Managing Server environment (Report server, SQL Server, IIS).
Building reports via SSRS.
QA testing and mentoring DBA for SSIS for ETL processes.
Merging/Branching via TFS 2010. Managing TFS 2010 server/environment. Extensive use of TFS 2010 for Application Lifecycle Management.
Share Point 2010 Installation, Configuration, Upgrade, Architecture, Customization, Site Templates, Site Definitions, Content Management and Reports,.
Conceptualized WCF to handle multiple clients connecting to a fat client application.
Conceptualized IIS server side handling for multiple clients via a single level binding.
Built the ETL based model to bring new clients into database using SSIS.
Worked with direct clients to understand their software/tools to extract data to import into SQL Server.
Start Date: August 2009 to May 2011 Client/Project: PennDOT (Pennsylvania Dept. of Transportation), Employer: Acclaim Systems, Inc., Title: Sr. Technical Architect
High Level Responsibilities: I have been Part of the Primary Transition Team which handled transition from previous vendor and have performed Technical Business Analysis of .NET, GIS and Highway Team. I have been working with the below applications handling various roles like Technical Architect, Application lead etc.
DotGrants Application
Role: Technical Lead
Description:DotGrants handles processing, reviewing/scoring and management of grants with Pennsylvania Department of Transportation. It is a web-based scalable, configurable, business rule driven and work flow based end-to-end Electronic Grants system. It provides consistent and standard user interfaces to handle the process from grant application entry to closeout. It also provides a secure and scalable solution that facilitates an efficient method of grant planning, publishing and solicitation, application entry, review, approval, contract, award and post-award monitoring.
Responsibilities:
Actively involved in the Release from Requirements gathering to post implementation support.
Efficiently managed and mentored the application team members in development and testing of the Release changes.
Created/updated SQL stored procedures to fix the broken application functionalities.
Regularly conducted team meetings to address the application issues across 5 Bureaus of PennDOT.
Have provided and executed effective initiatives to improve the release management process and performance of the team.
GISIQ (GIS Interactive Query): Role: Technical Lead
Description: The GIS Interactive Query (GIS-IQ) application serves as the flagship application with PennDOT's Geographic Information Division. GIS-IQ provides an interface for showing sets of thematic map data which can be exported and queried for attribute data. Application is designed using InterGraph’s GeoMedia Webmap professional, Oracle 10g and Visual Studio 2008.
Responsibilities: Created new layers for various highways and federal programs. Extracted data using ETL tools from DB2, Oracle and IMS systems.
IForms: Role: Project Lead / Tech Lead
Description: The Windows Tablet PC Application is designed for Bridge Inspections for Bridge inspectors who enter data in handheld tablet PC for sate wide bridges. This is a C#, SQL Server, Crystal Reports based application for tablet PCs which interacts with Java/Oracle based ECSM (electronic construction management) application.
Responsibilities:
Actively involved in the Release from the Requirements gathering to post implementation support.
Developed and unit tested the Release changes.
Efficiently performed the SQL server Migration of the application from Version 2000 to SQL Express 2008.
Lead the Java/J2EE based web service development architecture to communicate with ECMS and tablet PCs.
Constantly mentored and provided support to the System Testing Team.
Actively involved in the User Acceptance Testing to ensure the successful implementation.
Documented new s/w installation instructions post SQL upgrade for the users across 11 Districts.
Eprocurement: The flagship procurement application of PennDOT communicates with SAP, IES and Mainframe.
Responsibilities: Lead SQL Server upgrade effort from SQL Server 2005 to SQL Server 2008. Extensively used SSIS and ETL tool Informatica for data archiving.
CDS NextGen: Construction Documentation System handles complete cycle of construction of PennDOT and its vendors across Pennsylvania. Application interacts with ECMS (Electronic Construction Management System) of PennDOT and handles PO and invoices and project documentation.
Responsibilities: Transitioned from previous vendor and after acquiring subject matter expert skills, trained and guided the development team for new enhancements and maintenance.
Start Date: June 2009 to August 09 Client/Project: Mississippi Department of Environmental Quality, Employer: Acclaim Systems, Inc. Title: Sr. Technical Architect
Responsibilities: Developed and designed The Mississippi Department of Environmental Quality's "Enspire", the new web based data management system which will be the state's primary repository for water quality samples and measurements.
Start Date: May 2006 to May 09, Client/Project: Pennsylvania Department of Labor and Industry, Employer: Acclaim Systems, Inc., Title: Project Lead / Technical Lead
Description: UCTides is Tax filing system for Pennsylvania Businesses for unemployment compensation. Almost 40,000 taxes are filed each quarter and this system is used for collecting more than $300 million each year.
Responsibilities: Maintained and enhanced the application. For better performance, upgraded DTS to SSIS and Visual Studio 2005, performed DBA duties, client communication and training to users.
Start Date: Feb 2006 to April 06, Client/Project: PA House of Representatives, Republican Information Technology, Harrisburg, Pennsylvania, Employer: Acclaim Systems, Inc.
Title: Architect
Start Date: May 2005 to Jan 06, Client/Project: Pennsylvania Department of Environmental Protection, Employer: Acclaim Systems, Inc. Title: Technical Lead
Description: Handled more than 30 different web applications, which were in the process of .NET conversion. Took care of the web servers located at CTC as well as locally. Fine-tuned the web servers for better performance and moved the applications to new servers. Moved the SQL Server databases to new servers.
Start Date: Feb 2005 to April 05, Client/Project: PA House of Representatives, Republican Information Technology, Harrisburg, Pennsylvania . Employer: Acclaim Systems, Inc., Title: Architect
Description: HRIS application was originally written in MS Access, and was in a largely incomplete and malfunctioning status. Acclaim Systems was contracted to convert the application to a more flexible and robust SQL 2000 backend and .NET front end, troubleshoot and redesign the application logic to improve functionality, and add new capabilities to the system per the direction of the Human Resources Director.
Start Date: March 2004 to March 05, Client/Project: PA Department of Labor & Industry , Employer: Acclaim Systems, Inc., Title: Sr. Architect
Description: EASE is a secured intranet based application designed for examiners within the Unemployment Compensation Bureau to examine the claims filed for unemployment. It is also the application used through Bureau Service Centers for the gathering of claimant information by phone.
Start Date: July 2003 to Feb 04, Client/Project: Powell Rogers and Speaks, Employer: SSGUSA Inc., Title:
Tech Lead: The project was a Pennsylvania Commonwealth government funded delinquent tax and credit collection initiative. PRS deals with most of the state tax and major names in central Pennsylvania businesses.
Start Date: March 2003 to June 03, Client/Project: PA Department of Public Welfare, Employer: SGUSA Inc. Title: Lead Developer
Description: A Pennsylvania Commonwealth government initiative that provides technology and learning programs that will empower children, child day care professionals, teachers, parents, and communities through an enriching learning process of discovery, creativity, awareness, and imagining.
Start Date: December 2000 to Feb 2003, Client/Project: Pennsylvania Department of Education, Employer: Computer Aid Inc., Title: Sr. Developer
Teacher Certification SystemThis system keeps track of all certifications issued through the Department of Education to all teacher aspirants in various education establishments located in Pennsylvania.
Child Accounting System (CAD): Child accounting system collects pertinent information from all educational institutions of Pennsylvania and provides the data to various state agencies for budgeting purposes.
eGrants V2 (6 months): In continuation of the previous eGrants project, this project involved the conversion of the eGrants database from an older version of application to a new rewrite. The databases of the different Bureaus of the Department of Education were merged into one enterprise-wide database. T-SQL based DTS packages for MS SQL Server 2000 were written for this purpose.
eGrants V1 (2 years): eGrants is a unique web based Grant management system for Pennsylvania Department of Education. There are seven different Bureaus in the Department of Education, which distribute between $500 million to $1 Billion a year through this system.
RESPONSIBILITIES: Client Coordination, Analysis, Requirements Definition, Technical Design, Development, Implementation, Testing
Start Date: Sep 1995 to November 2000, Client/Project: Various, Employer: ASAP India (now part of MindTree Consulting), Title: Developer
Maruti Suzuki: Worked Dealer Network system which provides an Intranet facility to all Maruti Dealers which helps them to book orders and procure their materials through a central online system.
ZLAND: This software solution project was for a large US based client, related to online human resource information system accessed securely through Internet.
WEB@LOG: This is a B2B engine / Framework that can be customized for any business based on the needs.
Impulse: INGRAM MICRO, world's number one Technology Wholesale Distributor of IT related products, has mainframe based application systems (IMPULSE) for their global retailing services across the continent.
MEN(Modi Entertainment India): The Essar Project was modified for MEN and new schedules were developed based on Network needs.
ESSAR: This was a payroll package for one of India's largest Telecom companies.
Education:
Himachal Pradesh University, Shimla, India
Bachelor of Arts (Economics)GeoMedia WebMap Certified Professional
Web Development Diploma from ATS (1999)
Mainframe (Certification) From Micro Focus Training Center (1997)
One and half year IT Diploma from NIIT New Delhi
Contact this candidate