We provide IT Staff Augmentation Services!

Programmer Analyst Resume Profile

CAREER SUMMARY

  • Over 13 years of experience in IT industry, working as a result oriented Oracle PL/SQL Developer with experience Unix scripting and Development/Maintenance of complex and critical systems.
  • Hands on experience with optimization and performance tuning of queries which are degrading the performance of the system.
  • Hands on experience for working in onsite/offshore model as an onsite coordinator and managing multiple assignments.
  • Worked on Data Migration project to consolidate data from different database servers into one database server.
  • Worked on data verification utility which will verify and validate data correctness once we migrate data from one database server to other.
  • Hands on experience in production support role, currently providing 24x7 support.
  • Hands on experience on tools like Toad, PL/SQL Developer and SQL Developer.
  • Hands on experience on SVN, PVCS and MS VSS.
  • Hands on experience with Data Modeling.
  • Understanding and knowledge of database administration activities.
  • Has good knowledge of overall process of rapid application development RAD .
  • Excellent analytical skills, logical reasoning, and interpersonal skills.
  • Strong team player , ability to work independently and in a team as well, ability to adapt to a rapidly changing environment, commitment towards learning, Possess excellent communication, project management, documentation, interpersonal skills.
  • Excellent analytical and interpersonal skills, oral and written communication skills.
  • Strong personal drive and ability to work individually and in team environments.

PROFESSIONAL EXPERIENCE

confidential

Specialist Technology

Description:

AppNexus technology powers the most innovative trading solutions and marketplaces for Internet advertising. AppNexus offers online auction infrastructure and technology for data management, optimization, financial clearing and support for directly negotiated advertising campaigns.

Responsibilities:

  • Working on development/maintenance and support of Open Ad Stream a web based Advertisement Management tool.
  • Wrote SQL, procedures, functions and packages to develop reports as per business need.
  • Worked on query optimization used in report to improve performance.
  • Tuned and optimized the complex SQL queries.
  • Working on detailed requirement understanding to offshore team and driving them towards on time and defect free system delivery.
  • Created database objects like tables, views, procedures, packages using Oracle tools like PL SQL developer and TOAD.
  • Wrote complex SQL queries using Joins, Sub queries and Group functions.
  • Executed PL/SQL blocks using cursors, REF cursors, exception handling, Collections -Nested tables and Index of Table and Dynamic SQL.
  • Working with business analysts and business people to understand the requirement submitted by them and transforming them into technical requirements.
  • Attending daily health status calls to provide updates on issues occurred during last 24 hours as well as on old issues which are not resolved yet.
  • Conceptual, Logical and Physical data modeling and design of tables/database using Erwin.
  • Designed/developed tables, views, various SQL queries, stored procedures, functions, triggers, complex PL/SQL packages.
  • Worked on SQL Loader to load data from flat files for UI Usage and UI Report Usage data for further processing. Used standard packages like UTL FILE, DMBS SQL, and PL/SQL Collections and used BULK Binding involved in writing database procedures, functions and packages for Front End Module.
  • Extensively worked with Dynamic SQL, Composite data types Global Temporary Tables.
  • Involved in application performance improvement through partitioning of very large tables. Used list and range partitioning.
  • Associated with DBA to work on performance related issues using explain plan, SQL Trace and query tuning.
  • Involved in PL/SQL code review and modification for the development of new requirements.
  • Creating change management tickets for deploying changes to production systems.
  • As a database developer working on development and maintenance of OAS application and my work involves writing procedures, functions, triggers, packages and performance tuning of queries to improve the performance of application.
  • As a database expert identify and optimize queries which are degrading the performance of the system.
  • Unit, integration and user acceptance testing of database code developed.
  • Maintenance of development and QA database servers.
  • Working as a production support resource to provide 24x7 availability of OAS applications. My work involves handling production support calls and providing appropriate solutions to resolve production issues and updating incident management tickets with solution provided. And creating another ticket for long term solutions as and when needed which will gets resolved as a part of maintenance activity.
  • Technologies: Oracle 10g/11g, SQL, PLSQL, Java, XML, Netx, Sybase, Sql Navigator, Toad, XML Spy, SQL Plus, Windows, Oracle 10/11g, UNIX

