Summary
Overview
Work History
Education
Skills
Timeline
Generic

Sindhura Illindala

Holly Springs

Summary

Professional with significant experience in business analysis, skilled in data-driven decision-making, and process optimization. Strong focus on team collaboration and delivering impactful results. Reliable in adapting to changing needs while leveraging skills in stakeholder management, requirement gathering, and strategic planning. Recognized for analytical thinking, problem-solving abilities, and effective communication.

Overview

16
16
years of professional experience

Work History

Systems/Senior Business Analyst

Leidos Inc.
07.2013 - Current
  • Company Overview: National Dataware House Contract with CMS
  • Testing on Various components of NDW on various needs with extensive usage of Dashboards, Reports for Customers
  • Maintaining the ASIS(Existing Databases),Enhancements and incorporating the new technologies, like Cloud services (AWS),Bigdata and on-Par with the Data ware Housing Standards
  • Experience collaborating with procurement professionals on requests for proposals
  • Reviewing and Understanding Business/Functional Requirement to understand the data architecture, data warehousing, data querying, data manipulation, data analysis, reporting, system administration
  • Develop, Document, Maintain Business Standards and Documentations
  • Working with developers and architects to document periodical flows for successful project implementation
  • Extensive testing and understanding AWS migration and Glue concepts
  • Data received from Different sources are Designed and Processed thru Airflow tool
  • Thorough understanding on moving different source files to s3 bucket,Update the parameters and process the loads accordingly
  • Extensive understanding and Learning of SQL queries building based on Business Mapping Document
  • Extensive knowledge on Cloud concepts and PowerBI/Microstrategy/Pivot reports
  • Converting high level business requirements into technical requirements for developers
  • Extensive experience on Oracle Sql scripts for adhoc queries business needs
  • Execute, Track, and Report on the Test Plans and Cases
  • Analyze Results and Communicate Status to other team members
  • Conduct Peer Reviews and Walkthroughs
  • Involved in multiple roles as per the project needs
  • Followed Agile and Waterfall models for successful project implementation
  • Extensive understanding of the client needs for a successful project deliverables
  • Excellent communication skills
  • Used Quality center for Creating, maintaining defects and Test cases
  • Develop, and Maintain Project Plans and Timelines
  • Mentor, Coach and Guide Team Members
  • Extensive usage of SQL for Data validation purposes
  • Understanding Python scripts and reviewing the error logs with the developers to resolve the issue
  • Extensive usage of bigdata procedures for loading and data comparison
  • Written Minus Queries (Source ->target and Vice versa) for complete Data validation purposes as part of UAT testing
  • Following Standard documents as Specified by NDW for efficient testing
  • Worked on Different Dashboard testing using Micro strategy
  • Worked on Different subject areas of Reports internal to NDW
  • Actively participated in the Team building process
  • Creating Standards and guidelines for model and DDL Creations as part of technical specification document
  • Participated in Cloud migration and extensive testing
  • New code Deployments, loads, Extensive usage of Repository, Workflows and monitor for testing purposes
  • Conducting peer reviews on Unit test cases, test scripts, SQL queries and validation artifacts
  • Presentations, Hand off meeting, Brown bag meeting and review analysis are documented
  • Meeting minutes, daily status report, weekly reports and performance review are recorded and maintained timely manner
  • Validating Micro Strategy Grid Reports, Visual Crossing Dashboards and Cube reports on Cosmetic, Functional, Data and Security
  • Performing Cross Tabs, Master Detail and Formulas, Slice and Dice, Drill Down, variables, filters, conditions, breaks, sorting, Functions, Alerts, Cascading Prompts and User Defined Object
  • Writing SQL queries referring business requirements and comparing the reports
  • Performing Load and stress testing by selecting multiple dates and prompts
  • Developing Queries for DDL and DML validation
  • Verifying the mapped use cases in ERWIN
  • Deployment and Implementation of SQL scripts and raise a defect in any errors
  • Developing column to column complex Oracle SQL queries for the give logic for designated tables
  • Performing quality check and error by writing minus queries, case logics, inline views and sub queries
  • If needed mock the data as per requirement
  • Business Requirements analysis step by step
  • Design documents and table structure analysis
  • Validating the performance of data load in Informatica ETL tool
  • Designing and developing test strategy and test plans
  • Developing Test scripts to ensure and find the code changes
  • Test cases for each phase of validation like requirements, design, data warehouse and reports
  • Test planning and Approach is a much before a major releases to keep track on validation
  • Identifying the errors based on the log files generated while executing the scripts and reporting errors as bugs in HP Quality center
  • Preparation of Test Scenarios Document to be covered for Different Releases for efficient testing and output
  • Documenting modifications and Enhancements made to the data warehouses as required
  • Testing of the entire process including reports and back-end data validation
  • Perform regression testing after closing the defects or new build after fix
  • Involved in High end testing, system testing, Integration, Security ,smoke testing and supporting UAT
  • Maintaining the high secured standards of data security as per company's policy
  • Coordinated with developers regarding bug fixing
  • Active team player and Provided testing status to the team lead on a daily basis before the meetings
  • National Dataware House Contract with CMS
  • Testing on Various components of NDW on various needs with extensive usage of Dashboards, Reports for Customers
  • Maintaining the ASIS(Existing Databases),Enhancements and incorporating the new technologies, like Cloud services (AWS),Bigdata and on-Par with the Data ware Housing Standards
  • Environment: Glue,Airflows,MS Access 2000, Visio,Oracle 13.3,Redshit,AWS,Bigdata, Informatica,MS SQL server 2008,XML, XQuery, XPath,Hadoop,Python script,Hue, XML SPY tool for XML, ASP.NET, ADO.NET, SSIS ,JSON2005,COGNOS8Windows XP, IIS 5.1/6.0, HTM

