We provide IT Staff Augmentation Services!

Technical Manager Resume Profile

PROFESSIONAL SUMMARY

  • More than 20 years of broad-based business consulting experience.
  • Capabilities include conceptualization and development of business technology solution architectures, across a wide variety of disciplines, including Data Warehousing, Business Intelligence, Master Data Management, Data Governance, Enterprise Data Integration Architectures and Portals including J2EE development.
  • Extensive program and project management experiences with industry knowledge in Pharmaceutical, Healthcare, Logistics, Mortgage Service, CRM, Sales Force Automation, Retail, Banking and Telecom.
  • Experience includes working knowledge of many business functional areas, and the integration of technology and business strategies, to achieve ROI-driven solutions.
  • Provided professional services to several public sector organizations, including the Department of Homeland Security, of Department of Transportation, the Department of Defense, and Department of Energy.

TECHNICAL SKILLS

  • Applications / Modules: Oracle Application Server Pages,
  • Databases: Oracle 8i, 9i, 10g, 11g, Teradata, BD2, SQL Server, Sybase 9, 10, 11
  • Languages: SQL, HTML, Java, C
  • Methodologies: Rational Unified Process RUP/UML , Zachman Framework, Inmon DW , Kimball DW , Bachman, Software Development Life Cycle SDLC , Waterfall, Information Engineering, Finkelstein, Object Oriented, IDEF, Yourdon and Demarko Structured Analysis
  • Operating Systems: MS Windows, UNIX
  • Software: Microsoft Office Suite, including MS Project, XML, Oracle Business Intelligence Enterprise Edition, Informatica Power Center/Exchange, 6,7, 8, Oracle Enterprise One, Oracle 9i Application Server Suite , CA All Fusion, Popkin System Architect. Rational Clear Case, Rational Rose, Oracle Warehouse Builder, ETI Extract, Informatica Power Center/Mart , Ardent DataStage, Cognos, Powerplay, MicroStrategy, ActaWorks, Ab Initio GDE, Sagent, Cognos Framework, Business Objects, Hyperion-Brio, SAP, Erwin/Model Mart, Data Cruncher, Net Commerce, Multi Load/Fast Load, Web Sphere, MQ Series, Designer 2000, Cool Gen, ADW, Power Designer, Red Brick, Popkin, ARC GIS Geospatial

PROFESSIONAL EXPERIENCE

Confidential

Technical Manager

Technical Manager allocated to the Business Intelligence practice.

  • Managed a team of data architects and ETL developers to analyze source data that will be aligned to existing EDW operational data store.
  • Performed requirements gathering and system analysis, data analysis, data mapping, logical data modeling, functional design, discover data anomalies, and recommend/implement data quality transformations.
  • Extensive knowledge and experience in understanding logical mapping and data model to build Physical Design characteristics.
  • Once the data is analyzed and system of record is determined, it is moved to staging database via ETL mappings and workflows.
  • Created Integrated Data Dictionary and Master Data structures, utilizing Informatica MDM and IDD tools.
  • Recommended ETL strategy identified load frequency and designed /developed ETL mappings and workflows.
  • The long range goal is to build independent and dependent data marts.
  • The data marts were multi-dimensional data structures that were star schema, snowflake or galaxies.
  • The data marts were built as Type 2 slowly changing dimensions that were also conformed for the organization.
  • Tools utilized included Erwin, Informatica 9.5, INFA MDM and IDD, OBIEE, and Agile Scrum with SELC methodology deliverable documentation.

Confidential

Business Intelligence Practitioner

Technical Lead for the creation of the Investigator Data Warehouse and Master Data Management Solution.

  • Performed requirements gathering and system analysis, data analysis, data mapping, logical data modeling, functional design, discover data anomalies, and recommend/implement data quality transformations.
  • The first task was the creation Naming and Security Standards document to establish guideline for creation of business intelligence solution artifacts.
  • Created an ETL Framework to establish technical guidelines for creation of the data warehouse/business intelligence solution.
  • Upon completion of ETL Design Framework and design documents, created with corresponding Source to Target Mappings for Source to Staging, Staging to Master Data Management MDM , Staging to Data Warehouse, and ETL Mapping and Integrated Data Dictionary.
  • Additionally a Sales Force Automation solution was developed to automate the business tasks of sales, including order processing, contact management, information sharing, inventory monitoring and control, order tracking, customer management, sales forecast analysis.
  • Tools utilized to performs these tasks included Informatica Power Center 8.6, Business Objects, MicroStrategy, Microsoft BI, TIBCO-CIM, and Oracle 11g. Methodologies included Agile Scrum.

Confidential

Senior Architectural Specialist

  • U.S Department of Homeland Security DHS , US Citizenship and Immigration USCIS , Information Technology Sustainment and Security Remediation ITSSR , Enterprise Citizenship and Immigration Services Centralized Operational Repository eCISCOR .
  • Lead for Data Population Team which is responsible for the extraction, transformation and load ETL for source systems data. The tool utilized to performs these tasks, Informatica Power Center 8.6.
  • Task with performing Change Data Capture of data updates capture database logs and mainframe database journal, the tool used to perform these tasks, Informatica Power Exchange.
  • Built an Operation Data Store ODS , Enterprise Data Warehouse, and independent Data Marts.
  • Created dashboard and reports with Microstrategy BI tool and OBIEE.

