SUMMARY:

• 14+ years of hands - on experience (with around 10 years Cisco experience) as a Business/ Data Analyst, IT Analyst, SAS Analyst, SME
• Expertise in business planning, business analysis, business process management, requirements gathering, data analysis and resource management etc. Proficient in understanding Business processes requirements and translating them into Business Requirement Document
• Business engagements: Participating in business process reviews, understanding the business strategy. Providing solutions and recommendations to process issues as well as potential business initiatives. Proactively partnered with the stake holders to evaluate business needs including consulting in the development of BRDs
• Very strong experience in requirements gathering, functional gap analysis, defining scope, application design, configuration, module setup, writing training guides, providing training and production support.
• Possess excellent analytical skills along with strong data analysis abilities working extensively on data quality management
• Extensive experience in preparation and Review of BRD, FSDs, Gap Documents, Use cases, UML docs, Test Strategy and Test Plan Documents. Proficient in creating sequence diagrams, activity diagrams, Visio data flow diagrams and writing algorithms. Participation in SIT/BAT complete support in UAT
• Working closely with technical team. Involved in the End-to-End process of design and implementation of Customizations, Interfaces. Assisting with overall team management, communications and maintaining positive client/consulting team relationship.
• Reporting to senior Management and providing regular status and risk assessments.
• Effective communication skills and leadership skills to develop a creative solution for challenging client.
• Extensive experience with MS project, MS PP, MS Access, MS Excel, Formulas/Macros/Pivot tables, MS Visio for work flow, swim lane diagrams
• Experience with sharepoint, Tableau report development
• Experience with Mac products and applications
• Excellent Client handling and customer interaction skills.
• Excellent communication and presentation skills.
• Key team member and very good team player. Problem solver. Strong leadership skills.

PROFESSIONAL EXPERIENCE:

Confidential, San Jose, CA

BI Data Analyst/ Tableau Developer

Responsibilities:

• Interacting with the Business team to understand the requirements, implement agile methods for quick delivery
• Create and maintain documentations: BRD, User stories, Testing docs, Data mapping Docs etc
• Working on SW services migration project with install base, pricing and opportunity data
• Data analysis and gap analysis between different systems
• Work with technical team on ETL development
• Tableau reporting: Structure, develop and create dashboards for CSC reports, data visualization in Tableau.
• Content management on CSC portal
• Google Analytics: Reporting and data pull for systematic reporting dashboar

Technology:Back end: Teradata, Informatica, SQL, MDM dat, Unix, Python, Hadoop, Qlickview

Front end Tools: Hadoop Business rules manager, QlickView 360 reporting tool, Business Intelligence (Services BI, Finance BI), HP QC, Mantis, Tableau

Analytical/communication tools: MS Words, MS Excel, MS Power point, MS Visio, MS Project plan, SQL/HiveQL, Stata, R, MySQL, Java, Google API

Confidential, Cupertino, CA

Data Analyst

Responsibilities:

• Create adhoc reports as per requirements from end users using google analytics
• Extensive A/B testing for web site traffic analysis
• Data query using Java
• Analyze data for production issues
• Support UAT testing for upcoming applications.

Technology:

Back end: Hyperion, SQL, Unix, Oracle, Java

Front end Tools: Developer web portal, Google Analytics

Analytical/communication tools: MS applications for Mac, Hyperion, SQL, Pages, Number etc

Confidential, San Jose, CA

Business/Data Analyst, SME

Responsibilities:

• Active participation in all the stages of project life cycle including concept commit, business commit and execute commit following Cisco standards. Worked successfully on multiple cross functional back to back quarter releases
• Worked on project plan development to capture all the required tasks and timelines. Conducted status meetings with IT team and closely monitored the project status as per project plan. Resolved the issues, showstoppers etc. Updated management with the status on weekly basis
• Requirement gathering:
• Worked with Cisco customers, end users from different domains and Cisco acquisition companies for gather business requirements. Interviewed stake holders to tap new business opportunities Proficient in creating sequence diagrams, activity diagrams and Visio data flow diagrams.
• Documented flow charts, algorithms instructions for tech team.
• Understanding the Business objectives/requirements, review BRD/ARD, interaction with users to ensure capturing all the requirements as per business needs
• Worked with the Solution delivery team to review the business requirements in order to make them understand the complete requirements and reviewed the solution design documents
• Data quality management: Worked on install base, pricing and opportunity data profiling taking care of data consistency, data integrity. Validated data as per requirements. Plan, document and execute data cleansing/manipulating activities.
• Being SME on the project, shared complete process knowledge on all the components with the new teams from both IT as well as business
• Testing:
• Created test case documents for business acceptance testing
• BAT and UAT testing planning and execution.
• Supported completely during BAT/UAT cycles acted as interface between user/stake holders and IT team, provided complete analysis for all the defects/issues to ensure the smooth and pleasant interaction between the teams

Confidential, San Jose, CA

Business/Data Analyst

Responsibilities:

• Participated in complete project life cycle starting from vendor selection process in the foundation releases. Worked successfully on multiple cross functional back to back quarter releases
• Involved in project planning and complete execution. Hosted status biweekly meetings with the IT teams and reported management team
• Requirement gathering: Hosted meetings with System Integrator users across Cisco to capture requirement gaps and current issues.
• Translated it in business requirements in BRD
• Data analysis: Completed data analysis between old and new system.
• Validated data during production migration

Technology:

Back end: Data Warehousing(Star Schema Design), Informatica Oracle 9i/10G, PL/SQL, SQL, Java(UI), Teradata, Hyperion, TOAD, SqlPlus, $Universe, Unix, Shell Script, Hadoop, MDM data

Front end Tools: DRM, Finance BI (revenue, Bookings, Expenses), Hyperion cubes (Revenue, Bookings Expenses), ERP Tools, System Integrator Tool, HP QC

Analytical/communication tools: MS Words, MS Excel, MS Power point, MS Visio, MS Project plan, SQL

Confidential, San Jose, CA

Data Analyst, IT Analyst

Responsibilities:

• Involved in project planning and complete execution. Hosted status meetings with the IT teams for management reporting
• Requirement gathering: Interviewed acquisition POCs for Cisco integration. Worked closely with POC to understand acquisition data and current process to covert it for cisco reporting.
• Data analysis: Completed data analysis between acquisition data for cisco integration. Validated data during production migration
• Generated upload template with extensive use of excel formulas and macros for monthly uploads
• Supported IT during deployment. Let BAT UAT efforts.

Technology:

Back end: Data Warehousing(Star Schema Design), Informatica, Oracle 9i/10G, PL/SQL, SQL, Java(UI), Teradata, Hyperion, TOAD, SqlPlus, $Universe, Unix, Shell Script

Front end Tools: Business Intelligence (services BI, Finance BI), Data Relation Manager (DRM) Tool, HP QC

Analytical/communication tools: MS Words, MS Excel, MS Power point, MS Visio, MS Project plan, SQL

Confidential, San Jose, CA

Data Analyst, IT Analyst, SAS Analyst, SME

Responsibilities:

• Involvement in the complete vendor selection process in the foundation releases. Active participation in all the stages of project life cycle including concept commit, business commit and execute commit following Cisco standards. ERMO representative.
• Involved in project plan development to capture all the required tasks and timelines. Conducted status meetings with the IT teams and closely monitored the project status as per project plan. Resolved the issues, showstoppers etc. Updated management with the status on weekly basis
• Worked with Cisco customers, end users from different domains to gather business requirements. Interviewed stake holders to tap new business opportunities
• As part of IT analyst responsibilities, prepared Functional requirement document after complete functional analysis and data analysis. Extract data from different sources using Java and SQL queries. Developed mock-ups for the User Interfaces. Prepared, reviewed test strategy, test plan and test case documents. Worked on data assess. Socialized, reviewed and walked-thru with the IT team to understand Functional requirements and to get sign-offs from the respective teams. Participated in technical solution process to influence the solution to capture the complete functional requirements. Worked in offshore environment with teams from multiple vendors
• Being SME on the project, shared complete process knowledge on all the components with the new teams from both IT as well as business
• Participated functional testing at unit testing and at SIT level
• Data validation between source and target using SQL query
• Provided hand over document for next level of testing to Business and Users
• Supported completely during BAT/UAT cycles acted as interface between biz/user and IT team, provided complete analysis for all the bugs/issues to ensure the smooth and pleasant interaction between business/users and IT team
• Migration Support:
• Participated in migration plan development to ensure smooth deployment
• Supported development team during deployment. Validated the migration in production
• Communicated with business and management team on deployment progress
• Production Support:
• Knowledge transfer on functionally with the support team to bring them up to the speed
• Worked with support team during warranty period
• Provided post migration support in production as and when required from analysis prospective.

Technology:

Back end: Data Warehousing(Star Schema Design), Informatica Power Center 8.6, SAS software, Oracle 9i/10G, PL/SQL, SQL, Java(UI), Teradata, Hyperion, TOAD, SqlPlus, $Universe, Unix, Shell Script

Front end Tools: Business Intelligence (services BI, Finance BI), SAS Profitability Management(SAS PM) Tool,, ERP Tools, System Integrator Tool, HP QC, Web analytics

Analytical/communication tools: MS Words, MS Excel, MS Power point, MS Visio, MS Project plan, SQL

Confidential

Software Engineer

Responsibilities:

• Design, development and coding with ORACLE, SQL, PL/SQL Developed complex Informatica mappings and defined transformation code rules.
• Tuned the mappings and ETL procedures optimize load and query Performance.
• Developed dimension loads change mappings and defined mapping and session updates.
• Designed reusable transformations and shortcuts to share different mappings.
• Handle the development, QA and production folders and production data load validations
• Scheduling the sessions and Start the Informatica Sessions and Monitor the sessions.
• Troubleshoot the loading failure cases, including database problems.
• Estimated the data sizes for cache and index files.
• Involved frequently with management and business unit to learn new requirements.
• Implemented load strategy procedures to improve mapping dependencies

Technology:- Informatica Power Center 6.2, Oracle 8i/9i, PL/SQL, SQL

Confidential

Analyst / Quality assurance engineer

Responsibilities:

• Requirement gathering from the business clients and stakeholders, data analysis and documentation
• Worked with IT team on execution plans
• Wrote BAT/UAT test plans and test cases, define processes, and determine steps necessary to ensure a high quality software product. Execute test checklist and scenarios to test new product features and functionality. Analyze test results to determine test success or failure. Record defects found in testing using the defect tracking software
• Provided business support in the deployment activities
• Performed production validation and post production support

Technology: MS Excel, MS Word, Bug Tracking System, Oracle Database, HTML