VALENTINA PETER

ad2up4@r.postjobfree.com +1-908-***-**** New Jersey, USA - 08854

EDUCATION

Birla Institute of Technology & Science University,Pilani Dec 2015

Software Engineering (M.Tech)

Total IT Experience : 12.6 Years

SUMMARY

EXPERTISE: Working as a Tableau Product Owner in Transport & Logistics Domain,Leading Onshore & Offshore team of 10. Connecting with different Stakeholders & C-Level Executives to get the various requirements related to Executive Dashboards creation,Support & Maintenance.Driving different kinds of Meetings,Initiatives. Working on Tableau,Oracle,Talend DI,Salesforce CRM,IBM DB2,Service Now,Jira etc.

Formerly Worked as a Project Lead in Consumer Goods Domain, Leading the Onshore & Offshore team of 25.Connecting with Client Managers & Stakeholders, driving different Meetings,Initiatives. Worked on MSBI tools – SQL Server,SSIS,SSAS,SSRS,Power BI,Azure Data Factory, GCP etc.

Formerly Worked as Technical Lead in Pharma domain on Datawarehouse Management using Amazon Redshift. Have experience working on Veeva related products like Nitro Admin Console, Veeva Network for Master Data Management. Also have been working on as Jira Admin. Have relevant experience in Tableau.

Formerly Worked as MSBI Technical Lead and involved in development activities using MSBI SSRS (SQL Server Reporting Services), Crystal Reports & IBM Cognos BI. Worked as part of data model design team with MS SQL Database and has proficient knowledge in the same. Worked on ETL part on SQL jobs like periodic maintenance, debugging of jobs. Documenting the packages. Rerunning the jobs failed. tracing the activity etc. using MSBI SSIS(SQL Server Integration Services).

SKILLS:

Business Intelligence: Microsoft SQL Server Reporting Services(SSRS),Tableau, IBM Cognos BI,Power BI,

Data Integration: Microsoft SQL Server Integration Services(SSIS),Talend DI,Azure Data Factory

Analytical : Microsoft SQL Server Analysis Service(SSAS)

Cloud: Microsoft Azure,AWS,GCP

Databases: Amazon Redshift, MS SQL Server, Oracle,IBM DB2

Testing Framework: ALM – Application Lifecycle Management,OTM- Oracle Test Manager

Tools: JIRA, Putty, Jenkins, uDeploy,Confluence

Version Control: GIT Hub,WinSCP,Sharepoint Online

Good Knowledge in Smartsheet,Microsoft Forms,Google Looker

PROFESSIONAL EXPERIENCE

Wipro Ltd. New Jersey, USA. Product Owner (May/2023- Current)

PROJECTS:

TRANSPORT & LOGISTICS - Forward Air Inc.

RESPONSIBILITIES:

Leading technical solutions working with Customer stakeholders, vendors, offshore IT team and use tools like Oracle for the database management, Tableau as the Visualization Tool to create & Manage Executive Dashboards.

Extensively using Tableau tool to create customized Executive Dashboards and reports for Data Analytics purpose which would aid the Management & Stakeholders to get an overview on the Sales Forecast data and make executive decision for the business.

Tracking the schedule, effort, and costing for the projects. Ensuring the schedule is intact as per the business expectations and send necessary communications in case of any potential issues or delays to the stakeholders.

Communicating Project status information to the BI IT Stake holders. Preparing status reports capturing the key accomplishments, status of in progress activities, RAG status, issues, risks, and mitigation plans, and share with stakeholders.

Act as first support leader for the program on overall quality of the deliverables

End to end delivery ownership of the program using Agile methodology

Manage detailed plan for the program in consultation with the customer

Analyze and suggest continuous improvement measures and best practices followed in Wipro COE (Centre of Excellence) for the program.

Coordinate with multiple cross functional teams for the steady state delivery of the program

Manage the development and production teams in prioritizing the tasks on the Agile release trains for seamless delivery

Interfacing with customer and delivery teams to resolve technical issues in the project(s)

To understand the business requirements and guide teams for conversion to proper solutions

To evaluate projects from a technical stance, guaranteeing that the development methods are correct and practical

Coordinating at Onsite and work with Client to pursue new Change Requests

Manage Onsite and Coordinate delivery with the Offshore Team

Participating in the Look Ahead meetings on the future state of the program with Stakeholders

TECH STACK / ENVIRONMENT

Product Owner, Tableau,Oracle,Talend DI,Salesforce CRM,IBM DB2,Service Now,Jira

Wipro Ltd. New Jersey, USA. Project Lead (Nov/2022 – May/2023)

PROJECTS:

Consumer Goods – Loreal USA Inc.

RESPONSIBILITIES:

Leading technical solutions working with Customer stakeholders, vendors, offshore IT team and use tools like Microsoft SQL Server for the database management, SQL Server Integration Services for Extracting, Transforming & Loading the data into staging area & SSRS & Power BI as Visualization tools.

Working closely on multiple BI project applications such as EIW, Boost & Power BI and product owners of Digital IT, Business Intelligence, Integration, B2B, Cloud services and SAP to manage the application development, support, maintenance, and enhancements. Extensively using SQL Server Reporting Services tool to create customized Executive Dashboards and reports for Data Analytics purpose which would aid the Management & Stakeholders to get an overview on the Sales Forecast data and make executive decision for business.

Using expertise knowledge and experience in SQL Server Analytics Service extensively to create Business objects such as cubes to provide real time data for the report’s execution & Cube Processing.

Extensively using Power BI tool for specific regions to create high level dashboards which gives overall view of support provided by the team for services like

Incident management, Service Request, Problem Management, Minor Enhancements, Major Incident Management,Change Management etc.

Utilizing Informatica Power center as a ETL tool and Control M to create, monitor various

scheduled jobs which is the key factor in keeping the systems from experiencing downtime.

Establishing and stabilizing ITIL processes through service management tools like Service Now, Track-wise to monitor and track the issues reported or services requested as part of Incident, Service Request, Change and Problem Management.

Tracking the schedule, effort, and costing for the projects. Ensuring the schedule is intact as per the business expectations and send necessary communications in case of any potential issues or delays to the stakeholders.

Communicating Project status information to the BI IT Stake holders. Preparing status reports capturing the key accomplishments, status of in progress activities, RAG status, issues, risks, and mitigation plans, and share with stakeholders.

TECH STACK / ENVIRONMENT

Project Management(PMO),MSBI Stack( SQL Server,SSIS,SSRS,SSAS),Power BI,Service Now,Azure Data Factory,GCP

Wipro Technologies Ltd. Bengaluru, IN. Technical Lead (Aug/2021 – Oct/2022)

PROJECTS:

Pharma & Life Sciences – G1 Therapeutics Inc.

RESPONSIBILITIES:

Responsible for Managing the Datawarehouse requests such as updates to an existing object,creation of views,tables etc as per business requirement.

Development of ETL Packages by creating Jobs which contains the task sequences and tasks which further contains the main query used to perform the ETL activity.

ICS sales Data reporting

Monitoring of schedules Jobs

Master data management using Veeva Network

Development of Reports in Tableau using different type of properties like Chart controls, filters, Interactive sorting, SQL parameters and complex expressions to calculate, group, filter, parameterize, and format the contents of a reports in Tableau.

TECH STACK / ENVIRONMENT

Datawarehouse Management using Amazon redshift & Veeva Nitro Admin Console, Master data management using Veeva Network,Jira Admin,Tableau,WinSCP

Wipro Technologies Ltd. Bengaluru, IN. Technical Lead, (April/2021 – July 2021)

PROJECTS:

TRANSPORT & LOGISTICS – Bollore Transport & Logistics Inc.

RESPONSIBILITIES:

The EDI project is about Application and Maintenance of Web Methods process & interlinked SQL SPs in initial phase

SQL Server 2019 was used as the Database tool.

Since it was a Devops Project, used Azure Devops as the bug/tasks tracking tool.

Worked as a SQL TECHNICAL LEAD and provided support in bug resolution

TECH STACK / ENVIRONMENT

MS SQL Server 2019,Azure Devops, SMILE ticketing tool, Service Now

Wipro Technologies Ltd. Bengaluru, IN. Business Intelligence Lead, (Aug/2018 – Mar/2021)

PROJECTS:

BANKING & FINANCE – Wells Fargo Bank Inc.

RESPONSIBILITIES:

The CDO Transformation project was about recreating/redesigning the financial reports developed in legacy system - Crystal Reports tool & MS Excel Macros with the help of MSBI - SQL Server Reporting Services Tool.

There were 100 reports approx to be developed as part of Phase 1.

SQL Server 2017 was used as the Database/Datamart tool.

Since it was an Agile Project, used JIRA as the bug/tasks tracking tool.

Worked as a MSBI TECHNICAL LEAD Converted/redesigned the reports using SSRS tool.

Phase 1 development complete from reporting perspective.

Worked on UI(Java) to configure the reports & test the UI screen Merging of the reports & applying business changes post business review

Worked on Report merging process, writing SQL stored procedures

Stored the reports in PDF format, performed the unit testing & fixed the bugs found

Successfully migrated the reports to SIT,UAT Pre Prod & Prod Environments

Developed 20 reports related to Phase 2

TECH STACK / ENVIRONMENT

MS SSRS(SQL Server Reporting Services) 2017,SQL Server 2017,Crystal reports, Jira, Application & Lifecycle Management(ALM),Jenkins, GitHub, Udeploy

Wipro Technologies Ltd. Bengaluru, IN. Technical Lead, (May/2017 – Jul/2018)

PROJECTS:

Consumer: Wholesale – Ross Dress for Less Inc.

RESPONSIBILITIES:

Worked as Offshore Technical lead

Daily project status from offshore to onshore

Understanding the requirement and getting the reports developed.

Communication with client & the onshore team members. Also, with the WIPRO Practice team if needed

Developing the various important documents in the project.

Code Reviews,design review, document review, testing etc.

Made sure to maintain the quality of deliverables

Provided KT to newcomers to the team, support team, onshore team and Testing team from SSRS end.

Maintained the source code and other documents on the Sharepoint site.

Report Migration to other environments 2012 to 2015 server

Reports testing post migration and support

SSIS Job monitoring and support

Postmortem of project end phase

Postproduction support

TECH STACK / ENVIRONMENT

MS SSRS(SQL Server Reporting Services) 2017, MS SSIS(SQL Server Integration Services) 2017,Oracle 11g,Sharepoint 2016

Wipro Technologies Ltd. Bengaluru, IN. Senior Developer (July/2014 – Apr/2017)

PROJECTS:

Gaming & Semiconductor – Electronic Arts Inc. (EA Games)

RESPONSIBILITIES:

Created reports based on the ticketing database related to the Gitsd Unicenter tool which was used for creation of tickets .

Now Service Now tool is in place.

Creating Stored procedures in SQL.

Creating customized reports in SSRS tool.

Resolution of access issues tickets.

Migration of Reports(>300 in number) from one reporting server to another.(2008 to 2012)

Created Datasources & subscriptions for the same.

Worked on SSIS jobs like periodic maintenance, debugging of jobs. Documenting the packages. Rerunning the jobs failed. tracing the activity etc.

Develop Executive DashBoards

Provide Technical Support for Web applications developed on .Net framework 4.0.

Bug Tracking, WSR creation, Team building activities.

ETL Jobs Monitoring and fixing

Worked as a Problem manager, Major Incident manager & AMS ticket Auditor

TECH STACK / ENVIRONMENT

MS SSRS(SQL Server Reporting Services) 2008, MS SSIS(SQL Server Integration Services) 2008,MS SQL Server 2008 R2,GITSD Unicenter, Service Now,.Net Framework 4.0

Wipro Technologies Ltd. Bengaluru, IN. Software Developer (July /2011 – June/2014)

PROJECTS:

Healthcare & Life Science – Johnson & Johnson Inc. (J&J)

RESPONSIBILITIES:

During the DW Server Upgrade, the compiler was upgraded from a 32 bit to a 64 bit. During the compilation of the programs using the upgraded compiler, the team encountered warnings & the bug fix process was initiated. It was required to modify the array length of the impacted fields compared to the data in sourcing document & lengths in database.

APO Data assessment. 5 franchisees were involved.

Creating profiling for Back-to-basics systems & report creations.

Created reports for ASP systems for POC purpose

TECH STACK / ENVIRONMENT

IBM Cognos BI 8, IBM Cognos BI 10,MS SQL Server 2008 R2,Putty,Unix Shell Scripting, Informatica Power Center

Contact this candidate