Shivanshu S.

A functional person with good experience in business analysis, data analysis and product management.

, India

Experience: 10 Years

Shivanshu

A functional person with good experience in business analysis, data analysis and product management.

USD / Year

Start Date / Notice Period end date:

10 Years

Now you can Instantly Chat with Shivanshu!

Chat Now

About Me

Primary Skills-

- Business Analysis

- Requirement elicitation

- Feature and story writing

- Roadmap preparation

- Prioritization and Backlog maintenance

- Product ownership and management<...aration

- Prioritization and Backlog maintenance

- Product ownership and management

- UAT and system analysis

- Release plan and Demos

- Stakeholders management

- Cross-functional team management.

- Data Analysis

- DW architect

- Data Modelling using ERWIN

- Automation

- SCRUM

Toolkit-

- Informatica Power center

- Informatica Cloud

- Pentaho DI

- Oracle DB

- Postgres DB

- Toad

- Unix Shell scripting

And I'm learning about-

- R & Python (Data mining)

- Core Java

- Tableau

- Alteryx

- Hadoop ecosystem

Skills

Positions

Data Analysts

Business Analysts

Technology Analyst

Customer Insights Analyst

Business Process Analyst

Portfolio Projects

Description

Defined and prioritized the Program Backlog, and working with Chief Product Manager to optimize Feature delivery to the customers in balance with the enterprise’s technical and economic objectives.
Work with Product Management, Portfolio group, the Business Owners defines product roadmaps.
Prepare Road-map and release plan.
Implement best prioritization techniques. MOSCOW
Work with Product Management function in prioritizing business epics and agile release train epics.
Work with cross-functional teams to elicit & document advanced engineering business documentation, designs and plans for implementing solutions.
Responsible for investigative work to determine business requirements and specify effective business processes, through improvements in information systems, information management, and procedures.
Analyze business processes, identify alternative solutions, assesses feasibility, and recommend new approaches.
Facilitates scoping and business priority-setting for change initiatives.
Translate business needs/strategies into IT requirements and work with development teams to implement solutions.
Understand end-to-end business processes, and initiate improvement to the process and/or systems.
Facilitate open communication and discussion between stakeholders, acting as a single point of contact between business and IT teams.
Document business requirements as directed, ensuring traceability back to source.

Show More Show Less

Description

Handled two projects successfully.
Did gap analysis to understand the business need and created artifacts to support the analysis.
Responsible for investigative work to determine business requirements and specify effective business processes, through improvements in information systems, information management, and procedures.
Analyze business processes, identify alternative solutions, assesses feasibility, and recommend new approaches.
Assist in the analysis of stakeholder objectives and the underlying issues and identify options for consideration.
Facilitates scoping and business priority-setting for change initiatives of medium size and complexity.
Translate business needs/strategies into IT requirements and work with development teams to implement solutions.
Responsible for investigative work to determine business requirements and specify effective business processes, through improvements in information systems, information management, and procedures.
Assist in the analysis of stakeholder objectives and the underlying issues and identify options for consideration.
Translate business needs/strategies into IT requirements and work with development teams to implement solutions.
Understand end-to-end business processes, and initiate improvement to the process and/or systems.
Facilitate open communication and discussion between stakeholders, acting as a single point of contact between business and IT teams.
Document business requirements as directed, ensuring traceability back to source.
Facilitates meetings between Architect, Business and Engineering team
Involved in designing and UAT testing

Show More Show Less

Description

Worked for two major clients of Zensar, viz. Prudential and Logitech and was deputed to Scotland for 1.5 years
Created a relational model and dimensional model for insurance business.
Worked with Prudential finance team to understand the requirement and did the gap analysis and created data model for them.
Applied data cleansing/data culling techniques to ensure consistency amongst data sets.
Did capacity sizing for Prudential and created a macro for that.
Developed logical data models and physical data models using ER-Studio.
Created and implemented ER models and dimensional models (star schemas).
Generated SQL scripts.
Assisted DBA’s in the development of physical database.
Predominantly involved in designing and development of DW and ETL projects
Handled large scale data and involved in data analysis
Worked on Informatica and Pentaho and used different types of transformations.
Did the POC for Logitech when they were moving from Informatica to Pentaho.
Automated file management system for all the projects across floor by writing shell scripts.
Assisted Logitech CIO and Business team with their queries related to OBIEE.
Worked with Prudential’s Finance team to gather the business requirement and create low level design for them.
Provided round the clock support to both Logitech and Prudential tech team.
Created wiki pages for Prudential support team with clickable images and all the required info.
Handled Logitech’s humungous data(approx. 20-30 GB data per day) and implemented solution for scalability.
Worked as module lead and handled a team of fresher.

Show More Show Less

Description

Worked for two of the major clients of Infosys viz. Time warner Cable and Barclays, as Senior data warehouse engineer.
Interacted with business users and source system (OLTP) IT teams to define, agree and document incoming data mapping specifications.
Involved in leading offshore resources.
Provided project estimations to client and upon agreement with client delivered project accordingly.
The objective was to extract data from Flat Files and Oracle database and to initially load it into a single data warehouse repository, which was in Oracle.
Developed mappings using various transformations like update strategy, lookup, stored procedure, router, joiner, sequence generator and expression transformation.
Used Informatica Power Center Workflow Manager to create sessions, batches to run with the logic embedded in the mappings.
Designed and developed complex Aggregate, Join, Router, Look up and Update strategy transformation based on the business rules.
Extensively used ETL to load data from wide range of sources such as flat files, Oracle.
Wrote complex SQL queries using joins, sub queries and inline views to retrieve data from the database.
Checking the data flow and extensively using SQL Queries to extract the data from the Database and conducted data quality profiling and Oracle explain plan. Writing PL/SQL procedures for processing business logic in the database.
Implemented slowly changing dimensions according to the requirements, Partitioned sessions, modified cache/buffers and tuned transformations for better performance.
Continuously monitor the accuracy of the data and the content of the delivered reports.
Responsible to provide production support and resolve issues.