SUMMARY

• A dynamic professional with 7 years of experience in IT as a Business Analyst.
• Highly motivated, result oriented Business Analyst professional with good knowledge of technical codding and Data warehousing, comprehensive experience in managing small to complex project. Dedicated team leader with the ability to introduce creative collaboration and establish clear lines of communication to achieve project goals.
• Proficient in end to end development of software products from requirement analysis to system study, designing, testing, documentation, implementation, and delivery management.
• Solid complete understanding of SDLC & QALC.
• Knowledge in Waterfall and Agile methodology.
• Engaged in various end user technical and functional business process development that helped the groups, department and organization to achieve cost - effective output along with best quality and efficiency.
• Lead the JAD sessions, information gathering, data analysis, documentation and converting functional to technical requirement. Have end-to-end experience to deliver business & business users need in terms of ‘Data’ and ‘Data Products’ in enterprise data warehouse environment (EDW).
• Hands on creating Epic and User stories in JIRA.
• Proficiency in preparation and execution of Test plans, test conditions and test cases.

TECHNICAL SKILLS

Methodologies: Agile, Waterfall, Scrum, SDLC

Web Technologies: HTML

Testing Tools: HP QC, Quick Test Professional (QTP)

Other Tools: Microsoft Office (Word, Excel, Outlook, PowerPoint, Visio)

Operating Systems: MS-DOS, Windows 95/98/00/XP/win7, Vista/Win8/10

Databases: SQL Server, Teradata, Oracle,DB2, MS-Access

BI Tools: IBM Cognos, Tableau, Crystal report

PROFESSIONAL EXPERIENCE

Confidential, San Carlos, CA

Sr. Analyst

Responsibilities:

• Working independently to gather, formulate and define requirements to solve business problems.
• Working independently to interpret client requirements into documented system requirement specifications in accordance with approved standards and procedures.
• Translate high-level functional business requirement to detail technical specifications to get efficient turnaround of projects along with manages changes to such specifications.
• Guide, monitor and work with other analysts.
• Create Business Requirement document (BRD), Functional Requirement document and maintaining the Requirement Traceability Matrix (RTM) related document.
• Experience in implementing the SDLC and Agile processes for multiple projects.
• Investigate data issues and root cause analysis and resolutions.
• Generate professional documentation for requirements, design, development, and testing.
• Communicate with internal staff (Production, Operation, Supply Chain, Finance, HR), suppliers and clients as required to deliver development solutions.
• Coordinate between business and technical personnel to ensure a mutual understanding of process, applications and manage a product backlog.
• Reach out to other groups and users communities to see if current project may help them as well to achieve multiple goals with single effort.
• Working closely with the project management team to analyze and consolidate requested requirements to improve the decision planning process and meeting project deadlines.
• Conduct stakeholder Joint Application Design (JAD) interviews and facilitated meetings with project team members whenever needed.
• Consolidate input from multiple channels to solidify detailed feature requirements through user stories and/or functional specifications.
• Manage User Acceptance Testing (UAT) planning, documentation, tester training including UAT completion sign-off.
• Update design and technical specification documents for on-going BI applications (report, cubes and dashboard) modifications.
• Provide weekly accomplishment/status report to management.
• Organize and attended daily stand up meeting.
• Very good knowledge of data warehousing environments & ERP System.
• Research, analyzed, design and implemented appropriate Cognos data packages for business users based on any outstanding / future requests.
• Maintain knowledge of client data models and data dictionary for the purpose of maintaining Cognos packages and enhancing user awareness of business data.
• Created and updated Report Data column mapping to database tables and columns documentation.
• Hands on in Data Modeling using Cognos Framework Manager.
• Experience in the support and development of data analysis frameworks that support operational reporting and executive dashboards.
• Build, manage and maintain data models for BI team Strong knowledge of database querying and ETL processes.
• Exposure to HDFS Architecture & HiveQL.

Environment: SQL Server 2008, Cognos 10.2, Report Studio, Query Studio, Framework Manager, INFOR LN, Agile methodology, JIRA, Hadoop, Hive

Confidential

Business Analyst

Responsibilities:

• Worked with business and delivery teams as a Business Analyst and gathered requirements to post and update the user community portal.
• Created Excel reports and dashboards merging data from diverse data sources.
• Experienced working and managing offshore teams to deliver the projects.
• Experienced in documentation of business requirements and needs.
• Hands on Development of visualization and presentation material.
• Interacted with the business team to identify, validate, and document business needs, requirements, and plans.
• Turn business needs, requirements, and plans into solution models and roadmaps.
• Managed small to large initiatives, create proof of concept (POC)
• Added and edited slide show using HTML code.
• Prepared and posted new announcement, events, and meeting on CITSA Community portal.
• Scheduled meeting agenda and prepared presentation for meetings.
• Worked in a demanding environment which required a management of multiple stakeholders.
• Responsibilities included the interfacing with stakeholders and business, understand their requirements and concerns and came up with multiple solutions.
• Attend the meeting when required and provides the meeting minutes to the participants.
• Gathered, analyzed and translated business requirement for Tableau visualization/dashboard reporting needs.
• Act as a liaison among IT and Business communities.
• Provide ad-hoc data and report requests for Tableau.
• Query and report key metrics and actionable insight utilizing Tableau, Excel, SQL skills and other business intelligence software to leadership team.
• Responsible for translating BRD into functional specifications and test plans. Closely coordinated with both business users and developers for arriving at a mutually acceptable solution.

Environment: HTML, JAVA, Confidential JABBER, MS Office (Excel, Word. Power Point, Visio), Adobe Photoshop, Tableau Desktop

Confidential, Alameda, CA

Sr. BI Analyst

