We provide IT Staff Augmentation Services!

Sr. Bi/etl Data Architect/integrator Resume

SUMMARY:

  • Highly skilled and Energetic Data Consultant with more than 20+ years of hands - on, broad-base experiences in Software Development Life Cycle (SDLC) for Information Technology Big Data solution.
  • These include Software Design, Security, Development, Implementation and Maintenance.
  • Ability to bridge the gap between Business and Technology and collaborate with other teams.
  • Architect ETL solutions and Big Data integration strategy.
  • A highly sought after and broadly skilled Big Data Integrator/Consultant with Informatica PowerCenter v9.6. Subject Matter Expert (SME), Just being trained on InfoSphere DataStage v9.1 and working knowledge of OBIEE Oracle BI 11g R1, Virtualization, Great Problem Solving skills, Technical Analyst, Team lead offering extensive experiences of successfully analyzing, designing, implementing, data Cleansing/Migration/Conversion, and managing IT and Security Solutions/Programs for the United States Federal Government and Private Enterprise environments.
  • Utilized Agile Software development methodology in successfully delivery of software projects to Clients.
  • Created Business Requirements; Business Process Flow; Logical STAR Schema database model; and Data Modeling.
  • Experiences in performing Meta Data management and Data Cleansing. Informatica PowerCenter expertise in dealing XML source schema. Performed Extract, Transformation, and Load (ETL).
  • Senior Requirement Analyst designing Logical/Physical Data Model and Data Analysis.
  • Proven record in ability to deliver cost effective and quality IT Services.
  • Requirements and Analysis and Software Quality Solutions.
  • Creative problem-solver and continuously sought after to turnaround struggling projects/processes.
  • Adept at identifying patterns and operational needs before developing innovate strategies that increase revenues, reduce costs and boost productivity.
  • Talented at quickly earning the trust, confidence, and respect of peers, senior management, clients, and key decision-makers.
  • A respected leader, experienced in overseeing remote teams. Looking for a new, exciting opportunity to contribute to an industry leader.
  • Proven record in successfully delivered medium to large Data Integrator Projects for Big Data Applications.
  • Extensive experiences in utilizing Informatica PowerCenter (ETL) in delivery data transformation Projects.
  • Delivered Highly Complex SQL performance tuned scripts and written complex UNIX scripts.
  • Identified strategies for delivering the company’s revenue growth. Develop, track, and control the annual operating budget for delivering the existing and new projects. Development and management of Data modeling, predictive modeling, business architecture, application architecture and rationalization; Business Architecture with Requirements gathering, project scope analysis and Use Case development.
  • Experienced in team assessment, process integration, Change Management, Change Control, integration, and motivation. Experienced in Customer Relationship Management Product life-cycle, impact and risk assessment with contingency planning, requirements gathering and writing, Use Case development, activity diagramming, business reengineering & process redesign, standards definition and implementation, project facilitation and meeting management, workflow analysis, testing traceability, budgeting and cost analysis.
  • Provided System Engineering and Process Engineering support to the Application Architecture and Engineering. Develop Application requirements, design (conceptual, logical and physical) and review configurations of the infrastructure to ensure all requirements have been satisfied. Requirement gathering and analysis Application Architecture engineering and deployment on different projects.

