Home

Swetha - business analyst
[email protected]
Location: Irving, Texas, USA
Relocation: Hybrid
Visa: H4ead
Swetha Gurajala
Business Analyst
Email ID: [email protected]
Phone: +1 972 955 0279
Visa : H4EAD
Summary:
Have 8+ years of rich offshore and onsite experience in Business Intelligence DWH, Business Analysis,
Data Analysis, and Visualization tools with expertise in requirements gathering, analysis, designing
functional and technical specifications, and collaborating with architects & development teams to
achieve the deliverable.
Have a reasonably fair knowledge and hands-on experience in BI Visualization Tools (Tableau, Power
BI, SQL, MS-Excel, Python for Data Science, Qlik Sense, QlikView) and Testing tools (HP ALM, HP
Quality Centre)
Hands-on experience in SQL Server and Oracle databases
Have a gripping command and proficiency over BI Solutions in areas like CRM, CLM, Sales, Finance &
Marketing, and Supply Chain Finance
Played diversified roles ranging from Production Support Analyst, Tester, and Lead Developer to Tech
Business Analyst, resulting in added technical leverage and cognitive and analytical skills.
Strong knowledge of Change, Incident, Problem, and Release management
Experienced in providing L2 & L3 support.
Successfully carried out the task of acting as a bridge between the Stakeholders and various
development teams, elucidating business requirements into functional specifications
Have proven leadership skills involving managing, developing, and motivating teams to achieve time-
bound concrete results.
Proven track record of working throughout the phases of SDLC with solid hands-on knowledge of Agile
and Waterfall life cycles, requirement/functional analysis, and business improvement methodologies.
Possess a good aptitude to understand and document critical data through effective data collection,
analysis, and interpretation.
Excellent analytical skills, oral and written communication skills
Self-motivated team player with excellent problem-solving skills and ability to learn new technologies
and tools quickly.
Education and Certifications:
Bachelor of Technology specializing in Electronics and Communication.
Technical Skills:
BI Tools: Tableau Desktop, Power BI, Qlik Sense 3.2, QlikView 11.2, MS Excel
ETL Tools: IBM Infosphere DataStage 9.1, 8.5, Informatica 8.x/9.x
Databases: SQL Server, Oracle, Mongo DB
Programming Languages: Python for Data Science, C, PL/SQL
CRM: Salesforce.com, Veeva
Domain Expertise: Consumer Healthcare- Sales & Closed Loop Marketing, Supply Chain Finance
Development methodologies & Testing: DevOps, Agile, JIRA, ALM, HP Quality Centre
Source Control: Git, SVN, VSS, In4BI, Star team
Other Tools: BMC Remedy, Putty, TOAD, MS office

Work History:
Client: United Health Group
Business Analyst, Remote Oct 2023 - Current
Responsibilities:
Gathered requirements from business users and performed effective data analysis.
Delivered Business Requirement Documents and Report Specifications and collaborated with
the Architects & Development team to achieve the deliverables.
Developed and implemented a new Data Analysis tool that increased efficiency by 30% and
reduced errors by 15%.
Collaborated with cross-functional teams to identify and implement process improvements,
resulting in a 15% reduction in project delivery time.
Managed and tracked defects to closure by effectively providing analysis support in liaison with
the QA testing team & vendors, improving the defect fix productivity.
Delivered test case scenario documentation and approach for the User Acceptance Testing
(UAT) in liaison with the Business testers and QA testing team.
Provided orientation to support teams as a part of go-live by service introduction, collaboration,
and education using a centralized repository of documents.
Environment: Jira, Tableau, SQL Server
Previous Employment:
Tech Mahindra, Hyderabad Feb 2010 Feb 2018
Includes 1-year on-site (May 2012- Apr 2013) at Glaxo SmithKline, Brentford, London, UK
Awards and Recognition:
Certified Tableau Desktop Specialist qualification
Received Special award from Tech Mahindra for being instrumental in setting up the Qlik Sense
Server in Innovation Lab within GSK OSC and training ELITES in QV/QS technologies.
Received ACE award from Tech Mahindra for being a consistent STAR performer.
Received Star Award from the client, GlaxoSmithKline, for a contribution towards the Consumer
Connections Analytics project.
Received Appreciation Certificate from Tech Mahindra for consistent performance and long service.
Received Associate of the Month award for dedication and contribution to Med-e-rep Analytics
project and demonstrating thorough understanding and technical consultancy.
Received Pat on Back award from Mahindra Satyam for improving the performance of a Server
Process in CAS CRM- Trade Investment Promotion System.

