Summary
Overview
Work History
Education
Skills
Affiliations
Timeline
Generic

SREENIVAS TALLA

Pennington,NJ

Summary

An accomplished BI Architect/Designer and technical business Analyst with over 22 years of IT experience and technical proficiency in Data Warehousing teamed with Business Requirement Analysis, Application Design, Data Modeling, Development, Testing, and Documentation and with extensive experience in the full life cycle of the software design process including requirements definition, prototyping, proof of concept, design, interface implementation, testing, maintenance, and production support. Seasoned Data Architect adept at understanding mandates, developing plans and implementing enterprise-wide solutions. Complex problem-solver with an innovative approach. Ready to bring [Number] years of progressive experience and take on a challenging new role with growth potential.

Overview

23
23
years of professional experience

Work History

BI Architect

Capgemini
Jersey, California
03.2024 - Current
  • Client Name NDA
  • Project Name FUSION
  • Project, & To in Month/Year, Project Description This NDA project is to create Power BI dashboards containing information about the recruitment process for clients across multiple countries, track recruitment progress, and resolve issues to meet target timelines
  • Below are my roles and responsibilities
  • Responsibilities
  • Created wireframes to get approval from clients before building dashboards
  • Created Power BI data models which are being used as sources for multiple dashboards
  • Attending functional design review meetings with clients and preparing technical design documents in approved templates from the client
  • Created Power BI dashboards with frequent reviews from clients
  • Work with release management to plan for releases
  • Defect fixing and performance tuning where necessary
  • Added additional KPIs on the fly while in discussions with client
  • Operating Systems Windows, Software / Special Tools Workable

DQ Analyst and Tableau

Morgan Stanley, Capgemini
Jersey City, NJ
02.2020 - 02.2024
  • Project Name Data Quality Operations
  • Project, The objective of the project is to analyze, ’s Account and Party data discrepancies, define data remediation strategies, perform impact assessment for data fixes and breaks, create Business Requirement documents for large remediation, and deliver services in line with Morgan Stanley guidelines and schedule
  • Data operations support to programs viz
  • Account Restrictions, One Client, WM Data Governance, Solium WM Integration, E
  • Trade integration
  • Responsibilities
  • Created Tableau environment including non-prod and prod environments following Morgan Stanley’s internal Tableau setup, user group creation, Project setup
  • Created a reporting conversion framework to convert all existing excel based reports to Tableau
  • Created Tableau data sources which are being used as sources for multiple Tableau dashboards
  • Created security framework using AD groups for each organization in Morgan Stanley
  • Attending functional design review meetings with clients and preparing technical design documents in approved templates from the client
  • Using Tableau workbench to promote Tableau Dashboards from non-prod environments to Prod environments
  • Implementing data level security based on the requirements (user level/dashboard level)
  • Migration of reporting deliverables from DEV to TEST and to PROD environment
  • Defect fixing and performance tuning where necessary
  • Worked with various other groups to onboard their excel based reports after converting them to Tableau Dashboards
  • Automated several dashboards to execute and send PDF versions to various groups
  • Resolved performance issues of existing reports by fine-tuning SQL queries and creating extracts
  • Created documentation about the report conversion framework and shared with the team
  • Involved in production migration support
  • Created several documentation and trained users to create Tableau dashboards using self-serve capability
  • Share the project timelines and share updates to client manager and schedule weekly status updates
  • Maintain budgets, sent invoice for milestone payments, staffing for multiple projects
  • Address any roadblocks and client concerns
  • Work closely with stakeholders to understand business requirements and translate them into technical solutions
  • Provide technical expertise and support for challenges faced by the team
  • Collaborate with cross-functional teams to integrate Tableau with other systems and applications
  • Operating Systems Windows, UNIX, MS-DOS
  • Hardware
  • Software / Special Tools Tableau Desktop 2023.1.3, Tableau Server, SQL Developer, SAP BO, IBM DB2, Rapid SQL, Teradata SQL Assistant, Python
  • Languages Python, SQL
  • Organization Name, Client Name Vanguard
  • Project Name MVP for DQ operations for CDAO Organization

Title Tableau Architect

