Mounika Addunoor

BI Developer

adkkrp@r.postjobfree.com

603-***-****

Summary Of Qualifications

Results-driven professional with around 5 years of experience as PL/SQL, Power BI, T-SQL, ETL and Business Intelligence Developer in Analysis, Design and Implementation of Business applications using Relational Database Management System (RDBMS) Oracle and MS SQL Server. Managed multiple projects by developing business systems and technical solutions using PL/SQL, T-SQL, ETL tools and unix shell scripting. Technically proficient in RICE components (Reports, Interfaces, Conversion, Extensions) for Oracle HRMS application solutions. Hands-on experience in developing RDBMS databases using Normalization techniques, OLTP, OLAP, Data Migrations, Data Conversions using ETL tools. Hands-on experience in reportingtools using Power BI & Tableau. Demonstrated experience in Oracle database environments, SQL server, Data warehouse concepts and performance tuning of the SQL/stored procedures. Acknowledged for capacity to execute plans rapidly, and logically affect solutions focused on long-term system sustainability, stability, and growth in all stages of System Development Life Cycle (SDLC): design, analysis, coding, and testing. Good understanding in AWS cloud environment. Extensive change control background to translate technical jargon into layman’s terms and align management directives to the realities of technology. Skilled in performing effectively both as an autonomous, self-motivated individual, and as an active team participant. Seeking for an opportunity to get more exposure in advanced ETL tools, Cloud based environment and advanced reporting tools (Power BI, Tableau & Qlik).

Technical Proficiencies

RDBMS

Oracle 9i, 10g, 11g, 12c; SQL Server 2012,2008 R2; MS Access

Operating Systems

Unix,Linux, Windows

Languages

SQL, PL/SQL, T-SQL, HTML, Unix Shell Scripting, AWS

Reporting Tools

Power BI, BI Publisher, Report Builder, XML Reports, SSRS

Data Modeler Tools

Oracle SQL Developer, PL/SQL Developer, SSMS, SSIS, TOAD, Data Warehouse, OLTP Migrations, ODBC, Oracle HRMS

Professional Experience

Graduate Assistant – Master’s in Information Technology

(6/2020 – 10/2020) Southern New Hampshire University, NH, USA

Environments: SQL Server 2016, MS Access, Reports, PL/SQL, SQL, Power BI, HTML, JDBC, MS Visio, Gantt Charts

Performed experimental case studies using SQL Server & MS Access databases and developed data-flow functionalities using programming languages SQL, T-SQL for the Data Modeling. Power BI used to create dash boards & visualizations and Microsoft Visio used to create Gantt Chart for the project estimation. Upheld superior technical abilities in using SQL Server database to store the details of customer in database by alleviating its performance.

Key Achievements:

Developed user friendly front-end web pages using HTML, CSS, and JSP’s.

Created oracle 12c & MS access databases for the use case part of case study.

Gathered System requirements using Data Process model, Data Flow diagrams, Data Dictionary, object modeling and use case diagrams.

Designed system architecture & user interface.

Normalization & data modeling techniques used for the database objects design.

Complex SQL’s & stored procedures used for the application functionality.

Error/Exception handling used for the ease of debugging and displaying the error messages in the application.

Connected to backend DB by utilizing DAO objects and JDBC drivers.

Established various automated functionalities for application with stored procedures & functions.

Developed dashboards, visualizations and reports for various functionalities using power BI.

Designed Power BI data visualization utilizing cross tabs, maps, scatter, pie, and bar charts.

Created estimated budget & project plan for the whole application design & setup.

Created estimated Gantt charts for the project timeline & roadmap using Microsoft Visio.

Grade A- awarded for this case study project.

CIBERsites India Private Limited

Software Engineer II (Sep 2015 – Nov 2018) Bangalore, India

Environment: Oracle 10g, 11g,12c, SQL Server 2012, 2008R2, SSMS, SSIS, Oracle HRMS, Data Warehouse, OLTP/OLAP, Data Modeling, ETL Tools, Power BI, Performance Tuning, Shell scripting, Data Conversions, SQL Plus, SQL* Loader, PL/SQL, Linux, TOAD.

Key Achievements:

Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation, and maintenance with timely delivery against aggressive deadlines.

Created conversion programs to transfer data from a legacy system to the new system in oracle HRMS application.

Developed and deployed dashboards, visualizations, and dynamic reporting interfaces.

Developed scripts to migrate data from multiple sources to desired destination using ETL tools.

Created complex PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL_FILE package.

Integrated both structured and unstructured data as the foundation of reports, automated the processes using power BI.

Developed both inbound and outbound interfaces to load data into targeted database and extract data from database to flat files for oracle HRMS application.

Performed data extracts using ETL solutions from heterogeneous sources like Access, Excel, and CSV, flat files using connectors, tasks and transformations provided by SSIS.

Developed Database Triggers for audit and validation purpose and used pipelined functions for faster data accessibility.

Debugged various defects related to implementation of business logic.

Created SQL*Loader scripts to load data into temporary staging tables.

Utilized SQL*Loader to load flat files into database tables.

Designed, implemented, and tuned interfaces and batch jobs for Oracle HRMS application using PL/SQL.

Extensively used oracle PL/SQL for database objects development i.e., stored procedures, packages, functions & triggers.

Extensively worked in Report Migration of all data from source to target systems using shell scripting oracle HRMS application.

