Summary
Overview
Work History
Education
Skills
Personal Information
Affiliations
Accomplishments
Certification
References
Timeline
Generic

Shailaja Ventrapragada

Scottsdale,AZ

Summary

Results-driven Data Governance Specialist with a proven track record of enhancing data quality and compliance at various organizations. Expertise in SQL and Agile methodologies has facilitated successful cross-functional collaboration, leading to significant achievements in data-driven insights and operational excellence. Adept at driving project success while streamlining processes to ensure effective data management.

Overview

23
23
years of professional experience
1
1
Certification

Work History

Startup Founder

Self-employeed
Scottsdale, AZ
05.2023 - Current
  • Developed an EdTech business plan to launch a startup venture.
  • Built a team of professionals with diverse skill sets.
  • Managed daily operations of the company including staff recruitment and training.
  • Researched emerging technologies that could be leveraged by the startup, including those that can initiate data governance.
  • Prepared reports on progress made towards achieving long-term objectives.
  • Fostered a positive company culture that encourages teamwork, innovation, and excellence.
  • Implemented scalable processes and systems to support business operations and facilitate efficient growth.

Senior Data Governance Consultant/Data Migration Program Manager

Shutterfly
Tempe, AZ
08.2021 - 03.2023
  • Facilitated efforts for effective transition from AMS to Salesforce.
  • Developed Data Remediation Plan predicting data loss risks tied to decommissioning legacy AMS system.
  • Aligned data governance goals with leadership priorities at Lifetouch and Shutterfly.
  • Included key representatives to establish shared Data Governance objectives using DG tool for Lifetouch.
  • Developed a framework for logging and tracking data quality issues faced by analytics, marketing, or business teams.
  • Supplied comprehensive metadata through cross-functional cooperation with technical platform and finance departments across diverse Shutterfly brands.
  • Optimized database and application accessibility via ServiceNow.
  • Technical Environment: RedShift, Oracle, DBeaver CE SQL Query Tool, JIRA, Share Point, Power BI, Microsoft Teams, Excel

Lead Business Systems Analyst

Bank of the West
Tempe, AZ
10.2018 - 06.2021
  • Directed BSA tasks for Digital Channels and Wealth Management.
  • Worked with cross-functional groups to define core business needs and establish project success criteria.
  • Facilitated comprehensive insight into user digital behaviors impacting financial and banking choices.
  • Enhanced digital customer acquisition and application decision processes.
  • Contributed to MDM UI development and LANDIS ad-hoc reporting projects.
  • Enhanced search data platform for CCPA project.
  • Ensured timely resolution of Jira tickets to accurately submit FED reports the evaluate risk prior to FED submission.
  • Applied Informatica suite for Regulatory Reporting Framework and various other enterprise projects.
  • Produced analytical data on tool utilization.
  • Technical Environment: Informatica Power Center Read Access, Advanced Oracle SQL Query Tool, WinSCP, JIRA, Share Point, SQL Server Management Studio, Denodo(cloud), Service Now

Data Lineage Lead

Northern Trust Bank
Chicago, IL
02.2017 - 06.2018
  • Addressed queries from software owners and SMEs regarding the GDPR project.
  • Coordinated interviews with SMEs and software owners to understand each system.
  • Established parameters for content in data mapping files.
  • Reported work status for each application owner and SME during weekly project meetings.
  • Ensured SMEs stay on track with GDPR deliverables through regular prioritization.
  • Coordinated with different teams to integrate metadata from several applications into Information Governance Catalog.
  • Reviewed and approved data lineage created by developers for various applications.
  • Centralized communication channels between Lineage, Data Governance, GDPR Leads and Data Architecture teams.
  • Supported continuous improvement of data dictionaries.
  • Ensured GDPR-sensitive data elements are accurately represented in the glossary.
  • Ensured compliance with stringent GDPR aspects through innovative report generation.
  • Collaborated with middleware application SMEs to identify data inflow and outflow.
  • Engaged with SMEs in auditing user access for multiple applications.
  • Environment: Various Applications across NTRS landscape, SharePoint, Microsoft Standard Visio 2010, Information Governance Catalog -IGC (a product of IBM), Service now

ETL Production Systems Integrity Specialist

BMO Harris Bank
Chicago, IL
09.2014 - 04.2015
  • Facilitated collaboration between IT production support and source system vendors.
  • Corrected data discrepancies before final report generation.
  • Coordinate ETL job rejections with source file vendors to confirm error acceptance.
  • Notified relevant BMO departments about inconsistencies in the dimension table data.
  • Provided high-level inputs to line of businesses for data preview.
  • Investigated sources of discrepancies in report values.
  • Applied deep knowledge of Informatica maps to improve efficiency.
  • Supported report developers in creating new reports.
  • Documented and suggested resolutions to development and production support teams for BMO Harris.
  • Oversaw implementation of different flags post data checks for accurate final reporting.
  • Bring senior-level insights to support critical finance operations.
  • Enhanced data accessibility through improved reporting mechanisms.
  • Technical Environment: Informatica Power Center Designer 9.1.6, Mainframe DB2, EXTRA-Xtreme(ESP Sessions), Advanced Query Tool, F-Secure SSH, Essbase, PeopleSoft Tools, WebFocus

Intellectual Property Systems SME

AbbVie
Waukegan, IL
04.2013 - 03.2014
  • Led communications with legal operations team for IP Manager Application.
  • Delivered assistance for IP Manager technical concerns effectively.
  • Detected operational inefficiencies.
  • Utilized vendor resources effectively to implement strategies.
  • Updated back-end IP Manager data using SQL.
  • Oversee security configuration for user accounts.
  • Generated custom reports utilizing advanced SQL queries and Crystal Reports.
  • Applied enhancements and version releases regularly.
  • Installed software for various environments, mapped business processes, implemented workflows and facilitated integration with legal tools.
  • Technical Environment: MS SQL Server 2008, Sql Server Management Studio, T-SQL, MS Excel, Crystal Reports 2008, IP Manager 3.4.5

Data Analyst/Information Analyst Level 3

Capital One
Richmond, VA
09.2012 - 03.2013
  • Reviewed management-supplied artifacts to identify impacted customer population.
  • Determined population identification and restitution amount across datasets from three vendors for credit monitoring products.
  • Reviewed methodology ensuring alignment with restitution plan.
  • Independently executed management's scripts to identify impacted customers and calculate required refunds.
  • Received commendation from the Card President for identifying 651 enrollments under impacted customers.
  • Received recognition emails from Audit and Risk Committee board members.
  • Ensured reliable management script outcomes through thorough log file checks.
  • Conducted thorough tests of all scripts to verify smooth execution.
  • Conducted independent queries on diverse tables to detect and analyze missing accounts in the card database.
  • Conducted thorough quality assessments on utilized data.
  • Constructed specialized data tables enhancing detailed profiling.
  • Enabled Audit to confirm Management's accuracy in identifying affected customers and calculating restitutions.
  • Resolved queries for team members regarding tasks specified by the consent order.
  • Contributed technical expertise during audits of teams such as 'Recoveries' and 'Collections'.
  • Generated multiple summary reports for ongoing audits through OLAP tools.
  • Led team training initiatives on integrated new tools.
  • Produced daily ad hoc reports utilizing SQL and Crystal Reports to summarize complex data.
  • Ensured audit processes flowed smoothly by addressing auditor needs fully.
  • Technical Environment: Teradata SQL Assistant (Version 13), Sql Server 2008

Reports Developer/ETL Specialist

