SUMMARY:

• Around 4 years of extensive experience in Design, Development and Maintenance in Healthcare, Retail, Financial and other Software companies on Oracle Databases, SQL Server, MySQL and Reports.
• Good knowledge over the entire Software Development Life Cycle (SDLC) that includes requirements gathering, functional and technical specifications, design, development, testing and production deployment.
• Experience with multiple RDBMS including Oracle 12c/11g/10g, Microsoft SQL Server 2008, MySQL and associated SQL Dialects such as PL/SQL, Transact SQL (T - SQL), MySQL.
• Proficient in creating Tables, Views, Packages, Procedures, Functions, Exception handling Views, Triggers and various other Database Objects.
• Proficient in Analyzing data sources and creating interface documents and proficient in Dimensional and Relational Database Management Systems.
• Experience withData flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modelinganddesign techniques
• Query relevant data from databases, such as Oracle, Microsoft SQL server, using complex Structured Query Language (SQL), manipulate large unstructured and structured datasets to build insightful solutions to complex problems, and present the results in visually engaging and intuitive reports and dashboards.
• Collect, maintain, manage, interpret and analyze data received from internal and external data sources
• Hands on experience in interacting with Business User and Business systems analysts to understand the requirements and documenting the Functional Requirement Document and Technical requirement documents.
• Experience in all phases of Data warehouse development from requirements gathering for the data warehouse to develop the code, Unit Testing and Documenting.
• Strong Knowledge in ETL processing of Designing Workflows, applying Transformations in Informatica Power center tool and Data Services tool.
• Knowledge of statistics and experience using statistical packages for analyzing large datasets (Excel, SPSS, SAS etc)
• Hands on experience on Resolving helpdesk database tickets and production support
• Strong knowledge of and experience with reporting packages (Business Objects etc), databases (SQL etc), programming (XML, Javascript, or ETL frameworks), object oriented programming using C++, JAVA, Pro*C
• Strong Trouble-shooting, Problem solving, Analytical & Design Skills and ability to quickly master new software and adapt to changing needs
• Excellent communication, interpersonal and versatile team player with problem solving skills.

TECHNICAL SKILLS:

Frontend: Oracle Developer Suite 11g, QNXT, Reports Builder 10g, SQL * Loader, XML Publisher, QC, Informatica PowerCentre 9.6

Programming: SQL, TSQL, XML, HTML, PL/SQL Bash & Korn Shell Scripting, C/C++, Java

Database: Oracle 10g/11g/12c, MS Access 2000/2002, SQL server 2008, MySQL

Third Party Tools: TOAD 12.5/10.2, PL/SQL Developer, SQL Navigator, Putty, Informatica, MS-Office 2010, Microsoft Visual Source Safe, ER studio, Winscp, TFS (Team Foundation Server)

Operating Systems: Windows 98/2000/XP/8/10/NT, UNIX, Linux 3.0/4

Others: XML, HTML, SVN, Microsoft Visual Source Safe (VSS), Eclipse, Quality Center, Dimensions, Lotus Notes, Outlook

PROFESSIONAL EXPERIENCE:

Confidential, Los Angeles, CA

Oracle Developer/Analyst

Responsibilities:

• Designed and maintained the Provider Sync process from source Master Provider Data to target QNXT system.
• Actively participated in the daily status meetings for the Sync issues and resolving Help Desk tickets.
• Extensively interacted with the Business User and Business system analysts to understand the functionality and resolving the User Acceptance Test issues.
• Day to day interacting with the team members on the status of the projects, assigning the new projects and discussing the production issues.
• Involved in data migration from Production to test and created test data for analyzing problems, providing solution.
• Experience of working with Encounter Processes and Transactions (837P, 837I, 837D and NCPDP 4.2 transactions, EVR, 999/777/MAO) along with knowledge of healthcare member eligibility, provider network, claim processing, National Standard Codes
• Involved in the Daily and Monthly Fame Raws file loads from the state and enhancing the Provider assignment process to the members received in weekly HCO files and member eligibility files.
• Automated Quality Check tasks by creating PL/SQL procedures, cursors, functions and dynamic SQL Enhanced it with creating exceptions for error handling.
• Modified the queries by applying the oracle hints and using BULK COLLECT, FOR ALL and NOCOPY to reduce the time for performance of the query run time.
• Loading the Data into tables using External tables and extracting the files using Package UTL FILE.
• Developed Shell scripts to automate execution of SQL scripts to check incoming data with master tables, insert the valid data into Customer Management System and invalid data into error tables which will be sent back to sender notifying the errors.
• Wrote the Unix scripts for scheduling or running the scripts for day to day transactions.
• Extensively worked with third party database tools like TOAD & PL/SQL Developer.
• Hands on Exposure on 2010 TFS Version Control. This includes splitting and merging of code branches in various Release and Version Management. Experience in Checking in, checking out the code in TFS (Team Foundation Server).
• Created materialized view on remote database and automated scheduler of refreshing of materialized view on source side.
• Experience in using the Trace files and TK proof whenever required for performance issues.

Environment: Oracle 12c/11g, PL/SQL, SQL*Plus, PL/SQL Developer 10.0, Toad 12.5, UNIX, LINUX, TFS, QNXT, Provider Portal, Lotus Notes, Informatica PowerCenter 9.6.1

Confidential

SQL Developer

Responsibilities:

• Worked with the Business user to finalize the rules for loading of data.
• Worked on build and develop the product based on the requirements.
• Using Toad application tool wrote complexSQLqueries against theOracleERP system & legacy systems to retrieve data and validate if for Siebel Import process.
• Created different types of Reports to meet client requirements.
• WroteSQLscripts to create temporary tables and developed control files orSQL*Loader to load from legacy system into the temporary tables.
• Created various types of procedures using PL/SQLandSQLqueries for data validation, data cleansing.
• Wrote Procedures to drop appropriate Indexes on tables to improve the performance of loading.
• Extracted data from various sources like MSSQLServer and relational databases (Oracle) and supported in Production.
• Involved in Performance Tuning ofSQLQueries, Sources, Targets and sessions by identifying and rectifying performance bottlenecks.
• Created Control file forSQL*LOADER to load data from Flat file into staging area (EIM Tables) for loading of Sales Entities.
• CreatedSQL*plus reports as per client's various needs, and developed business objects.
• DevelopedSQLScripts, Packages and Procedures for Business rules check to implement business rules.
• Developed Procedures for efficient Error Handling process by capturing errors into user managed tables.
• Used Bulk Indexes, Views to improve the query executions.
• Used principles of Normalization to improve the performance. Involved inETLcode usingPL/SQLin order to meet requirements for Extract, transformation, cleansing and loading of data from source to targetdata structures.

Environment: Oracle 11g, 10g, PL*SQL, SQL Developer, SQL*Loader, Export & Import Data, Toad.