AREAS OF EXPERTISE AND YEARS OF EXPERIENCES:

  • Informatica Architect Performed Big Data Integration using PowerCenter v9.6; 11+ years in Informatica PowerCenter Architect; data transformation in Big Data Warehouse with more than 30 TB; data cleansing and data profiling. Created complex Informatica Mapping and Transformations; including workflows tuning.
  • System Architecture and Application Development.
  • Data Cleanse and Data Quality Performance Tuning SQL and Scripting Expertise.
  • Complex Project Leadership IT Strategy & Execution Business Development.
  • Requirement Analyst.
  • Resource Management Team - Building & Leadership.
  • 15+ years in writing complex custom scripts using Bourne and Korn Shell; SQL scripts, PL/SQL, SQL tuning; and optimization for automated sub-systems in Oracle environment and participated in Enterprise Wide Data Quality projects.
  • 15+ years in Full Software Development Life Cycle, including gathering and compiling user requirements, Data Modeling (Logical), Meta Data Management, system integration testing, and implementation.
  • 10+ years in leading technical team in facilitating and discussing business requirements with business users and managers. This include leading the analysis and developing Technical and Functional specification. Ensured Sox documentation Standard and Policies are met.
  • Excellent Business background and knowledge coupled with the ability to transform business ideas into successful technical solution.
  • 7+ years in designing Logical/Physical Data Model, Data Analysis and Cleansing, and Master Data Management.
  • 10+ years in manual QA Testing (functional, regression, integration, UAT, etc) in UNIX environments. Extensive exposure to QA methodologies, best practices, and instilling strong QA approach within projects relative to requirements gathering, building upon a solid foundation and structured model of QA processes, as well as building reusable scripting for testing of data. Extensive experience in developing test plans, testing schedules, and test cases from technical design specifications, functional specifications and functional requirements.
  • 10+ years recent experience in designing large Oracle Star Schema Data Warehouse, including writing test scripts against the Data Warehouse and ETL processes in working with data and testing in data marts.
  • Completed training on Confidential InfoSphere DataStage v9.1 and working knowledge of OBIEE Oracle BI 11g R1. Have some knowledge of SQL server SSIS.

TECHNICAL PROFICIENCY:

Languages: Completed OBIEE and MicroStrategy BI Project Design Training, Passed MicroStrategy Certified Project Designer certification, Completed Oracle OLAP Basic Training, C, PERL, SQL, DB2 SQL, PL/SQL, X-QUERY, SQR, XSLT, HTML, Pascal, Basic, UNIX Shell Languages, RDB/SQL, C++, ADA, Fortran.

Software Packages: Trained on InfoSphere DataStage v9.1, Informatica PowerCenter v9.6x SME, Embarcadero ER/Studio, Confidential Rational tools, Rational Quick Test Pro, Clear Quest, Actuate v7, Crystal Reports v8, Visio, SQR Report Writer, Oracle Financial Application 11i, Syncsort, PopKin Systems Architect, PVCS, People Resource Planning (PRP)™ Software-TEDS Application, Ernst and Young Global Expatriate Management (GEMS) Application, Oracle Developer 2000, SQLmenu, SQLforms, Lotus Notes.

Operating Systems and Databases: Linux, UNIX/Korn/Bourne Shell, VAX/VMS, NT, DOS, Windows, and MPE/XL; ORACLE 8i, RDB, and Personal Library Software (PLS) full text database.

Design Methodologies: STAR Schema, Gane and Sarson, Yourdan and DeMarco, Arthur Andersen/Method I, and Booch and Object Modeling Technique (OMT), UML; Kimball and Inmon.

Security: NIST, FISMA, Arcsight.

CAREER SYNOPSIS:

Confidential

Sr. BI/ETL Data Architect/Integrator

Responsibilities:

  • Lead Informatica PowerCenter Architect responsible for installation, setup and configured the Informatica v9.6.1.
  • Created, Developed, Unit Tested, System Tested and Migration of Mapping, Mapplets, Worklets, Workflows, and parameter file to Production environment.
  • Hands-on created standard documentation and Informatica Client setup.
  • Installed Actian databases connector for Informatica and ODBC client.
  • Migrating Informatica v6 artifacts to Informatica v9.6.x. Architect Informatica ETL solutions .Performed Data Source data analysis.
  • Trained on Actian MPP DB; Vector and Matrix.
  • Learned and used Ingres SQL.
  • Lead Informatica PowerCenter Architect responsible for enhancing and developing new functionality.
  • Architect Informatica ETL solutions and Performed Change Data Capture load.
  • Performed Data Source data analysis.
  • Architecting Confidential tables with Data Modeler.
  • Trained on Confidential InfoSphere DataStage v9.1 and Oracle Data Warehouse Administration Console.
  • Working knowledge and Modified OBIEE Oracle BI 11g R1.

Confidential

Senior ETL Data Integration Specialist

Responsibilities:

  • Lead Informatica PowerCenter Architect responsible for maintaining and developing new functionality.
  • Architect Informatica ETL solutions and Performed Change Data Capture load.
  • Trained on Confidential InfoSphere DataStage v9.1 and Oracle Data Warehouse Administration Console.
  • Working knowledge and Modified OBIEE Oracle BI 11g R1.

Confidential

Senior Analyst/Programmer

Responsibilities:

  • Architect ETL solution and Big Data integration strategy. For instance, responsible for Architecting and Designing entire defect free 1095A data flow and data transformation for loading to Confidential database.
  • Responsible for IRS ACA project with developing information security documentation and providing remediation recommendations for high risk business systems utilizing the NIST SP 800-53 rev3 standard.
  • Familiar government regulations and standards: National Institute of Standards and Technology (NIST), Federal Information Security Management Act (FISMA), FISCAM, FedRAMP, Gramm Leach Bliley Act (GLBA), HUD Handbook, Sarbanes Oxley (Sox), National Housing Act, etc.
  • Responsible for the development and implementation of security procedures.
  • Review security policies and procedures by administering and monitoring security profiles, reviews security violation reports and investigates possible security exceptions, updates and maintains the documented security controls.
  • Developed data transformation rules and implement extract, transform and load ACA/IRDB data mappings, tasks and workflows.
  • Created custom XML source view and perform complex XML manipulation using Informatica Powercenter.
  • Performed deployment of software releases.
  • Performed Informatica Workflows migration from v9.0.1 to v9.6.
  • Designed, implemented and tested highly complex Informatica workflows for ACA healthcare data.
  • Some Postgres SQL experiences.

Confidential

Senior Analyst/Programmer

Responsibilities:

  • Designed, implemented and performed quality assurance on Informatica PowerCenter workflows for transferring data to Cognos BI data mart.
  • Perform data transformation and cleansed. Modified COTS TPI’s ETL mappings.
  • Perform Informatica administrator related tasks.
  • Designed and implemented data model for a small Cognos BI datamart.
  • Assisted Maricom EDSC project to implement Data Quality tasks and Informatica mappings for 3 weeks.
  • I was on three-weeks borrow resources to Maricom EDSC project.

Confidential

Senior Analyst/Programmer

Responsibilities:

  • Performed extract, transform and load census data that feed into Census Metadata and into Oracle tables.
  • Performed Data Cleansing and transformation into Census Metadata Depository.
  • Designed, Implemented and tested Census search Interface and data transformation.
  • Trained junior co-worker on Census processes and Created ETL documentation.

Confidential

Senior Consultant Data Warehouse/ETL Architect

Responsibilities:

  • Responsible for implementing Data Integration strategy between Center for Medicare and Medicaid Services system and DECC systems.
  • Led and Implemented Informatica PowerCenter Architecture Framework and Standard.
  • Designed and Implemented Informatica Mapping, Workflows, Session tasks, Mappings, Worklets, Lookups, and so on.
  • Analyzed Claims, Patients and Facilities data lineage/relationship for End Stage Renal Diseases project.
  • Critiqued and provided feedback on Business Requirements to the Business Analysts.
  • Created, documented, and delivered the Interface Communication and Data Conversion documents.

Confidential

Senior Data Warehouse/Data Architect/ETL Consultant