Sr. Functional Analyst

Constellation Energy
11.2012 - 06.2013
  • Company Overview: Project comprises of doing enhancements to an existing product and building, testing new Packages and report in the COG infrastructure for this engagement
  • Within the Commercial IT Wholesale organization and the Finance and Risk Mgmt team, will maintain, support testing various Wholesale Finance PL/SQL business unit applications
  • This is Related to Trading and valuation of finance/trading data
  • The primary duties consist of testing of new Wholesale Finance business unit applications
  • Involved in full length of SDLC process
  • Used Informatica as an ETL Tool for Developing the Data Warehouse
  • Testing on SSIS Reports
  • Usage of Single sign on web with Micro strategy reports
  • Designed Reports using Microstrategy reports for access via mobile devices
  • Involved in one of the prestigious project of constellation and exelon after it's merge which involves trading data of both counter parties with successful integration of data via different sources
  • Worked with the components of Data Warehousing like components model, ETL tools
  • Responsible for the verification of the functionality of the Application on various Browsers and its Compatibility on Internet Explorer and Netscape Navigator and the different versions of the Web Browsers predominantly used in all business application environment
  • Understanding and testing on SSIS packages
  • Assisted BI Developers to fetch reports using cognos
  • Used Excel for updating the status of all the test cases & test scripts that are executed during testing process
  • Experience Developing and testing on XML documents
  • Worked with Data Warehousing developers and Oracle Developers who extensively used SSIS/ETL tools to design mapping to move data from source to target database using Stages to do the functionality
  • In order to provide scalable and robust data extraction processes, Business Intelligence team will use Informatica Power center tool to extract data
  • Testing of the entire process including reports and back-end data validation
  • Perform regression testing after closing the defects or new build after fix
  • Record and run tests using QTP
  • Involved in User Acceptance Testing, Usability testing
  • Involved in UI testing
  • Participate in test plan and test cases review meetings
  • Performed backend testing using SQL queries to check backend data and data integrity
  • Use some of the basic commands while testing UNIX
  • Perform and validate positive, negative, system and integration testing
  • Preparing Daily Execution Report – Involved in preparing the Daily Execution Status report and sharing with managers and leads
  • Weekly Status Report – Involved in preparing the Daily Execution Status report and sharing with the project manager and lead
  • Interactions with Business analyst, Program managers, Software developers for bug reviews and participated in QA meetings
  • Lead testing effort with Business users, customers and Offshore QA teams
  • Creating technical Documentation and Updating the functional documents
  • Involved in High end testing, system testing, Integration, confidence, smoke testing and supporting UAT
  • Active Participation in database testing using SQL scripts both oracle and Sql server
  • Developed and Maintained QA test cases
  • User load runner for load testing
  • Creating and migrating all the scripts to UAT and Production
  • Creating SQL Scripts for testcases
  • Strong technical knowledge of Oracle SQL and PLSQL supporting and enhancing large database environments in Oracle 10g and 11g
  • Functional knowledge of the Finance business
  • Support of multiple application instances that facilitates release management and testing in a structured, process driven environment
  • Involved in Production support and solving high risk issues
  • Maintaining the high secured standards of data security as per company's policy
  • Usage of CVS to maintain the versioning control
  • Involved in Production bug fixing
  • Tested the functionality of each screen to monitor proper navigation
  • Front-end testing done on different link and hyperlink verification and validation of the application
  • Updated defects using Excel reports
  • Coordinated with developers regarding bug fixing
  • Project comprises of doing enhancements to an existing product and building, testing new Packages and report in the COG infrastructure for this engagement
  • Within the Commercial IT Wholesale organization and the Finance and Risk Mgmt team, will maintain, support testing various Wholesale Finance PL/SQL business unit applications
  • This is Related to Trading and valuation of finance/trading data
  • Environment: MS Access 2000, Oracle 11g, Informatica, MS SQL server 2008, XML, XQuery, XPath, XML SPY tool for XML, ASP.NET, ADO.NET, SSIS 2005, COGNOS8 Windows XP, IIS 5.1/6.0, HTML

Sr.GIS/Quality Analyst

State High Way Administration(SHA)
03.2012 - 11.2012
  • Company Overview: The Asset Data warehouse stores all the Assets owned by the state, this data has to be aggregated, standardized and made ready for graphical display using GIS mapping
  • The project involves creation, Testing, review & data management of lighting, guardrail & Signs GPS data, collected for Asset Data Warehouse
  • Analyzing business requirements and developing specifications in order to create and execute test plans
  • Preparation of Test cases using A&D document, SoBR Document and Process flow documents
  • Utilized SSIS to produce a DW house for reporting
  • Involvement with automation of successful code to production
  • Review and understand the ETL processes, Functionality & identify test requirements and coverage
  • Used Informatica as an ETL Tool for Developing the Data Warehouse
  • Develop parameter driven ETL process to map source systems to target data warehouse with Informatica complete source system profiling
  • Designing and developing test strategy and test plans
  • Testing XML Documents
  • Active Participation in database testing using SQL scripts both oracle and Sql server
  • Developed and Maintained QA test cases
  • Wrote shell scripts to run PL/SQL programs and job scheduling
  • Provided design and implementation of formal software quality assurance processes and methodologies, including integration with overall development processes
  • Functionality, compatibility, reliability, performance, security and related testing of a variety of web-based applications, from static web sites to complex interactive web applications incorporating multiple front and back end database/web/internet technologies
  • Application design and testing for web-based bug tracking system
  • Developing test cases for functional, regression, Integration, End- To- End and System testing
  • Creating Test cases in MS- Word and later uploading those in Quality Center 9.0- Mercury Test Director
  • Debug/coding any procedures and packages as required by the developers
  • Converting non-spatial data into spatial, using the Arc Map
  • Responsible for writing SQL queries
  • Extensive use of Egis and Arcmaps
  • Testing of the entire process including reports and back-end data validation
  • Perform regression testing after closing the defects or new build after fix
  • Record and run tests using QTP
  • Involved in User Acceptance Testing, Usability testing
  • Involved in UI testing
  • Participate in test plan and test cases review meetings
  • Performed backend testing using SQL queries to check backend data and data integrity
  • Use some of the basic commands while testing UNIX
  • Perform and validate positive, negative, system and integration testing
  • Preparing Daily Execution Report – Involved in preparing the Daily Execution Status report and sharing with managers and leads
  • Weekly Status Report – Involved in preparing the Daily Execution Status report and sharing with the project manager and lead
  • Loaded data to different databases using SQL scripts and maintained a repository for data loading scripts
  • Generated manual scripts and responsible for executing and bug tracking
  • Used UNIX Shell Scripts and Perl Scripts to assist in QA testing
  • Developed SQL Queries and Procedures to perform database testing
  • Performing End- to - End test by analysis of different software applications and operating system by checking Log files, client specification applications, XMLs and Oracle DB
  • Responsibilities include acceptance testing, functional testing, Integration testing, System testing, performance testing
  • Modified Configuration file according to space constraints
  • Xml Coding and Testing
  • Worked on SSRS reports
  • Tracking defects and updating them on daily status check point by using Performance Metrics tool
  • Involved in analyzing and creating Periodic Status Reports
  • Interacting with development and QA teams to ensure overall quality of the software application
  • The Asset Data warehouse stores all the Assets owned by the state, this data has to be aggregated, standardized and made ready for graphical display using GIS mapping
  • The project involves creation, Testing, review & data management of lighting, guardrail & Signs GPS data, collected for Asset Data Warehouse
  • Environment: Java, Web Logic, Oracle10g,11g, SQL Server 2005, Unix, XML, Oracle SQL developer, SQL Loader, Mercury Quality Center- Test Director 9.0, CBE Web Query, SSIS 2005, Winscp3, BOD Utility, Altova XML Spy 2007, Load runner, Perl, Notepad ++, Web Log 7.3, Production Support Tool (PST), Performance Metrics Tool, INFORMATICA

