Shruthi Chandra M Email & Phone Number

Canada

Greater Vancouver Metropolitan Area

• Worked for Canada’s Public sector client as a Lead Data Warehousing Designer, where I met with the stakeholders for Scope Estimation, Requirement Gathering, conducting Data Modelling design sessions and supported with Data Migration activities.• Followed Agile and Waterfall methods as part of application team and Datawarehouse team respectively.• Led two important streams under a Large Transformation Project as part of DW team, where I made sure the data reporting requirements are captured on our backend system and were easily accessible to client for daily reporting.• Worked with front-end developers, application designers and testing team to design Data warehousing models for clients.• Implemented data pipelines using Informatica to automate ETL processes across various data sources.• Worked with Oracle BIEE to design and develop reports and dashboards to meet specific requirements for our business users.• Led onshore/offshore teams to route the approved designs for development, reviewed them and provided guidance.• I closely monitored the Dev activities, checked the project status, unit tested the final developments to deliver quality results.• Actively presented the developments at every stage to client to seek approvals. Prepared project documentation to capture all levels of changes in data. Supported with Release management migration activities for smooth Go-live.Environment: Informatica, SQL, OBIEE reporting, DAC scheduling tool, Excel

Phoenix, Arizona Area

• Followed Agile project methodology, attended daily Huddle meetings and participated in Sprint planning’s.• Worked closely with business users to understand the requirements and Interacted with Dev team, Data Scientists, Data Engineers and Database Developers to detail requirements for data preparation.• Collaborated with Data Engineers team and involved in building ETL pipelines for data storage and processing for analysis.• Developed Hive queries to extract the data from Data Warehouses and process it for business needs.• Used SQL to extract data for database reporting needs and created meaningful reports for the business.• Implemented Joins and Data Blending in Tableau to extract data from single and multiple source types, respectively.• Developed Tableau/Power BI dashboards on operational data based on crew login-logout, project performance, call quality, customer feedback, success rate information to fetch insights and made recommendations to support business decision making.• Analyzed historic data by creating reports on customer call data, identified trends on various metrics and presented the insights.• Coordinated with Lead Analysts and automated business processes, converted Excel reports to Tableau to minimize manual work.• Met with clients on a regular basis and made presentations, took feedback and improved the visualizations at every stage.Environment: Tableau Desktop 10.5/2019.2, Tableau Server, Cognos, SQL, Tableau Prep, SSIS, Power BI, AWS, SQL Server 2012

Phoenix, Arizona Area

• Participated in translating business customer needs into Business Intelligence reporting solutions by using Tableau Desktop and Tableau Server, while working with BI Architects and Data Warehousing Developers.• Involved in Data profiling, ETL transformations for structured data prep using Tableau Prep, working alongside Data Engineers.• Involved in Tableau Server installations, backup of servers, server migration from 10.5 to 2019.1 and responsible for administrative functions like assigning privileges to users, publishing workbooks on the Tableau server for scheduled refreshes etc. • Used SQL to connect and manipulate data in SQL Server DB, created Views to simplify complex joins and increase performance.• Interacted with Financial clients to understand data requirements and translated them into design documents and Visualizations.• Worked on large financial datasets and created Tableau dashboards using parameters, sets, groups, calculations, drill down and drill ups to deep-dive and find root cause of the problem areas to provide insightful reporting and support business decisions.• Created dual-axis charts with multiple measures based on user requirements for analyzing various trends in data.• Developed story telling dashboards in Tableau Desktop and published them to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand information. Environment: Tableau Desktop 10.5/2019.1, Tableau Server, Tableau Prep, SQL, MS SQL Server 2012

Houston, Texas Area

• Assisting students with course work, while working with professors and academic advisors.• Helped in Kardex filing, scheduling appointments for students with advisors, answered phone calls and emails to clarify student’s questions related to academics and admissions.• Used SQL to make required updates to student database and worked on student data to analyze semester wise admission rate.• Analyzed student enrollment data and produced reports on various metrics using Tableau, Power BI and Excel.Skills: SQL, Tableau, Power BI, MS Excel

