Data Analyst Business Intelligence
Resume:
ANJU SUSAN RAJU
Mob: 678-***-****
Email: - ********@*****.***
LinkedIn: - https://www.linkedin.com/in/anju-raju-91aa2257/
Career Objective:
To apply my functional & technical expertise in software development & contribute to the development of high-quality software products in your organization.
Professional Summary:
Experienced Data Analyst with 10+ years in IT and 9+ years specializing in SQL development, Azure SQL, Databricks, Python, and cloud-based ETL pipelines. Skilled in designing scalable data architectures and delivering clean, reliable, and insightful data for enterprise reporting and analytics.
Built a modern, end-to-end data ecosystem from the ground up using Azure Data Factory, Azure Databricks, and Azure SQL Managed Instance, enabling secure and automated data workflows across multiple sources such as Box, SmartSheets, Excel, APIs, and SQL databases.
Strong expertise in SQL administration, including:
Database and table creation, schema changes, indexing, and partitioning
Query tuning using execution plans and performance metrics
SQL Server Agent jobs, alerts, backups, and monitoring
Role-based access control (RBAC) and user permission audits
Table maintenance with data archival, purging, and growth monitoring
Proficient in building dynamic Tableau dashboards and reporting solutions to visualize trends, KPIs, and usage metrics. Hands-on experience with .NET, AngularJS, JavaScript, and other full-stack tools for application development. Agile team player with experience using Abraca’s Data Kanban board, participating in Scrum calls, and collaborating cross-functionally. Familiar with Agile/Waterfall SDLC, QA processes, and ITIL-based delivery models.
Technical Skills
Data Engineering & Analytics:
Python, Databricks, Azure SQL, SQL Server, Azure Data Factory, SSIS, Tableau
Database Development & Administration:
Stored Procedures, Views, Triggers, Table Maintenance, Indexing, Query Optimization, Execution Plan Analysis, SQL Agent Jobs, Backups, RBAC
ETL & Data Integration:
Azure Data Factory, Databricks Jobs, APIs, Excel, SmartSheets, Box
Data Visualization & Reporting:
Tableau, Excel Reporting, Report Summarization
Web & Application Development:
ASP.NET (2.0–4.0), C#.NET, ADO.NET, JavaScript, AngularJS, jQuery, HTML5, CSS3, WPF, WCF
Project & Agile Tools:
Abraca (Data Kanban), ServiceNow (SNOW), HPSM, DWNG
Additional Knowledge Areas:
ITIL, Agile/Scrum, SDLC, UML, Use Case Design, Data Governance, Six Sigma & Lean methodologies
Professional Experience:
Role : Senior Data Engineer
Duration : 03/27/2022 – Till
Employer : CompuCom, United States
Customer : GE Corporate, Atlanta
Roles & Responsibilities:
Designed and developed multiple data projects by integrating Excel data from Box into Azure SQL using Databricks and Python.
Built scalable, end-to-end ETL pipelines in Databricks to handle data ingestion, transformation, validation, and loading into Azure SQL.
Automated data workflows using Databricks Jobs, ensuring scheduled execution, error handling, and monitoring for pipeline reliability.
Developed and optimized complex stored procedures, views, and user-defined functions in Azure SQL for data preparation and reporting.
Performed comprehensive table maintenance, including:
Schema creation and modification
Indexing and statistics updates
Data archival, purging, and retention strategies
Monitoring table growth, fragmentation, and performance impact
Applied SQL performance tuning techniques such as execution plan analysis, index usage optimization, and query rewriting to improve performance across large datasets.
Created Python scripts for data ingestion from various sources including APIs, Excel files, and databases, preparing data for transformation in Databricks.
Collaborated with business stakeholders to understand data/reporting requirements and translate them into automated solutions with scheduled refreshes.
Developed and maintained interactive dashboards in Tableau, enabling data exploration and visualization of KPIs, usage trends, and licensing metrics.
Ensured data governance and security by implementing role-based access control (RBAC) in Azure SQL, enforcing access restrictions and compliance standards.
Participated in a large-scale database migration from on-premises SQL Server to Azure SQL, including schema comparison, data validation, and post-migration performance benchmarking.
Conducted data profiling and quality checks to identify anomalies and ensure clean, accurate datasets for downstream analysis.
Data Extraction and Querying:
Retrieve data from Azure SQL databases using SQL queries.
Develop complex queries to filter, sort, and aggregate data based on specific criteria.
Optimize queries for performance and efficiency, considering indexing strategies and query execution plans.
Data Analysis and Interpretation:
Apply analytical techniques to identify patterns, trends, and relationships within the data.
Perform statistical analysis, such as calculating averages, correlations, and standard deviations.
Conduct data profiling and exploratory data analysis to gain insights and support decision-making.
Data Collection and Cleaning:
Gather data from various sources, including databases, spreadsheets, APIs, and other relevant platforms.
Assess data quality, identify inconsistencies, and clean and organize data sets for analysis.
Data Visualization and Reporting:
Create clear and compelling visualizations, such as charts, graphs, and dashboards, to communicate complex data analysis results effectively.
Create visualizations, reports, and dashboards to present analyzed data in a clear and meaningful way.
Prepare comprehensive reports summarizing key findings, trends, and recommendations for stakeholders at various levels of the organization.
Present findings to both technical and non-technical audiences in a concise and understandable manner.
Utilize visualization tools such as Tableau to build interactive dashboards and reports.
Communicate findings and recommendations to stakeholders, both technical and non-technical, effectively.
Data Transformation and Modeling:
Clean and transform raw data into a structured format suitable for analysis.
Develop data models and schemas to organize and optimize data storage and retrieval.
Collaborate with database administrators and data engineers to design and implement efficient data pipelines.
Data Governance and Security:
Ensure data integrity and security by implementing appropriate access controls and data protection measures.
Follow best practices for data governance, including data classification, data retention, and compliance requirements.
Performance Monitoring and Optimization:
Monitor database performance, identify bottlenecks, and optimize SQL queries for improved efficiency.
Analyze query execution plans and suggest optimizations to enhance overall database performance.
Collaborative Problem Solving:
Collaborate with cross-functional teams to identify and address data-related challenges.
Work closely with stakeholders to understand their data needs, provide insights, and support data-driven decision-making processes
Role : Senior IT Analyst
Duration : 12/03/2018 – 04/30/2020
Project Name : DRA-Directory Resources Administration
Employer : Tata Consultancy Services (TCS), Bangalore
Project Details:
DRA (Directory and Resource Administrator) is an application that allows custom security to be applied to Active Directory (AD). Active Directory is a database containing information such as user details, groups (e.g. distribution groups) and resources, such as printers. It is now also the basis of the Shell Global Group Directory (GGD).DRA (Directory and Resource Administrator) from NetIQ is the tool that has been chosen to facilitate the Management of the Shell Active Directory. DRA is the interface to use for User and Group modifications to Active Directory wherever possible. This will allow the development and maintenance of one common set of business rules and policies. It is vital that data in Active Directory is validated and that the rules and policies are adhered to. By using DRA We can perform the operation on the following Resources
User Tasks – Includes user creation, user management, changing passwords.
Group Tasks – Includes group creation, modifying group membership.
Computer Tasks – Includes computer group management, viewing computer details
Exchange Tasks – Includes distribution list creation and management.
Reports – Includes downloadable reports for software groups, mobile office users, and other areas.
Change Managed Domain – Allows you to change the managed domain.
Roles & Responsibilities
Delivering prompt, professional solutions for customer inquiries.
Working to meet immediate goals of customer interaction.
Implementing improvements to customer service.
Training and managing the team members to work on the application well.
Collaborate with team members to understand organizational and operational challenges
Working on the incidents, user requests and monitoring the application.
Finding the Root cause of the issue and fixing the issue.
Implementations & Deployments for the DRA Servers.
Raising change through ServiceNow and implementing and deploying the change in the servers
Working on problem management and change management in ServiceNow.
Migration of DRA servers from HP server to TCS servers through ServiceNow implementation.
Coordinate with different departmental teams to produce better business outcomes
Test business processes and recommend improvements
Preparing articles that provide users with information such as self-help, troubleshooting, and task resolution.
Additional Project details
Role : Senior IT Analyst
Duration : 12/03/2018 – 04/30/2019
Project Name: ONE Drive for Business (ODB)
Employer : Tata Consultancy Services (TCS), Bangalore
Project Details:
User Home drives are getting migrated to One Drive for Business and users need to be notified on this activity. Project scope is to develop a PowerShell script that retrieves users from AD based on some filters and add/remove users to/from DLs
Platform used: - Pearl Scripting, Active Directory, Agile, Software Testing, ServiceNow
Roles &Responsibilities
Assist with client and TCS project management for the Project
Prepare the HLD Project documentation for client project team with the budget and man hours needed.
Testing the ODB using software testing methodologies.
Implementations & Deployments for the ODB Russia users.
Raising change through ServiceNow and implementing and deploying the change in the servers
Role : Senior IT Analyst
Duration : 05/01/2019 – 09/30/2019
Project Name: VASCO IAS -TP users
Employer : Tata Consultancy Services (TCS), Bangalore
Project Details: -
IDENTIKEY Authentication Server is a server product designed to support the deployment, use, and administration of VASCO DIGIPASS technology. IDENTIKEY Authentication Server can be easily integrated with existing applications using a Software Development Kit (SDK).
Platform used: - Microsoft Visual Studio 2016, MS Sql Server, Active Directory, Agile, Software Testing, ServiceNow
Roles &Responsibilities
Prepare the HLD Project documentation for client project team.
Develop SQL databases including back-end data for web applications and data storage.
Create and optimize SQL queries to sort, retrieve or store data
Conduct testing and perform troubleshooting on databases to ensure accuracy, security, and efficiency.
Testing the entire VASCO IAS using software testing methodologies.
Implementations & Deployments for the VASCO IAS in DRA Servers.
Raising change through ServiceNow and implementing and deploying the change in the servers
Role : Senior IT Analyst
Duration : 09/30/2019– 04/30/2020
Project Name: DRA Test Lab
Employer : Tata Consultancy Services (TCS), Bangalore
Project Details: -
DRA (Directory and Resource Administrator) from NetIQ is the tool that has been chosen to facilitate the Management of the Shell Active Directory. DRA is the interface to use for User and Group modifications to Active Directory wherever possible. This will allow the development and maintenance of one common set of business rules and policies. It is vital that data in Active Directory is validated and that the rules and policies are adhered to. By Using DRA, We can perform the operation on the following Resources
User Tasks – Includes user creation, user management, changing passwords.
Group Tasks – Includes group creation, modifying group membership.
Computer Tasks – Includes computer group management, viewing computer details
Exchange Tasks – Includes distribution list creation and management.
Reports – Includes downloadable reports for software groups, mobile office users, and other areas.
Change Managed Domain – Allows you to change the managed domain.
Platform used: - Microsoft Visual Studio 2016Active Directory, Agile, Software Testing, ServiceNow, UI Designing(HTML,Javascript,CSS)
Roles & Responsibilities
Implementations & Deployments for the DRA Servers.
Prepare the HLD Project documentation for client project team
Raising change through ServiceNow and implementing and deploying the change in the servers
Conduct testing of completed applications, websites, and software to Assess user experience.
Use coding to develop the aesthetics implemented within a website or product, from the layout menus and drop-down options to colors and fonts
Testing the DRA Test Lab functionalities using software testing methodologies.
Role : Senior Service Delivery Consultant II
Duration : 08/12/2014 – 11/30/2018
Employer : DXC Technologies (formerly Known as HP, HPE), Bangalore
Project Name: DRA-Directory Resources Administration
Platform: Microsoft Visual Studio 2010, MS Sql Server, Active Directory
Quarterly Audit & Attestation: DRA Audit and Attestation
Roles & Responsibilities: -
Control Owner for the below controls -09.02.01a – DRA Access Request. Control Number: -08.17.03 – DRA Logs Protection.
Project Name: DRA (Directory Resource Administration
Description: - DRA-Directory Resources Administration
DRA (Directory and Resource Administrator) is an application that allows custom security to be applied to Active Directory (AD). Active Directory is a database containing information such as user details, groups (e.g. distribution groups) and resources, such as printers. It is now also the basis of the Shell Global Group Directory (GGD).DRA (Directory and Resource Administrator) from NetIQ is the tool that has been chosen to facilitate the Management of the Shell Active Directory.DRA is the interface to use for User and Group modifications to Active Directory wherever possible. This will allow the development and maintenance of one common set of business rules and policies. It is vital that data in Active Directory is validated and that the rules and policies are adhered to.
Roles & Responsibilities:
Working on the incidents, user requests and monitoring the application through ServiceNow
Finding the Root cause of the issue and fixing the issue.
Implementations & Deployments for the DRA Servers.
Upgrade version DRA 8.6 to 9.0
Working on change requests through ServiceNow.
Project Name: AIDED – Account Identify Disable Enable Delete
AIDED is the Automation tool which can identify the user accounts which are not using for 30days from Active Directory. Aided will send the notification to the user, If the user is not using his/her account more than 45 day account AIDED disable the account and send the report to the user line manager. If the account is not using more than 60 days AIDED delete that account and send the report to the Housekeeping team and move the account to obsolete container. After 60 days the account will be deleted permanently from AD.
Role & Responsibilities:
Working on the data related.
Monitoring the tool working fine or not if the tool is failing fixing the issue and fixing the tool.
Monitoring the AIDED mailbox and Check the reports are generating correctly or not.
Checking the reports are send to the concern teams or not investigate the issue and fix it.
Working on the incidents, user requests and monitoring the application.
Project Name: Helpdesk Administrative Tool (HAT)
HAT is a web-based application that allows Helpdesk to perform actions in Active Directory. The functions and design of HAT are catered to suite the Helpdesk Active Directory-related job functions in GI. This application is extended from DRA as a solution that provide Helpdesk with a fast and easy access to AD without resorting to MMC. Currently the HAT is co-hosted on selected DRA servers globally and is only used by Helpdesk personnel.
Roles & Responsibilities:
Working on the incidents, user requests and monitoring the application.
Finding the Root cause of the issue and fixing the issue.
Implementation & deployments projects for Shell account (TOOL SUPPORT)
Role : Software Developer
Duration :10/08/2010– 06/30/2011
Employer : Microland Pvt Ltd, Bangalore
Platform used: Microsoft Visual Studio 2010, MS Sql Server, HTML5, JavaScript, CSS.
Project Name: FIM
Microsoft Forefront Identity Manager (FIM) 2010 R2 helps you provide self-service identity management for your users, automated lifecycle management across heterogeneous platforms for your administrators, and a rich policy framework for enforcing corporate security policies and detailed audit capabilities.
Roles & Responsibilities:
Developing similar platform of FIM in C#.net and SQL.
Testing the product using software testing methodologies.
Use coding to develop the aesthetics implemented within a website or product, from the layout menus and drop-down options to colors and fonts
Develop overall concepts for improving the user experience within a business webpage or product, ensuring all interactions are intuitive and convenient for customers
Collaborate with back-end web developers and programmers to improve usability.
Role : Associate Software Developer
Duration :03/14/2010– 06/03/2010
Employer : Technip France, Abu Dhabi, UAE
Platform Used: Microsoft Visual Studio 2010, Microsoft SQL Server2008, CSS, HTML, MVC JavaScript
Project Name : Janus
Janus is a Progress measurement home service application for Technip group. The project is created in the windows-based machine. The entire web application is developed in ASP.net 3.5 and Oracle 10g.
Roles & Responsibilities:
Developing the code for the product in C#.net and SQL.
Analyze the code and review it and do the basic testing for the application.
Role : Associate Software Developer
Duration :05/01/2007– 12/31/2008
Employer : Anwar Al-Qatami Co., Kuwait
Platform Used: Microsoft Visual Studio 2008, Microsoft Visual Studio .net, Microsoft SQL Server, JavaScript, CSS,HTML.
Project Name: Ford Website
Ford is an automobile company, this site made for company profile, new cars, news and events & career options. In this site user can do online registration, online booking, searching cars and post their feedback also. Payroll is included in this project for the customers to apply loan.
Roles & Responsibilities:
Use coding to develop the aesthetics implemented within a website or product, from the layout menus and drop-down options to colors and fonts
Develop overall concepts for improving the user experience within a business webpage or product, ensuring all interactions are intuitive and convenient for customers
Collaborate with back-end web developers and programmers to improve usability
Developing the code for the product in C#.net and SQL.
Analyze the code and review it and do the basic testing for the application.
Project Name: Early Birds Consulting Inc. USA
This is a corporate website offering the functionalities of a job portal wherein a candidate seeking for a job and the employer must be registered to apply and to post a particular job under various categories and skills. This application is also equipped with an effective search mechanism which can produce the result in a lesser period of time. Authentication is done by the webmaster for both the parties, candidate as well employer. Payment module is incorporated with this application so that any employer can register in successfully based on the payment terms and conditions offered
Platform Used: Microsoft Visual Studio 2008, Microsoft Visual Studio .net, Microsoft SQL Server, JavaScript, CSS, HTML.
Roles & Responsibilities:
Developing the code for the product in C#.net and SQL.
Analyze the code and review it and do the basic testing for the application.
Use coding to develop the aesthetics implemented within a website or product, from the layout menus and drop-down options to colors and fonts
Develop overall concepts for improving the user experience within a business webpage or product, ensuring all interactions are intuitive and convenient for customers
Collaborate with back-end web developers and programmers to improve usability
Education & Certification
Master’s in computer applications from Anna University, 2006.
Degree of Bachelor of BSc Mathematics from Mahatma Gandhi University, 2003.
Certification: Programming in C# Jump Start from Microsoft Virtual Academy
Diploma in .net Technologies from NIIT, Bangalore
Certification of completion: -Developing Microsoft Azure Solutions (M20532)
Certification in ITIL V4, Google Analytics Certification
Google Data Analytics Certificate, Coursera 2025
REFERENCE: - Will be provided upon request. Anju Susan Raju
Contact this candidate