Responsibilities:

• Analyzed client’s business requirements and processes by analyzing documents, interviews, workshops, and workflow analysis.
• Created and delivered HR reports, dashboard and analyses for senior and executive level audiences.
• Contributed to the development of automated reporting solutions.
• Proactively recommended and sourced HR data/information.
• Acted as lead member of the HR BI & Reporting team.
• Provided Data management including complex reporting required by business leaders.
• Liaised with HR community to identify, design and develop value added processes and report support.
• Supported other projects and initiatives related to data, analytics and reporting in absence of designated Project manager or business analysts as back up.
• Experienced in capturing and presenting all levels of Enterprise Metadata.
• Worked on multiple large complex projects with cross functional teams and business simultaneously.
• Possessed good knowledge of Database & Data warehouse design, architecture and operation.
• Worked with end-users and stakeholders to define and document reporting requirements for initial reports and to enrich reporting capabilities.
• Communicate client’s business requirements by constructing easy-to-understand data and process models.
• Worked closely with stakeholder group to determine priority of requirements based on business directions.
• Involved/attend a range of scrum sessions, including backlog refinement, sprint planning, sprint retrospective, story pointing as well as other ad hoc meetings.
• Conducted stakeholder Joint Application Design (JAD) interviews and facilitated meetings with project teams.
• Facilitated monthly meetings with clients to document requirements and explore potential solutions.
• Met with key account managers, payroll managers, customers, and internal management to explain reports and report findings.
• Worked with the various departments to assist in UAT and support proper change management.
• Created and delivered full sign-off project documentation starting from development and ending at post-Production deliverables.
• Supported end users \ group \ department for Cognos BI reports and Crystal reports requirements.
• Validated the report data against the data entered in ULTIPRO for HR and Payroll reports.
• Good knowledge of UltiPro HRIS system.

Environment: Cognos 10.2.1, SQL Server, Crystal Report, Business Object, Ultimate Software (ULTI PRO).

Confidential, Sunnyvale

BI Developer/Analyst

Responsibilities:

• Responsible to deliver visualization reports to engineering and finance groups.
• Partner with other IT teams in defining and designing target state architecture by combining knowledge of what the business wants with knowledge of how the systems are built.
• Interface with users to determine needs, uses and specifications of data requests and conducts detailed analysis of data requirements.
• Assisted in the design and implementation of solutions in all phases of the development lifecycle.
• Created detailed Data Mappings through all stages of data life cycle.
• Presented findings and recommendations to identify gaps or issues, explained the root cause, documents the impact, and present options for resolution and change.
• Served as liaison between IT and business end-users, worked with development team to ensure that they understand the specifications.
• Identify, assess, and document business requirements, recommending business priorities, and advising business on options, risks, and costs.
• Worked with scrum master to ensure that there are suitable stories to take into the sprint process.
• Identify and reconcile errors in client data to ensure accurate business requirements.
• Conducted demo session for business and product owners.
• Drafted and maintained business requirements and align them with functional and technical requirements.
• Created and delivered full sign-off project documentation starting from development and ending at post-Production deliverables.
• Interface with executive and their associate along with group of engineers, leads, product managers and analysts to understand data and report \ views requirements.
• Proactively communicate with various product/business/engineering teams for creating, modifying and fine-tuning KPIs/metrics/dimensions for existing, new and changing business/product needs.
• Wrote supporting functional specification and design documents.
• Worked in a team and with offshore team during the project.
• Experienced in developing interactive dashboards for business reporting needs
• Hands on to develop analytical reports per business needs.
• Developed reports and Dashboard using Tableau 7.0., 8.1.
• Developed visually informative dashboards, customized reports based on business requirements.
• Created Workbooks and published in Tableau Server.
• Worked on performance tuning of the views/dashboards.
• Ongoing support to application running in production & troubleshoot.
• Ability to write efficient & custom SQL statements for reports, analyze data to identify for data inconsistencies and fix.

Environment: Teradata 14.0, Tableau 7.0, 8.1/2, Agile, JIRA

Confidential, San Francisco

Business Technology Consultant

Responsibilities:

• Worked as technical and functional member in BTC - IT.
• Work with business users to translate requirements into data visualizations.
• Understand the business requirements and identified gaps in different processes and implemented process improvement initiatives across the business improvement model.
• Planned, facilitated and reported on quality assurance testing efforts.
• Perform ad hoc analysis to support business decisions.
• Interacting with Sales director and other executive to build decision support system \ application as per their requirement.
• Worked with users to troubleshoot system, model and report issues for TM1.
• Write and maintain complex TM1 business rules to provide additional reporting and analysis capabilities.
• Research Collect, process and develop sales data into standardized reporting system (Report, Cubes, OLAP and Ad-hoc reporting).
• Write SQL statement to verify and troubleshoot report data.
• Supporting end users \ group \ department for Cognos BI reports, FM models, DMR, Cubes and Reports create out of Cognos cube (Transformer).
• Troubleshooting existing BI application (Cognos cubes and reports).
• Fix high priority ticket as well as one day ticket fix (Urgent ticket).
• Building BI application (Reports and OLAP cubes) on the fly on demand.
• Interacting with users for their day to day need and support.
• Migrating application to production and be on call 24*7 supports.
• Prepared and presented dashboard using Cognos report studio and Tableau.
• Prepared and demonstrated various Tableau Dashboards for Clients from disparate data sources.
• Created Workbooks and published in Tableau Server.
• Analyze, design, implement, BI reporting solutions using Tableau.
• Develop relevant functional and technical documentation.

Environment: TM1, Cognos BI 8, Oracle, SQL Server, Apex system, Nielsen, Hyperion, Tableau