SUMMARY

• 15 years experienced Healthcare domain IT profession with excellent organizational skills.
• Experience in implementing business process and skilled to lead end to end solutions.
• Proven ability to interface and coordinate with cross functional teams and cultures, analyze existing systems, wants and needs, design and implement solutions.
• Experienced in business requirements gathering, documenting them, and converting them into robust system designs.
• Authored Multiple Solution design documents and functional specifications.
• Expertized in problem - solving skills and Goal oriented Team player, Mentor and Certified Project Manager.
• Experienced in all part of SDLC and skilled Subject Matter Expert.
• Experienced in architecting, designing, and delivering complex client/server systems and extensive systems integration -Also experienced with SAP R/3 Integration using DCOM.
• Excellent working knowledge in UML concepts/ Diagrams and Rational Rose Suite, ERWIN and XML.
• Export in data modeling, software design, development and support using MS SQL Server.
• Expert Programming skills in T-SQL and proven abilities to write optimized queries with complex business/transformation logic, strategically implementing indexes and performance fine tuning.
• Proficient in developing stored procedures, functions, triggers, views and cursors.
• Experienced in handling SQL Profiler, Job Scheduling, SSIS, Replication, Query Optimization, DBCC commands and Statistics and Experienced in Applications report generation using Crystal Reports 8.5.

PROFESSIONAL EXPERIENCE

Confidential

Senior SQL Architect

Environment: SalesForce.com, IBM DB2, SAP and Visio

Responsibilities:

• As a lead consultant worked for Integration team and helped with Integration Solutions.
• IIB/DELL BOOMI/ETL Integration Technologies integrates legacy systems to SAP based future systems - I have been part of solution team to provide Integration solutions.
• Salesforce.com is one of the applications I have been helping with Integration of external systems and Conversion.
• Gathered Business requirements and translated them into functional and non-functional specifications.
• Working with system analyst, business customers to understand business processes and help with them solutions.
• Carried out Multiple Proof of Concepts, solution proposals and prototyping.
• Involved in Data Modeling Database solution - Developed SQL DDL/DML Scripts.
• Worked on Reverse engineering with the existing Database solutions and covered them as models.
• Working with conceptual, logical and physical Database modeling.

Confidential

Senior SQL Architect/Subject Matter Expert

Environment: MS SQL Server 2005 and 2008, SSIS, SQL Developer, Ms Visio, ERwin and Ms Project

Responsibilities:

• As a lead working with system analyst and business customers to understand business processes, gather and document project requirements and translate them into functional and non-functional specifications and prototyping.
• Modeling a Database solution.
• Working with conceptual, logical and physical Database modeling.
• Reverse engineering the Database solution as models.
• Developing T SQL scripts, writing stored procedures and Database objects.
• Developed/reviewed SSIS packages for Data Warehouse needs.
• Carried out efforts estimation and team tasks planning.
• Performance tuning and optimizing the application.
• Involved in release management and code deployment strategies.
• Involved in customer interactions and offshore coordination.
• Project Managed end to end solution - Involved in onsite/offshore development and support.

Confidential

Consultant/SQL Developer

Environment: MS SQL Server 2000, DTS, VB6.0, Crystal Reports 8.5, Windows

Responsibilities:

• Worked on collecting client specific, customer gap analysis, functional specification collection and design.
• Modeling a Database solution using ERWin.
• Reverse engineering the Database solution as models.
• Designed and developedjobs, DTS packages for data migration requirements.
• Designed and developedstored procedures to serve data requirements for front end applications.
• Coordinated of team for data programming activities periodic reporting and Confidential management.
• Implemented SQL performance improvement mechanisms and systems integration.
• Contributed to process improvement and project management activities like resource planning, providing billability data etc.
• Involved in Crystal Reports analysis and development.

Confidential

Sr. Developer

Environment: MS SQL Server 2000, DCOM, BAPI, SAP R/3 4.6c, Crystal Reports 8.5 and VB 6.0

Responsibilities:

• Involved in ERP integration engineering and worked on enhancement.
• Worked on logical and physical Database and Application modeling.
• Worked on collecting client specific, customer gap analysis, functional specification collection and design.
• Designed, developedjobs, stored procedures, DTS packages for data migration requirements.
• Implemented SQL Performance improvement mechanisms.

Confidential

Sr. Developer

Environment: MS SQL Server 2000, Crystal Reports 8.5, VB 6.0, Windows

Responsibilities:

• Collected requirementsanddesigned for various clients.
• Worked on logical and physical Database and Application modeling.
• Involved in system analysis, design and system development.
• Involved in stored procedures, T SQL coding and code reviews.

Confidential

Developer

Environment: Microsoft Visio, ERwin, PL SQL/Oracle 8i, SAP R/3 4.6 c, R/3 DCOM, IIS 6.0, Windows

Responsibilities:

• Analyzed functional requirements and prepared solution design.
• Worked on logical and physical Database and Application modeling with Oracle 8i.
• Worked on technical specification and developed tool.
• Involved in requirement collection, system analysis, impact analysis, design and development.
• Designed all modules and Involved in development.
• Involved in UI development using ASP.Net and business COM components using VB.Net.
• Developed DCOM component to integrate SAP R/3 system.

Confidential

Developer

Environment: MS SQL Server 2000, Rational Rose, ASP 3.0, SAP R/3 4.6 c, COM + Services, Windows

Responsibilities:

• Involved in system analysis, impact analysis, design and development.
• Worked on logical and physical Database and Application modeling.
• Involved in design and development of Bosch IQ in MVC Architecture.
• Developed DCOM components to extract available products from R/3 System.
• Involved in UI development using ASP and business components using VB.
• Developedstored procedure and all database objects.
• Generated report of system usage using Microsoft Chart Control.
• Participated in design of Mobile PC, Offline Increment’s of Bosch IQ.

Confidential

Developer

Environment: MS SQL Server 2000, Visual Basic 6.0, ASP 3.0, COM server, MTS, Crystal Reports 8.0,Visual Modeler 2.0, Windows

Responsibilities:

• Involved in system analysis, impact analysis, design and development.
• Developed smart card access business components development in Visual Basic.
• Developed web interface using ASP 3.0, Java Script and VB Script.
• Developedstored procedure and all database objects.
• Designed and developed application on three-tiered service model.
• Developed reports in Crystal Reports 8.0.

Confidential

Developer

Environment: MS SQL Server 2000, Visual Basic 6.0, HMS, Report Tool, Crystal Report 8.0, Visual Modeler 2.0, Windows, UNIX

Responsibilities:

• Involved in system analysis and impact analysis.
• Involved in design and development.
• Worked on logical and physical Database and Application modeling.
• Developed on VB 6.0 and SQL.
• Generated reports using Crystal Reports 8.0.

Confidential

Developer

Environment: MS SQL Server 7.0, Visual Basic 6.0, C++, Windows

Responsibilities:

• Involved in GUI Development in VB 6.0.
• Involved in TSQL Development.

Confidential

Developer

Environment: MS SQL Server 7.0, Visual Basic 6.0, XML1.0, ASP 2.0, Crystal Report 7.0, Windows

Responsibilities:

• Involved in GUI Development in VB 6.0.
• Involved in TSQL Development.
• Developed of stored procedure and all database objects.

Confidential

Project Trainee

Environment: Visual Basic 6.0, C++, MATLAB, Windows

Responsibilities:

• Worked as a trainee with Confidential Scientific project.
• Developed application on VB 6.0 and SQL.