Confidential

Project Manager

Project manager for Data Warehousing/Data Quality initiative for Otsuka Pharmaceuticals R D .

  • Responsible for performing data quality audits Trillium , update/maintenance of the Enterprise Data Architecture Model logical , and the development of data mart/data warehouse.
  • Duties include design/architecture of logical/physical Operational Data Store ODS , Multidimensional data structures, design and development of ETL mappings for data transformation/load and development of BI front-end and SAS reports.
  • Tools used to develop logical/physical Data models Erwin Model Mart. Responsible for completing data quality audits utilizing Trillium. Oracle 10g, Oracle Warehouse Builder, Cognos Framework

Confidential

Principal

Principal Consultant/Data Architect, Air Force Integrated Logistics Support System, Supply Chain Management . Assisted in componentized, e-development and data warehousing initiative data mart , utilizing an iterative approach to the Rational Unified Process RUP/UML and Open Application Group OAGIS XML Business Object Documents BODS .

  • Participated in the design of a geospatial data mart for the Environmental Protection Agency.
  • Responsible for the creation of relational logical and physical and object relational multidimensional database structures data models .
  • Responsible for correct application of data types, domain, validation, and valid values reference tables .
  • In the creation of these structure the techniques of data normalization 3NF , forward/reverse engineering, and data standardization were utilized.
  • The approach used in the development of the data marts included determination of user requirements including hardware/software, full scope of business intelligence needs, determination of solution required.
  • The logical e-development framework was built with WebSphere as the web server with Broad Vision gateway, Broad Vision Enterprise 6.0 Portal Interaction manager, and Oracle 9iAS as the database, and IBM WebShphere Application Server.
  • Technologies utilized include Erwin Model Mart, DB2, SAS BI, Informatica Power Center, Business Objects, Oracle 9iAS Web Builder , Enterprise Java Beans, J2EE and XML.

Confidential

Principal

Principal, Data Warehouse data mart Manager/Lead Data Architect for Pharmacia, Data Services, Center of Excellence, as a Data Warehouse Architect/Project Manager.

  • Business Intelligence experts for the Center of Excellence, team established the Pharmacia Data Warehousing Methodology and prepared the Business Case data warehouse assessment documentation for Consumer Healthcare, Research and Development, and Clinical Trials Division s .
  • The assessment s began by conducting interviews with executive level management president/vice presidents to ascertain business visions, goals, and objectives and sponsorship.
  • These findings we used to develop and an executive background, understand business risks, benefits analysis, business readiness and determine scope of entire data warehouse initiative, and gave insight into key bottlenecks of management reporting process, which is a key element in business intelligence.
  • In the technology phase we interviewed business analyst and IT staff to determine Data Analysis Requirements, which is the basis for constructing logical/physical Operational Data Store data models , Multidimensional design, and doing data source mapping/analysis.
  • ETL Tool is Infomatica Power Center, Modeling tool ERWIN Model Mart, Oracle 8I database and MicroStrategy BI tool. Data sources SAP, Microsoft SQL Server, DB2, Sybase, and Informix.

Confidential

Project Manager

Project Manager on contract to Banco de Credito del Peru South America .

  • Responsible for the development of Customer Relationship Management data warehouse/data mart, within Marketing Management section of bank.
  • The Information Technology architecture consisted of Host/Source data Mainframe and SQL Server that was transformed/loaded Sagent Data Mart into and Operational Data Store Teradata and MultiLoad .
  • A multidimensional DBMS snow-flakes and galaxies on Teradata is then accessed via and OLAP Micro Strategy .
  • As an added dimension to project knowledge discovery development was deployed Data Mining DataCrucher to increase marketing, segmentation, and campaign management.
  • Technical lead, on contract to design an Electronic Commerce website.
  • Hosting DMZ is IBS RS 6000 with AIX designed logical and physical data models with Erwin for an Oracle 8 database.
  • The Application Component was Net Commerce and Application Server WebSphere with MQ Series Middle

Confidential

Project Manager

Technical Manager, This position required both technical and managerial responsibilities.

  • Lead team of data warehouse architects in the creation/modification of logical/ physical database designs and data warehouse data mart database designs determining user requirements, utilizing star schema methodology, to develop facts, dimensions and hierarchies in a multidimensional database structure .
  • Client base included Defense Finance Accounting Service DFAS , Campbell's Soup International, and Vlasic Foods International.
  • Tools utilized include Oracle Designer 2000/Data Mart Suite/Discover, SAS, Erwin Model Mart, Business Objects, and various other modeling and ETL Extract/Transfer/Load tools.

Confidential

Consultant, Data Administrator/Modeler

