MAJOR STRENGTHS:

• 12 years of experience defining, developing, documenting and using enterprise data architecture best practices to standardize and optimize the use of data and data models
• 5 years of experience making strategy recommendations related to data modeling that ensures data integrity and optimization
• 8 years of managing the team both at on-site and off-shore. Involved in People management , Status tracker and as liaison between Business analyst, Solution Architect, Higher management and Data Stewards throughout SDLC Life Cycle.
• Extensive experience of on all Software Development Life Cycle SDLC with data and requirement analysis, design, development, testing and implementation of software applications including in-house Enterprise Resource Planning applications. Have experience of tuning Oracle Forms, Reports 6i, SQL Performance Tuning, preparation and execution of stored procedures, functions and triggers.
• Experience in Data Architect, Build and Deployment Administrator,DB2 Database Administrator, Migration Team Lead cum Data Architect, Oracle Consultant, Oracle Form Developer and in-house ERP Systems Analyst
• Completed training on Big Data - Using Big Data to Transform an Enterprise
• Involved in POC for winning bids in Public and Healthcare sector.
• Involved in SOW preparation and resource Planning.
• 8 years of experience on Oracle 8i / 9i /10g DB and Forms 6i /10 and Reports 6i /10g with hands on PL/SQL , stored procedures, triggers, 3NF etc
• Experience as Data Quality Lead to actively drive and manage the data requirements for migration, coordinate with the Integrity project manager s and technical teams, create and review Requirements Documents
• Proficient in analyzing and translating business requirements to technical requirements and database modeling by having a strong Architecture concepts , database skills, Object Oriented Programming and development knowledge
• Well versed in preparation and execution of Test cases and good experience in different software testing like Sanity, Unit , Black-Box , White Box ,Alpha , Beta , Comparison, Integration and Interface
• Having knowledge of Data Management Tools i.e. Optim 6.5 which helps in Data Security, Data Anonymization, Data Masking, Archival and Test Data Management
• Executed software projects for Tele-communication, Industrial Manufacturing Distribution, Finance, Government and Energy and Utility industry
• Involved in Oracle databases proposal development for different bidding projects
• Technical panel for IBM India DBMS interview drives
• Good communication skills, interpersonal skills, self-motivated, quick learner, team player

TECHNICAL SKILLS:

PROFESSIONAL EXPERIENCE:

Confidential

ROLE : Project Manager cum Senior Data Architect

BDA is an internal Big Data Project that was a Proof of Concept for sales team. I was responsible for the following as a part of the proposed solution

1 Gathering medical data i.e Physician, Patient, Treatment, Diagnosis, and related data from Internet using Mozenda Tool. Also I retrieved back additional personal data, such as date of birth, location of birth, Weight Height, any personal data that reflects the individual race, ethnicity, sex, sexual orientation, etc. .

2 Developed a Data Model to support the storage of content analytics, and to store the full extractions onto AWS EMR Elastic Map Reduce environment.

3 Testing the Data in the Alchemy API tool to check for the Alchemy API standards and the keywords which can be used for Descriptive and Performance Analysis.

4 Creating the data for Qlikview which is an exploration discovery Analysis.

5 Inserting the data into OPENEMR database.

6 Mapping the data from both OPENEMR to Qlikview.

7 Insure that data once extracted from the EMR is HIPAA compliant.

8 Handled both on-shore and off-shore team of 4.

Confidential

Description: Confidential is one of the world's largest hospitality companies that offer individual consumers and business-to-business customers a broad suite of hospitality products and services across various accommodation alternatives and price ranges through premier portfolio of world-renowned brands. It is also world's largest developer and marketer of flexible, points-based vacation ownership products.

Voyager Platform/System:-

