Technology Analyst Resume Profile

Summary

Project Management and Computer Programmer/Analyst for over 10 years. Experienced on a variety of systems and in a variety of languages, in business/financial and scientific environments, in both a consultant and employee capacities.
Software: Oracle 9i and 11g , Oracle PL/SQL: Stored Procedure, Cursor, View, Materialized View, Indexes, Toad Version 10.6, SQL Loader, Data Analysis, Data Mapping, Data and Schemas Modeling, SQL Server, HP Quality Center, Business Objects, PEGA/PRPC Pega Rule and Process Command , IBM MQ Data Communication, S.W.I.F.T. messages, Client-Server Technologies, C, C , VISUAL BASIC, MS OFFICE 2007, POWER BUILDER, VAX BASIC, VAX FORTRAN, SnagIT

PROFESSIONAL EXPERIENCES

Business/Data Analyst

Confidential

Translated Business Requirements into Functional Specifications to help developers for easier coding
Designed new wireframes based on the requirements and current system configuration
Wrote User Guides with step by step wireframes and instructions to help the users to get familiar with the new releases
Performed and responsible for QC/QA testings to minimize development faults
Wrote Regression Test Scripts and perform Regression Testing before large project release
Created and executed Test Plan and Test Cases

Data Modeler

Confidential

Define Data Models and perform queries performance tuning to be used in Production environment and execute batch scripts for production implementations

Senior Technology Analyst

Confidential

Constantly query and monitor both US and European Fund Transfer Databases for quality review and data integrity
Made recommendations to senior management on steps to improve data quality.
Write Stored Procedures by using PL/SQL to create a nightly run script to port data from Application Server to Data server for the reporting projects
Analysis of Fund Transfer Case data based on different user types and rolls up to business specified user hierarchies to create Fact and dimension tables for the ETL team
Handle 3 Tera-bytes of Fund Transfer Case data to create Trending and KPI reports to be shown to upper management
Responsible for the life cycle of Oracle projects from Schema Design, Data Modeling, data loading to actual implementation and create tables to be used by production ETL team
Coordinated Oracle projects with both on shore and offshore team members for the SDLC project deliverables
Use SQL Loader to upload flat file to Oracle Database
Utilized MQ queue structure and Send/Receive channels to send data query and receive query result set among different systems
Provided Business Objects reports to external customers with accuracy and punctuality to earn 100 client satisfaction for the group
Project Management and Project Planning from Initiation to Post-Implementation of Trending and Executive reports as well as Ad-hoc reporting by using Business Objects
Identified project issues and risks, and facilitate remediation
Participated in project governance and provide high level quality control
Tracked and communicated project performance for management and key stakeholders by providing weekly status report to upper management
Participated in UAT meetings for release and defect prioritization
Responsibility of Project Management for various projects like PRPC search Portal Historical and Same day searches , European Fund Transfer Data feed upload, etc for STaRS Services Tracking and Reporting System
Worked closely and professionally with the business partners and clients from beginning to the end of the projects
Responsible for the following documentations for each project: Project Plan, Functional Specification, Technical Design Specification, Development Test Plan and Test Script, Deployment Plan, Risk and Issue log
Utilized MQ queue structure and Send/Receive channels to send data query and receive query result set among different systems
Contribute to the compliance of Software Development Life Cycle SDLC
Propose for different development approaches and status reports to upper management.
Provided solutions and leaderships for the software development team
Responsible for the complete Life Cycle of projects from high level project estimates, to thorough project plans, to resources allocations, to integration testing, to actual project implementations
Heavily involved in End-users problem support with prompt and professional responses
Provided 24x7 production supports to Citibank's internal system LOCCAL Letter Of Credit Collection And Loan to resolve any outages that would have cost thousands of dollars to fix
Assumed the responsibility as a DBA to maintain and ensure the data integrity of the VMS RMS DATABASE
Initiated and implemented the solutions for data communication between different processing platforms
Comfortable to learn complex business requirements in a constrained timeframe

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship