SUMMARY:

• 9+ years of professional IT experience in software development life cycle (SDLC) with diverse experience at various roles including - Sr. Database Developer, Database designer/modeler, ETL Developer, Sr. Applications Support Analyst and Production Support Lead.
• Expertise in database development and programming using SQL and advance PL/SQL. Experience in Oracle Forms & Reports (6i/9i).
• Experience in development and support of Extract-Transform-Load (ETL) processes using Informatica.
• Expert level experience in Production support of multiple-technology-integrated complex environments.
• Sound experience working on UNIX, Linux and windows based environments. Proficient in Operational Unix and Shell scripting.
• Demonstrated work experience in Job scheduling tools including Autosys, FLUX and Crontab and different middleware technologies including TIBCO, Vitria, Weblogic, Enterprise Service Bus (ESB).
• Multi domain industry experience including Educational IT Services (K-12), Finance-Investment Management, Telecommunications & Media, Retail Merchandising Systems-Oracle Retek (RMS).
• Effective written and verbal communication skills. Exceptional focus, follow-through and coordination skills to interface with internal and external stakeholders, IT groups and business users. Team player with good interpersonal and problem solving skills, ability to work in team and also work individually.

TECHNICAL SKILLS:

RDMBS : Oracle 11i/10g/9i/8i, Oracle Forms 9i/6i

Languages : SQL, PL/SQL, Advance PL/SQL, UNIX shell scripting, C

ETL : Informatica (Power Center 9.6/8.6/8.5)

BI reporting: OBIEE 11g

OS: Windows 95/98/2000/2003 Server/XP, LINUX, UNIX

Middleware : TIBCO, Vitria, Weblogic, Enterprise Service Bus (ESB)

Batch Job scheduling : Autosys, Crontab, Flux 7.x, Appian 7x (BPM)

ER Design & Documentation : Erwin 9.x, MS Visio, MS Office

Database tools : TOAD, SQL Developer, PL/SQL Developer, SQL Plus,SQL*Loader

Ticketing & Version control : JIRA, ITSM, Remedy Force, HP Quality Center, Rally, CVS, SVN

PROFESSIONAL EXPERIENCE:

Confidential, Reston, VA.

Oracle & ETL developer, Production Support Analyst

Responsibilities:

• Responsible for providing end to end support of all ETL processes and systems interchanging data with vendor partners and within operational data store (ODS)to enterprise data warehouses (EDW).
• Using Informatica PowerCenter develop, customize and maintain ETL processes to process and load data from various sources into enterprise integrated database(EID) and to enterprise data warehouse(EDW).
• Understanding design specification documents for OLAP schema design and implementing ETL solutions using Informatica.
• Customize existing mappings and workflows to extract, modify and load data to meet a wide range of business and system requirements using Informatica ETL tool.
• Responsible for researching the problem, identifying root cause, developing and executing workarounds for issues related to SAT/PSAT89/PSAT10Scoring feeds, Scoring and Batch Reporting processes.
• Resolution of production issues with data and processes within the prescribed SLAs and deadlines.
• Write complex SQL queries, DDL, DML scripts for data retrieval and analysis.
• Develop SQL programs, Anonymous and PL/SQL stored procedures as part of root cause analysis.
• Extensive work on UNIX. Created and customized shell scripts as per the requirement.
• Analyzing applications scripts, making modification and writing new scripts as needed.
• SFTP the scoring feed files using Tumbleweed from production to lower environments and load them to maintain the environments in sync with production and to help issue replications.
• Batch jobs scheduling and maintenance using Autosys and Flux. Troubleshoot and resolve batch failures.
• Monitor ETL load schedules through Autosys and ensure that they meet the schedules.
• Identify areas of improvement to improve system stability.
• Create and maintain flowcharts/jobs in Flux scheduler.
• Identify long running jobs and coordinate with DBA to fix the same.
• Executing jobs and processes via Appian based on Runbook instructions. Analyze issues with Appian workflows and resolve them so as to minimize the business impact.
• Debug issues related to WebLogic instances on which Flux engines are mounted and fix them.
• Error handling and Troubleshooting using various log files.
• Worked on restoration efforts for high severity and high impact incidents, sometimes requiring off-hours support.
• Perform unit testing, system integration testing and user acceptance testing to test the new changes.
• Coordinate with release team to understand changes to production rollout.
• Manage incident communications across a diverse audience up to and including senior executives.
• Demonstrate continuous effort to improve operations, streamline business processes, and working cooperatively and jointly to provide quality member service.

Technologies used: Oracle 11i, Oracle Exadata, Informatica PowerCenter (9.6.1),Amazon Web services(AWS), WebLogic, UNIX, Crontab,Autosys-R11, Flux 7.x, Appian 7x,Cognos, Toad, PL/SQL Developer, HP PPMC (ITSM), Atlassian Jira, Appian (7x), Tumbleweed (FTP), Putty.

Confidential,Irvine, California

Technical Delivery Lead, Sr. Production Support Analyst

Responsibilities:

• Responsible for managing a team of technical support specialists who are responsible for issue management and resolution, escalation support, reporting and overall support.
• Communicate with several different technology SMEs in a highly matrixed organization to drive issue resolution by collaborating with the customer, internal resources and third parties.
• Accountable for Middle and back office applications- Eagle STAR, FITR, FSR, IDH, CMPS, IMAP, MARS, SDS, IDH.
• Extensive work on SQL, Advanced PL/SQL, UNIX, Informatica, Linux, Shell scripting.
• Create and modified several UNIX shell scripts according to the changing needs of the project and client requirements.
• Worked on SQL*Loader to load data from flat files. 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.
• Day to day execution of real time technical support and troubleshooting.
• Lead the resolution of SEV1 and SEV2 incidents. Provide guidance to the team in resolving performance related issues.
• Lead maintenance of master documents i.e. Runbook, Playbook and helps maintain accurate application documentation.
• Identify repetitive issues and analyze with the team on root cause and help in remediation steps to avoid such issues in future.
• Identify, analyze and resolve complex issues elevated from different teams, actively participate in resolving problems, determine solutions, and track and manage issues. Identify underlying source of problems, recommended solutions, successfully implement the same.
• Participate in technical discussions with the development team for deployment and code reviews, drive knowledge transition from SMEs, development teams to sustain team for each functional deployment
• People management responsibilities including Time Report approval, recognition, coaching and resource planning.
• Assign tasks to teams and guide the team in resolving technical issues ensuring accuracy meeting the SLAs.
• Responsible for onsite - offshore team management.
• Partner with Delivery Management team to ensure a smooth transition from enhancement and project teams to production support team.
• Participate in technical meetings and status meetings with the business.
• Document, maintain, and communicate information specific to incident management initiatives including: Incident Management (IM) processes, standard operating procedures, service level agreements, incident response metrics and incident review sessions as per ITIL methodology.
• Status Reporting: Prepare Weekly, Monthly and Quarterly SLA Metric reports and presentation to the client. Stress on value addition or process improvements.

Technologies used: Oracle 11i/10g/9i, Informatica PowerCenter 8.6, OBIEE-11g, UNIX, LINUX, Shell Scripting, Tomcat, Apache, Tibco Middleware, Autosys-R11, TOAD, PL/SQL Developer, MS Visio, Erwin Modeler, Remedy Force, Rally, HP Quality Center, Quick Build.

Confidential, Dallas-Fort Worth, Texas

Oracle, ETL & BI Developer, Sr. Application Support Analyst

Responsibilities:

• Technical Lead for applications/modules - VBS/VAST Billing, VICS Customer Care, Distribution Systems (IDS/SDS), VAST-Sales Compensation, Product Performance Analytics and Reporting.
• Interaction with business for clarification on requirements and new functionalities and their documentation. Preparation of high level functional documents (FDD) and Technical documents (TDD).
• PL/SQL coding - Created database objects - Tables, Views and Sequences, create and modified Stored Procedures, Packages, Functions, Triggers, Cursors, Exceptions and Error Handling scenarios.
• Worked on Dynamic SQLs, created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package.
• Wrote numerous complex SQL scripts involving multiple table joins for data extraction, spooling and data loading based on business need.
• Bulk data loading using SQL*Loader, PL/SQL developer and TOAD to load data from flat files obtained from various distribution centers and vendors.
• Extensive use of DECODE, NVL, Group functions, Sub-queries, co-related sub queries, etc. to achieve the desired results.
• Worked on performance tuning of SQL and PL/SQL queries using various tools methodologies like EXPLAINPLAN, SQL*TRACE, TKPROF.
• Development and customization using Forms & Reports 9i for Distribution modules - IDS & SDS.
• Developed ETL processes using Informatica tools and schedule jobs for data integration between various applications.
• Worked effectively on Source definition, Target definition, sessions, transformations like Lookup, Filter, Expression, Router, Union, Aggregator, Sorter, etc.
• Customized existing mappings and workflows to read and write data from and to flat files and Oracle Database tables as per the business requirements.
• Created and modified several UNIX shell scripts.
• Wrote Unix Shell Scripts to process the files on daily basis like renaming the file, extracting data from the file, unzipping the files and remove the junk characters from the file before loading them into the base tables.
• Wrote and modified several Autosys JILs (Job Information Language) to create new and alter existing batch jobs. Coordinate with production control team to schedule them via Autosys-R11.
• Actively worked on production defects. Analyze and provide root cause analysis, Troubleshoot and resolve issues within SLAs. Troubleshooting and resolving batch failures. Batch jobs scheduling and maintenance through Autosys-R11.
• Team management - coordinate and manage team at offshore by prioritizing and assigning day to day tasks, gathering status updates, perform peer reviews, Technical & functional assistance in resolving the assigned tasks and achieving the deliverables meeting the SLA / KPI.
• Coordination between Development, Testing and the Production Support teams for cross functional training.
• Coordination and daily calls with various stakeholders for code deployment and version control. Dealing with Change Management (CC) & Release Management (RM), QA teams.
• Reporting - Project metric reports (WSR, MSR, QSR reports) preparation in MS Excel. Using Pivots, Charts, VLOOKUP, etc. for report creation.