Responsibilities:

  • Analyzed data sources from multiple Companies. Using Salesforce Apex Data Loader loading data to Veeva.
  • Developed Logical Data Model for Enterprise Data Warehouse and MDM for Pharmaceutical Manufacturer.
  • Created and implemented Oracle DDL scripts for Sequence generators, Triggers and Stored Procedures the Enterprise Data Warehouse.
  • Developed and Implemented 54 Informatica PowerCenter Mappings, Session tasks, Worklets, and Workflows for Type 6 Slow Changing Dimension Data Model within the first 6 weeks of joining the client.
  • Tested complex Informatica PowerCenter mappings for Lookups, Aggregation, Router and Mapplets to transfer and load data from Data Warehouse to Oracle Data Marts.
  • Implemented and automated processes using Unix Shell Scripting to execute SQL, PL/SQL scripts.
  • Created complex SQL scripts to extract data from Enterprise Data Warehouse for reporting purposes.
  • Developed, documented, and updated (Wiki) business processes to establish a comprehensive, coherent body of knowledge that can be used to transition onto the data warehouse support team.
  • Resolved PL/SQL interfaces issues by modifying PL/SQL and UNIX scripts.
  • Excellent Problem solving skills and my ability to resolve difficult and complex issues.
  • Performed Application testing for transition onto Window 7 environment.

Confidential

Senior Data Warehouse/ETL Consultant

Responsibilities:

  • Implemented and automated processes using Unix Shell Scripting to execute SQL, PL/SQL scripts.
  • Created complex SQL scripts to extract data from Enterprise Data Warehouse for reporting purpose.
  • Designed, implemented and tested complex Informatica mappings for Lookups, Aggregation, Router and Mapplets, and Workflows to transfer and load data from one database to another Oracle database.
  • Performed Extract, Transform, and Load processes for Data files to feed into Reporting Data Marts.
  • Gathered, Update, and Documented business and data requirements documents.

Confidential, Washington, DC

Senior Data Warehouse/ETL Analyst

Responsibilities:

  • Created and implemented automated process using Unix Shell Scripting to execute SQL, PL/SQL scripts.
  • Transformed business ideas into technical solutions.
  • Designed, implemented and tested complex Informatica PowerCenter mappings for Lookups, Aggregate, Joiner, Router, Worklets, Mapplets, and Workflows to transfer and load data from one database to another Oracle database, including logical design of Enterprise data flows.
  • Standardized Informatica PowerCenter naming convention so that it can be executed via UNIX script.
  • Converted SQL reports from UNIX into multi-tabs Excel Spreadsheet using UNIX and Perl command script.
  • Managed and multi-task between nursing, surgery and emergency department (ED) projects for healthcare industry.
  • Defined Global environment variables for Informatica PowerCenter.

Confidential, Washington, DC

Team Lead/Senior Analyst

Responsibilities:

  • Implemented and automated processes using Unix Shell Scripting to execute SQL, PL/SQL scripts.
  • Transformed business ideas into technical solutions.
  • Used Visio Professional to create Logical Data Model E-R diagrams, Business Process and System Process flows.
  • Performed Extract, Transform, and Load Data files to feed Reporting Data Marts.
  • Created Complex SQL scripts and Tuned SQL for DB2.
  • Developed Logical Data model, Data Analysis and Cleansing.
  • Gathered, Critiqued and Documented business and data requirements documents.
  • Created Complex SQL scripts and Tuned SQL for DB2.
  • Developed Logical Data model, Data Analysis and Cleansing.
  • Gathered, Critiqued and Documented business and data requirements documents

Confidential, Washington, DC

Data Warehouse/Team Lead

