SUMMARY

• Experience working as a Business Data Analyst over 5 years in Utility and Banking industry.
• Experienced in using MS SQL to extract data needed to perform data analysis, data manipulation, data validation and data visualization.
• Experience working with large datasets as well as experience analysing volumes of data through basic Microsoft Excel functions, like macros and pivot tables.
• Adept with SDLC methodologies like Waterfall, Agile Scrum and Kanban boards.
• Served as teh liaison between teh business unit and teh programming/technical units.
• Working Knowledge of Business Intelligence tool like Tableau for data visualization.
• Strong Proficiency in using MS Visio and Rational Requisite Pro to design and create Use Case Diagram and Activity Diagrams.
• Strong knowledge of project management skills such as time estimation, task identification, and scope management.
• Experience with Joint Application Development (JAD) sessions with IT Groups and Conflict Management with Project team members.
• Extensively used tools like HP ALM and JIRA for defect tracking and requirement management.
• Worked with Postman and SOAP UI API integrations.
• Worked as BA for Java frameworks like Spring, Apache.
• Have Intermediate level Python language skills and have created arcade games like Alien invasion by coding in python.
• Experience implementing AWS Cloud based solutions like Database through Redshift; VPC through EC2, Elastic BeanStalk; Storage services through S3 and S3 Glacier; Networking through Route53 and CloudFront; Security through CloudWatch, CloudTrail and IAM services; Machine Learning through Amazon Sagemaker; and many more in AWS.
• Excellent interpersonal skills, organizational skills, and strong detail oriented and self - motivating skills.
• Ability to excel and succeed in a diverse environment and projects with strong determination, dedication, and inclination towards customer satisfaction.
• Self-driven with teh ability to adapt quickly to constantly changing teh environment.
• Confident and comfortable presenting in front of stakeholders or large groups.

TECHNICAL SKILLS

Databases: MySQL Server, MS Azure, Amazon Redshift

Req. Management Tools: Rational Requisite Pro, HP ALM

Defect Tracking Tools: HP ALM, JIRA

Modeling Tools: MS Visio, LucidChart

Packages: MS Office, Google Suite, Amazon Web Services (AWS)

Operating System: Windows, MacOS, Linux distribution Ubuntu MS SQL, Python, AWS, Java Frameworks

Database Tools: SQL, XML, Tableau

PROFESSIONAL EXPERIENCE

Confidential

Technical Business Analyst

Responsibilities:

• Worked as Product owner for a new notification feature via Text messages for Credit notifications which involved sending SMS to customers when their account were past due.
• Gathered requirements and drove teh project to completion while working with external vendor (Twilio).
• Assisted with teh text language to be used to send to customers in SMS and got it approved from teh PGE Brand team.
• Discovered multiple problems with MS Exchange email services and provided PGE with a solution to migrate to another vendor(SendGrid).
• Worked as Product Owner to migrate teh email services from MS Exchange to SendGrid for better data analytics.
• Worked with Cyber Security team to make sure dat new vendors are in compliance with our policies and all security measures are followed by team like password storage in Cyberark and two factor authentication.
• Worked with stakeholders to get requirements and then helped developers convert teh legacy code to Java framework.
• Worked with teh team to resolve Incidents assigned to our team for teh notification features we built.
• Worked as Business System Analyst and created multiple requirements document and functional design document for multiple new programs PGE rolled out like Green Future Impact, Smart Thermostat and Residential renewables.
• On multiple occasions filled out teh Scrum master role and walked teh team through Daily Standup, Sprint planning and change requests.
• Did weekly Storytime sessions with teh developers to convey what needs to be done and then prioritize and estimate those stories.
• Gave bi-weekly status updates to teh executive team on teh progress of teh projects I worked on.
• Worked on rate change requests for different tariff programs for Oregon electric like Schedule 54, 55, 90 and end of year general rate change requests.
• Created test scenarios and acceptance criteria as part of requirements for multiple programs.
• Worked on Oracle CCB and MDM applications.
• Worked with teh Scrum Master to prioritize teh items from teh product backlog in teh sprint planning.
• Created flow diagrams in MS Visio for team to better understand teh process.
• Worked with teh Customer Service team to update teh CSA training material dat teh representatives use for answering customer questions.
• Participated in weekly product hurdles to discuss product specifications and to develop technical functionalities.
• Followed agile methodology using Jira board to track team progress and product features development.
• Created quarterly go to market plans so dat IT and Business have transparency on what to expect each quarter.

Environment: MSOffice, SQL, CCB, MDM, Appworks, MS Visio, aha, Jira, Twilio, SendGrid

Confidential

Technical Business Analyst

Responsibilities:

