We provide IT Staff Augmentation Services!

Data Analyst/database Analyst Resume

SUMMARY:

  • Professional with experience in Financial, Insurance and Education institution with a strong foundation in data and system requirements analysis. Worked on several projects using a variety of systems using various tools, languages, and software.
  • Extensive experience in designing, modeling and developing relational databases using both Entity Relationship (ER) models and Datawarehouse dimensional models (star join / snowflake modeling).
  • Efficient in writing SQL queries, and performance tuning.
  • Extensively used ORACLE (PLSQL/SQL) to write ETL scripts, to produce aggregate tables, and to denormalize data in the Datawarehouse, and implementation of business rules.
  • 7 years of experience in supporting several financial data mart applications (both batch systems and real - time systems) housed in Oracle database server that includes Trade History, Positions, Securities Lending, Mutual Fund Processing system, Portfolio Valuation, General Ledger
  • Expertise in using Business Intelligence tool Oracle-Report Builder, Hyperion and Microstrategy to develop reports/charts/pivots and creation of business-specific reporting cubes.
  • Extensive experience with all phases of the Software Development Life Cycle including analysis, Resource Planning, code development, testing, implementing and maintenance
  • Performing impact analysis as per user requirement
  • Strong understanding on UNIX shell usage and scripting.

TECHNICAL SUMMARY:

IBMPC, SPARC, PDP11, Oracle 11g/10g/9i/8/7.x, UNIX Shell scripting, Java Scripting, SQR, HTML, VAX- Assembly, VAX/VMS, WINDOWS NT, IBM Cognos Report studio, Oracle Report Builder,Hyperion Designer, Microstrategy DSS Agent/Architect, MS Project2010, Serena PVCS, Visio

EXPERIENCE:

Confidential

Data Analyst/Database Analyst

Responsibilities:

  • Performing data analysis for the migration project of fixed income data from IBM Netezza to Oracle Exadata for 540 source feeds
  • Preparing daily status report of the migration of various source feeds, corresponding source and target counts, number of source feeds that are processed with a match reporting table mismatches, and load performance statistics
  • Writing SQL scripts for data comparison analysis between the systems, generating the records that have data mismatches at the attribute level, and the missing records for each systems

Environment: SQL Developer, Oracle Exadata, SQL*PLUS, UNIX, MS Office

Confidential

Database Analyst

Responsibilities:

  • Supporting a comprehensive transactional ERP system that includes Purchase Orders, Inventory, Cash Receipt, AR transactions
  • Coordinate with multiple teams in performing impact analysis as per user requirement
  • Work with packages, stored procedures, functions, views, materialized views for development work
  • Proficient in advance features of Oracle 11g for PL/SQL programming in using Records and Collections, Bulk COLLECT and Dynamic SQL.
  • Created database objects like tables, views, sequences, synonyms, indexes using Oracle tools
  • Unit testing in a version control development environment
  • Enforced data integrity using integrity constraint and database triggers

Environment: PLSQL Dev eloper, Oracle 11g, PL/SQL, SQL*PLUS, Windows 7, UNIX, MS Office, Oracle Forms, Oracle Report Builder

Confidential

Database Analyst

Responsibilities:

  • Develop scripts to support compliance application enhancements using stored procedures, packages, functions
  • Becoming familiar with shared schema objects and Oracle Mantas tables for transactions monitoring
  • Conduct training sessions and peer code reviews
  • Keep issue logs current
  • Troubleshooting scenario xml for data quality
  • Keeping documentation current with new enhancements
  • Write SQL scripts to perform ETL jobs for watchlist entity entries

Environment: Quest Software (TOAD), Mantas UI, Oracle 11g, PL/SQL, SQL*PLUS, Windows NT, UNIX, MS Office

Confidential

Sr. Database Developer

Responsibilities:

  • Provide database support for the Bank applications residing in Oracle, namely the Commercial Loan application, and Compliance application
  • Develop PL/SQL scripts to support application enhancements using stored procedures, packages, functions
  • Write SQL scripts to perform ETL jobs
  • Involve in performance tuning
  • Write queries to access global credit monitoring database for Customer ratings, Loan ratings
  • Using SMBC master data and shared schema objects to develop scripts
  • Develop a thorough understanding of a 3rd party Commercial loan data dictionary product
  • ( Misys Commercial Loan 6.0) that holds data on commercial loan customers, financial deals that are drawn, credit line facilities, loan portfolio positions
  • Develop UNIX scripts to transfer files across application servers
  • Generating the Bank's monthly SWIFT reports
  • Develop knowledge in BI tool IBM Cognos 10 Report Studio to build reports

Environment: Quest Software (TOAD), Oracle 11i/10g, PL/SQL, SQL*PLUS, UNIX, Serena PVCS, IBM Cognos 10 Report Studio, Windows NT

Confidential

