Niveditha Shabnavees
New City,NY
Summary
Extensive experience in the areas of Database Management, Recovery Management, Production Support & Database Design / Development and QA. Experience in Performance Tuning, Query Optimization, Client/Server Connectivity. Experience in using Performance Monitor/Profiler to resolve Dead Locks/Long running queries. Expert level experience with SQL Server and T-SQL in creating database Triggers, Tables, User functions, Views, Indexes, writing Stored Procedures, query writing, user profiles, relational database models, Cursors, T-SQL batches. Hands on experience on SQL Server Analysis Services (SSAS), Reporting Services (SSRS) and Integration Services (SSIS) to manage data warehouse environment. Experienced in writing parameterized Queries for generating reports, formatting report layout, sub reports using global variables, expressions and functions in SSRS. Expertise in conceptual, logical and physical designing of a database by using top-bottom and bottom-approach and hands on experience on Data Modeling. Used Erwin 4.1. Very good in developing a Web based application using Object Oriented Design and can also maintain it. Well versed in all stages of SDLC – gathering and analyzing the requirements, converting the specifications into functional and technical design documents, coding and testing. Experience in designing Use cases, Class and Sequence diagrams using Rational Rose Enterprise Edition 2000 and UML, OOAD and J2EE Design Patterns. Ability to effectively multitask, meet deadlines, quickly adapt to different project environments and ability to work with different team sizes across geographical locations. Proven record of task achievement, excellent communication, and interpersonal, analytical and functional skills.
Overview
15
15
years of professional experience
Work History
Clinical Informatics Analyst
BronxCare Health System
10.2018 - Current
- Involved in building and configuring reports in Allscripts Application for clinicians.
- Create Stroke Patients reports for Department of Nursing
- Involved in workflow analysis and proposed necessary changes to facilitate daily hospital operations.
- Develop complex SQL logic Stored procedures, create SSRS (SQL server reporting services) reports and integrate them in Allscripts EMR for Nursing department.
- Trouble shooting issues in production for reports/printing.
- Create KPI reports for Department of Nursing like Stroke, Pain Assessment/Re Assessment and Restrains.
- Create reports to track Clinical documentation done by nurses.
- Create Performance Improvement reports for nursing department.
- Business Intelligence reports for Performance improvement are developed to understand the customer needs by using SSRS.
- Responsible for providing daily and weekly reports to the immediate supervisor and actively involved in the daily and weekly meeting to discuss project status.
- Trouble shooting all the issues in MS Reports and maintained documentation for future reference.
- Created new stored procedures and debugged the existing ones. Extensively worked on T SQL DDL, DML and DCL commands.
- Responsible for Query optimization and Performance tuning, SQL queries using Show Plans and Execution Plans.
- Test the existing reports, report any bugs in JIRA.
- TEST all Nursing reports for 22.1 Pre-upgrade, document all issues in JIRA and ensure that they work fine after Post Upgrade.
- Bronx-Care Health system is the largest voluntary, not-for-profit health care system serving the South and Central Bronx, with 970 beds at two major hospital divisions, a major psychiatric facility, two specialized long term care facilities and an extensive BronxCare Network of medical practices, including the Dr. Martin Luther King, Jr. Health Center as well as a 51-unit housing facility for seniors and low income residents.
- Environment: MS SQL Server 2005/2000/2008/2012/2016/2018,2019, SQL , SSIS, SSRS, Windows 2003/2000, Windows Server 2003, Allscripts Sunrise Clinical Manager 5.5/5.5 SP1,Dentrix Enterprise 3.7/5.0, Object Oriented Programming, Arden Syntax, objects plus programming, JIRA .
- Developed complex SQL queries to extract and analyze patient data for reporting purposes.
- Optimized database performance by implementing indexing strategies and query optimization techniques.
- Automated routine reporting processes, reducing manual effort and increasing accuracy of data outputs.
- Conducted thorough testing of SQL scripts to ensure data integrity and compliance with healthcare regulations.
- Evaluated new technologies related to SQL development for potential implementation opportunities, facilitating innovation within the team''s workflow.
- Developed custom database objects, stored procedures, and delivered application support.
- Managed database security by implementing appropriate access controls, maintaining compliance with industry regulations and company policies.
- Designed and implemented TSQL queries for reporting and complex solution development.
- Conducted comprehensive performance tuning efforts, identifying bottlenecks and implementing optimizations to improve overall system responsiveness.
- Enhanced user experience by creating intuitive data retrieval interfaces, making information access easier for non-technical users.
- Enhanced database performance by optimizing SQL queries and indexes, significantly reducing response times.
- Debugged problems caused by hardware, operating systems software, application programs and network failures.
- Analyzed clinical data to identify trends and support decision-making processes.
- Developed and implemented electronic health record workflows to enhance user experience.
PI Co-coordinator/Data Extractor
C-HIM LLC
11.2013 - 12.2015
- Involved in building and configuring reports in AdvancedMD Application for clinicians.
- Involved in work flow analysis and proposed necessary changes to facilitate daily hospital operations.
- Trouble shooting issues in production for reports/printing.
- Implemented proper workflow to handle unplanned down time.
- Developed PI reports for Nursing and physicians to monitor the staff productivity.
- Developed reports for billing department about patient’s information with their outstanding balance.
- Provide training to Physicians/Nurse about the new features in AdvancedMD 12.2.
- The Center for Hypertension and Internal Medicine (C-HIM) opened for business as a preventative care organization focused on saving patients’ time, money, and the pain of visiting the hospital. They have achieved these goals by offering a wide array of diagnostic and treatment plans tailored to each of their patient’s individual needs.
- Environment: MS SQL Server 2005/2000/2008, SQL
- LOADER, SSIS, SSRS, Windows 2003/2000, Windows Server 2003, AdvancedMD12.2.
Junior Programming Analyst
INSYNC Solutions
02.2011 - 02.2013
- Developed the presentation layer using JSPs and JavaScript.
- Used Servlets for server side implementation.
- Used Oracle 7.3 as the back-end.
- Used Oracle Thin Drivers for database connectivity.
- Developed the Client-side JavaScript to speed up the User Input Validation.
- Implemented intelligent search using the wild card queries based on the user input.
- Developed a generic framework used for building various applications.
- Extensively used EJB as Middle ware.
- Extensive development of session and entity beans.
- Led the testing team and the components development team.
- INSYNC Solutions is a software development company. It facilitates the normal workflow for its different clients by developing applications, as a programmer I was involved in creating Ecommerce application and created Learning portal.
- Environment: JDK 1.2, Web Logic Server 7.x, Eclipse 3.x, Java Swing, JSPs, Servlets, JDBC, JavaScript, SQL, JWS 2.0, Oracle 7.3,Unix.
Education
Master of Science - Computer Science
Jawaharlal Technological University
Hyderabad India11-2011
Skills
- SQL Server Tools: Enterprise Manager, Profiler, Query Analyzer, Export & Import, DTS, Replication, SSIS
- Relational Database: MS SQL Server 2018, 2012, 2016, 2008, 2005, 2000, 70, 65, MS-Access, Oracle 10g/9i/11g, IBM DB2 70
- Language: T SQL, SQL, PL/SQL, C / C, Java, J2EE, VB, VBnet, ASPnet, XML, HTML
- Operating System: Windows 95/98/Me/XP/NT/2000, Unix, DOS, Linux, Windows Server 2003
- Case Tools: MS Office 2000/XP/2003, MS Excel 2000/XP/2003, MS Outlook 2000/2003, MS Visio
- Reporting Tools: Ms SQL Server Reporting Services, Business Objects XIR2/XIR1/65
- Web design Tools: Dream weaver, Fireworks, Ms Front page
- Dimensional Modeling: Erwin 41/352/3x, Dimensional Data Modelling, Star Schema Modelling, Snow-Flake Modelling, Fact and Dimensions Tables
- Data analysis
- Project management
- Customer service
- Technical support
- Software development
- Teamwork and collaboration
- Excellent communication
QA and Project Management tools
JIRA
Timeline
Clinical Informatics Analyst
BronxCare Health System
10.2018 - Current
PI Co-coordinator/Data Extractor
C-HIM LLC
11.2013 - 12.2015
Junior Programming Analyst
INSYNC Solutions
02.2011 - 02.2013
Master of Science - Computer Science
Jawaharlal Technological University