Somil_Aggarwal_CV_Tririga
- 1. Somil Aggarwal Mobile-+918860311118 Email-lovey210686@gmail.com http://lnkd.in/6HRr_V Education Bachelor of Technology in INFORMATION TECHNOLOGY, Uttar Pradesh Technical University, Lucknow, India, 2010. Experience Summary  Total 4.8 Years of experience in IT industry.  IBM TRIRIGA Certified.  Have experience in software development using IBM TRIRIGA tool for various requirements.  My technological forte is IBM TRIRIGA(10, 3.x), IBM Lotus Notes, Oracle, Lotus Script, BIRT, Pentaho ETL  Basic Knowledge of TRIRIGA Database structure.  Data loading experience using Data Connect, Data Integration, Offlining & Pentaho ETL.  Experience in reporting tool BIRT.  ITIL V3 foundations certified. Areas/Applications • Retail - Real Estate & Constructions(Capital Project Management, Scope Management, Scheduling) - Real Estate Site Selection Computers Worked on Computer System Programming Languages Special Software Windows Lotus Script, C, C++ IBM TRIRIGA, IBM Lotus Notes Designer,sql developer, BIRT Projects May 2011-Nov 2013 Tata Consultancy Services, India Role Developer (TRIRIGA) and Business Analyst (Lotus Notes) Period since Jan 2011-Nov 2012 Tool/Technology: IBM Tririga, Sql developer, Pentaho ETL 1
- 2. Client Name Walgreens Pharmacy, US Client Description Walgreens is one of the largest retailers in the US with primary business of pharmacy Currently they have around 8300 stores nationwide. Project The project involves the analysis, design and development of new customized Project tracking system and Real Estate Site development functionality to identify the potential locations for Walgreens stores and to track the whole life cycle of construction and project management activities till stores completion for different location types. Responsibilities • Fetch the business requirements from existing Lotus Notes application (site selection & Project Tracking). • Worked on Development of new customized site selection & capital Project module in Tririga. • Discussions with on-site coordinator & business users to cover the functionality, technical issues and scope of work. • Created FDD/TDD, performed unit testing by own before submissions of deliverables & performed the CM (Configuration Management) activities like OM Package backup, restore & maintenance with proper versioning. • Data Migration from Lotus to Tririga using data connect. • Created complex cross tab queries and BIRT reports. Also worked on offline process. Since Nov 2013 Tata Consultancy Services, India Role Developer Tool/Technology: IBM Tririga Client Name Walgreens Pharmacy, US Responsibilities/Duties • Involved in maintenance & Support activities for developed Site selection & Capital project module. • I customized the application as per user requirements, performed data fixes and small enhancements. • Created security matrix and user training documents. • I worked on various customization- (mainly)- Form building , Workflow designing, Report/Query creation, BIRT report creation, Object Migration & Unit Testing. Jan 2011 – Apr 2011 Tata Consultancy Services Title: Internal Training 2
- 3. Period: Jan 2011 to Apr 2011 Client Name - TCS Internal Position: ASE-Trainee Project Location: Trivandrum, India Training Attended Year Title Location Organised by 2011 Lotus Script Noida Tata Consultancy Services 2013 Pl/sql Noida Tata Consultancy Services 2012 IBM TRIRIGA Noida Tata Consultancy Services Personal Details Date of Birth June 21, 1988 Sex Male Nationality Indian Marital Status Unmarried Date of Joining Jan 31, 2011 Designation Systems Engineer Location New Delhi, India Passport Details J6032276 Issued at Ghaziabad (Uttar Pradesh, India) on Nov 29, 2010 Valid up to Nov 28, 2020 3