SHIKHAR KUMAR GUPTA

Email: acyb8u@r.postjobfree.com

www.skgworks.branded.me

Contact No. : +1-979-***-****

Detail-oriented experienced graduate with over three years of success devising innovative and tailored solutions to meet ever-changing business requirements within diverse industries seeking work. Able to manage teams and meet project deadlines cost effectively.

EDUCATION

M.S., Engineering Systems Management, Texas A&M University, College Station, TX - 2016

Bachelor's, Electronics & Communications Engineering, JIITU, Noida, India - 2012

TECHNICAL SKILLS

Tools & Applications: MSSQL Server, MySQL, SQL Plus, TOAD, PL/SQL Developer, PuTTy, SQL Navigator, SQL*Loader, SAP Crystal Reports, Oracle EBS R12, Oracle 11i, Oracle 10g/11g, Salesforce, RStudio, Visual C++, UML tools, Simio, @RISK, Adobe Photoshop, Dreamweaver, Illustrator, Flash, Excel, Access, PowerPoint, CS Photoshop, Visio.

Programming: R, SQL, Transact-SQL, PL/SQL, Java (Core), C, C++, Python, VBA, MATLAB, UNIX, JavaScript, PHP, HTML, CSS3

CERTIFICATIONS & TRAININGS

Salesforce certified Administrator WI 2017

Microsoft certified HTML5 with JavaScript and CSS3 Professional (2013)

NIIT certified Java Programmer (2010)

Diploma in Web Designing & Animation (2010)

Coursework: Project Management, Systems Management and Thinking, Engineering Data Analysis, Simulation Methods, Decision Making Analysis, Human Operations: Complex Systems, Industrial Analysis, Database Systems.

Salesforce and Oracle trainings on AR, AP (Accounts Payables), GL, Procurement, Order Management and Contract modules.

WORK EXPERIENCE

Texas A&M University, Graduate Business Assistant, May 2015 - August 2016

* Analyzed healthcare data and built technical system architecture & database application for management of Healthcare finances with SAP reporting capabilities using MSSQL Server, MS Access and SAP Crystal Reports.

* Achieved simple and complex financial calculator functions in C/C++ applications thus reducing 20% work hours.

* Created a Java and MS Access application for making adjustments and maintenance of financial database.

* Performed regression analysis in R on the financial and the survey data using current variables for forecasting.

* Charted out technical layouts of reports in SAP Business Objects and created them for financial reconciliation.

Accenture, Business Systems Analyst,Oct 2012 - July 2014

Implemented Oracle E-Business Suite and provided Support for Multinational Financial and Product firms.

* Designed, Built and Implemented 17+ technical system components like conversions, in & out bound interfaces, ETL on financial modules like Account Receivables (AR), AP, Contracts, PO, General Ledger (GL) and OM.

* Led the offshore team of six as a critical resource to support the Oracle ERP environment by resolving tickets.

* Imparted Brown bag sessions, white papers and documentation on financial modules in Oracle Apps ERP.

* Created Packages and Procedures to automatically drop table indexes and create indexes for the tables. Also, worked extensively on External Tables, Collections (Nested Tables and Varray) in complex backend packages.

* Created tables, complex SQL queries, and Correlated sub queries, Nested Queries, Views and Function Based Indexes for effective Business Application Development.

* Automated the Procure-to-Pay (P2P) process to efficiently place orders with vendors and process invoices, reducing requisition request cycle time by 80% thus making it user friendly and customer-facing.

* Conceptualized a plan with the team to integrate PL/SQL scripts, BI Reports, XML Check printing and discoverer reports used for analysis and forecasting trends for 15% value addition to the project and client’s business.

* Collaborated with business users to gather and document business requirements for their Oracle ERP SCM system and delivered and integrated new features using SDLC (Agile) methodology or resolved legacy issues.

* Optimized internal SharePoint site and worked on web parts, XSLT files, list and libraries during support phase.

* Transformed business requirements and EBS SLDC process into documentation like MD50, MD70, TE70 & IGs.

* Performed root cause analysis to streamline production workflow by optimizations and refactoring of PL/SQL stored procedures, code migrations, improving system performance and producing financial reports 50% faster.

* Applied advanced Excel techniques like VLOOKUPs, pivot tables and functions to monitor progress and deliver project status reports to key stakeholders on effort estimation, saving 20 hours of human effort per week.

* Worked on Exception handling, trouble-shooting PL/SQL code and displaying error messages in the application.

* Received awards and appreciation from management and client for business operations and value creation.

Center on Conflict and Development, Web Project Management Intern, Summer 2015

* Worked closely with coordinators for management, improvement & optimization of the Web Outreach Project.

* Collaborated with people in eight different conflict-ridden countries such as Ghana, Congo & Nepal to mitigate conflict.

Bangalore Aircraft Industries Limited, Systems Lead Engineer, Jun 2012 - Sept 2012

* Awarded Employee of the Month for leading a team of interns for Oracle financial database software support.

* Created and dealt with C/C++ applications, tables, complex SQL queries, Correlated sub queries, Nested Queries, Views, exception handling, performance tuning and Function Based Indexes for effective Business Application Development.

Defense Research and Development Organization, Industrial Intern, Summer 2011

* Created a GUI system on MATLAB for Early Detection in War based on Direction Finding research.

LEADERSHIP & VOLUNTEER WORK

* Volunteer Supervisor at a De-Addiction centre: Dayaneeta Social Welfare Society, New Delhi.

* Hyderabad HDC3 Head of GPTW (Great Place to Work) & PPA (Project People Advisors) Team Head, integral organizations of the Accenture Services Pvt. Ltd for event management and employee counselling.

* Senior Advisor to TAMU organization - International Student Organisation for Public Health Aggies (ISOPHA)

* Active member of Aggie International Ambassadors (AIA) & Indian Graduate Student Assoc. (IGSA) at TAMU.

* Chief Coordinator - Management cadre of an international event 'MOS-AK/GSA INDIA 2012'.

PROJECTS

* Database Systems Course Project: Designed a 3NF Database & Website for an event info website.

* Java SQL Interpreter: Created a functional SQL interpreter in Java for parsing and executing queries using limited memory blocks in RAM.

* Java Database Systems Course Project: Designed a 3NF Database & Website for an event info website.

* Health Monitoring and Wellness System: Designed a Health Monitoring System in accordance to U.S. DoD guidelines as a Systems Engineering Methods project and created system documentation to support it.

* Wireless Energy City System: Outlined a concept model for wireless energy city as a Systems Thinking project.

* Gesture Computer Interface: Built an C/C++ interface with MS Xbox Kinect sensor and OpenNI SDK libraries to play various racing and fps games by body gestures on your own laptop. For details: http://www.teKnoreality.com.

Contact this candidate