Anand Bhat

Lead Test Engineer

Work History

Work History

Database Analyst

Mind Reach Consulting, Bangalore, India
Database Analyst(Remote Project) Aviva Insurance Responsibilities: Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions. Worked with Operating Business Management to outline Functional Requirement Specifications and System Requirement Specifications. Extract data from different source systems using Data Services tools. Performed Unit testing and module testing on developed web forms and custom classes Environment: SQL, T-SQL, HTML, SQL Server. NON-RELEVANT EXPERIENCE

Report Analyst

Stefanini Inc
BI Report Analyst(Covance Project)  Worked with Operating Business Management to outline Functional Requirement Specifications and System Requirement Specifications.  Worked with Business Objects Data view and Info view to generate reports in order to propose Process improvements to upper management.  Developed Data Models in Universe Designer to be used downstream by WEBI and Desktop Intelligence.  Developed ad hoc reports using WEBI. Developed complex reports using Desktop Intelligence.  Extensively used MS Excel in order to create visual representations of KPI and CPI performance.  Migration from BOXI 3.1 to BOXI 4.0 to create multi source connections in the universe. |  Extensive use of I.T Central Service to generate reports, create dynamic dashboards and customized gauges. Met with senior Project Managers to build customized reporting for teams in Manila, Bucharest and Jilin.  Used Excel to create Mockups and Spec doc templates based on the Business requirements.  Used Excel to perform Three Point Validations involving the Input data source such as csv and Access with the ETL workflows and a final validation with the Generated Reports.  Interacted and closely worked with Stefanini teams in 5 different countries and trained User Administration teams in reporting on I.T Central Service. Environment: SAP Business Objects 4.0, MS Excel 2013, I.T Central Service, Windows 7/8
Oct 2014 - Present

Qc Engineer

Maximus Inc
Albany, NY QA/QC Engineer New York State of Health Project  Developed test plans, test cases, test scripts and test reports on multiple projects of varying size.  Performed testing on various software, telecom and reporting systems.  Validated that user expectations are achieved during the testing process.  Reviewed user requirements documents to ensure that requirements are testable.  Tested on CRM applications like Siebel CRM to ensure that the system works as per business expectations.  Created full workflows of various testing modules as a means of knowledge transfer for new team members.  Processed paper applications through applications like KOFAX Batch Manager Analyzed, interpreted and helped modify SRDs to ensure compliance with business requirements. Creation of complex, multi layered testing scenarios and their test execution using software like ALM Creation of defect tickets and their retesting in various environments Three point testing by using custom SQL queries to perform joins and other operations on the backend to slice and dice through data in a manner that enables thorough testing. Comparison of backend, front end and if available data warehouse with the BRD, SRD and Software design documentation was frequently performed as part of end to end testing. Creation of regression test suites to ensure that new implementation did not break any existing functionality. Training colleagues in improving the documentation process and analyzing requirements. Creation of dynamic HTML based presentations to showcase testing techniques and strategies to various corporate stakeholders. Creation of handoff reports to other testing teams to document defects found and other relevant information to ensure seamless transitioning during the SDLC process. Environment: MAXe, Siebel CRM, KOFAX, MS Excel 2013, KOFAX, Windows 7/8
Dec 2013 - Jun 2014

Business Process Improvement Analyst

Stefanini Inc
Southfield, MI Business Process Improvement Analyst
Jun 2013 - Dec 2013

Strategy Bi Consultant

Maximus Inc
Austin, TX Micro Strategy BI Consultant(MaxDat)  Contact Center Agent Efficiency Reports/Data Modeling and Contact Center Production Planning.  Worked on a three man developer team to architect and develop reports and dashboards for MaxDat project.  Experience on Data validation, Data merging, Data cleansing and Data aggregation activities.  Created multilayered Dynamic Enterprise Dashboards using panels, panel selectors, widgets and grids using multiple datasets  Created Freeform SQL ad hoc reports.  Designed Components, Templates and Filters to generate reports in grid/graph mode.  Worked on troubleshooting non-data returning reports and dashboards.  Used VLDB Properties to enhance the performance and retrieval time.  Involved in migrating from Microstrategy 9.2. 1m to 9.3  Created ad hoc reports without mapping documents by analyzing the Data model. Environment: Micro Strategy 9. 3/9.2. 1(Architect, Desktop, Command Manager, Object Manager, Narrowcast Server, Enterprise Manager) Oracle 9i, 10g, SQL Server.
Dec 2012 - Jun 2013

Strategy Bi Consultant

Reliable Software
Novi, MI Micro Strategy BI Consultant(MaxDat)  Creation of test projects from scratch, including creation of metrics and attributes, data modelling, ER mapping etc.  Experience on Data validation, Data merging, Data cleansing and Data aggregation activities.  Created multilayered Dynamic Enterprise Dashboards using panels, panel selectors, widgets and grids using multiple datasets  Created Freeform SQL ad hoc reports.  Designed Components, Templates and Filters to generate reports in grid/graph mode.  Worked on troubleshooting non-data returning reports and dashboards.  Used VLDB Properties to enhance the performance and retrieval time.  Involved in migrating from Microstrategy 9.2. 1m to 9.3  Created ad hoc reports without mapping documents by analyzing the Data model. Environment: Micro Strategy 9. 3/9.2. 1(Architect, Desktop, Command Manager, Object Manager, Narrowcast Server, Enterprise Manager) Oracle 9i, 10g, SQL Server.
Jun 2012 - Dec 2012

I.T Consultant, Bpi Specialist

Mind Reach Consulting, Bangalore, India
Aug 2010 - May 2012

Student Ambassador

University of Illinois
Student Ambassador,, Springfield, IL Student Ambassador,, Normal, IL May2009-May2010 Conduct campus tours and market the school to potential students and their parents. Collect and enter student information in a University database and update as necessary Answer questions that students and parents may have in dedicated personal and group forums Send personalized communications to students in order to build a professional relationship with them and to provide a differential to the marketing strategies of the school. Assist in office activities by providing administrative support. Conduct telephonic outreach efforts to potential students and answer all questions. Visit various colleges and schools to assist with recruitment and marketing efforts.
Jun 2007 - Jun 2008

Human Resource Consultant

Opus Dei Consultancy
Human Resource Consultant, Bangalore, India  Sourcing suitable candidates via networking, advertising and referrals.  Maintaining candidate networks.  Providing resume, interview and career advice to candidates.  Interviewing candidates on a general basis and for specific roles.  Managing the job offer process and negotiating salary packages.  Maintaining market and commercial awareness through research and networking.  Developing and managing ongoing client relationships-both on the phone and face to face. LANGUAGES Language Proficiency English Native Speaker/Expert Kannada Native Speaker Hindi/Urdu Native Speaker Tulu Native Speaker Tamil Working Proficiency Telugu Intermediate Spanish Elementary.

Education

Education

M.Sc

Heartland College

B.Mngt

University of Illinois

B.B.A

University of Illinois