Divija Sangaraju

Experience

• 

  Accenture

  Jul 2019 - Dec 2020

  Data Analyst

  ● Effectively communicate with product team and support Engineering team during development cycle Agile. ● Automate web-scraping tool to produce marketing content using Python. ● Use R statistical software for effective analysis by hypothesis testing to validate data and interpretations. ● Perform Data Management duties acquire validate, process, store and protect data for reliable accessibility to data users. ● Generating various reports (graphical) using Python packages like NumPy, Pandas, Matplotlib, SciPy, ggplot2. ● Create processes utilizing SQL Server Integration Services for the import, export, and transformation of data from and to SQL server. ● Create action filters, parameters and calculate sets for preparing dashboards and worksheets in Tableau. ● Analyze financial statements and internal cost accounting records of manufacturing enterprises in terms of ratio analysis and account balance reconciliations.● Perform slicing and dicing of data using SQL and Excel for data cleaning and data preparation. ● Performing data analysis and maintenance on information store in MySQL database. ● Working with Data Cleaning, Wrangling, Data Analytics, Modelling, Integration, ● Involved in defining the source to target data mappings, business rules, and data definitions.● Wrote SQL queries for data validation, analysis, and manipulation, and maintaining the integrity of the database. ● Analyzed the flow of data into the downstream data warehouse, which fed to data marts and end systems that support analytical and operational reporting.● Responsible for extracting specific data sets from the Operation database (ODS) by using PL/SQL query for data cleansing process and new feed processing purposes. ● Performed various ETL tasks Extracted the data from Oracle, Flat Files, Excel, Teradata Transformed (Implemented required Business Logic) and loaded into the target Data warehouse using SSIS (SQL Server 2008 R2). Show less

• 

  Appnovation

  Mar 2021 - Feb 2022

  Data Analyst

  ● Created data pipelines and multiple ETL tasks and data warehouse solutions using SSIS, and stored procedures/jobs and Windows services.● Collated and converted user requirements into business requirements, performed analysis, and segregated them into high-level and low-level business requirements.● Performed analysis using Python libraries for large datasets provided by clients.● Created and maintained reports for clients such as portfolio summaries, ad hoc reports, EOD balances, customer statements, and more.● Deployed reports and dashboards to clients' internal/remote servers. ● Involved in extraction, transformation, and loading of data directly from different source systems like flat files, JSON, XML, Excel, Oracle, and SQL Server.● Converting data into Business intelligence ● Design and maintain business intelligence tools, applications, databases, dashboards, and systems methods ● Program user interface and application of business intelligence solutions ● Worked with Cog nos reporting systems to extract the data for analysis using filters based on the analysis ● Reviewed the data model and reporting requirements for Cog nos Reports with the Data warehouse/ETL and Reporting team. Wrote several SQL scripts for massive data extracts and managed the data conversion and extraction process. ● Good experience with data requirements for migrating data from Third Party Vendors/Internal Systems to ODS and then to DW to cater to the needs of the Business Intelligence Users Team. ● Provided support to the software development team and sometimes served as a liaison between the end users and developers.● Interacted on a day-to-day basis with different groups to achieve a common deliverable.● Provided user acceptance testing and training to clients.● Always documented new processes and updated existing processes.● Performed several database tasks such as refactoring stored procedures for easier understanding, and improved performance. Show less

• 

  Investors Group Financial Services Inc.

  Mar 2022 - now

  Data Analyst

  ● Worked to elicit requirements, and facilitated and coordinated discussions between business and technical teams to clarify business, functional, non-functional, and Data requirements. ● Worked with the Data Management team to analyze sales data using tools like SQL, Access, and Excel (Lookup, Pivot tables) and predicting any future impacts on business.● Analyzed Data through querying via SQL from various database sources. ● Collected large financial data sets in Microsoft Excel and Access and created reporting for senior management. ● Analyzed current state SQL queries that generate current reports, and documented those logics in pseudocodes to make better understanding to technical folks for their technical requirement documentation.● Cleaned and processed third-party spending Data into maneuverable deliverables within a specific format with Excel and Python libraries such as NumPy and Pandas. ● Utilized Python and SQL Scripts to optimize complex SQL queries, to build and test various ETL data pipelines for Feature Implementation.● Responsible for developing database objects like Stored Procedures, Functions, Packages, and Triggers using SQL. ● Involved in relational and dimensional data modelling for creating Logical and Physical design of the database and ER diagrams using data modelling like Erwin. ● Used SQL to execute queries against the Oracle databases towards data analysis and data extraction into, among others, MS Access, MS Excel, and Text files. ● Created Excel reports and dashboards & and performed data validation activity using LOOKUP, HLOOKUP, Macros, formulas, index match, Slicer with (Pivot table, Get Pivot Data, Dashboards), Power View, Power Map, and Heat Map. ● Designed and developed weekly, and monthly reports by using MS Excel Techniques (Charts, Graphs, Pivot tables) and PowerPoint presentations. Show less