Resume

Resume Details
A. B.
Location	Lansing, MI
Contact	Click to View Contact
Source	Direct Candidate
Salary	N.A.
Rate	N.A.
Skills: Accounts-Accounts Payable/Receivable, Accounts-General Ledger, CEO/CIO/Executives-Leadership, IT-Business Analyst, IT-ClearCase, IT-Crystal Reports, IT-DHTML, IT-Data Warehouse, IT-Database Design, IT-EJB, IT-ERP, IT-ETL, IT-HTML, IT-Informatica, IT-J2EE
Resume

Summary
• Strong Analytical, Database and Reporting skills
 • Extensive 8+ years of overall professional experience in relational databases design and development in Oracle 8i/9i/10g databases and developing applications in PL/SQL, SQL Loader,  TSQL, Oracle Forms. Actively involved in full database development life cycle in Oracle 10g/9i/8i.
  Perform Oracle database tuning using sql plan area, tkprof, explain plan.
  Extensive experience in SQL, Stored Procedures, Packages, Triggers, Joins, Performance Tuning and Batch Processing on Oracle, SQL Server
 • J2EE developer with 7 years of professional experience in user interaction, systems analysis, design, development and implementation of many Web Based Application systems in Internet and Intranet environment
 • Strong development skills in Java, JDBC, JSP, Servlets,  EJB (J2EE), JNDI, RMI, HTML, DHTML, XML, XSL, Java Script, Rational Rose and Macromedia tools.
 • Experience in Client interviewing, Requirement capturing and Design of Project Specifications.
 • Experience in Business Process Reengineering.
 • Computer professional with solid knowledge of internet and intranet application development
  Good leadership qualities, excellent communication and interpersonal skills. Excellent analytical ability, Project management skills and presentation skills. Proactive. Efficient team member and resourceful with ability to grasp complex fundamentals quickly with little instruction
 

Certifications
Oracle Certified Database Application Developer 
 Oracle Certified in Oracle Web Deployment.
 Brain bench certified Java programmer.
 TQM certified in Quality System Implementation.