Capital One
Richmond, VA
09.2009 - 09.2011
  • Participated in collecting business requirements for report generation on the Business Objects system.
  • Developed an architecture for organizing BOBJ usage data into a star schema format.
  • Utilized multiple sources including CMS, Audit, and NAS to complete table entries.
  • Executed consistent quality assessments for timely data loading.
  • Oversaw team efforts in optimizing ETL processes for precise MBR data delivery.
  • Maintained client partnerships while analyzing new bank data warehouse using diverse database systems.
  • Utilized sophisticated techniques to generate statistics for platform's Monthly Business Review.
  • Enhanced performance through tuning of several Korn scripts.
  • Productionized multiple reports for various Capital One teams including the card 'Embossing' team.
  • Developed multiple web intelligence variables.
  • Enhanced strategic decision-making by developing critical administrative monitoring tools.
  • Led upgrade project for business objects from XIR2 to XIR3.
  • Generated critical business insights through the integration of multiple data sources.
  • Enabled platform performance monitoring through carefully designed reporting processes.
  • Directed initiatives related to modifying Teradata space allotments.
  • Technical Environment: Business Objects XIR2/XIR3, Teradata v2r6, Toad, Teradata SQL Assistant, Crystal Reports 2008, Sql Server 2008, Oracle 10g

Senior Data Analyst/Designer

Grange Insurance
04.2008 - 05.2009
  • Involved in the process of segmentation such as deriving the basic population and applying the general inclusion and exclusion criteria for strategy analysis and implementation
  • Communicated with Business Analysts, Senior Project Managers and Developers to gather business requirements and specifications
  • Developed process for extracting data from existing production data sources to perform Ad-hoc queries, built data mart by using Teradata SQL, SAS, MS Access and UNIX
  • Designed and deployed UNIX Shell scripts for seamless data loading automation.
  • Collaborated with Project Manager to produce detailed reports.
  • Performed data validation and data integrity before delivering data to operations
  • Worked with group of Business Analysts to perform in depth data analysis and created monthly reports by using BTEQ, MS Excel, MS Access, VBA, SQL, PL/SQL, UNIX to full fill business requirements
  • Worked on monthly dashboard, manager reports and automated the reports by using MicroStrategy
  • Involved in performance tuning and optimization of large database for fast access of data and reports, MS Excel, UNIX, Oracle and Teradata being used for data transformation
  • Worked with team in the data analysis, database design and development of building a new schema (staging tables, views and SQL files)
  • Performed spooling of the data into Flat files by using Teradata, Oracle and UNIX
  • Performed root cause investigation and analysis
  • Created a new reporting database utilizing data feed from both internal and external data sources
  • Technical Environment: Teradata V2R6, MS SQL Server 2000, Micro Strategy, TOAD, Query Manager, Oracle 9i/8i, SQL, PL/SQL, BTEQ, SAS, MS Excel and MS Access

Data Analyst/ETL Developer

Kaiser Permanente
Permanente, CA
10.2006 - 02.2008
  • Developed reports by using Teradata, Oracle, SQL and UNIX to fulfill Business Analyst's strategies
  • Created data structures for various subject areas to perform data analysis
  • Documented the business process flows, scheduled meetings and presented technical issues to business users and Developers
  • Developed data structures by using Teradata, Oracle, UNIX, MS Excel and MS Access
  • Extracted data from various source systems and summarized clinical data as requirements
  • Performed Ad hoc queries on the business Data Warehouse to meet Business Analyst requests
  • Analyzed the data by slicing and dicing the data, merging and manipulating the files using AWK and Shell scripts
  • Developed UNIX Scripts to automate weekly, bi weekly and monthly clinical reports
  • Took ownership and maintained the Metadata tables, which reflected the business requirements
  • Investigated data and data integrity issues, verifying source data files and sourcing new data feeds from a variety of internal and ancillary Data Marts
  • Converted and merged team efforts including daily interaction with upstream sources and downstream clients of the PST DW with duties including data analysis in MS SQL Server, Oracle and Teradata environments
  • Built complex queries on a daily basis in support of re-sourcing data, new data feeds, existing data issues and report generation
  • Monitored daily, monthly and quarterly cycle processing with issues identification and correction as top priority
  • Created new user accounts, monitored and processed password reset requests, identified and corrected access issues for a number of departments that were allowed security restricted access to the data using a variety of front end products such as vision
  • Participated in design reviews and provided input to the design recommendations
  • Involved in performance tuning of the queries to extract the data and loaded it onto Teradata database
  • Involved in production support and troubleshooting data quality and integrity issues
  • Researched and selected a simplified manual SOX compliance system
  • Technical Environment: Oracle 10g/9i, Teradata V2R6, MS SQL Server, Query Man, Toad, SQL, PL/SQL, MS Excel, MS Access and SOX

