More Related Content
What's hot (19)
Viewers also liked (20)
Similar to AnkitPRao (20)
AnkitPRao
- 1. ANKIT PRATAP RAO E-Mail: ankitprataprao@outlook.com Phone: +91-9819877211 Skype Id: ankit.rao84 LinkedIn: in.linkedin.com/in/ankitprataprao Proficiency in eliciting Business Requirements, System Requirements, Technical Documentation, Application Design, Development and Troubleshooting; targeting assignments in the areas of Application Support with an organisation of high repute Location Preference: Pune / Bangalore / Hyderabad SKILL SET Product Development Application Maintenance & Support Project Management Root Cause Analysis Competitors Research & Analysis MIS Reporting & Documentation SLA Compliance Troubleshooting Customer Relationship Management PROFILE SUMMARY Result-oriented professional; offering nearly 8 years of rich experience in Product Development, Application Support & Relationship Management Expertise in interacting with business users to analyse the business process and requirements and transforming requirements into screens, designing database, documenting and rolling out the deliverable Proven skills in creating complex reports by linking data from multiple data providers, using free hand SQL, stored procedures & functionalities Worked on platforms like PL/SQL, Oracle 10g/11g, Linux and Autosys Exposure to Airline Revenue Accounting Domain & Airline Interline business (Under SIS) Proficient in all aspects of software life cycle (SDLC) with waterfall and hybrid development methodologies Hands-on experience in DR implementation & testing An effective communicator with excellent relationship building. interpersonal, analytical, problem solving & leadership skills ORGANISATIONAL EXPERIENCE Accelya Kale Solutions Ltd., Pune (Mar12-Present) Client: LATAM Airways, Santiago Growth Path: Senior Programme: Mar12-Sep12 Lead Programmer Analyst: Sep12- Present JP Morgan, Powai, Mumbai as Application Development Support (Jul11-Mar12) Kale Solution Ltd., Thane, Mumbai as Senior Programmer Analyst (Jun08- Jul11) Key Result Areas: Eliciting business/system requirements & providing the customers with best solutions involving evaluation & definition of scope of project and finalization of project requirements Monitoring multiple projects from conceptualization and visualization to technology mapping and final execution Ensuring timely completion & delivery of project to the client & extending production support of multiple applications Working on SQL database maintenance, performance tuning and development of server administration scripts Determining customers' needs and desires by specifying the research needed to obtain market information Providing information for management by special reports and analyses; answering questions and requests Conducting User Acceptance Testing (UAT); supporting clients during testing weeks to build and strengthen their confidence in products Steering product demos for clients to build product knowledge and ensuring penetration & ramping-up the business Assisting the technical team in accomplishing related results as needed; upgrading the customer service centre to meet the growing customer needs Highlights: Awarded with Best Performer for the month of Nov12, Jan13 and Mar13 Analysed product features; evaluated factors that appeal to customers; provided valuable inputs during the planning, design and development of revenue accounting products Successfully worked for: o Vueling Airways in Barcelona, Spain as IT consultant o Japan Airways and worked in Tokyo for 6 months o Vietnam Airways in Hanoi VNA (ONSITE) for 6 months Rolled-out product communication strategies to ensure high brand recall & product engagement by end-users
- 2. Took several cost saving initiatives such as automating different modules Acknowledged with many spot awards for solving critical issues reported by client in Vietnam Airways/Air Berlin/Japan Airways in Accelya solutions Ltd. PROJECTS HANDLED: Title: Revera Client: LATAM Airline Period: Apr13-Present Designation: Application Development Support Designation: Lead Programmer Analyst Operating System: LINUX Tools: PL/SQL Developer, Putty, TOAD, WinSCP, EditPlus, Desktop Intelligence & SCP Team Size: 5 Description: Revera PRA is the most comprehensive passenger revenue accounting platform in the airline industry. Its high level of automation minimized processing errors and maximized productivity. It helped airlines respond to the demands of their internal customers with speed and accuracy. Responsibilities: Analysed the needs to examine different inputs incoming files from airways companies; created GAP & ICD for the same Coordinated with client to make them understand on different prospect of current system/product Steered debugging stored procedures and functions, triggers, packages; developed new PL/SQL blocks to incorporate new requirements Prepared procedures to make putty options and workarounds Created data to load the same in revenue accounting system Maintained new BO reports and identifying issues with the reports and if there are any changes in the query or data then making those changes Wrote Shell Scripts for new requirements and modified the same Conducted performance tuning of SQL scripts in production, test and training databases Single-handedly managed IR/CR development Deployed new IRs, patch releases and hot-fixes in production as well as in training and test environments Received calls from the client to understand the specific requirement and coordinating with them Title: IIPS (REVERA Interline) Client: Air Berlin & Air Turkish Period: Apr13-Present Designation: Senior Programmer Analyst Description: Revera Interline simplified the interline processes. It was designed to help airlines capitalize on the reengineering opportunities offered by SIS. It seamlessly connected with all revenue accounting and financial systems, including legacy. REVERA Interline was powered by APEX, the industry endorsed, highly accurate proration engine chosen by IATA. Tools: PL/SQL Developer, Putty, TOAD, WinSCP, EditPlus, Desktop Intelligence & SCP Team Size: 5 ACADEMIC DETAILS 2008 PG Diploma in Advanced Computing (Under C-DAC, Sunbeam) from DAC India University 2007 B.E. (Electronics & Telecommunications) from SSBT, Bambhori, Jalgaon 2002 12th from Kendriya Vidyalaya, CBSE Board 2000 10th from Kendriya Vidyalaya, CBSE Board IT SKILLS Operating Systems: Linux & Windows XP Databases: Oracle 10g Tools: PL/SQL Developer, Putty, TOAD, WinSCP, Edit Plus, Desktop Intelligence, SCP & Microsoft Excel CERTIFICATION CDAC & ITIL (Foundation) Certified from PeopleCert Institute PERSONAL DETAILS Date of Birth: 10th May 1984 Languages Known: English & Hindi Mailing Address: A502, 33 Keshav Kunj, Keshav Nagar, Mundwa, Pune
- 3. ANNEXURE PROJECT HANDLED in JP Morgan, Powai Mumbai Title: FSA/CAD (Capital Adequacy financial Reporting Database) Client: Bank of England Period: Jul12-Mar13 Designation: Application Development Support Team Size: 5 Description: Worked on FSA/CAD for data processing and generating reports. Tools: PL/SQL Developer, TOAD, Autosys & Linux Responsibilities: Managed debugging stored procedures, triggers, packages; developed new PL/SQL blocks to incorporate new requirements Prepared Shell Scripts as per the requirement from the bank and the test cases and published to all the stakeholders Reviewed the Autosys jobs and coordinated with different feed supplier Attended the calls of clients to gather the requirement and better understanding PROJECT HANDLED in Kale Solution Ltd., Thane Mumbai Title: Revera Period: Jun08-Jun12 Designation: Senior Programmer Analyst Description: Revera PRA helped airlines respond to the demands of their internal customers with speed and accuracy. With its powerful business intelligence capabilities and real-time revenue reporting, Revera delivered tangible business value for the airlines. Client: Vietnam Airways & Flybe Operating System: LINUX Tools: PL/SQL Developer, Putty, TOAD, WinSCP, EditPlus, Desktop Intelligence & SCP Team Size: 4s