Sulata Panda

ac0pnb@r.postjobfree.com

IT Analyst

+1-563-***-****

Visa Status : L2EAD

Professional Summary

I am an experienced IT Analyst with more than 4 years of progressive years of proven experience solving complex database, data warehousing, Reporting, Webpage development, Network engineer and computer hardware field. I have excellent data modeling, design, and development of SAP BW and ERP. 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/JAVA Script for web development. Worked as a computer hardware and network engineer with server maintenance, dell sonic wall firewall.

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.

Education

Bachelors in Computer science & Engineering 2007-2011 from BPUT,India.

Professional Experience

Worked For Arya Iron and Steel Co. Pvt. Ltd., Mumbai as IT analyst from Aug 2012 to Apr2016.

Worked for Enliven Soft, Noida As a Software Trainee from September Sep 2011 to Jul 2012.

Technical Summary

ERP : SAP R/3, ECC 6.0,Orion ERP.

SAP Component : SAP-BW /BI 7.3, ABAP.

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

Reporting Tool : BEx Designer, BEx Analyzer, crystal Report, BO, Oracle BI Discoverer

Other Technical skills : Computer Hardware and networking,Server maintenance, PHP & VB Scripting,Firewall Admin,SQL.

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 writting.

Field validation.

Exclusive involved in Computer hardware and Networking

IT & ERP Administration, Networking Administration, Hardware Networking, All IT Assets Maintenance & Troubleshooting, All IT Sensitive items like CCTV Cameras, Switches, Routers, modems, printers Servers,(IBM Machine server, ) Windows Server 2003/2008 Maintenance & troubleshooting,etc maintenance & troubleshooting. Active Directory connection, Antivirus Maintenance,Troubleshooting etc

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 a 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 SAP BW

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 .

Involved in creation of web universe, web-reports by using BO-Reporting tools.

Worked on Cut over activities for system upgradation and System Preparation for Cycle testing.

Dealt with numerous Business users and Analysts of Arya Group business spread across the regions by providing them business solutions and trainings.

Project Experience

Project#1 (Website name : NEAS)

Role

Web Developer

Client

Type

Web site development

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 writting 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

Project#2 (Networking Implementation & Support)

Role

Consultant

Client

Arya Group

Type

Network Support to the tunnel kiln project office.

Roles and Responsibilities

Establishing the networking environment by designing system configuration, directing system installation, defining, documenting and enforcing system standards;

The design and implementation of new solutions and improving resilience of the current environment.

Maximizing network performance by monitoring performance, troubleshooting network problems and outages, scheduling upgrades and collaborating with network architects on network optimization.

Liaising with project management teams, third-line engineers and service desk engineers on a regular basis.

The support and administration of firewall environments in line with IT security policy.

The configuration of routing and switching equipment.

IP configuration.

the basic configuration of Dell sonic wall firewalls.

remote support to end users during installation.

Project#3(ERP)

Role

Consultant

Client

Arya Group

Type

ERP Implementation.

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.

Project#4(Oracle DBA)

Role

Consultant

Client

Arya Group

Type

Oracle Maintenance and Support

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.

Project#5(SAP BW)

Role

Consultant

Client

Arya Group

Type

Implementation

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.

Contact this candidate