PROFESSIONAL SUMMARY:

• Development, Maintenance & Support experience of 10 years in various domains such as Finance, Pharmacy, Health Insurance, Manufacturing and Healthcare
• Skilled in Microsoft .Net Technologies (C#, ASP.Net, VB.Net) with hands - on experience in Windows and Web applications development
• Very strong in database technologies with immense knowledge in Microsoft SQL Server database evolution (From MSSQL 2000 to MSSQL 2012)
• Excellent Data Analysis and Reporting Skills using Microsoft BI Tools like SSRS, SSIS and SSAS
• Experience working in Team Foundation Server 2012 and Agile Methodologies
• Understanding and Working knowledge of MVC, Windows Azure development, Windows Azure platform (Cloud Computing) and LINQ
• Experience working in UNIX Shell Scripting, XML Web Services, XSLT, IIS, Data Transformation Services (DTS), Replication, SQL Mail, SQL Jobs, FTP File Transfers
• Experience in developing windows and web applications using Classic ASP 3.0 and Visual Basic 6.0
• Highly skilled in using Excel and MS Access VBA programming, generating Trend Analysis reports, automation and presentation of reports
• Six Sigma Green Belt Certified in DMAIC with expert knowledge in ITIL Framework principles and Lean Production Support Model implementation
• Very good at Business Communication, generating Project Proposals, Business cases and receiving Client Approvals for various project initiatives
• Experience in creating Software Models using UML (Class Diagram, Sequence Diagram, Use Case Diagram) in MS Visio
• Experience in Onsite - Offshore coordination
• Managed up to 11 Team Members in various projects, assigned work and monitored to completion
• Extensive knowledge in Production Support & Maintenance Projects using tools like BMC Remedy and Unicenter

TECHNICAL SUMMARY:

Programming Tools: Vb.Net, C#, VB 6.0, VBA, UNIX Shell Scripting

Database: SQL Server 2012, SQL Server 2008 and SQL Server 2000, Oracle 9i/8i, PL/SQL

Web Technologies: ASP.Net, ASP 3.0, VB Script, Java Script, XML, Ajax, COM+/ DCOM

Reporting Services: SQL Reporting Services (SSRS), Excel, Crystal Reports 8.5, MS Access Reports, VB Reports

IDE and Case Tools: Team Foundation Server 2012, Visual Source Safe (VSS), Visual Studio, MS Project

Prod Support Tools: BMC Remedy, Unicenter Service Desk, Request IT

PROFESSIONAL EXPERIENCE:

Confidential, Des Plaines, Illinois

Sr. .Net Developer consultant

Environment: C#, Windows Azure Cloud Services, SQL Server 2012, AJAX, LINQ, JavaScript, JSON, Visual Studio 2012, Agile, Team Foundation Server 2012, SSIS and SSRS

Responsibilities:

• Developed modules based on prioritized work items from TFS and Agile working model
• Participated in Scrum meetings
• Developed interactive applications based on Business needs
• Supported Work item determination and prioritization from knowledge attained through the Legacy system
• Assisted Testing team by preparing test data and scripts
• Revamped a production job using Windows Cloud that needed optimization and cleaning
• Ability to quickly understand the Business model and complete development work on time

Confidential

Sr. Developer and SME

Environment: Visual Basic 6.0, SQL Server 2000, UNIX, SSIS, SQL Replication, DTS, COM+

Responsibilities:

• Proven ability to learn business quickly and adapt to the development environment
• Developed and Resolved about 12 Product Backlog Item within 45 days of starting work
• Resolved Production Support issues, conducted Business meetings and supported Business Operations
• Integrated Legacy System to trending technology by participating in Business Review meetings, Product enhancement and workflow meetings
• Managed work items using TFS 2012

Confidential

Sr. Application Developer Consultant

Environment: ASP 3.0, PHP, PL/SQL, MySQL, WAMP Server 2.2, MS Excel 2010 (Advanced Pivots), VB 6.0, VBA, MS Access 2010, COM+, PHP, UNIX, XML, Ms Visio

Responsibilities:

• Optimized 15 different Data Queries for faster and efficient data processing by reducing up to 50% to 70% of Query run time.
• Developed webpages for Fields Services to enter Milestones Task list and used the database systems to track end-to-end scheduling lifecycle processes
• Created data tables by following Normalization techniques, analyse Run time and work towards improving ETA
• Took part in Business Meetings to gather requirements, documented Business Overview and coordinated with the management in creating application web pages based on the requirements
• Participated in full SDLC lifecycle to design, develop, test and implement code using PHP, ASP 3.0, XML using Agile method for implementation of Project
• Created Use Case Diagrams, Class and Sequence Diagrams using MS Visio
• Generated automation one-click tools to process Huge Datasets using macros and advanced Excel and MS Access Concepts to generate various reports.
• Use Unix shell scripting and CRON jobs for various Data Transfers and Extracts
• Took over responsibility of difficult client to obtain additional data files. Previous files took twice as long as indicated by the project plan; by using a collaborative and knowledge-based communication style, new files were accurately received in the shortest period setting new goals for project plan delivery.
• Created and developed data quality and documentation for new team members and created opportunities for continued and development for entire team.
• Supported Project Governance team by developing applications and automation tools using VB 6.0, VBA and Advanced Excel
• Generated Project Schedules by analysing Project & Functional Impacts and considering Business Requirements and other various major parameters
• Executed reports from various Payroll and Worktime applications using PL/SQL for providing Financial Trend analysis, Future Project Planning and Budgeting
• Facilitated management with Project Status and Scheduling reports, Milestones Accomplished Reports using Excel and VB Reports
• Enabled team in creating and maintaining rollout strategies for various small, medium and large-scale projects by providing analysis logics
• Generated timely Status Reports and build metrics based on various Project Analysis, provide improvement strategies, plan and design Improvement and Optimization methods
• Created Usability and Project Metrics reports for productivity analysis of Team Members
• Provided reports to support time usage and resource utilization

Confidential

Sr. Consultant

Environment: ASP.Net, VB.Net, SharePoint Administration, SQL Server 2008

Responsibilities:

• Defining organization roles in order to align KM initiatives with operational and process improvements using ASP.Net, VB.Net, SharePoint Tool and SQL Server 2008
• Established KM effort as central service entity assisting various groups and functions to improve their operational efficiency and innovation levels while simultaneously identifying opportunities for higher level knowledge interchange between groups and functions
• Designed, developed and conducted programs for various user communities/groups across the organization
• Defined and driven the Change Management policies at an enterprise level bring in awareness and participation across the organization
• Created and executed specific communication plans for spreading KM awareness and it’s benefits for large projects
• Created a knowledge sharing culture by creating and promoting networks within the organization

Confidential

Project Lead / Sr. IT Analyst

Environment: VB.Net, VB 6.0, C#, ASP.Net, XML, Oracle 9i, COM+, UNIX, VB Script, Java Script

Responsibilities:

• Completed Lean Six Sigma project using DMAIC for resolving a redundant data fix issue with an annual savings USD 15000.
• Certified in Six Sigma Green Belt - Lean Production Support Model
• Managed a team of 11 members enabling a smooth support process, setting process goals and achieving them as a team
• Supported Incidents using Unicenter Service Desk application, analyse and fix production issues using Oracle 9i, VB.Net, VB 6.0 and Unix
• Handled severity 1 issues efficiently within SLA using VB.Net, C#, XML Web Services
• Developed new modules for Claims processing using VB 6.0, Unix Shell Scripting for Data Transfers, CRON Jobs, Control Files
• Worked with downstream Mainframe Teams in performing Data Transfers using PL/SQL and Unix Data Transfer jobs and created procedures to transfer Data from Mainframe Systems to downstream MS SQL Server 2008 servers
• Coordinated with Development Team, provide implementation support, perform Business & Quality Testing using LoadRunner
• Handled Project Management reports, Client Business Coordination, Requirements Gathering, Translating technical issues to simple Business Terms, receiving Client approvals for various change management processes
• Worked as an Onsite - Offshore Coordinator in understanding Business Requirements, creating Change Requests based on various Project Meetings
• Involved in many meetings in presenting business cases (using MS Visio, MS Projects, MS PowerPoint) and receiving approvals for various new project change requests and Problem Records
• Created Problem Records for redundant issues occurring within the application, discussed with Business Customers and prioritized Change Management to ensure application issues are fixed
• Worked as a Change Management Process Lead in identifying various functional and business impacts and scheduling code releases, run the Change Management Process Board Meetings to elaborate and prioritize key issues to Business Clients
• Trained End Users in application usage and provide Business Overview orientation to new team members
• Participated in various ITIL awareness programs, supported Lean Production Support Model and published Internal white Paper on ITIL principles

Confidential

Project Lead/ Sr. IT Developer

Environment: VB.Net, C#, ASP.Net, SQL Server 2008, MS SSIS, MS SSRS, MS SSAS, Unix, MS Access, VB 6.0, ASP 3.0, UNIX, SharePoint Administration, Rational Rose

Responsibilities:

• Worked as a Project Lead and excelled as an Individual
• Ensured proper backup systems are in place and ensured cross functional Knowledge Transfer is provided in the team
• Developed new application modules, automated systems for reporting and enhanced user view using VB.Net, C#, ASP.Net
• Worked with Disaster Recovery and Back-up Recovery System using MS SQL Server 2005 and MS SQL Server 2008
• Supported Product migration from Visual Studio 6.0 to .Net 2.0 and from SQL Server 2005 to SQL Server 2008
• Coordinated with Database Team in creating Cubes using Microsoft SSAS to analyse Recruitment System Data for generating geographical reports and predictive analysis reports
• Created Project Repository using SharePoint Administration
• Used Rational Rose to create Use Case Diagrams, Class Diagrams and Sequence Diagrams
• Documented Business Overview and Application Overview documents for Business Users and for the Development and Deployment Teams
• Performed Data Analysis to fix production issues, provide permanent solutions to redundant issues by creating Problem Records
• Worked in Change Management process and SCM to create new enhanced products and applications
• Conduct RCA using various Analytical logics to resolve any issue
• Worked with SLA and Priorities and ensured efficient product delivery
• Worked towards improving Resolution and Response Time Index for Incidents
• Accredited with various s and recognitions for s made in this project

Confidential

Environment: ITIL LPSM Business Processes, MS Excel 2008

Responsibilities:

• Completed CSF-CTQ for various KPIs for 25 different applications
• Created Business documentation and used SharePoint Server for Storage
• Worked in designing Project Information SharePoint Interface and establishing Documentation Repository using SharePoint Administration
• Appreciated by Business Customers for following a collaborative and transparent approach in completing the Project
• Enabled to learn ITIL and LPSM concepts and different Analytical strategies and logics
• Worked with BMC Remedy Tool and Unicenter Service Desk tool in creating Project Parameters and Inputs and creating Analysis Reports

Confidential

Environment: ASP 3.0, SQL Server 2005, SQL Server 2008, MS SSRS, MS SSIS, XML Web services, UNIX, MS Outlook, MS Access and VB Macros, SSAS

Responsibilities:

• Implemented a strategic and a collaborative approach in completing successful enrolment with no issues for the first time from offshore
• Highly appreciated by Client for efficiently handling the Annual Enrolment Process
• Managed huge datasets to read and analyse trends, keep track of status and provided daily reports using SQL Server 2005 and MS SSRS
• Worked with the Mainframe Team in transferring secure Sensitive Information Datasets into SQL Server 2008 Database using Microsoft SSIS
• Performed various Data Transfers and Load from SQL Server 2005 using UNIX and Mainframe Systems to transfer Data to a third party Data warehouse Systems.
• Created an Automated Email Generation tool using ASP 3.0 & MS Outlook due to License Withdrawal of a leading Bulk Email Generation Software
• Automated hardcoded Application Logics and Enrolment Information by redesigning the Data Structure to accommodate dynamic changes using SQL Server 2005
• Worked with Mainframe Application Team to get input information and provide support in performing Data Transfers to third party vendor organizations through secure Unix CRON jobs and Mainframe jobs
• Created and Presented Annual Enrolment Process Report for Senior Management's review
• Provided support for non-seasonal Enrolment support for new Hires and for new Life events of existing users
• Performed Reverse Engineering for 3 major audit applications in a span of 3 months
• Bestowed with Technical Excellence for the phenomenal analysis done in re-establishing the support model
• Created documentation, cleared Application Control Review Audit and S-PII Audit.
• Trained support personnel with Project Documentation and Application Overview Presentation
• Created enhanced modules for efficient data transfer models using SSIS
• Cleaned database with quality data, optimized various queries for improved efficiency