ARCHANA PALIVELA

• Created business related reports using Back office association tool.
• Developed complex ETL solutions by translating design requirements into feasible, reusable and scalable technical implementations.
• Experience in Ingestion of data into Big Query through SAP BODS.
• Experience in creating visualization reports in Google Data Studio
• Participated with clients in discussion meetings.
• Leaded team and guide as per project requirements , understanding customer requirements.
• Creation and Maintenance of SAP data migration plan , integration plan and cutover plan.
• Created multiple webapps to help users to cleanser , merge and enrich data.
• Recruited in-demand talent to expand and diversify development staff.

Technical Skills / Environments:

SAP Business Objects Data Services, SQL Server , SAP Hana , Google Data Studio , Google Big Query

• Responsible for migration architecture of extract, transform and load.
• Applied relevancy rules for Customer , Materials , Vendors, Purchase Orders.
• Harmonized data prior to applying business rules and transformations.
• Tested all load programs and suggested improvements for better performance.
• Implemented cross reference for global usage.
• Engaged reporting teams on how best to utilize view and cross reference.
• Created many SQL views and stored procedures to transform data.
• Done configurations in DSP tool to connect with different source systems.
• Implemented a POC in SAP Business Object Data Services to replace Melissa Address Cleansing with SAP BODS address Cleansing Transform.

Technical Skills / Environments:

SAP Business Objects Data Services, SQL Server , SAP Hana , Tableau , Syniti ( Advance Data Migration ) 7.0

• Hands-on experience in extracting, transforming and loading non SAP data into SAP.
• Worked with Syniti ( Advance data migration) in gathering and implementing conversion logic.
• Utilized BODS to load data into SAP S4 Hana system.
• Harmonized data from acquired businesses into SAP system.
• Responsible for BODS development, job promotion and connection integrity.
• Promoted and implemented BODS object version control within Central repository.
• Data Harmonization, data enrichment, data cleansing, data quality for business needs and loading data into SAP HANA using SAP BODS/IDOCs.
• Perform Merge Match operation for address cleansing in SAP data services.
• Create a weekly reports for validation of obsolete materials using BOA dspMirgrate.

• Participated in design sessions with clients to ascertain all project specifications for applications, databases and systems.
• Performed regression and system-level testing to verify software quality and function prior to release.
• Documented program development and revisions and accurately maintained historical records.
• Updated documentation with project deviations to capture changes.
• Created and modified many BODS jobs to validate and reconcile data against SAP.
• Configuration of lookup tables.
• Analyze existing data and created various transformations to meet SAP requirements.

Technical Skills / Environments:

SAP Business Objects Data Services, SQL Server , SAP Hana , Syniti Advance Data migration)

• Analyzed, designed, developed, implemented and maintained Parallel jobs.
• Implemented pipeline and partitioning parallelism techniques and ensured load balancing of data.
• Supervise installation of DataStage Software and established all setups including data base connections, plugins, configuration file setup, directory setups.
• Worked on different source and target systems DB2, SYBASE, SQL SERVER, FACETS etc.
• Work with development team during development process, this include provide help with tasks and transfer knowledge on DataStage, Quality Stage, UNIX shell scripting.
• Developed DataStage jobs extensively using Aggregator, Join, Lookup, Sort, Merge, Copy and Datasets in Parallel version to achieve better job performance
• Developed Master Sequences using Activity stages such as Execute Command Stage, Terminator Stage Activity, Exception handler, Nested Condition, Sequencer, Terminator, User variables activity, Start Loop and end loop activity.
• Used Parallel version for parallel processing of data extraction and transformation.
• Developed Job templates, Shared components, DS functions and DS routines in order to reduce level of effort for future development and ongoing support.
• Designed and build process to migrate data from divisions to centralized application.
• Created and tuned SQL queries to improve performance.
• Implemented Type I and Type II slowly changing dimension tables from several operational source files.
• Involved in creating UNIX shell scripts for database connectivity and executing queries in parallel job execution.
• Debugging and providing solutions for complex data stage jobs and complex processes.
• Performed Unit test and System Integration testing by developing and documenting Test cases.
• Followed Best Practices and naming standards during SDLC of project.
• Involved in migration of DataStage jobs from Development to Production environment.
• Developed parallel code for existing server code to with performance tuning.
• Worked extensively on onsite-offshore model to meet deadlines as per client requirements.
• Developed Controllers, Sequencers and with scheduling them with scheduler called Zena.
• Aided with development of presentation layer for custom reporting and business intelligence.
• Built and maintained enterprise ETL processes using datastage.

• Involved in migration of jobs from DB2 to Netezza.
• Extensively used Aginity workbench for SQL querying.
• Good hands on experience with Datastage v8.7 v8.5, v8.1.
• Used DataStage Netezza Enterprise stage to load data, utilizing available processors to achieve job performance, configuration management of system resources in Orchestrate environment.
• Used Netezza Enterprise stage for doing loads into Netezza Database.
• Extensively used Lookup, Join, Merge stages for joining various information and used Parallel Transformer, Column Generator, Funnel, Filter, Switch, Modify, Pivot, Row Generator.
• Written SQL procedures to facilitate coding.
• Worked extensively on UNIX for scripting.
• Participated in source to target mapping design document, prepared system requirement documents based on data model and source target mapping documents.
• Identify business rules for data migration and perform data administration through data models and metadata.
• Worked extensively on onsite-offshore model to meet deadlines as per client requirements.
• Scheduled various ETL Batch processes using Control-M.

Technical Skills / Environments:

Datastage v8.7.x, v8.5, v8.1.x, Netezza 6.0, SQL, Db2 v9, Linux, Control- M

• Participated in developing Test plans.
• Reviewed SRS documents for correctness and completeness.
• Ensured system is acceptable for business and end users.
• Designed test cases using different techniques like equivalent, boundary and error guessing.
• Performed System, Integration and Regression testing and updated test cases with actual results.
• Created traceability to ensure coverage.
• Applied different testing Methodologies like Positive testing, Negative testing, and Error testing.
• Used Quality Center to design test cases, execute test cases, create and track defects.
• Assigned defects to development team and maintained communication with that team towards speedy resolution of defects.
• Tracked defects until closure of defects.
• Generate Test Status Reports on daily basis.
• Participated in Go/No-go meetings before implementation of project.
• Responsible for reviewing test plans.

Technical Skills / Environments:

MS Word, Excel, HP Quality Center

GPA: 3.75

Academic Projects:

ERP:

• Developed an ERP system for a pizza delivery store considering modules (Sales & Distribution, Production Planning, Financial, Material Management)
• Knowledge on how to implement and evaluate ERP systems in organizations
• Impact of ERP implementations on business process
• System Analysis and Design
• Designed and analyzed for Superior text books
• By using Select Architecture we have drawn the Use case diagram, Activity diagram, State chart diagram, Designed User Interfaces, Class diagram and object sequence for the system.

Web Development:

• To develop a web based application, which can be used to carry out online book sales and Articles Management
• Books Fair is an online book sales application provides with an environment, which is simple to use for end user
• It provides all the basic online shopping requirements for management of resources as well as end user flexibilities.

GPA: 3.2