• A Software Developer and BI Consultant for 4+ years in Software Development Life Cycle (SDLC), Business Analysis and Modeling, Functional Requirements Gathering and Analysis and collaborating with Technical Teams in preparing System Design Document (SDD). • Business Process Reengineering in Health Care Sector with prime focus on Membership, claims adjudication, migration, provider, eligibility and prior authorization for Medicaid and Medicare programs. Recent assignments include working with Payer Organizations (Insurance Companies) on upgradation projects (ICD-9 to ICD-10; FACETS). • Knowledge in requirements gathering, analysis, preparing technical and program specifications, coding, development, code review, coordination with stakeholders, production promotion and post-production support. • Manage internal databases, from planning and testing stages through implementation and support. • In-depth understanding of security and backup procedures to ensure database integrity. • Superior communication, presentation, analytical and problem solving skill. Work well with all levels of business. • Skillful in handling the critical business requirements by providing quicker and better solutions. • Proficiency in analyzing and translating business requirements to technical requirements and architecture. • Responsible for business analysis for improvement through the use of data analysis and performance trending. • Good Knowledge in writing SQL queries/ procedures in different RDBMS systems and Performance Tuning. • Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces. • Design, develop and test automated reporting solutions using various reporting tools and database platforms. • Responsible for establishing and maintaining business relationships with key stakeholders and providing reporting solutions to meet organizational objectives. • Worked in Release Management team as Release and Configuration Manager. • Knowledge using Oracle, as well as advanced SQL in a large scale data warehouse environment. • Create business and associate level reporting from concept to implementation to include scope, definition, design and development through various programming software like MS SQL, Crystal Reports, and the Microsoft Office suite of applications. • A good deal of Knowledge in SAP Crystal reporting, SQL Server Reporting, SSRS, Data Transformation Services. • Experience with Hadoop and bigdata. • Detailed knowledge of the full software development life cycle. • Used incident tracking system JIRA and Footprints to document changes made and progress. • Ability to automate data retrieval and storage processes. • Knowledge in preparing Test Strategy, developing Test Plan, Detailed Test Cases, writing Test Scripts by decomposing Business Requirements, and developing Test Scenarios to support quality deliverables. • Ability to function in a