Data Technical Support

ac3xce@r.postjobfree.com

Phone no: 513-***-****

USA Citizen

Cincinnati, OH

SUMMARY OF QUALIFICATIONS

Pursuing certification for python for data science from university of San Diego

* ***** ** *xperience in HADOOOP and its components like HDFS, MAP REDUCE, HIVE, PIG SQOOP and Oozie.

Involved in writing Map Reduce code to covert the PDF input file format to text format and partitioning purpose.

Involved in writing the Pig scripts for ETL transformations on semi structured and unstructured data.

Involved in Importing the Data from RDBMS table to Hadoop HDFS and Export the process data from HDFS to any RDBMS table

Involved in creating HIVE Managed and External tables.

IT/Business Consultant experienced in testing, documenting, performing maintenance, and troubleshooting applications.

Experienced managing Procter and Gamble projects for their Retail and Finance applications.

Clarified project details with the customer and managed the offshore team to make sure objectives were met within the time frame allocated and within budget.

Skilled in managing and communicating with global cross functional teams.

Proven ability to work with vendors to gather requirements and manage development process through entire lifecycle.

Experienced with Oracle, SQL, Windows and UNIX.

Managed internal Oracle database (9iand 10g) usage and consulted with Engineering on database layout and performance issues that impacted applications.

Supported and maintained development and production Oracle databases.

Implemented backup and recovery processes.

Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization by coordinating with the offshore developers.

Modified database structures as necessary for enhancements and performance.

Planned for system growth and monitored capacity usage for new hardware or software requirements and communicated these capacity requirements to management.

Programming experience in C, PERL, UNIX, KORN and BASH shell scripts for variable information printing processes.

Business Requirements Analysis & Design

Lifecycle Management

ITIL/Service Management

Global/Offshore Experience

Training & Documentation

Project Coordination

TECHNICAL COMPETENCIES

Programming Languages: SQL, Perl, Java, ASP.Net, VB, C, C#, Python

Operating Systems: UNIX, Windows

Databases: Oracle

Technologies: Hadoop – HDFS, PIG, HIVE, SQOOP, OOZIE, MAPREDUCE

PROFESSIONAL EXPERIENCE

MYNTRA TECHNOLOGIES Inc. 2015-2017

Consultant (2015-2017)

Moved all crawl data flat files generated from various retailers to HDFS for further processing.

Written the Apache PIG scripts to process the HDFS data.

Created Hive tables to store the processed results in a tabular format.

Developed the sqoop scripts in order to make the interaction between Pig Output files and Oracle Database.

Involved in gathering the requirements, designing, development and testing

Writing the script files for processing data and loading to HDFS

Completely involved in the requirement analysis phase.

Moved all log/text files generated by various products into HDFS location

Written Map Reduce code that will take input as log files and parse the logs and structure them in tabular format to facilitate effective querying on the log data

Created External Hive Table on top of parsed data.

HEWLETT PACKARD at P&G (Cincinnati, OH, U.S.A) 2010-2012

Delivery Line Manager/Consultant (2010-2012)

For HP's Enterprise Services Department, managed projects and communicated management solutions to the Procter & Gamble (P&G) Retail business account with a focus on smooth functioning of the systems.

Documented management solutions for the Procter & Gamble (P&G) account and assured the automating of account’s transactions including: Purchase Orders Invoices and Acknowledgments.

Met with the customers to gather business requirements.

Managed the coding and testing EDI program.

Led the project team of up to 6 people, facilitated meetings, and documented project updates in MS Excel.

Met with the offshore development team to discuss technical details.

Estimated time and effort for the projects.

Automated EDI transactions including: Purchase Orders, Invoices, and Acknowledgments.

Documented training materials and coached the junior level resources.

Met with the Asia-Pacific EDI managers to ensure projects were successful end to end.

Consistently completed all projects as scheduled within the budget and according to quality standards.

Database Administrator (2006 -2010)

Managed data & processes throughout P&G's multiple databases globally.

Worked on business process applications of P&G's finance systems supporting and managing key systems integration and design projects.

Managed and supported all production, development and staging instances of Oracle 9i and 10g applications.

Worked with offshore software developers to develop and enhance applications.

Monitored usage of the databases and performed database tuning.

Planned for system growth and monitored capacity usage for new hardware or software requirements. Communicated these capacity requirements to management.

Provided technical support and assistance to all database end users.

Created new database, performed regular backups, and maintained the databases.

Monitored and performed troubleshooting of various databases remotely for databases located in US, Europe, and Asia-Pacific.

Maintained data integrity and tuned database for optimum performance and availability.

Worked as a team member with other DBAs to ensure 24X7 support of all corporate databases.

Documented training materials and mentored the junior level resources.

.

MIAMI SYSTEMS CORPORATION, Cincinnati, OH, U.S.A 2003-2006

Programmer

Developed, designed, coded, and debugged various computer programs and applications.

Collaborated with project managers in developing and writing specifications for applications.

Programmed in C, Perl, UNIX, Korn and Bash shell scripts for variable information printing processes.

Worked with regular expressions, SED, and AWK in programming.

Prepared statements as well as weekly and monthly bills, booklets, and magazines for customers.

Intern 2001

Designed and developed web based on-line application using Active Server Pages (ASP.net) for customer related transactions of a bank.

EDUCATION

Masters, Computer Application, JNTU, A.P, INDIA

Bachelors, Math and Statistics, AU, A.P, INDIA

Certifications

R Programming

The Data Scientist’s tool box

Contact this candidate