SUMMARY

• Expertise in System design and development required for business process
• Experience in Project Management, Business Analysis, Business Modeling, and Data Modeling.
• Excellent skills and experience in doing documentation on business requirements.
• Apply proven oral and written communication, analytical and problem - solving skills to help maximize the benefit of Information Technology system investments.
• Strong knowledge of business application and ability to apply principles around Requisition, Purchase Order, Requisition Self Service.
• In-depth understanding of the functional transactions and system interface.
• Experience in working with various tools like OOD Visual Basic which is used for requirements gatherings in business.
• Experience working in Waterfall/ Agile environment.
• Excellent analytical and negotiation skills.
• Good knowledge of SDLC methodologies.
• Knowledge and experience working in various domains.
• Quick learning and strong multi-tasking capability.
• Strong organizational and managerial capability.
• Excellent presentation skills.
• Good ETL, DBMS, SSIS, SSAS skills; Good Programming skills.
• Responsible and dependable team player, effective and reliable leader.
• Presented seven research papers in National and International Seminars.

TECHNICAL SKILLS

Databases: SQL Server (SQL Query, Database design), MySQL, MS-Access, ETL & Data Warehousing (SSIS, SSAS)

Programming Languages: C#.NET, ASP.NET, VB.NET

Scripting Languages: Java Script

Reporting Tools: Crystal Reports, SSRS

Defect Tracking: Test Director 8.x

Testing Tools: WinRunner, LoadRunner, Quick Test Pro (QTP)

Operating Systems: LINUX, Windows

Software Packages: MS-Project, MS-Word, MS-PowerPoint, MS-Excel and MS-Outlook, MS-Visio, Rational Rose

Web development: HTML, CSS, Dreamweaver, MS- Paint, Adobe Photoshop

Web Server: IIS

PROFESSIONAL EXPERIENCE

Confidential, Baton Rouge, Louisiana

Business Analyst/Project Manager

Responsibilities:

• Provided IT support activities to the operations in the department of Computer Science in support of B2B, Telecommunication orders.
• Developed project plans and assumed responsibility for project profit and loss.
• Monitored project activities and advised staff of issues due to resource availability.
• Responsible for procurement supply
• Facilitated the development of skills across the broader procurement team through a partnership with stakeholders- providing, supporting problem-solving and influencing process best practices.
• Developed the business case with emphasis on NPV, IRR and ROI.
• Managed cost budget to allocate overall cost estimate to individual tasks.
• Designed and presented presentations regarding projects and their requirements to a wide range of audiences.
• Managed the coordination of development of the data structures, transformation and data loading.
• Provided resources in the risk identification, project scope definition and methodology of the project.
• Produced project status reports, managed the team and resolved day-to-day issues with emphasis on SDLC.
• Defined and articulated business processes, performed analysis on various aspects of the supply chain.
• Evaluated vendors and potential supply chain partners.
• Researched industry best practices, participated in meetings, and communicated supply chain management goals to cross-functional teams.
• Conducted JAD sessions for effective communication of views between suppliers and the department to gather business requirements.
• Communicated and interacted on a regular basis with the stakeholders and development team during different stages of the product life cycle.
• Ensured that all the artifacts are in compliance with corporate SDLC Policies and guidelines.
• Prepared BRD and converted into functional specifications using requirement management tool.
• Created UML diagrams such as use case diagrams, activity diagrams, and sequence diagrams.
• Designed Data Flow Diagrams (DFD’s), Entity Relationship Diagrams (ERD’s), and web page mock ups.
• Prepared Business Process Models that depicted modeling of all the activities of the supply chain from the conceptual to procedural level.
• Prepared and maintained Risk Register to assess project risks.
• Used prototypes to demonstrate and verify the behavior of the system.
• Published documentation including: project charter, project plan, risk assessment, high level business requirement, use cases detailed requirements, workflow diagrams and output requirements.

