RENEESH PRABHA

Thorough SQL Developer with expert grasp of SQL code generation, analytics, reporting and business intelligence. Diverse knowledge of complex T-SQL coding instances. Conversant in up-to-date and legacy programming languages, standards and tools. Adept in leading all stages of software development and troubleshooting.

• Xerox Services Manager (XSM), 2014-Sep Till date, Xerox, Kochi, SQL Server, Xerox Services Manager (XSM) is a web-based asset tracking and management application that provides a single point of management for all service-related incidents and helps organizations better understand and manage output costs. Its incident management component enables Xerox Authorized Managed Print Services Partners to track all service and support-related activities, improving output/performance and increasing device and end-user productivity.
• Xerox Managed Print Services(MPS), 2014-Sep Till date, Xerox, Kochi, SQL Server, Xerox Managed Print Services uses comprehensive security, analytics, digitization and cloud technologies and software to deliver a more seamless work experience across paper and digital platforms. Our core set of Managed Print Services (MPS), including workplace assessments, device management, and print management, are complemented with digital transformation capabilities
• Wynsure, 2014-Feb 2014-Till date, MphasiS Wyde, Wyde, AIG, SQL Server 2008 R2, MphasiS Wyde has developed Wynsure, a premium, comprehensive and flexible IT solution for Insurance industry which is used by many of the leading insurance carriers in North America and Europe. Wynsure is a modern end to end platform used by clients to transform their business with greater efficiency. Wynsure comprises eight independent and consistent modules across Property and Casualty, Disability, Health, Hybrids, Annuity and Life Insurance. It is an international solution which is open to all insurance actors in all business lines. With its highly sophisticated technical foundations and extremely powerful rules engine, Wynsure is easily customizable to meet your specific needs. My Role: Working closely with client on Index tuning, Tsql and stored procedure tuning Taking care of on database administration activities. Performance tuning SQL Server. Developing stored procedures/Tsql scripts/Triggers as per client’s requirements.
• ProSystem fx Engagement, Feb 2013-Jan 2014, MphasiS an HP Company, CCH, a Wolters Kluwer business, US, SQL Server 2008, Visual Studio 2008/2010, TFS 2010/08 Rally's Agile project management tools, CCH (www.cch.com) is a leading provider of tax and accounting information, software and services. It has served tax, accounting and business professionals and their clients since 1913.CCH’s ProSystem fx Engagement is designed to be used as an integrated part of the vendor’s comprehensive suite of professional accounting, tax and practice management systems, providing advanced workflow tools, collaboration capabilities, automation of tasking, integration with external programs and strong oversight for audit managers. The system includes the core features found in CCH’s trial balance solution, and shares data with tax, accounting, document management and other applications. My Role: Working as a Lead database developer. DB Requirement analysis and database development. Working closely with client as part of Agile team. Design/creation/implementation of database objects. Performance tuning SQL Server. Developing stored procedures/Tsql scripts/Triggers as per client’s requirements.
• Jiva, Aug 2008-Aug 2012, ZeOmega, SQL Server 2005/2008/2008 R2, Oracle, Red Gate SQL Data Compare, Red Gate SQL Compare, DB Ghost, Oracle SQL Developer, TortoiseSVN, Bugzilla, ZeOmega is a leading provider of software for integrated care management. Jiva, the integrated care management solution, transforms traditional episodic-based care management into proactive and collaborative population healthcare management through electronic health record (EHR)-enabled care plans, point of care tools, decision support, and user-configurable workflows for care management. And our portal services connect stakeholders to ensure seamless care and collaboration. An integrated real-time rules-driven workflow application that promotes transparency between Utilization Management, Care Management and Disease Management functions. Integrated workflow for health, wellness and lifestyle support programs complemented by content from health risk assessments and clinical protocols and business rules. Deliver personal health records, patient decision aids, health management tools, clinical content for health education, and decision support tools at the point of care. Exchange data with external systems, consolidate information across disparate data sources and present this information through web services to physicians, members and care managers. My Role: Writing T-SQL Scripts, Stored Procedures, User Defined Functions, Cursors, Views and Triggers. Product development and implementation. Design/creation/implementation of database objects. Database Implementation activities as part of Product Implementations. Database designing based on client's requirements. Product development. Performance tuning SQL Server. Developing stored procedures/Tsql scripts as per client’s requirement. Preparing build script for new implementation of the database at the client site. Database testing. Conversion of SQL Server scripts to Oracle scripts. Working in migration projects - preparing migration scripts. DBA activities. Training for new employees. Knowledge in Health care domain, HIPPA and Healthcare Coding Standards.
• AUTH Export 278 Updates and extensions Interface, Jan 2010-Nov 2010, ZeOmega, SQL Server 2005/2008/2008 R2, Oracle, Red Gate SQL Data Compare, Red Gate SQL Compare, DB Ghost, Oracle SQL Developer, TortoiseSVN, Bugzilla, Auth export 278 interface receives Patients/Physicians billing data from text files, processes it, and transfers it to database tables. An auth satisfying the 278 extract selection criteria selected for export, if the validation is successful, then the auth record is marked status “EXPORTED”, if unsuccessful then “ERROR. and are sent to Xcelys system. My Role: Writing Stored Procedures, T-SQL Scripts, User Defined Functions, Cursors. Export procedure development/testing. Design/creation/implementation of database objects.
• Jiva Migration Projects, Jan 2009-Nov 2011, ZeOmega, C3, Ohio, CHP & Niveda, SQL Server 2005/2008/2008 R2, Oracle, Red Gate SQL Data Compare, Red Gate SQL Compare, DB Ghost, Oracle SQL Developer, TortoiseSVN, Bugzilla, Migrating the live Jiva product to the latest versions My Role: Comparing DB schema differences and taking care of data migration tasks. Taking care of data mapping and referential integrity. Writing T-SQL Scripts, Stored Procedures, User Defined Functions, Cursors. Planning/Development/Testing/Executing of migration scripts. Migration Analysis. Addressing/fixing client issues/clarifications.
• Customer Asset Management, Sep 2012-Dec 2012, PwC, Cisco, SQL Server 2008, Data has to be migrated from the existing legacy system (a .NET application) to the new system on SAP. The data has to be available in the new Vantive and CADS DBs(SQL Server) as well for reporting purpose My Role: Worked on Database Development/Data Analysis tasks.
• Correspondence Configuration Engine, The Correspondence Configuration Engine (CCE) a versatile tool that enables to generate letters/notices with patients specific information by using its integrated word-processing tool. My Role: Writing T-SQL Scripts, Stored Procedures, User Defined Functions, Cursors, Views and Triggers. Performance tuning. Addressing/fixing client issues/clarifications.
• System Administrator Module, Facilitate system administrator to Manage internal/external user accounts, Configure internal user roles, Reset user passwords, Unlock user accounts, Manage user teams & Activate User My Role: Writing T-SQL Scripts, Stored Procedures, User Defined Functions, Cursors, Views and Triggers. Performance tuning. Addressing/fixing client issues.
• Member Search, Member search enables the user to search details such as Patient’s Personnel details, Contact details, Client(TPA) name, Insured employer name, Insurance type, policy number, Physicians details, Benefit Details Race & Ethnicity Details My Role: Writing T-SQL Scripts, Stored Procedures, User Defined Functions, Cursors, Views and Triggers. Performance tuning. Addressing/fixing client issues/clarifications.
• The Galaxy Series, Aug 2005-Aug 2008, SQL Server 2000/2005, The Galaxy Series is comprised of data acquisition, transformation, presentation and administration components. My Role: Implementation of Production Databases & Non-Production Databases Implementing upload DTS packages and Upload Directory Structure. Setting up Interfaces to download data from Meditech to Upload Directory. Fix data exceptions and upload the data using upload DTS package to production databases. Setup various jobs and triggers at Galaxy sites that pages if there is any error during the uploads. Maintenance and post-production support.
• Galaxy Administration, SQL Server 2005, DBAs can effectively monitor downloads and can stay informed as to how current their data are. My Role: Backend development of Galaxy Administration website using SQL Server 2005 Implementation and configuration of Galaxy Relationship website using DNN modules at the client site.
• ASTRO Interface Engine, It allows authorized users to deploy and manage interfaces at the site My Role: Backend Creating Interfaces to download data from Meditech.
• Galaxy Upload Manager, Galaxy Upload Manager (GUM) is used to upload data into Galaxy tables using DTS package. My Role: Creating DTS packages using GUM. Implementing, scheduling, and supporting SQL Upload jobs.
• Datamarts, Repository of data gathered from operational data that is designed to serve a particular community of knowledge workers. My Role: Implementation, Enhancement, Maintenance of Financial, Payroll, Materials Management Datamarts. Datamart purging as per client request. Responding to clients queries/issues regarding data discrepancy.