Informatica PowerCenter Big Data Architect

Location:

Severn, MD

Posted:

September 14, 2026

Contact this candidate

Resume:

Ace Analytics Solutions, Inc.

Your Big Data Transformation and Integration Solutions Service provider. ALLEN A. SHE

MARYLAND

*********@*****.***

410-***-****

I am a US Citizen with an active DoD Secret and other clearances. CompTIA Security+ Certified. Highly skilled and Energetic Data Consultant with more than 20+ years of hands-on, broad-base experiences in Software Development Life Cycle in Information Technology Big Data solution. Such as Software Design, Data Vault 2.0 implementation, Data Security, Custom Software Implementation and Maintenance. Ability to bridge the gap between Business and Technology, and ability to collaborate between teams. Architect ETL/ELT solutions. A highly sought after and broadly skilled Big Data Consultant with Informatica PowerCenter v10.4x Subject Matter Expert (SME), being trained in InfoSphere DataStage v9.1 and working knowledge of OBIEE Oracle BI 11g R1, Virtualization, Excellent 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; Data Vault 2.0 Methodology; STAR Schema and Relational database modeling. Experiences in performing Meta Data management and Data Cleansing. Informatica PowerCenter, PowerExchange expertise in dealing XML source schema. Performed Big Data Integration strategy. 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. Highly capable of solving complex problems/issues. Project Development & Management:

• Proven record in successfully delivered medium to large Data Integrator Projects for Big Data Applications. Extensive experiences in utilizing Informatica PowerCenter, including Informatica Cloud version r29, in delivery data transformation Projects. Delivered Highly Complex SQL performance tuned scripts and written complex UNIX scripts.

• 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.

• 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. 2

ALLEN A. SHE

Areas of Expertise and Years of Experiences

• Lead Informatica/Data Architect • Performed Big Data Integration using PowerCenter v10.4x; 15+ years in Informatica PowerCenter/PowerExchange Architect; data transformation in Big Data Warehouse with more than 50 TB; data cleansing and data profiling. Created complex Informatica Mapping and Transformations;

• Application Development • IT Strategy & Execution • Business Development • Team-Building & Project Leadership • Utilized Agile Scrum Methodology for project execution/implementation.

• 20+ years in Data Cleanse and Quality • Performance Tuning • SQL/PL-SQL and Unix Scripting Expertise.

• 17+ 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. Perform Informatica and/or SSIS workflows performance tuning.

• 20+ years in Full Software Development Life Cycle, including gathering and compiling user requirements, Data Modeling (Logical), Meta Data Management, system integration testing, and implementation.

• 16+ 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.

• 16+ years in designing Logical/Physical Data Model using Erwins, Data Analysis and Cleansing, and Master Data Management.

• 16+ 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.

• 16+ 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.

• 8+ years hands on experience in Data Vault 2.0 Modeling and Implementation on MS SQL server database v2012, v2014, and v2016 and Oracle database.

• 2+ years of recent experience using DataStage v9.1 and completed training on IBM InfoSphere.

• 1+ year hands on support and working knowledge of OBIEE Oracle BI 11g R1.

• 6 months hands on experience in using Salesforce Apex Data Loader to load address data to Saleforce Veeva.

• Completed ServiceNow Fundamental Administration training. Knowledge of Hadoop MapReduce (Master and Slave) and understand and having Security knowledge of FISMA Standards - NIST Guidelines. Technical Proficiency

Languages: Certified Data Vault 2.0 Practitioner, Postgres scripting exp, Utilized PowerBI for reporting, ANSI SQL, DB2 SQL, PL/SQL, MicroStrategy Certified Project Designer, Completed Oracle OLAP Basic Training, C, PERL & Unix Shell Scripting, X-QUERY, SQR, XSLT, HTML, Pascal, Basic, Fortran. Software Packages: Power BI application, Github, Completed ServiceNow Fundamental training, ERWIN Data Modeling tools, Informatica PowerCenter v10.4x SME on Cloud AWS and Azure, Trained on InfoSphere DataStage v9.1, Trained on Ab-Initio, Embarcadero ER/Studio, IBM 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. Knowledge of Security protocol NIST, FISMA, Arcsight. Operating Systems and Databases: Linux, UNIX/Korn/Bourne Shell, Greenplum,VAX/VMS, NT, DOS, Windows, and MPE/XL; ORACLE v12c, RDB, and have knowledge of Hive and NoSQL. Design Methodologies: Data Vault 2.0 Certification, STAR Schema, Gane and Sarson, Yourdan and DeMarco, Arthur Andersen/Method I, and Booch and Object Modeling Technique (OMT), UML; Kimball and Inmon. 3

ALLEN A. SHE

CAREER SYNOPSIS

ACE ANALYTICS SOLUTIONS, Inc – Sr. Data/ETL Architect/Integrator Consultant May 2015 to Present. ACE – Defense Commissary Agency (DeCA) with Secret, Fort Lee, VA Oct 2021 - Present LMI, Inc.

Informatica Architect SME/Data Architect responsible for Design, Implementation, Enhancement of Data Warehouse, and ETL mappings and workflows.

Hands on implementation of data ingestion, data modeling, PL/SQL, through data consumption.

Utilized Informatica cloud to migrate on premise data to Azure Cloud Sqlserver database.

Performed process improvement and create jobs automation for data ingestion and delivery.

Streamlined and converted all the existing manual processes using automation job scheduler.

Lead Data Warehouse/ETL Enterprise Architect responsible for Design, Implementation, Enhancement Data Vault 2.0 Data Warehouse, and ETL mappings and workflows on SQL server database.

Implemented and created Power BI reports and dashboard for business users.

Mentor and Coach other Data and ETL Architects on Data Vault 2.0 implementation methodology.

Utilized Erwin tool for Data Vault 2.0 modeling and implementation.

Designed and implemented automate processes using Unix Shell Scripting to execute SQL, PL/SQL scripts.

Implemented Informatica incremental load for data cleansing and transformation to Salesforce.

Utilized PowerBI to create dashboard graphical reports for management.

Utilized GitLab extensively for DevOps continuing software integration and configuration management.

Utilized GitHub DevOps for continuing integration of software changes.

Utilized PowerBI to present graphical DeCA stores daily and monthly sales. ACE – Defense Contract Management Agency TA (DCMA) with Secret, Fort Lee, VA Oct 2020 – Oct 2021 Oran, Inc -- HHSN316201200124W-10/22/2020

Informatica Architect SME/Data Architect responsible for Design, Implementation, Enhancement of Data Warehouse, and ETL mappings and workflows.

Hands on implementation of data ingestion, data modeling, PL/SQL, through data consumption.

Established Data Governance process with government client and initiated database table to store metadata.