SUMMARY

• 5+ years of experience as NextGen EHR Systems Analyst
• 8+ years of experience in planning and managing project implementation, and supporting information systems
• Hands on experience in Development, Design, and Support of Microsoft SQL Server 2008r2/2012
• Transact - SQL, Window forms, Crystal Report, and SQL Reporting (SSRS)
• Experienced in creating stored procedures, triggers, views, and other SQL joins and statements
• Experience in Software Development with Real client (SOGETI USA LLC) for software engineering course
• 1+ year of experience in Project Management/Project Management Methodology
• Customizing, Configuring, Implementing, Testing, Documenting & Supporting Ambulatory EMR
• Proficient in database build, report design, training, go-live support, and problem solving
• Project planning, training, and implementation experience
• Worked on ETL process using SSIS package
• Experience in SQL Server SSIS (Integration Service) package design, constructing, and deployment
• Experience in creating packages to transfer data between ORACLE, MS ACCESS and FLAT FILES to SQL SERVER using SSIS
• Proficient in defining Query for generating drill down reports, tabular reports, matrix reports, sub reports in SSRS 2008r2/2012
• Implement best practices in data visualization dashboards & Reports using various BI tools
• Experience in designing and developing applications using .NET Framework
• Excellent analytical, communication and interpersonal skills
• Proficient in technical writing and presentations and a good team player
• Ability to work independently or as part of a team to accomplish critical business objectives and to make decisions under pressure
• Developed a Courier Management System - a web application created for courier companies to automate their business workflow and process
• Designed system using Model-View-Controller (MVC) paradigm
• Implemented the design integrating ASP.NET MVC 4.5 with Entity Framework
• Updated and upgraded code based on test results
• Submitted reports on weekly basis
• Presented and successfully defended the final report and demo of the web application

TECHNICAL SKILLS

• C, C++, .NET, Python, R
• MS SQL Server 2008 R2/ 2012
• Oracle 10g/11g
• MS Access
• PHP, MYSQL
• JavaScript, jQuery
• Angular JS, Mobile development
• ASP.NET MVC
• HTML, CSS, WordPress
• XAML, LINQ, XML/XSL, SOAP, SOA, WCF, and Web Services
• Crystal Report
• SSRS (Reports)
• SSAS, SSIS
• Windows, OpenSUSE
• Kali Linux, Ubuntu
• Apple iOS, MAC OS
• Microsoft Office 365/2013/2010 , Visio 2013
• Adobe Photoshop, Adobe Illustrator
• Visual Studio, SQL Server Management Studio
• Asterisk, Payment Gateway

PROFESSIONAL EXPERIENCE

Confidential

Software Developer/Consultant

Responsibilities:

• Developed software and/or web applications to meet business/user requirements
• Analyzed user and business requirements and prepared technical specifications from all relevant stakeholders
• Collaborated closely with programmers and analysts to develop and add applications to systems
• Developed new modules based on the specifications
• Conducted tests and fixes on a variety of reported bugs
• Performed unit testing, system testing, and regression testing for changes
• Developed test cases and script files to test the system
• Documented test plans and test results
• Created script files to implement the changes in production
• Participated in meetings to discuss about various topics such as requirement analysis, deciding on design and architectural styles, choosing programming language, implementing codes, testing, performing analysis, and evolution/maintenance
• Provided production support for various types of system and/or website projects
• Experienced designing conceptual data models, entity relationship diagrams and business process models
• Transformed and cleansed data using tools such as SQL, Python, or R
• Dashboard management and creating Use-Case and UML diagrams
• Established relationships and developed understanding with technical and non-technical team members
• Learn new strategies and trends to train about analytically, technically, and technologically

Confidential

IT Manager

Responsibilities:

