SUMMARY:

• Around 5 years of experience in multiple roles such as Business/Data Analyst and also a module lead in a Service Delivery Project.
• Experience with diverse industry verticals such as retail, life science, and service
• Experience in analyzing business requirements and creating Business Requirement Document.
• Experience in gathering requirements from business stakeholders by conducting interviews, defining the business processes and working on process improvements.
• Experience in analyzing the business processes and implementation of business process improvements
• Experience working in different SDLC cycles including waterfall model and agile methodology
• Experience in writing SQL queries to pull reports from Oracle database, writing stored procedures and functions to maintain the data quality in the database
• Experience in tracking tools such as BMC Remedy IT Service Management, and Serena Team Track
• Experience in team and resource management
• Extensive knowledge in content management systems such as SharePoint and its workflow architecture.
• Excellent in verbal and written communications, with excellent organizational skills both as an individual as well as a team contributor

SKILLS:

Database : Oracle 11g, PL/SQL

Database Tool : Toad for Oracle, MS SQL Management Server

Business Process Management : Microsoft Visio

Content Management : MS Office SharePoint 2007 2010 , MS SharePoint designer

Microsoft Office Suite : Word, Excel, PowerPoint, Project, Access, InfoPath, Outlook

Tracking Tool : BMC Remedy IT Service Management, Serena Team Track

Data Visualization : IBM Cognos, Qlikview

Statistical Analysis : IBM SPSS Statistics, IBM SPSS Modeler, R Programming

PROFESSIONAL EXPERIENCE:

MONSANTO COMPANY

Confidential

BUSINESS ANALYST

• Worked with business users, gather their requirements and developed complex SQL queries to generate reports from Oracle database for the business team that facilitates better understanding of the customer profile
• Managed jobs using Autosys job schedules in UNIX environment.
• Conducted interviews with stakeholders across the team to document the business processes with the help of Microsoft Office Visio to keep the business and technical documents up to date
• Implemented an initiative to improve the usability of media files in business documents that resulted in 90 time savings
• Addressed ah-hoc requests from business stakeholders that involved tasks ranging from data analysis and report generation to backend testing of data to adhere to the business standards
• Implemented data cleansing solutions in the database with the help of regular expressions to maintain the data quality in the database system by writing SQL queries
• Logged and tracked data management requests using the Serena Team Track tool

Environment: Oracle 11g, PL/SQL, Toad for Oracle, Microsoft Visio, MS SharePoint 2010, MS Office Suite Word, Powerpoint, Excel, Outlook , BMC Remedy IT Service Management, Serena Team Track, UNIX, Autosys Job Schedules, Nintex Workflows, Qlikview, MS Access

Confidential

GRADUATE ASSISTANT

• Analyzed the logistics data of a Fortune 500 pharmaceutical company using IBM Cognos Insight and provided insights on logistic issues and recommendations for overcoming them.

Environment: MS SQL Management Server, MS Office Suite, MS Project 2010, MS SharePoint 2010, IBM Cognos Insight, IBM SPSS Statistics, IBM SPSS Modeler

Confidential

SYSTEMS ENGINEER

• Performed multiple roles as a module leader and maintenance Business Analyst. Collaborated with Product and Production manager on business requirements for the employee portal SharePoint site and coordinated with the team of 13 members that managed 1500 SharePoint sites
• Gathered requirements from product owners to identify business issues, categorized under different priority levels and formulated solutions to enhance the business process
• Organized meetings with the development and maintenance teams to evaluate the feasibility of the proposed solution and come up with an estimate for the deliverables
• Prepared the business requirements documents and maintained them in SharePoint repository
• Developed custom workflow Auto Acknowledgement System that saved 240 person hours, eliminating the need for additional staffing
• Devised an issue resolution database by analyzing issue inflow and team performance metrics, which reduced customer complaints by 20 and increased client satisfaction to 95 a raise of 3.5 from previous year
• Initiated the creation of value additions for process improvement e.g. Monitor Portal Outage and customer satisfaction e.g. Content Approval Workflow that decreased respective lead time by 25
• Performed as a Technology Innovation Lead at account level with a headcount of 84 members to experiment on synergy outcomes
• Improved the response time of medical emergency service in the company at organization level by reforming the three stage approval process to single stage process

Environment: MS Office SharePoint Server 2007, MS SharePoint 2010, MS SharePoint designer 2010, MS Office Suite, BMC Remedy IT Service Management, MS InfoPath 2010, SharePoint integration with other office utilities