SUMMARY:

• Over 14 plus years of experience in IT industry as Oracle Project Lead, Technical Lead, Team Lead, and Developer with all phases of the SDLC (Software Development Life Cycle) from Analysis, Design, Development, Debugging, Testing, Implementation and Maintenance of projects .
• 14 years of Strong Database Design, Modeling and PL/SQL Programming experience of Business Applications using Oracle RDBMS, ETL Data flows/Processing and Data warehouse .
• Strong experience on Advanced PL/SQL programming in implementing the concepts and features using bulk collect, bind variables, ref cursors, execute Immediate, Exception handling, Procedures, Functions, Packages, Triggers, Upsert Merge statements, Autonomous transactions, Global Temporary tables, external tables, Hierarchical Queries, Aggregate Functions, Analytical Functions, Batch Jobs.
• Having extensive working experience in design, modeling and development using DB technologies like Oracle 10g/11g/12c, PL/SQL, SQL, Toad, PLSQL Developer, ETL, OLTP, OLAP, Query Tuning and Optimization and Web technologies like C#.Net, ASP.Net, ADO.Net, Web forms, Web API, REST Web services, Java Script, AJAX.
• Strong experience on Oracle SQL Performance Tuning using TKProf, analyzing the explain plan and implement the required optimizer hints in executing optimized queries.
• Experience in using ORACLE facilities, such as Import/Export, SQL*Loader and SQL*PLUS .
• Familiarity with Extraction, Transformation and Loading (ETL tools) to facilitate loading large amounts of data.
• Experience with developing system design specifications such as Entity Relationship(ER) Diagrams, Process Models, Data Modes Data Flow Diagrams .
• Having Experience with UNIX Cron Jobs, Batch Processing with highly complex data model and UNIX shell scripting.
• Having knowledge on Big Data Hadoop technologies stack, which includes HDFS, Sqoop, Hive, HQL, Pig, Oozie, HBase, Spark SQL/RDD/Data frames on Apache, Cloudera and Hortonworks Hadoop Distributions.
• Excellent experience in interacting with the Business and stakeholders, Gathering the requirements, analyze the requirements, design and recommend solutions.
• Experience on authoring technical design document and functional specifications and providing the solution from design in the software development life - cycle (SDLC) to implementation.
• Strong experience in coordinating and providing support to UAT/BAT/QA Team during testing phase of Project life cycle.
• Experience on working in a production support (24x7) environment, resolving the issues, providing support with technical and business issues.
• Experience in providing knowledge transfer and support to the team.
• Experience in working in an Agile and Waterfall Methodology.
• Experience in the project deliverables within the project timelines.
• Having experience in Project Management for distributed enterprise projects with cross-functional and geographical teams in an agile environment .
• Experienced Working in onsite-offshore development and delivery model for projects and products development.
• Strong Technical background mixed with Excellent Communication (Oral/Written), Inter-Personal Skills and Analytical skills .
• Good Team player and ability to lead and mentor the team.

TECHNICAL SKILLS:

Domain Knowledge: Banking, Treasury, Money Market, Finance, Health Confidential, Insurance, CRM, CS&M, e-Governance

DB Technologies: Oracle 8i, 9i, 10g, 11g, 12c, Oracle SQL, PL/SQL, Microsoft SQL Server, T-SQL, SQL*Plus, SQL Server, MySQL, Toad, Oracle Developer, PLSQL Developer, SQL Navigator

ETL Technologies: Oracle Data Integrator (ODI), Oracle Warehouse Builder (OWB) 10g, Oracle Business Intelligence (OBIEE)

Data Modeling: MS Visio, Erwin

Big Data Technologies: Hive, Hql, Sqoop, HDFS, Hbase, MapReduce, YARN, Spark SQL, Rdd/Data frames, Spark Streaming, Hadoop

Cloud Technologies: Amazon Web Services (AWS), EC2, S3, DynamoDB

GUI & Data Visualizations: Developer Suite -Forms 4.5/6i/9i/10g, Reports 2.5/6i/9i/10g, Oracle APEX 4.0, Tableau, Discoverer Reports, BI Publisher, Crystal Reports 6.0/10.0, VB 6.0

Web Technologies: MS Visual Studio 2010/2012/2013, .Net Framework 4.0/4.5, C#. Net, ASP.Net, ADO.Net, Web forms, Web API, REST Web Services, MVC, LINQ

Scheduling Tools: Control-M, JAMS, Autosys, Oracle Report Queue Manager

Scripting Technologies: Java Script, Ajax, JQuery, Anqular.js, HTML 5, CSS 3, XML, JSON, UNIX Shell Scripting

Version Control Tools: Source Off site, VSS, Clear Case, Subversion, Tortoise SVN, Team Foundation Server (TFS)

Operating Systems: Windows Client & Server OS, Windows CE 3.0, UNIX, Linux

Other Tools: Putty, Win SCP, Secure Shell, SVN, PVCS, Clear Case

PROFESSIONAL EXPERIENCE:

Confidential, Cincinnati, OH

Sr. Analyst Systems

Responsibilities:

• This Web based data driven application developed and Implemented for the Convergys
• Financial clients like “ Confidential”
• And for Telecom clients like “Confidential ”
• Depending on the client and line of Business (LOB) requirements it can be implementable and configurable for any Banking & Financial, Telecom, Insurance and Service oriented clients.
• Responsible for the development and delivery of projects in onshore and offshore model.
• Extensively involved in Analysis, Design, Development, Integration, Debugging, Testing, Build, Release, Implementation and Production/Technical Support.
• Preparing technical DFD’s, data pipelines, design documents, Visio Class and ERD diagrams as per Business functional and technical requirements.
• Design and development of complex PL/SQL scripts for business requirements, mappings, stored Procs, Packages and batch programs for Hourly, BOD and EOD.
• Worked on design of conceptual, logical and physical data models using Data modeling tools MS Visio.
• Developed the Toasts Notifications generating Procedural API’s, which is used by SignalR to push the Notifications on the UI dashboards.
• Developed the Skip level Notifications generating Batch program API’s, which runs hourly in Scheduler and records the all notifications details for missed thresholds on Metrics and Measures in DB Tables, which are pulled using MSMQ and pushed to mail servers Quick Connect and MS Outlook.
• Developed the Db Procedures and Packages to pull and Push the Current Interval, Last Interval and Cumulative data to the Role based Dashboards.
• Designed and Developed the Package API’s to pull filtered and transformed data from OLTP and OLAP data Marts in Real-time.
• Designed and Developed the Views and metalized views to abstract the complexity of multiple table joins and transformations.
• Design and Development of Batch programs like Procedure and Packages, which were configured using the JAMS and Control-M.
• Providing solutions for SQL queries, complex joins, Expertise in PL/SQL, Procedures, functions and packages.
• Worked on design of conceptual, logical and physical data models using various Data modeling tool MS Visio.
• Worked on SQL Query optimization & Performance tuning using Oracle PL/SQl Developer Explain Plan and DBMS XPLAN.
• Developed the Parallel running Batch Programs using DBMS Scheduler API.
• Extensively involved in Performing database, SQL’s, API’s tuning and optimization.
• Designed and developed the data migration Scripts and Programs to upgrade the Development, QA, UAT and Production DB schemas upgrade to Oracle 12c from Oracle 11g in Development and Production Environments.
• Performed need based DBA activities like DB schema creating and maintenance for Development, QA, QC and Staging environments, Jobs scheduling in Scheduler, Data Import from production for QA/QC, DB Objects Creation and validation.
• Interacting with UI development team to develop in tandem back-end solutions with front-end web executions.
• Providing recommendations to Architects regarding approach and identifies additions/changes necessary.
• Perform unit tests of system interfaces for complex programs prior to release of code for Quality Assurance testing.
• Assess risks, anticipate bottlenecks, provide escalation management, make tradeoffs, balance the business needs versus technical constraints and encourage risk taking behavior to maximize business benefit.
• Perform investigation and research for system environments (i.e., reporting systems, switching systems, computer systems, etc.) to assist in resolving complex programming problems or identifying solutions to new business requirements.
• Preparing WBS, Work Units Development effort estimation and assignment of activities to resources based on the competencies.
• Analyzing and prioritizing the production issue tickets and moving them from development to scheduled releases.
• Followed the Agile Methodology by understanding the user stories provided for entire implementation.

Environment: Oracle 11g/12c, PL/SQL, SQL, PL/SQL Developer, Responsive design, MS VS.Net 2013, C#.Net, ASP.Net, Web Forms, MVC 4, Web API (REST), SignalR, AngularJs, Java Script, Ajax, jQuery, HTML, Shell Scripting, JAMS, Control-M.

Confidential, Cincinnati, OH

Sr Database Developer

Responsibilities:

• Preparing technical DFD’s, data pipelines, design documents, Visio Class and ERD diagrams as per Business functional and technical requirements.
• Design and development of complex PL/SQL scripts for business requirements, mappings, stored procedures and batch programs for BOD and EOD schedules.
• Design and development of complex PL/SQL scripts for business requirements, mappings, stored procedures, Packages and batch jobs Using Oracle 10g & 11g.
• Designed and developed the logical and physical data models using Data modeling tool MS Visio.
• Developed ETL jobs for Data Extraction, Data Mapping and data Conversion from OLTP and OLAP schemas using SQL, PL/SQL in OWB.
• Developed the Role, Scorecard, LOB based Notifications generation workflow and configurations.
• Developed the Notifications generating Batch Job API’s, which runs hourly in Scheduler and records the all notifications details for missed Skills, Metrics and Measures in DB, which are pulled using MSMQ and pushed to mail servers Quick Connect and MS Outlook.
• Developed the Chart Programs, helps to present the data on Clients dashboards and drill down to each Client, LOB, agent, skill, measures and metric level records.
• Analyzing new ER’s and developed the DLD’s for impact on existing system and Objects.
• Extensively involved in SQL’s and API’s performance tuning and optimization.
• Developed migration scripts to upgrade to Oracle 12c from Oracle 11g in Development and Production Environments.
• Developed the Batch job configurations (Hourly, BOD, EOD) in batch scheduler JAMS.
• Performing DBA activities like DB schema creating and maintenance for Development, QA, QC and Staging environments, Jobs scheduling in Scheduler, Data Import from production for QA/QC, DB Objects Creation and validation.
• Interacting with UI development team to develop in tandem back-end solutions with front-end web executions.
• Involved in analyzing and translating client business needs, functional specifications and change requests into technical specifications.
• Perform investigation and research for system environments (i.e., reporting systems, switching systems, computer systems, etc.) to assist in resolving complex programming problems or identifying solutions to new business requirements.
• Preparing WBS, Work Units Development effort estimation and assignment of activities to resources based on the competencies.
• Analyzing and prioritizing the production issue tickets and moving them from development to scheduled releases.

Environment: Oracle 10g/11g/12c, PL/SQL, SQL, PL/SQL Developer, MS VS.Net 2010/2013, C#.Net, ASP.Net Web Forms, Java Script, Ajax, jQuery, HTML, Unix, Shell Scripting, JAMS, Control-M.

Confidential, Cincinnati, OH

Analyst Systems

Responsibilities:

• Developed the User Interface screens using the Forms Developer as per technical specifications.
• Developed the User Reports using the Reports Developer as per technical specifications.
• Developed of Database Objects for business requirements, mappings like Tables, Views, sequences, synonyms and Triggers.
• Developed interfaces for Service Manager, Release Control , CMDB, Asset Manager, Project Portfolio Management Systems and Alarm point.
• Developed the interfaces systems with the Enterprise Data Warehouse using HP Connect-It.
• Developed the Batch programs for Workflows.
• Developed PL/SQL Packages, Functions and Procedures to implement the Business Logic using Bulk collect, bind variables, Ref cursors, dynamic SQL’s to convert the legacy system data to normalized data.
• Developed the external and shared reports using the Crystal reports.
• Developed the ETL process programs by creating stored procedures and packages to pull data from data warehouse schemas.
• Developed the Unix Shell Scripts for batch jobs executions and process.

Environment: Oracle 10g, PL/SQL, Oracle Developer 6i, Forms Developer, Reports Developer, Crystal Reports 6.0, PLSQL Developer, Shell Scripting, UNIX, Control-M.

Confidential, Cincinnati, OH

Analyst Systems

Responsibilities:

• Developed the User Interface screens using the PL/SQL Web Toolkit and PL/SQL Cartridge as per technical specifications.
• Developed of Database Objects for business requirements, mappings like Tables, Views, sequences, synonyms and Triggers.
• Developed PL/SQL Packages, Functions and Procedures to implement the Business Logic using Bulk collect, bind variables, Ref cursors, dynamic SQL’s to convert the legacy system data to normalized data.
• Developed Portal Specific Modules that allowed content to be retrieved using predefined Blue spring templates.
• Developed the Ticket Approval workflows programs using the Blue spring workflow system .
• Developed Custom Authentication module for the PL/SQL cartridge to authenticate and authorize users.

Environment: Oracle 10g, PL/SQL, Java Script, HTML, PL/SQL Cartridge, PL/SQL Web Toolkit, Crystal Reports, PLSQL Developer, Shell Scripting, UNIX, Control-M.

Confidential

Database Developer

Responsibilities:

• As Database Developer and Individual Contributor responsible for Analysis, design, development and implementation of all database programs and physical objects of the application.
• Analyzing and provide the impact analysis if any on the application based upon the requirements.
• Involved in System Study & Business Requirements Gathering and Analysis.
• Developed PL/SQL Packages, Functions and Procedures to implement the Business Logic using Bulk collect, bind variables, Ref cursors, dynamic SQL’s.
• Worked on the database design for the new tables as per requirements.
• To convert the legacy system data to normalized data.
• Served as Single point of contact for All DB related queries of the Development Team.
• Worked on the queries for improving the load performance in various schemas across databases using appropriate SQL hints.
• Involved in Analysis, Design and Development of various complex Database programs for System operations and for EOD and BOD Programs.
• Coordinating with Client on the Business requirements confirmation.
• Coding database programs for Money Market (MM) and Foreign Exchange (FX) Modules.
• Building database schemas, Importing and Exporting database objects.
• Performance Tuning and Optimization of SQL queries and Database Programs.
• Coding Database Procedures, Functions, Packages and Triggers.
• Analysis, Design and development of reports using iReport and Crystal Reports.
• Unit Testing and assisting in certification testing.
• Involved in Code Promotion and Build & Release process.
• Provided the Technical Support to the Implementation and Production support Teams.
• Coordinating with Onsite and offshore teams spread in various locations.
• Worked on Agile Methodology by understanding the user stories provided.

