We provide IT Staff Augmentation Services!

Sr. Data Architect/etl Architect Resume

Richmond, VA

SUMMARY:

  • Over 20 plus years of experience in Data analysis, design, development, testing and implementation of Client/Server, ERP and Data Warehouse. I have expert knowledge within analytical and problem solving skills.
  • Experienced in End to End Data mapping, ETL logic validation 239 principles, FFIEC101, FRY 9C and AML Regulatory Reporting and IT Internal Auditing.
  • Development Life Cycle (SDLC) and ITIL V3 Certified

SKILLS:

Operating Systems: Windows 2000/NT/98/95, UNIX, MS - DOS, Windows 3.1

Languages & Technology: VB, ASP, PL/SQL, SQL, Fundamentals of Java 2, Perl, C, Tobin, ADO, COM

Web Servers: IIS (Internet Information Server)

Databases: Oracle7.x/8i/9i/10g/11g, Sybase, MS Access 8.0/7.0/2.0, MS SQL Server 7.0/2000

Tools: Developer 2000/Developer6i, Designer6i/2000, Erwin, Business Objects 5.0/XI,BODS, Crystal XI, Infomaker 11 and Cognos 8, SAS 4.3

ERP: Oracle 11i F inancials (Customization of Reports and Forms.), Novistar, P2es, Oracle Energy, SAP BW/BI Netweaver 7.2.

BigData: Hadoop,Hbase,Hive, BigSQL

EXPERIENCE:

Sr. Data Architect/ETL Architect

Confidential, Richmond, VA

Responsibilities:

  • Providing consulting and Advisory services in implementing Enterprise Data Warehouse solution for Virginia State Police, includes ETL/ELT and Business Intelligence tool evaluation, vendor negotiations, Cost estimates, design, road map and pilot program.
  • Responsible for Oracle Data integrator (ODI) 12cR2 installation and configuration on Solaris 11, Design, Data mapping, Data modelling, ETL/ELT logic, SAP Business Objects 4.2/lumira installation and configuration on Solaris 11, Universe Design and report development as part of the pilot program to provide road map for VSP Data warehousing initiative.
  • Responsible for mapping, ETL, universe design and all the related activities.

Environment: ODI 12c, Oracle 12c, SAP Business Objects 4.2, Solaris11

Sr. Data Engineer

Confidential

Responsibilities:

  • Providing advisory services to The Program Executive Office (PEO) and Program Management Office (PMO) for Defense Health Modernization Systems (DHMS) Project.
  • Providing Courses of Action related to data retention and Archival solutions based on NARA and HIPAA requirements.
  • Validating and reviewing Decommission planning, Interfaces, Architecture, Data Flow, Data Mapping, Data Quality, Data Lineage, Data Modeling.