Data/functional Analyst

Tyco Electronics
10.2009 - 01.2012
  • Company Overview: Pdmlink system to get all three Intralink instances on to one system
  • Involves Dataware house picks all the CAD files, Shortly called as TE-global
  • This capable of maintaining all CAD & CAM files implementation
  • Considered as highly risk and prestigious project of PTC
  • Involved with Business Analysts (BAs) and Configuration Subject Matter Experts (SMEs) to create Test Cases/Scenarios, Test Steps, Expected Results and Test Data in Test Director
  • Test Cases for each of the available data forms were regression tested as new functionality was added; loading Win Runner scripts in Test Director for batch testing
  • Providing Future Estimations of Database sizes and flow of files in to DW housing Database Down the line for 10years
  • Having used SQL server 2005 SSIS transformations in the data flow of data to package to aggregate, merge and modify data
  • Responsibilities include acceptance testing, functional testing, Integration testing, System testing, performance testing
  • Developed common reusable libraries of Win Runner 6.0
  • Designed standards for data driven testing architecture using XLS files and parameterized test scripts based on ID of data form for 2000 records
  • GUI & Text Checkpoints and Synchronization statements used extensively to validate correct ID entry or search criteria for information to be displayed
  • Developed SQL Queries and Procedures to perform database testing
  • Managed, Documented and Controlled all the Test Scenarios, Test Cases, Test Steps and Expected results in Quality Center
  • Wrote Test Scripts and SQL/PL/SQL scripts to conduct Database Testing
  • Analyzed, reported and keep track of defects using Quality center
  • Maintained Bug reports in the Defects module of Quality Center
  • Provide daily and weekly defects status summary for overall project
  • Provided testing status to the team lead on a daily basis before the meetings
  • Participated in strategy and status meetings to report issues
  • Communicating developers, data team, and functional and business concerns about all phases of testing prioritize bugs resolution
  • Documented and reported the defects and interacted with developers to follow up on Defects/Issues
  • Used clear quest for defect tracking, coordinated the defect resolution process and generated management reports
  • Recorded, parameterized and enhanced Vuser scripts to simulate the critical business transactions
  • Pdmlink system to get all three Intralink instances on to one system
  • Involves Dataware house picks all the CAD files, Shortly called as TE-global
  • This capable of maintaining all CAD & CAM files implementation
  • Considered as highly risk and prestigious project of PTC
  • Environment: Oracle 9i,10g, Oracle SQL Loader, Import/Export Utilities, MS Access 2000, MS Excel, IIS 6.0, Sun ASP 4.0, toad, Test director 9.0, Windows XP

Education

Master of Science - Electronics And Computer Science Engineering

Southern Illinois University, Carbondale
Carbondale, IL
12-2008

Skills

  • Requirements gathering
  • Agile methodology
  • User acceptance testing
  • Stakeholder management

Timeline

Systems/Senior Business Analyst

Leidos Inc.
07.2013 - Current

Sr. Functional Analyst

Constellation Energy
11.2012 - 06.2013

Sr.GIS/Quality Analyst

State High Way Administration(SHA)
03.2012 - 11.2012

Data/functional Analyst

Tyco Electronics
10.2009 - 01.2012

Master of Science - Electronics And Computer Science Engineering

Southern Illinois University, Carbondale

Similar Profiles

CREATE PROFILE
Sindhura Illindala