Yogita Kolhe

Mobile: 982-***-****, E-Mail:adabtd@r.postjobfree.com, Address: B3-804, Ganga Constella, Kharadi, Pune.

EXPERIENCE SUMMARY

** ***** ** ************ ********** in Oracle PL-SQL, UNIX (Shell Scripting), Web logic, OFSAA, Oracle E Business Suite 12.3, Oracle Exadata, Java, Hadoop. MySQL, Apache Strom,Kafka, Mongo DB,Geneos ITRS,AWS

5 yrs. of experience in Banking and Finance Domain in Data ware housing projects (AML and Risk Management,sepa payment system)

Understanding Incident Management, Disaster Recovery / Business Continuity, Configuration Management, Change management (ITIL framework) ITIL Certified

ACADEMICS

Bachelor of Engineering in Information Technology from Govt.College of Engineering, Aurangabad.

Diploma in Computer Engineering from Govt. Polytechnic Jalgaon.

PROFESSIONAL EXPERIENCE:

Duration

Organization

Designation

23-oct-2017- Till Date

02-Nov-2015–16-Oct-2017

17-Jul-2013- 30-Oct-2015

17-Jan-2011-10-Jul-2013

July-2007 – 16-Dec-2010

Citi Corp Services India

Sears India IT Management

iNautix India Pvt Ltd

Mphasis an HP Company

Tech Mahindra Ltd

Assistant Vice President

Technical Leader

Technical Leader

Software Engineer

Technical Associate

TECHNICAL SKILLS

Databases: Oracle 11g/10g/9i/8i, MS Access (2000, XP),Mysql

Languages SQL, PL/SQL, UNIX Shell Scripting

DB Utilities: Toad 8.0/9.0/10, PL/SQL Developer, Export/Import, SQL Loader Utilities,

