Suja Sukumar
Pune
Summary
In a relatively short time, Qatar Airways has grown to more than 140 destinations worldwide, offering unmatched levels of service excellence that have helped excel the award-winning carrier to become best in the world. Voted Airline of the Year 2011 and in 2012 in the prestigious Skytrax industry audit, Qatar Airways has won the confidence of the travelling public. Systems Engineer Sep 2012-Nov2014 IT Commercial – Revenue Management, Qatar Airways Scope expanded to be the sole point of contact for PL/SQL queries for reporting team Worked on data preparation for dashboards for senior management Support of Informatica ETL job runs and performance tuning. Involvement in large scale projects designed to integrate data requirements for various systems.
Overview
19
19
years of professional experience
1
1
Certification
Work History
Technical Architect
Tata Consultancy Services
Pune
01.2017 - Current
- Managed all the reporting requirements for a large retailer in US.
- Managed migration of reports from MicroStrategy to Tableau and SSRS providing end to end solutions.
- Tableau Upgrades
- Providing end to end solutions in building Tableau reports including efficient data preparation for dashboards.
- Tableau open office sessions to promote self serve BI
- Collaborated with stakeholders to ensure successful delivery of projects
- Worked on data preparation for dashboards for senior management
- Successfully implemented migration of legacy applications.
Technology Manager
Tata Consultancy Services
Mumbai
09.2007 - 12.2016
- Led a team in designing, coding and testing for ETL and building MicroStrategy reports
- Involved in ETL part of a BI Project in Teradata SQL on Mainframes
- Working with BTEQs, MLOADs, Stored Procedures in Teradata and JCL on Mainframes
- Work included extraction of Credit Allowance data from Oracle on a UNIX platform to Mainframes using shell scripts and Uniftp utility
- Credit Allowance Data once stored on Teradata Database had to use Inventory transaction data already present on database to burst data from vendor level and allocate them to item/location level
- To perform this process, took part in designing and coding stored procedures in Teradata SQL Assistant
- Involved in performance tuning of the Teradata Stored Procedures in Teradata SQL Assistant by defining Indexes, partitions and fine tuning queries
- Also involved in the historical load and computation of Credit Allowance bursting from the beginning of the year till the current fiscal week which re-used the stored procedures set up for the normal process
- Designed the MicroStrategy architect objects and built MicroStrategy reports
- Trained and guided new recruits to the team.
- Conducted interviews and formed the project team and guided them throughout the project cycle
Team Member – Staffing Project
Tata Consultancy Services
Mumbai
10.2005 - 08.2007
- Resolved tickets/bugs raised in Service Desk based on priority
- Specialized in Margins, Tax Home Status, Assignment Processing related issues
- Worked on margin module enhancements which re-vamped the whole module and added new features to correct margin calculation using Informix 4GL and SQL
- Worked with SQL, Informix 4GL forms, cursors on a regular basis
- Fixed issues with cursors/programming in Informix 4GLs
- Did Impact Analysis for changes/enhancements
- Mentored and trained new recruits for this project
- Gave two week training to the offshore client set-up in Pune
- Started with a customer satisfaction index of 75% which went up to 98% by the end of the project.
Education
MCS (Master of Computer Science) -
MES Garware College
Pune04-2001
Skills
- Tableau
- croStrategy
- SSRS
- Teradata
- PL/SQL
- Migration projects
- Upgrades
- Project Management
- Informix 4GL
Certification
Teradata Certified SQL Specialist
Computingskills
Oracle PL/SQL, Informix 4GL, UNIX shell script, JCL, C++, Oracle, Informix, Teradata, Netezza, VPN, Visual Source Safe, NetTerm, Oracle Toad, MicroStrategy, Teradata SQL Assistant, Putty, DB Visualiser, SQL Navigator, Win CVS, Win SCP, IBM AIX UNIX, Solaris, GNU/Linux, Windows (Vista/98/2000/NT), IBM 390
Awards
- Received TCS Star of the Month Award in June 2006. Star of the Month is a monthly employee recognition program, to motivate achievers based on performance factors like contribution to complex assignments, client feedback etc.
- Received numerous appreciations from the client in the Cross Country Healthcare Project
- Received an appreciation from team member for mentoring in Toys R Us Net Margin Project
- Received 'On the Spot' award in Toys R Us Net Margin Project for working on critical modules and delivering them on time. On the Spot Award is an employee recognition award for doing good work and serving as an inspiration to others in the team
- Received 'On the Spot' award in Nielsen Online Panel Support Project for working on picking up the application at a fast pace and resolving production issues
- Received client appreciation in Nielsen Online Panel Support Project
- Received Best Team award as a part of the Nielsen Online Panel Support Project
Training
- Participated in Initial Learning Program held for TCS trainees in Trivandrum which covered basic courses in Computer Science and Soft Skills. This included training in Oracle, DBMS, Java, C++, UNIX, and Good Programming Skills among other courses
- Took a course in Oracle SQL from Syscoms Information Technology, Doha
Timeline
Technical Architect
Tata Consultancy Services
01.2017 - Current
Technology Manager
Tata Consultancy Services
09.2007 - 12.2016
Team Member – Staffing Project
Tata Consultancy Services
10.2005 - 08.2007
MCS (Master of Computer Science) -
MES Garware College
Similar Profiles
Vrunda ChindhadeVrunda Chindhade
HR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services LimitedHR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services Limited
Sreya BasuSreya Basu
Procare Analyst at Tata Steel(Tata Consultancy Services)Procare Analyst at Tata Steel(Tata Consultancy Services)
Arun VArun V
Program Manager at Tata consultancy services | Financial Ombudsman ServicesProgram Manager at Tata consultancy services | Financial Ombudsman Services
Naimish AgnihotriNaimish Agnihotri
Assistant Delivery Manager at Tata Consultancy Services, Global Shared ServicesAssistant Delivery Manager at Tata Consultancy Services, Global Shared Services
Pooja BotulePooja Botule
Associate Linux Support Engineer at Codify Software ServicesAssociate Linux Support Engineer at Codify Software Services