Software Developer/consultant Resume
2.00/5 (Submit Your Rating)
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