SUMMARY:

• Currently working as a primary Product Owner/Business Analyst for requirements gathering and specifications onMobility/non - mobility applications
• Expert level Business and system impacts Analysis adhering to Agile/Kanban methodology
• Expert level knowledge in Analysis, design, Application development (transactional/datawarehouse) and deployment of IT/Business projects
• Learning TABLEAU
• Oracle database development/DBA experience, on versions Oracle 10G/9i/8i under Unix (Sun Solaris, HP-UX, IBM/AIX) and Windows (NT/2000/95/XP)
• Possess strong hands on experience in using Oracle Utilities, SQL, PL/SQL, SQL*Plus, SQL*LOADER, Export & Import
• Exposure to ERWIN Confidential Modeling tool
• Good hands on experience working on migration/reengineering/systems Integration projects
• Good hands on and trouble shooting skills on ETL (DataStage 7.1/7.5.2)
• Strong hands on experience in Unix utilities, shell scripting (Korn & C)
• Expert level experience in communicating and working with executive and senior leadership
• Advanced level skills in Microsoft Word, Excel, PowerPoint
• Over 10 years’ experience in IT Industry

SKILLS SNAPSHOT:

Lead Business Analyst

Results Driven Leadership

Excellent Team Player

Executive Communication

System Engineering/Coding Skills

Trouble shooting, documentation M&P

Microservices Architecture Experience

High-Level System Solutioning

Confidential Analyst/DBA Skills

Project Delivery/upgrade releases

Scaled Agile, Kanban, JIRA Align

Traditional/Waterfall/SDLC

Collaboration Across Agile Teams

Team Motivation & Development

Application Deliver Driven Estimates Management

PROFESSIONAL EXPERIENCE:

Confidential, Middletown, NJ

Solutions Engineer/Lead Business Analyst

Responsibilities:

• Work as a Lead Solution Engineer on the assigned projects.
• Coordinate between cross functional teams (Onshore/Offshore) for multiple projects and provide the system requirements to the design team/Dev team
• Participate in all the PI planning sessions and provide Epics/User stories prioritized for each iteration on time. (part of the Safe Agile DevOps incremental Methodologies)
• Participate in the daily stand-up calls to provide status /have an idea on the overall project progress
• Lead the E2E delivery as a primary Systems Engineer with good understanding of Confidential movement per Confidential & Confidential standards between systems and following Firewall practices with external clients. (via SFG, Dmaap)
• Engage in System design and modelling skills (e.g. domain driven, event driven architecture design, Confidential modeling)
• Perform Impact Analysis of changing business needs, prioritize on programs and adapt to address emerging needs
• Strong relationship and connect with client Confidential different levels.
• Work on coordinating to provide the HOM to the clients based on the impacts. (HOM is the High order measurement of total application cost)
• Responsible for participating the design reviews/test cases/Dev team demos and provide the approvals.
• Provide documentation describing the functionality of each feature needed for training of support team and educating other users.

Skills: TDP, Agile craft, Safe Agile methodologies, Unix/Linux, Oracle 12.1, Sparx, Java/JDBC, exposure to Docker/Kubernetes (DevOps approaches)

Lead Production/ Business Analyst

Confidential

Responsibilities:

• Identify any missing requirements after detailed analysis of Confidential in current production, source systems, code
• Worked closely with business and client systems on the requirement gatherings and ensure handling them while meeting very tight deadlines.
• Perform Confidential look-ups and analysis in the EDF database
• Verify the existence of Confidential in sources and ensure source systems are engaged for missing Confidential .
• Verify any Confidential lags caused by Golden Gate replication and involve the DBA teams as needed.
• Involving Dev/ST teams for all source code issues. Needed analyzing the existing ETL code base.
• Engage on working war rooms to resolve application and Confidential integrity issues.
• Provide specifications for release upgrades to Dev/ST teams with proper documentation.

Platform: Unix/Linux, ETL ( Confidential stage), Oracle, PLSQL

Confidential Analyst

Confidential

Responsibilities:

• Primary responsibilities include support and functionality like:
• Troubleshooting production errors via existing/coding PL/SQL packages as required
• Provide formatted Confidential in excel spreadsheet to the users as required
• Delegating tickets to upstream and downstream systems as needed and handle escalations via a working bridge and support any outages
• Engage teams in SWAT calls for improving the application in an effort to reduce the number of production issues.

Platform: Oracle (with 4 databases), HP UX 11.0 (primarily), Middleware: IIOP (= CORBA), MQ Series, Connect: Direct, and libe (which is written right on top of TCP/IP), All the apps have C++. OSDS, FC, Java.

Oracle DBA

Confidential

Responsibilities:

• Primary on call DBA for INR and Daytona applications, this includes DBA support of monthly deployments, supporting any production DBA application errors on a daily basis, providing analysis for additional space requirements, Adding Space Confidential the Table space level to ensure enough space for growth, Rebuilding Indexes when they become Invalid, Performance tuning of application Queries as needed, maintenance of Partitions and working with Dev DBA to come up with automation scripts for cleanup of Older Confidential .
• Support of daily operations including job monitoring and troubleshooting of the 24x7 production
• Provide Export backups which aid in Testing /Dev Environments and also support emergency import to production tables. (also use SQL*Loader)
• Work on Confidential cleansing with appropriate backups
• Monitor to find long running Queries and give suggestions to application teams for better performance
• Ensure compliance in related tasks with company and regulatory policies and procedures and deliver on-call support for critical database applications as needed.
• Ensure control, integrity and accessibility of the Confidential
• Trouble shooting Materialized Views errors, and re-running them manually on production to refresh the Confidential
• The entire work includes effectively and proactively communicating and hosting review calls with several systems, teams and interfaces
• Prior to working in the DBA team also worked for GCP High Level Design team to provide an end to end design and process architecture for few applications. This team was eventually phased out due to company Re-org.
• Understanding the requirements document to determine the changes need to be made to the header/detail/trailer sections of the XML file generated
• Understand the existing packages and make all the necessary changes
• Unit test the end-to-end application
• Support the UAT testing to generate the billing files in the XML format and ensuring that the generated files go through the people soft engine
• Deployed these changes to the production environment

Environment: Oracle10g, TOAD, SQLdeveloper, PL/SQL, SQL

Confidential, NYC

Consultant

Responsibilities:

• Support for Confidential ’s Sales and Marketing Confidential Warehouse Production PL/SQL batch jobs involving TDP(Table Driven Process) process, Autosys scheduler, Oracle tables, Flat files
• Automation of existing manual PL/SQL programs using TDP and Autosys JIL scripts.
• Extensively used the performance tuning techniques for troubled SQL queries.
• Providing the Quarterly space Estimates for table spaces in all databases.
• Analyzing the Schemas in regular basis as well as after mart refreshes.
• Run the regular monthly processes that update the Confidential mart with the updated monthly Confidential received from various Confidential sources within Confidential and external sources such as NDC/WKH and IMS.
• Coded PL/SQL procedures for Confidential cleansing and Confidential conversion
• Once the files have been received from the various external and internal sources the Confidential is loaded into the processing servers using SQL*Loader.
• Used export/import utilities for Confidential refreshes between databases.
• Supported to provide the platforms for upcoming new projects which includes space management Confidential file system level and Confidential Oracle table space level
• Supported Patch/security and version upgrades when required and recommended.

Environment: Oracle9i, TOAD5, PL/SQL, SQL, SQL*Loader/External Tables, UNIX Shell Scripting, VSS, Auto sys/TDP

Confidential, Hopewell, NJ

Oracle Developer/Consultant

Responsibilities:

• As an Oracle consultant for the EXSOP team, had been working on multiple assignments as part of the developer’s team and Production support which include:
• Supporting the web based applications (like Order Recap and Subsequent Sales) to give the formatted Confidential using PL/SQL procedures Confidential integrity.
• Coded and automated a PL/SQL Package/batch process as part of phase II of Grant Award Acceptance project with 18 reconciliation scenarios on Grants/Options.
• Coded and supported enhancements to a PL/SQL package, which sends out the Options and related information to Equity Methods, which does financial reporting and option expense forecasting. The information was written to flat files and sent out to Equity Methods.
• Coded a PL/SQL procedure to filter out the bad Confidential within the database as part of Equity Methods project to preserve the Confidential integrity.
• Coded and automated a PL/SQL process to load the inbound valuations Confidential from Equity Methods. Used the External Tables feature to point to the flat files from EM. This Confidential is used by the business for further research.
• Coded FTP scripts to ftp the files to Equity Methods and coded shell scripts to automate the process of calling the Equity methods package whenever the User turns ON the processing for a company from front end.
• Worked as part of a team on Million dollars tracking project, to make enhancements to the PL/SQL programs and Triggers which are invoked for any adjustments made from the EOWIN by the Users
• Worked as an Oracle developer (written in PL/SQL) to support the web functionality on the Performance Shares project.
• On every application worked very closely with the project managers and business users to understand the requirements clearly.
• Worked very closely with the testing team during the UAT phase and fixed the bugs as needed
• Tested the queries against the production database to make sure good performance (performance tuning) is achieved.
• Coded structured PL/SQL programs with good exception handling

Environment: Oracle 9i, TOAD5, PL/SQL, SQL, SQL*Loader/External Tables, UNIX Shell Scripting, PVCS

Confidential, Piscataway, NJ

Developer/Consultant

Responsibilities:

• Worked as the prime developer on the VOO (Value Opportunity Offer) program of the Manual Payments and Accruals project which are made available to the GPS for GP calculations.
• Worked as the prime developer on the redesign project of Ann Taylor website.

Environment: Oracle 8i, TOAD 7.5, Pro*C, PL/SQL, SQL, SQL*Loader, Export/Import Utilities, HP UNIX Shell Scripting, Oracle Enterprise Manager, Microsoft Access, PVCS