SUMMARY:

• Passionate, energetic and result oriented professional offering 11+ years of experience as an Oracle application developer and data analyst.
• Expertise in all phases of SDLC, business intelligence, technical analysis and project management.
• Deep understanding of technology with an outstanding history of collaborating with partners & global clients to deliver business solutions and drive decision making.
• P ersuasive communicator with exceptional relationship management skills and ability to relate to people at any level of business and management; highly ethical, trustworthy and dependable.

AREAS OF EXPERTISE:

• APEX Application Development
• Business Intelligence & Data Analytics
• All Phases of SDLC & PMLC (Systems Analysis, Design, Implementation, Technical Documentation, UAT & Enhancement)
• Maintenance and Data Migration
• Performance Optimization & SQL Tuning
• Requirement Gathering
• OBIEE Dashboards, Metrics & Reports
• Data Extraction, Modeling & Visualization
• PL/SQL Packages, Triggers, Cursors, Functions, Stored Procedures & Exception Handling
• Advanced Excel skills including Pivoting, VBA, Formulas, Financial Modeling, ODBC & Macros
• Customer Relationship Management
• Relational Databases & Predictive Modeling
• Deployment and Production Support

TECHNICAL SKILLS:

Languages: Oracle PL/SQL, SQL, HTML, Visual Basic & CSS

Database Tools: Oracle 9i,10g,11g,12c & SQL Server

Web Development: Oracle APEX (APEX 4.0/4.1/4.2/5.0/5.1 )

Analytical Tools: OBIEE, SAS, R Programming & Siebel Analytics

Query Tools: Toad & SQL Developer

Platforms: Windows 9x, Windows 2000/NT/XP & Windows 10

Other: Advanced MS Office (Excel, Outlook, PP, Word), UNIX and LINUX shell scripting, AJAX

PROFESSIONAL EXPERIENCE:

Confidential, CT

Oracle PL/SQL Developer

Responsibilities:

• Wrote and executed database programs in SQL, PL/SQL
• Implemented and facilitated a variety of applications to gather customer data
• Created coherent hierarchies of customers using external data
• Incorporated elements from company websites, financial websites and Hoovers
• Helped lead a team in creating and maintaining an extensive database of top customers
• Data was synthesized from several sources, including the internet
• Provided guidance to other team members
• Coordinated efforts across several teams to ensure data consistency
• Wrote PL/SQL code that automated analysis of contact email domains
• Created OBIEE dashboards that combined several analyses of customer satisfaction
• Reconfigured and analyzed data for sales lead generation
• Principal APEX developer for the customer insight and Oracle 2K account management applications. In creating bot, synthesized a complex data structure into a single customer view supported by an advanced UI design enabling executive management with instant access to the most current and accurate information available on the organization’s global clients and products

Confidential

Systems & Tools Specialist

Responsibilities:

• Utilized PL/SQL and SQL to develop Oracle APEX web applications and database reports
• Led all phases of APEX web application development lifecycle including analysis, design, preparing prototypes, implementation, login credentials, documentation, user acceptance testing, migration, upgrades, handled enhancement requests, provided on call and daily production support of Oracle PL/SQL ETL processes, maintenance of tools and database schemas
• Developed BI dashboard application for accounts and contacts based on products, revenues, region and fiscal year for Oracle managers
• Performed business analyst role to coordinate between stakeholders and cross functional IT staff at different organizational levels for requirement gathering and business activities

Confidential

Marketing Analyst

Responsibilities:

• Specialized in technical analysis to support decisions made by Oracle executives and the marketing, product, and sales teams
• Utilized SQL and PL/SQL to automate a procedure to run a report that showed all the install base Oracle customers’ information and scoring analysis for specific product lines and families enabling campaign managers to target their customers with email blasts regarding upgrades and updates
• Performed hypothesis testing, competitor analysis, attrition analysis, RFM analysis, cross - selling / up-selling models, data mining, and predictive modeling for customer profiling and segmentation
• Developed and maintained customer analytical database to improve service metrics
• Utilized PL/SQL, Excel and SQL to introduce advanced visualization techniques to analytical process (heat maps, mosaic plots, association plots, world clouds and bubble charts)
• Mentored and trained multi-regional teams of marketing analysts and data miners
• Created a family tree and segment view of Oracle customers by identifying the most valuable relationships within our data and implemented intelligent analytics to deliver growth with best- in-class insights from Duns & Bradstreet
• Migrated federal & sales Do Not Call registry into Oracle database to stop unwanted calls to clients by Oracle telemarketers
• Analyzed, prepared and presented weekly, monthly and annual regional Oracle product analysis and comparison charts for upper management to evaluate the sales flow

Confidential, CA

Accounts Executive

Responsibilities:

• Handled accounts & administration for 4 sister companies of Confidential.
• Prepared monthly bank reconciliation statements, finalization of accounts, trial balance, profit & loss accounts and balance sheets
• Calculated and filed tax forms 16, 16A and all annual Income Tax returns