Programmer

SDV Technologies
Hyderabad, Telangana
05.2003 - 05.2006
  • Managed and setup levels of security and access permissions to the users
  • Involved in performance tuning of application and installation of various Oracle products and tools
  • Extracted the data from various sources of input and loaded into Oracle tables
  • Created process to extracting data from various production databases and built data structures and financial reports
  • Extracted latest accounts data from Oracle, MS Access database by using SQL and PL/SQL
  • Developed the interfaces in SQL and PL/SQL for data calculations and data manipulations
  • Extracted data from MS Access and loaded into Oracle tables
  • Developed strategies for data analysis and data validation
  • Involved in system and integration testing
  • Wrote Shell scripts to run jobs in the Corn Job
  • Provided 24 X 7 production support on application and database side
  • Technical Environment: Oracle 7.3, SQL, PL/SQL, Windows XP, TOAD and HPUX

Developer/Tester

Electronics Corporation
Hyderabad, Telangana
02.2002 - 04.2003
  • Analyzed and enhanced existing code according to the business and data requirements
  • Modified Shell scripts to effect those changes
  • Developed PL/SQL scripts for setting up the environment in the database for the purpose of testing
  • Developed test plans and execution plans for testing
  • Technical Environment: UNIX, C, Oracle 7.x, Cathode Ray Oscilloscopes and Windows 2000

Education

Bachelor's -

Electronics and communication engineering

Skills

  • Data-Driven Insights
  • Excel
  • AWS Data Management
  • Microsoft Excel
  • Agile Project Management
  • Jira Workflow Optimization
  • Microsoft SQL Server
  • Oracle, Teradata, Redshift ,SQL Server
  • Proficient in SQL for Data Warehouse Management
  • Metadata Collection Coordination
  • Data Management Practices

Personal Information

Work Permit: Authorized to work in the US for any employer

Affiliations

  • Actively involved in community service

Accomplishments

  • Commendations from high-ranking officials across various organizations.
  • Appreciation emails and awards are presented for performance reviews.

Certification

Teradata Certified Professional

References

References available upon request.

Timeline

Startup Founder

Self-employeed
05.2023 - Current

Senior Data Governance Consultant/Data Migration Program Manager

Shutterfly
08.2021 - 03.2023

Lead Business Systems Analyst

Bank of the West
10.2018 - 06.2021

Data Lineage Lead

Northern Trust Bank
02.2017 - 06.2018

ETL Production Systems Integrity Specialist

BMO Harris Bank
09.2014 - 04.2015

Intellectual Property Systems SME

AbbVie
04.2013 - 03.2014

Data Analyst/Information Analyst Level 3

Capital One
09.2012 - 03.2013

Reports Developer/ETL Specialist

Capital One
09.2009 - 09.2011

Senior Data Analyst/Designer

Grange Insurance
04.2008 - 05.2009

Data Analyst/ETL Developer

Kaiser Permanente
10.2006 - 02.2008

Programmer

SDV Technologies
05.2003 - 05.2006

Developer/Tester

Electronics Corporation
02.2002 - 04.2003

Bachelor's -

Electronics and communication engineering

Similar Profiles

CREATE PROFILE
Shailaja Ventrapragada