Sr. Systems Analyst - Database Developer/ Business Analyst

Responsibilities:

  • Actively used Confidential Enterprise wide datawarehouse that houses the client proprietary account and trades transactions, Financial Analyst, Product Lines, Branch information and various specific datamarts with conforming key attributes to create quarterly, monthly and daily extracts for Business Analysts, and Senior Managers in the Compliance Department
  • Understanding the Compliance Report Delivery system to actively provide full production support
  • Responsible for the data mapping of the attributes used in the Datawarehouse tables
  • Confidential Enterprise wide Datawarehouse has a data volume of approximately 8 - 9 Terabytes
  • Meeting with business users and business analysts to review reports requirements specifications
  • Develop reports using Oracle Report Builder for several compliance business units, Product surveillance, Customer Surveillance and Money Laundering
  • Involved in the entire life-cycle of the project, from gathering user requirements, developing projects task plans to provide estimates of man hours required to complete work, functional unit testing, both pre- validation and post-validation of results, and documentation

Environment: SQL Navigator, Oracle 10g, PL/SQL, SQL*PLUS,Oracle Report Builder, Eclipse IDE for JAVA, Windows NT

Confidential

Oracle Datawarehouse Developer/Technical Business Analyst /Business Intelligence Architect

Responsibilities:

  • During my tenure at Confidential and Harriman, my function as a Systems Developer has ranged from Datawarehouse Developer, Technical Business Analyst to Business Intelligence Architect
  • Maintaining and supporting several financial datamart applications (both batch systems and real - time systems) housed in Oracle database server that includes Trade History, Positions, Securities Lending, Mutual Fund Processing system, Portfolio Valuation
  • Involved in full life cycle development of the Securities lending application from developing scripts to load transaction activity and a comprehensive set of reporting products that offer clients a selection of several categories of reports
  • Involved in the migration of database objects from Oracle8/to Oracle9i/Oracle10g
  • Involved in physical database modeling, and developed PL/SQL scripts to process replication tables
  • Used case tool ERWIN to update data models
  • Provide time estimates for completion of project tasks assigned to resources
  • Fluent in DDL, DML, DCL scripts; PL/SQL language to automate loading Procedures
  • Good knowledge of OLAP analysis tool

Environment: SQL Navigator, Oracle 8.x/9.x, PL/SQL, SQL*PLUS, UNIX, JavaScript, SQR, Cognos,Hyperion/Brio 8.x, Hyperion Broadcast server, Windows NT

Confidential

Oracle Developer, Data modeler to Business Intelligence Developer

Responsibilities:

  • Role as a Programmer has ranged from Oracle Developer, Data modeler to Business Intelligence Developer
  • Involved in design, implementation, and maintenance of departmental relational databases for Premium and Claims information up to the policy level
  • Used CASE tool, Visible Analyst, ERWIN for developing ER diagram for Datawarehouse ROLAP model generating the DDL scripts, index, and referential integrity constraints
  • Keep current the data dictionary and provide end - user support, about 20 managers and supervisors in New York Headquarters and Branch offices across the country in running adhoc custom queries and drill down analysis
  • Developed reports using Microstrategy DSS Architect and DSS Agent for Premium Claims and Agent Analysis
  • OLAP metrics supported: Current YTD vs. Prior YTD, Current Year vs. Prior Year, Percent, and Total
  • Responsible for Oracle local client installation, ODBC drivers, SQL*NET2.3, and creation of datasources
  • ETL knowledge using Informatica
  • Acted in the capacity of backup to DBA, creating users and profiles.

Environment: Oracle7.3.2, PL/SQL, SQL*PLUS, Visible Analyst, ERWIN, UNIX, Microstrategy, Informatica

Confidential

Data Analyst/Data Modeler

Responsibilities:

  • Wrote scripts to access information from an Oracle database server from the main campus The City college of New York
  • Assisted in projects for the formulation of predictive models for academic performance, the evaluation studies of various courses, and reporting aggregate statistics on a wide array of outcomes to key administrators
  • Performed data modeling to determine the entities, data elements, data constraints and accessibility for an on - line database system. SDMOS (Sophie Davis Medical School On-Line System). Implemented and maintained SDMOS using Microsoft Access

Environment: Oracle 7.x, SQL*PLUS, MsAccess2.0, SPSS

Confidential

Summer Intern

Responsibilities:

  • Involved in the operational needs and development design phase of the Departmental database system
  • Project involved monitoring the Borrower key commitments and their respective status of compliance. Gathered user requirements and extracted the entities, relevant data attributes to design the Entity - Relationship (ER) diagram
  • Interacted with the Front-Office team to gather user requirements, reports for analysis and research
  • Investigated the root cause of work flow problems by carrying out a computer needs analysis of the whole department
  • Gave recommendations in terms of hardware and software issues

Environment: MsAccess2.0

Hire Now