PRATHYUSHA AKELLA

Phone: +1-571-***-**** Email: aculnl@r.postjobfree.com

SUMMARY

• Around 4 years of experience in Software Development, Integration, Business Intelligence and Database Platforms.

• Oracle Certified SQL Expert

• Computer Science engineer with expertise in a broad range of programming languages, expertise in algorithms and using various technologies

• Proficient in Data Migration, Data Extraction, Data Transformation and Data Loading using Oracle PL/SQL

• Experience understanding customer requirements and collaborating with developers in the implementation

• Have working knowledge in developing entity-relationship diagrams, Star/Snow Flake Schema Designs, and expert in modeling Transactional Databases and Data Warehouse

• Outstanding skills including data cleansing and processing, writing data extract scripts/programming for data conversion and researching complex data problems

• Extensive experience in using SAP Web Intelligence reports

• Have working knowledge in data integration using SAP BODS, in designing BO Universes and extract Business Objects Reports to support the user requirements

• Possess effective communication & presentation skills

• Worked in cross-functional and multinational teams TECHNICAL SKILLS

Reporting Tools Crystal Reports, SAP Web Intelligence ETL Tools Informatica Power center

Databases Oracle 10g

Methodologies Data Modeling – Logical/Physical/Dimensional, Star/Snow flake Schema, ETL, OLAP, Complete Software Development Lifecycle, Waterfall, Agile Languages SQL, PL/SQL, Java, JavaScript, HTML, CSS Data Integration Tools SAP BODS

Operating System Windows XP,7, UNIX

Middleware IBM Websphere v7.0, v8.0, SOAP

CERTIFICATIONS

• Oracle Certified Database SQL Expert (1Z0-047)

• IBM Certified Integration Developer - WebSphere Process Server V7.0 Certification (Score: 97/100)

• TCS Business Domain Academy: Foundation Certificate in Telecom (Score: 90/100) EDUCATION

JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY (JNTU), HYDERABAD, INDIA Bachelors of Technology in Computer Science and Engineering: Aug 2007 – May 2011

• Achieved First Class, with University Distinction

• Worked as an Event Coordinator and Organizer for QUBIT, a National level Technical Festival of the Department of Computer Science

PROFESSIONAL EXPERIENCE

Tata Consultancy Services

Systems Engineer (Feb, 2012 – Jun, 2015)

Project: Data warehousing using Business Intelligence tools: Virgin Atlantic Airways

• Led the monitoring of all Business Object Data Services (BODS) using SAP Extract-Transform-Load

(ETL) tool working with a large team

• Resolved and addressed efficiently all major and minor production issues as per the client requests

• Generated reports as per the client requirement on a daily basis using SAP Business Intelligence (BI) Reporting tools

Project: Bill Generation Integration in World Connect Project: Tata Communications Limited

• Worked independently on integrating the bill generation of all international accounts from a third party database to Geneva Billing System

• Developed the back-end adaptors and other mediation modules using middle-ware tools such as IBM Integration Designer (IID)

• Led the successful testing and deployment of the mediation modules in a Live environment using IBM WebSphere Application Server

Project: Data Migration from ACE Global Virtual Private Network (GVPN): Tata Communications Limited

(India)

• Led and built a new automatic integration module to read data from flat files and appropriately load the relevant databases using IBM Integration Designer (IID)

• Reduced process execution time from 60 minutes to 5 minutes when compared with an older module, using efficient data loading methods

• Developed and implemented a data loading module to aggregate and transform data to BIG data/XML based on business requirements, referring to an active, Point-Of-Sale (POS) database

• Developed PL/SQL Cursors, anonymous blocks and other objects for performing bulk updates.

• Extensively used SQL Loader to load data into the target tables. Wrote control files based on both positional mapping and CSV/pipe separated value

Project: Data Migration from Legacy Database to New End-to-End (E2E) Databases: Tata Communications Limited (India)

• Executed Data Reconciliation process for extracting billing and customer data, using relevant PL/SQL stored procedures and packages

• Coordinated with the client on data validation and implemented the required data cleaning services

• Prepared the pre-migration environment for future implementation of data loading and migration services

• Independently worked on creating new stored procedures as per the client requirements

• Led the training of four new associates to be able to independently handle data migration as per the set guidelines in the project

• Developed PL/SQL stored procedures and functions to facilitate consistent data entry into the database and for common utilities

• Implemented triggers that fired on detecting only updates that occurred on the column for logging purposes Project: Reconciliation of Telecommunication Consumer Order Data: Tata Communications Limited (India)

• Extracted reports according to the customer requirements using SQL development techniques

• Analyzed and verified data for consistency with other End-to-End systems with appropriate manual interventions

Project: Development of a Business Continuity Plan: Tata Communications Limited (India)

• Prepared an executable action plan to continue business in case of crisis, calamity or a failure of resources or processes

• Executed mock-drills coordinating with the concerned teams and prepared comprehensive reports with suggestions for the management

Project: Development of an Online Testing System: Tata Consultancy Services (India)

• Worked with a team of four to design and develop an online testing system with randomly generated questions

• Received recognition and appreciation for executing the project well within the estimated timelines Environment: PL/SQL, Oracle 10g, SQL, UNIX, SAP BODS, Crystal Reports, IBM Websphere, Java, SOAP, SAP Web Intelligence Reporting, Microsoft Office (Word, Excel, Outlook)

Contact this candidate