Developed analysis reports and visualization using DAX functions like table function, aggregation function and iteration functions.

Creating and maintaining Power BI Reports and Dashboards and embedding them inside on premises Organizational apps for the larger audience to view them.

Explore data in a Variety of ways and across multiple visualizations using Power BI.

Created data validation test cases and test scripts for Unit Testing and Integration Testing and documented the same.

Involved in uploading of the data from flat files into Databases and validated the data with PL/SQL procedures.

Extensively used Exception Handling for the ease of debugging and displaying the error messages in the application.

Created database objects like Tables, DML, DDL, Views, Stored Procedures, Functions, Joins, and Indexes in T-SQL based upon the functional specifications.

Developed complex SQL queries using stored procedures, common table expressions (CTEs), temporary tables to support Power BI and SSRS reports.

Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedure.

Involved in Query Optimization, Debugging, and Tuning for improving performance.

Designed and developed of Business Intelligence Solutions using power BI.

Contributed in designing and configuring ETL workflows designed in MS SQL Server Integration Services (SSIS).

Used SQL Server SSIS tool to build high performance data integration solutions including extraction, transformation, and load packages for data warehousing.

Analyzed the Data quality, Data validating, Data Mapping to migrate data to SQL Server database.

Created SSIS packages which involved a variety of transformations such as look up, Aggregate, Derived Column, Conditional Split, Multicast, Union All, Merge, Merge Join, and Data Conversion before loading the data into Data Warehouse.

Created complex SSIS packages using proper control and data flow elements with error handling.

Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.

Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, TKPROF and AUTOTRACE.

Developed and modified UNIX Shell scripts according to the changing needs of the project and client requirements.

CIBERsites India Private Limited

Software Engineer I (Aug 2014 – Sep 2015) Bangalore, India

Key Achievements:

Environment: SQL Server 2008R2, 2012, Oracle 9i,10g,11g, OLTP, performance Tuning, Data Modelling, Stored procedures,Functions, Reports, SQL Plus, SQL Loader, Data Mart, Oracle HRMS, PL/SQL Developer, Linux.

Developed & enhanced database objects such as tables, views, materialized views, indexes, procedures, and packages using Oracle tools like TOAD, SQL Developer, PL/SQL Developer and SQL*PLUS.

Designed the data model based on star schema and created the tables and indexes and developed the scripts to load the data mart tables.

Extensive experience in writing stored procedures, functions, and views.

Extensive experience in writing and tuning complex sub queries, SQL, PL/SQL stored procedures, functions, and triggers.

Created Oracle Tables, Views, Constrains, Synonyms, Sequences.

Load the data from MS Excel to Oracle Table and Oracle table to MS Excel.

Loaded the data using the SQL loader, Imports & UTL files based on file formats.

Used the inner join, outer join, cross join while writing the complex SQL Queries.

Used Collection objects, ref cursor, and bulk collect, aggregate functions while Writing SQL Queries.

Created database Schema, Users, Tables, Constraints, Indexes, Triggers, Privileges, Roles, Cursors, Ref Cursors, User Profiles, anonymous blocks, directories, sequences, synonyms to implement business rules.

Responsible for creating/modifying SQL queries using joins, sub-queries to implement business rules.

Designed SQL Database and Table Design with Schemas, Constraints and Views.

Involved in database design process and data modeling process.

Developed Ad-hoc reports, data driven subscription reports by using Report Builder.

Wrote complex SQL queries and stored procedures for retrieval of data.

Facilitated Release Planning, Sprint Planning, Backlog Grooming, and Retrospective meetings.

Provided technical support to front end design team.

Strong knowledge of Data Warehousing methodologies, concepts and implementation of star schemas, snowflakes schemas, facts & dimensions.

Worked closely with QA team and helped them come up with test scenarios.

Developed UNIX Shell scripts to automate repetitive oracle database processes.

Used SQL*Loader, SQL* Plus, Oracle Import/Export utilities for data migrations and loading into Datawarehouse environment.

Involved in the continuous enhancements and fixing of production problems.

Extensively used bulk collection in PL/SQL objects for improving the performance of the SQL’s.

Created technical specification documents.

Intern – Computer Science

(9/2013 – 4/2014) Jawaharlal Nehru Technological University, Hyderabad, India

Environments: Oracle database, SQL, Shell Scripts, Core-Java, CSS, HTML, XML, Servlets, JSP’s, JDBC

Performed experimental case study using oracle database and improved its performance using SQL, PL/SQL, Java, CSS, HTML, and JavaScript. Recognized as a core participant of the team in heading and developing Net Banking projects. Upheld superior technical abilities in using Oracle to store the details of customers in the database. Coded shell scripts for the application support.

Key Achievements:

Established various internet automated functionalities for banking applications using Java/J2EE and JSP’s.

Developed user friendly front-end web pages using HTML, CSS, and JSP’s.

Connected to backend DB by utilizing simple DAO objects and JDBC drivers.

Education

Completed Bachelor’s in Computer Science & Engineering, 2010 - 2014

Jawaharlal Nehru Technological University, Hyderabad,India. GPA - 3.5, 4

Pursuing Master’s degree in Information Technology, 2020 - Current

Southern New Hampshire University, NH-USA. GPA - 3.9, 4 (15 credits out of 36 completed)

Certifications

AWS Certified Cloud Practitioner

Contact this candidate