SUMMARY

• Over 7 years of experience in information technology involving Business and Data Analysis, Data Profiling, Data Migration, Data Integration and Agile/Scrum methodology
• Proficient in working with business user, SMEs and other stakeholders to gather and understand businessrequirement
• Experience in creating business requirement document, functional and non - functional specifications, data flow diagrams, business process diagrams and user Stories
• Experience in conducting and facilitating agile ceremonies: daily scrum, sprint planning, sprint review and retrospective and strong understanding scrum artifacts: product backlog, sprint backlog and increment and; sprint burndown chart
• Experience in data modeling with expertise in creating Star &snow-flake schemas, FACT and dimensions tables, physical and logical Data Modeling using Erwin
• Experience in working with ETL environments like SSIS, Informatica and reporting tools like SQL Server Reporting Services (SSRS), Cognos and Business Objects
• Experience in development of Process Flow Diagram, Use Case Diagram, Activity Diagram, and Database schema generation using UML tools likeVisio and Oracle SQL developer
• Experienced in Cloud Services such as AWS EC2, EMR, RDS, S3 to assist with big data tools, solve data storage issues and work on deployment solution
• Ability to understand current business process and implement efficient business process
• Experience in writing complex SQL queries to perform data completeness, correctness, data transformation and data quality verification for source to target mapping
• Experience working with Alteryx - Data Analytics and python programming
• Strong understanding of Requirement Traceability Matrices (RTM) to ensure that all the requirements are covered by the test cases
• Experience in conducting Joint Application Development (JAD) sessions with Business users, Subject Matter Experts (SME's), Development and QA teams
• Excellent planning, communication and interpersonal skills
• Expert in problem solving skills with the ability to think creatively and strategically about alternative solutions and opportunities

TECHNICAL SKILLS

Languages: SQL, Java, Python, HTML, UNIX

ETL Tools: Informatica PowerCenter, Ab Initio, Alteryx

Operating Systems: LINUX, UNIX, Windows

Databases: Oracle, Teradata, SQL Server, MS Access

Packages: Toad, SQL Developer, SQL PLUS, WINSQL, SQL Loader

CI/CD: GitHub, Jenkins

PROFESSIONAL EXPERIENCE

Confidential, Dallas, Texas

Business Data Analyst

Responsibilities:

• Created business document and user stories, and reviewed acceptance criteria for various pricing and fare related software development projects
• Participated in backlog grooming sessions, identified obstacles, planned releases and assisted in managing sprints and product releases
• Created Data flow diagrams, Business flow diagrams, Use Case diagrams, Class, Activity and Sequence diagrams to present a better view of the systems
• Conducted workshop, JAD sessions and inception meetings with stakeholders and end-users for requirement analysis
• Analyzed and reviewed requirement documents, prepared user stories and help createand review test cases for various projects
• Defined and documented Source to target data mappings, business rules, business and data definitions
• Worked with DBAs to define the modeling requirements, change implementation and in resolving performance and other issues
• Wrote and executed complex SQL queries to analyze fare data and to verify data correctness
• Extensively used Informatica Power Center for Extraction, Transformation and Loading process
• Scheduled Cube Processing from Staging DB Tables using SQL Server Agent in SSAS
• Created SSIS package to load data from Flat files, Excel and Access to SQL server using connection manager
• Created data transformation task such as BULK INSERT to import data
• Responsible for transforming data from OLTP to OLAP data sources using SSIS
• Assisted Business acceptance testing with the Data Needs
• As a part of scrum team, participated in all agile/scrum ceremonies and assisted with the story grooming and writing acceptance criteria
• Used Alteryx for analyzing and validating large volume of fare data
• Worked closely with business users, business analysts, software developers, QA teams, and project leads to ensure successful roll out of quality application
• Utilized PowerPoint presentations while conducting walkthroughswith the stakeholders and Conducted/participated in various demo Sessions
• Worked closely with Production support team and Provided post production support by monitoring applications and their performances and reported issues (if any)

Environment: Visio, Windows, AWS, MS Excel, SharePoint, PowerPoint, MS Project, Oracle SQL Developer Erwin, Business Objects, MS Outlook, PL/SQL, Alteryx, Jira, Python, dB Visualizer, IntelliJ, Informatica

Confidential, Dallas, Texas

Business data Analyst

Responsibilities:

• Created business requirement document and functional requirement document by gathering requirements through frequent discussions with the business users and SMEs
• Documented the Source to Target mapping documents with data transformation logic
• Wrote user stories and created process/Data Flow diagrams and flowcharts using Visio
• Wrote and executed complex SQL queries for accessing, analyzing and manipulating the schedule data
• Facilitated various workshop and session to identify business rules and requirements
• Worked closely with QA teams and developers to clarify functionality, debug, resolve and track issues
• Assisted QA teams with test plan and test cases reviewand test data requirements
• Involved in Normalization/De-normalization techniques for optimum performance in relational and dimensional database environments
• Worked on data profiling and data validation to ensure the accuracy of the data between the warehouse and source systems
• Created user training documents to helpuser understand the new applications and functionality
• Built and customized interactive reports and dashboards reports using Tableau
• Worked with cross functional team to generate backlogs, capture them in JIRA, and worked against the committed backlog against the Sprint delivery schedule

Environment: PL/SQL, SQL Developer, MS Project, Business Objects, MS Office, SharePoint, PowerPoint, MS Visio, MS Outlook, AWS, Tableau, Agile, JIRA