Responsibilities:

  • Implemented an automate process using UNIX Shell Scripting to validate all Financial Statements for Income Capital Business Model. Transformed business ideas into technical solutions.
  • Participated in designing the new Portfolio Data Services systems for Confidential . This new system perform Confidential Assets and Liabilities’ Risk Forecast and Compute duration of the assets and liabilities such that duration gap is within the management’s goal.
  • Facilitating across Functional teams for Enterprise Wide Data Quality projects. Created Logical Data Model for Loan Database. Created Sample test data. Used Visio Professional to create Logical Data Model E-R diagrams, Business Process and System Process flows.
  • Lead Technical teams in Facilitating and Discussing Business Requirements with business managers and users; this includes Leading the analysis and creating Functional and Technical specifications.
  • Created Complex SQL scripts and Tuned SQL. Performed Data Profiling using Exeros Discovery tool.
  • Performed Extract, Transform, and Load data files to feed Data Marts and Warehouse Database using Informatica PowerCenter. Created ETL data flows. Created and Maintained Oracle Database Meta Data.
  • Met with stake holders to discuss the scope for Business Requirements.
  • Performed loan portfolio Data Cleansing; instill documentation discipline; and SOX control procedures.
  • Created a new General Ledger Oracle database for drill-down of complex financial statements.
  • Mastered the “SUMMIT”, 3rd party Financial Application, database in just three weeks, and independently validated the Debts VNML portfolio using SQLs and found 5 errors in the process.
  • Gathered, Critiqued and Documented business and data requirements documents.
  • Created Stored Procedures and Performed SQL tuning, using Oracle SQL hints for maximum performance.
  • Developed and Maintained Oracle Logical Data Model.
  • Created and Performed overall regression test plan for RBCPro (risk-based capital software) for OFHEO risk management compliance purposes. Created independent Sybase SQLs for automate verification processes.
  • Implemented test procedures and processes to ensure that all applications are thoroughly tested.
  • Created XSLT conversion style sheet to flatten XML files for QA automate processes.
  • Developed processes using Unix Shell scripts to validate all derivative instruments’ data for Confidential portfolio. Ensured Sox documentation Standard and Policies are met.
  • Documented, Analyzed, and Transformed business ideas into information technology solutions.
  • Evaluated, Implemented and Supported Custom Off The Shelf (COTS) application for Exeros Data Profiling Discovery and Compuware File-Aid Disguise tools.
  • Evaluated and Tested Portfolio Data System (PDS) Assets and Liabilities Financial Modeling Systems.
  • Managed multiple projects for the Portfolio Strategy group in Confidential throughout the different phases of Software Life Cycle Process.

Confidential, Bethesda, Maryland

Team Lead/Senior Systems Analyst

Responsibilities:

  • Designed, Implemented and Maintained Confidential International Reservation Data Warehouse Oracle databases (approx. one terabyte).
  • Hands-on tester for all COTS Application and Oracle-based Data Warehouse.
  • Software development lead in Full SDLC including meeting with users, gathering and compiling user requirements (Method I), designing logical data models, and implementing sub-systems for data-mart.
  • Utilized Informatica PowerCenter, Crystal Reports, SQL, PL/SQL, including Stored Procedures/Functions, SQR Report Writer, MS Project, C, UNIX to PeopleSoft interface, Data Conversion, and Unix Shell Scripting.
  • Utilized Informatica PowerCenter tools to extract, transform, and load (ETL) data and create reports.
  • Written complex SQL scripts, tunings and utilized hints to optimize SQL performance.
  • Supported the Confidential International’s Reservation Data Warehouse, utilizing STAR schema methodology.
  • Performed system integration, regression, and unit tests for Data Warehouse Applications.
  • Developed test cases for white and black box testing, and performed software development life cycle (SDLC) testing as needed.
  • Implemented test procedures and processes to ensure that all applications are thoroughly tested.
  • Created tasks list for step by step procedures for white and black box testing, and assigned resources as required.
  • Evaluated new custom-of-the-shelf (COTS) applications.
  • Managed and lead various Human Resources application projects, including TEDS and GEMS applications.
  • Initiated Request for Proposal for various new software applications for Application Service Provider projects.
  • Planned and compiled next year budgets for individual projects.
  • Coached junior analysts on business and systems functionalities.
  • Coordinated resources from various departments to achieve projects’ objectives.
  • Performed troubleshooting for COTS applications.

Confidential, Glen Burnie, Maryland

Oracle Financial Programmer/QA Analyst & Team Lead

Responsibilities:

  • Software development lead in Full SDLC including meeting with users, gathering and compiling user requirements, designing logical data models, and implementing sub-systems for 3-way invoice, receipt, and purchase orders matching.
  • Supported Oracle Financial Application 11i and utilized C, PL/SQL, including Stored Procedures/Functions, Developer 2000, MS project, and Unix Shell Scripting.
  • Lead the system integration test for Oracle Financial Application, including purchase orders/receipts matching sub-systems.
  • Performed regression and unit testing for purchase orders/receipts matching sub-systems.
  • Successfully implemented the new three-way purchase orders/receipts matching sub-system using PL/SQL, Unix Shell Scripts, and SQL/Plus. Resulted in 50% costs saving.
  • Developed inter-companies ledger reports for auditor, using SQL/Plus.
  • Designed and implemented Oracle reports for Oracle Payables sub-system, using SQL/Plus and Developer 2000.
  • Maintained Oracle General Ledger sub-system, using PL/SQL and SQL/Plus.
  • Resolved Oracle Financial Application systems related problems.
  • Utilized Developer 2000 to create and enhance Oracle Financial and Payables reports.
  • Created and maintained a manual accounting data feeder sub-system, using SQL/Plus and SQL-Loader.
  • Loaded and reconciled monthly sales data into Oracle General Ledger subs-system, using PL/SQL and SQL/Plus.

Confidential, Washington, DC

Senior Analyst/Programmer

Responsibilities:

  • Software development lead in Full SDLC including meeting with users, gathering and compiling user requirements (Method I), designing logical data models, and implementing sub-systems for night-alert and automate web-publishing.
  • Utilized Perl, C, PL/SQL, including Stored Procedures/Functions, HTML, and Unix Shell Languages, SQL/Plus, Developer 2000, PL/SQL, SQL/Forms, C++, Digital Command Language (DCL), Lotus Notes, MS project, MS Access, SQR Report Writer, and full system life cycle project development.
  • Designed and implemented a Personal Library Software (PLS) full text state legislative database for the Washington Alert systems, using Oracle PL/SQL, SQL/Plus, and SQL Report; Developed a state legislative reporting system, using Oracle SQL/Plus.
  • Performed system test and hands-on implementation of COTS Application.
  • Developed test cases for white and black box testing and performed software development life cycle (SDLC) testing as needed for all COTS Application.
  • An assistant Database Administrator (DBA).
  • Created task lists and performed hands-on regression and unit test for all COTS Application.
  • Participated in Web development projects. Converted PLS databases into SGML and to HTML files.
  • Successfully redesigned, streamlined, and enhanced the news Night-alert sub-system and the Congressional schedule database that resulted in 30% costs saving.
  • Project Leader for the StatetNet project that automates the process of feeding the daily state legislative data to the state legislative full text database, using C, PL/SQL, Stored Procedures/Functions, SQL/Pus, and DCL.
  • Designed and implemented the FloorWatch and the NewsAlert PLS databases for the Confidential World Wide Web site CQ.com, using SQL/Plus and PL/SQL.
  • Project lead for implementing an automated system for the Weekly Report publication.

Confidential, Columbia, Maryland

Financial Systems Analyst

Responsibilities:

  • Utilized Pascal, C, PL/SQL, including Stored Procedures/Functions, RDB/SQL, Digital Command Language (DCL), MS project, MS Access, SQR Report Writer, Basic, and full system life cycle project development.
  • Hands-on software development life cycle (SDLC) including meeting with users, compiling requirements, including functional design, logical and physical design of database and implementation.
  • Lead analyst involved in designing, planning, and implementing the new Mortgage Backed Securities System for Collateralized Mortgage Obligation (CMO) bonds, Pass-Through (structured) securities and other assets securitization models for mortgage and asset backed collateral pools.
  • Developed Stored Procedures/Functions for bond payment sub-systems.
  • Lead Analyst for implementing the asset backed securities forecasting system.
  • Delegated sub-tasks to team members and trained junior analysts on business and system functionalities.
  • Streamlined the process of generating securities pricing reports that resulted in 20% costs saving.
  • Effectively managed resources for pass-through securities modeling and investor direct analytics projects.
  • Analyzed, designed, and implemented a historical tracking and analysis system for bonds and collateral payments including an actual prepayment experience sub-system.
  • Performed financial systems design, analysis, and bonds modeling.
  • Developed and maintained technical and end-user documentation.
  • Received the annual Company award for “Outstanding Achievement” for the most productive programmer analyst on the development team.

Hire Now