• A Wyndham had Physical Inventory Application which enables a variety of opportunities to modify data in its Physical Inventory database. The users modify physical inventory information that resides in a SQL Server Database. It also holds a set of views that simplifies the relevant data managed within. But, the current solution is very fragile, and as such there is concern that any time the business partner touches it, there's risk of breaking the data transition to pi-views as there is little understanding of how the data is being moved to the Voyager Data Platform Moreover, the current system only provides for daily refreshes of information from the Physical Inventory over to PI Views.
• I had the responsibility to bring up a solution. In order to resolve this issue, I was responsible for the performing the below tasks as a part of the proposed solution:-
• Trace the impact of 35 different transactions across Property and Inventory Management system so that user can have clear visibility of the changes they made either in the Source System or any of the downstream system.
• The impact was being done by interviewing the Business Persons, Query the ETL repository, analyzing ETL mapping, understanding the documents and tracing down the impact. This was further summarized into Data Flow Diagrams.
• Provide a quick and effective means to refresh the Physical Inventory Views in the voyager platform, without encountering any down time for the views.
• Lead team having 3 Analyst and 1 Technical Writer.
• B There was no daily data validation queries/reports designed to do a Data Validation Check for each domain/subject area. So, there was a need to design and execute a regular data validation check after the daily ETL jobs were being done that will validate at a high-level the key attributes and measures of each business domain within scope. This check should then compare it against the source system to determine the relative accuracy for each domain area. I am responsible for the below tasks to be performed as part of this solution are:
• Analyze and define high-level key metrics to be captured for each business subject areas that can quickly determine whether the production data is within the valid range or not. Compare key metrics with source data.
• Based on the domain, metrics will be compared at different data processing layers including Stage, Central Repository, Hub, and Analytics.
• Handling the team and updating the management of the Progress.
• Develop the High Level Design, Low Level Design and develop SQL statements that will populate the to-be-distributed flat-file.
• Develop flat file report that will be provided to users.
• Lead both on-shore and off-shore teams of 8 Technical Analysts.
• C After migration of the data in each layer, it needs to be tested to do data validation. My responsibilities for the this are as below:
• For field to field testing, mapping is done for each field at each layer. Queries are written for each filed to validate the counts at each layer. They were migrated in QC Tool where they were executed for validation of counts.
• In HRMS Testing, the mapping of the fields was done at each layer. Scenarios were prepared for each field and then queries were written. After migration of these queries in the QC Tool, validation was done after the counts of records at different data processing layers including Stage, Central Repository, Hub, and Analytics comparison.
• In the UAT testing, reconciliation of Testing needs to be done. To accomplish this task, mapping of the data was done. Then, queries were written and migrated to QC Tool before executing which is validation point for testing.
• Lead 3 on-shore Technical Analysts.
• D Responsible for the creation of different database scopes for next phase work. Analysis for work and hours required for the completion of these scopes was done.

Confidential

ROLE : Senior Data Architect cum Oracle Consultant

Description: Confidential has more than 250 companies located in 57 countries around the world. Their Family of Companies is organized into several business segments comprised of franchises and therapeutic categories. Basically J J has 3 categories which are 1 Consumer segment 2 Medical Devices and Diagnostics segment 3 Pharmaceuticals

I am working as Oracle consultant / Data Architect / Project Lead on the below modules:-

1 Confidential: - This is a worldwide decision support tool designed to assist Line Managers and Human Resource staff with compensation planning. In particular, this includes support for the year-end compensation planning cycle. The cycle formally begins in November and finishes in February with the issuance of bonuses and other forms of year-end compensation. However, a great deal of work is done in CompNAV before and after the planning cycle dates. CompNAV expedites the planning process by significantly reducing paperwork, providing Line Managers with sufficient information to make good compensation decisions and facilitating rapid review and approval. CompNAV accesses information from a real-time, common database. There is no importing and exporting of data and no data files to send to supervisors or HR/Compensation departments. For US operations, employee data remains current during the planning process and is updated for new hires and terminations.

Responsibilities: - My responsibilities for this module includes:-

• Development of a data strategy and design specifications
• Development of conceptual data models that demonstrate understanding of business rules, hierarchies and relationships between entities
• Development of logical data models based on client approved conceptual data models
• Responsible for the deployment of the physical database and the ongoing performance, stability and reliability of the database
• To grant role permission to users, batch jobs and elements on admin, planning and report modules
• To perform daily code and database migration on CompNAV and MyCompNav
• To support the daily tickets raised by client and assign them to team for the changes required and apprise them of status.
• Assist with the transition of currently running applications to the new technologies
• Review, recommend and assist with the implementation of systems monitoring and capacity planning
• Provides the means of system integration by understanding the source and target data and build the data mapping.
• High-level data architecture documentation, which illustrates the source and destination of data to and/or from approved data sources

Confidential is a Global Expense Reporting System gXRS . In this system the files are generated as per layout specifications and loaded into the gXRS database using a gXRS process that pulls a particular folder in the server for presence of the files during daily processing. As soon as the gXRS process finds these files they are processed and loaded or rejected depending on the validity of the files.

Responsibilities:- My responsibilities for this module includes :-

• To check daily load of the data loaded on daily basis
• To update daily users of the progress and status of daily data load
• To support the daily tickets raised by client for the changes required and apprise them of status.

Confidential

Role : Senior Data Architect

Responsibilities:

• I had worked on NASCO Mid-Tier Transformation Project as Information / Data Architect. This Mid-Tier Transformation / Modernization Project are being undertaken to:
• Improve and modernize the infrastructure and its support model
• Update and modernize NASCO mid-tier hosting technologies
• Assist with the transition of currently running applications to the new technologies
• Review, recommend and assist with the implementation of systems monitoring and capacity planning
• Improve system recovery with a 3-footprint server model Review and recommend virtualization strategies and opportunities and Improve new application support model
• Implement new Production Support Team model Implement new Application Delivery Team model
• Provide new service level delivery capabilities
• Understanding the customer's business requirements, business processes and system functionality to develop the data design and maintain the source of data.
• Responsible for developing and maintaining a formal description of the data and data structures which includes data definitions, data models for Conceptual, Logical and Physical Data Model, data dictionaries, data flow diagrams, etc. in short metadata for both OLAP and OLTP.
• Creating STAR and SNOWFLAKE Schemas.
• Data architecture includes topics such as metadata management, business semantics, data modeling and metadata workflow management.
• The architecture covers databases, data integration and the means to get to the data resolve the end to end data issues, design issues and end to end test issues with the help of data dictionaries.
• Provides the means of system integration by understanding the source and target data and build the data mapping.
• High-level data architecture documentation, which illustrates the source and destination of data to and/or from approved data sources
• Development of a data strategy and design specifications
• Design strategy and design for managing history data
• Selection of capabilities and systems to meet business information needs Evaluating new techniques for enhanced functionality
• Daily call and meeting with the customers to prepare document and review the migration strategy.
• Finalization of the tool strategy to be implemented and the different ways to optimize the application performance improvement.
• Check the consistency between sub-architectures and to identify the re-usable components with in the Architecture.
• Enforcement of Architecture Compliance and improving the maturity level of architecture discipline within the NASCO organization.
• To provide the basis for all decision-making with regard to changes to the architectures.
• To ensure that infrastructure projects are aligned with agreed-to IBM and NASCO standards and are scalable to meet both current NASCO requirements and future growth requirements.
• To ensure that the NASCO infrastructure considers the architecture of NASCO applications. As a result, I also need to review the infrastructure requirements for all CSRs and application projects greater than 500 hours, or of any size if deemed by an appropriate manager which contain changes that are significant enough to warrant review.
• To provide input based on knowledge and experience with the steady-state support of the NASCO Infrastructure environment.
• Responsible to stay abreast of new technologies and practices that might be suitable for consideration within the NASCO environment and to raise those as topics for future IAB Monthly Review Meetings.

Confidential

ROLE : Senior Oracle Consultant cum Data Architect

Description:

The Contact Management System CMS is a custom Oracle/Unix relational database application developed for the State of Michigan Department of Civil Rights. Its primary purpose is to record and store information documenting contacts from individuals and organizations regarding civil rights concerns and related requests for service. Service options covered include Complaint Issue processing, Community Outreach, Education, Contract Compliance and requests for Information. In addition to data keyed into the application, the system also provides the means to store and retrieve output documents generated by Oracle forms and reports modules in the application, to send emails with document attachments, and to upload and store externally created and/or scanned documents. The application also includes functionality to track business process workflow, to enter notes reflecting actions taken concerning specific requests for service, to readily export data to Excel and other applications, and to document chain-of-custody of contacts as they are moved from one user to another. CMS also provides the means for reporting and measuring department activities for management decision support and to satisfy requests for information from the state legislature and other government entities and from news media and members of the public.

Responsibilities:

• Working on Data Modeling and Architecture with 3NF implementation
• Installing Oracle 10g both on server and client and also installing Oracle Middleware like Oracle Application Server: Oracle Forms, Oracle Reports.
• Selectively purge records from the database in accordance with MDCR Records Retentions Schedules.
• Modify existing forms and reports to reflect changes in business processes and to enhance or restore functionality
• Create new forms and reports to support current business processes
• Correct appearance issues in existing reports, including those resulting from the shift to the Oracle 10g database platform
• Determine the source of and correct programming errors that delay or prevent the completion of data commits in specific modules
• Correct programming errors that prevent the proper functioning of specific aspects of the CMS application
• Assess the impact to CMS of a shift from Novell GroupWise to MS Outlook and make or plan for any modifications required to implement the transition
• Modify database structure by adding columns and tables as needed to support new functionality
• Create or modify forms and reports in accordance with written Work Orders provided by the MDCR Project Manager
• Assist and support User Acceptance Testing
• Deploy completed work upon authorization by the MDCR Project Manager
• Document the changes done for the existing reports and form and also if new forms and reports are created

Environment : Oracle 10g, Mainframe o/z

Confidential

ROLE : Oracle Data Architect cum Migration Lead

Responsibilities:

• Installation of Oracle 10g both on server and client
• Gathering Business requirements from database modeling perspective
• Designing Logical databases using IDA 7.5 Tool by referring Use Cases and business requirement using IDA 7.5 Tool
• Converting the Logical database to Physical databases in Oracle 10g Database by implementing 3NF.
• Drive and manage the team for the quality of data required for migration from Legacy system to Target System and
• Writing and executing Table Partitioning scripts
• Analysis of Table Compression and executing the scripts for the same
• Creating and reviewing Requirements Documents and Preparation
• Troubleshooting the data flow between Database and Interface
• Planning the strategy for data migration from legacy to the new proposed Database

Environment : Oracle 10g

Confidential

ROLE : Oracle Data Architect

Description:

Confidential offers specialty drug utilization management services for plan sponsors that want significant, often immediate cost savings and optimal patient care for their members. Since the existing system identified the front end MS Access interfaces as a capacity concern that will limit the growth of the application, so a standard base architecture is designed and implemented by IBM to align with Express-Scripts enterprise standards which met the expected growth of the Care Continuum business. The scope includes the application to be built with Layered architecture and will have loosely coupled components supporting service oriented architecture. The Application should be built on standard technology stack, supporting scalability Java/Websphere/Oracle Web application. It should leverage existing enterprise services Authentication and patterns ESB/Frameworks .Use of standard ESI-framework for development and existing Microsoft Access/SQL DB will be replaced with standard Java technology stack and oracle transaction server Database

Responsibilities:

• Installation of Oracle 10g SOA on server and client
• Gathering Business requirements from database modeling perspective
• Designing Logical databases using RDA 7.5 Tool by referring Use Cases and business requirement using RDA 7.5 Tool
• Converting the Logical database to Physical databases in Oracle 10g Database by implementing 3NF.
• Involved in database tuning by performing query optimization
• Drive and manage the team for the quality of data required for migration from Legacy system to Target System
• Creating and reviewing Requirements Documents Preparation
• Troubleshooting the data flow between Database and Interface
• Handled data migration team for data migration from legacy to the new Database

Environment : Oracle 10g

Confidential

ROLE : Build and Deployment Administrator

Description:

The Confidential module is a strategic, transformational, fundamentally IBM technology based solution that aims to transform Confidential online and e-commerce presence. The programs scope includes the definition and implementation of an architecture based on Websphere Commerce, along with the full scope of services to deploy the implementation within the T-Mobile network. In additional to the expected satisfaction of several hundred functional requirements, this deployment also satisfies many stringent non functional requirements and is the first comprehensive GBS led IBM commerce deployment within the Americas.

Responsibilities:

• Lead the support team tasked with managing code repository and code deployment across multiple environments Development / Testing / Production
• Responsible for managing database deployment across multiple environments Development /Testing / Production
• Coordinate staging off the code to the client's environment for deployment to testing and production environment
• Responsible for code and database quality assurance
• Involved in application trouble shooting and defect management.
• As communication liaison between Development/Test/Project management as relates to code and database management
• Help team in preparation and execution of Ant script for DB and Code Deployment
• Preparation and execution of test cases

Environment : UNIX,

Confidential