Environment: MS Office, MS Visio, C#.NET, ASP.NET JavaScript, HTML, DHTML, MS SQL Server

Confidential

Business Analyst

Responsibilities:

• Gathered requirements and data for the project and made a detailed analysis.
• Conducted JAD sessions with development team and stakeholders.
• Analyzed daily behavior of these pollutants using methods like Association Rule, Clustering, Logistic Regression etc. in SQL Server analysis services (SSAS).
• Formatted the raw data in various steps in MS excel.
• Exported them to SQL Server 2008.
• Executed various SQL queries to make the data usable for SSAS.
• Found that all techniques have similar trends of behavior of all air pollutants over a certain period of time.
• Prepared reports using SSRS.

Environment: SQL Server, SQL Server Analysis Services (SSAS), MS Visual Studio, MS Excel, Import and Export data (32 bit).

Confidential

Business Intelligence Developer

Responsibilities:

• Set up an SSIS package that both initially and then incrementally populates a data warehouse staging database that has a relational star schema design.
• Designed cubes to analyze the data.

Environment: SQL Server, SSIS, SSAS, SSRS, MS Visual Studio.

Confidential

Business Analyst

Responsibilities:

• Analyzed user needs within a functional Business Process to determine functional requirements.
• Facilitated JAD sessions, introduced use cases into application development methodology and created client approval process for project methodology.
• Aligned requirement documentation with use of UML for object oriented software development.
• Created ensuing use cases, report requirements/templates, scope documents, issue tracking and project plans.
• Established as client/vendor liaison throughout plan, analyze and design phase.
• Developed Crystal Reports.

Environment: Rational Rose, MS Office Suite, MS Visio, JAVA, J2EE, JavaScript, HTML, DHTML, MS SQL Server

Confidential

Consulting - Business Analyst/Project Lead

Responsibilities:

• Analyzed and planned business projects.
• Prepared system requirements documents after interacting with wholesalers and retailers.
• Identified relationships between the various functional requirements.
• Created quantitative and statistical business models by using MS Excel data analysis program, statistical and financial functions.
• These models include budgeting, customer buying frequency and scheduling.
• Recommended software and systems to achieve company’s business requirements.

Environment: MS Office, MS Visio, Java Script, HTML, DHTML, C#.NET, ASP.NET, MS Visual Studio, SQL Server

Confidential

Project Leader/ Business Analyst

Responsibilities:

• Planned and prepared workshop schedules for every semester.
• Conducted trainers’ at the beginning of every semester and conducted weekly mentor meetings.
• Conducted mid-semester and end-of semester trainer’s evaluations and redesigned programs for the next semester after researching these evaluations.
• Interacted with students, professors, tutors and other clients to gather requirements.
• Conducted workshops and also assisted a few Special Request Workshops.
• Created process documents, reporting specs and templates, material and slideshow presentations for Budget Management for the monthly, quarterly and annual budget processes.
• Drafted and edited press releases for the START program, prepared and designed advertising materials for the print and other media.
• Conducted Table-sits to advertise the START program.
• Presented the work done by START to LSU professors and directors.
• Designed and prepared modules and presentations using MS-Word, MS-Excel, MS-Powerpoint.
• Entered and updated data into START database using Lotus Notes.
• Reviewed technical materials to be taught at the START workshops.
• Updated START website.
• Represented START at various events.

Environment: MS Visual Studio, MS Visio, Rational Rose, Photoshop, Flash, End Note, VB.NET, ASP.NET, MS SQL Server, IIS, Windows.

Confidential

.NET Developer

Responsibilities:

• Developed web forms using C#.NET and ASP.NET
• Displayed the search result.
• Designed the SQL Server Database, created tables, queries.
• Developed Crystal Reports for the project.

Environment: C#.NET, ASP.NET, MS Visual Studio, SQL Server, HTML, CSS, Dreamweaver, IIS Web Server.

Confidential

Project Leader/ Business Analyst

