Jayanthi Camillus
Job Related Summary
*+Years of experience in Business Analysis, Reporting Analysis, Testing and Documenting the Process requirement.
Experience with MS Excel and MS office and Visio
Excellent communication and interpersonal skills
Summary
Business Analysis and Reporting Analyst with over three years of successful experience in analyzing and auditing the data for audit purposes.
Worked as a liaison among the team members to understand the data from different sources in the context of requirements and recommend solutions that enable the organization to achieve its goal.
Review, analyze and evaluate the data from different sources
Generated Excel Reports to know monthly and weekly status of audit
Familiar with Excel pivot table and V-LOOK UP
Wrote detailed process requirements documents in one note
Coordinate user testing which allowed the project manager to focus on problems for successful audit
Set and meet deadlines
Worked under pressure to meet the deadlines
Handled multiple tasks
Good written and verbal communication skills.
Areas of Knowledge
Identify Customer Needs, User story development
Process improvement, Application Development Life Cycle
Quality Assurance, Research Analysis and Customer Service
System Development Life Cycle (SDLC)
Agile Methodology and Waterfall Methodology.
Presentation skills
Written and verbal communication
Research and analysis
Time management
Understand computer security, Network and Project Management knowledge
Knowledge of Business Intelligence and Data Warehouse.
Technical Skills
SAP BI/BW, Oracle 10g, SQL Server, ASP.net, MS Excel, MS Office, MS Project, Crystal Reports, Visio and Business Objects.
Education
Masters of Science in Information Technology, University Of Dallas, Irving, TX.
Bachelors of Science in Chemistry
Bachelors in Education
Member of Sigma Iota Epsilon, a National Honorary and Professional Management Honor Fraternity
Thesis – Business Intelligence for small business
Professional Experience:
Solutionstar/Lewisville
Feb2015-Current
Business Operations Analyst
Responsibilities
Created process maps for business operations using Visio for the organization to follow the policies and Procedures that reduced cost for the organization
Documented all the day to day business operations and created user guides for all the resources
Assisted Manager in business Operation functionalities to remove any redundancy in the procedures
Communicated with the departments to ensure that policies and procedures are followed and gave feedback to automate some process
Attended offshore meeting and supported their business operations
Adopted agile methodology for vendor management using .NET application developement
Microsoft/Irving
Jun2014– January2015
Business Analyst/ Reporting Analyst
Responsibilities
Audited and generated time entry reports for resources in Public Sector and World Wide
Reports generated every fiscal week for resources who worked More than 24 hours in a day or more than 16 hours three times in a week using Excel
Every week extracted data from PSR, JADE and MCS and exported to Excel
Created reports using SSRS tool. SSRS tool is used for filtering resources information for creating final reports
Created pivot table to summarize and to give more insight into data
Contacted resources and their managers in a polite way to check for any duplicate time entry or for any lost labor in their time entry
Checked the resources for time entry compliance to follow policies and procedures
Suggestion offered to resources to adjust their time entry or asked to provide business justification with managers approval
Checked the updated audit log for any change in the time entry while saving Money to Microsoft
Uploaded Excel file in the Dashboard for analysis for Management team to have overall idea of the time entry.
Involved in User Acceptance Testing to check and improve the audit log reports
Fiscal week auditing reduced the number of emails sent to the resources that reduced non-compliance time entry
Suggestion given to the management team for effective auditing to improve the time entry process
Mckesson/Fortworth
Dec2013- Feb2014
Business Analyst/ Reporting Analyst
Responsibilities
Worked closely with key business stakeholders and SMEs to understand the drivers for business and enables to achieve the strategic business goals through reporting process
Reviews, analyzes and evaluates business system and user needs.
Wrote detailed business requirements documents, program function, steps to modify computer programs, business processes and user test plans.
Act as a liaison and provide support for Business and IT projects. Support the defined project management processes and standards and assist with decision-making regarding business applications.
Adopted Agile methodologies for quick change in the software development with of involvement of customer and stakeholder to finish the project with high quality results
Coordinated user testing which allowed the Project Manager to focus on problems and implementation
Generated SQL queries using sql server for report developing
Used Excel to format the reports and used pivot table to categorize the data
Created end of month reports using EXCEL.
Created CRM reports using SAP/BW and adhoc reports using Business Objects
Worked with QA in testing each test cases
Lead requirement elicitation efforts on enterprise analysis projects including the elicitation and mapping of the AS-IS and TO-BE processes
Coordinate and facilitate meetings with clients to a gather and document requirements and explore potential solutions
Plans, designs and recommends business processes to improve and support business activities
Participate in preliminary cost/benefit assessment in an effort to align information technology solutions with business initiative.
Translate stakeholder requirements into various documentation deliverables such as functional specifications, use cases, user stories, workflow, process diagrams, data flow and data model diagrams.
Lewisville Independent School District
Aug 2006-2010May
Special Education Aide
Collaborated with the teachers to assist the kids in Math and Science
Helped the kids to learn in their way to improve their performance
Created study plans to match their learning skill
Participated with the kids in extracurricular activity to improve their all around personality
Lewisville Independent School District
Aug2005-May2006
Substituted all the schools in the district