LogIn

Don't have an account? Register now

Forgot Password?

Register

Custom

Select Your Default Landing Page

Photo

Anusha ****** Senior Business Intelligence Developer

Summary

Accomplished Software Engineer with 9 Years of Experience in MS SQL, ETL and BI Reporting.

Thorough SQL Developer with an expert grasp of SQL code generation, analytics, reporting and business intelligence. Diverse knowledge of complex T-SQL coding instances.

Experience across the entire Microsoft BI suite of products including SQL Server, SSIS, SSRS, SSAS and Power BI.

SKills

AI EthicsAlgorithm DevelopmentArtificial IntelligenceDecision TreesEnsemble LearningGITNeural NetworksNumPyPython
AI ConsultantAI EthicistAI Operations ManagerAI Software Developer

Education

Finished in 2013 Bachelor of Information Technology at Anna University

Experience

Feb 2023 - Sep 2023 Senior Business Intelligence Developer at Queensland Department of Education

– Integrated with the technical team and Business users to perform analysis of business requirements and transformed them into technical requirements for ETL and reporting needs.
– Creating and designing a data model/mart from the warehouse and landing databases from scratch to bring data in using SQL.
– Designing Fact and Dimension tables using T-SQL load data via SSIS and scheduling the job through SQL Server Job Agent.
– Reconciling report and data model results and fixing the discrepancies between data sources and technical issues raised by the testing team.
– Developing visualisation dashboards and reports using Power BI desktop.
– Good knowledge of Data Marts, OLAP, OLTP, and Dimension Data Modelling for Fact and Dimension tables using SQL Server Analysis Services (SSAS).
– Worked with 130 million worth of SAP BW and Agresso data in fact table.
– Used Redgate and Git repositories as a source repository and deployed the objects in DEV/ QA/ PROD once the pull request was approved in Azure DevOps for tickets raised in ServiceNow.
– Self-motivated and possess the ability for critical thinking analysis, and good interpersonal and communication skills. Team-oriented, technically motivated, and creative. User-oriented with a desire to learn client’s business requirements. Strong inclination for finishing the job before the project deadline. Flexible and versatile to adapt to any new environment and work on any project.
– Prepare a test plan document that consists of unit testing, system testing, flow, development of the business process, and workflow charts and update the same in Subversion as a tool for a repository of codes and audit purposes.
– Actively engaging with stakeholders and working groups about the project progress during weekly meetings.

Nov 2018 - Jun 2022 Senior Software Engineer at BNP Paribas

– Developed stored procedures to transform data from enterprise data warehouse to data mart to build dimensions and load data to fact tables.
– Backend skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, triggers, functions, CTE, Cursor etc.
– Developed SSIS Packages using Derived Columns, Condition Split, Aggregate, Execute SQL Task, Data Flow Task, Execute Package Task, Error handling etc. to generate underlying data for reports and to export leaned data from Excel Spreadsheets, Text files, MS Access, Oracle, and CSV files to data warehouse.
– Once data is in place, develop a cube right from scratch with multiple cube dimensions, hierarchies, measure groups and calculated measures.
– Created complex SSAS cubes named “Reporting Consolidated BI Warehouse” with multiple fact measures groups (Invoices, Pending Sales and Sales Orders) and multiple dimension hierarchies based on OLAP reporting needs.
– Wrote calculated columns, Measures, and queries on the Power BI desktop to show good data analysis techniques. Created Dax Queries to generate computed columns in Power BI.
– Hands-on experience in composing APIs along with Web Services over Python using PyCharm and Flask.
– Expertise in using Git, TFS and SVN as a tool for a repository of codes and version control, branching and merging into production.
– Closed issues raised by the business analyst and users in JIRA daily and updated Confluence wherever necessary.
– Actively engaging and participating in Scrum meetings such as daily stand-ups, sprint retrospectives and reviews

Nov 2013 - Jun 2018 Data Analyst at Ramco Systems

– Used ERP suite including Finance, Supply Chain, Production, Maintenance, Sales and Shipping, and CRM.
– Extensive experience with SQL Server and T-SQL in constructing advanced SQL queries, stored procedures, functions, Data warehouses, Data mart, Temporary Tables, Table variables, and Relational database models.
– Improved Stored Procedures and SQL Query performances by analysing execution plans and creating proper Indexes using SQL Profiler and Database Tuning Advisor.
– Work with business analyst groups to ascertain their database reporting needs. Created several standard reports and complex reports to analyse data using Slice & Dice and Drill Down, Drill Through using SQL Server reporting services SSRS, which is then exported as PDF.
– Use SSIS to load data into staging tables using different transformations, control flow tasks, loop containers and data flow tasks, then move data into dimension and fact tables.
– Experience in data modelling, development, and maintenance of database applications on SQL Server in OLTP/OLAP/BI environment.