Sr. Professional/Manager (Data Analyst/Data Architect/IT Internal Auditor

Confidential

Responsibilities:

  • For each control remediation as part of the corrective action plan, reviewed the DEA (BRD and FRD), inspected the BRD and FRD to verify that Business requirements in the BRD mapped/traced to the Functional requirements in the FRD. Reviewed the approvals, sign off by AML Operations, AML PMO, AML Advisory and AML Technology had occurred at the appropriate time.
  • Performed Operational effectiveness (OET) validation based on the Data Quality Platform (DQP) rules.
  • Minimized potential blind spots in sourcing, staffing and on boarding by working with the Confidential recruiters, resources, managers and directors.
  • Initiated and identified the resources as per the client needs by reviewing the resumes, coordinating with Confidential and client lead.
  • Identified attributes required to analyze the mortgage fraud types such as a Builder Bailout, Double selling, Asset rental, foreclosure, Buy bailout, Short sale, Chunking, Equity skimming and Fictitious loans etc. part of Business Development .
  • Identified Data points to develop credit risk and score model and involved in developing presentation deck for Business Development.
  • Designing know your vendor (KYV) database for the supply chain risk management tool to identify the risk associated with vendors, contractors, suppliers, products and services. The globalized vendor and supplier network represents an opportunity to integrate illicit goods, launder money, legitimize illegal labor, and sustain sanctioned entities.
  • Designed process flow for the Elderly Fraud detection.
  • Designed process flow for Hedge funds and Anti-Money laundering.

Environment: Oracle 11g, SQL Server, SQL, Toad, Tableau,Paxata.

Data Architect

Confidential

Responsibilities:

  • Data Modeling
  • Data Validation, Cleansing, Mapping, Extraction and Migration
  • SQL and PL/SQL
  • Data Integration
  • Data Dictionaries
  • DFDs, DSDs and ERDs
  • MDM (Master Data Management)
  • ETL specifications and develop data mappings
  • Asset Management

Environment: Oracle, SQL Server, SQL, Visio.

Sr .Data Architect/Analyst

Confidential, Richmond, Va

Responsibilities:

  • Responsible for Data analysis, Data Modeling, Data/process flow diagram and Data Lineage Mapping attributes for CTR (Currency transaction reporting), Monetary Instruments, general Anti-money laundering Transactions.
  • Responsible for identifying attributes required for Anti-Money Laundering and Suspicious Activity Report (SARs) Filing for currency transactions.
  • Responsible for writing triggers for cash withdrawals, check cashing, currency/ monetary instruments and wire transfers.
  • Build solutions for enhanced compliance, critical deficiencies in Anti-money laundering controls and make formal recommendations for correction.
  • Oversee a team of five junior AML compliance analysts, provide guidance and review all analyst recommendations for further review.
  • Responsible for ETL logic, Data Lineage and mapping attributes..

Confidential, Pittsburgh, PA

Data Analyst

Responsibilities:

  • Charge-off Date
  • Charge-off Amount - Separate fields for principal, interest and fees
  • Principal Forgiveness Date
  • Principal Forgiveness Amount
  • Responsible for identifying attributes for Delinquency Status, Material Fair Value Adjustment, Repo Initiation, Over-Draft Protection, Default Resolution & Recovery Requirements, 3rd Party Foreclosure, OREO Sale, Short-Sale/Settlement, Settlement, Full Balance etc..
  • Involved in reviewing attribute mappings and current gaps with SMEs to Confirm mappings and Identify gaps which need to be addressed, to remediate gap attributes for current year models and Design required Process changes to ensure data capture moving forward.
  • Responsible for mapping consumer charge-off and recovery data in support of RCMR (Basel and CCAR models).
  • Data Flow/ Data Lineage Diagrams (DFD/DLD) to depict the source-to-Target Mapping and Data Lineage Analysis.
  • Responsible for reconciliation of data from source all the to DataMart using he BCBS-239 principles.
  • Participated and validated Business Requirements, Design Documents, Mapping Documents, Test Strategy, Test Plan & Test cases in User Acceptance and System Integrated Testing environments.
  • Involved in validating data between Source (Assets) and Target RCMR (Basel and CCAR models).
  • Responsible for Developing ETL scripts to pull the Data from ETL Stage Database for MSP asset class. Responsible for creating SAS Dataset and Data profiling.
  • Worked in PD and LGD data modeling with various business units for yearly model change implementation
  • Responsible for Reports like FFIEC101, FRY 9C.

Environment: Oracle 11g, SQL, PL/SQL,SAS, Unix and Excel

Sr.Data Analyst

Confidential, Fairfax, VA

Responsibilities:

  • Responsible for Data Analysis, Lessons learned analysis and Data Artifacts for the Postal One application releases.
  • Responsible for validating and approving Data/Database related production support Data repairs for the Postal One application.
  • Responsible for checking Database related log file for Postal One applications Pre and Post Deployments.
  • Responsible for creating Ad-hoc and Canned reports for SIT/CAT for each release, information on SRS, DRs, ERs .
  • Responsible for creating graphs/charts for root cause analysis (Code issues, Database issues, configuration issues, user errors etc.), creating graphs for Priority details (critical, high, medium and low).,Days to close charts etc.

Environment: Oracle 11i, SQL, PL/SQL, HP ALM, SAP Business Objects XI R3

Sr.Data Analyst

Confidential, Mclean, VA /Wilmington, DE

Responsibilities:

  • Responsible for, Data Analysis, Data profiling and Data validation and approvals for Bank Operations Falcon BCP/Share builder projects.
  • Responsible for Developing Ad-hoc and Canned reports for Analysis to report suspicious (Anti money laundering) Cash deposits above $250K, International wire transfers, multiple Joint accounts with different addresses, multiple accounts with different mailing addresses, missing zip codes or phone numbers.
  • Responsible creating reports on commercial (small business) accounts, like monthly/daily deposits, cash deposits etc.

Environment: Teradata, SQL, Teradata SQL Assistant, Business Objects XI R3

Data Report Analyst/BOXI Developer

Confidential

Responsibilities:

  • Responsible for Data requirements/ Technical documentation and Data Analysis for the Home Affordable Modification Program known as Confidential is federal program of the Confidential .
  • The program was built as collaboration with lenders, Investors, mortgage servicers and the Federal housing Finance Agency, to create standard loan modification guidelines for lenders to take into consideration when evaluating a borrower for a potential loan modification programs like Tier1, Tier2, Confidential, NPV, HAFA, PRA, 1MP, 2MP etc.
  • Created and developed canned, Ad-hoc, Dashboard Reports for Confidential Program using Webi on Confidential Data Mart Universe for Analysis and reporting.
  • Responsible for writing complex SQL to generate reports and files.

Environment: Oracle 11g, SQL, PL/SQL,Toad, Clear Case, Clear Quest, Business Objects XI R3

Sr. Data Analyst

Confidential

Responsibilities:

  • Responsible for Data Analysis, Data profiling and Data Modeling on various attributes from HP asset management, HP configuration management, HP Service Management, ITSM, SCCN, Systinet, Rackwise, Clarity, Quality Center which was heavily used in creating and maintaining Corporate compliance, Operational Risk, SOA Governance processes, Application Portfolio Rationalization and IT Optimization.
  • Defined Data attributes, Relationships, LDM (Logical Model) and PDM (Physical Model) ) in collaboration with Data Modelers.
  • On a day-to-day basis coordinated and engaged Off-shore & On-shore teams
  • Participated and validated Business Requirements, Design Documents, Mapping Documents, Test Strategy, Test Plan & Test cases in User Acceptance and System Integrated Testing environments.