Environment: Oracle 9i, Oracle PL/SQL, PL/SQL Developer, Toad, WebLogic 8.2, JSP, Servlets, JDBC, Swings, XML, JavaScript, Ant, iReport, Unix, Windows 2000.

Confidential

Oracle Database Developer

Responsibilities:

• As Database Developer responsible for Design and coding database programs using oracle PL/SQL and Reports of the application using Crystal Reports.
• Involved in Analysis, Design and Coding the Database Procedures, Functions, Triggers and Packages.
• Worked on various customizations, data conversions and upgrades to oracle 9i.
• Analysis, Design and coding the DB programs for EOD and BOD Programs.
• Designing and coding application Software for Retail - NPA Module.
• Designing and coding application Software for TD - Passbook Module.
• Involved in redesign and development of 150+ legacy reports to Crystal reports 6.0.
• Developed PL/SQL Packages, Functions and Procedures to implement the Business Logic using Bulk collect, bind variables, Ref cursors, dynamic SQL’s.
• Involved in Support the project and resolving the issues functionally and technically.
• Involved in Build and Release of Version based Flexcube Application at Client desk.
• Involved in Unit Testing and Implementation Support.
• Provided the Technical Support to the Global Support Team.

Environment: MS Visual Studio 6.0, Oracle 9i, Oracle PL/SQL, XML, SOAP, Crystal Reports 10.0, SQL Navigator 3.0, Windows 2000/NT.

Confidential

Developer

Responsibilities:

• Worked on Analysis, Design, Development, unit testing of software application.
• Involved in requirements gathering and confirmation from Client.
• Involved in Analysis, Design, Development, Unit testing, Implementation, User Training and Technical Support.
• Involved in design and development of HRUS, FWS, PIS and IEB Modules.
• Developed application software for TWIMS, SHG, VMS, ANC & PNC modules for Desktop and PDA/Palmtop.
• Involved in design and development of various database objects like PL/SQL Procedures, Functions, Triggers and Packages.
• Worked on the export and import of data.
• Involved in various Technical design document reviews.
• Tested and debugged the application on Desktop and PDA/palmtop.
• Involved in design and development of Application Repots using Crystal Reports.
• Involved Unit Testing for all modules on Desktop and Palmtop and assisted the Users while User Acceptance Testing (UAT) on application navigation.
• Traveled to 26 Client locations to implement the Application and to provide Training to the End Users on Desktop and Palmtop Applications.
• Provided the Technical Training to the Implementation, Technical and production Support teams
• Provided the Implementation Support while application implementation Country wide 26 Client locations.
• Technically Supported on HRUS and FHIMS configurations to country wide spread Support Engineers.
• Supervised team members and supported the team in any technical issues.
• Provided the Technical and Functional Product Demo to the Clients and users.

Environment: VB 6.0, ORACLE 8i, PL/SQL, SQL Navigator 3.0, Crystal Reports 6.0, Windows 2000/XP, eVB 3.0, Active Sync, PDA Flat DB files, Windows CE 3.0.

Confidential

Responsibilities:

• Involved in requirements gathering and confirmation from Client.
• Involved in Analysis, Design, Development, Unit testing, Implementation, User Training and Technical Support.
• Involved in design and development of HRUS, FWS, PIS and IEB Modules.
• Developed application software for ANC & PNC modules for Desktop and PDA/Palmtop.
• Involved in design and development of Database PL/SQL Procedures, Functions, Triggers and Packages.
• Tested and debugged the application on Desktop and PDA/palmtop.
• Involved in design and development of Application Repots using Crystal Reports.
• Involved Unit Testing, QA for all modules on Desktop and Palmtop.
• Assisted the Users while User Acceptance Testing (UAT) on application navigation.
• Traveled to multiple Client locations to implement the application and to provide training to the End Users on Desktop and Palmtop applications.
• Provided the Technical Training to the Implementation, Technical and production Support teams.
• Provided the Implementation and deployment support.
• Provided the Technical Support on HRUS configurations to country wide spread Support Engineers.
• Provided the Technical and Functional Product Demo to the Clients and users.

Environment: VB 6.0, ORACLE 8i, PL/SQL, SQL Navigator 3.0, Crystal Reports 6.0, Windows 2000/XP, eVB 3.0, Active Sync, PDA Flat DB files, Windows CE 3.0.