ROLE : Oracle Consultant cum Data Architect

Description:

Confidential Department of Corrections describes the need for a clinical data repository as the foundation for all future health information technology systems and as a central database for patient-inmate health records. The Receivership required a solution that enabled secure clinical and administrative information access, sharing and reuse to enhance patient access to care, clinical diagnostics, treatment and

reporting. The core initiative that is the basis for this CPR implementation is to establish a provider portal and a clinical data repository to manage the collection, reconciliation, data standardization, storage and distribution of a person-centric, clinical summary profile, the CPR Portal will integrate relevant information from numerous systems to provide a single view for a patient.

Responsibilities:

• To develop and perform ETL process for CPR using Oracle Data Integrator ODI tool
• Prepare CODB Central Offender Database and DECS Disability Effective Communications Database reference data/terminologies for Oracle consumption
• Prepare CODB and DECS transaction data for Oracle Initiate consumption
• Prepare Location Hierarchy tables for Oracle consumption
• Develop error handling processes/procedures for CODB and DECS
• Perform data cleansing and data remediation
• Involved in query tuning process
• Involved in duplicate record checking, analysis, survivorship and deletion
• Perform remediation of variances from specified standard medical terms and codes or IBM specified data formats
• Accept, resolve, investigate and escalate if necessary, ODI service Incidents from the CPR Call Center
• Monitor and repair of data feed issues from various vendors like Maxor, Quest and Foundation required for processing of data in ODI.
• To work with CPR to define, prioritize and complete design phase required for Minor Enhancements
• To provide Level 2 and Level 3 support for CPR
• Involved in Pharmacy profile review.

Environment : Oracle 10g, Windows XP

Confidential

ROLE : Oracle Data Architect cum Migration Lead

Description:

The project was supposed to develop a new computerized system for the monitoring and control of the production of the Supplement to the Official Journal of the European Union OJ S .A reliable but flexible open-ended and user-friendly production system needs to be built on well-established software, mainly based on standards to avoid the risk of lengthy developments and captivity. As this project is mission-critical. Every notice must be published within the delays stipulated by the community legislation, on pre-defined forms every edition of the OJ S must be published according to a pre-defined time schedule.

Responsibilities:

• Installation and configuration of Oracle 10 g SOA fusion.
• Designing Logical databases using RDA 7.5 Tool by referring Use Cases using RDA 7.5 Tool
• Converting the Logical database to Physical databases in Oracle 10g Database by implementing 3NF.
• Drive and manage the team for the quality of data required for migration from Legacy system to Target System and also create and review Requirements Documents
• Trouble shooting data flow between database and interface
• Preparation of Proof of Concept POC for DB migration by writing Oracle Scripts like procedures and functions for migration of the data from source existing system to target system
• Project SPOC for mandatory IBM Quality QPACE Trainings
• Handled the role of Defect Prevention Co-coordinator / Data Quality Coordinator
• Involved in PL SQL performance tuning

Environment : Oracle 10g, Windows XP

Confidential

ROLE : DB2 DBA

Description:

Confidential has a Social Security System in legacy application. They want to move to client-server technology and also enhance the features. The new IT solution is called VISTA which consists of several business and core applications. The server architecture of Vista is client independent and model driven. It is based on the generic component model and divided into logical layers to have clear separation of concerns.

Responsibilities:

• Creating and managing the database, database users, granting objects and system privileges, creating roles, tuning, backup and using tools for monitoring information about database health
• Applying Structural Changes like deltas Database changes and Loading of different data Application / FIT / AIT , CM Data, Dope Data received from Swiss team into different Applications to all offshore databases Development, A-Build and V-Build Databases
• Prepare Integression Test Environment for the Testers and Developers as per requirement specifications
• Involved with team for loading of correct data in databases.
• Involved in SQL performance tuning
• Responsible for effective communication between the project team and the customer
• Perform all the DBA activities including Technical and Pre-Migration Architecture review as and when required to complete the successful implementation
• Analyzing existing processes and based on that created database, control files, set initialization parameters and planned to distribute table spaces across different disks thus reducing disk contention and improved system response
• To provide full support and knowledge to the developers, users day to day activities related to databases including Development and Testing
• Database Refresh, Performing Export and Import in DB2 9.5 version
• Taking cold backups through Script

