Consultant Resume
SUMMARY:
Seeking a challenging position to utilize 4 years of agile experience in data and business analysis providing valuable insights, creating interactive data visualization dashboards in Tableau, generating reports in Excel and Tableau, ability to gather, document, and analyze business requirements, and help design a process solution to implement system enhancements to align the current state of system with new requirements. Technically proficient with SQL, analyzing large data sets, recognizing data trend and patterns, business requirement documents, flow charts, user stories, tableau, and reporting.
TECHNICAL SKILLS:
- SQL
- Data Analysis
- Data Trend and Patterns
- Data Cleansing
- Data Mapping
- Data Governance
- Data Quality/Validation
- Data Flow Charts (MS Visio)
- Oracle (SQL Developer)
- Teradata (Teradata Studio)
- Hadoop Hive (Squirrel)
- Tableau (Dashboards)
- Reporting (Excel and Tableau)
- JIRA
- VLOOKUPs
- Pivot Tables
- Macros
- MS PowerPoint
- MS SharePoint
- MS Word
- MS Visio (Data Flow Charts)
- HP Quality Center 10.1
- Liaison (IT & Business)
- SDLC - Agile Methodology
- Requirements Gathering (BRD)
- Key Performance Indicators ( Confidential )
- Monitoring Data
- User Stories (JIRA)
- Adaptive Learning
- Project Coordination
- User Acceptance Testing (UAT)
- Test Cases
- Data Management
PROFESSIONAL EXPERIENCE:
Confidential
Consultant
Responsibilities:
- Involved in Agile Methodology system development to gather, review, and analyze business requirements from stakeholders through open-ended discussions and brainstorming sessions to understand the business rules and needs.
- Authored business requirement documents and helped transition the requirements into detailed design oriented functional and technical definition.
- Acted as a liaison between technical team and stakeholders to become an essential part of business development team efficiently working hand-to-hand with product development to implement business requirements and deliver highly sophisticated but robust retail software to the client.
- Developed and executed SQL queries against Oracle and big data, Teradata and Hadoop Hive, database to extract data for analysis and reporting.
- Monitored the collection of data containing information about inventory, sales, finance, assets and events, and cleaned it for further analysis
- Performed data analysis using SQL Developer, Teradata Studio, and Squirrel SQL to study the data patterns and trend in complex data sets, and developed dashboards and visualization in Tableau to present valuable insights
- Responsible for data governance, data sourcing, data mapping, data profiling, and data quality checks to identify data issues and gaps, and propose technical solutions
- Worked extensively with Excel using tools such as VLOOKUP's, macros and pivot tables
- Generated weekly and monthly reports in Excel and Tableau to provide Key Performance Indicator ( Confidential ) measures.
- Excellent in preparing UML diagrams - Use cases, Sequence diagrams, Data Flow Diagram and Process Flow Diagram, Business process modeling and Business Flow Diagrams using MS Visio .
- Created and maintained User Stories in JIRA to track all business requirements. Worked with Core Team (comprised of Business and IT contributors) to groom user stories and assign story points.
- Conducted sprint sessions, daily stand ups, tracked user stories to display exceptional project coordination skills.
- Presented enhanced system changes to stakeholders post each sprint using MS PowerPoint and Tableau Dashboards
- Versed with predictive analysis using historical data to identify key customer attributes to predict customer behavior.
- Well versed with test cases, test plans, test scripts and test data and verifying the unit testing results
Environment: Agile, SQL, MS Excel, Tableau, JIRA, Oracle, Teradata, Hadoop Hive, Analysis, MS Word, MS PowerPoint, MS Visio
