We provide IT Staff Augmentation Services!

Team Member Resume

Little Rock, AR

PROFESSIONAL SUMMARY:

  • Result oriented professional with 15 Years of experience in IT industry in Confidential, Enhancement and Maintenance and Testing projects.
  • Experience in Oracle SQL, TSQL, Sybase, DB2, MS - SQL, PostgreSQL.
  • Experience in writing DDL, DML commands and SQL Queries, Table Partitioning, Collections.
  • PL/SQL stored procedures, functions, packages, triggers, Exception handling and Dynamic sql, Import and Export data, XML data type, XML script, Cursors, REF Cursors.
  • Oracle Forms and Reports and Crystal Reports and Actuate Report, Oracle APEX.
  • Experience in Performance Tuning methodology, Query Optimization, Oracle Supplied Packages such as DBMS SQL, DBMS JOB, DBMS Profiler, UTL FILE. Execution Plan, AWR Report, Oracle Data Migration.
  • Worked on Unix/Linux Shell scripting, CRON Jobs, ETL Methodologies Informatica, Cognos, BI Publisher, OBIEE reports, Java, JavaScript, HTML and VB Script.
  • Experience in designing Data flow diagrams using Ms-Visio, MS office Tools, Oracle Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques.
  • Involved in Huge data migrations, transfers using and SSIS, Bulk Copy Program (BCP) and Bulk Insert.
  • Experience in BI Development and Deployment of DTS, SSIS packages from MS-Access, Excel, Oracle.
  • Designing and Deployment of Reports for the End-User requests using Web Interface & SSRS.
  • Extensive experience in controlling the User Privileges, Monitoring the Security and Audit issues as per Standards.
  • Expertise in Performance tuning, Optimization, Data integrity and Statistics by using SQL Profiler, PerfMon and Spotlight.
  • Experience in solving Real Time issues with Index fragmentation, DBCC checks, Query Tuning, Error and Event Handling.
  • Expertise in SQL Server Storage Structures and Security Architecture for databases residing on SAN storage.
  • Experienced in programming tasks-Stored Procedures, Triggers, Cursors using SQL Server 2012/2014 with T-SQL.
  • Experienced in SDLC life cycle for Design, Development and Staging phases of the projects with support of Data-Flow, Process Models, E-R Diagrams.
  • Extensive experience in Deploying and Consolidating Multiple Instances over Clustering Environment and Remote Installations.
  • Extensive experience in Installation, Configuration and Deployment of SSRS using Scale-Out, Scale-Up and Local topologies.
  • Involved in migration of SSIS Packages 2014 and troubleshoot migration issues.
  • Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
  • Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
  • Got PMP Training to involve on all stages of product development, Testing and Implementation.

SKILL:

Database: Oracle 7.x,8.x, 9.x, 11g,12c, MS SQL SERVER 2005,2008,2012, PostgreSQL.

Development tools: SQL, PL/SQL, Oracle utilities.

Designer tools: Oracle Forms, Oracle Reports, BI PublisherTableau 9.x,10.3, Oracle Database Designer, SQL Data Modular, Mongo DB 3.4.:

Erwin and MS-Visio, MS-office.:

ETL: SQLLDR and UTL Packages, Informatica, Cognos 10.3

Database tools: SQL Developer, PLSQL Developer, DB query tool & TOAD, Oracle APEX.

Job Schedulers: ORACLE Schedulers / SQL agent

Operating System: Windows, Unix, Open VMS

Oracle Apps Modules: Oracle EBS, HRMS, Inventory, Purchase, Order Management.

Internet Technology: HTML, Java Script, Java, .Net, HPSD, Jira, CA Clarity, Apache Tomcat, SVN.

PROFESSIONAL EXPERIENCE:

Confidential, Little Rock, AR

Software/Technology: Oracle, Oracle Apex, SQL, PL/SQL, SSAS, SSIS, SSRS, Cognos 10.3.

Team Member

