Divyashree Shivashankar

**** * ****** **, ******, CO-80014 1-720-***-**** acy2pm@r.postjobfree.com Summary:

Professional experience in IT business domain and acted as liaison between business users and development team ensuring smooth workflow of web based application.

Expertise in Agile (Scrum) and Waterfall methodology for SDLC and JIRA for issue tracking and requirement management.

Experience in gathering business requirements, interacting with stakeholders, defining business processes, performing risk and impact analysis using appropriate templates and analysis tools.

Experience in analyzing and creating Use Case Models, Data Flow models, Workflow analysis, Functional analysis, object modeling along with Activity Diagrams and Sequence Diagrams using Microsoft Visio.

Strong experience in analyzing the business requirements, documenting and prioritizing user stories and used JIRA for project management.

Extensively used SQL queries for data verification and validation and optimizing the queries in Oracle and SQL Server.

Experience in conducting Joint Application Development (JAD) sessions for requirements gathering, analysis and design of the system

Excellent Object Oriented Design and programming Skills using Java, Web Services and Database technologies

Entire Software development life cycle experience from the Project conceptualization, Initiation, Scope definition, Business Analysis, Requirements Management, Design, Development, and Testing to implementation and handling post implementation issues.

Experience in Data visualization tools (Micro Strategy, Power BI, Tableau)

Experience of Integration Services (SSIS), Analysis Services (SSAS) and Reporting Services(SSRS).

Expertise in leading and mentoring individual’s tasks, which maximized productivity levels.

Quick learner and Capable of adapting to new and fast changing technologies quickly to deliver quality product on time.

Strong Analytical and Problem Solving skills, Multi-Tasking abilities helpful in envisioning Business situations.

Strong communication, organized, coordination and leadership skills. Professional Experience:

Worked as Associate-Projects for Cognizant Technology Solutions, Bangalore from May 2013 to May 2014.

Worked as Programmer Analyst for Cognizant Technology Solutions, Bangalore from Jan 2011 to April 2013.

Worked as Junior Developer for Uttara InfoSolutions Pvt. Ltd., Bangalore from July 2010 to Jan 2011. Education:

MS in Information System (Business Intelligence Concentration) May 2017 University of Colorado, Denver - GPA: 3.75/4.0

B.E in Electrical & Electronic Engineering Jun 2010 Visvesvaraya Technological University, Belgaum (India)- GPA: 3.5/4.0 Recognition & Awards:

Recognized as “Gladiator of the Quarter” in 2014 for handling the requirements independently without any production issues in Orbitz World Wide account.

Awarded KUDOS twice in 2012 and 2013 in recognition of Valuable contribution for Orbitz World Wide account. Skills:

Programming: Java, SQL, Python, Linux shell scripting, JSP, HTML5, CSS3 Database: Oracle 10g/11g, MS Access, My SQL, MS SSIS, SSAS, SSRS Operating Systems: Windows (XP/7/8/Vista), UNIX and LINUX Tools: Access, GitHub, JIRA, MySQL, Eclipse, TOAD, SONAR, MS-Office suite. Reporting /BI Tools: Micro Strategy, SAS Visual Analytics, Pentaho, Power BI, Tableau, MS Excel Architecture and Process: Waterfall, Agile methodologies and SOA Certifications:

Oracle Certified Master Java SE 6 Developer (OCMJD)

Cognizant Certified Professional in Core Java

Academic projects Aug 2015 to Dec 2016

Project 1: User Interface Design for Coffee Village Homestay Project Description:

Coffee Village home stay located near hill station and serves the tourists a place to stay and enjoy their vacation. Homestay business is operated manually and maintained the paper records/MS excel for customer booking details, information handling and other information. To transform the manual processes into automated, we created a centralized database and an interface design using MS access considering the functionalities like online booking, payments, 24/7 services and helps the homestay business admin to maintain the customer information and track the availability and check-in details. Responsibilities:

Worked on relationship database models, schema & entity-relationship diagrams (ERMs) to create technical/system design documents considering the business requirements.