GUI Tools: Developer 2000(Forms 6i/9i/10g, Reports 6i/9i/10g, BI Publisher, XML, Eclipse

ETL & Reporting tools: Oracle Warehouse Builder (OWB 10g), SQL Loader, OBIEE, Pentaho

Version Control: SVN, Clear Case

Operating Systems: Windows 95/98/2000/XP/NT4.0,HP UNIX, Red Hat Linux

WORK EXPERIENCE

Organization: Citi Corp Services India.

Technology: Oracle, Linux, Java, Autosys, WebLogic, Java,Geneos ITRS

Role: Assistant Vice President (Trade and Treasury services)

Experience working in a Unix & Oracle environments, Unix Shell Script Programming, Oracle SQL, Java

Strong written and verbal communication skills with ability to handle conference call coordinating various activities

Provide prompt, effective day-to-day support, identify and resolve issues by collaborating and communicate with internal and external groups and vendors also update incidents in Service Now.

Supporting the Payment Application for different regions such as EMEA(SEPA),NAM,APAC

Worked with Change, Project and Incident management using software tracking tools following ITIL best practice

Business interaction to understand system gap and improvement

Took ownership Manual task’s Automation, DR activity,Process improvement,System stability initiatives

Monitor Application using Genios Console (ITRS)

Autosys job scheduling and handling issues.

Involved in planning and execution of Critical Payment System migration from AIX to Linux

Technical Documentation for production release schedule, Application changes, KT Plans

Involved in release management like planning execution verification and using udeploy tool

Organization: Sears Holding India.

SPIN stands for Sears Product Information Network, and is a system designed to handle online content: items, hierarchies, etc. for different websites within the OBU (Online Business Unit). SPIN is a PIM (Product Information Manager) system consisting of a new data model, database, and GUI tool interface.

Technology: MySQLOracle, Unix, Java, Tomcat, Hadoop, Jenkin/Hudson Jetty

Role: Technical Leader

Developed Oracle objects Like Packages, Procedures, Partitions, Bulk operation, AWR reports understanding Indexes, Synonyms, Triggers .

Supported the Web Application like Java log, Tomcat log debugging, Kafka, MQ, Web Service Rest API

Application Management like Web server, Code debugging of java, Oracle, Linux

Worked on Enhancement request like DB changes Automation using shell script, Report preparation and scheduling for Business as when required.

Documentation for production release schedule, Application changes,

Documented enhancement in existing DTD,ASG documents like OLA SLA, Escalation Matrix, Contact details

Prepared the KBDB for support team to improve response time.

Maintained code and all related artifacts in source control (Git, SVN);

Issue tracking under Incident tool like Service Now, BMC Remedy, HP service center or JIRA tickets for changes

Good Understanding of Data Warehousing and ETL concepts

Experienced in monitoring tool like Nagio, Splunk also scheduled job on ESP, Jenkin, Control M

Created Adhoc report using Hadoop queries using hive.

Prepared KT plans and documentation for L2 and L3 Teams. Mentored junior team member.

Organization: iNautix India Pvt Ltd.

ERI (Enterprise Risk Integration):

The Enterprise Risk Integration (ERI) is program to enhance enterprise-wide risk management capabilities through delivery of robust business processes that furnish authoritative data, analysis and reporting for internal management and as well satisfy regulatory reporting needs.

Technology: ORACLE 11G, Linux, OFSAA, Pentaho, OBIEE

Role: Technical Leader

Responsible for oracle development and Worked on performance tuning using different feature like Partitions, Hint, AWR report, explain plan

Developed and executed unit tests for new code and existing unit tests for modified functionality. Used ALM tool to track defects.

Gathered and understand Business requirements with BA and designed it with appropriate data models and prepared design documents accordingly.

Verify build and deployment completeness of the features owned in the QA environment before making it Testing Ready in Quality Center.

Involved in Data modeling Activity like physical, logical data model creation, relationship between tables, grouping those tables based on business needs.

UNIX Shell scripting functional requirement, Automation and scheduling tasks

Handled OBIEE reporting data issues and ETL issue using Pentaho tool.

Worked Data ware Housing concepts like Dimension, Fact tables and SCD logic

Assigned technical task to team members also provide timely status to management

Involved in different Meetings like Review meeting, postmortem meeting, CAB meetings. Retrospective meeting

Organization: Mphasis an HP Company

Regulatory Filtering (AML Compliance) RBS, UK (Jan 2011 to Till Date)

Regulatory Filtering is an application to perform client/customer screening based on AML compliance against list/rule file also provide facility take decisions on generated alert according AML Regulatory

Technology: ORACLE 10G, Unix, Java, Webspare

Role: Oracle Developer

Oracle PL SQL development/Enhancement and Performance tuning.

Responsible for requirements gathering from Clients and implement the back end changes in existing product and in designing the database.

UNIX Shell Scripts for scheduling various data cleansing scripts and loading process. Also developed the batch Shell Scripts.

Test case/data preparation, execution and verification of the test results

Worked on Database migration activity like table space maintenance, Environment alignment, data migration

Organization: Tech Mahindra Ltd

Projects: Unified Inventory Interface (UII) and Billing Access Layer (BAL), Client: British Telecom, UK

Technology: ORACLE 10G, LINUX, Web logic Server, Oracle Warehouse Builder, OAS, XFB, Java Role: PL-SQL developer

Oracle PL SQL development and Unit testing.

UNIX shell scripting and administration.

Handles Oracle and java code deployment and web logic administration activity

Performed end-to-end (E2E) process analysis, requirement analysis and gap analysis for the migration process

Involve in Restructuring UII application on Upgraded platform like Oracle 9I to 10 G.

Provided Support for Functional & testing support for CIT, IVVT, DR & regression testing

Configuration of Billing and rating on GENEVA 5.1, INFINYS 2.2.

Oracle Apps Technical/Functional Training Knowledge:

Oracle form customization and personalization,Oracle report generation, BI Publisher, SQL Loader

Hands on oracle E Business Suite( 2 months)

Basic functional knowledge of Finance Module(PO,P2P,AR,AP)

Responsibility and user creation, Value set, concurrent program registration. Data mapping conversion and data load in Oracle Apps using Interface/API.

ACHIEVEMENTS:

Received Manage Risk Award 2015 (Inautix BNY Mellon)

Received Spot Award 2014( Inautix BNY Mellon)

Received Customer Appreciation Award 2010 ( British Telecom UK)

Received Best Team Award 2010 ( British Telecom UK)

Rewarded as “Pat On Back” 2009 (Tech Mahindra Ltd.)

WORKSHOPS/TRAINING PROGRAMS ATTENDED

Oracle E Business Suite Technical training.(3 Months)

Oracle PL SQL (8 days)

Java/J2EE (8 days)

UNIX (8 days)

Contact this candidate