Experience
Project  Child Support Enforcement System- State of Michigan
 Location Lansing, MI, USA
 Role Programmer/Analyst
 Platform Client/Server, Oracle Database
 Technology/Software SQL, PL/SQL, Oracle Forms 9i, Reports 9i, Designer 9i, XML, J2EE
 Duration Dec 2005 till Date
 Client Accenture
 MiCSES is a child support financials system that enforces the childcare responsibilities on the divorced parents.  It collects money through various means – employer, unemployment agencies, insurance, tax returns and bank accounts. MiCSES also penalizes through credit reporting, professional license suspension, drivers license suspension, passport cancellation and also imprisonment.  
 The development work consisted of managing the new cases, cash flows – collection, reconciliation, distribution and disbursement.  It also handled various real life scenarios of collection enforcement systems. The system has been developed completely in Oracle using SQL, PL/SQL, Forms 9i and Reports 9i.
 
 • Provided production support for application /group of applications. These activities included problem analysis, break/fix, testing, and promotion to the production environment.
 • Actively participated in JADs/requirements/functional design sessions as assigned.
 • Analyze, code, and test simple to complex modules (both new and changes to existing programs) from design specifications.  Ensured that the finished product meets the design objectives and any other appropriate criteria associated with the original request.  Produced a complete and accurate documentation for work based on current documentation standards.
 • Create and maintain database schema objects accessed by various stored procedures, functions and triggers.
 • Code database stored procedures, functions and triggers in PL/SQL to provide core MiCSES functionality.
 • Code complex stored procedures using collections, ref cursors and do bulk processing.
 • Implement stored procedures to parse a XML file and gather data to store it in different tables. 
 • Generate reports with bulk processing using PL/SQL, code stored procedures to generate report files by querying data from data warehouse structures such as materialized views and dimensions.
 • Responsible for Requirements Definition Analysis, translating Functional and Business requirements into Technical Requirements.
 • Responsible for Application Design Analysis, assisting the functional leads in developing application functional designs in support of the business policy
 • Provides policy ,business and technical procedure input into the development of training materials
 • Creates business and Technical procedures to ensure adherence to policy and legislation
 • Conducts requirements analysis for all new work orders received by the development team and ensure that the technical requirements are properly documented.
 • Supports the application team in analyzing new requirements and ensuring designs properly represent business needs.
 • Programming to translate the Technical requirements to real code. Writing Packages, procedures and function in PL/SQL.
 • Technical design and Code peer reviews.
 • Writing and executing Unit/String test plans and ensuring that the code adheres to technical requirements.
 • Wrote Packages/Procedures in PL/SQL for reading data from text /XML files and producing output in text/XML files.
 • Writing Ad-Hoc SQL queries to enable users to view data as required.
 • Remedy documentation for production issues.
 • All status updates (Test Tracker, Time Tracker, Remedy, etc.)
 • Contributed to work estimates as necessary
 • Received client appreciation for resolving a 2-year old system problem that was eluding solution.
 
 Project  Department of Developmental Services – State of California
 Location Sacramento, California
 Role Forms, PL/SQL Programmer
 Platform Client/Server, Unix, Oracle Application 11.03
 Technology/Software Oracle 9i PL/SQL, Forms, MS Access 
 Duration July 2004 to Dec 2005
 Client Deloitte   Touche
 Project    Department of Developmental Services
 Description   CADDIS (California Developmental Disabilities Information  
                                                   System) Implementation of Health Care ERP package 
 • Import data in the CSV format into database tables using SQL Loader.
 • Maintain application versioning using Rational ClearCase software.
 • Generate xml files using Oracle XMLGEN package to provide conversion of data in xml format into a PowerPoint presentation using Tonic Systems API.
 • Execute autonomous transactions in PL/SQL to perform independent tasks.
 • Make use of ref cursors, Varrays and PL/SQL tables to process data and load/retrieve data from database tables.
 • Worked with Application Architect and Business Analyst to confirm and substantiate functional and technical designs. 
 • Produced required coding design documentation 
 • The different covered areas are Consumer Case Development, POS (Purchase of Service), Trust management and financial modules like GL, Account Payable.
 • Configuring Echo’s Share Care application to suit the CADDIS Application 
 • Developed Data mapping and data Conversion scripts to move data from legacy systems 
 • Monitoring the over all performance and tuning the various performance bottlenecks using scripts . 
 • Loading data using Oracle SQL/Loader, Exp/Imp 
 • Creating packages to move code, database changes to production environment 
 • Constructing packages and using oracle built in packages 
 • Implementing the Partition Tables, Partition Indexes, Partition splitting etc. Worked with huge tables with multi million rows as needed 
 • Providing functional inputs and database application design inputs to the programmers 
 • Effectively using the native dynamic SQL, autonomous transactions, temporary tables, bulk binding, dbms profiler, dbms trace, ref cursor features in PL/SQL 
 • Handling security issues concerning creating and administering roles, object and system privileges to users, user account creation and maintaining 
 • Wrote moderate to complex SQL queries.
 • Tune SQL statements using explain plan, hints, query rewrite hints, index hints and using cost-based optimizer. 
 
 Project  Economic,Financial and Forensic Consulting
 Location Denver, Colorado
 Role Programmer/Analyst
 Platform Client/Server, Oracle Database, SQL Server, MS Access
 Technology/Software SQL, PL/SQL, Oracle Forms 9i
 Duration June 2002 to July 2004
 Client    Zeeb   Company (Formally Arthur Anderson), Qwest, AT T, Exxon
 • Design a very flexible hierarchical Oracle database to establish a parent and child relationship between tables records that eliminates any need for structural changes.
 • Provide data feed to JSP applications using stored procedures and functions.
 • Manage test, development and production database systems.
 • Perform logical and physical database backups using EXP utility and user -managed backups.
 • Provide support for UAT and production database systems.
 • Design the application and data schema in development, test and production database systems.
 • Wrote SQL queries for user interaction with system
 • Wrote PL/SQL Functions, Procedures and Packages
 • Client meeting and interviews for requirement capturing.
 • Create and Document Work procedures.
 • Importing the raw Data from Client into our Database.
 • Perform Data cleanup, standardization and necessary modification.
 • Create necessary Rollup tables and Database views 
 • Wrote SQL queries, Procedures and functions for performing the analysis.
 • Write SQL for Crystal Reports, Queries and extracts.
 • Using TSQL writing stored procedures and functions and Database Triggers.
 • Fine Tuning Database and optimizing query execution.
 • Use MS excel to fine tune analysis.
 • Document the findings and Project deliverables.
 • Create fact tables for the findings and presentation to client/other side.
 • Implement advanced database replication using user managed sql scripts by creating materialized views on the remote site to keep it in sync with data on the master site to provide high data availability.
 
 
 
 Project  Requirement Capturing and Techinical Specs
 Location Denver, Co
 Role Programmer/Analyst
 Platform Client/Server, Oracle Database, SQL Server, MS Access
 Technology/Software SQL, PL/SQL, MS SQL Server, Java Script, VB Script
 Duration Feb 2001 to June 2002
 Client Syscommes Inc.
 • Business Interviewing and Requirement Capturing. BPR.
 • Prepared Software Requirements specification (SRS).
 • Preparation of system design including Entity relationship diagram, Dataflow diagram and Function Hierarchy diagram.
 • Preparation of Test Specifications
 • Regular Interaction with Module leaders regarding inter-functional communication and inter-functional Data flow.
 • Development and testing stored procedures and Functions.
 • Generation of SQL DDL.
 • Creating module data diagrams.
 • Using TSQL for writing stored procedures, functions and Database Triggers.
 • Implement database audit using database triggers to monitor the user activities.
 • Manage application implemented in Java and Perl that uses Weblogic Server.
 • Carry out database performance tuning such as tuning SQL statements, tuning database structures, creating indexes, using explain plan for improving the processing time.
 • Conversion of excel based system into User Interface screen systems driven by database.
 • Requirement gathering, review meeting and implementation of six-sigma methodologies
 • Development of user transaction screens and reports using JSP, Java, PL/SQL
 • Designed and Developed views, database triggers, packages, procedures and functions.
 • Creation of data warehouse extracts and interfaces with Oracle GL to estimate actual costs
 • PL/SQL was extensively utilized for coding and writing complex database views, triggers, stored procedures and packages.
 • SQL*LOADER was used for data loading of Data warehouse feeds.
 • Involved in Planning, Designing, Developing and Implementing application and data migration
 • Performance tuning and Optimization of large database using parallel query options for fast accessing data and reports
 • Writing Unix Shell Scripts for batch process and data loading
 • Creating Mapping and Transformation using Informatica (ETL tool)
 
 
 Project  Extranet Oracle Application for Dealers
 Location Delhi, India
 Role Programmer/Analyst
 Platform Client/Server, Oracle Database
 Technology/Software Oracle Web Application Server(11i),SQL, PL/SQL, Java Script, VB Script, Front Page,JSP,J2EE, Servlets, EJB, Struts, XML, JNDI, JDBC, Weblogic ,Web Services, UML
 Duration Dec 1999 to Jan 2001
 Client Maruti Udyog Ltd. 
 • Creating and maintaining Oracle Web Forms.
 • PL/SQL Coding, Optimization and String Testing.
 • Implemented one production release of backend Batch Othp Merge, new form FRM OTHX, FRM OTHP and its corresponding SPKG OTHX, SPKG OTHP. 
 
 Project  Material Management System
 Location 
 Role Programmer
 Platform Web based Application
 Technology/Software Oracle Web Application Server (4.03), SQL, PL/SQL, Java Script, VB Script, Front Page
 Duration June 1999 to Dec 1999
 Client Jindal Strips Ltd
 
 • Developed critical Enhancements for web based invoicing system utilized by over 1400 users in two countries.
 • Utilized PL/SQL for web and Java script skills to develop application running on oracle Application server 4.03 with an oracle Database backend.
 • Programmed front-end interface.
 • Interfaced with Oracle Financial tables and stored procedures to retrieve and enforce corporate financial data and standards. 
 
 Project  Sales Management System
 Location Delhi, India
 Role Senior Associate
 Platform Web based Application
 Technology/Software Oracle 8i, SQL, PL/SQL, Java Script, VB Script, Front Page, Oracle Designer
 Duration Oct 1998 to June 1999
 Client Minda Industries Ltd.
 
 • Analysis of functional requirements using Process Modeler and Function Hierarchy Diagrammer
 • Data analysis using E-R Diagrammer
 • Logical database design in Oracle Designer using Database Design Transformer
 • Implementation of the physical database design
 • Defining Database Components, like table spaces, storage parameters
 • Front-end screens were extensively used with Forms 6i
 • Code in SQL,PL/SQL. Write SQL queries for users to accomplish complicated tasks.
 • Design, development and testing of form and report modules in Oracle Designer.
 
 Project  Loan Processing System
 Location Delhi, India
 Role Associate
 Platform Web based Application
 Technology/Software Oracle 8i, SQL, PL/SQL, ASP,VB Script, Oracle Designer
 Duration Aug 1997 to Oct 1998
 Client Associated India Pvt. Ltd.
 • Prepare a list of all the packages, procedures, functions required by the system with a brief description about them and their use.
 • Write Packages ,Procedures and Function in PL/SQL
 • Test and debug the application with test data.
 • Design the Front-end screens using forms.
 
 Project  BPR and ERP Implementation
 Location Delhi, India
 Role Senior Engineer
 Platform BPCS implementation
 Technology/Software Oracle 8i, SQL, PL/SQL, Oracle Designer
 Duration June 1996 to Aug1997
 Client GKN India
 • Member of Multi Disciplinary Team for conducting BPR and implementing BPCS
 • Participated in the Design of database
 • Created Database Tables, Users and worked on Privileges
 • Wrote stored Procedures   triggers in PL/SQL
 
 

Education
B.S. (Engg.) from REC Kurukshetra, India. 1996

Additional Informtation
.
<< Back
Resume

Similar Candidates
