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) 521-1404 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