SUMMARY

• Analyst professional with 5+years of experience in business system, Data Analysis and project management
• Responsible for defining, analyzing and documenting business and functional requirement
• Elicit business needs and translate those needs into requirements
• Trained on Software Development Lifecycle(SDLC) - Waterfall/Agile Methodologies, requirement gatherings techniques, SQL Data Analysis
• Applies appropriate tools to analyze and document including epics, user stories, use cases and system specifications
• Documents and analyzed functional business requirement, creates specifications
• Experience in Business IT Systems, business process and project management.
• Coordinate ongoing user support for ad hoc questions, inquiries, and service requests.
• Reporting and data tools for supported business area use and for trend analysis.
• Prepared and maintained MS Excel Database reports and related communications.
• Ability to manage multiple priorities, work independently and meet deadlines.
• Understands technical IT resources and translates/documents information into requirements for technical and non-technical audiences
• Work with Application SMEs to document behavioral and passive data models across applications following UML
• Proficient in BI tools-Qlickview, Qlicksense, Tableau 10.3 dashboards, graphs for data visua-lization
• Effectively engage and partner with cross-functional teams to create and deliver solution
• Sound communication skills, team/stakeholders meetings, MS power point presentation
• Certified professional in business process and data management helps better business decision making

TECHNICAL SKILLS

Project Management: SDLC-Waterfall, Agile/ Scrum, RUP, Six Sigma, Kaizen, TQM

Requirement analysis: Use Case, SWOT analysis, BRD, FRD, Rally, IBM Rational

Operating System: Windows 7, 8. 0, 8. 1, 10 MAC OS X, Linux

Software tools: SharePoint, MS Project, Excel, PowerPoint, MS Visio, Skype for Business, Oracle SQL, Tableau 9.1 Load Runner, JIRA, Qlickview, Qlicksense, Crystal Report

PROFESSIONAL EXPERIENCE

Confidential

Business Analyst

Responsibilities:

• Responsible for defining, analyzing and documenting IT business systems in SDLC project environment
• Works in Oracle SQL assists in delivering consolidated, consistent and data report across the enterprise and distributes this master information to Citi operational and analytical applications
• UtilizedTableau BI 10.1 to design real time dashboards/charts data analytical decision
• Experience in matching, merging and cleansing the data sets using complex SQL queries
• Identifying unique customer details from different source systems in data warehouse
• Migrated data from legacy system to new system through SQL Server 2016 and completed
• Published reports and dashboards designed inPowerBIutilizingPowerBIservices and shared it across through Microsoft Office 365.
• Used JIRA software to share user stories and communication project status
• Designs UML workflow diagrams across applications for Businesses for report generation.
• Created epics, user stories, use cases and system specifications
• Process Mortgage industry client data utilizing loan origin system
• Used SharePoint for team collaboration and sharing client files, creates Visio workflows
• Lead requirements validation and traceability analysis uses JIRA/SharePoint for team communication and collaboration
• Documents and analyzed functional business requirement, creates specifications
• Prepares minutes of meeting/presents in monthly team review meetings
• Advanced skill on MS Excel 2013/16 (VLOOKUP, pivot tables, Formulas, filters, Graphs)

Confidential

Business Systems Analyst

Responsibilities:

• Eliciting, documenting, prioritizing business requirement using Rally software
• Involves in mortgage credit data analysis and audit, Datawarehousing, profiling & Dataflow across applications for Businesses using SQL
• Prepares data requirements, including epics, user stories, use cases and system specifications
• Creates Qlickview/Qlicksense - dashboards, graphs for data visualization/reporting
• Process Mortgage industry client data utilizing loan origin system
• Used SharePoint for team collaboration and sharing client files, workflows
• Reviews and analyzes a variety of forms, documents, reports, data output, and record-keeping requirement
• Works with teams (including IT, Business, Marketing, and Capacity Planning)
• Gather/documents business requirements from business users and subject matter experts SMEs
• Creates MS PowerPoint and creating customized presentations that are clear and easily understood by the audience
• Perform business process workflow design in conjunction with operations teams;
• Manage scope and requirements throughout the project lifecycle;
• A team player who works well with technical and non-technical resources
• Analyzes input and data using MS Excel, Visio and Oracle SQL applications
• Advanced skill on MS Excel 2013/16 (VLOOKUP, Macros, Formulas, Tables, Graphs)

Confidential

Data Analyst

Responsibilities:

• Confidential is the largest US automobile retailer. The data entry position provides the dealer trade division with correct data and necessary reports using SQL Server and MS Excel spreadsheets.
• Provide support for ad-hoc requests and small projects from Customer Experience team and Business Analytics Manage
• Keep up-to-date documentation of processes, data sources, tables and fields
• Gained knowledge on financial statements, cost-benefit analysis, Case development
• Performed requirement gathering session in analysis of data.
• Performs datawarehousing, mapping, profiling, ETL, integration, distributeddatafile systems
• Prepared Business Requirement Document (BRD) functional specification document (FRD), Traceability matrix to ensure efficient software development
• Provide support for ad-hoc requests and small projects from Customer Experience team and Business Analytics Manager
• Gained expertise in Use cases, user stories, story points, Epics, UML Diagrams
• Analyzes input and data using MS Excel, Access and Oracle SQL applications
• Advanced skill on MS Excel-Pivot, VLOOKUP, Macros, Formulas, Tables, Graphs
• Creates, modifies and troubleshoots SQL Queries, stored procedures and jobs.
• Converts, manipulates large volumes of data, uses JIRA/SharePoint for team communication and collaboration
• Perform testing, test scenarios, user stories and use cases, UML diagrams
• Strong communication skills - knowledge of grammar, spelling and punctuation
• Creates Excel Charts and PowerPoint presentation for better data visualization