Professional experience:
Client: Glaxo SmithKline (GSK), UK
Project 1: G-ERP Qlik Sense Capability Oct 2016 - Feb 2018
Role: Qlik Consultant
Description:
The client wants to introduce Qlik Sense in the GERP BI & Analytics landscape to provide a governed
platform for Self Service and Data Visualization, allowing integration of SAP and Non-SAP data.

Responsibilities:
Provided consultancy in setting up Qlik Sense multi-node environment to cater to the reporting needs
of businesses from different functional areas.
Gathered requirements from business users and performed data analysis.
Explored Qlik s SAP connectors to extract data from the SAP BW system.
Explored capabilities of SAP Lumira Vs. Qlik Sense Reporting
Defined security, user access provisioning, and service model
Qlik Consultation to help Business develop their Dashboards.
Analyzed the areas of improvement within the Business by effectively utilizing KPIs, performing data
analysis, and root cause analysis.
Delivered report specification document collaborating with the technical team to achieve the delivery.
Led the team of developers.
Environment: Qlik Sense 3.2, QlikView 11, SAP Lumira, SAP BW-HANA

Project 2: SPICE+BI Oct 2015 - Feb 2016
Role: Technical Business Analyst
Description:
For the Pharmacy and Mass Market business of Consumer Healthcare, a new CRM system SPICE+, an
implementation of Veeva, is used for activities such as order taking, order processing, and sales activity.
The BI reporting solution replaces their current manual reporting solutions and would aid in analyzing &
improving activities at each step.
Responsibilities:
Gathered requirements from business users and performed data analysis.
Delivered Business Requirement Document and Report Specifications and collaborated with Architects
& Development team to achieve the deliverable.
Managed and tracked defects to closure by effectively providing business analysis support in liaison
with the QA testing team & vendors, improving the defect fix productivity.
Delivered test case scenario documentation and approach for the User Acceptance Testing (UAT) in
liaison with the Business testers and QA testing team.
Have provided orientation to support teams as a part of go-live by service introduction, collaboration,
and education using a centralized repository of documents.
Analyzed the As-Is process and redesigned it to an effective To-Be process focusing on the customer
experience.
Analyzed the areas of improvement within the Business by effectively utilizing KPIs, data analysis, and
root cause analysis.
Environment: QlikView, Informatica, Teradata

Project 3: Connections Analytics Mar 2015 - Sep 2015
Role: QlikView Tech Lead
Description:
Cx Connections Analytics solution significantly enhances an existing Cx eSales analytics solution, which
provides integrated reports on CRM (Med-e-rep) and CLM (Skura) for Sales Managers to analyse and
improve Sales Force Effectiveness and Content usage in customer interactions from cycle to cycle.

Responsibilities:
Involved in requirement gathering, data analysis, estimates, and solution design.
Identified Business and technical issues throughout the project that could impact requirements,
scope, or schedule and worked with the project manager to identify potential solutions.
Provided functional knowledge to the development and testing team.
Liaised with different teams (source systems involved in integration)
Performed progress review and documented project metrics.
Environment: QlikView, IBM DataStage 8.5, SQL Server 2008

Project 4: Med-e-Rep Analytics Apr 2014 - Feb 2015
Role: QlikView Lead Developer
Description:
Med-e-Rep is a CRM solution built in SalesForce.Com (SFDC) and used by dental detailers. The system is
live in over 86 markets. As Med-e-Rep has matured, an emphasis has been placed on developing
standardized reports for Dental Detailing teams. This project aims to provide an effective BI tool to
improve analytics for Sales Managers and Market Administrators while driving the standardization of
reports.
Responsibilities:
Acquired business requirements from end users and compiled them into detailed functional
specifications.
Designed process workflows and Report Mock-ups and coordinated with lead customers through the
definition and design phases of the model and implementation process, including analyzing current
business processes, documenting configuration and extension requirements for the application as well
as data and integration requirements, and producing business requirement documents.
Identified Business and technical issues throughout the project that could impact requirements,
scope, or schedule and worked with the project manager to identify potential solutions.
Worked with the technical team members during the development and test phases of the project to
clarify issues and managed and made documental changes when needed.
Environment: QlikView, IBM DataStage 8.5, SQL Server 2008

