Gitika Poddar

Email: ac12j3@r.postjobfree.com 312-***-**** https://www.linkedin.com/in/gitika-poddar-7977b624 Chicago, IL 60616

EDUCATION

Illinois Institute of Technology (IIT), Chicago, IL May 2017

Master of Information Technology & Management GPA – 3.70/4.00

Relevant Courses: Advanced Database Management Systems, Data Analytics, Supply Chain Management, Information Technology Framework, Objected Oriented System Modeling & Design, IT Project Management, IT Auditing, Hadoop, And Human Computer Interaction.

University of Pune, India Jun 2011

Bachelor of Engineering in Electronics & Telecommunications GPA– 3.47/4.00

SKILLS

SDLC Methodologies

Agile, Waterfall

Internet Languages/ Web Applications

SAP Business objects, UML, HTML, SQL, JIRA, HP ALM, MS Visio, Tableau

Databases and Tools

SQL Server 2005, 2008 & 2012, Oracle 10g/11i, MS Access, My SQL, PL/SQL, ETL BODI

Languages

C/C++, Java, JavaScript, JavaFX, CSS, SQL, XML, SAS

Version Control

Team Foundation Services, SharePoint, GIT

Others Skills/Requirements Gathering Techniques

MS Office Suite (Word, Excel, PowerPoint), UAT testing, Ad-Hoc testing, Planning poker.

WORK HISTORY

Capgemini – Mumbai, India BI consultant July 2011 – July 2015

•As a BI consultant, collaborated with cross-functional teams (Oracle Tech, Oracle Functional & QA team) to analyze the business requirement to outline and propose solutions as per business needs.

•Involved in gathering functional and technical requirements from clients for developing SAP BO reports.

•Developed and implemented scalable global reporting best practices through use of SAP BO universe structures and SQL that could be tailor made to comply with data privacy policies for respective countries, increase streamlined approach to data reporting for financial analyses.

•Led team of 4 to drive critical software release activities and timeline planning for Financial Services rollouts.

•Ensured standard agile practices through regular Sprint Planning, Story Sizing, Task Breakdown, Spring Retrospective Meeting and Sprint Review sessions.

•Drove JAD and Brainstorming sessions with multiple international teams across Europe, USA, Asia and managed resources accordingly to meet determined goals & timelines.

•Worked closely with end users and stakeholders to drive test plans and test cases to perform UAT testing and Ad- hoc testing to identify any sort of usability issues.

•Created stories using Tablaue based on the data to analyze and communicate the KPI’s and Profits and Losses

•As the ‘Change Manager’, communicated frequently with the end users and the clients during the testing and

Implementation process, ensuring 80% customer satisfaction.

•Developed both WebI and DeskI reports using functionalities like Queries, Master Detail and Formula, Slice and Dice, Drilling, Cross Tab and Charts to analyze and present the data in a diverse perspective.

•Optimized universes by implementing aggregate awareness, derived tables and shortcut joins, created context, alias to resolve the loops and to increase operational efficiency.

•Analyzed and resolved discrepancies by performing an end-to-end analysis using complex SQL DDL, DML statements as well as Contexts and Alias.

•Created dynamic and complex SQL queries to retrieve large amount of data without compromising the performance or maintainability.

•Developed PL/SQL Stored Procedures, Triggers, Functions and Packages using Oracle tools like Toad.

•Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN and AUTOTRACE.

•Involved in the migration process from SAP BO XIR2 to SAP BO XIR3.

•Awarded “Project Star” for efficiently leading team through successful release.

Contact this candidate