Data Sql

Professional Summary:

Over * years of programming experience as an Oracle SQL, PL/SQL, ETL Developer in Analysis, Design, Support and Implementation of Business Applications in OLTP, Client/Server architecture and data warehouse applications.

Strong Knowledge on oracle architecture and database design.

3+ years of Microsoft SQL programming, 3+ years of experience in Production Support. Worked in 24X7 environments and resolved the issues in the prescribed SLA limits.

2+ years of experience in Oracle BI Publisher 11g

Solid experience in translating business requirements into creation of Database Objects.

Good Experience in developing PLSQL Stored Procedures, Functions, Packages, Database Triggers using features like Cursors Ref Cursors, Analytical Functions, Collections, Exception Handling.

Extensive experience in analysis and design of database ER Diagrams,

Experience working on Onsite/Offshore Model, Production Support, Release management, documentation.

Extensive experience in Relational database analysis, design, development, testing support, project management and implementation of applications primarily using Client/Server, Middleware, Enterprise Application Integration, RDBMS and Object Oriented technology to accommodate client’s distinct business needs.

Interacted with the business users, collected the requirements, analyze the requirements, design and recommend solutions.

Good experience as Data analyst for migrating data from Oracle to CSV files or Excel.

Tuned SQL queries using Explain Plan and performed refinement of the database design leading to significant improvement in system response time and efficiency.

Expertise in loading data from legacy systems using SQL*Loader.

Have in-depth knowledge in Data analysis, Data warehousing and ETL techniques, Business Objects, UNIX Shell Scripting, SQL, PL/SQL scripts.

Extensively worked with third party database tools like TOAD & SQL Developer.

Worked with various performance tuning techniques using tools provided by Oracle like SQL*TRACE, TKPROF, HINTS etc.

Used DBMS_SCHEDULER to run jobs in parallel to improve time-constrained performance.

Used DBMS_XMLGEN to Parse and Fetch XML data.

Good understanding of Relational database design and developed various data models using ERWIN.

Experience in using oracle long data types like CLOB

Experience in Handling Exceptions.

Experience with software Development life cycle (SDLC) process performing detailed analysis, collecting requirements, documents requirements, coding and unit testing, integration and system testing.

Experience in Coordinating with off-shore and on-site teams to explain client requirement.

Experience in Understanding complex performance issues and worked with DBA’s to to fix the problem.

Experience in query optimization (executions plans, hints, indexes, etc.), partitioning, materialized views and using analytical functions.

Experience in creating webpages using HTML, JSP and EJB.

Experience in ETL to load data from Flat files to Data Warehouse.

Worked on creating SQL*Loader control programs, PL/SQL validation scripts for validating and pre-import processing legacy data from feeder systems to Oracle Applications.

Prepared BRS (Business Requirement Specifications) document that gives the detailed information about the requirements.

Creating RTF reports using Oracle BI Publisher 11g.

Creating RPD, doing modifications to the repository.

Creating of new Analysis, Dashboards and modifying existing Analysis and Dashboards.

Adding BI Publisher reports in Dashboards.

Programming work experience with Batch Scripting and shell scripting as a part of Batch Processing.

Professional experience in using External Tables and Temporary tables.

Extensive knowledge and experience in SQL Queries.

Proficient in writing PL/SQL Packages, Stored Procedures, Functions, Database Triggers.

Has experience in export & import of databases.

6 months experience in Oracle Applications in creating and customizing Reports.

Have Knowledge in Reports 6i, XML Publisher

Has knowledge on creating Dashboards, and integrating BI Publisher reports in OBIEE 11g.

Strong analytical skills.

Have experience in converting sql server 2008 database to oracle 11g.

Possess excellent oral / written communication and interpersonal skills.

Good ability to quickly grasp and master new concepts and technologies.

Professional skills:

RDBMS

Oracle 9i/10g/11g, SQL SERVER 2008, Teradata

Languages

SQL, PL/SQL, TSQL, Unix shell scripting, Core Java

ETL Tools

Informatica Power Center 9 / 8.x

Operating Systems