confidential

Technical Architect

Description:

Alliance Bernstein's investment services encompass value and growth equities, blend strategies, fixed income, alternatives and asset allocation. It also provides independent investment research, trading and brokerage-related services to Institutional clients through Sanford C. Bernstein Co. LLC and its London-based affiliate.

Responsibilities:

  • Worked as a Team Leader with Alliance Bernstein.
  • Worked on development/maintenance and support of Pacesetter system, a customized data warehouse system developed.
  • Design/Develop various technical components such as PLSQL and SQL Reports, workflows, etc. as well as participate in the maintenance of existing reports.
  • Worked with onsite coordinators to understand the requirement and preparation of functional and technical documents for team before starting development.
  • Designed and developed Risk engine rules to accept inputs and validate the input through defined set of rules and generate the output using PL/SQL procedures.
  • Created automated jobs using UNIX Shell scripts by passing all SQL scripts as parameters.
  • Involved in CMR creation and DB Changes Consolidation activities
  • Designed/developed tables, views, various SQL queries, stored procedures, functions, triggers, complex PL/SQL packages.
  • Worked on SQL Loader to load data from flat files for customized data warehouse system. Used standard packages like UTL FILE, DMBS SQL, and PL/SQL Collections and used BULK Binding involved in writing database procedures, functions and packages.
  • Involved in PL/SQL code review and modification for the development of new requirements.
  • Extensively worked with Dynamic SQL ,Composite data types Global Temporary Tables
  • Written processes for creation of customized ETL process to load data from files using Oracle PL/SQL coding and UNIX shell scripting.
  • Worked as a database support resource to maintain 24x7 availability of applications.

Technologies: Oracle 10g/11g, SQL, PLSQL, Java, XML, Netx, Sybase, Sql Navigator, Toad, XML Spy, SQL Plus, Windows, Oracle 10/11g, UNIX

confidential

Module Leader

Description:

The company's Global Automotive Services offer retail auto financing and leasing dealer lines of credit for vehicle inventory, equipment or facilities insurance coverages including retail vehicle service contracts and commercial insurance and remarketing services through physical auctions and online services. Ally Financial also operates Ally Servicing previously Semperian within its Global Automotive Services division. Ally Servicing provides customer relationship management, servicing, and collection through several inbound call centers across the U.S.

Responsibilities:

  • Worked as a Team Leader with GMAC General Motors Acceptance Corporation
  • Worked on development/maintenance and support of Information Warehouse a large relational database that contains account level and summary information on various GMAC lines of business.
  • Worked on the requirements and preparation of functional and technical documents for team before starting development.
  • Designed/developed tables, views, various SQL queries, stored procedures, functions, triggers, complex PL/SQL packages.
  • Developed PL/SQL packages and procedures for the back end processing of the proposed data base design.
  • Loaded data to database using oracle tools like SQL loader and external tables to load data.
  • Worked closely with Production Support team to Troubleshoot and fix any production issues.
  • Worked extensively on exception handling, to trouble-shoot PL/SQL code.
  • Prepared test plans and performed Unit Testing and Integration testing.
  • Worked on SQL Loader to load data from flat files for customized data warehouse system. Used standard packages like UTL FILE, DMBS SQL, and PL/SQL Collections and used BULK Binding involved in writing database procedures, functions and packages.
  • Extensively worked with Dynamic SQL Composite data types Global Temporary Tables.
  • Involved in PL/SQL code review and modification for the development of new requirements
  • Worked with team to minimize their load and written Packages, Procedures and Unix scripts for loading data into newly created tables using shell scripting for new line of business

Technologies: Oracle 10g/11g, SQL, PLSQL, Java, XML, Netx, Sybase, Sql Navigator, Toad, XML Spy, SQL Plus, Windows, Oracle 10/11g, Unix

