OBJECTIVE

Highly competent Senior Technical Lead with 11 years of IT experience in Oracle PL SQL, Oracle Application Express, Autosys Scheduler, Shell Scripting including data modeling, application/database design with primary experience in Credit Card - Collections seeks a challenging senior IT position that fully utilizes strong customer service attitude, exceptional organizational ability and communication skills.

SUMMARY

• Over 11 years of experience in Oracle PL SQL, Oracle Application Express, SQL Loader, Support Central Reports and Shell Scripting
• Comprehensive Experience in Analysis, Design and Development (Coding, Testing & Maintenance) of various types of oracle technology based projects in multi-tier environment for sectors like Banking, Finance and Credit Card.
• Oracle PL SQL consultant to develop the applications on Collections Skip Tracing Process, Hardship Enrollment Program, Post Office Returns, Statement Generation, Debt Buyer and Remittance Processing Center for Credit Card domain.
• Supported development effort by providing SQL statement tuning and optimizing SQL procedures and removing load and query performance bottlenecks by using tools Explain Plan and SQL Trace.
• Pronounce experience by developing customize reports using Support Central Database Report tool
• Prepare prototype ofGUI with Oracle Application Express and present to client to get sign off on requirements and design.
• Develop scripts with support of loading CSV, TXT,XLS, pipe delimited doc file
• Extensive database development skills using SQL, Stored Procedures, Functions, and Packages in PL/SQL for Relation Databases Oracle and developing Autosys JILs for Batch Schedulers.
• Involved in database design by following DDL standards - naming conventions, column order, metadata inclusion, indexing, table spaces, referential integrity constraints, default values, column check constraints, primary keys, and permissions.
• Experience in conversion project from Pro *C code in to Oracle PLSQL.
• Prepared Technical design document, Use cases, Test cases and User manuals for various projects and good at Bug fixing, Code reviews, and Unit & System testing
• Extensive noledge in working with Oracle 9i/10g, PL/SQL, TOAD, SQL* PLUS, SQL*Loader, UNIX shell scripting, NDM, SFTP.
• Performing responsibility as mentor for the new comers in the project by conducting noledge sharing sessions.
• Experience in Single Sign On (SSO) with IDM and Siteminder Authorization
• Good Experience on Payment Card Industry Compliance Standards
• Experience working independently as a lead and in a team-oriented, collaborative environment
• Experienced with project planning, execution, monitoring and resource balancing and prioritizing skills with ability to support multiple simultaneous projects

TECHNICAL SKILLS

Environments: Windows 7, XP/2000/98, UNIX

RDBMS/ DB: Oracle 9i/10g/11g, MS access

Methodologies & Tools: SQL Developer 2000, Oracle PLSQL Developer, Shell Scripting, AWK, SED, VI/VIM Editor, SVN, HP Quality Centre 9.2, MS Excel, MS Visio, Power point. HTML, XML

Reports: Active Reports, Support Central, Data Forms

Others: Autosys, Crontab, SSH, NDM, SMTP, HPOV

Web Technologies: Apache TOMCAT, Web Server 7, Glassfish, Core Java, JDBC

Domain Knowledge: Credit Card Application Processing, Remittance Processing Center, Collections, Statement Generation Process

PROFESSIONAL EXPERIENCE

Confidential, Frisco, TX

Technical Architect

Responsibilities:

• Use of DB LINKS for accessing data across different databases.
• Tuned SQL Statements using EXPLAIN PLAN, SQL-TRACE and TKPROF.
• Writing complex PL/SQL code and SQL queries.
• Develop backend procedures by using PL/SQL
• Wrote triggers and packages by using PL/SQL for giving security privileges
• Prepared the Test conditions and test scripts using standard templates.
• Developed schedule scripts in autosys
• Project status tracking, resource allocation and management
• Working closely with the business in understanding the requirement and interacting with the technology team to pass the detailed requirement
• Conducting walkthroughs of the Functional Specifications with the users and technical team in order to ensure a complete understanding of the requirements.
• Obtaining sign-off of requirements documents and functional design with business clients
• Leading presentations in architecture review, strategic technology directions, best practice development
• Involving in performance tuning of the queries, review and provide recommendations to the application developers
• Integrating with many upstream and downstream systems
• Writing test plans and test scripts, and create testing data for use in Quality Assurance testing.
• Release Activities

Environment: Linux, Oracle 11g, DB Link, Autosys, Shell Scripting, SQL Loader, DB Rule Engine, HPOV, J2EE

Confidential, Frisco, TX

Technical Lead

Responsibilities:

• Develop migration validation code in PLSQL Package.
• Migrating the schema, users, application ids, user objects like tables, triggers, synonyms, indexes into the new data center
• Working with storage team to take dump
• Validating the DB performance on the new database
• Preparing application pre-migration planning to the new data center and impact assessment
• Creating project documentation such as risk register, issue register, acceptance criteria, project controls, job descriptions, project progress report, change management report
• Interfacing with Network Engineers, Systems, Storage, Project Management and Database Administrators
• Analyzing the traffic drop while connecting to external teams along with Environment Performance Testing team
• Defining data quality monitoring solution and Preparing checklists to cover end-end provision to the customers

Environment: Oracle 9i, Oracle 10g, Autosys, Shell Scripting, SQL Loader, SFTP, DB Link, DB Rule Engine, HPOV, J2EE Linux, GENTRAN, Middleware

Confidential, Stamford, CT

Technical Lead

Responsibilities:

• PL/SQL was extensively utilized for coding and writing complex database triggers, stored procedures and packages.
• Involved in design and development (LLD & HLD) of system architecture and database.
• Prepared ER diagram using Visio tool
• Developed business rules classes based on business requirement.
• Develop Reports to facilitate useful output from system in forms of reports using Support Central Reports
• Develop test case and test script to perform DIT in development environment before handing
• Tuned SQL queries and performed refinement of the database design
• Developed Scripts in Autosys and Shell Scripting
• Providing technical leadership to development team and act as a bridge between Business and Application Development team

Environment: UNIX, Oracle 9i, Autosys, SFTP, HPOV, J2EE, GENTRAN, Middleware ODS, Target Stream

Confidential, Stamford, CT

Technical Lead

Responsibilities:

• Developed prototype using Oracle Application express.
• Developed the Oracle queries, SQL procedures
• Involving in performance tuning of the queries, review and provide recommendations to the application developers
• Project status tracking, resource allocation and management
• Providing technical leadership to development team and act as a bridge between Business and Application Development team
• Ability to deliver all required artifacts throughout the project life cycle
• Conducting walkthroughs of the Functional Specifications with the users and technical team in order to ensure a complete understanding of the requirements.
• Conducting code reviews to ensure developers and engineers are adhering to development guidelines
• Writing test plans and test scripts, and create testing data for use in Quality Assurance testing.
• Leading testing efforts, ensuring that issues are identified, tracked, reported
• Release Activities

Environment: UNIX, Oracle 11g, Oracle Application Express, Autosys, HPOV, Web Server 7, Glassfish.

Confidential

Project Manager

Responsibilities:

• Coordination and Completion of projects within the information technology department
• Developing and managing appropriate project plans, including resource identification and allocation, budgets, timelines and milestones.
• Assigning priorities, balance workload among the team according to competence, expertise and availability
• Assessing results and determines and implements risk mitigation solutions as appropriate
• Overseeing all aspects of projects including estimates, requirements, design, development, testing, deployment, and documentation
• Interacting with Client, Service Delivery and Project Management representatives for project status and progress. Escalating issues and risks as appropriate
• Building and maintaining working relationships with team members, vendors, and other departments involved in the projects
• Leading a team in the technical design and delivery of products and Taking responsibility for on-time delivery of solutions
• Applying noledge of system capabilities and user requirements to identify opportunities for system functionality innovation and alternative solutions
• Managing onsite/offshore team size of more than 15 members.

Environment: Oracle 9i, Autosys, SFTP, HPOV, J2EE, GENTRAN, Middleware ODS, Glassfish, WebServer7

Confidential

Technical Lead

Responsibilities:

• Involved in design and development (LLD & HLD) of system architecture and database.
• Prepared ER diagram using Visio tool
• Developed and design database stored procedure, views and functions.
• Developed business rules classes based on business requirement.
• Develop Reports to facilitate useful output in forms of reports using Support Central Reports
• Develop test script to perform DIT in development environment before handing over to QA team.
• Tuned SQL queries and performed refinement of the database design leading to significant improvement in system response time and efficiency.
• Developed Scripts in Autosys and Shell Scripting
• Providing technical leadership to development team and act as a bridge between Business and Application Development team

Environment: Oracle 9i, Autosys, XML Rule Engine, SFTP, HPOV, J2EE, GENTRAN, Middleware ODS

Confidential

Developer, Technical Lead

Responsibilities:

• PL/SQL was extensively utilized for coding and writing complex database triggers, stored procedures and packages.
• Involved in design and development (LLD & HLD) of system architecture and database.
• Prepared ER diagram using Visio tool
• Developed and design database stored procedure, views and functions.
• Developed business rules classes based on business requirement.
• Develop Reports to facilitate useful output from system in forms of reports using Support Central Reports
• Develop test case and test script to perform DIT in development environment before handing over to QA team.
• Tuned SQL queries and performed refinement of the database design leading to significant improvement in system response time and efficiency.
• Developed Scripts in Autosys and Shell Scripting

Environment: Oracle 9i, Autosys, XML Rule Engine, SFTP, HPOV, J2EE, GENTRAN, Middleware ODS

Confidential, Federal Way, WA

Data Conversion Programmer

Responsibilities:

• Loading the sold data from Confidential to other party.
• Running the jobs using the DATASTAGE ETL tool to extract the tables from other databases and load the tables into SAP environment.

Environment: Oracle 8i, MS Access, DataStage, SAP

Confidential

Technical Lead

Responsibilities:

• Actively involved in analysis, design, programming, implementing and customization of application using VB6, Active Reports.

Environment: Visual Basic 6.0, DLL Programming, Oracle 8i,Active Reports