Business Analyst Sql Server

VEENASA GARIMELLA

Richmond, VA ***** 425-***-**** ************@*****.*** www.linkedin.com/in/gveenasa

PROFESSIONAL SUMMARY

A seasoned Business Analyst with 6 years of experience, excelling in the art of eliciting and analyzing business requirements, streamlining processes, and delivering optimal solutions. Proficiency extends across various SDLC methodologies, including Waterfall, Agile, and V models, with a keen understanding of data warehousing concepts. Skilled in object-oriented programming with Python, adroitly navigating database operations, and crafting SQL queries that integrate smoothly with applications.

Skilled Netsuite Business Analyst with expertise in optimizing business processes and workflows through the implementation and customization of Netsuite solutions.

Experienced in collaborating with cross-functional teams to gather requirements, design solutions, and deliver high-quality Netsuite implementations.

Proven track record of successfully configuring and customizing Netsuite modules to meet unique business needs and maximize system capabilities.

Experience in developing Business Intelligence assets using tools like Informatica PowerCenter, Tableau, Oracle, and others.

Proficient in Software Development Life Cycle (SDLC) using Waterfall and Agile methodologies.

Good knowledge of data analysis, visualization using Tableau and SQL.

Working knowledge of different relational databases (MS SQL server and PostgreSQL).

Experience in writing SQL queries, Stored Procedures and Triggers using PostgreSQL and SQL Server.

Expertise in data visualization, developing Dashboards, Charts, Graphs, and reports using Tableau.

Expertise in developing reporting based on structured and unstructured data.

Having good experience in creating and shared dashboards to users as admin and helped in integration.

Expertise in transforming business requirements into analytical models and designs.

Knowledge on Python Basics and Tableau.

Expertise lies in coordinating sprints, driving quality deliverables, and collaborating with product owners to efficiently manage project backlogs. Well-versed in creating detailed business documents such as BRDs, wireframes, and UML diagrams, and adept in conducting gap analysis supported by data insights from SQL queries. An effective communicator with robust presentation skills, capable of building relationships and conveying complex information with clarity and tact.

Versatile in team leadership, known for motivating teams toward peak productivity and fostering an environment conducive to collaborative success. With a commitment to continuous learning evidenced by resource planning solutions that align with client business objectives, ensuring adaptability and independence in responding to new challenges. With a strong foundation in database management and performance optimization, equipped to handle data analysis with precision using advanced SQL techniques.

Leveraging the ability to influence others and work independently, adeptly managing complex workflows and translating customer program requirements into actionable user stories. With diligence in capturing detailed meeting minutes, ensuring that all process documents accurately reflect business processes, facilitating clear communication and project alignment.

CORE EXPERTISE & COMPETENCIES

Business Requirements Analysis

Data Analytics

Process Improvement

Project Management

Data Warehousing Concepts

Data Warehousing Strategies

Database Design & SQL

Change Request Management

Client Communication

Client Engagement

Data Modeling Techniques & Tools

Resource Planning

Resource Allocation

Behavior-Driven Development (BDD)

RFP/ RFI/ ROM Processes

Workflow Management

User Stories Development

Procurement

Traceability

Reconciliation

Progress Reporting

Customer Experience

Project Documentation

Performance Indicators

Customer Program Management

Team Coordination

Leadership

Flexibility

Deadline Driven

Insightful

Problem Solving Skills

Analytical Skills

Critical Thinking

Leadership Skills

Collaboration Skills

Interpersonal Skills

Python

Tableau

Dashboards

ERP

PROFESSIONAL EXPERIENCE

BUSINESS ANALYST Waste Management Richmond, Virginia Jul 2022 – Present 2024

Project Overview: A waste management project aims to efficiently collect, sort, recycle, and dispose of waste materials to minimize environmental impact and promote sustainability. It involves implementing strategies for waste reduction, reuse, and proper disposal methods, along with public education and awareness campaigns to encourage responsible waste management practices within communities.

•Proficient in gathering and analyzing business requirements to identify opportunities for process improvement and optimization.

•Skilled in utilizing data visualization tools like Tableau or Power BI to create insightful reports and dashboards for stakeholders.

•Experienced in conducting thorough research and data analysis using Excel and other spreadsheet software to support decision-making processes.

•Experienced in performing data validation and cleaning tasks using SQL scripts to ensure data accuracy and reliability.

•Skilled in creating complex SQL joins, subqueries, and aggregations to generate meaningful reports and dashboards for stakeholders.

•Demonstrated ability to collaborate with cross-functional teams to translate business needs into technical requirements for system enhancements or implementations.

•Familiarity with SQL basics and eager to expand proficiency through training and hands-on projects.

•Strong problem-solving skills and attention to detail, with a track record of delivering high-quality solutions to complex business challenges.

•Excellent communication skills, both verbal and written, to effectively communicate findings and recommendations to diverse audiences.

•Proactive learner with a passion for staying updated on industry trends and best practices in business analysis methodologies.

Notable Achievement:

•Developed cost-saving waste management strategies resulting in a 15% reduction in landfill usage within 6 months.

BUSINESS ANALYST IL & FS Technologies LTD Hyderabad, India Jul 2018 – Nov 2021

Project Overview: The Telangana Revenue Department initiated the Integrated Land Records Management System (ILRMS) to consolidate land administration and registration processes. This web-based platform ensures efficient, transparent, and secure land transactions, enhancing public service. It streamlines property registrations, mutations, and transfers, while providing instant access to digital land records, significantly reducing processing time and increasing convenience for landowners in Telangana, India.

•Conducted requirement gathering sessions, coordinating with stakeholders for JAD sessions to elicit functional and non-functional requirements, and implemented Business Requirement Documents (BRD) based on these requirements.

•Participated in creating use cases and periodic management reports, managed policy, issue, workflow and change management while analyzing data for comprehensive reporting and performance analysis.

•Support the creation and execution of efficient logistics plans, collaborating across teams to sync activities with production and customer needs.

•Designed and executed A/B tests to optimize user engagement and conversion rates, resulting in a 15% increase in click-through rates.

•Proficient in A/B testing tools such as Optimizely, Google Optimize, and Adobe Target for setting up and running experiments.

•Validated external data sources, collaborated on developing logical and physical data models, and provided data analysis and reporting support, ensuring adherence to corporate standards and guidelines.

•Manage transportation, including carrier selection, contract negotiation, and schedule monitoring, ensuring timely, cost-effective delivery while meeting regulatory standards.

• Proficient in writing complex SQL queries to extract, manipulate, and analyze data from relational databases, leading to actionable insights that drove a 10% increase in operational efficiency.

• Managed and optimized database performance through indexing, query optimization, and regular maintenance, resulting in a 20% reduction in query execution time.

•Developed and executed Test Strategy Planning, oversaw UAT processes with the testing team, conducted statistical analyses, and ensured high-quality data migration with stringent data validation protocols.

•Fostered internal communication and collaboration, acted as liaison for external stakeholders, managed project backlogs, resolved conflicts, and facilitated effective team adaptations to changes.

•Forge strong ties with freight and parcel vendors for prompt and accurate handling of 4Patriots Products. Assess vendor performance, aid in contract talks, and enhance reliability and quality measures.

•Help establish KPIs for logistics monitoring, analyze data, and generate reports on transportation costs, inventory, delivery, and other metrics. Identify improvement areas and take corrective action as needed.

•Ensure adherence to regulations like transportation and import/export standards. Mitigate risks and enact contingency plans for potential disruptions in the 4P supply chain.

• Applied fundamental Python skills to manipulate and analyze datasets using libraries such as Pandas and NumPy, aiding in the completion of academic projects and basic data exploration tasks.

• Developed introductory-level scripts to automate routine tasks, such as file organization and data extraction, enhancing productivity and learning automation principles.

•Guided development teams in Agile practices towards higher maturity, managed client relationships, facilitated meetings for business requirement capture, and translated informal requirements into formal documentation.

•Engaged continuously with development and QA teams during all application development phases, ensured adherence to project schedules, and facilitated the implementation of manual testing strategies.

•Created and maintained essential documentation (BRDs, FRDs, etc.), managed the Help Desk Team, resolved operational issues, and conducted user training for department officials and end users.

•Executed Gap Analysis, created use cases and process flow diagrams, assisted in project documentation such as status sheets, plans, and timelines, and trained internal teams on new functionalities with demos.

PROFESSIONAL EXPERIENCE (Continued)

Notable Achievement:

•Successfully overhauled the documentation workflow, introducing a suite of clear and comprehensive reporting protocols that significantly bolstered communication channels between our team and clients, which was instrumental in elevating client satisfaction by 20% and substantially enhancing project transparency across the board.

BUSINESS ANALYST Letzbank Hyderabad, India Apr 2015 – Jun 2016

Project Overview: Letzbank streamlines the search for suitable banking products, from personal to business loans, by aggregating offerings from top financial institutions nationwide on its platform. The portal www.letzbank.com presents comprehensive loan details—interest rates, terms, fees, and repayment options—in a comparative format, simplifying decision-making with minimal customer input required. This approach ensures an efficient, informed loan selection process for consumers.

•Conducted a feasibility study and prepared a High-Level Business Requirement Document (BRD) for the department, acting as a liaison between department officials, end users, and IT service providers.

• Executed basic SQL queries to retrieve and manipulate data from relational databases, supporting the team in generating reports and insights.

•Assisted in the maintenance of database integrity and performance by performing routine tasks such as data cleaning and indexing.

•Utilized requirement elicitation techniques to capture and translate informal departmental needs into formal documentation, including Requirement and Change Request Documents, Wireframes, BRDs, and User Manuals.

•Managed project scopes and timelines through agile practices, enhanced team communication, meticulously analyzed user needs for targeted software solutions, and facilitated IT quality control with detailed, insightful reporting.

•Engaged in every development phase, maintaining ongoing communication with both technical and non-technical vendors and executing functional and black box testing for departmental applications.

• Developed simple Python scripts for automating routine tasks and basic data handling, improving team efficiency by automating repetitive processes.

• Performed foundational data analysis using Python, leveraging libraries like Pandas and NumPy to clean and manipulate datasets for preliminary insights.

•Served as the main point of contact for external communications with customers or stakeholders, collaborated with product owners to manage backlogs, and ensured sprint deliverables met quality standards.

•Handled data import and report creation using MS-Visio, conducted user training for department officials, executed gap analysis, and facilitated user acceptance testing and application deployment.

Notable Achievement:

•Secured client trust and expanded business portfolio at Letzbank, resulting in a significant and remarkable business growth through strategic stakeholder engagement and fostering high approval rates from banking partners.

CERTIFICATIONS

Google Data Analytics Certification Coursera

Python Programming: Everyday Learning Coursera

Python Data Structures Coursera

The Complete SQL Bootcamp Udemy

Microsoft Power BI Desktop for Business Intelligence Udemy

Google Project Management: Professional Certificate Coursera

Netsuite Suite Foundation Oracle Netsuite

EDUCATION

Master of Information Management Systems, 2018

UNIVERSITY OF HUDDERSFIELD, UNITED KINGDOM

Bachelor of Engineering in Computer Science, 2015

SATHYABAMA UNIVERSITY, CHENNAI, TAMIL NADU, INDIA

TECHNICAL SKILLS

SDLC Methodologies: Waterfall, Agile, V-Model

Data Management Tools: Tableau, Power BI, Snowflake, SQL, ERP Netsuite

Programming Skills: OOP, Database Operations (SQL), Python

Documentation Expertise: BRDs, Wireframes, UML Diagrams

User Acceptance Testing (UAT) Black Box Testing Methodologies A/B Testing

Presentation Skills: Communicating Technical Concepts Clearly to Stakeholders

Google Suite: Gmail, Docs, Slides, Drive, Spreadsheet, Presentations

Microsoft Office Suite: Word, Excel, Access, PowerPoint, SharePoint, Outlook, Teams, OneNote, Forms

Social Media: Facebook, Instagram, Twitter (X)

Contact this candidate