• Followed Agile Methodology throughout teh Software Development Life Cycle (SDLC) from requirement analysis to deployment for teh AI model called sherlock.
• Implemented Cloud based solution using AWS for machine learning and Artificial Intelligence model.
• Implemented AWS solutions like Redshift Database, computing power using EC2, Elastic BeanStalk and storage services like S3 and S3 Glacier.
• Requirement gathering and then creating SSO, web services, microservices through Java frameworks with developers.
• Implemented networking and security solutions using AWS like Route 53, IPA, CloudWatch, CloudTrail and IAM (Identity and Access Management).
• Assisted Sherlock AI team in managing around 50 interns for Label-a-thon for AI model which helped inspectors track possible assets failure.
• Worked alongside developers writing codes in python language and trouble shooting and fixing errors in teh python code language.
• Working in Data Inventory for Data Mapping across thousands of systems, to be in compliance with teh California Consumer Privacy Act (CCPA) and also followed HIPAA guidelines for medical history data.
• Extensively used SQL queries for Data Validation and Data manipulation.
• Used SQL to extract and bifurcate Data between personal information data and business relevant data using parameters like customer account number.
• Exercised relational database knowledge to construct and execute SQL queries to be used in data analysis activities.
• Created Macros in Excel to differentiate between personal information and business information for teh customer database using parameters like PG&E Account Number, Medical history, household income and more.
• Created end of day reports using MS Excel and Business intelligence tool like Tableau for reporting purposes.
• Also used Tableau to visualize Data to present to teh leadership team.
• Worked as part of Data Analytics team and supported Product owners for cost forecasting, cost accounting, contract management and financial reporting.
• Helped product owners update teh forecast every month within Excel and then updating it in teh PRJ using SAP Business Planning and Consolidation (BPC).
• Assisted IT team in resource prioritization and managed capital orders for future assets.
• Worked with product owners in updating business use cases for EO Technology team every quarter.
• Created security group policies to make sure dat everyone who has been hired follow teh compliance policies and go through all teh mandatory trainings otherwise teh access might be revoked.
• Created automated bot in Slack workflows for new hires for onboarding.

Environment: MS Office, MySQL, AWS Redshift, Jira, Python, Tableau, AWS Services, Macros in Excel, Windows, Linux Ubuntu Distribution and MacOS OS

Confidential

Business Analyst

Responsibilities:

• Followed Agile Methodology throughout teh Software Development Life Cycle (SDLC) from requirement analysis to deployment.
• Gathered teh business requirements by interviewing client stakeholders, developers, and managers, asking detailed questions and carefully recording teh requirements in a format dat can be reviewed and understood by both stakeholders and teh technical team.
• Conducted process analysis of financial planning, programming and budgeting activities and developed recommendations for process improvement as needed
• Performed Monthly cost variance reports, comparing budget, performance and actual work performed.
• Conducted JAD Sessions with various stakeholders to develop teh structural design of teh application enabling it to meet teh required business standards.
• Worked with Project Manager, Product Owner, and Scrum Master to ensure timely completion of teh project and maintaining teh quality at teh same time.
• Conducted project walkthroughs in front of large groups for stakeholders like Loan Officer, Loan Processor, Underwriter, Loan Funding department, Loan Closure team and many more.
• Conducted Scrum meetings and discussed teh roadblocks dat are blocking teh progress and how to solve them.
• Collaborated with senior management and project teams to gather, analyze high level and low-level requirements for Scope, Timeline, and planning of teh project.
• Performed Feasibility, Adaptability and Risk Analyses to identify teh business critical and high-risk areas of teh application.
• Reviewed loan applications and analyzed data required to process loan documents and performed validation to ensure dat teh loan documents are transmitted to appropriate departments.
• Worked on implementing forecasting modules in Borrower portal like Loan to value, Refinance, equity on house, yearly taxes, expenses, expected inflation in home prices etc.
• Interacted with teh processors as well as teh loan officers thus acted as a liaison between teh business user groups and teh technical systems groups.
• Created UML Diagrams including Use Cases Diagrams, and Activity Diagrams using MS Visio for explaining workflows of complex user stories or epics.
• Documented teh User’s Guide and performed walkthroughs with teh end users in order for them to understand how teh software works.
• Organized and facilitated sprint planning, daily stand-up meetings, reviews, retrospectives, release planning, demos, and other Scrum-related meetings.
• Reported progress to all stakeholders through Sprint Burn-Down Reports, Iteration Burn-Down Reports, and velocity target updates.
• Coordinated release efforts with project management, QA and development team.
• Conducted Impact analysis of changing requirements and negotiate with users based on teh analysis results.
• Clarified QA team issues and reviewed test plans and test scripts developed by QA team to make sure dat all requirements are covered in scripts and tested properly.
• Participated in Defect Triage meetings conducted by QA during Defect cycle.

Environment: MS Office, Google Suite, MySQL, Project Management, CA-Agile, MS Visio, Lucid Charts, Agile Scrum, Windows and MacOS OS