Summary:
Senior Business Analyst with strong working knowledge on web driven
applications in the areas of e-commerce applications, software management
information systems, application architecture, business process re-
engineering, reverse engineering, requirements, user acceptance
verification, business applications, security, knowledge management,
process and control systems: Experienced in business requirements
gathering, use case modeling, data/ intelligence analysis, software
development life cycle projects UML designs using MS Visio and strategic
planning of projects, evaluation of proposals, response documents, and
project recommendations using JAD sessions. Have Subject Matter Expert
(SME) knowledge in Retail and Hospitality Industry.
Professional Highlights:
. A decisive, action-oriented and result-focused professional offering
10+ years of experience in IS/IT Project, and software development
life cycle (SDLC).
. Exceptional leadership skills, evidencing trust, respect, and
competency to lead and manage teams to operate within synergy and
deliver outstanding results in a collective manner. Persistent while
professional in pursuing data and obtaining timely and comprehensive
facts to synthesis for management reporting.
. Solid understanding of the project life cycle process, including
initiation, requirements gathering, analysis and design, Software
engineering development and application testing, development tools and
technologies, release and version control and have the ability to
transfer this knowledge to project teams and interface with all levels
of associates.
. Expert in interviewing techniques and scheduling meetings involving
stakeholders and sponsors.
. Very strong in key competencies of Project Management Knowledge Areas
such as scope, time, cost, quality, human resource, communications,
and risk.
. Excellent analytical skills, proficiency in root cause analysis,
demonstrated attention to detail, with ability to think strategically,
and demonstrate strong judgment.
. Experienced in creating ER diagram adhering to normalization concept.
. Experience with various industries in development, coding and designed
application and web applications with skills like Visual Basic 6.0,
'C', FoxPro, HTML, PHP, and ASP.
. Very good understanding and working knowledge on RDBMS such as ORACLE
and query language such as MS SQL, and MySQL
. Involved in program specification, coding and implementation of the
systems after unit and integration testing.
. Experience in Analysis, Design, and Testing and Maintenance phases of
software development life cycle.
. Have excellent knowledge in Object Oriented Design/ Programming, GUI,
CSS/HTML, Wireframes, MS Visio and MS Projects
. Strong experience in SQL, PL/SQL and ORACLE for creating stored
procedures, views and triggers.
. Strong trouble shooting skills.
. Experience with PL/SQL procedures/Packages with Visual Basic 6.0
framework.
WORK EXPERIENCE:
Client: Cricket Merchant LLC : Naperville, IL
Nov 2008 - Till Date
Sr. Business Analyst
Cricket Merchant is a prominent export house of cricket equipment and
accessories under one roof. Cricket Merchant is probably the only online
cricket equipment store that provided too many features to its customers
and carries more than 800 different cricket equipments from various
manufactures such as: Gray-Nicolls, Gunn & Moore, Slazenger, SG, SS, CA
etc.
Responsibilities:
. Put together a roadmap leading up to the final product and launch.
. Helped and later took the charge to do market research in sports
industry; to gain knowledge and complete insight of the process life
cycle.
. Identified manufactures, vendors, stockiest and wholesale distributors
and initiated communication for the startup business.
. Participated in Project Scope Management providing scope planning,
definition and creating work breakdown structures (WBS) using MS
Project
. Provided activity definition, sequencing, resources estimating, and
schedule development using MS Project
. Took active part in SCRUM and AGILE software development methodologies
as it was very critical to meet deadlines.
. Apply analytical and research skills to monitor trends and elevate
issues due to data variances across organizations. Improvise
solutions catered towards data variations.
. Conducted application design sessions with help of Flow Chart diagrams
and complex system design diagram.
. Identified strong customer focused technological features
. Interact with manufacturer, stockiest, vendors to developed, processes
for new business leads and UI decisions. Sole responsible for
marketing innovations for clients online retail domestic and global
sales.
. Interact with cricket playing national board members to generate more
business leads
. Helped client in creation of USA Cricket sports service and equipment
proposals (RFP)
. Implementation and customization of key ecommerce modules, to mention
few: SEO, Marketing Promotions and Tools, Analytics and Reporting,
Site Management, Catalog Management, Catalog Browsing, Product
Browsing, Mobile (iPhone) browsing, Order Management, Payment Gateway,
Shipping Modules, Affiliates Module, Customer Return Module, Database
Backups and Maintenance, New Letter Management, Discount Coupons
Modules, Featured Product, Expected Products, Specials, Product
Review, Who is Online and Real time Currency Converters with options
to have time interval currency update. In short a complete user
centered design.
. Full responsibility to stay active in social media marketing:
FaceBook, Twitter & Bebo
. Suggested and helped implementing mass media broadcasting tools such
as TweetDeck and TwitterFeed, which helped in Synchronizing FaceBook,
Twitter, Bebo and Cricket Merchant Blog.
. To overlook customer service and customer security and records
. To overlook day to day operations to make sure daily process life
cycle gets completed and to stay in touch with manufacturer, vendors
and stockiest to keep track of trade and inventory on regular basis.
. To explore various avenues to generate revenue upon study and
research, including conceptualizing CM brand for future product
launch.
Environment: Opens Source Commerce, MySQL 5.0, PHP, CSS/HTML, Wireframes,
Apache 2.2, MS Project 2007/2003, MS Visio 2007/2003, HTML, Macromedia
8.0 (Dreamweaver and Fireworks), MS Office Suite 2007: (Word, Excel,
Power Point, Outlook), Adobe Illustrator CS2, Social media.
Client: Live Travel: Glen Ellyn, IL
Feb 2007 - Oct 2008
Sr. Business Analyst
Live Hotel is an online hotel reservation ecommerce portal using open
source products to keep its running cost and end product cost low. By doing
so this portal will help its customer book/find rooms at cheaper price
compare to other hotel portals such as expedia.com, hotels.com,
travelocity.com. Unique feature that Live Hotel provide to its customer is
its introduction of SMART SEARCH or you can call it EXPERT SEARCH
Responsibilities:
. Participated in Project Integration Management, wrote business case
defined objective, current systems, problems, opportunities, critical
assumptions and constraints, analysis of options and recommendation
and initiated preliminary project requirements.
. Created Project charters for stakeholder and sponsor to sign and
approve
. Participated in Project Scope Management providing scope planning,
definition and creating work breakdown structures (WBS) using MS
Project
. Provided activity definition, sequencing, resources estimating, and
schedule development using MS Project
. Defined Project Quality Management and Communication Management
. Work with Director, Manager and Consultants at project start to
identify the needed roles, deliverables, dependencies, etc. by
providing assistance with establishing their initial project plan,
weekly project updates
. Provided milestone reports to Directors on weekly bases showing
current status and work completed.
. Used available informatics and proposed on how to use Neural Network
along with Artificial Intelligence to come up with a solution that may
result in a system that is close to an intelligence system or smart
system.
. Proposed a PATTERN RECOGNITION system
. Identify new system requirement update/modify complex existing program
when needed
. Created data definition for required field using MS Word.
. Assisted designers in developing portal logo and standards using
Macromedia Fireworks 8.0
. Created demo web pages using Macromedia Dreamweaver 8.0 for
presentation using Power Point.
Environment: MySQL 5.0, PHP, CSS/HTML, Wireframes, Apache 2.2, MS Project
2007/2003, MS Visio 2007/2003, HTML, Macromedia 8.0 (Dreamweaver and
Fireworks), MS Office Suite 2007/2003: (Word, Excel, Power Point,
Outlook), and Adobe Illustrator CS2
Client: Royal Vale Hospitality: Glen Ellyn, IL
April 06 -Jan 07
Sr. Business Analyst
Subject matter expert (SME) on hotel/motel vertical, including
understanding on LINUX OS and working skilled knowledge on Windows
environment, Super 8 part of Cendant family chain was undergoing major
updates on their existing system, I was responsible to handle and provide
data repository details on local property in Glen Ellyn. Installation
support on new IBM systems with LINUX as operating system and providing
property data to Cendant for master database creation, lead a project on
local property web site.
Responsibilities:
. Acted as a liaison between stakeholders and the development team for
the ecommerce project.
. Drive continuous enhancements of data capture, data integrity,
reporting capabilities & functionality of Cendant (myportal) reporting
tools through the development and maintenance of new and existing
reports for key business areas which track key business performance
metrics
. Gathered system requirements from various departments like accounting,
IS (Information Systems) through surveys and interviews.
. Worked on complete life cycle from requirement gathering, UI decision
to testing and user training.
. Provided successive solution on corporate branding displays and
materials.
. Conducted meetings/interviews with stakeholders and participated in
JAD sessions to collect business requirements and to review and
baseline the design documents on local web site.
. Created project templates using Macromedia 8.0 (Dreamweaver,
Fireworks) and HTML.
. Involved in creating Business Flow Diagrams, Dataflow diagrams, UML
Activity diagrams and ER diagrams using MS Visio
. Created functional specifications from the Business Requirements
Document
. Kept complete track on Web Development process using MS Project on
activities such as Work Breakdown Structure (WBS), Cost Management,
Human Resource Management, Integration and Closeout
. Mentored staff on new installed software and use of developed web site
and its integration with corporate web site www.super8.com.
Environment: LINUX, Windows XP/2000, MS Project 2003, MS Visio 2003,
CSS/HTML, Wireframes, Macromedia 8.0 (Dreamweaver and Fireworks), MS
Office Suite 2007/2003: (Word, Excel, Power Point, Outlook), and Adobe
Illustrator 11.0
Client: Royal Vale Hospitality: Glen Ellyn, IL
Oct 04 - Mar 06
Business Analyst
Americas Best Value Inn is a nationwide family of Inns, Suites, and Hotels
that are brought together by one common goal-customer satisfaction.
Directed by ABVI corporate, my responsibility was to manage entire
conversion project from its previous hotel brand to its new hotel chain
ABVI, which means new software, hardware, servers and many other management
issues that had to be taken into consideration in respect to hotel website
and it incorporation with chain web site.
Responsibilities:
. Conducted JAD sessions with management, SME, vendors, users and other
stakeholders for open and pending issues.
. Provide baseline concepts, technical analysis, and project management
to corporate directors.
. Managed relationship between local IT service support & vendor
providing global helpdesk services from corporate.
. Re-engineered service support processes like New-hire, Termination &
branding utilizing PMI methodology for process improvement.
. Designed the support process for more than 4 business applications and
infrastructure services, including implementation of SQL Servers 2000,
MSI Property Management System on three different nodes, online
extranet hotel portal and ABVI portal in relation to local property.
. Responsible to get local property sign up with online portals such as
expedia.com, hotels.com, travelocity.com, orbitz.com and to several
Global Distribution Systems (GDS) - Amadeus, Galileo, Sabre and
Worldspan,
. Mentored staff on installed applications and online portals such as
MSI Property Management System, GDS, Extranet, Genares and ABVI member
site.
. Managed a team of 24 employees directly responsible to follow up on
project scope management.
. Performed cross trainings/knowledge sharing within the team to bring
up the team performance.
. Worked on reporting & data analysis, assisting Team Lead in gauging
the helpdesk performance.
. Consulting the client and IT management throughout the project life
cycle, to assist and support the Requirements analysis, design,
development and implementation of effective systems.
. Creating standard development environment
. Performed human resource management using MS Project, communication
and quality tasks during execution phase
. Used MS Project to create WBS for entire SDLC of its new hub site.
. Sole responsible in project management cycle: Initiate Planning,
Execution, Control, Closeout and Cost
. Provide local hub site design, standard, and contains, that were than
integrated with corporate site.
. Managed a team of 4: designer, technical writer, web developer and
Flash animator.
. Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams and ER
Diagrams in MS Visio.
Environment: MS SQL Server 2000, SQL, MS Project 2003, MS Visio 2003,
CSS/HTML, Wireframes, Macromedia 8.0 (Dreamweaver and Fireworks), MS
Office Suite 2003: (Word, Excel, Power Point, Outlook), and Adobe
Illustrator 7.0
Client: Wellesley Inn & Suites: Glen Ellyn, IL
Jan 2003 - Aug 2004
Visual Basic 6.0/VB .NET Programmer
. Time Management application written using Visual Basic .NET and MS
Access for database storage & SQL (Access) for database handling to
process Payroll Check from the main Time Management System.
. Analyze & Planned and developing Time Management system
. That reduces company's payroll expenses
. Automated calculation of employee work hours and overtime with an
approval
. Features like Faxing or attaching employee work hours report to an
email.
. Login security and access privileges used VB FORMS
. Application programmed in Visual Basic 6.0
. Used Microsoft Access as backend Database
. Used MS SQL/Access for data retrieval, updates & modification.
Environment: Visual Basic 6.0, Microsoft Access, SQL* PLUS, MS Office
2000(Word, Excel, PowerPoint), MS Visio 2000
Client: College Of Dupage: Glen Ellyn, IL
Feb 1999 to Sep 2002
Programmer Analyst
. Responsible for ad hoc query request from student department.
. Minimize database complicity by providing Compaq PL/SQL procedures for
end result
. Helped, suggested better database design for quick response time by
creating views, clusters and indexing tables.
. Major workload was to update existing procedures that adhere to
student database.
. Programming /defining student grade base on provided college rules.
. Developed procedures for several major department including records
and Human resources.
. Login security and access privileges
Environment: PL/SQL, Oracle Database, SQL* PLUS, MS Office 2000(Word,
Excel, PowerPoint), MS Visio 2000
Client: Aptech: (Gujarat India)
Sep 1997 to Apr 1998
Application Programmer http://www.aptech-worldwide.com/
. Designed and developed several modules in a team environment, using
Oracle 7.1 - RDBMS
. Used Oracle 7.1 as a backend for GUI procedural development using
Developer 2000
. Created tables, views, index views and cluster views and reports by
developing stored procedures
. Planned and conducted trainings in a classroom environment for clients
of both academic and industrial backgrounds
. Group trained the clients in Developer 2000, Oracle, SQL, PL/SQL, 'C',
and FoxPro 2.6 by using innovative and practical learning methods.
. Introduced faster and yet comprehensive tools of utilizing enormous
information to assist clients in putting academics into practical use
Environment: Oracle 7.1, SQL* Plus, Developer 2000, PL/SQ, Windows 98
Future Generation: Gujarat India
Jun 1997 to Aug 1997
Consultant (System Analyst)
. Analyze clients system with help of different designing tools like
Data Flow Diagrams (DFD), Entity Relationship Diagram (ERD), and
manpower scheduling chart with documentation on proposed current
system
. Assisted in recruiting, marketing, planning, networking, and
administrative areas for promoting the firm's product successfully
. Responsible to provide data security and entry in Lotus 123 during
clients UNIX OS conversion.
. Extensively got involved in creating accounting charts, using Lotus
123 with necessary math formulas.
Environment: Windows 3.1, Lotus 123, C, UNIX, Windows 95, MS/DOS
Aash Computers: Gujarat India
Aug 1994 to Apr 1997
Business Technical Expert
. Responsible for setting up interviews for potential new hires
. Negotiated rates for all potential employees
. Worked directly with client managers at various company's to enhance
business relationships
. Required to make over 100 calls per week to potential candidates.
. Required to generate leads for all account managers
. Recruited nationwide for all high level positions
. Looked for variety of skills sets included but not limited to UNIX,
FoxPro, Tally Accounting, Project Managers, Business Analysts, Desktop
Support, and Helpdesk
. Expertise in project related duties like, requirements gathering,
design, development and testing of software
. Tested, debugged, and developed modules and sub-modules
. Project member of software development that used 'C' and FoxPro 2.5
programming
Environment: C, FoxPro 2.5, MS/DOS, Windows 95
Technical Skills:
Operating system : UNIX with shell programming, DOS, Windows
95/98/2000/XP
Languages : Visual Studio 6.0, Visual Basic 6.0, SQL*Plus, PL/SQL, C/C++,
and
Knowledge of JAVA Programming
Database : ORACLE 6, 7.1 and 8i, MySQL, MS Access
Front Ends : Developer 2000 [Forms Designer 4.5, Report Designer, Graphic
Designer, and
Menu Builder]
Development Software : MS FoxPro 2.6 and, FoxPro 2.5, Access 2000
Web Development : PHP, ASP, VBScript, HTML 4.0, Dreamweaver 8.0, Flash 8.0
Designing Tools : Adobe Illustrator. CS2/7.0 and Ulead GIF Animator 5.0,
Firework 8.0
Application : MS Office Suite 2007, 2000
Project Management : MS Project 2007/2003
UML Tools : MS Visio 2007/2003/2000
Year of Experience : 10+ years of professional work experience
Education:
Masters in Information Science (MIS) Northeastern Illinois University
Chicago, IL
Highlights: Pursuing Project Management
Bachelor in Computer Science Northeastern Illinois University
Computer Science Chicago, IL
Diploma/Certifications:
. Brainbench SQL Certified Nov 2000 (ID: I974008)
. Masters Diploma in Software Engineering (MDSE), June 94 - Dec 1997
Aptech Computer Education (http://www.aptech-education.com/)
Gujarat, India
. Civil Draftsman Engineering, May 1995 - June 1997 Industrial Training
Institution Gujarat, India.
Part time Project Experience while doing MDSE (1994 - 1998):
[pic] Electricity Generating Company named Ahmedabad Electric Company.
Participated in the design and development of the company's RF
(Requisition Form) using ORACLE 6, Performed the following:
. Developed RF data entry transaction application for billing using five
major options like new account, transferring account, increase in
assumption in Kwts, change address and deactivate accounts
. Developed material master entry, modification and transaction
application
. Automatic assignment of job/task for contractors using developed
application
. On line customer request
. Generation of reports for each individual stage
Environment: Application Development using unix base oracle 6 (forms, V3
triggers, sql, pl/sql sql reports and sql menus)
[pic] BRITISH LIBRARY AHMEDABAD, PERFORMED THE FOLLOWING:
. On line queries
. Customizing Master Records for Books and Members of Library
. Daily transaction
. Online alerts about the book status
Environment: UNIX, Oracle 6 (forms, V3 triggers, sql, pl/sql sql reports
and sql menus).
[pic] KPES English School, Performed the following:
. Managing master data for the staff members and Students
. Staff Payroll
. Student mark-sheet and Certification
. Maintaining records of student about their sporting event or cultural
activities
Environment: Development of software using 'c', Ms/dos and windows.
[pic] KPES English School, Performed the following:
. Managing daily transaction
. Connecting and checking student master data for each transaction
. Managing master books records
. Generating reports and memos
Environment: Software Development using 'c', Ms/dos and windows.
[pic] Indian Airlines branch office, Performed the following:
. Online status of the craft to be boarded
. Daily reports
. Reservation and conformation
. Maintaining customer records
Environment: Software Development Using FoxPro 2.5, Ms/dos and windows.