Project 5: eSales Analytics Oct 2012 Mar 2014
Role: BI Lead
Description:
The purpose of eSales analytics is to provide an essential link in the closed-loop marketing cycle that of
reporting the performance of Electronic Sales (eSales). This application offers insights for the Sales
Managers to improve Sales rep effectiveness, focus on brands, and convey key messages along with the
scope for improving the content used in one sales cycle to the next.
Responsibilities:
Analyzed the requirements and designed High-level and Low-level Design specifications
Extracted data from ODBC (SQL Server), applied business logic and built server and parallel jobs in
DataStage.
Designed QlikView data model per the requirement and created Innovative Dashboards to analyze the
KPIs.

Identified and eliminated performance bottlenecks during the development lifecycle and participated
in Unit Testing.
Created Test plans, Test cases for testing end-to-end processes from DataStage ETL to QlikView
reporting.
Administered the SQL and QlikView servers in pre-prod and production environments.
Educated users regarding different functions of the dashboards deployed and helped them conduct
UAT.
Environment: QlikView, IBM DataStage 8.5, SQL Server 2008

Project 6: Host Analytics May 2012 - Sep 2012
Role: Support Analyst, Onsite (London, UK)
Description:
Host Analytics ONEplan solution projects the financial performance of the Consumer Healthcare Europe
business by market, product, and customer by corporate planning requirements and with Consumer
Healthcare demands. This solution provides a standard process and tool to support the needs of the
European region in creating their financial forecasts, Mid-Year reviews, and 3-1 Plan submissions.
Responsibilities:
Acquired knowledge transition on Host Analytics CPM suite
Involved in End User training, Manuals preparation, and application customization.
Performed UAT as a system administrator and helped end users test the system.
Helped in Troubleshooting technical and data loading issues faced by Users during UAT.
Documented Standard Operating Procedures and Application Understanding
Environment: CPM Tool-Host Analytics, SQL Server 2008, BMC Remedy

Project 7: CP-WREX Apr 2010 - Apr 2012
Role: Support Analyst
Description:
CRM consists of Processes to track and organize the company s contacts with current and prospective
customers. TIPS (a CRM process) is the name of a TPM tool of the product CPWerx developed by CAS. It
provides P and L forecasting, which drives Businesses to plan promotional activity based on historical data
and helps manage and accrue customer payments. Through SFA (another CRM process), users can plan
calls, Orders, and Campaigns, get customer feedback, keep track of Assets GSK installed at customer
locations, Order processing, Approvals, and financial data interfaced from JDE.
Responsibilities:
Key support Analyst in Trade Investment Promotion System for Australian Business (AUSTips),
performing roles like Customizing and configuring CAS CRM Application, specific to country/market.
Analyzing and removal of orphaned or junk data that flew into the system through interface files
Troubleshooting application-level problems faced by Users, performing administrative tasks like
managing users, assigning roles, mapping territories, granting access rights, etc.
Understanding, uploading, and exporting data that moves to and from interface files in JD Edwards,
SAP, and other sources with different formats like Text, CSV, and XML.
Deploying the Patches released by CAS (Vendor).
Acquiring knowledge transition on new changes deployed for CRM, BI DataStage, Cognos reporting,
and providing support.

Environment: CRM Tool-IBM CAS, Oracle 10G, BMC Remedy
Keywords: cprogramm quality analyst business intelligence database information technology golang business works hewlett packard microsoft procedural language Idaho

To remove this resume please click here or send an email from [email protected] to [email protected] with subject as "delete" (without inverted commas)
[email protected];2323
Enter the captcha code and we will send and email at [email protected]
with a link to edit / delete this resume
Captcha Image: