SUMMARY:

• Accomplished US citizen software engineer with experience in the full life cycle of the software development process (SDLC) including requirement definition, prototyping, design, interface implementation, testing, and maintenance
• Extremely well adept in working with onshore - offshore business model and excellent work productivity in a geographically dispersed team
• Extremely efficient in working remotely and extensive work experience in a geographically distributed / virtual teams
• Strong knowledge of and experience in analysis, database design, coding, testing, and implementation of Microsoft.NET applications including ASP.NET web applications, Microsoft Business Intelligence stack -- SSIS, SSRS and SSAS 2012
• Strong knowledge of and experience in Healthcare vertical and its associated concepts, tools and techniques, including but not limited to Quality Programs, HL7, CDA, HIPAA, CDA submission to Center for Disease Control CDC / NHSN etc

TECHNICAL SKILLS:

Databases: SQL Server 2012/2008/ 2005 , SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS)

Languages: C#, ASP.NET, Web Services, AJAX, JQuery, Kendo UI

Operating Systems: Windows Server 2003/2000/XP, Linux, UNIX

Software: Visual Studio.NET 2013/2008, IIS, Visual Source Safe, SVN, Office (Word, Excel, Outlook), Adobe Acrobat, MS Visio, Bugzilla,

PROFESSIONAL EXPERIENCE:

Confidential, Lowell, Massachusetts

Consultant - Business Intelligence/ Healthcare Analytics

Responsibilities:

• Involved in development of reports / database components for measuring performance of Eligible Providers (EP) submitting patient data for quality programs such as PQRS
• Involved in the development and support of end-to-end solution provided to the Iowa Medicaid Enterprise (IME), XEROX being the project coordinator, that enabled IME to enroll EMRs / Health Home Providers in their Health Home and or Meaningful Use Quality Programs and CCDs submitted would trigger measures to which providers had subscribed to, which would eventually be used to measure the performance of providers and to display them in sophisticated SSRS reports.
• Created several SSRS reports for hospitals and clinicians.
• Wrote C# Assembly to extend functions in SSRS.
• Created a custom rendering extension that enhanced our company’s capability of rendering clinical document (CDA) to end user in a way that provided rich user experience that was not possible with OOB capabilities of the SSRS reporting server
• Created multiple ETL packages in SSIS to populate Staging and Data Warehouse Dimension and Factless tables.
• Encrypted XML document nodes using SQL Server Encryption Libraries.
• Extracted data from large XML documents (HL7 CDA 3.0) in script component using C#.
• Wrote basic MDX queries to retrieve data from the cubes.
• Involved in development of web application of clinical surveillance system (CSS) where real time surveillance of infectious diseases is carried out by one of the premier hospital in the state of New York. This also includes a medication management module and CDC / NHSN reporting of identified infections using the CDA document. This has a work flow built in - whereby “forms” for identified reportable events to NHSN, undergo different states till the time it is ready to be submitted in the form of a CDA, clinical document based on HL7 standards, generated by MARC-HI Everest Framework, which is a sophisticated .NET / Java framework for generating clinical documents to be shared across different entities based on HL7 standard
• Involved in deployment of BI components on AWS
• Competence and leadership acknowledged by engineering management and made Scrum Master of a Rapid Response Team

Environment: AWS. C#, .NET, ASP.NET, MVC, JQuery, Kendo UI, SSRS, SSIS, SSAS, HL7, CDA, JIRA, HIPAA

Confidential

Consultant

Responsibilities:

• Managed and coordinated several integration projects that lead to expansion of e-Services being offered by the Department.
• Managed numerous Bank Integration projects thereby allowing the Department to expand its e-Payment services. Inclusion of different banks for e-payment has led to the collection of several millions of Rupees electronically.
• Revised Detailed Project Report (DPR) to address local needs of the project and for re-appropriation of funds
• Evaluated and recommended appropriate hardware for the Department
• Managed and coordinated activities of different vendors including that of TCS, Tulip Inc. etc
• Evaluated and approved different change request proposals for the existing system

Environment: J2EE, Oracle 11g, Unix, MS Office ( Word, Excel, PowerPoint)

Confidential, Richardson, TX

Sr. Software Developer

Responsibilities:

• Elicited new requirements and sought clarification on existing set of requirements
• Developed reports using SQL Server Reporting Services 2008
• Created stored procedures and other database objects for the SQL Server
• Created SSIS package for data migration
• Coordinated project activities including creation of functional specification
• Provided development of web pages for ASP.NET work flow applications that included creation of complex web forms and user controls
• Developed different classes of data access and business layers of the application in the n-tier architecture
• Fixed issues in existing ASP.NET web pages using Visual Studio 2005/ 2008
• Developed intranet portal utilizing Microsoft SharePoint Server (MOSS) 2007 technology

Environment: Visual Studio 2005/2008, .NET 2.0/ 3.5, ASP.NET, C#, SQL Server 2008/ 2005, Oracle 10g, AJAX, JavaScript

Confidential, Roseland, NJ

DBA/ Software Engineer

Responsibilities:

• Enforced change management procedure for database development
• Administered project database development. Maintained and managed database development including data release process
• Designed and developed a .NET utility that performs database scripting for development submission. The utility also includes administrative tasks such as scripting database schemas and foreign key definitions.
• Implemented and maintained database security
• Created and incorporated SQL Server Reporting Services reports into existing web application as well as developed reports in Business Intelligence Development Studio (BIDS)
• Provided custom development for company products
• Created web services to enable access to the system from external sources
• Created stored procedures, functions, views and triggers
• Created, modified, and updated component (conceptual, functional, and design) specifications and documentation for modules within our product and development system
• Enhanced and fixed issues in dynamic ASP.NET pages using Visual Studio.NET 2003/2005
• Set up Team Foundation Server for collaborative software development environment
• Researched new technologies and prepared reports on their feasibility and appropriateness for the company

Environment: Visual Studio.NET 2003/2005, ASP.NET, VB.NET, C#, SQL Server 2000/2005, Visual Source Safe, Crystal Reports, HTML, SQL Server 2005 Reporting Services, XML Web Services (WSDL)

Confidential, Parsippany, NJ

Member of Technical Staff

Responsibilities:

• Migrated Sybase ASE12 database to Oracle 10g database using the Oracle Migration Workbench.
• Administered Oracle 10g database in Linux environment
• Data manipulation, validation and updating the tables in Oracle 10g and Sybase ASE 12 databases.
• Extensively worked on stored procedures, triggers and view in Oracle 10g
• Designed the Test Plans and Test Scenarios according to user requirements, which also involve creating ER Diagrams and Dataflow diagrams
• Developed and Enhanced the FIX Message Generator in Java using swing components
• Set up cron jobs in the Linux server to automate tasks such as starting of processes by creating shell scripts
• Strong understanding of FIX protocol used by leading Equities, Options, and Futures Exchanges in the US, e.g. NYMEX, NYBOT.

Environment: Java, Oracle, Sybase, Linux, VC++ 6.0

Confidential, Livingston, NJ

Intern: Information Security

Responsibilities:

• Assisted Information Security department in its efforts to make the Confidential Inc. compliant to Sarbanes-Oxley (SOX) requirements
• Environment: Proprietary Compliance system with Oracle at the back end, Windows