• Researched new developments and uses of current systems and applications, as well as upgraded systems and applications to meet HIPAA standards
• Identified requirements on existing/proposed systems analyzing applications, programming, and operations prioritizing needs and getting solutions delivered
• Experienced in the ambulatory provider setting
• Implemented System Development Life Cycle to ensure all necessary steps for planning, creating, testing, and launching of the system
• Implemented clinical workflow and systems integration with thorough understanding
• Involve with Project Management supervising projects from beginning to end; directed and guided the implementation of projects; ensured optimum quality design, timeliness, cost effectiveness, and supportability of implementation
• Configured NextGen system for different practice systems
• Experience in writing T-SQL code, dynamic SQL, functions, triggers and complex joins and sub queries in SQL Server Management studio (SSMS) 2012
• Worked on Mobile and Digital Analytics to help clients make data-driven decisions
• Appended related queries to single query to analysis the data
• Developed stored procedures, views and User Defined Functions using T-SQL statements
• Wrote new Stored Procedures for new system and optimized old Store Procedures and Functions on Production Server
• Designed and developed SSIS ETL processes (SSIS 2008/2012)
• Experience in SSIS script tasks, look up transformations and Data flow tasks using T- SQL, C#, and Visual Basic scripts
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse
• Created SSIS packages using Data transformations like Conditional Splitting, For Each Loop, For loop
• Implemented ETL process to download files by email attachments and import data into Data warehouse system through SSIS packages
• Designed and Developed matrix, tabular and parametric Reports using SSRS 2012
• Designed and developed databases for OLTP and OLAP Applications
• Developed, scheduled, and generated variety of reports like List, Matrix, Drill-Down, Chart and Sub Report and standardize company report by implementing SQL Server Reporting Services (SSRS)
• Developed reports in Tableau, Crystal and converted Crystal reports in to SSRS reports
• Implementing SSRS solutions, used dashboards and gauges to enhance for the business users
• Scheduled Jobs according to the frequency of files so that data is loaded into database in a timely manner
• Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports and Dashboards
• Designed SSRS reports with sub reports, and prepared Ad-Hoc reports through report builders
• Implementing SSRS solutions, used dashboards and gauges to enhance for the business users
• Designed and developed Drill down and Drill Through reports with Drop down menu option using SSRS
• Maintain and optimize the existing databases; monitor database performance and growth, performance tuning, generate reports per the business requirements using SQL Server Reporting Service (SSRS) and populate data warehouse using SQL Server Integration Service (SSIS)
• Deployed and scheduled reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including status
• Developed SQL queries and stored procedures to retrieve data for creating reports from NextGen EHR and EPM using SQL and Crystal Report
• Created reports using SQL Query, Crystal Report and SSRS reports
• Responsible for monitoring and tuning SSRS Report Performance
• Formulated reports using simple to complex SQL queries i.e. Joins, Sub-queries, CTE’s techniques
• Expert in generating Sub Reports, Cross Tab Reports and Graph Reports by using Crystal Reports
• Created Interactive dashboards on Healthcare and Insurance data using Power BI
• Created Roles and implemented Row level security for user Authentication in POWER BI
• Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources
• Configuring Power BI Gateway for SSAS Live connection and Direct Query
• Utilized Power BI (Power Pivot/View) to design multiple scorecards and dashboards to display information required by different departments and upper level management
• Implemented clinical workflow, systems integration, HL7 interface and security
• Performed maintenance duties such as performance tuning, query optimization, and stored procedures
• Reviewed current workflows & system functionality, assisted with issue resolution, and created recommendations for enhancements and/or break/fix issues
• Applied knowledge of HIPAA/HITECH in regulating health compliance and protecting patient information
• Built and modified EMR system to meet Meaningful Use and PQRS regulatory requirements
• Planned, organized, and coordinated NextGen implementation, upgrades, hotfixes and patches as per organizational need
• Configured and implemented other NextGen modules like Patient Portal, HQM, Rosetta interface to meet Meaningful Use and PQRS regulatory requirements
• Documented Business Continuity and Disaster Recovery with respect to NextGen EMR, ensuring that in case of a disaster the system would be able to perform all critical function
• Identified, reported and resolved network problems and security violations involving hardware, software, and communications issues
• Maintained network performance by performing network monitoring and analysis, performance tuning, and troubleshooting network problems, and maintaining documentation
• Installed, configured, tested, maintained systems and applications as well as managed created disaster recovery and business continuity procedures
• Worked with Active Directory, Exchange Environment, Group Policy and provided end user support
• Created custom instructional documentation platform using Documents Builder as required by medical staffs, doctors, and nurses for medical and clinical procedures
• Worked with Microsoft Office products, Novell, Linux Operating Systems, and Oracle PL/SQL
• Worked with CISCO routers and switches, Managed Cloud VoIP Systems and EBR & Bar Code
• Trained providers, administrators, staff on implementation and use of NextGen EHR, EPM and ICS
• Collaborate with end users from various departments (Clinical and Senior Management) to gather report requirements, ensure proper testing, validation and identified opportunities for improvement on Clinical\business operation and workflow process
• Delivered agile projects that provide exceptional business value to users
• Integrated ASP.Net MVC 4.5 with Entity Framework to design and build web application and implemented new features or enhancements
• Planned and organized Agile Scrum project developments to achieve high level of performance
• Experience with agile methodologies and tools such as confluence and Jira interfaces and product integration
• Worked closely with vendors and internal organizations staff to support success and growth of the company
• Keenly participated in company meetings to overcome daily problems and maximize daily functions

