Sql Server Project

MADHAN KUMAR ARUMUGAM

*** ******* *****, #***, **********, IL - 60563

Phone: 312-***-****

E-mail: ******.*******@*****.***

PROFESSIONAL SUMMARY

• 5+ years of programming experience for major software development corporations, providing systems programming, data analysis, and data administration services.

• Proven ability to lead teams in the design, development and implementation of new software solutions and in the customization of existing solutions to specifications and on schedule.

• Expertise in full project life cycle development for implementation and integration

• Trained professional in Object Oriented Analysis and Design (OOAD) and SQL Server by Verizon Data Services Inc.

• Demonstrated solid management skills and proficiency in leading and mentoring individuals to maximize levels of productivity, while forming cohesive team environments.

EDUCATION

Master of Science, Management Information Systems Aug 2008 - May 2010

University of Illinois at Chicago GPA: 3.7/4.0

Bachelor of Engineering, Electronics & Communication Engineering July 2002 - June 2006

Anna University, India GPA: 3.9/4.0

IT EXPERTISE

Programming languages : C, C++, Java, C#, VB6

Web Technologies : ASP.NET, JavaScript, XML, HTML, CSS, JSP, Servlets, PHP

Framework : ADO.NET, COM/DCOM

Database Tools : Oracle 9i, SQL Server 2X, Microsoft Access, MySQL 5.0, Visio

Software Packages : Adobe Dreamweaver, Microsoft Visual Basic, MATLAB, MS Project

Web Tools : Visual Studio 2X, Expression Web, Visual Web Developer

Operating System : Windows variants, UNIX variants

EXPERIENCE

Reports Engineer, Epic Systems Dec 2010 - Jan 2012

• Involved in the planning, developing, testing and shipping of minor patches and other product releases.

• Collaborated with cross-functional teams, including system architects, marketing team, QA and end-users to determine system flow and implementation.

• Migrated the database from existing Chronicles server to SQL server using Extract Transform Load (ETL) development for Epic's reporting needs. Identified errors that occurred during conversion and integration and provided prompt resolution for the same.

• Developed dashboard reports application using crystal reports in C#.net.

• Involved in the deployment of the Epic software in various client location.

• Participated in engineering processes involving source control, coding standards, code reviews, automated validation and verification tools and, product release and maintenance.

• Demonstrated ability to quickly learn organizational processes, workflows, policies and procedures in a short span of time.

• Wrote complex stored procedure in SQL Server 2008 and Oracle to serve the reporting needs.

• Performed unit level testing - both functional and workload tests - before integrating the changes to Integration Development Environment.

• Concentrated on query optimization techniques in Epic's reporting needs.

Software Developer, Infinite Energy Jun 2010 – Oct 2010

• Actively participated in the daily stand up meetings to analyze the time frame and report the status of the project.

• Measured, monitored and communicated the application's development status to the appropriate audience and escalated risks and issues as needed.

• Involved in Unit Testing and Integration Testing of different framework modules.

• Mentored and assisted team members by answering development questions, helped with coding new transactions, and teaching and helping with source control processes.

• Created UML Diagrams based on use cases provided by business analyst team.

• Demonstrated judgmental ability to solve problems.

Software Analyst and Programmer – Graduate Assistant, Dept of Psychiatry, UIC Aug 2008 - May 2010

• Revamped the design and implementation of Grant Report Tool using C#.Net and SQL Server 2000 that provided business queries more comprehensively than the traditional one.

• Developed an ASP.NET application using C#.Net with SQL Server 2000 as backend to enable the staffs in the Dept of Psychiatry to check various events and activities happening in the department, to check and update their leave balances and to check the profiles of all the professors and doctors in the department.

• Content Manager with daily postings and site changes using Microsoft Expression Web software.

• Gathered requirements from business users of Psychiatry Hospital and DCFS, translated the business need into technical requirements and provided business solution for Psychiatry Hospital to automate the process of managing and updating contact, demographic, diagnosis and medication details of their child patients.

• Developed DCFS tool for the same using C#.Net and SQL Server 2000 which serves as an interface between the patient database and the Research Assistants, Nurses and Doctors. After sufficient records are added to the database, automated the process of generating contact history of the patient using Crystal Report XI

• Analyzed different reporting tools and proposed recommendation that leverage existing architecture to generate Grant Report.

• Proposed and developed an integrated clinical and billing software solution for providers of Psychiatry Mental Health and Substance Abuse Services using C#.Net and SQL Server 2000, which enhances the ability of the user to provide quality care while ensuring that all the required administrative tasks that are needed for billing are also attended.

• Responsible for generating Insurance claims for the Neuropsychiatric Institute.

• Created development plans, project documentation and E2E test scenarios to emulate user interaction in the production environment

• Handled database server tuning, application tuning, maintaining documentation, capacity planning and database security.

• Worked extensively with Data Adapter, Dataset and Data Reader as part of ADO.NET to access and update database.

• Responsible for the design and maintenance of the clinical databases and programming of the edit checks.

Business Analyst / Developer – Project Intern, SBLI USA Mutual Insurance Inc., Aug 2009 - Dec 2009

• Conducted a systematic analysis of pros and cons of current and potential competitor’s website and its usability.

• Analyzed the current website using the 7-point usability analysis technique.

• Prepared a detailed project plan for implementing various modules of the company’s website using MS Project software and Data Relationship Diagramming concepts.

• Redeveloped the existing website using ASP.net and SQL Server 2005 as backend.

Lead Developer – Project Intern, The Berco Company Inc., Aug 2008 - Dec 2008

• Lead designer and developer for web sites and promotional media which enabled company’s web based business.

• Oversaw application design, development and maintenance as team leader of this project.

• Part of the development team which developed the JSP application for Berco.

• Designed and implemented retail sales catalog system by serving as lead over team of five software developers.

• Created analysis and design models with system use cases, activity diagrams, pseudo-code, and test cases.

• Created web reports using Crystal Report XI.

• Created e-mail based notification system for activities of registered users.

Analyst, Verizon Data Services India June 2006 - July 2008

• Developed a windows application in C#.Net with SQL server 2000 as backend to analyze the orders which failed to flow through the end systems. Analysis carried out using this tool increased the productivity in the long run.

• Designed and developed an intranet web application for managing production details and issues of fallout orders by using SQL Server 2000 as backend database.

• Developed intranet websites for IT Retail portfolio in ASP.NET (VB) with SQL server 2005 as backend to implement the work order flow.

• Wrote stored procedures for automating the process of loading the production database with production details on a daily basis.

• Development on SQL Server 2000 focusing on Database Normalization, Indexing, Triggers, Views and Reporting (Crystal Reporting Services).

• Implemented SQL Server Replication to improve infrastructure between live databases and reporting databases.

• Developed DTS packages with SQL Server 2000.

• Assessed release scope and business requirements to sketch the development plan and identify system impacts.

• Interacted with Business Analysts and Architects to distill business use cases and requirements into analysis and design artifacts.

PROFESSIONAL PROJECTS

Advanced Database Management Systems

• Developed an online music store portal using, ASP .NET, SQL Server 2005, Adobe Photoshop and Dream Weaver.

• Created the entire database system for maintaining user account information, product availability and discount information.

UNDER GRADUATE PROJECTS

• Developed a centralized application for managing the department symposium details for Anna University, India.

HONORS & AWARDS

• Best Performance Award – Verizon Data Services Inc., - Software design and development for National Service Order Processing (NSOP), 2007.

References Available on request

Contact this candidate