Candidates About

 

WORK EXPERIENCE

Sep-16 to current(Application Modernization)

Customer: SOMOS INC, Herndon, VA.USA.

Role: Application DBA, Data Modeler, PL/SQL Developer

Project Description:

SMS/800 Inc. is the company responsible for the administration of toll-free numbers in North America, including managing the assignment of toll-free numbers and provisioning of routing information that enables the network to deliver toll-free calls to the correct destination. To keep pace with the evolution of the telecommunications industry, SMS/800 Inc. has begun to consider the potential replacement of the current system that has supported toll-free number assignment and routing information provisioning since the late 1980s. A project has been initiated to define the functionality required of a replacement system.

Responsibilities:

·         Converts business requirements and specifications into Data Model using ERWIN and SQL Data Modeler

·         Create data models and xml schemas at all levels including conceptual, logical, and physical for both relational and dimensional solutions. Models will include objects, entities, attributes, their inter-relationships and dependencies

·         Have expertized in Reverse and Forward Engineered in Data Modelling

·         Enforced Naming Standardization for Entities and Attributes by defining Glossary file

·         Created and implemented ER models and dimensional models (star schemas).

·         Involved in PL/SQL Development- Writing Complex Package, Procedures, Views, DBMS Schedulers, Function, Table Partitioning and complex queries with better performance

·         Performed JMeter performance testing

·         Generate DDL from Data Model for Physical Structure Creation in Database.

·         Defined Appropriate Constraints and relationship between the entities

·         Have experienced to define Domain Attributes to enforce appropriate datatypes

·         Define the Database Design as per the application requirement

·         Periodically Review data model with Customer

·         Have Spitted model into appropriate Subject Areas

·         Represented Data model on LLD Review

·         Have Maintained Data Model with different Versions and Created Data Dictionary for meta data to understand attributes by other team members

·         Prepared Data Mapping between different Application Sources

·         Have been involving Application DBA Activities (Database schema users Creation, Tablespace Creation, Roles Creation, Database Backup, Database Scheduler Creation)

·         Proposed New Database features to customer

·         Have experienced Database Defragmentation by moving data to different tablespaces

Dec-14 to Feb-16(GRC IMPLEMENTATION)

Customer: TIVO INC, San Jose, USA.

Role: PL/SQL Developer, GRC Consultant, Reports Developer

Project Environment: MetricStream GRC, Oracle Database, UNIX and Open Office Reports
Project Description:

TiVo Information Security & Compliance group has identified to implement two out of box solutions of MetricStream – Policy Document Management & Compliance Management to automate their

Policy & Compliance Management processes. Policy Document Management solution and implement a comprehensive, consistent process for managing the lifecycle of policies and exceptions. Policy Management solution has listed the features are Categories, Access Groups, Life Cycle, create document based policy, Attestation process, Exception, Linking policies. Users could create polices by using upload templates to load legacy policies. Leverage the out of box Compliance Management solution of MetricStream has implemented to the compliance management framework to measure security compliance. The ‘out of box’ features listed which exist within the Compliance Management (CM) solution are Creation of control assessment factors/questionnaires, Creation of assessment plan, triggering a control assessment and completing the control assessment. Created data upload templates to load Control Standards / Procedures and SOX findings. Imported the existing control standards / procedures information of TiVo.

Responsibilities:

·         Involved in overall coordination regarding Installation, configuration and setup of MetricStream Out of Box Solution

·         Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues

·         Actively involved in gathering requirements from end users, involved in modifying various technical & functional specifications

·         Have migrated Data from previous system to out of box solution

·         Have developed Customized Reports and Dashboards

·         Have configured out of box solution to customer by defining all the initial setup.

·         Have Prepared Documentation – SMTD and LLD

·         Tracking Project Status and Preparing WSR Reports to present to customer.

·         Collaborated with internal stakeholders to drive efficiency and effectiveness of the metrics and reporting

·         Have involved in Impact Analysis on PL/SQL Development changes.

·         Have involved MetricStream GRC Development

·         Ensured from Customer for Sign-off for deliverable

·         Have prepared User Guide and provided GRC training to End users

·         Have prepared Test cases and well document including DR test cases

·         Have Setup Disaster Recover by coordinating with DEVOPS Team

·         Have experienced in Open Office Reports Development

Sep-13 to Nov-14(Loan Loss Forecasting System)

Customer: Capital One.

Role: Oracle Application DBA, Data Modeler

Project Environment: ERWIN, Oracle Database

 

Project Description:

Loan Loss forecasting application will have input from Mortgage Data Warehouse and stored in SAS database. Ermas Model Manager will have interface to initiate Model executions and results will be

stored in results database. Reports can be gene rated from these results and exported in different formats like Excel, PDF, etc. Capital One existing models should be reusable to implement with this solution.

Responsibilities:

·         Creating Oracle Users and Assigning related roles to the user

·         Creating DDL script for Table creation

·         Have Developed Conceptual, Logical and Physical Data Model

·         Forward engineer physical models to create DDL scripts to implement new databases or database changes. Reverse engineer databases and synchronize data models with actual data implementations

·         Create data dictionaries and business glossaries to document data lineages, data definitions and metadata for all business-critical data domains

·         Capture business rules that govern how data is transformed, integrated, and used

Mar-13 to Jul-13 (SOCRATES)

Customer: UBS BANK, SINGAPORE.

Role: PL/SQL Developer, Data Modeler

Project Environment: Oracle Database, SQL Data Modeler and ETL

Project Description:

Socrates application deals with PNL data and it comes under Finance IT division of UBS. The main purpose of this project is to receive data from up streams like BROIL, DAYTONA, CREDIT_BROIL, OBS and perform business validations and load PNL trade details into Socrates DB which can be used for business reporting as well as for feeding down streams like GGL, HOLMES. Performed the activities like Level 3 support, Monitoring the remedy ticketing system, New code development, Bug fixing, Code migration, Technical design documentation.

Responsibilities:

·         Assisting with data analysis, strategy, and modeling

·         Supporting users of the schema and the standard data models

·         Review PL/SQL Code and provided feedback to improve performance

·         Preparing Source and Target Data Mapping

·         Prepared Data Dictionary

Sep-11 to Feb-13 (AVAYA TIS SUB PROGRAM)

Customer: AVAYA, USA.

Role: PL/SQL Developer

Project Environment: Oracle Database and SSIS

Project Description:

Remedy is the IT Service Management Suite tool which was used by Avaya. It reduces complexity and makes customer support, change, asset, and request management a seamless integrated process. Users will raise tickets for their issue with hardware/software/configuration and  ticket will be assigned to appropriate person to fix the issue. Ticket types are varying depends on issue like Incident, Problem, and Change, Work order or Computer systems. Tracking and updating of ticket response times and service desk performance against SLA's. Also worked to setup an archive database for transaction data by using

 

 

SSIS technology from different types of source databases like SQL Server, MYSQL and Sybase. Integrated a Reporting database by scaling out of the Production database, to optimize the Reporting applications.

Responsibilities:

·         Have involved in POC for ETL between different databases

·         Analyzing AWR Reports to identify database performances

·         Have tuned complex Oracle SQL Queries

·         Have experienced in Database Job Scheduler

·         Have worked on PL/SQL Development and SSIS

·         Have created data Modelling for ETL Process

·         Experience in creating/reviewing Requirement Specification & Design documents

·         Developed complex Oracle Database Procedures

Aug-10 to Aug-11 (UMPIRE APPLICATION)

Customer: CISCO, San Jose.

Role: PL/SQL Developer

Project Environment: Oracle PL/SQL and Oracle Apps Technical Consultant

Project Description:

An UMPIRE(Upgrade Management Program Including Reporting) program field Notice. When a Field Notice is published, customer(s) can provide details about products and required quantities and submit the request. Helpdesk generates new buy orders from Manufacturing or shipment from service to fulfill the demand. Analyst will create a new UMPIRE Program for this PID. UMPIRE too l will gather all such requests for Products on a Field Notice, associate request to a program. The Marketing team will prioritize the customers and product quantities based on various factors. The Global Planner will assign quantities to the top level depot in the area of customer. This will allow Theater Planners to manage the process further from Area depot to customer’s location. Thus the UMPIRE tool will allow Cisco to streamline and put controls in the product replacement process.

Responsibilities:

·         Have provided production Support

·         Have Monitored Remedy Ticket system and assigned to Team Members

·         Have Mentored the team to debug the issues

·         Involved Deployment and Release Management Activities with different teams.

Jul-09 to May-10 (WAREHOUSE MANAGEMENT SYSTEM)

Customer: FUJITSU, UK.

Role: Oracle Forms, PL/SQL Developer
Project Environment: ERWIN and Oracle
Project Description:

Warehouse Management System is designed to manage and control the flow of goods in and delivery out of the warehouse. It supports activities like automated put-away, picking, stock reservation, stock transfer, stock count etc. It allows customers to view stock movement and availability online and

stock can be reserved online. It has option to check Digit for ensuring data   accuracy and put-away and pickup sheets.

Responsibilities:

·         Have developed Oracle Forms and Reports for Warehouse Management System

·         Created Master detail forms and created template forms

 

 