confidential

Information Technology Analyst

Description:

As part of GE Capital, it offers products such as revolving lines of credit, floorplan finance, equipment leasing of various forms, real estate services, and car fleet management. The industries served include healthcare, manufacturing, fleet management, communications, construction, energy, aviation, infrastructure and equipment, as well as many others.

Responsibilities:

  • Worked on development/maintenance and support of GECARS GE Capital Accounts Receivable System a web based Accounts Receivables system.
  • Designed/developed tables, views, various SQL queries, stored procedures, functions, triggers, complex PL/SQL packages.
  • Writing extensive PL/SQL code for customizations as needed
  • Creation of unit test cases
  • Optimized SQL statements for customer summary reports.
  • Worked on SQL Loader to load data from flat files for customized data warehouse system. Used standard packages like UTL FILE, DMBS SQL, and PL/SQL Collections and used BULK Binding involved in writing database procedures, functions and packages.
  • Extensively worked with Dynamic SQL, Composite data types Global Temporary Tables.
  • Involved in PL/SQL code review and modification for the development of new requirements
  • Worked on visual basic, ASP and oracle code components to develop new components and maintaining old components of system.
  • Worked as a production support resource to maintain 24x7 availability of applications.
  • Technologies: Oracle 10g/11g, SQL, PLSQL, Java, XML, Netx, Sybase, Sql Navigator, Toad, XML Spy, SQL Plus, Windows, Oracle 10/11g, Unix

confidential

Programmer Analyst

Responsibilities:

  • Worked as a team member to design, develop and maintain EnCompass an ERP application designed and developed by Godrej InfoTech.
  • Worked on query optimization used in report to improve performance.
  • Tuned and optimized the complex SQL queries.
  • Solved critical production issues.
  • Created LINUX shell scripts to automate data loading, extraction and to perform regular updates to database tables to keep in sync with the incoming data from other sources
  • Created UNIX Korn shell scripts, which call the PL/SQL scripts and scheduled those using Autosys.
  • Developed Teradata Export Scripts in Linux environment using various LOGMECH, BTEQ FEXP.etc.
  • Worked on various modules of system to include new functionalities.
  • Worked on design and development of E-Sell For Distributors and E-Pos For Shops applications for Creative Garments Ltd a customer of Godrej InfoTech.
  • Technologies: Oracle 10g/11g, SQL, PLSQL, Java, XML, Netx, Sybase, Sql Navigator, Toad, XML Spy, SQL Plus, Windows, Oracle 10/11g, Unix
  • Confidential
  • Systems Engineer,
  • Responsibilities:
  • Worked as a team member for various in house customized application development and maintenance of software systems.
  • Involved mainly in loading claims ETL in to the system from different sources.
  • Loaded Data from flat file in DB through SQL Loader.
  • Created SQL Loader scripts to load data from external system to oracle.
  • Created UNIX Shell script for sending email to alert users for erroneous records.
  • Responsible for performance tuning of SQL queries written in procedures and functions at the back end which are called from the front end forms.
  • Technologies: Oracle 10g/11g, Forms 10g, Reports 10g, SQL, PLSQL, UNIX, Sql Navigator, Informatica, Erwin, Toad, UNIX, Oracle 10g RAC.

Confidential

Software Engineer,

Responsibilities:

  • Worked as a team member for design/development and maintenance of various applications developed for the clients of organization.
  • Worked on complete life cycle of various applications and products developed.
  • Created data entry Forms using oracle Forms 6i for entering data related to Order Information and inventory.
  • Assisted in the development of a standardized batch processing environment utilizing UNIX Korn shell scripting and the Autosys job scheduler
  • Built custom forms using Oracle Forms 6i Builder to fulfill the business requirements of the client.
  • Created and customized analytical reports for existing system using Reports 6i.
  • Environment: PL/SQL, Oracle 8i, Toad, Forms 6i, Reports 6i.

Hire Now