Windows Server 2000/2003, Oracle Enterprise Linux, Red hat Linux

Development Tools

SQL*Plus, TOAD, SQL *Loader, SQL Developer

Oracle utilities

SQL Loader, EXP/IMP, EXPDP/IMPDP, RMAN

Reporting Tools

Oracle BI Publisher 11g, BO XI R3, OBIEE 11g

Education:

Master of Computer Applications from Osmania University.

Certifications:

Oracle 9i – IZO-007 – Introduction to oracle9i SQL

Summary of projects:

Bitech Inc, Novi,MI Jul ’16 – Till Date

Role: PL/SQL Developer

Client: Sherwin Williams

Environment: ETL, Oracle 11g, Windows, UNIX, SQL Developer, Flat files,

Responsibilities:

Identify data entities for migration into new CPR system and architect database for new system.

Normalize and structure database objects for new CPR system, construct data load scripts and load data from mainframe through nightly batches.

Design and develop database procedures handling and validating all business logics.

Assist front end team in understanding table structures and business logics handled at database level and help write complex queries, review and performance tune queries.

Updating Management team on latest Database features and help them in making decisions.

Interact with corporate Architect group, Review current system architecture and recommend on design changes.

Prepare application design with detail impact specifying impact on data flow, change in business logic of Shell Scripts, Oracle Pl/sql, performance/testing consideration, change in data volume & dependency.

Attended review meetings and walkthroughs to discuss the status of the project and for change requests.

Understanding requirements and discussing requirements with Business Analyst.

Data Loads using the SQL* Loader

Involved in the optimization of Oracle queries/scripts which resulted in substantial performance improvement for the conversion processes using Oracle Hints, Explain Plans.

Creating PL/SQL packages, procedures, functions and triggers as per the business requirements.

Preparing build scripts by release to higher environments.

Monitoring the databases and identifying the long running queries and tuning the SQL

Writing PL/SQL packages, procedures and functions as per the business needs.

Creating triggers for auditing the data.

Fixing the issues that are reported by the client.

Created database objects such as tables, views, indexes and sequences according to business requirements.

Created & maintained jobs using Shell Scripts..

Responsible for validation and creation of supporting documentation of new products and services delivered to our internal customers.

Performed load and integration tests on all programs created and applied version control procedures to ensure that programs are properly implemented in production.

Imported data from various sources (oracle, fixed width flat files) transformed and loaded into targets.

Using Informatica designer, developed mappings which populated the data into the target.

Worked with business analysts for business requirements, analysis and technical specifications.

Data conversion from flat file to intermediate tables using SQL*Loader and also created control files for SQL*Loader.

Developed and maintained UNIX and Shell scripts for database process and conversions.

SSB Software Technologies Inc, Lake Forest, CA Apr ’15 – Jul’16

Role: PL/SQL Developer

Client: Sherwin Williams

Environment: ETL, Oracle 11g, Windows, UNIX, SQL Developer, Flat files,

Responsibilities:

Identify data entities for migration into new CPR system and architect database for new system.

Normalize and structure database objects for new CPR system, construct data load scripts and load data from mainframe through nightly batches.

Design and develop database procedures handling and validating all business logics.

Assist front end team in understanding table structures and business logics handled at database level and help write complex queries, review and performance tune queries.

Updating Management team on latest Database features and help them in making decisions.

Interact with corporate Architect group, Review current system architecture and recommend on design changes.

Prepare application design with detail impact specifying impact on data flow, change in business logic of Shell Scripts, Oracle Pl/sql, performance/testing consideration, change in data volume & dependency.

Attended review meetings and walkthroughs to discuss the status of the project and for change requests.

Understanding requirements and discussing requirements with Business Analyst.

Data Loads using the SQL* Loader

Involved in the optimization of Oracle queries/scripts which resulted in substantial performance improvement for the conversion processes using Oracle Hints, Explain Plans.

Creating PL/SQL packages, procedures, functions and triggers as per the business requirements.

Preparing build scripts by release to higher environments.

Monitoring the databases and identifying the long running queries and tuning the SQL

Writing PL/SQL packages, procedures and functions as per the business needs.

Creating triggers for auditing the data.

Fixing the issues that are reported by the client.

Created database objects such as tables, views, indexes and sequences according to business requirements.

Created & maintained jobs using Shell Scripts..

Responsible for validation and creation of supporting documentation of new products and services delivered to our internal customers.

Performed load and integration tests on all programs created and applied version control procedures to ensure that programs are properly implemented in production.

Imported data from various sources (oracle, fixed width flat files) transformed and loaded into targets.

Using Informatica designer, developed mappings which populated the data into the target.

Worked with business analysts for business requirements, analysis and technical specifications.

Data conversion from flat file to intermediate tables using SQL*Loader and also created control files for SQL*Loader.

Developed and maintained UNIX and Shell scripts for database process and conversions.

4086 Advisors, Caramel, IN Dec ’13 – Jan ‘15

Role: Senior Oracle Developer

Project Description:

40 86 Advisors, Inc., a wholly-owned subsidiary of CNO Financial Group, is a fixed income investment advisor with its roots in the Midwest. The firm manages over $26 billion in public corporate debt securities, taxable municipal bonds, emerging market securities, high yield bonds, government bonds, mortgage related securities, privately placed debt securities, commercial mortgages, and bank loans.

40 86's investment strategy enables the firm to consistently achieve solid performance in its fixed income portfolios by employing a disciplined portfolio structuring process; an intensive bottom-up security analysis that focuses on individual sectors and security structure; a focus on relative value which allows it to discover undervalued opportunities in the marketplace; and a clearly defined, rigorously implemented buy, review and sell discipline.

Environment: Informatica Power Center 9.1, Power Designer, ETL, Oracle 11g, Reports 6i, Oracle BI Publisher 11g, Sql Server, Windows, UNIX, SQL Developer, Flat files, RAZOR, PARIS, Teradata

Responsibilities:

Analyze Business and Technical Requirements.

Involved in gathering elements from different data marts to consolidate in to single data mart.

Prepare application design with detail impact specifying impact on data flow, change in business logic of Shell Scripts, Oracle Pl/sql, performance/testing consideration, change in data volume & dependency.

Attended review meetings and walkthroughs to discuss the status of the project and for change requests.

Understanding requirements and discussing requirements with Business Analyst.

Writing stored procedures, triggers and functions using PL/SQL.

Data Loads using the SQL* Loader

Involved in the optimization of Oracle queries/scripts which resulted in substantial performance improvement for the conversion processes using Oracle Hints, Explain Plans.

Rebuilding the Indexes for performance of SQL Queries.

Analyzed Oracle objects and created Partitions for very large tables to reduce disk contention and improve performance.

Production Support for the nightly cycle jobs to load financial data into the system.

Creating PL/SQL packages, procedures, functions and triggers as per the business requirements.

Backup of all the databases (development and QA databases).

Preparing build scripts by release to higher environments.

Monitoring the databases and identifying the long running queries and tuning the SQL

Queries, identifying the deadlock queries and informing to the development team.

Writing PL/SQL packages, procedures and functions as per the business needs.

Creating triggers for auditing the data.

Fixing the issues that are reported by the client.

Creating reports using Oracle BI Publisher 11g.

Modifying Oracle 6i Reports. Migrating Oracle 6i Reports to BI Publisher.

Created database objects such as tables, views, indexes and sequences according to business requirements.

Created & maintained jobs using Shell Scripts..

Participate in mock deployment of every release, help to prepare release plan, identify the dependencies.

As part of the Production Support team resolved failures in production data processing.

Responsible for validation and creation of supporting documentation of new products and services delivered to our internal customers.

Performed load and integration tests on all programs created and applied version control procedures to ensure that programs are properly implemented in production.

Imported data from various sources (oracle, fixed width flat files) transformed and loaded into targets.

Using Informatica designer, developed mappings which populated the data into the target.

Worked with business analysts for business requirements, analysis and technical specifications.

Data conversion from flat file to intermediate tables using SQL*Loader and also created control files for SQL*Loader.