·         Have worked Forms Objects- LOV, List Box, Drop Down, Radio Buttons, Canvases, Menus, Forms Triggers, Objects, Alert Message Box, Data Block, Relationships, Libraries, Object

Groups, Program Units, Record Groups, Parameters and Popup Menu, Property Classes and Visual Attributes

Dec-08 to Jun-09 (PHOBIS APPLICATION)

Customer: FUJITSU, UK.

Role: Oracle Application DBA, PL/SQL Developer, Data Modeler
Project Environment: Oracle PL/SQL, Forms, and Reports
Project Description:

Company supplied mobile and Land line phones, PHOBIS is the application that enables employees to view their mobile/landlines phone bills on line and then mark each call as either personal or company and to total up the cost of personal calls for sub sequent deduction from the payroll. Vodafone supply Fujitsu with call details for each mobile phone monthly and send a printed statement to the user. (An email sent to the user to advise him a bill has been received and needs checking). The user logs into PHOBIS and can see all monthly mobile/landline phone bills that have not been checked by him for private use calls. The user marks private calls. PHOBIS calculates the costs and creates a file for deduction from payroll. The credit is passed to the appropriate cost center.

Responsibilities:

·         Experienced with conceptual data models

·         Experienced in taking complex business problems and visualizing and simplifying them

·         Experienced using Erwin to data model

·         Experienced using a model repository to keep enterprise models updated

·         Experienced with data movement technologies(ETL)

·         Pl/SQL development (Stored Procs, Views & functions) in PL/SQL, Performance optimization and query tuning

·         Have involved Deployment and Release Activities

·         Have prepared technical and functional document

·         Creating Views, Packages, Functions and Triggers

·         Have created Types, PL/SQL tables and Exception Handling

Jan-05 to Nov-08 (EFRIEGHSUITE(ERP))

Customer: FREIGHT SYSTEMS LLC, Dubai, Middle East.

Role: PL/SQL, Oracle Forms, Reports Developer, Data Modeler

Project Environment: Oracle PL/SQL, Forms, and Reports
Project Description:

eFreightSuite enables transformation in freight forwarding services through a superior and holistic suite of solutions for freight forwarders, NVOCC. It is fully integrated with existing business models and enterprise infrastructures. The eFreightSuite is designed to assist operational and financial excellence by facilitating planning, execution, monitoring and control of freight movement across the transaction life cycle from receipt of order to job costing. The application has the features of multi-company, multi-location, multi-currency system with region and zone code supported system. This is web based application with centralized database for all the locations. User can generate various kind of reports like

MIS, analytical reports, account reports, customer reports, exception reports in xls, pdf, doc, txt, xml and html formats.

 

Responsibilities:

·         Have created New GUI Screen using Oracle Forms and Reports

·         Have worked on PL/SQL Development by using Oracle Objects(Packages, Cursors, Procedures, Functions, Triggers, Views, Synonyms, Database Jobs, Dynamic SQL, Exception handling

·         Have worked in PL/SQL Collections, Performance Tuning, Access Files using UTL_FILE, Indexes, Constraints, Complex Joins, Analytic Functions and Aggregate Functions, Global Temporary Tables, Ref Cursor, Materialized Views, Materialized Views, Sequences, Different Loops)

·         Have experienced for requirements analysis, design, development, testing, documentation, user training and support

·         Have implemented Freight Forwarding Out of Box Solution to customers.

·         Design and develop data models

·         Identify business data entities and attributes

·         Create physical and logical data model

·         Create SQL scripts and procedures to enable interaction with the front end applications for data retrieval

·         Create SQL scripts for data migration

Jun-03 to Jul-04 (PAYROLL PROCESSING SYSTEM)

Role: Application Development
Project Environment: VB 6.0, ASP 3.0, Crystal Reports and MYSQL
Project Description:

This Application is used to manage payroll processing for a small-scale company and categorized different types of functions are Employee master which maintain employee application login information and profile & preference details, Salary module stored salary component detail, allowance and deductions. This application solution had features to generate monthly salary, arrears and leave salary and maintained the salary history. Also, employee attendance and leave maintenance included in the system.

Responsibilities:

·         GUI Development using VB6.0 and ASP3.0

·         Have experienced in VB 6.0 objects Developments

·         Have worked on ASP Objects for Website Development

·         Designing of multi-layer forms using designs and layouts in VB

·         Designed forms for the software being developed by the organization

·         Connecting forms in VB to SQL or MS Access database

·         Error and Exception handling in Forms

·         Experience in Creating the User Controls and Custom Controls in VB 6.0

·         Involved in developing client server reports using reporting tools like Crystal Reports 9