Sr. Prog. Analyst/Data Architect Resume NJ - Hire IT People

OBJECTIVE:

I am seeking employment with a company where I can use all my hands on experience I have learned in SDLC and move into a project manager position.

SUMMARY:

IT professional with 20+ years of experience and 18 years in the financial industry.
16 years at one company as a Programmer Analyst/Team Lead/Data Architect in various environments. Experience in analyzing business process, re - engineering, implementing change control, elevations and supporting application systems.
Work with business users to collect requirement and manage development with off shore development group. Managing business user expectation
Used to manage off shore development team.
Worked with on all phases of a Software project life cycle.
Used ETL tools like Oracle SQL *Loader and Informatica for loading and transforming feeds to and from the vendor.
Worked extensive on Oracle(7.0 to 11g) and used packages/proc/function/triggers/materialized views/XML.
Very proficient in UNIX scripting.
Very familiar with schedule and monitor jobs on Control-M.
Setup and monitor data replication and data sync jobs from Sales Force (SF) to Oracle using Informatica.
Developed and tested disaster recovery plans for our application.

PROFESSIONAL EXPERIENCE:

Confidential, NJ

Sr. Prog. Analyst/Data Architect

Responsibilities:

Informatica data replication and data sync from SF to Oracle
Managed and Involved in data replications from SF to our oracle database using Informatica.
Design processes and built the surrounding process to feed SF information to our accounting system
Work with Informatica support to resolve issue encountered and find solutions to issues.
Migration of SBL Oracle systems from CIT to Confidential
Was one of the key members involved in meeting and sticking to schedules for the move to Confidential .
Ran mock runs to move application and data to the new environments.
Validate applications/connectivity/data once in the new environment.
Develop scripts to mask/scrub Personally Identifiable Information ( PII ) when data was move from Prod to UAT or development.
SBA E-Tran XML feed:
Involved in data mapping and implementing web service call to United States Small Business Administration (SBA).
This process saved time and money fax, couriers and most importantly cut the processing time for loan approvals to minutes.
This was implemented using package stored procedures & oracle built in packages to transmit data.
This process was required to check any owners/businesses against the Office of Foreign Assets Control (OFAC) database, in short against the terrorist/fraud list.
Implemented this process by web services calls through oracle packages and passing XML data.
Insurance feed:
Held meeting with the vendor on format and delivery file.
Implemented the flat file generating using oracle packages and encrypting/decrypting while sending/receiving.
SQL*Loader was used to upload the verified data into our system.
Asset recovery reporting:
Automated AR reporting process which used to take days manually to doing it in minutes.
Was involved in the whole software life cycle from analysis, development to implementation.
Used oracle packages/procedures/analytic function as well as performance tuning to get the response time down to seconds.
Received letter of excellence from the user for accomplishing this project in the given time frame.
PLP Audit:
Computerized this process, which was done manually and enhanced the output of the user.
Was involved in the whole life cycle from analysis, development to implementation.
Used oracle packages/triggers and procedures for reporting.
Received letter of excellence from the user for making her job easier and more time for other projects.
File Tracking:
Computerized this process of requesting loan files in an orderly way and tracking the file which were requested
Used oracle procedures to generate the report and PowerBuilder to present it.

Environment: Oracle 7.3 / 8i / 9i/10g 11g, Power Builder 9.0..12.5,Linux,Unix, Erwin, PL/SQL Developer, Oracle enterprise manager, Informatica cloud, Control-M Scheduler, Lync, GoToMeeting and WebEx.

Confidential, NJ

Sr. Programmer Analyst

Responsibilities:

Was involved in developing client-profiling system, which was a part of Client Information System ( Confidential ).
This system kept track of the client’s source of wealth.

Environment: PowerBuilder 6.5, Microsoft SQL Server 6.5/ 7.0, MS Windows NT 4.0.

Confidential, NYC

Programmer Analyst

Responsibilities:

Worked on building and enhancing in house base classes to hold functionality like sorting, printing, security check, notification.

Environment: Power Builder 6.5 / 6.0 / 5.0, PFC 5.0, Sybase System 11, Oracle 7, Visual C++ 6.0.

Confidential

Team Leader

Responsibilities:

Worked on a key software module for an advertising firm and was also instrumental in building base classes that were used across modules like television/billboard/print media.

Environment: Power Builder 5.0 / 4.0, Power Tool (4.0) class library / Sybase System 10 (NLM)

We provide IT Staff Augmentation Services!

Sr. Prog. Analyst/data Architect Resume

NJ

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship