Business Analyst Resume Profile

QUALIFICATIONS

Experience with Enterprise Oracle 11g Database, SQL Server 2008, Data Warehouse, RDBMS
Advanced PL/SQL Development experience
Written Oracle stored procedures, functions, triggers, types Created tables, indexes, views, objects
SQL Query Performance Tuning and Optimization
Database administration and performance tuning
TOAD v11 SQL development application development experience
Spring / Eclipse IDE development experience with Java, Grails, Groovy
Application Development experience in a team environment, Agile methodology
Experience with XML, JSON, REST Interfaces, Mule ESB
Business Intelligence: Business Objects XI R2, WEBI, SAS, SAP Business Warehouse, Hyperion EssBase

Experience with ETL

Other programming languages: C , JAVA, HTML
Data Modeling Statistical for Forecasting Systems
Strong data analysis and problem solving skills
Testing Functional, Unit, Integration, Regression, UAT
Bachelor's degree in Engineering CS and EE core

PROFESSIONAL EXPERIENCE

Application Developer

Confidential

Contributor for building the team's Oracle database from the ground up, including database administration duties for DEV, QA and Prod environments. Created and maintained users and roles. Designed and developed tables, stored procedures, functions and types in Oracle to support and automate the front-end UI functionalities. Written PL/SQL code in stored procedures/functions approx. 300 to handle insert/update requests and return result sets for pagination search requests from the UI, written pipelined table functions that utilize recursive algorithm to compute the status of feeds and its dependencies time elapsed from its SLA for the feed monitoring project FMO , and optimized table structures indexes and partitioning and optimized SQL bulk binds and parallelized pipelined functions . Participated in Scrum meetings utilizing the Agile methodology and contributed in a team environment to develop end-to-end applications that include the UI layer, the intermediate Enterprise Service Bus ESB layer written in Java utilizing JSON / XML, and the the Oracle database layer. Familiarized with UI development in Java and Javascript including REST interfaces. Promoted from Information Analyst II through internal mobility.

Information Analyst II

Confidential

Migrated full life-cycle month end process, tables, views, sampling methodology from SQL Server to Oracle database by understanding the current process to future end state and created an improved automated sampling methodology. Improved accuracy of data and reduced load time. Performed extraction, loading and sampling of data at month end. Developed SQL PL/SQL code per business requirements in the DEV environment for production. Performance tuned Oracle database schema . Performance tuned SQL queries utilizing explain plans. Integrated Oracle SQL advanced querying techniques and hints in query for faster retrieval of data.

Financial Business Analyst II

Confidential

Developed PL/SQL queries for performance metrics in Oracle db 10g. Developed queries in SAP BW Business Warehouse and Business Objects for Business Intelligence month end reports. Worked with IT to help in building Business Objects data mart Universe for A/R data for reporting in Oracle database.

Supply Chain Process and Application Specialist

Confidential

Production support for Oracle Demand Planner ODP application in Oracle EBS for monthly forecast of sales. Application development experience of ODP Oracle Forms / Reports . Performed statistical data modeling and ETL of sales history at month end for forecast in ODP. Queried sales, inventory data from SAS downstream and upstream data from ODP . Other applications supported: DRP, MRP in Oracle EBS. Participated in Oracle 10g database upgrade and testing Oracle EBS modules before go-live: unit, functional, integration, regression and user acceptance testing.

Demand Planning Analyst

Confidential

Analyzed and mined data to support Supply Chain business initiatives utilizing TOAD for Oracle 9i in SQL , Business Objects Business Intelligence for sales history and inventory levels, Hyperion Essbase for future sales forecast. Monitored sales data feed ETL. Performed data modeling on I2 Demand Planner sales forecast data. Performed root cause analysis on sales/forecast/inventory data utilizing all data sources mentioned. Worked with IT on requirements and user acceptance testing of company wide team specific system enhancements. Gained knowledge in C development for applications. Gained knowledge in Informatica ETL. Hired on as Inventory Analyst, promoted to Demand Planning Analyst.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship