Sql Server Azure Devops

VALENTINA PETER

*************@*****.*** +1-908-***-**** New Jersey, USA - 08854

EDUCATION

Birla Institute of Technology & Science University,Pilani Dec 2015

Software Engineering (M.Tech)

Total IT Experience : 13 Years

SUMMARY

EXPERTISE: Worked as Business System Analyst in Banking & Finance Domain,Leading Onshore & Offshore team of 15. Connecting with different Stakeholders & C-Level Executives to get the various requirements related to Executive Data Strategy Engagement.Driving different kinds of Meetings,Initiatives. Working on IBM Datastage,Jira,MS SQL,Oracle,IBM DB2,Confluence,MS Azure,Databricks,Azure Data Factory,IBM Sterling Connect & Azure Devops

Formerly worked as a Technical 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,Anaplan,Azure Devops

Formerly Worked 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,Anaplan,Azure Devops

Formerly Worked 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 in Manufacturing & Hi-Tech and Gaming domains and was 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: IBM Datastage,Microsoft SQL Server Integration Services(SSIS),Talend DI,Azure Data Factory

Analytical : Microsoft SQL Server Analysis Service(SSAS),Anaplan

Cloud: Microsoft Azure,AWS,GCP

Frameworks/Platforms: Azure Databricks,Azure Devops

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,Service Now

Version Control: GIT Hub,WinSCP,Sharepoint Online

Good Knowledge in Smartsheet,Microsoft Forms,Google Looker

File transfer: WinScp,Filezilla,IBM Sterling Connect,OpenText Biztalk

Domains:

Healthcare & Pharma: Johnson & Johnson,G1 Therapeutics

Manufacturing & Hi-Tech: Electronic Arts

Consumer: Ross Dress for Less,Loreal

Banking & Finance: Wells Fargo,First Horizon National Bank

Transport & Logistics: Bollore,Forward Air

Certifications:

IBM Certified Designer Cognos 10 BI reports

IBM Certified Cognos 10 BI Metadata Models Developer

102_Introduction to Model Building V2-Official ANAPLANNER_Certificate_8157

Tableau Online & Desktop

Jira Admin

PROFESSIONAL EXPERIENCE

Wipro Ltd. New Jersey, USA. Business System Analyst(Feb/2024 – Current)

PROJECTS:

Banking & Finance - First Horizon National Bank

RESPONSIBILITIES:

Communicate with First Horizon Data Integration teams, project stake holders, IT management team and understand the detailed functional and non-functional requirements for DevOps projects.

Estimate the effort involved in fulfilling the requirements after consulting the project manager. Responsible for Business information systems focusing on database architecture, data modeling, data analysis, software design, programming, and application integration.

Prepare the functional specification document, high level design document and low-level design document for software components and services.

Worked on Auto Lending lifecycle section where Analysis was done by going through the existing lifecycle which FHN has,Documenting the same and providing improvement feedbacks.

The Auto Lending lifecycle steps included Loan Origination,Loan Servicing,Loan restructuring, Automating to mitigate Auto Loan collections & Removing silos with End to End Lifecycle Automation.

Design and implement new software component and services to ensure system wide efficiency, reliability, and compatibility to maximize system performance.

Designed ETL solution to move data from on premise to Cloud.

Translated business needs into detailed technical specifications and user stories.

Conducted feasibility studies and impact analyses for proposed solutions.

Led and managed DevOps projects, ensuring timely delivery of high-quality solutions.

Developed and maintained project plans, timelines, and status reports.

Coordinated with development, operations, and QA teams to ensure seamless integration and deployment of software applications.

Write effective and efficient Structured Query Language (SQL) statements to retrieve data from Oracle, DB2 and SQL Server databases Perform code reviews, recommend improvements, and establish standard development framework.

Drive initiatives to build and improve process, quality initiatives and support critical requests during US Business hours Migrate and validate the ETL code and DDL changes to higher environments such as QA and Production using Azure Data Factory.

Work closely with development teams and product owners to coordinate project activities, address impediments & meet project deliverables.

Assist with internal and external communication, improving transparency and radiating information. Liaise with offshore team to guide them on the design and development.

Provide Daily/Weekly status report to the client and Wipro Management. Prepare reports on various metrics and statistics that help track the project status.

Source files were transferred through IBM Sterling Connect.

Used GitHub to collaborate on code & create version control.

Addressing all technical, functional and production deployment issues and effectively communicating with business team for issue resolution and cross functional and technical knowledge on the existing applications, application/system analysis and solution design capabilities.

Trained in Data Governance tool using Databricks & Storage with Azure datalake Gen2

ETL experience in Azure Data Factory

TECH STACK / ENVIRONMENT

Jira,IBM Datastage,Power BI,MS Azure,Azure Devops,Databricks,Confluence,IBM Sterling Connect

Wipro Ltd. New Jersey, USA. Technical Product Owner (May/2023 – Feb/2024)

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.

Identified and implemented process improvements to enhance the efficiency and effectiveness of the software development lifecycle (SDLC).

Promoted and facilitated the adoption of DevOps best practices, tools, and methodologies.

Monitored and analyzed key performance metrics to identify areas for continuous improvement.

Provided technical guidance and support to development teams on DevOps tools and practices, including CI/CD pipelines, automation, and infrastructure as code (IaC).

Collaborated with IT and security teams to ensure compliance with security standards and best practices.

Troubleshoot and resolve technical issues related to DevOps implementations.

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.

Developed Tableau reports & Dashboards along with some SSRS reports.

Worked on building testing & deploying ETL packages & pipelines using Azure Data factory & Talend DI.

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

Automated Imports & Exports using Anaplan connect API.

Defined Modules,Lists,Subsets,Actions,Process based on Business requirements.

Followed Application Lifecycle management to manage Development,Testing & deployment of the models.

Analyzed Anaplan inbound SQL queries & applied fixes during UAT & Production Support.

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

Used GitHub to collaborate on code & create version control.

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,Azure Data Factory,Databricks,Salesforce CRM,IBM DB2,Service Now,Jira,Anaplan

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.

Managed the development and deployment of a cloud-native application on GCP, resulting in a 30% increase in user engagement and a 20% increase in revenue.

Implemented a CI/CD pipeline using Jenkins and Cloud Build, reducing software release times by 50% and minimizing production issues by 30%.

Developed and maintained GCP security policies, ensuring compliance with industry standards and regulations

Served as a liaison between business stakeholders, development teams, and other IT departments.

Conducted regular meetings and presentations to update stakeholders on project status, risks, and issues.

Prepared and deliver clear and concise documentation, including business cases, technical specifications, and user guides.

Driving Anaplan model reviews that supported Loreal in Finance,Sales Performance & Supply chain planning.

Modelling sophisticated problems & developing expertise in various functions by using data to support strategic & operational decision- making resulting in improved Anaplan model performance.

Providing concise & informative suggestions to improve Anaplan model performance resulting in Customer satisfaction.

Consulting on architectural standard methodologies for connected planning solutions, resulting in optimized customer product experience.

Developed ETL Processes for support of the Loreal Product management portfolio with SSIS,SQL stored procedures & C# Scripting.

Involved in creating SSIS jobs to automate the report generation,cube refresh packages.

Experienced in Building Cubes & dimensions with different Architectures & Data Sources for Business Intelligence & writing MDX Scripting.

Experienced in creating complex SSIS packages using proper control flow & data flow elements with error handling.

Designed & developed SSIS packaged to move data from various sources into destination flat files & databases.

Troubleshoot previous SSIS packages to solve issues.

Performance tuning existing scripts & processes.

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.

Used GitHub to collaborate on code & create version control.

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,Anaplan

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

PROJECTS:

Pharma & Life Sciences – G1 Therapeutics Inc.

RESPONSIBILITIES:

Day to Day activities included:

Managing the Datawarehouse requests – Updates to an existing object,creation of views,tables etc as per business requirement using Amazon Redshift.Data from various datasources were being managed.

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 in Veeva Nitro tool

ICS sales Data reporting – ICS 867,ICS 852 daily files processing.Files received through OpenText Bizmanager.

Monitoring of schedules Jobs & Orchestration in Veeva Nitro

Master data management using Veeva Network As a daily task.Match & merge of HCPs & HCOs based on different attributes such as address,zip code etc.

Veeva CRM – Used to cross check the events,call data & VAE details.Also territory wise details of a Medical Representative.

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.

Worked as a Jira Admin & built various documentation & channels in Confluence.

TECH STACK / ENVIRONMENT

Datawarehouse Management using SAP HANA,Amazon Redshift & Veeva Nitro Admin Console, Master data management using Veeva Network,Jira Admin,Tableau,OpenText Bizmanager

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. Technical 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.

Worked on Auto Lending lifecycle section where Analysis was done by going through the existing lifecycle which FHN has,Documenting the same and providing improvement feedbacks.

The Auto Lending lifecycle steps included Loan Origination,Loan Servicing,Loan restructuring, Automating to mitigate Auto Loan collections & Removing silos with End to End Lifecycle Automation.

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 Project Engineer (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. Senior Project Engineer (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