Business Analyst/ Lead Oracle Developer Resume Seattle - Hire IT People

SUMMARY

IT professional with over eleven years of experience in all phases of software development and maintenance.
This includes business and technical requirements, data modeling and architecture, design, coding, testing and compliance.

TECHNICAL SKILLS:

Platforms: Windows Server, UNIX, AWS

RDMS: Oracle, SQLServer

Data Modeling Tools: Erwin, TOAD Data Modeler

ETL: Informatica Powercenter

Development Tools: Eclipse, TOAD, SQL Developer, IntelliJ 2018.3

Demonstrated Strengths in: Business Requirements Data Analysis Software Development

PROFESSIONAL EXPERIENCE

Business Analyst/ Lead Oracle Developer

Confidential, Seattle

Responsibilities:

Analyzed the existing production system and migrated Oracle packages to micro services and AWS.
Resolving the production tickets in current system and implementing CRs and demonstrating the functionality to Business.
Migrated ICM functionality to SQLServer queries and implemented Sark SQL. Extract Data from SQL Server, Transformations done in Spark with Scala and SparkSql, Load into hive. Implemented Microservices

Technical Business Analyst/Sr. Oracle Developer

Confidential, Southfield

Responsibilities:

Eliminated Mainframe and migrated to open source by analyzing the current system, preparing Business Requirement Document, designing the process flow.
Designed Data Flow Diagrams, demonstrated to Product owners, captured all the business requirements to technical requirements.
Primarily responsible for eliminating Mainframes from ODIMS, Common Modules, CAF, TLAS and VIO and moved to Open Source
Developed Oracle packages, tested, comparison with Mainframes and demonstrated to business.

Sr. Oracle Developer

Confidential, California

Responsibilities:

Designed spatial Oracle Database as per the requirements and implemented the functionality along with AutoCAD MAP3D. Extensively used Materialized views, rendering layers on the maps
Objectifying the assets using views, performance tuning, batch jobs, creating indexes.

Oracle PLSQL Developer

Confidential

Responsibilities:

Developed Oracle Packages, Procedures, Functions, Triggers.
Worked on CTL files to load data using SQL Loader.
Performance tuning using partitions, hints, indexes.
Query optimization using explain plan, trace files, bulk binds, global temporary tables
Database administrative activities like logical backups, recoveries.

Oracle PLSQL Developer

Confidential

Responsibilities:

Written SQLs, PL/SQL Stored Procedures and Packages to retrieve relevant information from various tables into intermediate tables.
Assisted the business intelligence team in writing complex queries, PL/SQL scripts and database triggers.
Created UNIX shell scripts, which call the PL/SQL scripts to test the source rows to destination rows.
Written CRON Jobs in UNIX to run end - of-day processes automatically.