Data Sql Server
Resume:
Poorani Santosh
Oracle PL/SQL Developer
EXPERIENCE SUMMARY
Over 9 years of experience in various phases of Software Development Life Cycle involving Analysis, Design, Development and Maintenance of Business Applications using Oracle Relational Database Management System.
Experience in Design and Implementation of PL/SQL Stored Procedures, Functions, Packages, and Database Triggers for Oracle Relational Databases.
Proficient in the Data Manipulation using SQL for the retrieval of data from the Relational Database (inner joins, outer join, group by, order by, cursors etc).
Have extensively worked in developing ETL for supporting Data Extraction, transformations and loading using Informatica Power Center.
Extensively worked in Client-Server application environment using Oracle 10g/9i/8i/7.x on Windows, UNIX/LINUX platforms and profound knowledge on Oracle 11g.
Worked with Collections, Records, Dynamic SQL and Exception Handling.
Used SQL and PL/SQL performance tuning techniques which included creating indexes, partitioning tables, providing Hints, Optimizer query execution plans, SQL trace and TKPROF.
Worked with tools like PL/SQL Developer, SQL Developer, SQL*Loader, TOAD, SQL plus.
Extensive experience in managing teams/requirement analysis/code reviews/implementing standards.
Worked closely with lines of business/operation areas to identify and specify complex business requirement, processes and convert into IT Requirements
Efficient in creating Test cases and performing data validation and process testing for application moving into production.
Expertise in understanding Fact Tables, Dimension Tables, Summary Tables
Experience in using Automation Scheduling tools like Autosys
Migration of Oracle packages, code and DB objects between environments as well as Production Support.
Experience in SCRUM agile methodologies.
TECHNICAL SKILLS
Operating Systems: Windows 2000/XP, Unix
Project Management Tools: MS Office, MS Project
Programming Languages: SQL, PL/SQL
Data Bases: Oracle 9i,10g, 11g, MySQL
Tools: SQL/PLSQL, Macromedia Dream Viewer, MySql, TOAD, SQL Server Management Studio Express
Scheduling tools: Autosys
ETL Tools: Informatica Power Center 9
PROFESSIONAL EXPERIENCE:
Monsanto NOV 2016 – Till now
Sr. Oracle Developer
Environment: Oracle Exadata (Production Support)
Project Description:
Monsanto is a global modern agriculture company. It develops products and tools to help farmers around the world grow crops while using energy, water, and land more efficiently. It believes innovation has the potential to bring humanity’s needs in balance with the resources of our planet. We are supporting various applications used by the business users and the data issues are handled by the Data Team.
Contribution:
Handled incidents and work orders and resolve the issue based on the priority.
Always meets the SLA.
Reduced the count of tickets by developing pipeline protocols to achieve the frequent request.
Developed automation scripts to reduce the turnaround time of the ticket resolution for the frequent tasks.
Suggested some permanent fix/solution to avoid the repetition of the same request.
Worked on Enhancements which involves data loading in the Oracle Exadata for the front-end application
Ensure the system is up and running 24x7.
Worked in Agile methodology.
Created procedures, packages based on the requirement and done unit testing.
Created database links to retrieve data from multiple servers.
Anthem Aug 2016 to Oct 2016
Sr. Oracle Developer
Environment: SQL Server, Oracle Exadata
Project Description:
Anthem, Inc. is one of the largest health benefits companies in the United States. Through its affiliated health plans, Anthem companies deliver several leading health benefit solutions through a broad portfolio of integrated health care plans and related services. Anthem wants to migrate the data from Sql server to Oracle Exadata.
Contribution:
Involved in complete analysis of the existing Objects like tables, views, procedures, function and packages.
Migrated the tables from SQL server to Oracle by copying a dump and loaded the table structure.
Used Oracle Migration Workbench Tool to migrate the objects from SQL Server to Oracle Exadata.
The procedures which are not completely migrated using Workbench are modified manually.
It was more challenging to implement the complex logic from SQL server to Oracle Exadata for some of the complex Procedures.
After the migration, end to end testing happened with the application team.
Involved in Production deployment activities.
Aetna Apr 2014 to Sep 2015
Senior Developer
Environment: Oracle 11g
Project Description:
Aetna is one of the nation's leading diversified health care benefits companies, serving approximately 37.3 million people with information and resources to help them make better informed decisions about their health care. Healthagen is a division of Aetna that offers health and technology services to providers, payers, employers and consumers. Our solutions are designed to improve care quality, control health care costs and engage consumers in their health care.
Contribution:
Analyzed the business requirement.
Developed Oracle PL/SQL Procedures, functions and packages based on the requirement and performs unit testing.
Worked very close with the ESB and UI Team to understand the expected output and implements the same in development.
Prepared Technical Design document based on the business requirement and based on the review implemented the changes.
Worked in Agile methodology.
Done Performance testing for some long running queries.
Wrote complex SQL queries including sub queries for faster data retrieval from multiple tables.
Modified and debugged several PL/SQL programs for performance tuning using techniques like EXPLAIN PLAN, TKPROF and DBMS_PROFILER.
AstraZeneca (AZ RND AD Emerson Data Migration) May 2013 to Mar 2014
Developer
Environment: Informatica, Oracle 11g
Project Description:
AstraZeneca is a global innovation-driven biopharmaceutical company specializing in the discovery, development, manufacturing and marketing of prescription medicines that make a meaningful difference in healthcare. They are using an applications JASPER, CRIMSON and Safeguard for various countries which captures the cases if any adverse event occurs due to the drugs provided. This Project deals with the Migration of data from CRIMSON and Safeguard to Jasper. It involves cleansing and migration of tables, documents and XML.
Contribution:
Analyzed the business requirement.
Involved in Data Analysis
Created Conversion mapping document by understanding the business logic.
Created mappings in Informatica involving complex business logic.
Migrated the data from SQL server to Oracle 11g.
Managed the team members.
Responsys, USA Apr 2012 to May 2013
Developer
Environment: Oracle 11g R2, Toad
Project Description:
The Responsys Interact Suite provides marketers with a powerful, comprehensive set of integrated applications to design, define, execute, manage and refine Cross-Channel Lifecycle Marketing campaigns across all key digital interactive channels email, mobile, social, display and the web. Digital Marketing involves the Campaigns that are to be triggered for the clients as and when required.
Contribution:
Analyzed the business requirement.
Understand the current reporting and analysis process.
PL/SQL development, Tuning and Optimization.
ACXIOM DIGITAL, USA May 2010 to Apr 2012
Developer
Environment: Oracle 11g R2 (UNIX Platform)
Project Description:
Acxiom Corporation integrates data, services and technology to create and deliver customer and information management solutions for many of the largest, most respected companies in the world. Digital Marketing involves the Campaigns that are to be triggered for the clients as and when required. Data Management System (DMS) project involves the reporting of the data from the database based on the criteria required by the Clients which would be further used for the Campaigns that are to be triggered for the members whoever comes from the report.
Contribution:
Analyzed the business requirement.
Understand the current reporting and analysis process.
Developed Procedures, Functions, triggers and Packages based on the requirement.
Loaded the incoming file using External tables and created more dynamic sqls based on the requirements.
Done Performance Tuning and Optimization.
Done Unit testing and involved in Production Deployment activites.
Developed Procedures more with Dynamic SQLs.
Basic file validations are handled using Unix scripts and the data has been loaded through External tables.
Monitored the campaigns after the production movement and verified based on the business logic the emails were triggered to the right clients.
CITI India Apr 2008 to Jul 2009
System Analyst
Environment: PRO*C, Oracle
Project Description:
NR project deals with Non-Resident Indian customer of Citibank. There are 3 booking centers in NR system. India, London, Singapore. Main Products are TIDE (Time Deposit),FIS(Fixed Income Security), NRMF(NR Mutual Funds),RCA(Rupees Checking Account),DCA(Dollar Checking Account),Insurance, E brokerage and the supported Projects are Currency Conversion, RQ(Relationship Query),Remittance, Forwards.
Contribution:
Involved in Logical and Physical design. Identified Fact tables, Transaction tables.
Involved in analysis, design and coding of data extraction, transformation package in PL/SQL for loading data from online websites.
The system design involving the various technologies like Pro*C, Oracle, JSP, XTML.
Depending on the requirement, design the technologies with various important criteria like future enhancement, efficient, performance and portability.
Developed Pro*C modules to extract data for front end application.
Identified the performance and scalability bottlenecks in earlier versions and suggested optimal solutions.
TNEB (Utility Billing) Jan 2007 to Mar 2008
Programmer
Environment: Oracle 9i, PL/SQL, PHP 5.1.2, LINUX, Apache 2.0.54
Project Description:
This system is being developed for TNEB in order to ensure prompt and accurate billing, Collection and accounting. To help TNEB management to process quickly using automated process and to get accurate data, in order to speed up the revenue process.
The Functionalities of this system are:
Application Tracking
Billing Status
Section Bifurcation
Revenue Status
Defaulters List
Arrear Tracking
Meter Reading Entry
Status Reports
Contribution:
Gathering the requirement from the client and translating the business details into Technical design.
Involved in analysis, design and coding of data extraction
Involved in transforming package in PL/SQL for loading data from online websites.
Creating and managing database.
Using the technical document to design the database table.
Unit testing for the developed projects are done with documents.
Implementation is done after complete testing.
Report Preparation
Contact this candidate