SUMMARY

Professional with over 8 years of industry experience and well versed in Software Development Life Cycle. Expertise in Analysis, Design, Development and Deployment of business solutions using Oracle, PL/SQL and SQL technologies. Well experienced in Pl/Sql, ORACLE, Shell Script KSH , PERL, HTML, JavaScript and CGI. Possess sound technical and analytical skills with strong business knowledge. Good analytical and problem solving skills. Effective working independently and contributed significantly in teams.

PROFESSIONAL EXPERIENCE

Confidential

• The Confidential announced the release of two final rules that will facilitate the United States' ongoing transition to an electronic health care environment through adoption of a new generation of diagnosis and procedure codes and updated standards for electronic health care and pharmacy transactions.
• The first rule adopts two medical data code sets as part of the Health Insurance Portability and Accountability Act of 1996 HIPAA standards for use in reporting diagnoses and inpatient hospital procedures in health care transactions ICD-10 final rule . The standards adopted under this final rule will replace the ICD-9-CM code sets, developed nearly 30 years ago, with greatly expanded ICD-10 code sets. The compliance date for the ICD-10 final rule is Oct. 1, 2013
• There are number of instances where ICD-9 codes sets CM, PCS are used within EmblemHealth's systems. EmblemHealth's existing Data Warehouse does not support ICD-10 code sets and needs to be remediated. The Enterprise Data Warehouse Workstream, as part of this I10 Remediation Program, will identify all the impacted data structures, data stores within the Emblem Health data warehouses and reports that require remediation
• Splitted the existing batch jobs written in MS DOS for the project to make the jobs run based on the types of entity
• Supported the production issues and implemented the fixes on the regular basis
• Wrote pattern matching Sql scripts to find the objects based on the column matches
• Created the inventory by writing the procedure to capture the impacted tables,views,constraints,indexes,procedure,package,function,trigger from 16 databases through the DB link
• Wrote equivalent queries as part of Database shutdown and migration.
• Prepared the Gap analysis document as part of DB migration to capture all the objects and data information
• Altered the tables, indexes and views as part of remediation based on the changes provided.
• Enhanced the complex procedures, packages to handle the structural changes with data.
• Supported the production jobs during the disaster recovery by running the Autosys jobs and validating the data after each run
• Created and Modified the Sql loader control files based on the Copybook layout changes.
• Worked on the BRD and TRD document for all the SDLC life cycle
• Involved in tuning the complex queries to produce the results in the timely
• Created the mapping document based on the Mainframe copybook layout to map the source from Mainframe file to the tables.
• Developed test plan, test case document as part of data base migration and deployment.

Environment: Oracle SQL, PL/SQL, SQL Loader, Autosys, TOAD, Oracle 10g/11g, Windows

Confidential

Patient Health Information Tracking: The project is about tracking the health information of patient and getting the reports from the lab for the New York State. This report is sent to the hospitals. The application is designed for the end users such as the doctors, lab technician, nurses etc.

• Data migration from Sybase to Oracle using Sql developer migration wizard
• Tuning the long running queries in the Oracle database
• Creating stored procedures, functions based on the requirements
• Analyzing data from the source systems
• Writing test scripts to test the data for missing records
• Used Oracle application express to create table reports and validate the data between Sybase and Oracle
• Used Toad data modeler to create data dictionary report for the complete database
• Analyzing issues and solve them

Environment: SQL, PL/SQL, Toad, Oracle Application Express, Oracle 10g, Sybase, Windows 7, Windows XP

Confidential

CRMS Credit Risk Management Service : The key objective of the CRMS team is to provide credit data management, policy advisory services and control related functions that facilitate and enhance the credit approval, limit monitoring and documentation review processes and support the active management of our firm's portfolio through leadership, individual initiative, integrity and effective execution of our business objectives.

• Created jobs using Talend to load the data from the csv file to the tables
• Enhanced the existing jobs based on the modification of the feeds and the raw tables
• Created tables, synonyms, sequences, views, PL/SQL stored procedures and triggers
• Created PL/SQL functions to facilitate the business functions and calculations
• Created Complex stored procedure based on the business logic to join the multiple raw tables based on the join condition and the filter applied
• Based on the Raw table data, the aging calculation is performed by looking up in the same table
• Created range partitioning on the tables to improve the performance
• Improved the performance by fine tuning the long running queries.
• Supported ETL framework structure in R2 migration for creating separate stream
• Created a Jil file and deployed the job to automate the Talend jobs to load the data in to the table on weekly and monthly basis
• Supported the autosys monitoring team in case of alerts such as job failure
• Support and debug the failed stored procedure in the production and identified the root causes of the issue and fixed it and release it to production
• ETL jobs fails due to data related issues, so validated the data again and sent it to the source system and fixed the issue and processed the job again
• Fixed bugs addressed by the client during production
• Created test plans in development and UAT environment before each migration
• Created SQL test scripts to test the results in the form of unit testing and documented the screenshot of the result
• Created RFC tickets in remedy, got approval from manager's for UAT and production deployment
• Created the folder, descriptor and applied the label on the folder, descriptor file to push the database scripts to production
• Created pivot chart in Excel to send the results to the business users

Environment: Oracle SQL, PL/SQL , ETL , Autosys , Unix, Sql developer, Sql tools, Talend, Remedy, IBM Rational Clearcase, Oracle 10g/11g, Windows, Unix

Confidential

PRE-CLERANCE: Pre-Clearance is a web based Employee Compliance Applications Portal ECAP incorporating different applications like Outside Business Acknowledgement Application OBA , Employee Acknowledgement Application EAA , Employee Trade Request system ETR and Employee Trade Surveillance ETS . This project involves enhancements of OBA like providing new link for maintaining/adding internal affiliations and dual hated responsibilities etc.

