Developer Information Systems

LAKHAN S. CHHABRIYA

(***) - *** - **** *****@****.*** https://www.linkedin.com/in/lakhan-chhabriya/ PROFILE SUMMARY

● Information Systems graduate student with an extensive academic record.

● Over 4 years and 6 months of professional experience in designing and developing various applications, programs, analysis tools and database systems successfully.

● Demonstrated strengths in software development lifecycle processes including requirements gathering, design, and usability analyses, release and version control, application maintenance and handle support issues.

● Utilize my skills and experience to render excellent results which are beneficial for my professional and organization’s growth.

● Good team player with interest in creative and challenging technical activities. EDUCATION

New Jersey Institute of Technology, Newark, NJ Dec 2017 Masters in Information Systems GPA: 3.95

University of Mumbai, Mumbai, Maharashtra, India May 2012 Bachelors in Computer Engineering Class: First

TECHNICAL SKILLS

Oracle SQL-Pl/SQL, MS SQL Server Management, MySQL, Teradata, Microsoft Excel, XQuery, Cognos reports, Java, JavaScript, JDBC, Spring, Hibernate, HTML, Eclipse, XML, Axure, and SDLC. CERTIFICATIONS

ORACLE CERTIFIED ASSOCIATE

Oracle PL/SQL Developer Certified Associate.

ACADEMIC PROJECTS

Baseball Database Jan 2017 – May 2017

Key Responsibilities:

o Installed database and created tables, views, stored procedures, joins, and indexes in MS SQL Server. o Designed a detailed documentation of database, entity relationship diagram, logical and multidimensional data models.

o Expertized in writing large/complex queries using SQL joins. o Performed Database administration, recovery and backups, and application monitoring throughout a project. GETTECH - A social commerce platform for connecting and hiring technology service providers. Key Responsibilities: Sept 2016 – Dec 2016

o Designed an interactive prototype in Axure using Agile methodologies. o Prepared documents such as Software Requirement Specification, Technical Specification Document, Estimation, and Functional Specification Document. o Conducted in-person usability test and analyzed results of the prototype. Data Migration and Loading in Data warehouse using Teradata Utilities July 2011 – March 2012 Key Responsibilities:

o Created a database, users, tables, triggers, views, stored procedures, functions, joins and indexes in Teradata database.

o Designed logical and physical data models for the database. o Extensively worked with Teradata utilities like BTEQ, Fast Export, Fast Load, and Multi-Load to import data from flat files. Expertized in writing large/complex queries using SQL. WORK EXPERIENCE

New Jersey Institute of Technology March 2017 – December 2017 Part-time Oracle Database Developer

o Created and executed about 40 job chains using scheduling tool Automic Appworks to automate the processes thereby increasing productivity and consistency of output, documenting all these processes and test cases.

o Designed more than 90 reports using Business Intelligence tool Cognos and complex SQL queries and PL/SQL code for various department heads which can be used for future planning and decision making. o Provided support for the IT team and enterprise information systems (BANNER) needs of various stake holders within one or more function offices.

Oracle Financial Services Software Limited, Mumbai, India Jan 2013 – Aug 2016 Associate Application Developer

Flexcube 11.6 India Release (Retail Banking Product) Role: Impact Analysis, Requirement Analysis, Design and Development for Loans Module, and Database Development and Administration.

Technology: Oracle 11g, Core Java, Oracle PL/SQL Developer, Eclipse Key Responsibilities:

o Gathered requirements from the functional team and formulated designs to carry out the task using Agile development methodologies.

o Involved in designing of logical and physical data models, development and managing database objects such as Functions, Stored Procedures, Packages, Views, Indexes, Cursors, Constraints and triggers in Oracle 11g to achieve goals in the short deadlines. o Adapted the changes which needed to be done with minimal supervision without affecting the functionality of the other working modules.

o Volunteered to shoulder additional responsibilities for resolving any peer difficulties and help them to understand in a simple way which resulted in a better team bonding. o Performed user acceptance testing, bug fixing and development support using JIRA environment, which honed a lot of my abilities.

Flexcube 11.5 Version (Integration of FCR and FCUBS Version) Role: Application Developer (Module General Ledger and BIP Reports). Technology: Oracle 11g, Core Java, Oracle PL/SQL Developer, Eclipse Key Responsibilities:

o Analyzed the functional specification of both versions and accordingly provided the compatible change for the new system Flexcube 11.5.

o Managed database objects and proposed suitable process enhancements for the new product which facilitated the client to use only the single product instead of two existing different products. o Developed complex database objects, inline views and functions using PL/SQL in Oracle 11g to provide the same functionality independent of from where the system is accessed (Retail Banking side (FCR) or Corporate Banking side (UBS)) and whether the schema is a single or double thereby reducing the number of database objects.

o Tuned the SQL query by applying indexes which reduced the time taken to fetch customer details by 75%. o Validated the change requests and defects, tracking the test plans and results using JIRA environment. o Designed and developed more than 10 branch screens in Eclipse and complex database objects to generate various real-time reports for end users.

ACTIVITIES & INVOLVEMENTS

o Volunteered for Student Orientation program in NJIT o Core member of an NGO (KARTAVYA)

o Vice president of Google Developer Group, Mumbai o Chief mentor at ‘Teach for Kids’, which imparts free computer training o Elected as Vice Chairman for Watumull Chapter of the Computer Society of India o Organized many events and festivals during course of engineering o Completed Training in Basic Fire Safety and Emergency Preparedness

Contact this candidate