Designed and developed database architectures and data models to improve company productivity and/or processes, and engage in the database development process from inception through services.

Developed SQL queries/scripts to create new tables, added constraints like primary key, foreign keys, insert data into tables and queries to retrieve data from Oracle database.

Design, develop code, implement, install, and maintain MS Access Database.

Designed and developed customer and management front end interface design using MS Access to ensure automated routine business operations.

Environment: Oracle 10/11g, SQL, MS Access, Excel, VPN and ERD Plus Project 2: Micro Strategy Dashboard monitor and Visualization for Restaurant Performance Analysis. Description:

Over the last year, the three New York locations of fast-food restaurant Blazin’ Burger have produced mixed financial results. As the regional manager, have been analyzing the performance data of fast-food restaurant from each location, gathering additional external data, and identifying the causes of these results. Responsibilities:

Using BI tools created a presentation-ready dashboard to monitor the Key Performance Indicators (KPIs) for all three restaurants locations by accessing the given Sales and Marketing data for those locations.

Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files) and then loaded the data into destination tables using SSIS.

Generated reports using SSRS to track the performance, sales and trend of restaurant.

I have also created Dashboards & Reports for Revenue Trends, Scores based on Cuisine types, Revenue performance vs Average Health score and Order count by day of week for better analyzing performance of restaurant. Environment: Micro Strategy, Excel, Tableau, SSIS, SSAS, SSRS, Dataset, Oracle Project 3: KAMRA- Digital learning center project using Waterfall and Agile methodology of project management. Description:

The Barbara Kirker School Digital Learning Center (DLC) Project has been designed to establish and equip schools with a modern computer laboratory, including Internet access and educational tool for enriching the learning environment for students. Designed and developed the complete DLC project following the IT Project Management (PMBOK) knowledge areas. Used tools such as Gantt chart to maintain the duration of the project, estimate and resources planning as per the actual progression of the project using this software. Used Project Libra software to manage tasks and milestones to ensure successful project completion.

Environment: Project Libra, MS-Office suite, Gantt chart Professional Projects:

Cognizant Technology Solutions Jul 2010 to 2014

Project 1: Orbitz- Site Content Project May 2013 to May 2014 Description:

The content management system is migration from ‘Alfresco a build on technology’ to a scalable, traceable content management system. Site developers will add required images from time to time to the site, supplied by the business to use in the specified spots. Use content management to store and manage digital assets. Site Images - publishing images.xml, including integration with Key Master to validate image keys. The project includes analysis and solution proposition of service requests raised by business users. Service Request is basically a change or enhancement that is driven by business or another application

Responsibilities:

Led a team of five and involved in daily Agile Scrum "Stand-up", Biweekly Sprint Planning and Retrospective Sessions and update the team on status of upcoming User Stories for the project.

Facilitated multiple Joint Application Design (JAD) sessions with Business and Technical SME’s, architects for analysis and design of the system, impact analysis of change requirements.

Worked in migration and conversion of data from the Alfresco into Oracle10g database, preparing mapping documents and developing partial SQL scripts as required.

Gathering requirements from various work streams and perform detailed analysis to produce business and technical requirement documents like SRS for use by Developers and QA.

Interacted with business users to gather user requirements, version control and update business documents by improving 50% usability in projects.

Collaborated with QA teams to perform UAT to ensure adequate software testing and developing the Test plan, test cases and Test Scenarios based on technical and business requirements.

Resolve all emergency production issues and ensure appropriate resolution of all issues within required time-frame.

Facilitated daily scrum, coordinated with onshore team for daily status update, resolving issues and monitoring progress

Performed Scrum Master responsibilities when required such as conducting Sprint Grooming, Sprint Planning, Sprint Retrospective and creating Product Backlog.

Ensure the best possible performance, quality, and responsiveness of the applications. Team Size: 5

Environment: Java, Spring Web flow, Grails/Groovy, SQL, XML, LINUX, JSP, HTML5, Eclipse 3.x, GitHub, JIRA, Oracle 10g/11g, TOAD, H2-DB, Find Bugs, Agile Methodologies Project 2: Away.com Travel Port Project Jan 2011 to Apr 2013 Orbitz World Wide (Washington DC, US)

Description:

Away.com is a Web application for all kinds of tourists across the world. This application presents all kinds of necessary information to the users with its dynamic content from Away’s rich content databases. The application uses Search Engine Optimized URL format to increase visibility to search engines. The application is a stateless web application deployed on tomcat, with oracle as the database. The architecture heavily uses Façade design pattern and hibernate for Oracle – The mapping framework.

Responsibilities:

Worked on project using Agile SCRUM methodology involving in daily stand up meetings.

Analyzed the specifications provided by the client, Developed/delivered the code as per the requirement and worked towards resolving production issues.

As a key person, I directly interact with the client on a scheduled basis for gathering the requirements information and clarifications.

Involved in development of controller component using Servlets and view component using JSP, XSLT, CSS, HTML and JavaScript for the client side validation.

Developed functional requirement specifications, creating detailed use cases and process flow diagrams to support functional specifications in the form of epics, user stories and used Wiki for documenting the same over different iterations and sprints.

Involved in various phases of Software Development Life Cycle (SDLC) of the application like Requirement gathering, Design, Analysis and Code development.

Develop and maintain elaborate services based architecture utilizing open source technologies like Hibernate, ORM and Spring MVC Framework.

Provide build support and monitor the build process during production builds.

Integrates applications by designing database architecture and server scripting; studying and establishing connectivity with network systems, search engines, and information servers. Team Size: 20+

Environment: Java, J2EE, Servlet, Struts Tiles Framework, JavaScript, Hibernate, XML, CSS, JSP, HTML, SQL, Oracle 10g, Eclipse, TOAD, Accurev, GitHub, SONAR, JIRA, Find Bugs, Tomcat, Agile Methodologies Project 3: Travel Port Away.com Admin Systems Jan 2011 to Apr 2013 Orbitz World Wide (Washington DC, US)

Description:

Away.com is a travel guide website which has Oracle as the background database. It has huge number of articles, which are categorized based on activity or interest and the destinations. The admin system deals in administering the data by categorizing and modifying. For this purpose, it has its own admin system which uses Spring Web flow framework. I have been part of the development of various admin systems which have helped administering the website better. As part of the trip.com team I was instrumental in development of DCL admin on which the trip.com website depends. Responsibilities:

Worked in Agile environment-SCRUM.

Worked on design, development, and testing during the development phases of various admin systems.

Used Sonar to analyze and measure source code quality.

Used various types of Oracle relational database tables to store the data. Also, handled history and audit of the data.

Good at Deploying code in the production and various development environments and was part of maintenance in tracking and fixing the defects.

Extensively involved in the enhancements, troubleshooting, bug fixes and change requests for the Web Services.

Provide build support and monitor the build process during production builds.

Developed the customized components with the offshore team and reviewed the customized components with the business team.

Team Size: 5

Environment: Java, J2EE, Servlet, Spring Web flow, JavaScript, HTML, and SQL, Eclipse 3.1, TOAD, Accurev, Tomcat Uttara InfoSolutions Pvt Ltd. Jul 2010 to Jan 2011 Project 4: Travel Site- parklanemysore.com Project Parklane agency

Parklane is a Web application for all kind of tourists and visitors in Karnataka, India. This application provides facilities like reservation, information about travel to Users, dynamic search engines, and rich database. Responsibilities:

Write code to generate web pages, access databases and business logic servers.

Closely worked with business system analyst to understand the requirements to ensure that right set of UI modules been built.

Worked on design, development, and testing during the development phases and content producers of the project.

Test and document software for web sites.

Successfully executed all the test cases and fixed any bugs/issues identified during the test cycles. Team Size: 4

Environment: Java, JavaScript, HTML, SQL, Oracle 10g, MySQL, JavaScript, and CSS, Eclipse 3.1, TOAD, SONAR, JIRA, Find Bugs, Tomcat, Waterfall Methodologies.

Contact this candidate