• Involved in user requirements gathering, analysis, design, coding, testing, implementation and review
• Created PERL script for feed processing and feed pre-processing
• Created and maintained many PERL/KSH scripts
• Worked in CGI/PERL programming and DBI/DBD to connect to Oracle and fetch data for presentation
• Developed CGI/PERL pages using JavaScript and HTML
• Developed upload system using PERL and CGI for research group
• Created many database objects like tables, triggers, views, stored procedures and functions in Oracle database on need basis
• Involved in Oracle PL/SQL coding for data conversion to write transact, extract, validate and update procedures
• Wrote row level triggers to replicate legacy systems data to Oracle database
• Created SQL Loader scripts as a part of conversion process to load the legacy data from existing flat files into Oracle tables
• Created UNIX shell scripts for ad-hoc requests
• Worked in data handling using UNIX shell scripts
• Created UNIX shell scripts for sequential execution of PERL scripts including file archiving, transformation and backup
• Worked on porting UNIX applications to multilevel secure workstations
• Worked on bug fixing and supported the production applications
• Participated in testing, test case documentation and quality assurance

Environment: PERL, CGI, HTML, Oracle, JavaScript, DBI/DBD, SQL Loader, Windows, UNIX

Confidential

RISK MANAGEMENT OF EQUITIES AND FIXED INCOME: This application is about the web-font end for Risk Manager, Complete picture of the Risk Spread position across different regions, Businesses Fixed Income / Equities and Products IR Products / Portfolio and Traders. Senior management use the reports for taking decisions based on the Daily VaR, Risk Appetite, Usage Greeks like Beta, Gamma and Theta Vega. The Reports are available for any given trade date and these data changes daily based on the market conditions.

• Designed and developed many PERL modules and interfaces
• Designed developed PERL scripts for sending application based mails using SEND MAIL
• Created PERL scripts to check the feeds for header/footer formats
• Created roll back mechanism using PERL for feed processing
• Worked in log/error file scanning and reporting using PERL
• Wrote many PERL programs for data file loading
• Developed web pages and templates utilizing HTML, PERL CGI, and JavaScript
• Designed and validated GUI's using JavaScript and HTML
• Tuned configuration system with advanced Oracle techniques to improve performance
• Worked with Oracle databases and designed stored procedures
• Generated stored procedure skeletons from Oracle schema input
• Led integration with Oracle, redesigning code frameworks to harness power of PL/SQL, stored procedures and other key Oracle features
• Developed many indexes for performance and worked in fine tuning the SQL queries
• Developed many UNIX KSH scripts for data file movement and scheduling
• Designed and programmed the UNIX provisioning system
• Installed and configured TCP wrappers to help secure standard ports on all UNIX machines
• Maintained, upgraded and supported UNIX client load server infrastructure
• Wrote many wrapper scripts and supported the system
• Scheduled PERL/KSH batches using CronTab
• Supported with other team members to move the code to production
• Worked with users for new module enhancements and testing

Environment: PERL, CGI, HTML, Oracle, JavaScript, KSH, DBI/DBD, Windows, CronTab, UNIX

Confidential

GAS STATION MANAGEMENT SYSTEM: This system targeted to reduce paper work and develop an well-automated management system. The system comprises of Order management, Payment management and Billing as principle modules. The application is provisioned to give information of daily collection and bill items.

• Wrote synchronization code using PERL and UNIX shell scripts
• Supported front-end search and lookup screens using PERL/CGI/HTML
• Worked in scheduling PERL scripts for end of the day run
• Created many DBI/DBD based PERL programs for database connectivity and querying
• Developed dynamic content with the aid of templates using JavaScript and HTML
• Created many PERL programs for data upload and download
• Worked in creating tables, stored procedures and triggers as part of Oracle effort
• Used PL/SQL tables, array structures as a part of Oracle collections
• Involved in helping with design custom data models that's integrated with Oracle applications
• Designed and developed interactive GUI forms to support data entry, querying and reporting from Oracle databases
• Enhanced sites with PL/SQL procedures that delivered web content
• Enhanced and fixed existing UNIX Korn shell scripts
• Created several scripts to maintain UNIX systems and user accounts
• Assisted with software testing and reporting
• Planned, implemented, supported and updated document changes in UNIX systems
• Participated in production support, documentation, testing and end user training
• Supported the application during deployment and production phases

Environment: PERL, Oracle, CGI, HTML, DBI/DBD, JavaScript, KSH, UNIX

Confidential

HOSPITAL MANAGEMENT SYSTEM: Hospital Management System is a software product suite designed to improve the quality and management of clinical care and health care in the areas of clinical process analysis and activity-based costing. This system improved the Hospital's effectiveness and improved quality and managed the key processes efficiently and overall contributed to the success of the hospital.

• Wrote PERL scripts for data manipulation, retrieval and data handling
• Designed and developed many PERL modules
• Used PERL CGI scripts for server side computing, searching and reporting using dynamic web pages
• Created many SQL batches for data handling using PERL/KSH
• Involved in adding the Oracle database layer of security
• Developed stored procedures, triggers, tables and indexes in Oracle database
• Implemented physical models using Oracle database
• Performed data conversion from legacy system to Oracle
• Created various UNIX KSH scripts to perform data transfers and archives periodically
• Created UNIX shell scripts for automating the execution process
• Created many PERL/KSH scripts for maintenance and monitoring of the application during production support
• Provided technical support to internal developers and external clients

Environment: PERL, Oracle, PL/SQL, CGI, HTML, JavaScript, UNIX