Data Sql

Dhananjay Yadav

Sr. Oracle PL/SQL Developer

*.*******@*****.***

***-***-********************************************

Summary:

• 7 years of experience in systems Analysis, design and development of complex software systems in Retail, Banking, Finance, Telecom, Manufacturing and Energy Domains.

• Experienced in requirement analysis, coding and testing various modules in a software development life cycle (SDLC).

• Excellent team player and proven track record working in various team sizes.

• Erudite in preparing High and low level design documentations and DFDs from use cases diagrams, functional and non functional requirement analysis, JAD sessions, use case diagram of different phases of software development life cycle (SDLC).

• Extensive experience Oracle Plsql Development using stored Procedures, PL/SQL Packages, Triggers and functions, ref cursors, LOBs, Oracle Jobs, Collections, Bulk Collect and Forall.

• Strong knowledge e in cursor management and exception handling.

• Experience in database query tuning performance tuning using Indexes, Oracle Hints, explain plan, TKprof, Partitions, Clusters.

• Erudite in Development activities including analysis, design, coding, data migration and testing for production and development environments.

• Hands on experience of using MS Office Suite, MS Project, MS Visio, Rational tools, Erwin.

• Erudite in Preparing word documentation and Visio diagrams to depict business processes better.

• Experience in analysis of performance issue bottlenecks and provide resolution including implementation plans.

• Experience in Development activities including analysis, design, coding, data migration and testing for production and development environments.

• Experience in Application development & Quality Assurance testing using Informatica Power Center 9.0/8.6/7.1/6.2/5.1(Source Analyzer, Data Warehousing Designer, Mapping Designer, Mapplet Designer, Transformation developer), Informatica Power Mart, Power Connect 6.2, Power Exchange, OLAP, OLTP.

• Experience in Data model, ETL and data integration experience in developing ETL mappings and scripts.

• Developed Client –Server applications using front end tools like Oracle developer, SQL* loader and SQL* Navigator, Toad, Plsql Developer.

• Performed exception handling for data that did not conform to the required format

• Extensive knowledge in SQL* loader and usage of external tables, global temporary tables.

• Experience in creating XMLs from SQL using SQL/XML (SQLX) functionality.

• Created indexes for faster data retrieval and improved query performance

• Created indexes ,Partitions and Hints to optimize performance of database

• Written shell scripts to automate loading files into database using crontab, error handling and notification.

• Implemented PL/SQL scripts in accordance with the necessary Business rules and procedures

• Wrote complex queries to retrieve information from database depending on the user requirements.

• Experience in maintaining development, QA, pre-production and the production databases

TECHNICAL SKILLS:

Languages SQL, PL/SQL, Java, Php, Perl, Shell Programming

RDBMS Oracle 9i, 10g, 11g, Data stage 8.1, MS SQL Server 2005.

Tools Oracle , SQL*Plus, PL/SQL Developer, TOAD 10.6,Oracle Sql Developer, Oracle Forms & Reports, Oracle data modeler, Erwin, SQL Navigator, SQL/XML(SQLX), JSP, Servlet, Eclipse, SVN, VSS, Quality Center, Service Desk4, Autosys, Control M,Visio, Informatica 8.6.1,DBA Basics,

DB Utilities Oracle dbms utilities, SQL*Loader, Export /Import.

Operating Systems UNIX, LINUX, IBM AIX 5.3, Windows NT, Windows XP/98/2000

Web Technologies HTML,XML, Macromedia Dreamweaver MX, MS-FrontPage, JavaScript, CSS

NFL (Planning),

Nike, Inc

Application Engineer Oct- 2011 – Present

Replenishment is a supply model that places inventory in buffers at the plant or factory. This benefits our customers and Nike by providing faster delivery of product direct from stock, and is usually reserved for carry over or longer life products where there is sufficient time in the product life cycle. Planners manage the Replenishment buffers and ensure they are properly replenished, ensuring these Replenishment products are “always available” for the consumer. Replenishment has touch points to the downstream raw material process. To support raw materials, the Apparel supply planning system adjusts buy dates for replenishment materials in the Production Plan, Supply Plan, and Global Buy plan.

Responsibilities:

• Involved in requirement gathering from functional team and creating stored PL/SQL Packages, Procedures, functions and Triggers to manipulate the demand master data from SAP R/3 UI, Integration of data from source systems to calculate the buffers and PO’s to supply the finished good to distribution centers on demand During NFL season and all the sports events.

