SUMMARY:

• 7+ years of IT experience with a strong background in Business analysis, Database design and development, Quality Assurance, Data Science in Health Care, Insurance and mobility domains utilizing RDBMS, Oracle, Mainframes, DB2, My SQL, SQL Server
• Experience leading long - term projects requiring full life cycle management, in progress review presentations, and management of development personnel in aggressive & fast-paced environments. Repeatedly brought high profile projects to completion on schedule.
• Experience in ETL, Batch integrations, OLTP, OLAP & Data Warehousing Systems environments for business products, operations and Information Technology implementation.
• Excellent Functional Analysis skills in Healthcare Benefits Administration, with good experience in Change management, Release management, HIPAA standards, Medicare.
• Adept at interfacing with end users to gather requirements and produce technical, functional and non-functional requirements; Strong Customer/User advocate
• Experience in Physical & Logical Data Modeling using ERD Diagrams, UML Modeling, Use Case analysis
• Developed Test Strategy, Test Plans, Test cases for the adjustment application using Black Box/ GUI/ Functionality/ Regression/ System/ Stress/ Performance/ UAT
• Experience working in Unix Shell Scripting environment to analyze and provide solutions to integrate the changes needed and suggest the best practices for different projects
• Advanced Proficiency in manipulating and transforming data in MS Excel .
• Good working knowledge of the Software Development Life Cycle (SDLC), Agile methodologies and Rational Unified Process (RUP).
• Proficient in analytical, Collaboration, Communication, Decision-making, and Organization skills.
• Excellent rapport with the team members and maintains an inspiring environment

TECHNICAL SKILLS:

Languages: VB, C, C++, Java, COBOL, PL- SQL, Oracle D2k Forms 6i, Unix Shell Scripting, Oracle

Operating Systems: UNIX, Windows, Sun/Solaris

Databases/RAD Environment: Oracle (11g, 10g, 9i), DB2, Access, SQL Server 2000 and 2005, MS Access

Tools: Toad for oracle, SQL Developer, QTP, HP Quality Center, Rational Rose, UML, MS Visio

PROFESSIONAL EXPERIENCE:

Confidential

Database Development Lead/ Senior Business Analyst

Responsibilities:

• Gathered business requirements thru interviewing clients, stakeholders and Subject Matter Experts(SME’s)
• Worked on Database programming in writing Dynamic-queries, sub-queries, Complex joins, Stored procedures, Cursors, Ref-cursors, Functions, Packages, Triggers, Constraints, and Indexes using various DDL and DML commands
• Analyzed, synthesized and documented business requirements as specifications for development teams; Working knowledge in parsing and loading data using sql loader, oracle XML packages
• Led the team in implementing Normalization/De-normalization techniques for optimum performance
• Led the team in assessing resource deadlock issues and implementing queries without conflicting scenarios
• Analyzed data input process to determine cause of duplicated records and developed process to remediate duplicates and methods to prevent further duplication.
• Analyzed client data and determined best methodology for determining patient primary prescription control flow; Created batch jobs, ETL processes, SQL scripts with strip table procedures, TOAD query cost profiling and analysis, archiving data by working with DBA teams
• Good knowledge of data marts, data warehousing, adhoc reporting, operational data store (ODS), OLAP, data modeling like dimensional data modeling
• Developed and created UML diagrams such as activity diagrams and sequence diagrams.
• Designed data flow diagrams (DFD’s) and entity relationship diagrams (ERD’s) in Rational Rose and MS Visio using existing documentation.
• Serve as primary point of contact for junior engineers and QA teams to resolve issues and clarify requirements, facilitate scrum meetings
• Test & Deploy code across various SDLC Environments like TEST,UA/UT/Production Managed schedules and collaborated with different teams working on the project
• Assisted with required data analysis, interpretation, correction and document presentation for various assignments.
• Coordinated team members work on complex assignments while completing additional assignments
• Maintained good lines of communication with internal as well as external customers, including sales representatives, project managers.
• Owned the features from its inception phase to the completion phase.
• Extensively gathered requirements from all users, experts and key personnel to understand the current functionality of the existing system.
• The system included the ability to scan the initial form and store it to a DB2 database and generate a report of any data violations.
• Assisted in modelling and documenting the user’s AS-IS work flow and TO-BE business process.
• Analyze business requirements and segregated them into high level and low level Use Cases, sequence & activity diagrams using UML methodology.
• Involved in documentation in various stages of the product life cycle.
• Developed a Checklist procedure to quickly find the problem area and the related programs and database tables to check for inconsistencies.
• Created and executed various queries in SQL databases
• Designed and developed the automation of a scalable consistency checker of mandatory attributes for various health plans.
• Reporting the Daily, Weekly and Monthly status of the team to the higher management.
• Developed a maintenance system to allow the users to view and correct the scanned data. The system also included a generic report writer and several canned statistical reports.
• Identified opportunities for business process improvements and initiated efforts to make them possible.
• Developed test plan based on the business requirement document, design document.
• Started leading a project for migrating from DB2 to Oracle DB
• Worked with clients, development teams and QA to develop and execute UAT plans.
• Worked actively in bringing the clients onboard the CVS/Caremark plan setup system.
• Involved in documentation in various stages of the product life cycle.
• Available as Single point of contact from our team to the transition team for all technical questions and new feature requests.
• Responsible for offshore-onsite coordination
• Preparation of Functional Spec as per the requirements.
• Schema Creation, Data Configuration, Data upload and Conversion related Activities
• Researched and Diagnosed reported issues with data and applications, using query and reporting tools as needed.
• Instrumental in ensuring DBA team maintains high availability of the database exploiting the concepts of CLUSTERING, REPLICATION
• Defined and Developed ad hoc reports using query reporting tools like Toad for Oracle, both for clients and internal use
• Developed test plan based on the business requirement document, design document.
• Created necessary test data according to the scenario.

Confidential, Bannockburn, IL

Senior SQL Developer / Analyst Application Developer

Responsibilities:

• Had expertise in resolving tickets with quick turnaround times in high priority tickets.
• Maintenance of Database, inserting, updating records.
• Created and executed various queries in SQL databases.
• Researched and Diagnosed reported issues with data and applications, using query and reporting tools as needed.
• Defined and Developed ad hoc reports using query reporting tools like Toad for Oracle, both for clients and internal use
• Created necessary test data according to the scenario.
• Responsible for Creating tickets, assigning and finding the root cause to the tickets using the Heat ticket tracking system.
• Ownership on all the tickets related to the major clients like Coventry, MEDD, and Motorola.
• Involved in documentation in various stages of the product life cycle.
• Experienced in working with SQL Loader and creating imports and Exports for large volumes of data.
• Helping DBA Team in setting up Initialization Parameters
• Managing Data files and Control files
• Helping DBA Team in Creating and maintaining table spaces by providing Business domain context and user data model hierarchy for enterprise level categorization
• Loading non-Oracle data converting into the Oracle database using SQL loader.

Confidential

Analyst

Responsibilities:

• Participated in the development of appropriate syllabuses and materials.
• Assisted the teachers in planning the lesson plan.
• Actively involved in curriculum review and development.
• Created several hands-on math units like vegetable math and pebble math to promote higher order thinking.
• Created and implemented mock tests for students to prepare students for the year end exams.
• Liaison between the Public school teachers and the volunteer teaching staff in the organization.