SUMMARY

• Over five years of IT experience in the field of Business Intelligence and Data Analytics, Data Warehousing in Retail, Banking and Financial Services, Media and Entertainment industries.
• Efficient in implementing BI solutions, problem solving, applying analytical skills in a cost - effective way by actively getting involved in various phases of SDLC cycle from requirement to Implementation phase.
• Trained around 15+ associates on technologies like ATG eCommerce, JUnits, SAP Business Objects, SAP Business Data Warehouse, SAP ERP and Business etiquettes.
• Coordinating with teams in US, India, China
• Expertise in SAP ERP (Enterprise Resource Planning) FICO, MRP, SD, MM, PP, BOM, Procurement, SAP BW (Business Data Warehouse), SAP BOBJ (Business Objects), SAP HANA, Web Intelligence, Crystal Reports, Xcelsius, Tableau
• Proficient in Base SAS, Advanced SAS, SAS Enterprise Miner
• Expertise in Requirement Gathering, Business Requirement Analysis, Preparing Technical Design Documents, Software Requirement Specifications, Developing Data Flow Diagrams & performing Unit Testing.
• Proficient in Google Analytics, Google Adwords, Search Engine Optimization (SEO), Core Java, Servlets, XML, HTML, C, C++, J2EE
• SAP Certified Associate-Business Process Integration with SAP ERP 6.0 EhP6
• Self-motivated & likes to do job with utmost dedication without any compromise on quality of work.
• Awarded “Feather in Cap” in Confidential Technologies Ltd for immense contribution during Holiday Season.
• Looking for Entry Level/Junior Management roles

TECHNICAL SKILLS

SAP Modules: SAP ERP, SAP ECC 6.0, MM, FICO, MRP, SD, SAP Business Objects, SAP NetWeaver BW, SAP HANA

Reporting Tools: Web Intelligence, Crystal Reports, Xcelsius, MS Office, Tableau

Data Warehousing: Data Modeling, Star Schema, OLAP, BEx Designer, BEx Analyzer

BI Tools & Other: SAS, Advance SAS, SAS Enterprise Miner, Google Analytics, Google AdWords, Vlookups, Pivot Table, Excel Statistical Data Analysis, Macros, Data Science, Machine Learning

Database tools: Oracle, MySQL, SQL Developer, PLSQL, UNIX, Big Data, Pig, Hive

Software: MS SharePoint, Service-Now, Jira, PPM

Operating System: Mac OS, Windows, Unix

Programming: Core Java, Servlets, JSP, XML, HTML, C, C++, J2EE, JUnits, ATG eCommerce

Other: Accounts Payable, Accounts Receivable, Procurement, Vendor Management, Use Case Diagrams, Sequence Diagram, UML, Scrum Methodologies, Agile Methodologies, MDM

PROFESSIONAL EXPERIENCE

SAP BO Developer

Confidential, California

Responsibilities:

• Built daily/weekly detailed status reports as well as summary & trend analysis of incidents/problems/change requests using SAP Business Objects - Web Intelligence with the data flowing from Service- now reporting.
• Collect and combine data from multiple sources and use to generate BOBJ Reports
• Published and validated reports and scheduled them as per business requirements using SAP Business Objects - Web Intelligence.
• Involved in data and functionality testing and validation of the two merging applications Interplan- WPTS.
• Ported over SAP BO- Web Intelligence reports from one source universe to another.
• Gained insight and built SAP mappings to perform ETL for “InterPlan” transactional data
• Demographic analytics for international releases of movies.

Environment: MS SharePoint, Splunk, ServiceNow, SAP Business Objects, SAP BW, Web Intelligence, Tableau.

Production Support Analyst

Confidential

Responsibilities:

• Coordinated with a team of 11+ members in various locations (US, Canada, India) for daily updates and work progress
• Worked with business analysts for requirement gathering and documentation (BRD), business analysis, and translated the business requirements into technical specifications to build the Enterprise data warehouse using SAP.
• Interacted with both Technical, functional and business audiences across different phases of the SLDC.
• Worked with data modelers to construct an efficient data model that best fits in reporting needs
• Involved in unit testing and system integration testing to ensure application integrity and quality.
• Prepared the Standard Operating Procedure (Knowledge Transfer) document, which provides necessary information, required for the Maintenance and Operation of the application.
• Automated activation report sent to the business and designed dashboards for Confidential Mobile to show new activations, lines, upgrades and plan changes for mobile communication companies like AT&T, Sprint, Verizon, T-mobile, MetroPcs, Net 10 using SAP Business Objects and other reports such as Web Intelligence and crystal reports
• Analyzed reasons for losing customers for different partner telecom companies during Holiday season
• Resolved application defects working with the QA teams with a target of 10 tickets per day that were raised in production i.e., in Confidential retail stores, Online site and Mobile Store thus improving performance by 16%.
• Experienced in Splunk Tool and also did a PROACTIVE alert set-up for any major failures.
• Implemented incident, problem and change management procedures for any support issues using ServiceNow.
• Involved in Server (WAR/patch) & Client (.jar/.lib/.properties files) Deployments and performed end-end validations for every release.

Environment: MySQL, SQL, Unix, Oracle, MS SharePoint, Splunk, ServiceNow, SAP Business Objects, SAP BW, JIRA

System Engineer (Java Developer)

Confidential

Responsibilities:

• Understand the various aspects of retail domain as well as gained more knowledge about the ecommerce framework ATG and how ATG web marketing and software platform was required to set up a retail project for Confidential .
• Worked extensively on web designing and Junits to test the Java codes for the market place implementation and find defects.
• Modify java codes and test the UI functionality, deploy and merge different versions of source codes in repository with the use of Tortoise SVN.
• Worked along manager to update project health tracker.

Environment: Eclipse, XML, MS SharePoint, ServiceNow, HP PPM(Project Portfolio Management), JIRA, WIKI

Project Engineer (ATG Developer)

Confidential

Responsibilities:

• Work on the Data Flow Diagrams, Data Dictionary, Database Normalization theory techniques, Entity relation modeling and design techniques.
• Expertise in SQL and PL/SQL programming, developing database triggers, Functions, Procedures.
• Extensive experience on using SQL, PL/SQL, ORACLE Database and many other ORACLE facilities.
• Highly skilled in Performance tuning - analyzing query plans and query tuning using the tools such as EXPLAIN PLAN
• Gain in-depth knowledge in user stories, Agile practices, use cases, ETL transformations
• Performing post migration testing and checking the integrity of application through manual testing.
• Thorough check of the server logs and application logs for any exceptions
• Daily updated reporting for the various application status and arranged for update calls with Onsite team

Environment: MySQL, SQL, PLSQL, ATG eCommerce, Unix, Putty, Oracle, MS SharePoint, Apache Tomcat

Trainee

Confidential

Responsibilities:

• Devised a software “Airline Management System” using simple JAVA code which was a systematic approach to airline reservations, ticket availability and agent information
• Trained in core Java, J2EE, XML, SQL, PLSQL
• Elected as the batch representative during the training
• Awarded one of the best mini projects of the batch for optimizing resources, improving time and efficiency
• Conducted knowledge transfer sessions about the ecommerce framework ATG for 15+ associates.
• Learn how ATG web marketing and software platform was required to set up a retail project.

Environment: Eclipse, Java, J2EE, XML, SQL, PLSQL, ATG eCommerce, Unix, Putty, Oracle, MS Access, Service Now, MS SharePoint, Apache Tomcat