Sivaranjani_Data Analyst
United States of America 1------------- ------------
SUMMARY
Focused, quick-learning and detail-oriented strategic analyst with five years of IT experience with the ability to lead teams without compromising service or quality, seeking an opportunity to upgrade my technical, collaborative skills and analytical ability.
EDUCATION
Illinois Institute of Technology, Chicago, IL Jan 2019 �May 2020(Expected)
Master of Science in Information Technology Management � Data Management - GPA 3.66/4
Thiagarajar College of Engineering, Madurai, India Aug 2009 - May 2013
Bachelor of Technology in Information Technology - GPA 3.56/4
SKILLS
Key Skills: Business Analysis, Data Analysis, SDLC, Airline domain, Agile Scrum
Tools: MS Office, JIRA, SOAPUI
Programming Skills: JAVA, R, MYSQL, SQL developer
PROFESSIONAL EXPERIENCE
British Airways � TATA Consultancy Services
Business Analyst March 2017 � Dec 2018
� Promoted existing ------------ application to an XML-based data transmission standard (NDC - New Distribution Capability) promoted by the International Air Transport Association (IATA) to enhance the capability of communications between airlines and travel agents also modified them to minimize airline costs and maximize profits.
� Communicated with business users to derive the user stories and functional documentation for the project.
� Retailed the air products to corporations, leisure and business travelers, by addressing the industry�s current distribution limitations.
� Held experience of working in an agile environment with sprint planning, gathering business requirements, developing user stories and participating in scrum meetings with various stakeholders and managing a scrum team.
� Performed business user acceptance testing during release flow to verify functionalities, possessing business and technical expertise in a wide array of customer and commercial oriented airline business solutions
� Validated test results to verify scenario coverage and to ensure zero defects during user acceptance testing.
� Created, maintained Jira dashboards for task assigning, backlog tracking and report to senior management on a bi-weekly basis.
Data Analyst August 2016 � March 2017
� Undertook the role of data analyst in a data migration project in the airline's Customer Relationship Management where
the personalized customer content helped improving customer recognition and delivering a personalized experience
� Performed various SQL testing using DML scripts to access and verify data on various schemas and datasets
� Worked with the project team and business to carve data requirements, and prepared test strategies and test plan for the migration.
Test Analyst September 2013 � July 2016
� Understood the process flow between service layers with UX and database.
� Created detailed project deliverables (Requirement Traceability Matrix, Test Plans, Test Cases, Test Report, and Support files) cases and took them through the approval stages.
� Completed various levels of testing - System, System Integration, End to End, Regression, User acceptance
� Assisted the development team in fixing the bugs.
� Prepared effortless automated suite for regression testing
ACADEMIC PROJECTS
A study of sales through consumer behaviors on Black Friday Sales
� Identified sales transaction made in a retail store during black Friday sales from K------------.
� Processed data for analyzes and found correlation between various attributes.
� Performed regression and classification analysis using R to predict of sales, characteristics of users based on their purchase data.
ACTIVITIES
Placement Representative, Thiagarajar College of Engineering, India June 2012 �April 2013
Learning Group SPOC for Initial Learning Program, TCS, Ahmedabad September 2013 � Dec 2013
United States of America 1------------- ------------
SUMMARY
Focused, quick-learning and detail-oriented strategic analyst with five years of IT experience with the ability to lead teams without compromising service or quality, seeking an opportunity to upgrade my technical, collaborative skills and analytical ability.
EDUCATION
Illinois Institute of Technology, Chicago, IL Jan 2019 �May 2020(Expected)
Master of Science in Information Technology Management � Data Management - GPA 3.66/4
Thiagarajar College of Engineering, Madurai, India Aug 2009 - May 2013
Bachelor of Technology in Information Technology - GPA 3.56/4
SKILLS
Key Skills: Business Analysis, Data Analysis, SDLC, Airline domain, Agile Scrum
Tools: MS Office, JIRA, SOAPUI
Programming Skills: JAVA, R, MYSQL, SQL developer
PROFESSIONAL EXPERIENCE
British Airways � TATA Consultancy Services
Business Analyst March 2017 � Dec 2018
� Promoted existing ------------ application to an XML-based data transmission standard (NDC - New Distribution Capability) promoted by the International Air Transport Association (IATA) to enhance the capability of communications between airlines and travel agents also modified them to minimize airline costs and maximize profits.
� Communicated with business users to derive the user stories and functional documentation for the project.
� Retailed the air products to corporations, leisure and business travelers, by addressing the industry�s current distribution limitations.
� Held experience of working in an agile environment with sprint planning, gathering business requirements, developing user stories and participating in scrum meetings with various stakeholders and managing a scrum team.
� Performed business user acceptance testing during release flow to verify functionalities, possessing business and technical expertise in a wide array of customer and commercial oriented airline business solutions
� Validated test results to verify scenario coverage and to ensure zero defects during user acceptance testing.
� Created, maintained Jira dashboards for task assigning, backlog tracking and report to senior management on a bi-weekly basis.
Data Analyst August 2016 � March 2017
� Undertook the role of data analyst in a data migration project in the airline's Customer Relationship Management where
the personalized customer content helped improving customer recognition and delivering a personalized experience
� Performed various SQL testing using DML scripts to access and verify data on various schemas and datasets
� Worked with the project team and business to carve data requirements, and prepared test strategies and test plan for the migration.
Test Analyst September 2013 � July 2016
� Understood the process flow between service layers with UX and database.
� Created detailed project deliverables (Requirement Traceability Matrix, Test Plans, Test Cases, Test Report, and Support files) cases and took them through the approval stages.
� Completed various levels of testing - System, System Integration, End to End, Regression, User acceptance
� Assisted the development team in fixing the bugs.
� Prepared effortless automated suite for regression testing
ACADEMIC PROJECTS
A study of sales through consumer behaviors on Black Friday Sales
� Identified sales transaction made in a retail store during black Friday sales from K------------.
� Processed data for analyzes and found correlation between various attributes.
� Performed regression and classification analysis using R to predict of sales, characteristics of users based on their purchase data.
ACTIVITIES
Placement Representative, Thiagarajar College of Engineering, India June 2012 �April 2013
Learning Group SPOC for Initial Learning Program, TCS, Ahmedabad September 2013 � Dec 2013