Responsibilities:

  • Worked closely with Project Team, SME and Internal Business Partners (IPs) to clarify business requirements and translate the requirements into technical specifications.
  • Involved from beginning of the project such as of Statement of Work (SOW) to post implementation of SDLC process.
  • Assisted Project Manager in scope estimation and work breakdown structure (WBS) to meet Project Milestone.
  • Analyzed Auto sys job flows and created JIL’s for data validation process such as pre and post load SQL checks.
  • Performed Source system analysis (SSA) to identify the source data that needs to be moved into the target tables.
  • Defined frameworks for Operational data system (ODS), Brokerage data warehouse (BDW), Central file distribution (CFD) and Data Quality (DQ) and created functional data requirement (FDR) and Master Test Strategy documents.
  • Conducted workflow, process diagram and gap analyses to derive requirements for existing systems enhancements.
  • Performed impact analysis for DB2 tables that needs to be compressed and archived to implement the lower cost storage mechanism.
  • Defined target load order plan and constraint based loading for loading data correctly into different target tables.
  • Designed and created Data Quality baseline flow diagram, which includes error handing and test plan flow data.
  • Created Test Plans, Test Cases, and Test Scripts for all testing events such as System Integration Testing (SIT), User Acceptance Testing (UAT) and Unit Integration Testing.
  • Created SQL-Loader scripts to load legacy data into Oracle staging tables and wrote SQL queries to perform Data Validation and Data Integrity testing.
  • Coordinated with offshore vendor and established offshore teams and processes for code development.
  • Coordinated with execution team to define the batch flow for data validation process.
  • Involved in all execution phases such as Pre-Mock, Mock1, Mock2, and Mock3 before implementing the conversion data into live event.

Confidential

Software/Technology: Oracle, SQL, PL/SQL, Unix Shell scripting.

Team Lead

Responsibilities:

  • Coordinate with offshore team and provide knowledge transfer and required support to complete the deliverables.
  • Effective participation & coordination in requirement gathering to understand and design based on business processes and review them.
  • Preparing SOW and updating the modifications in the procedures, packages and database.
  • Involved in all phases of database design, development, Testing, End user Training and support.
  • Production Support for Clarity Tool (Resource, Project, Timesheet), Added new features in the existing functionality. Tuning existing procedures, functions to improve the performance, Supporting Microsoft project and Open Workbench issues.
  • Scheduling daily jobs, weekly jobs, monthly jobs and Rollover jobs. Monitoring the production server performance, Monthly Rollover and Weekly Timesheets posting.
  • CRON Jobs scheduling in Unix.
  • Used SQL*Loader to load the flat file data like bulk employee embarkation, disembarkation to Oracle Tables. Developed materialized views for data replication in distributed environments.
  • Used Oracle supplied packages, Dynamic SQL, Records, and PL/SQL Tables, Ref Cursor, External Tables, and Collections.
  • Extensively worked in Tuning existing procedures, functions and packages to improve performance of the application. Used ANALYSE option and AWR, ADDM report to improve the performance.
  • Developed New Reports using Crystal Reports and modifying existing Crystal Reports based on business requirements.
  • Worked on Actual Reports for user requirements.

Confidential

Software/Technology: Oracle, SQL, PL/SQL, Unix Shell scripting, Java.

Team Lead

Responsibilities:

  • Oracle Forms Developer, designed forms of Custom screens and Modifying Existing forms.
  • Oracle BI Publisher, Custom Reports designed using this tool.
  • Oracle PL/SQL Developer, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
  • Requirement Analysis, Designing, Development.
  • Designing new tables using Normalization.
  • Developing Stored Procedures, Triggers, Functions and Packages.
  • Involved in Tuning Existing Queries, Views, Packages.
  • Used SQL*Loader to load the flat file data to Oracle Tables.
  • Created indexes on the tables for faster retrieval of the data to enhance database performance.
  • Oracle performance related features such as Query Optimizer, Execution Plan and Indexes.

Confidential

Software/Technology: SQL, PL/SQL, Forms & Reports

Team member

Responsibilities:

  • Production Support for different clients like JET Airways, Aero Mexico, Philippines Airlines etc.
  • Loading new member details, Cancellation details from flat file to oracle tables using SQL Loader and generating acknowledgement for that.
  • Loading the Confidential Miles, fare details from flat files to the respective tables.
  • Maintaining Family member details like family head and family members. Based on Percentage definition travelled member/family member points may change.
  • Calculating the points based on the miles travelled. Maintaining the the member levels based on points earned.
  • Designing different types of report to generate the acknowledgement for data loading.
  • Generating the report to the client about the member travelled in different airlines other than the member registered.
  • Writing backend procedures to populate details in the front-end screens.
  • Scheduling jobs like daily/monthly/yearly.
  • Involved in query tuning, database performance tuning. Used different techniques like Explain plan, TKPROF.

