Data Analysis Quality Control
Resume:
Sruthi Gundu
***********@*****.***
Summary
·Over 15 years of experience in analysis, design and development of reports.
·Interacted with IT and Business Team at various levels and coordinated meetings during the different cycles of the project. Extensive experience in data analysis, profiling, data validation and data visualization.
·Experienced in working on Tableau (Desktop, Server, and Reader), creating Dashboards and Reports using different functionalities.
·Strong SQL skills related to information retrieval and analysis. Exposure to Client Interaction, User requirement Analysis and Support.
·Excellent experience in Banking and Finance domain.
·Preparation of process documents, Business requirements and Functional requirements document, Use case diagrams for development and quality control.
·Worked closely with developers, QA and business users to ensure the technical compatibility and user satisfaction
·Gave demos to the stakeholders to get them familiarized with the product and giving insights of the roadmap items
·Strong experience of designing, building, testing, documenting the SAP BO Universe
·Experienced in tuning long running SQL queries for better performance
·Experience implementing projects successfully with both waterfall and agile methodology
·Excellent research and analytical skills with attention to detail
·Collaboration with domestic and global teams and business stake holders across organization
·Excellent written and verbal communication skills.
Technical Skills
Databases: Oracle 11g/10g, Teradata, Microsoft SQL Server 2005/2008, DB2, Azure SQL, AWS Redshift
Reporting Tools: Tableau Desktop v9/V10, Tableau Server v9/V10, Tableau Reader, SAP Business Objects XI4.0, Crystal Reports 2011, Xcelsius 4.5, Salesforce Einstein Analytics, Salesforce Classic and Lightening
Languages: SQL, PL/SQL, Python, C, HTML
Cloud Platforms: AWS, Azure
ETL: Azure Data Factory, Azure Databricks, PySpark
Operating Systems: UNIX, Linux, Windows NT/2000/XP/7 and MS DOS
SQL Tools: Teradata SQL Assistant, SQL Developer, Rapid SQL, TOAD, SQL Server Management Studio
Other Tools: Microsoft Office (Access, Word, Excel, PowerPoint), Microsoft TFS
Academic Profile
Bachelors in Computer Science and Information Technology, JNTU 2006
Work Experience
Citi Bank, Tampa, FL April 2020 – February 2025
Lead Business Analyst & BI Developer (Tableau)
Global Foundation Layer, MSCI-ESG, IPMS (Investment Processing Management System)
•Responsible for participating in producing new Regulatory reporting requirements, understanding and modifying existing reports.
•Collaborated with business stakeholders to understand their data needs, requirements, and goals, and provided guidance on best practices, data governance, and data quality.
•Understanding business needs and conducting in-depth data analysis, data profiling and impact analysis to articulate detailed BRD’s and FSD’s for business users and technical team members consumption
•Responsible for Requirement Gathering, Flow diagrams, Data models, Data Gathering, updating DDF(Data Demand File), and ETL mapping specs.
•Translated technical research and data analysis into concise non-technical summary when communicated with business
•Collaborated with global, multi-functional and geographically diverse teams.
•Responsible for Mortgage, Retail Overdrafts and Wholesale Overdrafts products requirement gathering and UAT testing.
•Worked on CPB-CIM, ESG projects involving vendors MSCI, Morning star to ingest and analyze Market data.
•Detailing use case samples for dashboards and reports with coding standards that fit in overall architecture of the project in Technical Design Document
•Strong SQL (Analytical SQL & PL/SQL) to perform deep data analysis and investigation for root cause analysis for complex data problems
•Worked on dashboards using Stack bars, bar graphs, scattered plots, geographical maps.
•Ensure data accuracy and reliability of reports.
•Worked on Context Filters and handled performance issues while dealing with huge volume of data.
•Worked on tableau dashboards with Forecast and Reference lines.
•Administered user, user groups, and scheduled instances for reports in Tableau.
•Extensive experience on building Reports and Dashboards using Tableau and worked with advanced connections, join new tables, create & manage live and extract, Data blending, Relationships, Filters, Quick filters, Parameters, Hierarchies, Sorting, and Grouping, Advance Analysis Actions, Calculations, Background images, Maps, Individual Axis, Axis Blending and Dual axis, Data bins and histograms, Marks section and Page shelf.
•Designed data models and created optimized queries for efficient data retrieval and analysis.
•Conducted data analysis and modeling to identify trends, patterns, and anomalies, using tools such as SQL, Excel
•Worked with Data engineering teams to design, develop, and maintain data pipelines and data warehousing solutions, ensuring data integrity, security, and performance.
•Performed and supported detailed 16-point UAT testing on Foundation layer which includes balance reconciliation, Pre- Validation, Data Quality testing and escalation, Derivation testing for domestic and international markets, pre-validation and join validation.
•Presentation of FR2436: OTC derivatives report analysis to stakeholders.
•Managed delivery of projects/initiatives highlighted by the stakeholders as key deliverables.
•Managed full spectrum programs (platform, process, risk & control, design, testing, analytics) for Regulatory Reporting group.
•Report Analysis using Knime.
•Trained users in product usage and supported them as post production ongoing activity
•Build and maintain extraordinarily strong relationships with internal and external teams.
•Worked on Code and dashboard migration using git.
•Created JIRA user stories and tasks with detailed description and acceptance criteria for each ticket and assigned appropriate story points
•Maintained backlogs and assigned them into 2-week sprints based on business priority
Environment: Tableau, Oracle, SQL, PL/SQL, AWS, Hive, Python, Paxata, Knime, Git, UDeploy, Excel
Wellcare Health Plans, Tampa, FL April 2019– Dec 2019
Sr.Business Technical Analyst/ Tableau/ SQL Developer
•Developed ETLs to extract Members, claims and Providers data from a mix of source DBMS.
•Wrote complex SQL queries to create views, UDFs and stored procedures to accomplish business tasks.
•Wrote Dynamic SQL codes to be used in Reports.
•Developed complex SSRS reports using features like cascaded and multi select parameters to display KPIs at Enterprise level.
•Developed highly interactive, visually appealing and insightful Tableau dashboards and Stories including crosstabs, Heat maps, Box plots, Scatter plots, Geographic maps, pie charts, Gantt charts, Waterfall charts etc.
•Worked extensively to provide solutions to business questions using Tableau features like Calculated fields, Parameters, LOD Expressions, Table calculations, Moving Averages, Trend lines, Forecasting, Clustering and other Statistical measures
• Analyzed requirements, procedures, and problems to automate processing or to improve existing business systems
•Support, troubleshoot, and maintain systems and applications as required, optimizing performance, resolving problems, and providing timely follow-up on identified issues
•Conduct business analysis and recommend technical alternative solutions to management as a course of action that best meets the organization's goals
•Publishing reports on SAS Server, Report Server and Tableau Server Accomplishments
•Wrote code to validate and rectify auto assignment of PCPs to new members, using Geo Spatial data
•Automated Quarterly IPA Segmentation Report (An MS Excel based manual report using over 500,000 look ups) to a SSRS and Tableau based solution.
•Developed a Tableau and SSRS based Report to rank providers based on their HEDIS and MBR scores.
•Developed SQL code to generate random sample for audit by CMS
•Developed SQL code to calculate sample audit sizes for different Lines of Medicare and Medicaid Businesses
State Farm Inc, Bloomington, IL Aug 2018– March 2019
Sr.BI / Tableau Developer
·Involved in requirement gathering for data flows/reports/dashboards.
·Created data flows, datasets, recipes in data manager in Salesforce Einstein Analytics.
·Implemented data security by restricting datasets to few users using security predicate.
·Enable/disable data elements at field level in lightning.
·Worked on Life cycle of an opportunity-opportunity history reports.
·Worked on data Profiling using Recipes and Lens.
·Worked on data profiling by writing SOQL queries in workbench between opportunity and task objects.
·Analyzed why global data is visible to local agents and corrected the problem.
·Worked on Incremental and Full Sync in connect in data manager to sync the data from salesforce core to Salesforce Einstein.
·Created multiple datasets in a single dataflow.
·Worked on Workbench using SOQL Query to download data, to copy data, to transfer data from one environment to other.
·Worked on SAQL and SOQL queries.
·Displayed dashboards on homepage in lightening.
·Worked on problems with Aliases in dataflows.
·Worked on tasks and Events and connecting them to opportunities/leads using what id and who id.
·Worked on custom Pick list values in filters in Lightening.
·Worked on the Role Hierarchy with CEO-SVP-AVP-VPA-SL-Agent-ATM-Proxy.
·Created Claims dataflow with multiple Loss reports objects.
·Rapid development implementing agile methodology using version one.
·Worked on Code and dashboard migration using gitlab with json objects.
Environment: Salesforce Einstein Analytics, Salesforce Classic & Lightening, Einstein Data manager.
Fieldcore Services (A GE Company), Tampa FL July 2017 – May 2018
Sr. Tableau Developer/Business Technical Analyst/
·Requirement gathering for reports/dashboards.
·Designed dashboards for payroll.
·Created worksheets with visualizations, Text tables, Dashboards and stories
·Worked with live data sources with large volumes of data
·Worked on performance improvement of few dashboards.
·Worked on data validation of data which is made available for reports.
·Created Action Filters, Parameters, calculated sets for preparing dashboards and worksheets in Tableau.
·Worked with adhoc requests from business users to correct the existing dashboards.
·Worked extensively with Data Blending, Advance analysis Actions, Calculations, Parameters, Background images, Maps
·Designed and perfected the reporting requirement documents and the tracker logs to track and assign the work packets until they get completed /resolved.
·Defined best practices for Tableau report development.
·Used Drilling, formatting, page-by on the reports.
·Generated reports by using custom groups.
·Involved in extraction, transformation and loading of data directly from different source systems like flat files, Excel, Oracle and SQL Server to destination databases using data flow components.
·Worked with live and extract connections.
·Worked extensively with Calculations and Actions.
Environment: Tableau 10.2, ORACLE 10g, SQL Server 2014, Business Objects 4.0/XIR2.
Northern Trust Bank, Chicago, IL Aug 2013 – Oct 2015
Tableau/ Sr BI Developer
·Requirements gathering meetings with IT Partners, SMEs, business team and external vendors.
·Involved in writing detailed functional specification documents for large scale projects
·Performed data analysis on large data volumes to support business decision making.
·Worked closely with different groups in the team to resolve several data challenges during data mapping, data verification/validation and ongoing production issues
Tableau:
·Created Tableau worksheets and dashboards for Charles River trading application reports.
·Participated in the user requirement gathering and Design meetings.
·Created advanced connections, join new tables, create & manage live and extract, Data blending, Relationships, Filters, Quick filters, Parameters, Hierarchies, Sorting, and Grouping, Advance Analysis Actions, Calculations, Background images, Maps, Individual Axis, Axis Blending and Dual axis, Data bins and histograms.
·Extensively used Marks section and Page shelf.
·Created dashboards using Stack bars, bar graphs, scattered plots, geographical maps.
·Ensure data accuracy and reliability of reports.
·Generated Context Filters and handled performance issues while dealing with huge volume of data.
·Generated tableau dashboards with Forecast and Reference lines.
·Administered user, user groups, and scheduled instances for reports in Tableau.
SAP BO:
·Involved in the designing and Building of Universes, Classes and objects.
·Resolved loops and Traps using Contexts and Aliases while designing Universes.
·Created Derived tables in the Universe Designer to enhance performance of the universe.
·Created Crystal reports using add command, stored procedures and universes.
·Migrated reports to SIT, UAT and PROD using promotion management.
·Worked with quality assurance team in BRD walk through sessions and in testing phase.
·Helped business users with Post production activities and issues.
·Given KT to new team members.
·Worked on various emergency production fixes.
Environment: Tableau V9, ORACLE 11g, Business Objects 4.0/XIR2, Crystal Reports 2011, IDT, Teradata v12, Rapid SQL, Teradata SQL Assistant, Microsoft Office, Charles River Application.
CF Industries, Deerfield, IL Jul 2012 - May 2013
Sr BTA/ Tableau Developer
·Involved in gathering the requirements from Business Users.
·Analyzed these requirements and prepared Technical Specifications Document for crystal reports.
·Involved in data modeling discussions with system analysts and data modelers.
·Created Crystal reports using complex multiple sub reports, passing data from sub reports to main reports and managing the report.
·Formatted the Various Crystal reports according to the specifications by the end user.
·Created Webi and Crystal reports and dashboards according to user requirements.
·Validated the data such that it is pulling the intended data from SAP BW to reports and created a Unit test document for those reports.
·Modified already existing Crystal reports according to customer requirements.
·Created groups according to the report requirement, sorted the data in groups, managed the groups, giving different header names. Used specified order for the groups.
·Modified the Crystal reports to increase the performance of reports.
·Designed, implemented and migrated complex Universes and Business Objects Reports, Created classes, subclasses, objects, Cardinalities, Conditions, Contexts, Joins.
·External Strategies, Prompts and Aliases for resolving Loops and checked the Integrity of the Universes.
·Created complex reports using Merged Dimension and multiple data providers and synchronized the data providers by linking the common objects to create the common report.
·Developed Universes, Webi, Webi Rich Client reports.
·Involved in Building universe, Inserting tables, Detecting joins, Detecting cardinalities and checking the integrity.
·In Universes, created classes, objects, Prompts, Predefined conditions, by retrieving the data from data sources and defining the necessary connections.
·Involved in the troubleshooting of universe schema with loops, chasm and fan traps, and cardinality problems.
·Implemented the Object-Level Security and Row-level security in Universe.
·Designed and developed extensive Business Objects reports like Simple, Complex, Cross Tab using multiple Queries, Prompts, combination chart and tables.
·Created complex reports using user-defined functions like @variables, @prompt, condition Objects and Aggregate Awareness Functions for SQL enhancement.
·Created users, groups, server groups and setup security architecture.
·Created the reports using Business Objects functionalities like Combined Queries, Drill down, Cross tab, Master detail, Formulas, Optional Prompts, Functions, Alerters etc.
·Created Breaks, Filters at Different Levels of the reports and applied ranking in the Webi reports.
·Deployed Business Objects Universes and Reports in a Secure Environment from One Server to Other Servers using Import Wizard.
Environment: Business Objects XI3.1/XIR2, Web Intelligence, Universe Designer, Business View Manager, Desktop Intelligence, Crystal Reports 2008, SQL Server 2008, ORACLE 10
ACS Ltd, Bangalore Sept 2010 – Jan 2011
Sr BTA/ Tableau Developer
·Connected to the different databases like SQL Server / Oracle / Sybase etc.
·Created different kinds of reports like Standard reports, mailing label reports, Cross Tab reports.
·Created complex formulas, Sub-Reports, different kinds of Charts, Dynamic Cascading Parameter, Static / dynamic- parameters
·Publishing the developed report to the Repository.
·Formatted the reports with conditional formatting or non-conditional formatting.
·Worked on Summaries and Manual Running Totals using default crystal option.
·Applying Row Level / Column Level security through crystal reports.
·Exporting the reports to various formats like PDF, Excel and Data Definition etc.
·Created Data Connection to the database, Dynamic Data Connection, Data Foundation, Business Element, Business View.
·Creating a list of values for the report (Dynamic parameter)
·Applied row level security and column level security using BVM.
·Creating filters at data foundation and business element level.
Environment: Business Objects XI R2, Broadcast Agent, Infoview, Crystal Reports XI, Xcelsius 4.5, Performance Management, Dashboards, Toad, SQL, PL/SQL, Oracle 8i, Windows 2000, MS SQL Server 2000, MS Office.
Goldstone Technologies Ltd, Hyderabad Nov 2007 - Aug 2010
Technical Associate
Client: Business Objects, a SAP Company
·Worked on data profiling to see whether data met the expectations of business requirements.
·Worked on documenting functional specifications and data mapping rules.
·Created Crystal reports using complex multiple sub reports, passing data from sub-reports to Main reports and managing the report.
·Used On-demand, normal sub reports concepts in the Crystal reports.
·Formatted the Various Crystal reports so that the end product will look as specified by the end user.
·Used fetching data from command objects and various databases.
·Modified already existing Crystal reports according to customer requirements.
·Modified the Crystal reports to increase the performance of reports.
·Created complex reports by linking data from multiple data providers, using free hand SQL, stored procedures and functionalities like Combined Queries, Sub Queries.
·Applied row level and object level securities on different groups and users.
·Developed standard, cross-tab, On Demand and Drill-down Reports using Crystal Reports.
·Use the slice and dice feature, set variables, and set alerts and group values in a report.
·Built queries to retrieve data through a universe and set up query conditions.
·Created Cross-tab and Master Detail reports in Business Objects.
·Creating complex reports using features like slice and dice, Drill capabilities, Functions and Cross Tab tables with multiple breaks.
·Used alerts to highlight critical data based on business conditions.
·Created various MTD, YTD and daily reports.
·Extensively used Calculations, Sorting, Rank, Drill, Slice and Dice.
·Created classes and objects and logically grouped them together and defined business names for the classes and objects.
Environment: Crystal Report / Business Objects Enterprise, SQL Server 2000/2005, Oracle 9i/10g, TOAD, MS Access 2000 / 2003, MS Office Suite, Windows XP / Windows 2003 Server.
Certifications
Crystal Reports 2008 Certification (Level 1, 2)
Business Objects XI3.1 Certification (Level 1, 2, 3)
Contact this candidate