Data Engineer

SOUMYA RANI GOPU

**************@*****.***/614-***-****

https://www.linkedin.com/in/soumyaranig/

Public Trust Clearance - MBI (GSA)

Over 9 years of progressive experience as a developer in Data Architecture, Business Analysis, System Analysis & Design, Development, Testing and implementation of Data Warehousing and Business Intelligence.

SUMMARY:

Extensive knowledge in design and development of Business Intelligence Applications.

Proficient in Tableau 8.x/9.x/10.x(Desktop, Server, Mobile, Public

Extensive experience in using Tableau functionalities for creating different Reports, Interactive Dashboards with page and Dashboard prompts using sets, joins, bins, hierarchies, sorting, grouping etc.

Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like bar graphs, scatter plots, pie-charts, geographic visualization and other making use of actions, other local and global filters, context filters, user filters according to the end user requirement.

Expertise in designing and creating various analytical reports in Tableau Enterprise and Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.

Understanding of Python scripts and integration with Tableau.

Experience in OBIEE 10.x and 11.x including Installation & Configuration of OBIEE along with experience in Informatica Power center 7.x,8.x

Expertise in implementation of end-to-end BI solutions following standard OLAP methodologies using Oracle Business Intelligence (OBI EE).

Expertise in design and development of the three layers (Physical/Business Model and Mapping/ Presentation) of OBI Metadata Repository using Oracle BI Administration Tool.

Expertise configuring Analytics Metadata objects (Subject Area, Table, Column), Answers (ad-hoc querying, reports), Variables (Repository/ Session/ Presentation), Interactive Dashboards with drill-down capabilities (charts/ tables/ graphs), Delivers (iBots) and administering Web Catalog Objects (Dashboard, Pages, Folders, Reports).

Hands-on experience using Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimension Tables, Physical and Logical Data Modeling

Experience in customizing the change capture process of DAC to load data incrementally.

Extensive Knowledge on Oracle BI Delivers and Implemented schedule based iBots to deliver reports.

Extensively worked on Informatica Power Center tools - Repository Manager, Designer, Workflow Manager and Workflow Monitor.

Strong understanding of Dimensional Data modelling (Star Schema modelling, Snow-Flake modelling, Fact and Dimension tables), Physical and logical data modelling

Expertise in performance tuning of BI Repository, Reports, Informatica.

Experience in Oracle PL/SQL programs, Procedures, Packages, Functions and Triggers.

Excellent Knowledge on Tableau installations, Setup, Configuration, role creations, publishing and troubleshooting.

Extensively involved in Reverse-Engineering and Business Rules Extraction Expert in project planning, strategic planning, systems analysis and troubleshooting, quality control, forecasting, scheduling and planning and tracking of results

SKILLS:

OLAP/BI/Reporting

Tableau 8.x/9x/10x, OBIEE 10.1.3.x

ETL Tools

Informatica Power Center 8.x

Languages

C,C++,Java, HTML,Java script,SQL,PL/SQL

Operating systems

Windows NT/2000/XP, UNIX, LINUX

Databases

Oracle, SQL Server

EDUCATION:

●Masters in software engineering, Stratford University, Falls Church, VA - 2010

●Bachelors in computer science, JNT University, Hyderabad, India - 2006

Professional Training and Education

●Tableau Training 2014

●Informatica Training 2011

●OBIEE Training 2010

●Java and SQL training 2006

EXPERIENCE:

Sept’15 – Present BI Consultant (GSA - PBS) Washington, DC.

There were couple of tasks attached to this contract, Development of Tableau reports, migration of MS Access based National Staffing Reports into Tableau and Maintenance of OBIEE 11g based Financial domain reports. Financial domain comprised of reports and dashboards that the business line users used extensively for reporting on the GSA’s financial systems and spend analysis. National staffing system was a repository of GSA Employees HR and Payroll information.

Experience in maintenance and gathering of Requirements from the business line users

Involved in discovery and IPT meetings with all parties involved

Designed and deployed reports/data visualizations from end to end.

Created Schedules and Extracted the data into Tableau Data Engine

Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.

Created action filters, parameters and calculated sets for preparing dashboards and worksheets

Created Tableau scorecards, dashboards using Stack bars, bar graphs, scattered plots, geographical maps using show me functionality

Worked on predictive reports using Python based analytics and integration using TabPy in Tableau 10.x

Developed Tableau visualizations and dashboards using Tableau Desktop.

Developed Tableau workbooks from multiple data sources using Data Blending.

Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps

Administered user, user groups, and scheduled instances for reports in Tableau.

Executed and tested required queries and reports before publishing

Developed dashboards in Tableau Desktop and published them on to Tableau Server that allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.

Worked on data load and data refresh on Tableau servers for bi weekly and monthly increments.

Developed parameter and dimension based reports, drill-down reports, matrix reports, charts, and Tabular reports using Tableau Desktop

Installation of OBIEE Releases for BI Framework and Financial Domains

Installed software and scripts in production, IVV and Integration servers

Worked on Monthly loads for BIDB and National Staffing

Environment: Tableau 9.x/10.x, Python, OBIEE 11.2.x, Oracle 11g, SQL Server 2008, Unix.

Nov’13 – Aug’15 Sr Tech-Ops Engg (GSA - PBS) Chantilly VA.

TechOps program supports the Development and maintenance of OBIEE reports, Development of migration plan from MS Access based reports to Tableau, Installation of different applications at the Enterprise Data Center of GSA PBS. Part of the program is to maintain compliance with Hardening and Security guidelines set by GSA SecOps team. Patching the databases and Operating Systems. Team is also responsible for handling level 2 and 3 service requests and tickets in ServiceNow. Also handle workflow of application releases in JIRA.

Developing and executing PL SQL and SQL Queries

Developing OBIEE reports, dashboards and RPD.

Installation of OBIEE Releases for BI Framework and Financial Domains

Worked on Tableau POC for migrating MS Access based reports.

Provided LOEs (Level of Effort) and migration plan for the MS Access Reports into Tableau

Developed RPDs and OBIEE reports.

Generate Database Dumps and backups

Installs software and scripts in production, IVV and Integration servers

Updates and schedule cron jobs.

Working in Monthly loads for BIDB and National Staffing

Working on Oracle and SQLServer Patching and Hardening

Working on CastIron Orchestration and solving business specific requests

Generating exports for REXUS, EASI, Iris, LMT, RETA, Oatool.

Helping users for resetting their passwords and Unclocking their accounts

Working for National Staffing load for every 15 days.

Adding groups and users in the NETIQ DRA.

Supported apps include: FMIS, BI Framework, Financial Domain, REXUS, EASI, RETA, IRIS, LMT, ReWEB, MAR, MARC, OATOOL, OABILL, National Staffing, TMS, Galaxy

Environment: OBIEE 10.1.3.4, Oracle 11g, SQL Server 2008, Unix.

Feb’13 – Nov’13 Senior OBIEE Developer (GSA - PBS) Chantilly, VA.

The objective of the task was the migration of Comprizon based Acquisition reports from Business Objects (BO) to OBIEE and maintenance of Acquisition reports and data models in BI Framework.

Documented the migration strategy and gathered requirements for migrating Comprizon based Acquisition reports from BO to OBIEE.

Provided LOEs (Level of Effort) for different migration plans.

Developed a POC (Proof of Concept) for migrating the reports.

Developed RPDs and OBIEE reports.

Attended and organized end user meetings for UAT of the migrated reports.

Developed scheduler reports to be delivered to end users.

Developed SQL packages for back end Oracle DB tasks to go inline with the OBIEE report development.

Developed dashboards according the user requirements.

Monitored and customized the ETL tasks as needed.

Provided Tier 1 support for end users and in cases when needed provided information of how to create reports in OBIEE 11g.

Environment: OBIEE 10.1.3.4, Oracle 11g, SQL Server 2008, Unix.

Feb’11 – Jul’12 OBIEE Developer, EDMC (Education Management Corporation), Phoenix, AZ.

9010: Education Management Corporation is among the largest providers of private post-secondary education in North America, based on student enrollment and revenue, with 104 locations in 31 U.S. States and Canada. 9010 is a reporting project, helping the business line understand the revenue flow based on the following, Ed system Analysis, Program Analysis, Fund Source Analysis and OPEID analysis. The Analysis reports included all the revenues generated in relation to students of the organization and grouping them based on Fund Source, Ed System, and Program etc. 9010 reporting module helped the business line understand and plan the budget for the next fiscal year and fiscal months.

Proposed Architecture/Design for Business Model and Performed Metadata Modeling for proposed architecture.

Configured OBIEE Repository, Physical Layer, Business Model and Mapping Layer and Presentation Layer using OBIEE Administration Tool.

Worked closely with the business users in identifying various KPI’s and designed solutions to indicate them efficiently for enhance business decision-making.

Created ad-hoc reports in OBIEE Answers and Intelligence Dashboards as per the business requirements.

Creating application, process, testing and data mapping documentation.

Created data source view in the physical layer to convert rows coming from back end to columns

Updated security permission / privileges as per the role of each user.

Designed and developed a prototype of reports for the 9010 project.

Developed report layouts using Html and JavaScript.

Developed custom prompts for reports.

Organizing the presentation layer in a format that is easy for end user to use as basis for reporting.

Environment: OBIEE 10.1.3.4, SQL Server 2008.

Nov’06 – Jul’07 Test Engineer/Reports Dev (Manilax Information Tech) Hyderbad, Ind.

Vodafone is a private mobile and network service related player in Netherlands. In Manilax we are involved in System Testing (Manual) of the Billing product for Vodafone. The Billing product of Amdocs involves Ensemble, Enabler, Rater Advertising and Management and many other modules which together work for pre-paid or post-paid Billing activities for Vodafone.

Understanding the Business Requirement Specifications.

Developing System Test Cases.

Documentation and preparation of Test Reports.

Writing functional, GUI, scenario based test cases & executing them.

Performing Black box testing i.e. GUI testing, Regression testing, Functional testing.

Executed System Test Cases to check the functionality of the application.

Generated the test defects report and reported it to the development team for Bug fixing.

Environment: Manual Testing, Smoke Testing, End to End Testing, Quality Centre, Coldfusion, Javascript, HTML,Ms Sql Server, WinXP, Unix.

Mar’06 – Nov’06 Test Engineer (Manilax Information Tech) Hyderbad, Ind.

The project was to enhance the existing on-line system to store and maintain the customer's insurance information in a centralized location. The web portal allowed Guardian customers to track and review claims and other health account information as well as performs on-line transactions such as ordering medications. The system was designed to increase efficiency of the website

Responsible for creating Test Plans and Reports for projects

Responsible for documenting Test Plan, Test Case and Test Script as per Business rule for each release.

Enter and Analyze Requirements to create test cases using HP Quality Center

Developed and Executed Test Scripts for Integration and Regression testing.

Environment: Manual Testing, Smoke Testing, End to End Testing, Regression testing, Toad,Oracle.

Contact this candidate