Technologies used: Amdocs Billing, PeopleSoft CRM, UNIX, Shell Scripting, Oracle 11i/10g/9i, Forms & Reports 9i, Autosys-R11, TIBCO middleware, Enterprise Service Bus (ESB), SQL, PL/SQL Developer, TOAD, Informatica PowerCenter (8.6), MS Visio, Remedy Force, Rally, HP Quality Center, Quick Build.

Confidential 

Oracle Programmer, ETL & BI Developer

Responsibilities:

• Understanding the overall Kenan Billing system, Clarify-CRM, POG application and Derby functionality and the integration of various modules within Derby.
• Extensively worked on Billing, POG & Invoicing and Collections modules.
• Implementation of new functionalities and enhancements under AHCR.
• Coding and implementation using PL/SQL, UNIX shell scripting & Doc-one.
• Actively worked on developing and modifying Functions, Procedures, Packages, Triggers, Cursors and Exception Handling using PL/SQL.
• Worked on altering of database table structures, adding and modifying table columns, primary & foreign keys, etc. to support new functionalities.
• Application and performance tuning of SQL queries using Explain Plan, TKPROF, Hints, Indexes with the help of DBAs.
• Understanding design specification documents for OLAP schema design and implementing ETL solutions using Informatica.
• Understand the Design Analysis documents and accordingly develop ETL transformations, mappings and work flows as per the requirements.
• Develop ETL scripts using for data integration and flow between various applications
• Production Support – debugging and resolving production defects and providing the resolutions meeting SLAs/deadlines.
• Data loading using Sql loader, PL/SQL developer and TOAD. Providing bulk data fixes & code fixes to resolve the defects.
• Support Kenan patch upgrades and releases. Smoke test and sanity testing post to releases.
• Perform thorough unit and regression testing for the changes. Development and validation of unit test cases for validating code check-ins, continuous integration using CVS, perform peer-reviews.
• Development and validation of test cases, validating code, thorough peer reviews, Identifying opportunities for code re usability and thereby implementing the changes.
• Communicating & coordinating among a large team group.

Technologies used: Comverse Kenan & Kenan-FX, Clarify-CRM, Oracle 10g/9i, Informatica 8.5, OBIEE 10g, Visual Basic(POG), Vitria middleware, UNIX, Shell Scripting, SQL, PL/SQL Developer, TOAD, CVS.

Confidential

Oracle Developer, Production Support Analyst

Responsibilities:

• Understanding overall RACO application – Oracle Retek Merchandising System (RMS) and Advanced Inventory Planning (AIP) and their integration.
• Worked on customization of Purchase Order processing and generation of reports (if22, if23).
• SQL and PL/SQL coding, development and customization of screens using Forms 9i and Reports 9i as part of the requirement.
• Working mainly on UNIX and PL/SQL Coding and debugging.
• Bulk data loading using SQL *Loader and PL/SQL developer.
• Creating database table structures and creating database objects – Tables, Views, Sequences, Synonyms, Creating Users and Granting Roles.
• Written stored procedures, functions and triggers using PL/SQL.
• Working and fixing the production defects including data & code issues meeting the deadlines and budgets.
• Batch jobs maintenance and support.
• Identifying opportunities for code re-usability.
• Creating test plans, performing thorough unit and regression testing on all changes.
• Documenting programming and unit test deliverables thoroughly according to client standards.
• Smoke testing and checkout of application post release.
• On-call support outside normal business hours.
• Communicating status to Team Coordinator on a regular basis.

Technologies used: Oracle-RMS (Retek Merchandising System), Oracle 9i, Forms & Reports 9i, OpCon scheduler, UNIX, Shell scripting, SQL plus, PL/SQL Developer.