Responsibilities:

• Managed the project, defined the methodology structure and the process for developing it.
• Analyzed current work practices, led facilitated sessions and coordinated production of the deliverables.
• Analyzed client’s requirements and developed project strategy and implementation plans.
• Developed the format of proposals.
• Risk assessment and resolution.
• Reviewed and assisted in development of Use Cases.
• Provided clarifications to the development team throughout the development process.
• Conducted unit testing at the desktop environment, log results and sign-off.
• Coordinated and provided procedural support for User Acceptance Testing (UAT).
• Conducted Technical Reviews with the development team.
• Ensured compliance with government rules and regulations.
• Responsible for planning, staffing and mentoring of new Business Analyst.
• Conducted weekly team meetings and prepared weekly Status Reports.

Environment: MS Office, MS Visio, MS Project, C#.NET, ASP.NET, MS Visual Studio, SQL Server, Java Script.

Confidential

Business Analyst

Responsibilities:

• Conducted user interviews to define banking system business requirements.
• Determined gaps between functional specification documents and vendor software. Provided recommended changes to workflow process.
• Worked with a diverse group of stakeholders who had differing views on the scope and objectives of proposed systems enhancements.
• Documented requirements specifications in accordance with program and the bank’s standard operating procedures.
• Performed functional allocation to validate that required tasks map to Government regulations and standards.
• Managed projects to improve system process.
• Worked with the programmers and other system experts.
• Designed databases for maintaining customer records, interest, loan records, payment dues etc.
• Translated requirements/objectives, data import procedures and mapping to developers.
• Developed test cases, scenarios, scripts and expected results in accordance with QA accounting functionality, operational reporting and client statement generation. Recommended and define system enhancements.

Environment: MS Visual Studio, MS Visio, VB.NET, ASP.NET, MS SQL Server, IIS, Windows.

Confidential

Junior Developer

Responsibilities:

• Developed database system for recording and maintaining their daily transactions.
• This involved maintaining records of stock, inventory, daily supply, revenues, placing new orders when stock get over, restocking according to the expiry dates of medicines.
• Also included customer databases, such as their names, addresses, contact numbers, purchase items, frequency of purchase, payments, balance amount, payment dates and such other details.

Environment: MS Office, MS Visio, MS Project, C#.NET, ASP.NET, MS Visual Studio, SQL Server, Java Script, HTML, DHTML.

Confidential

Marketing Research and Business Development Manager

Responsibilities:

• Conducted market analysis and research to determine market trends and competitor product and strategy analysis.
• Designed and implemented marketing strategies for the company.
• Marketed company’s product in the region.
• Projected sales and gap analysis.
• Trained sales team and imparted product knowledge.

Confidential

Business Development and Customer Service Manager

Responsibilities:

• Launched company's operations in the city and set up office infrastructure, selected and supervised tele-marketing executives, assigned tasks, set targets, analyzed daily reports, conducted interviews, identified target customers, acted as contact person between sales team and headquarters in Mumbai, coordinated after sales services, estimated costs, budgeting, maintained database of customers using MS-Access.
• Analyzed, defined, documented and communicated business requirements and solutions to meet business partners’ needs for the new branch.
• Coordinated communications to and from the headquarters.
• Coordinated/Participated in the testing of the business requirements.
• Coordinated/Participated in the validation of the data about the new customers in the new branch.
• Coordinated/Participated in the development and deployment of on the FDM to team members and Business Partners.
• Responsible for coordinating, tracking and updating project issues, risks and change controls.
• Collection Performance: Devised a collection strategy, suitable for clients in our region. This strategy helped in maintaining consistent collections during the entire period of my service. Increased baseline monthly collections from Rs.4,75,000 to Rs.7,00,000.
• It also helped in boosting sales as the payment strategy devised by me attracted more customers.

Environment: MS Access, MS Excel, MS Word, MS Powerpoint, Tally.