Capgemini
Malvern, PA
10.2019 - 01.2020
  • This project is to create an MVP for the Data Governance team for setting up the Tableau environment on AWS and generating data quality scorecards
  • I worked with the AWS Architect in completing this framework setup
  • Responsibilities
  • Worked with the data governance team to gather requirements for this MVP and created BRD
  • Created Tableau environment on AWS by following all guidelines set up at Vanguard
  • Created Tableau data connections using Amazon s3 buckets
  • Created a security framework to mimic the existing setup for the Data Governance group
  • Attending functional design review meetings with clients and preparing technical design documents in approved templates from the client
  • Implementing data level security based on the requirements (user level/dashboard level)
  • Involved in unit testing before releasing to the UAT team
  • Defect fixing and performance tuning where necessary
  • Created documentation about the Tableau environment on AWS, challenges, and resolutions that are specific to Vanguard
  • Involved in production migration support
  • Share the project timelines and share updates to client manager and schedule weekly status updates
  • Maintain budgets, sent invoice for milestone payments, staffing for multiple projects
  • Address any roadblocks and client concerns
  • Work closely with stakeholders to understand business requirements and translate them into technical solutions
  • Provide technical expertise and support for challenges faced by the team
  • Collaborate with cross-functional teams to integrate Tableau with other systems and applications
  • Operating Systems Windows
  • Hardware
  • Software / Special Tools Tableau Desktop 2019.1, Tableau Server, SQL Developer, AWS S3
  • Languages Python
  • Organization Name, Client Name Transunion
  • Project Name BIRST to Tableau Conversion
  • Project, To in Month/Year Format

BI Architect

Capgemini, Wells Fargo
Jersey, Colorado
05.2019 - 10.2019
  • This pilot project is for Transunion to convert their ClearIQ Healthcare dashboards from BIRST to Tableau
  • Current BIRST dashboards contain information about estimates of the care, the accuracy of their estimates by facility and each site, and standard and outlier estimates
  • I have been the only architect/lead developer on this project and carried the below roles and responsibilities
  • Responsibilities
  • Created BRD based on new functionality requirements gathered from various stakeholders
  • Reviewed and refined BRD based on the comments from the technical team
  • Created a POC to convert the BIRST dashboard to Tableau on one of their most complex dashboards
  • Created a reporting conversion framework to convert all healthcare dashboards from BIRST to Tableau
  • Created Tableau data sources which are being used as sources for multiple Tableau dashboards
  • Created security framework to mimic existing setup on BIRST dashboards
  • Attending functional design review meetings with clients and preparing technical design documents in approved templates from the client
  • Work with release management to plan for releases
  • Implementing data level security based on the requirements (user level/dashboard level)
  • Migration of reporting deliverables from DEV to TEST and to PROD environment
  • Involved in unit testing before releasing to the UAT team
  • Defect fixing and performance tuning where necessary
  • Created documentation about the report conversion framework and shared it with the team
  • Involved in production migration support
  • Share the project timelines and share updates to client manager and schedule weekly status updates
  • Maintain budgets, sent invoice for milestone payments, staffing for multiple projects
  • Address any roadblocks and client concerns
  • Work closely with stakeholders to understand business requirements and translate them into technical solutions
  • Provide technical expertise and support for challenges faced by the team
  • Collaborate with cross-functional teams to integrate Tableau with other systems and applications
  • Operating Systems, Project Name Data Quality Operations Dashboards

BI Architect

Wells Fargo, Capgemini
, New Jersey, North Carolina
01.2018 - 04.2019
  • This project is for the, Data Quality team where several Data Quality dashboards have been created around different kinds of data that is being handled
  • It includes data at rest, data in motion, and Data Quality Tickets to name a few at domain and application level
  • The dashboards created gave the users the health of their systems in terms of several good and bad records (which failed the data quality checks) so that they could take corrective action
  • The process includes data quality rules written and implemented at data sources and the results have been made available in Ab Initio
  • Data Quality dashboards have been created based on the results of the rule implementation which include total records monitored, total records failed, total dollars monitored, total defective dollars, Data Quality measurement, Data defect Measurement, Data Quality indicator, Data defect indicator, the total number of rules implemented, Number of Core data elements, Core data elements in scope, coverage %
  • Responsibilities
  • Manage and lead the delivery of reporting projects through the entire development lifecycle
  • Attending functional design review meetings with clients and preparing technical design documents in approved templates from the client
  • Review the DQ results from Ab initio and create reports / Dashboards and share with application owners for their specific domain/application
  • Attending reporting requirements review meetings with domain and application ABDOs to work on common dashboards
  • Worked with release management to plan for releases
  • Create and distribute status reports including dashboards to all stakeholders
  • Participate in operational readiness activities
  • Create a project plan for each phase and share it with all the stakeholders
  • Leading the teams and sharing technical information with both the shores
  • Build phase of the project Tableau dashboards
  • Involved in peer review of the deliverables built by the team and vice versa
  • Implementing data level security based on the requirements (user level or group level)
  • Assembly test of all the report-related objects
  • Migration of reporting deliverables from DEV to TEST and to PROD environment
  • Managing all reporting deliverables and measuring the actual timelines against one provided in the analysis phase
  • Involved in unit testing before releasing to the UAT team
  • Defect fixing and performance tuning where necessary
  • Provide KT sessions to the support teams
  • Involved in production migration support
  • Participate in post-implementation monitoring
  • Operating Systems Windows
  • Hardware
  • Software / Special Tools Tableau Desktop 10.2, Tableau Server, Ab Initio, Query>IT, SQL Developer, Teradata SQL Assistant
  • Languages SQL
  • Organization Name, Client Name TIAA-CREF
  • Project Name Digital Confirms Dashboards
  • Project Duration

BI Architect

03.2016 - 12.2017

Reporting Analyst

Morgan Stanley
Iselin, New Jersey
07.2015 - 02.2016
  • This project is for TIAA
  • TIAA, formerly TIAA—CREF (Teachers Insurance and Annuity Association—College Retirement Equities Fund), is a Fortune 100 financial services organization that is the leading retirement provider of financial services for the academic, research, medical, cultural, and governmental industries
  • TIAA serves over 5 million active and retired employees participating at more than 15,000 institutions and has over $900 billion in combined assets under management with holdings in more than 50 countries
  • We developed a series of Tableau dashboards that cater to several TIAA business areas (BPMO, Financial, Digital markets, Confirms, Pensions, and Prospectus) which will give clients insights into how any particular business area is doing based on the period selected
  • These dashboards have high visibility (up to CFO) and have a wide variety of uses which include and not limited to making decisions on allocations for the future
  • We created a variety of dashboards which includes summary and detail-level dashboards that will help identify the areas where remediation is needed
  • We also archived all the reports into DocHub for later retrieval
  • We created Splunk dashboards based on the logs for each system involved to provide a visual monitor to the production support team to check the health of each system
  • We also converted dashboards created in OBIEE to Tableau with more features added to them
  • My responsibilities include
  • Responsibilities
  • Manage and lead the delivery of reporting projects through the entire development lifecycle
  • Attending functional design review meetings with clients and preparing technical design documents in approved templates from the client
  • Prepare and update data model diagrams (both Physical and logical) for reporting platforms
  • Attending reporting requirements review meetings with clients and other teams
  • Work with release management to plan for releases
  • Create and distribute status reports including dashboards to all stakeholders
  • Participate in operational readiness activities
  • Create a project plan for each phase and share it with all the stakeholders
  • Leading the teams and sharing technical information with both shores
  • Build phase of the project Tableau dashboards
  • Involved in peer review of the deliverables built by the team and vice versa
  • Assembly test of all the report-related objects
  • Migration of reporting deliverables from DEV to TEST and to PROD environment
  • Managing all reporting deliverables and measuring the actual timelines against one provided in the analysis phase
  • Involved in unit testing before releasing to the UAT team
  • Defect fixing and performance tuning where necessary
  • Provide KT migration to the support teams
  • Involved in production migration support
  • Participate in post-implementation monitoring
  • Operating Systems Windows, Software / Special Tools Tableau Desktop 10.2, Informatica, Erwin, SQL Developer, Splunk
  • Languages SQL
  • Organization Name Capgemini
  • Client Name

Reporting Analyst

Shire Pharmaceuticals
01.2014 - 07.2015

Designer

Accenture
05.2012 - 12.2013
  • Information Design Tool, Tableau Desktop, Netezza, Informatica, Aginity Workbench, Millercoors
  • Project Name Inventory Reports for MillerCoors
  • Project Duration (From & To in Month/Year Format

Senior BI Analyst

Pfizer
Wayne, Peapack, PA, NJ
08.2011 - 05.2012
  • Project Description This project is for Shire Pharmaceuticals
  • Shire is a leading pharmaceutical company that manufactures medicines to treat an extremely rare and life-threatening disease like Hunter syndrome or Fabry disease; or a medicine for a specialist condition like ADHD or ulcerative colitis which if not treated effectively, can dramatically affect the lives of the patient and their whole family
  • This project CMSO (Commercial Managed Service Outsourcing) supports the IT systems of the Shire field reps and Shire business users to do their jobs
  • Responsibilities
  • Manage and lead the delivery of reporting projects through the entire development lifecycle
  • Attending functional design review meetings with clients and preparing technical design documents in approved templates from the client
  • Prepare and update data model diagrams (both Physical and logical) for reporting platforms
  • Attending reporting requirements review meetings with clients and other teams
  • Work with release management to plan for releases
  • Create and distribute status reports including dashboards to all stakeholders
  • Participate in operational readiness activities
  • Create a project plan for each phase and share it with all the stakeholders
  • Leading the teams and sharing technical information with both shores
  • Build phase of the project including BO reports and Tableau dashboards
  • Involved in peer review of the deliverables built by the team and vice versa
  • Assembly test of all the report-related objects
  • Migration of reporting deliverables from DEV to TEST and to PROD environment
  • Managing all reporting deliverables and measuring the actual timelines against one provided in the analysis phase
  • Involved in unit testing before releasing to the UAT team
  • Defect fixing and performance tuning where necessary
  • Provide KT sessions to the support teams
  • Involved in production migration support
  • Participate in post-implementation monitoring
  • Operating Systems Windows, Project Name Remapping of BO Architecture
  • Project, Project Description Security and Navigation: This project is part of PACE (Pfizer Achieving Commercial Excellence)
  • As a part of this project, we have analyzed all the reports for the Customer analytics team (350+)
  • Based on the user business groups and their roles, we have created 19 core security user groups and aligned all the existing users under one of the security groups
  • Also, based on the subject area we created categories and universe folders
  • Responsibilities
  • Analysis of users and their access to the report folders and categories and organizing under specific core security user groups
  • Analysis of reports and universes and categorizing them based on the functional area
  • Discussed with business groups and identified the reports/universes which are needed, and which can be archived
  • Analysis of blueprint document created based on the objects present in the production environment
  • Created functional and technical design documents and presented them to the client for approval
  • Held meetings with other teams involved and discussed the project plan and each team's responsibilities
  • Testing of the framework after the admin team implemented it on all 3 environments (Test, Stage, and Production)
  • Coordinating with the offshore team throughout the project
  • Provided archiving and retirement solutions and standards to the client
  • Testing of each environment after the framework has been implemented and raising defects
  • Operating Systems Windows

Designer, Business Objects Architect

Mphasis, Motor Vehicle Commission, Convergys
Trenton, NJ
06.2009 - 08.2011
  • Oracle, Informatica, Toad ness Objects 3.1, Web Intelligence, Universe Designer, Teradata, Informatica, Toad
  • Languages SQL
  • Organization Name, Client Name NJ, Project Name MATRX
  • Project, This project is for the New Jersey Motor Vehicle Commission (NJMVC)
  • The project is MATRX (Motor Vehicle Automated Transaction System)
  • This project is legacy modernization for the 30+ year-old New Jersey Motor Vehicle commission (NJMVC)
  • NJMVC is a government agency that services its customers by issuing driving licenses, vehicle registrations, business licenses, provide driver abstracts, provide data requested by external agencies, etc
  • Our team is involved in the entire SDLC of this project
  • We are upgrading the existing functionality to the latest technologies which include JAVA, J2EE, JSF, Spring framework, SAP BusinessObjects, Crystal Reports, xPressions, Rational tools to name a few
  • Responsibilities
  • As BO Admin, I created all 5 environments for reports including Production(clustered), configuring and administering them
  • Involved in creating POC and demo to NJMVC
  • Gathered requirements from the customers and prepared High-level design documents
  • Involved in the analysis and creation of universes based on the requirements
  • Leading a team of 10-member strong reports team
  • Responsible for reports design for all modules which include Customer Care, TPI, VTR, BLS, DL, FM
  • Analyzed requirements from Business/Users
  • Document Reports & Universe specifications and design
  • Involved in Design and Development of reports using Business Objects(XIR 3.1)/ Crystal Reports 2008, xPressions V4.0
  • Involved in creating Vehicle Title and registration documents which are top priority
  • Had meetings with DBAs and architects for the universe and reporting query costs, optimizing queries for maximum performance
  • Improved the performance of reports and universes by creating indexes and materialized views
  • Involved in defect analysis for both development and QA
  • Created test cases for both UAT and integration testing
  • Trained NJMVC team about the reports
  • Interacted with SAP and EMC for technical support
  • Operating Systems Win2003, UNIX, Software / Special Tools Business Objects (XIR3.1), BusinessObjects Life Cycle Manager(LCM), Crystal Reports 2008, Web Intelligence XI, xPressions xDesign, xAdmin, TOAD, Oracle 11g R2, Erwin, ClearCase, ClearQuest
  • Languages SQL, Client Name HO Systems/VeriSign/

Senior BI Analyst

Savannah, GA
05.2001 - 06.2009
  • Project Description Cellular Information Management Systems
  • Responsibilities
  • Involved in the analysis of universes for any possible changes
  • Gathered requirements from the customers and prepared High-level design documents
  • Led a team of 8 including Mphasis and Verisign/Convergys team members
  • Responsible for 3 modules, CARE, POS, KIT
  • Analyzed requirements from Business/Users
  • Involved in production support
  • Document Reports & Universe specifications and design
  • Involved in migration and report conversion activities
  • Involved in creating a test environment
  • Involved in the Development of reports using Business Objects/ Crystal Reports (XIR2 and R2)
  • Had meetings with DBAs and architects for the universe and reporting query costs
  • Improved the performance of reports and universes
  • Involved in defect analysis for both development and QA
  • Created test cases for both UAT and integration testing
  • Trained QA and CARE team about the reports

Data Quality Reporting Analyst

Morgan Stanley
New York, NY
  • We are developing Data Quality dashboards for Morgan Stanley which will give clients the ability to find the areas where existing client data is missing key elements including SSN, DOB, and Legal addresses etc., Our variety of dashboards which includes summary and detail level dashboards will cater to the needs of clients and identify the areas where data remediation is needed either on mass level or individual level
  • The process includes extracting data from the EDB source and loading it into the Data Quality data warehouse using Informatica and BO reports and Dashboards are generated out of it
  • Responsibilities
  • Attending functional design review meetings with clients and preparing technical design documents in approved templates from the client
  • Prepare and update data model diagrams (both Physical and logical) for reporting platforms
  • Attending reporting requirements review meetings with clients and other teams
  • Work with release management to plan for releases
  • Create and distribute status reports including dashboards to all stake holders
  • Participate in operational readiness activities
  • Create a project plan for each phase and share it with all the stakeholders
  • Leading the teams and sharing technical information with both the shores
  • Build phase of the project including BO reports and Tableau dashboards
  • Involved in peer review of the deliverables built by the team and vice versa
  • Assembly test of all the report-related objects
  • Migration of reporting deliverables from DEV to TEST and to PROD environment
  • Managing all reporting deliverables and measuring the actual timelines against one provided in the analysis phase
  • Involved in unit testing before releasing to the UAT team
  • Defect fixing and performance tuning where necessary
  • Provide KT sessions to the support teams
  • Involved in production migration support
  • Participate in post-implementation monitoring
  • Operating Systems Windows, Software / Special Tools Business Objects 4, , Web Intelligence, Information Design Tool, IBM DB2, IBM Data Studio, Tableau Desktop 9.0, Informatica

Designer

Golden, CO
Milwaukee, WI
  • Project Description This project is for MillerCoors which is one of the leading beer breweries in the US
  • I worked on several sub-projects at this client which includes MCDEM, and RIO (Phases 1-3)
  • In all these projects, MillerCoors Datawarehouse is being populated with new data from various interfaces and we have developed new universes and reports for each phase using the latest data
  • I also lead team in these projects both at onsite and onshore
  • Responsibilities
  • Manage and lead the delivery of reporting projects through the entire development lifecycle
  • Attending functional design review meetings with clients and preparing technical design documents in approved templates from the client
  • Attending reporting requirements review meetings with clients and other teams
  • Work with release management to plan for releases
  • Create and distribute status reports including dashboards to all stake holders
  • Participate in operational readiness activities
  • Create a project plan for each phase and share it with all the stakeholders
  • Leading the teams and sharing technical information with both the shores
  • Build phase of the project including BO reports and Tableau dashboards
  • Involved in peer review of the deliverables built by the team and vice versa
  • Assembly test of all the report-related objects
  • Migration of reporting deliverables from DEV to TEST and to PROD environment
  • Managing all reporting deliverables and measuring the actual timelines against one provided in the analysis phase
  • Involved in unit testing before releasing to the UAT team
  • Defect fixing and performance tuning where necessary
  • Provide KT sessions to the support teams
  • Involved in production migration support
  • Participate in post-implementation monitoring
  • Operating Systems Windows, 1, Web Intelligence, Universe, , Teradata, Informatica, Toad
  • Languages

Education

Bachelors in Engineering - Mechanical

Andhra University Andhra University
01.1996

Skills

  • Skills Profile
  • Technical
  • Operating System MS-DOS, UNIX, Linux
  • Environment Business Intelligence
  • Database DB2, Oracle, SQL Server, Redshift, Teradata, Netezza
  • Internet Tools HTML, Perl
  • Languages COBOL, Python
  • Products Workable
  • BI Tools Power BI, Tableau, SAP Business Objects, Spotfire, AXIOM
  • Functional
  • Management and Leadership Skills BI Architecture, Project Management, Strategic/ Tactical Planning, Business Analysis and Development, Budgeting/Forecasting, Responding to RFP, Collaborate, Problem solving, Client engagement, Staffing, onsite-offshore coordination
  • Training & Development BI Architecture, Tableau, Power BI
  • Operating Systems Windows
  • Hardware
  • Software / Special Tools Business Objects /Crystal Reports (XIR2), Web Intelligence XI, Webi, TOAD, Oracle 9i and 10g, Erwin, Star Team, Win2003, UNIX, Applix, PERL
  • Languages SQL
  • Training and Seminars
  • Impact EP from SSI Chennai
  • Harvard Connected Manager offered by Capgemini

Affiliations

Certifications , Prior Work Experience Details Organization’s Name Designation Dates of Employment Location (City & State) Explanation for Interruption / gap (If Any) From (DD-MON-YYYY) To (DD-MON-YYYY) Publications/Presentations Page 1 of 4

Timeline

BI Architect

Capgemini
03.2024 - Current

DQ Analyst and Tableau

Morgan Stanley, Capgemini
02.2020 - 02.2024

Title Tableau Architect

Capgemini
10.2019 - 01.2020

BI Architect

Capgemini, Wells Fargo
05.2019 - 10.2019

BI Architect

Wells Fargo, Capgemini
01.2018 - 04.2019

BI Architect

03.2016 - 12.2017

Reporting Analyst

Morgan Stanley
07.2015 - 02.2016

Reporting Analyst

Shire Pharmaceuticals
01.2014 - 07.2015

Designer

Accenture
05.2012 - 12.2013

Senior BI Analyst

Pfizer
08.2011 - 05.2012

Designer, Business Objects Architect

Mphasis, Motor Vehicle Commission, Convergys
06.2009 - 08.2011

Senior BI Analyst

05.2001 - 06.2009

Data Quality Reporting Analyst

Morgan Stanley

Designer

Golden, CO

Bachelors in Engineering - Mechanical

Andhra University Andhra University

Similar Profiles

CREATE PROFILE
SREENIVAS TALLA