Summary

• 9 years of experience in Information Technology IT industry.
• Exceptional database skills with 6 years of experience as Oracle PL/SQL developer.
• Design source to target mapping and developed technical design documents using Data Warehouse Dimensional modeling Type 2 Slowly Changing Dimension.
• Expertise using OLAP Online Analytical Processing , OLTP Online Transaction Processing .
• Experience with Power Designer to design high level conceptual model, detailed conceptual model, logical model and physical model.
• Experience with Data Analysis tools like TOAD, PL/SQL Developer and Rapid SQL access data for querying and reporting.
• Experience with creation of Database objects like Tables, Views, Synonyms, Sequences, Index, Constraints, Partitions, Clusters, Stored Procedures, Functions, Packages, Cursors, Ref Cursors, TKPROF, EXP/IMP, Exceptions, Complex Joins, Triggers, Materialized views and Autonomous Transactions.
• Developed ETL Data Extraction, Data Mapping, Data Conversion and Data Loading using SQL, PL/SQL, Oracle 11G Forms, SQL Loader and various UNIX Shell Scripting.
• Extensive knowledge and experience in Software Development Life Cycle SDLC from requirements gathering to post production support.
• Experience in creating SQL loader scripts to load data from flat files into the database.
• Ability to explain technical concepts and communicate with users and system administrators at all levels. Extensively involved in SQL tuning, troubleshooting, debugging and fixing the codes/scripts.
• Responsible for the co-ordination and deliverables of a 10 member offshore team.
• Excellent presentation communication skills, analytic skills and problem solving abilities.
• Strong interpersonal skills with good Team management and Team development experience.
• Excel in team collaboration and solution brainstorming.
• An individual contributor and can work with little or no supervision in handling multiple tasks. Quick learner and rise to the situation.

Technical Skills

• Databases: Oracle 11g/10g/9i/8i, DB2, Sybase, MS Access 2000
• Languages Tools: SQL, PL/SQL, C, Pro C, Pro COBOL, SQL Loader, UNIX Shell Scripting, Perl
• Operating Systems: UNIX, MS Windows XP/2003/2000/NT, MS DOS, TUXEDO, MS Visio
• UNIX Platforms: Sun Solaris 9, IBM AIX 4.3.3, HP-UX 11.22
• Data Analysis Tools: TOAD, Pl/Sql Developer
• Data Modeling Tools: Power Designer
• Job Schedulers: Cron, Maestro
• Version Control Tools: MS Visual Source Safe, Rational Clear Case, Harvest
• Concepts :OLAP Online Analytical Processing , OLTP Online Transaction Processing Systems

PROFESSIONAL EXPERIENCE

Confidential

Role - Onsite Coordinator

Environment - Pro Cobol, Pro C, PL/SQL, SQL Plus, UNIX Shell script.

Tools - SecureCRT, Putty, Ultra Edit, File Zilla.

Responsibilities:

• Coordinating with Clients and leading an offshore 10 member team regarding project deliverables.
• Involved in requirement analysis, estimation, design, coding unit testing, system testing, UAT support, production support and coordination.
• Reviewing the project deliverables and supporting till project implementation in Production environment.
• Resolving the Production P1, P2, P3 critical tickets in stipulated SLA time on daily basis.
• Responsible for entire Billing process of PNM Resources.
• Involved in Performance tuning, which included creating indexes, providing Hints, modifying tables, analyze tables and estimate stats using explain plan utility.
• Monitor and respond to Adhoc trouble tickets generated by the HEAT Ticket Management system.
• Provide oncall support for high priority issues in batch and online environments.
• Research and provide solution for new enhancements and code defects.
• Create ad-hoc reports and data extracts using PL/SQL and SQL queries.

Confidential

Role - Onsite Coordinator.

Environment - PL/SQL, UNIX Shell script.

Tools - Putty, Ultra Edit, PL/SQL Developer.

Responsibilities:

• Coordinate with Clients, 2 third party vendors and offshore team.
• Organize client meetings and gather requirements from Business and third party vendors.
• Involved in requirement analysis, estimation, design, coding unit testing, system testing, UAT support, production implementation and post production support.
• Developed and implemented PL/SQL stored procedures packages for Outage communication.
• Developed UNIX Shell script to invoke PL/SQL procedures.
• Developed parameters to schedule batch Jobs in Appworx 8.
• Hands on experience in Database triggers, table creation, views and sequences.
• Review the project deliverables from offshore team and supported till project implementation in Production environment.
• Provide post production support to resolve real time issues and guide Business.

Confidential

Role - Onsite Coordinator.

Environment - Pro Cobol, Pro C, PL/SQL, UNIX Shell script.

Tools - SecureCRT, Putty, Ultra Edit, File Zilla, Appworx 7.

Responsibilities:

• Coordinate with Clients, third party vendor and 5 member offshore team.
• Organize client meetings and gather requirements from Business.
• Involved in requirement analysis, estimation, design, coding unit testing, system testing, UAT support, production implementation and post production support.
• Designed the requirements and Developed in Pro COBOL and Pro C languages.
• Developed UNIX Shell script tools.
• Developed parameters to schedule batch Jobs in Appworx 7.
• Reviewed, calculated the bills and ensured the correctness of the bill.
• Review the project deliverables from offshore team and supported till project implementation in Production environment.

Confidential

Role - Team Leader

Environment - Oracle, PL/SQL, JCL, ISPF, COBOL Z/OS, DB2, Eztrieve, VSAM

Tools - FILE-AID, ENDEVOR, OPC

Responsibilities:

• Leading the offshore team and Coordinating with onsite regarding project deliverables.
• Involvement in full SDLC process including gathering requirements from Business users, performing high level requirement analysis, estimation for the requirement, in depth analysis and design, development, unit testing, User acceptance testing, implementation and support.
• Analysed the requirements and created the functional and technical requirement specification document.
• Worked in migration of Mainframe to ORACLE database for 100K DUNS
• Performing peer review.
• Developed and implemented PL/SQL stored procedures packages.
• Coordinate the status call between onsite and offshore regarding the deliverables.
• Participating in Knowledge transfer, team discussions and status calls.

Confidential

Role - Team member

Environment - PL/SQL, ORACLE 10g, SQL Loader, SQL Plus, UNIX Shell scripting

Responsibilities:

• Experience in understanding CAMP Compliance analysis documents and prepared corresponding technical design documents.
• Design source to target mapping documentation and designed DataWarehouse Dimensional model using Type 2 Slowly Changing Dimensions.
• Strong Knowledge in ETL Extraction Transformation and Loading using SQL, PL/SQL and Unix Shell Scripting.
• Development knowledge in creating Packages, Functions, Procedures, views, exceptions etc.
• Provided solutions for partition adjustment tasks, Includes creating new partitions and moving data between different set of partitions.
• Improved partition techniques on daily, weekly, monthly, and yearly partitions. Improved analyzing techniques before processing tables and after processing tables by on demand.
• Automate Oracle scripts using Unix Shell Scripting and Experience file manipulation using Unix AWK scripting and Translated UNIX wrapper scripts from UNIX to Linux operating systems
• Solutions satisfy HSBC business requirements and delivered in a timely manner.