PROFESSIONAL SUMMARY:

• I am an experienced IT Data Analyst with more than 5 years of progressive years of proven experience solving complex database, datawarehousing (ETL), Reporting, Web Page development.
• I have excellent data modeling, design, and development of SAP BW and ERP.
• Worked on BO analysis office for creating multiple Financial and sales reports.
• I have excellent Working knowledge of Oracle database admin, is equally as strong as writing complex SQL queries.
• I have extensively worked on crystal reporting and oracle BI discoverer to develop complex reports.
• Extensively worked on PHP/HTML/JavaScript for web development. Worked as a business Analyst to implement ERP in my organization.
• I have good understanding of SDLC & STLC.
• I have vast experience in project management & agile methodology.
• I am well spoken, a self - starter and detail oriented, these skills combined with my work history and technical acumen will make me an excellent addition to your project team.

TECHNICAL SKILLS:

ERP: SAP R/3 (ECC 6.0).

SAP ETL: SAP-BW /BI 7.3.

Data Base: Oracle 10g, 12c, MySQL.

Reporting Tool: BEx Designer, BEx Analyzer, crystal Report, BO (Analysis Office), Oracle BI Discoverer

Programing Languages: Sap Abap, SQL

Scripting Languages: Java Query, PHP, VB, HTML

Other Technical skills: Hardware and networking, Server maintenance, Firewall Admin

Exclusive involved in SAP BW and BO Reporting

• Involved in multiple projects including Implementation, Roll-out, Upgrade, Enhancement and Support.
• Involved in complete life cycle implementation of BW projects that include data modeling, technical designing, development, report generation and data extraction.
• Worked on various aspects of development such as requirements gathering, analysis, development, testing and deployment. Worked extensively on various functionalities of SAP BW like Extraction, Modeling and Reporting.
• Worked on both standard (Lo - Cockpit) and Generic extraction to pull various R/3 Systems data. Worked on Flat File Extraction to pull non R/3 data into BW Systems.
• Enhancement of the standard extractors using BADI.
• Extensively worked on BI 7.3 - Transformations, Data Transfer Process, Process chains, Roles & authorization concepts etc.
• Worked on various Data hosting and distribution concepts like Open Hub Destinations.
• Having knowledge on ABAP to create Generic data sources using Function modules and to write routines (Start/Transfer/Update/Info package) and Variable BADI Exits.
• Performed Data load management, Process Chain changes, Data source Enhancement, OLTP extraction data, Loading (Full /Delta Up-Load), Monitoring, MutiCubes, and Data Mart.
• Involved with performance tuning of queries by maintaining Aggregates, DB statistics, Compression, Partition and indexing of Info cubes.
• BW Reporting - Worked extensively in BEx Analyzer in building Queries and saving it in Workbooks. Expertise in front-end Business Warehouse Components like variables, calculated key figures, restricted key figures, Structures, Exceptions, Conditions.
• BADI Implementations for BEX Query.
• Business Content- Extensively involved in installing and customizing the standard BW business content.
• Involved in creation of adhoc queries using BO analysis office-Reporting tools.
• Worked on Cut over activities for system upgradation and System Preparation for Cycle testing.
• Dealt with numerous Business users and Analysts of Confidential business spread across the regions by providing them business solutions and trainings.

Exclusive involved in ERP

• Performs the necessary administration to ensure daily continuity of the ERP System.
• Provides functional expertise on the modules used by to company
• Develops enhancements to augment the ERP systems capabilities, duties/Responsibilities to accomplish essential functions: specific responsibilities may include, but are not limited to:
• Supporting the ERP system by maintaining roles, authorizations, device and jobs.
• Optimizing overall performance and system availability for core components
• Training and Mentoring the Group Employees to better understand the ERP system and to be able to complete some of the administrative tasks.
• Managing, and developing new customizations while supporting existing customizations that include reports, tables, sessions, forms.
• Working with the development team to integrate the ERP system with other systems.
• Providing functional support for the ERP system to all departments
• Continuous improvement of the ERP system.
• Performing annual functions such as archiving and year-end closing.
• Evaluating future products and providing directions and long - term vision for the ERP system.
• Material management in Store department through ERP Store Module

Exclusive involved in Oracle DBA

• Good Knowledge in Oracle Server Architecture.
• Working Experience on 24 x 7 Environments.
• Good Experience on creating a database manual and DBCA. (10g and 11g, 12c).
• Good Experience in installing an Oracle software in graphical mode and silent mode.
• Good in Parameter file, data dictionary.
• Experience in handling Space related issues of a Table spaces.
• Creating users with restricted access with required privilege.
• Creating profiles and attaching them with users and monitoring the users.
• Managing Control files, Online Redo logs, Archive Redo logs.
• Experience in taking regular off-line, online Backups.
• Experience in Performing Logical Backups like Exp/Imp and Data pump.
• Experience in RMAN CONFIGURATION and Performing RMAN backups.
• Taking the compressed backups and Incremental backups using RMAN
• Planning Backup & Recovery procedures, Performing Backup and Recovery activities using RMAN, Hot & Export/Import utilities.
• Having experience in Cloning of a database using Cold and Hot cloning and RMAN cloning.
• Upgraded the database from 10g to 11g.
• Having Knowledge on Maintaining and administration Data guard.

Exclusive involved in Web page Development

• I have a professional experience in PHP programming.
• Skilled in hardware operating systems and network procedures.
• Exceptional history with content management relational databases systems and web development.
• Extensive knowledge of CSS/HTML jQuery.
• Worked in File zilla.
• Captcha writing.
• Field validation.

PROFESSIONAL EXPERIENCE:

Consultant

Confidential

Roles and Responsibilities

• Involved in Modeling, Extraction, Reporting and designing.
• Created Info Cube, DSO, Info Objects, and Multi Provider as per the requirements.
• Regular interaction with client for understanding business requirement and also creation of Technical Spec.
• Worked on different Data Source enhancements using customer exits and BADI.
• Scheduling and transferring the data from R/3 and CRM to BW into PSA, DSOs, Cubes.
• Worked on LO extraction using LO Cockpit and V3 update.
• Involved in creating Generic Extractors using Function Module, Table, Info set and view.
• Created many process chains to automate the process of loading transactional data into the data targets.
• Involved in UTP activities.
• In reporting Bex making using Formulas, Selections, Structures, Conditions, restricted key figures, calculated key figures using formula variables and navigation Attribute, Used Variables with User Entry/Default Value, Replacement path and Customer Exit.
• Involved in Data Catalog activity for different business areas.
• Involved in Data load to Hierarchy for some SCRS.
• Involved in Reconciliation of data in dev and Quality Box.
• Worked on Start routines and End Routines, also field routines.
• Involved in Designing technical spec and creating sample data for testing.
• Involved in Quality review of my peers.
• Involved in end-user Training.

Consultant

Confidential

Roles and Responsibilities

• Requirement gathering, worked from blue print phase, closely worked with business and IT to implement the ERP.
• Gap Analysis.
• Master data creations, approval rights, report generation, process flow of the plant for implementation this module.
• Analyzing Task, Programming, Testing, Debugging, Bug Fixing, handling, performance report generating.
• Worked with the business team and the development team to meet all their requirements.
• Followed the agile methodology for SDLC and STLC.
• Giving training to users and help them to prepare the working manuals for the business processes.
• Developed different forms using SAP smartform.
• Developed multiple ALV sap reports using abap.
• Enhanced standard applications using BADI.
• Worked on LSMW to load data from different legacy system.

Consultant

Confidential

Roles and Responsibilities

• Creating table spaces and monitoring their growth and Resize or add more data files to database or table spaces for space related issues.
• Created Users, Roles, Profiles and granted privileges and permissions to appropriate users.
• Created and maintained database entities included tablespaces, data files, redo log files, rollback segments and renaming/relocating of data files on servers.
• Moving data between databases using utilities like Export /Import and Transportable Table spaces.
• Design, develop and implementation of automated backup and restoration procedures.
• Reorganizing the Tablespaces on scheduled basis.
• Cloning/ Refresh from PRODUCTION instance to TEST instances using both Hot and Cold Backup.
• Involved in disaster recovery planning
• Implementation of Backup and Recovery Strategies using RMAN.
• Monitoring the alert log files on regularly.
• Installation and configuration in ASM.
• Gathering statistics on schema and schema objects.
• Rebuilding indexes which are fragmented.
• Generating of experience on generating AWR, ADDM and ASH.
• Creation of DB LINKS.

Web Developer

Confidential

Roles and Responsibilities

• Managed and maintained development of PHP backend for dynamic database driven website.
• Provided technical support in the assurance of quality systems and system changes
• Development of web site.
• Script writing using Java script and vb scripts for requirement meet for validation purpose.
• Designing with CSS and HTML.
• Writing captcha.
• Validation of fields in website development.
• Both front end and backend development.
• Designed and implemented PHP MySQL solutions as per project specifications
• Collaborated with team members in the development of database structuring