Confidential

NextGen EHR Systems Analyst

Responsibilities:

• Customizing, configuring, implementing, testing, documenting & supporting NextGen Electronic Medical Records (EMR), Enterprise Practice Management (EPM), Imaging Control System (ICS) & KBM modules
• Implemented new projects for practice where the NextGen KBM could not meet the client’s needs or workflow.
• Planned, organized, directed, and coordinated structured, semi-structured and unstructured medical record data using relevant informatics methods for NextGen Electronic Medical Record Systems during development and implementing phase
• Identified database requirements on existing and proposed systems, analyzing applications, programming, and operations with database design and functionality using DBMS language, Data Profiling, Data Design and Architecture
• Strong functional experience in customizing, configuring, implementing, testing, documenting & supporting NextGen EMR, EPM, ICS modules
• Designed and implemented completely new Templates (Template Editor) and Documents (Document Builder) in which NextGen KBM templates did not meet the client’s workflow system
• Set up Universal Preferences, Password Requirements, and Provider Approval Que (PAQ), KBM template sets and maintained users’ access & rights
• Management of IT implementation projects/applications and Radiology workflow such as RIS, PACS, or EMR/EHR
• Configured NextGen system at System, Enterprise, Practice, and Location levels
• Managed Patient Portal features such as Online Practice Setting, Online Forms Publisher, Message Routing and enrolling patients
• Edit/Add new information using File Maintenance for SIM Library, payers, providers etc.
• Designed and developed SQL server agents to automate SQL scripts for internal and external clients
• Planned, organized, and coordinated NextGen implementation, upgrades, hotfixes, and patches as per organizational need
• Configured and implemented other NextGen modules like Patient Portal, HQM, Rosetta interface to meet Meaningful Use and PQRS regulatory requirements
• Designed and implemented completely new Pain Management template model for which NextGen KBM templates did not meet the client’s workflow system
• Ensured system usability, scalability, extensibility of the operation and business flow with complete and correct understanding
• Configured NextGen system for different practice systems
• Performed data extraction and documented reports using Crystal Reports and Microsoft SQL Server
• Maintained users’ access & rights using different NextGen modules, added and modified new information using System Administrator and File Maintenance respectively
• Created custom instructional documentation platform using Documents Builder as required by medical staffs, doctors, and nurses for medical and clinical procedures
• Coordinated with Electronic Health Record users to assess clinic needs and objectives
• Administered servers, computers, printers, routers, software deployment, system updates and patches
• Trained providers, administrators, and clinical staff on use of NextGen EHR, EPM and ICS module
• Worked effectively with physicians, nurses, and clinical staffs to solve problems related to EMR and to make software more user-friendly to staff and doctors