Design and developed complex Informatica mappings including slowly changing dimensions.

Extensively used transformations like Router, Filter, Joiner, Source qualifier, look up both connected and unconnected, Expression, Aggregator, Update strategy and sequence generator.

Used parameters and variables at mapping and session levels to improve the performance and mappings.

Involved in fixing in-valid mappings and testing of the PL/SQL stored procedures and the target data.

Developed and maintained UNIX and Shell scripts for database process and conversions.

Brunos, Florida Jun ’11 – Dec'13

Role: Senior Oracle Developer

Clients: Amerilife, Gerber, BCBS, Reliance Standard Life, Vista

Project #1: Reliance Standard life Insurance (RSLI)

Project Description:

RSLI is an efficient system capable of handling agent, agent licensing, commission calculation. RSLI offers traditional insurance plus innovative plans like Health Insurance, Dental Insurance, Term Life Insurance that give consumer’s greater choice and control. It takes care of licensing and appointment aspect of agents and agency viz. add new agent, terminate agent and update agents, agent renewal, etc. The system also takes care of plan transfer between the agents, rearrangement of hierarchy, adjustments of advances paid (if any), maintains the levels for agents and suggests for change in level. . The commission is given to the agent based on the policy premium and adjustments of the policy. This project includes daily commission cycles, payment inbounds and premium related extracts. This project comprised several programs for customization of reports in payables, creating and maintaining supplier’s information and customization of various forms and reports as per business requirements.

Responsibilities:

Analyze Business and Technical Requirements.

Involved in gathering elements from different data marts to consolidate in to single data mart.

Prepare application design with detail impact specifying impact on data flow, change in business logic of Shell Scripts, Oracle Pl/sql, performance/testing consideration, change in data volume & dependency.

Attended review meetings and walkthroughs to discuss the status of the project and for change requests.

Developed PLSQL Packages/Procedures/Functions for massaging the data as per business requirement.

Created Shell Scripts to automate batch jobs.

Involved in the optimization of Oracle queries/scripts which resulted in substantial performance improvement for the conversion processes using Oracle Hints, Explain Plans.

Rebuilding the Indexes for performance of SQL Queries.

Analyzed Oracle objects and created Partitions for very large tables to reduce disk contention and improve performance.

Involved in Developing and handling the PL/SQL Packages, Procedures and functions.

Involved in tuning SQL queries by using EXPLAIN PLAN.

Development, test specification creation and unit testing for various changes.

Review design, code, and unit test cases.

Participate in mock deployment of every release, help to prepare release plan, identify the dependencies.

As part of the Production Support team resolved failures in production data processing. Resolving an average of 5 tickets per day.

Responsible for validation and creation of supporting documentation of new products and services delivered to our internal customers

Performed load and integration tests on all programs created and applied version control procedures to ensure that programs are properly implemented in production.

Migrating SQL Server 2008 Database to Oracle 11g.

Assigning tasks to other team members in accomplishing the deadlines for the CRs.

Handling multiple projects.

Environment: Informatica Power Center 9.1, Power Designer, ETL, Flat Files, Oracle 11g, SQL SERVER, TOAD 9.6.1, SQL Developer, Unix Shell Scripts.

Project #2: Independent Health (IH)

Project Description:

IH is mainly a health insurance product. It is an efficient system capable of handling mainly Medicare related products and policies. It takes care of agents, agent licensing, appointing and plan transferring. It takes care of premium calculation, which is used in calculating commissions for agents. Involves charge back, renewals, etc. Agent can transfer a single policy or bulk of policies at a time to another agent. IH mostly concentrates on Bonus section that can be previewed in every monthly commission cycle and Bonus calculation for every year. Bonus program changes every year based on the market. This project comprised several programs for customization of reports in payables, creating and maintaining supplier’s information and customization of various forms and reports as per business requirements.

Responsibilities:

Analyze Business and Technical Requirements.

Involved in gathering elements from different data marts to consolidate in to single data mart.

Prepare application design with detail impact specifying impact on data flow, change in business logic of Informatica, Oracle Pl/sql, performance/testing consideration, change in data volume & dependency.

