Sangeeta Swain
System Admin /
Business Data Analyst-Bangalore-
www.linkedin.com/in/sangeetaswain-5744a243
SKILLS
Business Analysis
Data Analysis
PROFILE
Enthusiast Business Data Analyst with 9+ years of experience
in Oracle EBS Application development, system Integration,
ERP implementation using SQL, MySQL, PL/SQL along with
analyzing business processes, identifying improvement
opportunities, and driving data-driven decisions. Proficient in
using data visualization tools like PowerBI, Tableau, Advanced
Excel. Adept at collaborating with cross-functional teams to
enhance operational efficiency and achieve potential
improvements.
PROFESSIONAL EXPERIENCE
Baker Hughes
System Admin/Business Data Analyst
August 2019 – present | Bangalore, India
Organized business requirements and created BRDs and
FRDs, resulting in improved project transparency and 20%
faster delivery time.
Developed SLA analysis reports and tracked SLA misses
using Excel and ServiceNow, resulting in a 25% decrease in
missed SLAs and improved service delivery.
Conducted data extraction, mining, and profiling, providing
critical insights that enabled strategic decision-making and
a 30% increase in customer satisfaction.
Collaborated with business stakeholders to gather
information and created technical documentation,
increasing cross-functional communication and alignment.
Utilized SQL queries to perform data analysis, identifying
and resolving data inconsistencies, resulting in a 20%
reduction in errors and improved data accuracy.
Streamlined Reporting process, reducing time spent by
50%. Created visualizations with Tableau and PowerBI.
•
Data Visualization
Data Migration
•
Data validation
Data Mapping
•
Data profiling
MySQL
•
SQL
MS Excel
•
Tableau
Microsoft PowerBI
•
Python
Power Point
PL/SQL
Oracle & BI Publisher Reports
KPIs
Tata Consultancy services
ITAnalyst/SQL Data Analyst
June 2014 – August 2019 | Bangalore, India
Expertise in Oracle EBS application development using
SQL, ,MySQL,PL/SQL.
Optimized T-SQL codes for faster processing and improved
performance resulting in 20% reduction in query execution
time.
Created Oracle Reports, BI publisher reports using Report
builder & BI tool. Optimized database queries to reduce
execution time by 50%, resulting in a 20% increase in
overall system performance.
Created Technical documents. Migrated data from legacy
system through SQL servers.
Resolved database related issues while data loading and
migration in production environments.
Collaborated with cross-functional teams to implement
new database schema and optimize data storage, resulting
in a 60% decrease in data retrieval time.
•
•
stakeholder management
Business Requirement Gathering
•
Dashboard
SSMS
•
•
•
PROJECTS
Oracle GTM- ITC Directive Project
Baker Hughes
April 2023 – present
Expertise in leading multiple technical teams specifically in
PO and OM areas by assigning tasks and monitoring
progress updates.
•
CERTIFICATES
Post Graduate program certification
in Business Analysis from Purdue
University
Google Data Analytics
Specialization certification
Python :Hands-on Introduction for
Beginners
Oracle E-Business Suite 12 Supply
Chain Certified Implementation
Specialist: Oracle Purchasing
Certification
Lean Six Sigma Green Belt
Certification
Developed dashboards to monitor key performance
indicators.
Worked with cross-functional teams to understand
business requirements.
Analyzed data using SQL to identify trends, patterns, and
insights
Created reports and visualizations to communicate findings
to stakeholders.
Created Business and functional required documentation
BRDs, FRDs and Technical docs etc.
•
•
•
•
•
Blueprint Documentation for Projects
Baker Hughes
October 2021 – present
Gathered information from Business Stakeholders/users
and Identified and evaluated Business Process related
Manufacturing specific areas in multiple assigned projects.
Documented BRDs (BR010), FRDs (CF250, BR100,
BR110), Technical docs(MD200)etc.
Monitered documention workflow process by validating
docs in Sharepoint.
•
•
BPS : SQL Basic_Foundation
Foundation : Oracle
PL/SQL_Foundation
Foundation/IT IS : Oracle 11g
PL/SQL_Foundation
Architecture & Tools : Microsoft
Office365_Foundation
AWARDS
Service & Commitment
Award(BAKER HUGHES)
On The Spot Award(TCS GEHC)
Service & Commitment Award(TCS)
Best Team Award(ALCOA)
EDUCATION
BACHELOR OF TECHNOLOGY
Institute of Technical Education &
Research
May 2010 – May 2014
Bhubaneswar, India
Electronics Communication
Engineering (9.43 CGPA)
•
OFSE SPC Abu Dhabi Project
Baker Hughes
November 2022 – July 2023
Performed Data extraction,Data mining,Data profiling using
Oracle SQL,Mysql,SQL server Management studio,Excel for
Manufacturing modules.
Worked with SMEs and dealt with cross functional teams
to gather all Data migration and Data mapping
requirements.
Explored and Analysed datasets using MS Excel by
cleaning, sorting, filtering data and creating pivot
tables,charts and graphs.
Created Dashboards and Data Visualization reports using
PowerBI/Tableau based on user requirements to provide
insights to stakeholders.
•
•
•
•
DT STORD PLM implementation project
Baker hughes
July 2022 – December 2022
Evaluated Business and functional required documents
with validation specific to rules sets created as per
stakeholders.
Used Advanced SQL to mine data for insights and patterns.
Developed and implemented data quality checks to ensure
accuracy and completeness of data
Developed predictive models to support business decisionmaking.
•
•
•
•
STANDARD XII / H.S.C.
B.J.B Junior College
April 2007 – April 2009
Bhubaneswar, India
76.3%
GRC SOD Long term Project
GE Oil & Gas
July 2020 – December 2021
Worked with SMEs and dealt with cross functional teams
to gather all Data migration and Data mapping requirement
Communicated findings and recommendations to
stakeholders in a clear and concise manner.
Used SQL to mine data for insights and patterns
Analyzed data using SQL to identify trends, patterns, and
insights.
Explored and Analyzed datasets using MS Excel by
cleaning, sorting, filtering data and creating pivot tables,
charts and graphs.
Created reports and visualizations to communicate findings
to stakeholders.
•
SSC Xth C.B.S.E
D.A.V Public School
Bandhabahal, India
91.8%
•
•
•
LANGUAGES
English
Hindi
Odia
•
•
HOBBIES & INTERESTS
people interaction, Solving Puzzles,
Reading Books,Novels, Net surfing,
Exploring New places,
Singing and Listening Music
EY SOD Analysis Project
GE Oil & Gas
August 2019 – December 2019
Provided support in EY SOD Analysis in order to identify
SOD violations and mitigate access risks Based on certain
ruleset.
Handled Incidents/Change Management Tickets in
ServiceNow to Coordinate with cross-functional teams to
identify and deliver the optimal solution
Done Datafix by exporting data and preparing monthly
reports with statistics on recurring change tickets.
Generated weekly SLA reports from ServiceNow reports
using Excel for further data analysis.
•
•
•
•
AON India Insurance Project
TCS
November 2018 – August 2019
Done enhancement in Oracle PLSQL packages,SQL stored
procedures in different environment and done PROD
applications fixes.
Implemented Advanced SQL queries in SQL server
Management studio.
Done Data Extraction from different sources like CSV files,
Excel files.
Optimized stored procedures in to extract, transform and
load (ETL) data to ensure reporting infrastructure was
maintained according to current service level agreements.
•
•
•
•
GE Healthcare Project
TCS
December 2016 – October 2018
Developed code and create technical design for business
features as per requirement
Done enhancement in oracle reports,BI pubisher reports,
PLSQL packages, Form personalizations based on
PO,OM,AP,INV,AR modules in Oracle EBS application.
Done Functional AOL setups in AP, AR modules in Oracle
EBS application.
Debugged codes to resolve existing production issues and
involved in migration of components to other instances.
Done Unit testing and Developed test scripts or cases.
•
•
•
•
•
Alcoa, Inc.
TCS
June 2014 – November 2016
Created technical design and MD technical docs as per
project requirements.
Created Discoverer and Oracle Reports, PL/SQL Packages,
Oracle Forms , stored existing Procedures in Oracle
Applications R11i/R12 and Oracle 10g database.
Debugged codes to resolve existing production issues and
Fix bugs in existing applications.
Done data validation, data loading, data mapping and data
migration and unit testing of test scripts.
Involved in Requirement Gathering, analysis, Design,
Development, Unit Testing , Production Deployment and
Support.
•
•
•
•
•
DECLARATION
I, hereby declare that the information given by me is correct to
the best of my knowledge & belief.
Sangeeta Swain
Bangalore
