Sapna Gupta's Email Addresses & Phone Numbers

• Senior Oracle Consultant with over 10 years of full project lifecycle experience incorporating analysis, design, development and testing stages of Oracle (OLTP &OLAP) applications in a wide variety of business applications into Banking , Telecom , Retail , Electronic Manufacturing and Financial Domain. Possess strong ability to quickly adapt to new applications, platforms and languages. •...

• Senior Oracle Consultant with over 10 years of full project lifecycle experience incorporating analysis, design, development and testing stages of Oracle (OLTP &OLAP) applications in a wide variety of business applications into Banking , Telecom , Retail , Electronic Manufacturing and Financial Domain. Possess strong ability to quickly adapt to new applications, platforms and languages. • Experienced in Oracle Business Intelligence Enterprise Edition( OBIEE ), BI Publisher ( Formerly Known As XML Publisher) • Exposure to Big Data, Data Science, HADOOP, HDFS, HIVE, PIG Tableau and Qlikview reporting tools. • Proven track record in troubleshooting of PL/SQL programming and addressing production issues like performance tuning and enhancement. • Extensive experience in programming, Coding, Testing and Debugging. • Written UNIX Shell Scripts for Customization of Work Environment and Automation of tasks. • Excellent client coordination, experience working closely with them in order to understand their requirements, issues and suggesting relevant solutions. • Excellent Analytical, Communication, and Team Working skills. • Experience in unit testing, system testing and integrated testing environment. • In depth knowledge of all the phases of SDLC, Agile Methodologies (SCRUM) • Superior work ethics with excellent communication and interpersonal skills with a strong aptitude towards learning new technologies backed with good analytical and communication skills • Clear written, Analytical and oral perception of ideas and concepts. Ability to articulate alternative solutions or workarounds. Ability to listen to superiors and absorb new technological advancesBusiness Information Analyst @ Working through Eden Recruitment as Business Information Analyst, on site at Google European Headquarters in Dublin. Working on Google big data , Google app scripts, BigQuery , Dremel , Plx tools to support finance department. From February 2015 to Present (11 months) Senior Data Analyst @ Worked in Data domain data warehouse in Data Quality team. From September 2014 to January 2015 (5 months) Oracle Consultant @ Played a key role in successfully implementing FATCA in KBC Bank for Retail and Personal Banking Clients and developing compliance reports. Team member of MARS ( Mortgage Arrears & Resolutions Systems) project relates to tracking , processing and end to end flow of mortgage application. Team member of CCMA (Central Bank’s Code of Conduct on Mortgage Arrears) project. From April 2012 to July 2014 (2 years 4 months) Software Consultant @ RAlite, Revenue assurance (RA) is a business philosophy that ensures processes, practices and procedures are aligned with the business requirements' of CSPs (Communication Service Providers), to optimize revenues, costs and margins. My role in this project was to develop reconciliation programs to monitor Revenue assurance using PostgreSQL. From September 2011 to March 2012 (7 months) Oracle Consultant @ Worked on Global time tracking system for all EMEA HP employees. Supported Procter & Gamble Data warehouse using Oracle 11g features.Member of Team working on ECCS (Enterprise consolidation Control System) and BPL (Brand Profit and Loss) Application which is running on this Data warehouse. From March 2009 to November 2010 (1 year 9 months) System Analyst @ Worked on Kenan Telecom Billing system and supported Data warehouse backend activities using Oracle 10g features. From February 2008 to February 2009 (1 year 1 month) Oracle Developer @ Worked on Migration of ERP application from Uniface to Oracle 10g. From March 2007 to January 2008 (11 months) Master of Science (MSc), Data Analytic / Data Science @ National College of Ireland From 2014 to 2015 Bachelor of Engineering (BE), Computer science @ National Institute of Technology Silchar Sapna Gupta is skilled in: R, Apache Storm, Apache Spark, Hadoop, HIVE, Google Analytics, Google BigQuery, Dashboard, DAC, Data Warehousing, Big Data, Performance Tuning, Predictive Modeling, Decision Modeling, Star Schema