Attended review meetings and walkthroughs to discuss the status of the project and for change requests.

Developed PLSQL Packages/Procedures/Functions for massaging the data as per business requirement.

Developed Informatica mappings to move batch data from flat files to oracle tables.

Created Shell Scripts to automate batch jobs.

Involved in the optimization of Oracle queries/scripts which resulted in substantial performance improvement for the conversion processes using Oracle Hints, Explain Plans.

Rebuilding the Indexes for performance of SQL Queries.

Analyzed Oracle objects and created Partitions for very large tables to reduce disk contention and improve performance.

Involved in Developing and handling the PL/SQL Packages, Procedures and Database Triggers.

Involved in tuning SQL queries by using EXPLAIN PLAN.

Involved in database upgrade & impact on application.

Development, test specification creation and unit testing for various changes.

Review design, code, and unit test cases.

Participate in mock deployment of every release, help to prepare release plan, identify the dependencies.

Provided on-call production support for several applications

Responsible for all aspects of product engineering, release management and production support

Provided Production support by tracking issues and monitoring the processes running.

Unit testing, User Acceptance Testing to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.

Environment: Informatica Power Center 8.6.1, Oracle 11g, XML, TOAD, ETL, DWH, Java, UNIX Scheduler, MS SQL Server 2008.

Clinapps, SanDiego, CA Nov ’10 – Jun'11

Role: PL/SQL Developer

Clients: Shire, Celegene, Sanofi Aventis, Allergan, Biogene

Environment: Business Objects XI R3/R2, Oracle 10g, Toad, Windows, UNIX, SQL Developer.

Responsibilities:

Performance Tuning of SQL Queries.

Creating PL/SQL packages, procedures, functions and triggers as per the business requirements.

Taking backup of all the databases (development and QA databases).

Preparing build scripts by release and sending to US office for testing.

Fixing the issues that are reported by the client.

Creating and modifying the reports using BO XI R3 as per the business logic.

Monitoring the databases and identifying the long running queries and tuning the SQL

Queries, identifying the deadlock queries and informing to the development team.

Writing PL/SQL packages, procedures and functions as per the business needs.

Creating triggers for auditing the data.

Monitoring Disk usage and free space.

Has fixed errors proactively and reduced the number of iterations in processing the data

Involved in tuning the performance of the long running queries.

Designed Report for Logistics, manufacturing and lots module. Specifically in shipment requests, transfer requests, pick and pack, returns, site reconciliations, manufacturing requests, treatment kits, lot inventory, lot quality, assign kits, lot ordering and lot regulatory.

Designed Universe and report using webi rich client and desktop intelligence.

Implemented cascading list of values. Used @variable and @prompt functions. Set cardinalities and defined contexts. Created derived tables. Implemented sort and ALL in list of values.

Created classes, objects, define condition objects in universe level.

Created complicated condition and combined queries in query filters. Implemented optional prompt and pattern matching in query filters.

Designed multiple section wise display of record in report.

LGS Global Limited, Hyderabad, INDIA Oct ’06 – Nov'09

Role: Programmer Analyst

Clients: BASF, State of Beauty, Masco Contractor Services

Environment: Oracle10g, 1i, XML Publisher, Forms/Reports 6i, TOAD, Oracle 9i, RHEL4(Server), Windows XP(Client), Java.

Responsibilities:

Writing SQL queries, Triggers and stored procedures development

Daily Jobs analysis and

SQL queries, Triggers and stored procedures development

Daily Jobs analysis and constructions.

PL/SQL Scripts for the backfill and yearly database maintenance.

Impact analysis.

Release Management

Unit Testing and Documentation.

Production support.

Creating Webpages using JSP, EJB

Creating Database Tables

PL/SQL Packages to Populate data from Stage Tables to Base Tables

Schedule the Scripts

Creating RTF Reports

Customizing RTF Reports

Customizing RDF’s ( reports 6i)

Performance Tuning of SQL Queries, Loading Data using SQL Loader

Unit Testing and Documentation.

Contact this candidate