Hyderabad Area, India

Client - Airbus• Contributed to customer/client requirements gathering and coordinated with the Software Development Team and Data Engineers to define standards and technical specifications.• Worked in Agile environment and was involved in daily SCRUM meetings and Sprint planning’s.• Created Database functions like Joins, Views, Sub-Queries to facilitate data flow in SQL Server.• Executed ETL Transformations such as Derived Column, Fuzzy Lookup, Conditional Split, Aggregate, Merge Join using SQL Server Integration Services to transfer data from various source files to SQL Server.• Skilled in Error and Event Handling using Precedence Constraints, Break Points, Check Points and Logging.• Built OLAP cubes in SSAS, identified the key Facts and Dimensions, and used Star Schema for Dimensional modelling.• Developed Visualizations on operational data, using various chart types like Crosstabs, Bar charts, Line charts, Pie charts, Maps and Scatter plots in Tableau Desktop to derive business insights and presented them to stakeholders.• Merged different Reports into interactive and Story-telling Dashboards in Tableau to analyze various operational KPI's and made recommendations to the leaders which helped rectify problem areas and increase efficiency.Environment: Tableau Desktop 8.0, Tableau Server, SQL Server Integration Services, SQL, SQL Server 2008, IBM Cognos

Hyderabad Area, India

Client - Infosys• Collaborated with Database team and designed a Database schema for Infy TV application, established relationships for various tables using E-R Diagrams, in MS Visio. Documented the Data models, flowcharts and use cases created.• Wrote SQL queries using Joins, Grouping, Aggregation, Sub-Queries, etc.• Imported, exported and manipulated large datasets in the database using SQL for Data Analysis.• Performed Data Extraction, Transformation and Loading (ETL) in Informatica for Integrating data from multiple source systems.• Worked on Data mapping using transformations like Joiner, Expression, Rank, Sorter, Sequence generator, Lookup to transform source data according to the target systems requirements using Informatica Power Center.• Created Reports to analyze the Weekly, Monthly, Quarterly usage and uncover Infy TV channel access patterns using Tableau.• Created parameters, sets, groups, normal filters and context filters to develop Dashboards in Tableau.• Scheduled data refreshes on Tableau Server to automate weekly and monthly updates to display data accurately. Environment: Tableau Desktop 7.0, Tableau Server, Informatica Power Center 9.1, SQL, SQL Server 2008

Hyderabad Area, India

• Conducted Data Analysis on customer call data using Tableau, Excel and reported findings on various ad-hoc requests concerning Service Level Agreement, Agent performance etc. to help clients make business decisions.• Analyzed various metrics which helped reduce human effort by automating business processes.• Worked on structured and unstructured data from various source files like Excel sheets, text files etc.• Used MS Excel concepts like Pivot Tables, VLOOKUP's, Formulas and Indexes for Data Analysis.• Created Reports and presented them through MS PowerPoint and MS Office tools to my mentors and the clients.Environment: Tableau, MS Excel, MS PowerPoint, MS Word

Hyderabad Area, India

• Used DDL and DML commands to develop SQL queries for inserting data, updating data and for data flow from source systems to target systems.• Created Database tables, Lookup tables, Views for data manipulation. • Used Informatica Suite of application to ETL data to the target system.• Created Informatica Mappings using Expression, Filter, Union, Normalizer, Source Qualifier, Joiner Transformations.• Developed SQL queries for data validation to verify the ETL Mapping Rules.• Worked on the application data to understand the user access patterns to improve performance by creating Reports in MS Excel.Environment: SQL, SQL Server 2008, Informatica Power Center 7.1, MS Excel

Master'S Degree, Management Information Systems, General

Bachelor'S Degree, Information Technology