Data Administrator/Modeler, assigned to Freddie Mac, Servicer Division.

  • This project dealt with inception through deployment phases of database application design data mart and maintenance within the Mortgage Servicing division.
  • Duties consist of but are not limited to creation of logical and physical data models, creation/modification of physical databases, performance tuning, and optimization of physical database.
  • The database software used in this project is Sybase 10 and the CASE tool s : Sterling Software Application Development Workshop ADW object-oriented development and ERWIN 2.5 SQL Windows.
  • The application GUI uses SQL GUPTA Windows.
  • Operations partitioned with both Windows and OS2 WARP.
  • Methodology used in the creation of applications: Object Oriented

Confidential

Consultant/Database Administrator

  • Database Administrator for joint venture between the Bank of Mexico and MCI in creating a Call Center utilized within new long distance Phone Company Avantel .
  • The project specifically dealt with the construction of the Call Center's logical and physical database structures. The database software used in this project is Oracle 7, with a DEC Alpha 8200 as the server hardware with UNIX and WINDOWS NT.
  • Duties included creation of logical and physical database structures for cross-functional applications utilized within Call Center's individual applications, Marketing/Sales, Customer Service, and Order Entry .
  • Performance tuning and database cleanup Oracle 7 for a Time Life Call Center.
  • Tools utilized included ERWIN, SQL Navigator, and Oracle Designer 2000.

Confidential

Program Manager

  • Program Manager and member of the BDM Enterprise Integration Team, responsible for the execution of Data Mapping/Conversion, Data Standardization and Data Modeling tasks.
  • Provided technical leadership in the analysis of enterprise legacy and migration information systems, mapping of legacy information to migration systems, creation of data logical and physical and activity models, database design analysis data mart , performance metrics, test analysis, requirements analysis and strategic planning.
  • Assisted in the performance of server administration Environment: DEC ALPHA UNIX of Oracle and IEF Composer software WINDOWS NT and OS/2 .
  • Tools utilized in these efforts included Designer 2000 Modeling/Diagramming and Design Wizards , Texas Instruments IEF COMPOSER 5.3 and ENCYCLOPEDIA, Oracle 7 Client Server . Certified IEF Composer Analyst .

Confidential

Technical Lead

  • Project Manager for Special Operations Low Intensity Conflicts SOLIC effort in support of the Office of the Secretary of Defense and for the Personnel Readiness project for the Joint Chief of Staff's Office of Personnel and Readiness.
  • Involved in proposal development, including cost and schedule development, and skill mix/resources determination, requirements analysis, database analysis and design and test plan analysis and design.
  • Oversaw the execution of all tasks within these projects, was responsible for budgets and schedules, staffing, all deliverables, and customer interaction.
  • Provided technical leadership in the analysis of enterprise functional processes, performance measurement, and workflow analysis, analysis/creation of activity and data models, requirement analysis and strategic planning.
  • Tools utilized in the creation of models included DESIGN IDEF, ERWIN 2.0 Client Server , VENTANA GROUPWARE, CASEWISE, IDEFINE, Texas Instrument IEF Version 5.2, DB2, and ORACLE CASE

Confidential

Consultant

  • Project Technical leader of data modelers and technographers in support of the US Army's Installation Transportation Office.
  • Led the team in the analysis/creation of business process models, data models, data standardization practices and business process improvements.
  • Responsible for project schedule and, budgeting, staffing, technical leadership, and for facilitating the effort with the customer.
  • Task Manager in support of a similar project for the Joint Battlefield Logistics Office, US Army, responsible for managing tasks within the team's assigned schedule and budget and for providing the technical leadership.
  • Engineering projects relied on the creation of logical and physical data model and facilitated workshops.
  • Tools used to create models and documentation included DESIGN/IDEF, ERWIN/ERX, LEVERAGE, IDEFINE, MODEL PRO, and WIZDOM.
  • Created Structured Methodology Language SML formats of data models, which were translated into Business Design Facility Texas Instruments IDEF methodology tool .

Confidential

Senior Technical Staff

  • Senior Technical Staff Member held position of Technical Lead for SETA in support of a number of different projects and customers.
  • Task manager in support of the Defense Information Systems Agency on two projects as part of the proposal development team.
  • Responsible for managing team's assigned budget and schedule, for the staffing, and provided the team its technical leadership: Defense Data Repository System DDRS supported DDRS development from inception to deployment.
  • As task leader of World Wide On-line System WWOLS similar management responsibilities were performed.
  • Created Entity Relationship, Key Based, and Fully Attributed data models using Finkelstein and James Martin data modeling methodologies , IE-Advantage CASE Tool and DESIGN/IDEF.
  • Both assignments were completed on schedule and within budget.

Confidential

Consultant

  • Led a team that enhanced the Mortgage-Backed Securities Systems MBS portion of the Fannie Mae Information Systems Structure.
  • Responsible for the task budget and schedule, and the technical lead.
  • Team developed the application on a Data General and IBM 3090 under MVS/XA using IDMS with ADSO/ADSA.
  • The system was developed using ADSG, OLM, DME, IDD, OLQ, CULPRIT, DMLO DB/TRACE under BACHMAN methodology.
  • Prepared Functional/Technical requirements and documents.
  • Modified existing programs that were written for a PC-based database, which was being converted, to ORACLE.

Hire Now