Data Analyst/ Business Analyst Resume
Tempe, ArizonA
SUMMARY
- An Independent, Enthusiastic, and Focused business graduate wif four years of work experience in statistical data analysis, data reporting, and project management.
- Combined strong passion for business and information technology to attain the goals of the organization.
- Demonstrated ability to envision, document, and communicate end to end solutions for business constraints and limitation.
- Capable of effectively working independently as well as in a cross - functional team environment, to deliver exceptional results for stakeholders.
- Skilled in Data Mining, Statistical Data Analysis, Advanced Excel (Pivot Tables, Macros, Formulas, Forecasting, etc.), Databases, Tableau, Agile SDLC, Project Management, Data manipulation, and Reporting.
TECHNICAL SKILLS
SDLC Methodologies: AGILE, WATERFALL, SCRUM, KANBAN, XP.
BI/ Reporting tools: Tableau, Power BI, Qlik View, ODI, SOA.
Databases/ETL Tools: SQL Server 2008,2010,2012, MS Access, Oracle SQL ETL Tools - ODI, SOA
Programming Languages: C, Java, Python, R, UML, HTML, XML, CSS XML
OFFICE / Project management Tools: MS Project, MS Word, MS Excel, MS PowerPoint, MS Access, MS VISIO, ServiceNow, SharePoint, Jira, CONFLUENCE
Operating Systems: Windows 2000/2003/XP/Vista/7 and UNIX
PROFESSIONAL EXPERIENCE
Confidential - Tempe, Arizona
Data Analyst/ Business Analyst
Responsibilities:
- Define key performance indicators for monitoring day-to-day business health in partnership wif the executive team.
- Conducted analysis to optimize existing channels and businesses and identify new opportunities for growth.
- Coordinated wif consultants to collect and organize data from unstructured and unformatted source files.
- Executed high quality data cleaning/merging/analysis of web application analytics, logs from the project management repository.
- Made realistic assumptions of data processing steps or when data is not available
- Leveraged Business Intelligence ToolTableauand MS Excelto create dashboards, reports and alerts to develop effective and informative visualizations
- Translated and documented the findings into business terms and actionable guidance
- Engaged wif key stakeholders at all levels to update them of important findings
- Created and implemented ad-hoc reports as requested by writing SQL queries and manipulating data inMS Access and Excel.
Confidential
Data Analyst/ Business Analyst
Responsibilities:
- Experienced as a Business Analyst wif expertise in all aspects of the software development life cycle such as agile.
- Functioned as the primary liaison between the business line and the technical areas.
- Experience in working wif an onsite and offshore business model.
- Experience in documenting the functional and technical requirements.
- Expertise in building the UML diagrams such as Use case, Class, Activity, State, Sequence, ER diagrams leveraging MS Visio, MS Access and ArgoUML.
- In-Depth understanding of Gap Analysis, Cost-Benefit Analysis, Risk, Impact, Return on investment, Feasibility, and root-cause Analysis of various business processes.
- Created reports, dashboards and Sophisticated Visualizations by using Tableau and Microsoft Power BI, to explain and communicated data insights, significant features, model's score and performance to perfectly elucidate for both technical and business teams.
- Designed the Star Schema to support EDW / BI reporting for Sales, Orders, Invoices, Product Returns, Customers, Warehouse, Shipments and promotions.
- Experience in designing Tableau dashboards wif large data volumes from various data sources like Oracle, databases, Spreadsheets and R Programming (Data Refining).
- Reviewed, monitored and documented ETL process for high volume data integration between multiple sources in production environment using Oracle Data Integrator.
- Experience in data mapping, data analysis and creating reports using Oracle SQL database, MS Excel and visual studio.
- Effectively analyzed and cited root-cause analysis and KEDB reports.
- Experienced in incident, problem, and change management in ServiceNow and resolving issues wifin SLA.
- Experienced in using project management tools like JIRA, MS Project, and CONFLUENCE for task assignment, tracking user stories, monitoring issues, and document sharing.
- Managed Kanban board to simplify the workflow of sprint tasks and encourage self-organization in the team.
- A balanced blend of Business, IT, leadership and Project management skill wif strong in-depth and breadth of experience wif multiple industry, technologies, tools, frame works and processes.
- Communicated effectively wif all levels of management, stakeholders and development team.
- Led a point of contact for the POS related interfaces and fixed critical issues wifout production loss.
- Proactively removed or escalated, impediments, roadblocks to allow team progress.
Confidential
Data Analyst/ Business Analyst
Responsibilities:
- Gained extensive business knowledge by dealing wif various business clients.
- Worked closely wif the development team to verify dat business needs are fulfilled, and deliverables are produced wifin specified budget, quality, and time.
- Gatheird business requirements, developed project baseline, WBS& Gantt chart to meet the deadlines using Microsoft Project.
- Defined milestones, created activity, state, and dataflow diagrams using Microsoft Visio. Managed budget to maximize the profit by 40% in the allotted duration of time.
- Developed Interactive Dashboard for CVS management to analyze the reports using SQL, R programming, Tableau Desktop, Excel.
- Designed set of automated procedures to run the daily reports on time and analyzed the reports using SQL, MS Excel, MS Access.
- Proficient in designing and handling SQL databases, DB tables, views, store procedures, functions, triggers, Join and, Subqueries to assist efficient data manipulation and data consistency and used DDL and DML commands for various business application.
- Hands-on development experience in IBM Tririga - by utilizing Data modeler, Form Builder, Workflow Builder, Report manager, Portal builder.
- Extensively worked on Tableau and Qlik View to develop the visualizations for the reports.
- Documented the scenarios and worked closely wif QA teams to define test cases.
- Documented, compiled, and maintained all business and technical requirements using SharePoint.
- Organized meetings via WebEx and face to face, documented action items and minutes.
- Provide ongoing coaching and mentoring to project team members.
Confidential
Data Analyst/ Business Analyst
Responsibilities:
- Worked on a “online Confidential system” web application.
- Involved in all the phases of SDLC from requirement gathering to deployment.
- Worked and gained knowledge in Waterfall methodology.
- Worked wif datasets of varying degrees of size and complexity including both structured and unstructured data.
- Participated in all phases of Data mining, Data cleaning, Data collection, variable selection, feature engineering, developing models, Validation, Visualization and Performed Gap analysis
- Extensively used MS Excel and Xl Miner for the statistical data analysis.
- Designed the database by applying the Normalization concepts.
- Developed the database and performed CRUD operations to obtain complex data from tables, using MySQL in SQL Plus IDE.
- Incorporated the processes and the workflows from planning to documentation to increase efficiency in a real time corporate industry.
- Extensive knowledge in Data Warehouse development - Data Marts, Operational Data Store (ODS), OLAP, Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling for FACT and Dimensions Tables, starting from inception to implementation and ongoing support.
- Designed and implemented dimensional modeling wif Star & Snowflake schemas and Involved in development of DW / BI architecture using ETL process for an online lifestyle & clothing retail store.