• Integration of data from source systems to calculate the buffers and PO’s to supply the finished good to distribution centers on demand During NFL season and all the sports events.

• Involved in creating stored Procedures, PL/SQL Packages, Triggers, functions , ref cursors, LOBs, Collections, Varrays, Index by table, Bulk Collect, Forall various oracle dbms utilities to implement the business logic.

• Involved in Data integration through the batch jobs performed by Autosys.

• The role involves pull required data form deferent systems and through the batch jobs in Autosys to calculate the buffers and PO’s.

• Involved in database query tuning performance tuning using various oracle functionality like indexes, hints, explain plan, Partitions, Clusters.

• Experience to maintain Development, QA, UAT Database environments.

• Performed exception handling for data that did not conform to the required format.

• Implemented oracle methodologies indexes, partitions and hints to optimize performance of database

• shell scripts to automate loading files into database using Autosys, error handling and notification.

• Support for the development, pre-production and the production databases

• Used TOAD 10.6 to develop database objects

• Changing the logic and enhancement at mapping as per the requirement.

• Unit testing of the developed module and deployment of respective work

•

Environment: Oracle 11g, SQL, PL/SQL, Toad 10.6, UNIX shell scripts, SAP.

CRO-IT,

Credit Suisse

Sr. PL/SQL/DWH Developer Sep- 2010 –Sep-2011

Project is for Credit Suisse bank which is located worldwide and involving Investment Banking activities. CRO-IT project is basically related to finding out\measuring the risk factors associated with the investment which bank does. They analyze the data from front office system which contains sensitivities, positions and portfolio information. They evaluate the risk by calculating the VaR (value at risk) analyzing number of scenarios.

Responsibilities:

• Involved in creation of feeds and various report to load the sensitivities, positions and portfolio information and display the summery reports.

• The role involves develop database objects package procedures and create adhoc script to create reports and repair the data.

• Creation of feeds using the bulk data through Informatica from various region like Asia, America, Europe The product uses optimized data models and configurable data maps (extract, transform and load analysis) to support various formats.

• Up to speed in ETL development using Informatica Power Center (Admin, Designer, Workflow Manager, Workflow Monitor, Repository Manager, Metadata Manager) for extracting, cleaning, managing, transforming and finally loading data.

• Performed exception handling for data that did not conform to the required format.

• Involve in creating stored Procedures, PL/SQL Packages, Triggers and functions. Strong knowledge e in cursor management and exception handling.

• Worked with performance tuning tools to analysis of explain plan, hints, Clusters, Partitions and Stats pack to improve the query and database performance.

• Implemented PL/SQL scripts in accordance with the necessary Business rules and procedures

• Wrote complex SQL queries to retrieve information from the database depending on the user requirements

• Support for the development, pre-production and the production databases

• Used PL/SQL Developer to develop database applications

• Changing the logic and enhancement at mapping as per the requirement.

• Unit testing of the developed module and deployment of respective work

• Changing the logic at mapping level to cop-up with performance issues.

Environment: Oracle 10g, 11g, Informatica 8.6.1,Erwin, SQL, PL/SQL, Perl Script, UNIX, Shell scripts.

Telefonica-O2, Accenture

Bangalore, IND

PL/SQL Developer Sep 2009- Aug 2010

Telefonica O2 is Czech Republic’s telecom project that uses the advance oracle technology to provide spectrum of services to its consumers and provides the end to end IT solution. It is a modular application software package developed using Seibel CRM and three tier architecture. Its modules cater to the various functional requirements of telecom.

Responsibilities:

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

• Interfacing between Seibel CRM and third party by staging the data for security and performance.

• Interfacing with the clients and to get the PRs and RFCs to fix.

• Collaborate with functional and technical teams to resolve technical database related issues.

• Involved in creation of XMLs of SQL queries results to communicate with third party using SQL/XML (SQLX) .

• Responsible for making decisions on coding standards and documentation.

• Design of table structures, Coding, Unit & Regression testing of database objects

Designed critical reports with complex relational data objects. Query tuning was performed to greater extent to reduce report generation time, which was a critical piece due to complexity in data relation

• Coordinate with the front end design team to provide them with the necessary stored package and procedures and necessary insight into the data

• Involved in developing UNIX shell scripts for Loading Database Tables.

• Loading data from flat files into database tables using SQL* Loader. Writing scripts for Data Staging, Loading and cleanup process.

• Preparing documentation for requirements, design, install and Unit testing and System Integration.

• Experience in developing various kinds of triggers and used sequences to generate values for surrogate keys in data warehouse tables using Before Insert triggers.