Environment: Oracle 10g(SQL,PL/SQL), Teradata 10, SQL Server, DB2 9.7, SQL, Teradata SQL Assistant, Toad.

Confidential, Richmond, VA

Sr.Programmer/Systems Analyst/BOXI Developer

Responsibilities:

  • Responsible for System Analysis/Development/Production Support related to Gas Transmission, Distribution, Accounting, Production, Purchase, Billing, Invoicing, Payment, 1099 - IRS, Property Taxes, Oracle Energy and Tobin (Land, Contract, Domain and Lease Management System).
  • Responsibilities also included System administration, suspend accounts, escheatment process, Participant ownership transfer (Royalty interest/Rental owners) Domain/Division of order approval from Tobin to P2es (Oracle Energy database), price schedules, equations, rate, component, Facilities, report centers, Wells, Network, Meter stations, equipment, sales allocation, daily and monthly theoretical and actual dispositions(AMD), transport statements, revenue and GL transactions and setting up new users, maintaining existing users, created scripts to generate list of active users for SOX compliance, .created and generated variance and reconciliation reports to resolve GL postings for the receivables, payments, suspense and escheatment control accounts for State and IRS Tax fillings. Created PL/SQL, Procedures, Functions and Packages to track, allocate meter volumes, Billing, Payments, Lease and Rental payments based on owners percentage.
  • Involved in designing Star Schema Dimension modeling (OLAP) for Data warehousing and Data Mart databases, tuned SQL and PL/SQL scripts for better performance.
  • Created PL/SQL script for ETL process to load data from OLTP databases to OLAP databases, created Cron batch jobs to run nightly to spool and load data from OLTP database to OLAP databases. Created Business Objects and Crystal Reports Development/Adminstration for OLTP and OLAP databases.

Environment: Oracle 11g (SQL,PL/SQL,SQLPLUS( Procedures,Functions and Packages),SQL Reports, SQL LOADER),Oracle Apps 11i,Forms 9i,Reports 9i, Oracle Application Express (APEX) 4.0,Business Objects/Crystal Reports XI,Tobin 4.3,Infomaker,Cognos 8 (Framework and reports), Oracle Energy-p2es Enterprise,Upsteam, Tobin 4.3,IBM - Filenet(Content Management),Unix, Shell Scripting,Toad, Doors 9.3, Harvest and CA Change Management, SOX

Confidential, Richmond, VA

Sr.Programmer/Analyst

Responsibilities:

  • Developing Technical Specifications, Design Documents.
  • Coordination & scheduling, testing.
  • Extraction and loading data from External tables & Flat files Creating Tables, Constraints, Indexes, Views, Procedures, Functions etc, Analyzed, designed and created Materialistic views for the reports, Analyzing and fixing the production issues, SQL Tuning, writing complex SQL and PL/SQL for reports, writing Shell scripts to retrieve the file and loading the data into tables using Sql Loader

Environment: Oracle9i,,SQL,PL/SQL,Procedures,Functions&packages, Sql Loader, control files, External Tables and LIMS * SQL, Explain Plan,Unix

Sr.Programmer/Analyst

Confidential

Responsibilities:

  • Capacity planning for the tables and indexes, participated in creating stories, assigning story points and participated in interactive retrospective and planning Meetings, coordinated the efforts for loading Test Data from sources, data requirement analysis, Data Synchronization efforts and Data Trimming Strategies, involved in the Data Architecture sessions and recommended to create enterprise data standards, created Technical documentation, communicated the data needs with test teams, created a process for data refresh activities, code reviews, coordination and scheduling of development & testing, coordination with off-shore team for On Call Support, wrote complex SQL and PL/SQL, used Explain Plan for optimal performance and fine tuning, used hints to tune the SQL, writing shell scripts to create signal files to check the file availability and to retrieve the file as well as to run the SQL Loader and to run SQL Scripts (Blocks) to load the Data into Data warehouse(ETL process using PL/SQL and SQL Loader).

Environment: Oracle 9i, SQL, PL/SQL (PL/SQL Blocks, Procedures, Functions and Packages) Toad, Clear Quest, Case, UNIX and Agile

Hire Now