Summary

Multifaceted, dedicated resourceful MS degree graduate with a strong academic background and a distinguished career working in different areas of software development, process improvement and data analysis. Well versed with different technologies and good experience in the area of systems analysis & design, relational databases, data analysis, client management, software testing & Quality Assurance and project management.  Open to relocation

Education

Education
Sep 2007 - Jun 2009

Master of Science

http://www.uc.edu

Graduated with a GPA of 3.85/4Related Courses:Project Management , Business Systems Analysis and Design (UML modeling) , Data Analysis, modeling and database design , Advanced Data Management , Business Intelligence , IT Auditing . ERP , Java , Web Applications Development using ASP.NET 3.5

IT Auditing  Created an IT audit plan to audit the Blackboard System for risk assessment / testing the controls using Sarbanes Oxley and COBIT principles. Project Management/Web Application Development    [MS Visual studio 2008, MS Project, MS Visio, SQL]Managed a Graduate Application System development life cycle. Gathered requirements, documented functional and business specifications, modeled the system using UML and implemented using Asp.netAdvanced Data Management                 [Oracle 11g, PL/SQL, MS office 2007, MS Visio]    Designed a relational database for a multiplex. Full development life cycle from case write up, E-R Modeling, logical schema design and normalized, created DDL and triggers using PL/SQL statements in Oracle and populated the relational database to test the systemBusiness IntelligenceLearned and used a Business Intelligence tool called Qlikview. Loaded data from several sources into the tool and analyzed the merged data for various purposes and used its reporting features to create graphical reports for presentation. System Analysis and Design    [MS Visio]                                                         Developed use cases, use case descriptions, sequence and class diagrams for a change management system using UML

Work History

Work History
Sep 2008 - Mar 2009

Business Systems Analyst, Global Web Solutions Center Intern

Atos Origin Inc

    Gathered user requirements, developed use cases (UML), functional specification & design documents and test cases for a web-based application development project which is used by Proctor & Gamble to support its marketing efforts.  Prepared test cases and performed quality assurance testing of several web based applications.  Liaised between US teams and offshore teams to co-ordinate project activities. Analysis of P&G’s product related data using Excel and SQL to identify data discrepancies and migration of data to databases using a Java application and Toad (Query Analyzer) for Oracle.Key Accomplishments:•   Improved, modeled, optimized and automated a complex content migration process  using Java which reduced the overall time spent for the data analysis and migration to database phase by about 75%•   Collaborated with representatives from P&G and offshore development  teams and resolved project issues in a timely manner•   Developed complex ad-hoc SQL queries for analyzing P&G’s product related data and identifying inconsistent data•   Demonstrated good understanding of systems analysis, data analysis techniques and tools used for the same

Aug 2007 - Jul 2008

Graduate Teaching Assistant

http://www.uc.edu

Taught IT lab course for business with emphasis in MS-Access, MS-Excel for Decision Support, MS-Expression web. Taught ERP Concepts, processing transactions through the logistics and support processes of SAP in the modules of SD, MM, PP, FI, CO, HR

Jun 2006 - Jul 2007

Systems/Programmer Analyst

Cognizant Technology Solutionsw

    Served in a Business Systems Analyst role for a J2EE based application development project and .Net based projects. Application used by D&B Corporation for pricing its customers. Liaised between Clients and offshore team, created use cases, and modeled the Business process for the system using MS Visio. Worked on all phases of the software development life cycle. Key Accomplishments:•   Developed key skills in Java, J2EE, ASP.NET,SQL, databases, Eclipse IDE, project management, SDLC documentation and testing•   Lead a team of 4 during the testing phase of a project and ensured a defect free application•   Cleared Sun certification for java (SCJP 1.4) and Cognizant certification for  Java Professional (CCJP)•   Served as the sole point of contact for project counterparts in USA to ensure co-ordination of project activities•   Demonstrated good understanding of the SDLC cycle, project management and client management experience

Skills

Skills

Technical Skills

•    Databases:  MySQL, SQL server 2005/2008, MS Access, Oracle, Toad, ERwin Data Modeler •    Application Software: MS Office, Visio, MS Project    •    Languages:  C, C++, Java and PL/SQL •    Web Development: VB,ASP.NET,JSP,J2EE, HTML •    ERP – SAP R/3 modules (MM,PP,SD, FI-CO) •    Testing/Automation tools: Quick Test Pro basics