Environment : AIX 5.3, DB2 9.5

Confidential

ROLE : Migration Team Lead

Description:

Confidential has build and deployed Service Delivery Platform SDP for India's Top Telecommunication service provider Confidential, a highly scalable and available performance oriented platform to enable efficient delivery of real-time content services and delivery to various devices over convergent networks for its mobility and infotel subscriber base. This included migrating of Confidential subscriber base spread across multiple classic IT system into Central Subscriber repository and content management system.

Responsibilities:

• Preparation of Oracle and UNIX scripts like stored procedures and functions used in extraction of the subscribers from source systems
• Analysis and preparation of transformation rules to be applied in the migration Process. Coding, reviewing, testing, verification and SQL query optimization of Oracle and UNIX scripts used during subscriber's migration activity
• Actively drive and manage the data requirements for migration, coordinate with the Integrity project manager s and technical teams, create and review Requirements Documents
• Preparation of Subscriber migration Plan, Schedule, Strategy, Pre-requirements, Final Process, Testing and re-conciliation of final subscriber migration report
• Preparation and execution of Unit and Integration test cases of CMS, DRM and Transcoding
• Application
• Involved in performance testing of DRM Application covering performance logs and I/O
• Preparation and execution of High Availability test cases of DRM Application
• Execution of shake out test cases of CMS and DRM Applications after installation
• Involved in testing of CMS- Portal Interface using SOAPUI Tool.
• Communication with Architects and design the approach
• Customer interaction during UAT to demonstrate the application
• Involved in installation, administration, configuration of the following systems:-
• Content Management System CMS Application
• Digital Right Management DRM Application
• Transcoding Application
• Preparation of Catalog used for on-line portal system
• Fixing bugs of CMS and DRM Applications using JAVA Technology
• Installation of Load Balancer and Veritas Clusters on DRM servers
• Preparation of Trouble shooting documents
• Handling Device configuration Management, Media Types, Media Formats, Media
• Classification in CMS system

Environment : Red Hat Linux, IBM AIX, Oracle 10g Database, JAVA, J2EE, JSP, Windows NT/2000

Confidential

ROLE : Team Lead cum Oracle Consultant

Description:

• Confidential provides IT-based solution for various functional processes going in Confidential Manufacturing Application . It aims at integrating various business divisions using PL/SQL e.g. Packages, Cursors, Procedures, Functions Triggers. It has Oracle forms 10g.The modules handled are:-
• Access Control Module: The main objective of this system is to limit user access time. Depending upon the profile privilege of the user, the Global Access point will display only the program, the users are authorized to access. Users will have access to certain forms of the program in the Application with specific profiles at specified locations.
• Comprehensive Process Master: This system gives a comprehensive view of the processes in ALMAP system, which includes Master Maintenance like Machine, Jig Fixture, Gauge, Tools, and Accessories etc. along with Process Planning Sheet Control Plan.

Responsibilities:

• Coding, Reviewing, Testing, Bug Fixing and Integration
• Creating various Oracle reports for reporting purpose
• Tuning of different Forms and reports by doing SQL Query Performance tuning
• Creation of different database functions and triggers
• Creation of tables by implementing 3NF normalization.
• Creation and Maintenance of User Roles and Privileges, thereby ensuring user level security for the database at Application level
• Preparation and execution of Unit and System Integration test cases
• Performed Black Box, White-Box and Alpha testing and involved with client in Beta testing of Application

Environment : Oracle 10g on Tru 64 UNIX OS Oracle Form 9i / Report 9i

Confidential

Role: System Analyst

Description:

• Confidential , provide IT-based solution for various functional processes in the organization. It aims at integrating various business divisions including Marketing Financial Accounting, Billing, Personnel Payroll, and Inventory Management, Cable Maintenance etc. using PL/SQL e.g. Packages, Cursors, Procedures, and Functions Triggers with Oracle Forms 6i and report 6i. The modules handled are:-
• Marketing Financial Accounting System: The reports include all statutory books of Accounts Registers, Ledgers, Trial Balance, B/S, Vouchers Printing, Customer Outstanding, Date-wise receivable summary, Debit/Credit Note register, etc
• Personnel Payroll Management System: This system has the whole employee Information like leaves, advance, deductions, income tax payment attendance capturing, annual returns leave encashment, and full final.
• Inventory Management System: This system includes areas like Purchase Order, Item Wise Summary, Item wise detail, Transfer in, Transfer Out, bill passing, freight bill passing, Loan register, Location Identification.

Responsibilities:

• Provided technical and investigative support for functional users on interfaces, defects, change requests, debugging issues, testing and adhoc report requirements.
• Continued support for production issues.
• Analyzing system functionality requirements, documents and scope of the work.
• Table design for Master Data and Transactional Data by implementing 3NF normalization
• Supported user community in defining Service Level Agreements SLA
• Performance testing by tuning SQL query enhancements, code enhancements to achieve performance targets
• Creation of different database stored procedures , functions and triggers
• Involved in both regression and acceptance testing

Environment : Oracle 9i on IBM 7000, Developer 2000 Windows NT 5.0 client Forms 6i and reports 6i

Confidential

ROLE : Senior Programmer

Description:

• The aim of the in-house ERP project is to provide IT-based solution for various functional processes in the organization. It aims at integrating various business divisions including Marketing Finance Management, Transport Dispatch Management Personnel Payroll, Inventory management etc. using PL/SQL e.g. Packages, Cursors, Procedures, Functions Triggers and Oracle Forms 6i and report 6i.
• Marketing Finance Management System: This system includes areas like Branch controlling, RO billing, business rules for manufactured goods, costing, Party analysis and its controlling.
• Transport Dispatch Management System: This system caters to the various payments like billing, excise controlling, and integration with marketing department for invoices, freight payment.
• Personnel Payroll Management System: This system has the whole employee information like leaves, advance, deductions, income tax payment, attendance capturing, annual returns, leave encashment, and full final.
• Inventory Management System: This system includes areas like gate entry, purchase, user level indents, bill passing, freight bill passing, Loan register, Location Identification, consumable items bill passing, ISO quality vendor rating.

Responsibilities:

• Analyzed requirements and developed customized solution in Transport and Dispatch module to meet management requirements
• Creating daily entry screens and various screens involving data maintenance and reports
• Creating various reports for reporting purpose
• Creation of tables by implementing 3NF normalisation
• Performance tuning of different reports, forms and SQL query.
• Creating and integration of various screens using Forms Designer
• Documenting, writing and testing scripts.
• Creation of PL/SQL Packages, Procedures, Triggers.
• Developed customized solution for test data recording and statistical reports
• Perform different software testing like Black-Box, White-Box, Incremental Integration and Integration

Environment : Oracle 9i on IBM 7000, Developer 2000 Forms 6i and reports 6i on

Confidential

ROLE : Programmer

Project Description:

• The scope of the in-house ERP project includes different modules covering Sales Management, Master Production Scheduling, MRP, Procurement Management, Inventory Management, Shop floor Management, Maintenance, Accounts Finance, and Personnel Payroll. Oracle form 6.0 were used to prepare these modules.
• Sales Management System: The systems caters to various Sales related practices, and generates reports including Sales Party, region, product, country , Daily / Monthly Dispatch Plan v. Actual , NSR Report, Pending LC status, Pending Order.
• Inventory Management System: The system generates reports like Stock Status Report, Stock Ledger, ABC Analysis, Consumption Reports FIFO based , Non/Slow/Dead Items, and Min/Max ROL Reports.
• Procurement Management System: Apart from handling standard procurement practices, the module tracks vendor performance, pending indents, pending PO's. Status of any indent/PO can be viewed at a given point of time.
• Financial Accounting: The reports include all statutory books of accounts registers, Ledgers, Trial Balance, B/S, Vouchers Printing, Customer Outstanding, Date-wise receivable summary, Debit/Credit Note register, etc.

Responsibilities:

• Analyzing system functionality requirements, documents and scope of the work.
• Migration into Target system Oracle 8i from source system Sybase
• Table design for Master Data and Transactional Data by implementing 3NF normalization.
• Coding, Reviewing, Testing, Bug Fixing and Integration.
• Creating daily entry screens and various screens involving data maintenance and reports.
• Creating various reports for reporting purpose.
• Creating and integration of various screens using Forms Designer.
• Documenting, writing and testing the scripts
• Involved in different testing like Black-Box, White Box, Acceptance, Comparison, Functional testing.