Confidential

Software/Technology: Oracle EBS, SQL, PL/SQL, Oracle Forms & Reports.

Team member

Responsibilities:

  • Involved in Developing Oracle Apps Forms and Reports.
  • Adding Oracle forms and Reports in Existing Oracle Apps Menu and Developed few Crystal Reports.
  • Worked as Business Analyst. Involved in requirement gathering, design, development, product delivery and user Training.
  • Designed new forms for warning and appreciation Module.
  • Warning module will have different warning category like verbal/written warning.
  • Appreciation module will have different types of appreciation.
  • SQL*Loader to load flat file data to Oracle Tables.
  • Designed Forms and Reports for Time monitor (Attendance) system.
  • Designed Reports to show Tardy and Overtime Reports based on shift timings entered in the database.
  • Developed procedures to send mail to immediate reporting supervisor.
  • Developed memo based on daily Roaster attendance data.
  • Used different techniques to improve query performance like creating index based on the requirements.

Confidential

Software/Technology: SQL, PL/SQL, Java

Team Member

Responsibilities:

  • Worked as Business Analyst. Involved in requirement gathering, design, development, product delivery and user Training.
  • Loading flat file data to corresponding oracle database tables.
  • Developed procedures, Functions, and Packages for analyzing the E2E activities like number of enquiries, fault complaints, resolved complaints, in progress and Repeating same complaints for different type of connection ex. PSTN.
  • Calculating the percentages based on the number of fault calls and resolved calls.
  • Developed SQL report and Dashboard to show all the above details.
  • Used External table to do calculation outside database to improve performance.
  • Created many reports using Crystal Reports for display the different products enquiry and show the product wise issues reported and resolved details.

Confidential

Software/Technology: SQL, PL/SQL, Oracle Forms & Reports.

Team Member

Responsibilities:

  • Designed front end form to enter the link between main product and sub products/items and quantity.
  • Worked as Business Analyst. Involved in requirement gathering, design, development, product delivery and user Training.
  • Developed Report to show the main product and sub products/items.
  • Designed front end form to enter the link between machine and component.
  • Worked as Business Analyst. Involved in requirement gathering, design, development, product delivery and user Training.
  • Developed Report to show machine and corresponding component list.
  • Designed front end form contains types of projects, types of components details.
  • Automatic tool number creation for new tools to corresponding projects.
  • Linking the component with corresponding tool, Linking the main tool with its child tool according to change over parts, New tool status i.e. design level, manufacturing level or in use, Generating the complete report of the tool.
  • Worked as Business Analyst. Involved in requirement gathering, design, development, product delivery and user Training.
  • Worked as Business Analyst. Involved in requirement gathering, design, development, product delivery and user Training.
  • Designed front end form to enter the link between machine and component and capacity of machine produce the component.
  • Designed front end to enter the BOM (Bill of Material).
  • Designed report to show capacity of the machine based on the above 2 table details.
  • Designed the report to show required manpower and time to produce the product.
  • Developed the final report for forecasting future month requirement.
  • Designed front end form to enter employee personal details, Salary, Loan, saving and attendance details.
  • Developed procedures and functions to generate monthly pay slip based on the above table details.
  • Designed report to show the employee with corresponding departments.
  • Designed different types of reports PF, ESI and Canteen deductions and Generating Form16, Form24, Form3A, ESI statement, PF statement, Loan statement.
  • Designed front end forms to enter store materials (component list), stock, Goods received (GRN), Goods Quality Check ( Confidential ), Material issue receipt (MIR), purchase order, Gate pass details.
  • Developed reports to show the details of stock in hand, required component based on the capacity plan for next month.
  • Developed procedures and functions to update the stock based on the Goods quality check pass, Material issue receipt.
  • Developed report for the Sales order, Gate pass, Purchase order.
  • Developed financial reports based on Payment order, Sales order.

Hire Now