• Extensively used SQL* Loader for data loading process.

• Created Materialized Views and partitioning tables for performance reasons.

• Preparing documentation for requirements, design, install and Unit testing

• Monitoring day-to-day Process for different Data Loads and resolving Issues.

• Priority basis problem solving and verification

• Worked on SFTP, FTP for file handling from remote servers

Environment: Oracle 9i, 10g, SQL, PL/SQL, PL/SQL Developer, Control M, UNIX (IBM AIX 5.3), Perl, Shell Script, Cron Job, SQL*PLUS.

e- Payment (Online Billing)

Tata Consultancy Services Ltd, GJ(India)

Sr. PL/SQL Programmer Feb 2009- Aug 2009

E-Payment Software is a web enabled, online integrated IT application to provide spectrum of services to its consumers. This software provides facility to make payment of electricity bill online anywhere and anytime with the help of debit/ credit cards and net banking.

Responsibilities:

• Responsible for requirements gathering from Clients and implement the back end changes in existing product and in designing the database.

• The role involves database modeling and implementation of invoice payment data extraction process from Oracle Apps for payments to its vendors. It is a product used by many resellers for payment processing regionally in bulk volume. The product uses optimized data models and configurable data maps (extract, transform and load analysis) to support various formats.

• Develop logical and physical data models that capture current state/future state data elements and data flows using Erwin.

• Extensively used Erwin tool in Forward and reverse engineering, following the Corporate Standards in Naming Conventions, using Conformed dimensions whenever possible.

• Analyzed the functional specs provided by the data architect and created technical specs documents for all the enhancements.

• Created Platform independent schema structure so that the product data can be implemented in any database.

• Used Internationalization and Localization techniques in designing data structure so that it can be adapted to various languages and regions without engineering changes.

• Developing Oracle PL/SQL stored procedures, Functions, Packages, SQL scripts to facilitate the functionality for various modules.

Environment : Oracle 10g, IBM Aix 5.3, PL/SQL, SQL Loader, Shell Scripting.

Utility Billing IT Solution

Tata Consultancy Services Ltd. IND,

PL/SQL Programmer Jan 2005- Jan 2009

Utility Billing Software is a web enabled, online integrated IT application that uses the state-of-the art technology to provide spectrum of services to its consumers that includes: billing, payment, arrears calculation, interest calculation, etc. It is a modular application software package developed using open system and three tier architecture. Its modules cater to the various functional requirements of electricity board. Modules involved are metering module, billing module and security module.

Responsibilities:

• Interfacing with the clients and preparing user documents, training manuals, technical documents, etc.

• Created the UI screens for master data, adjustment, Payment and various MIS reports using java web technology JSP, Servlet.

• Developing data migration for all the pilot sites in Gujarat including around 1,25,00,000 LT and HT consumers.

• Wrote PL/SQL procedures, triggers and functions to enable plug and play of multiple data sources.

• Writing scripts using SQL loader concepts to load the data in to target tables.

• Created Interface between Oracle CRM, Utility Billing System, Account Receivable (AR) and Energy Accounting (EA).

• Preparing MIS reports for all four distribution companies of Gujarat Electricity Board.

• Developed PL/SQL procedures to migrate data into the repository database

• Wrote complex SQL queries to retrieve information from the databases depending on user requirement

• Created database links between the operational data source and the trading application for reporting purposes to the top management

• Created and worked on Nested tables, temporary tables

• Customized data by adding calculations, summaries and functions

• Queried from different database tables as per the requirement

• Designed and created oracle forms to give user a front end display

• Designed and created reports on sales performed every month

• data from the legacy application in the form of flat files and load the extracted data into the new application

• Used explain plan to gather the statistics along with analyze command for performance tuning.

• Managed and resolved design issues during development stage.

• Good knowledge of Normalization and Software Development Life Cycle (SDLC)

• Lead a team of developers which involved assigning tasks and deliverables

• Analyzed the business process and collected the test cases. Executed the test cases as per the schedule

• Performed Unit test and Integration test. Directly interacted with the end user and was responsible for user acceptance

Environment: IBM AIX 5.3, Oracle 9i, 10g, PL/SQL, Oracle Forms 6i & Reports 6i, UNIX, Shell Script.

Education:

Master of Computer Application (MCA) Purvanchal University, Jaunpur, INDIA

M.Sc. (Math) Purvanchal University, Jaunpur, INDIA

B.Sc. (Math) Purvanchal University, Jaunpur, INDIA

Contact this candidate