We provide IT Staff Augmentation Services!

Data Warehouse Architect/ Project Lead Resume

Columbus, OH

SUMMARY

  • More than sixteen years of analysis and software development experience as a business intelligence and data warehouse (BIDW) technical consultant and architect.
  • Experienced in business analysis, design and requirement gathering.
  • Experienced in identification of tasks, time estimation, cost estimation, project planning, project co - ordination and status reporting.
  • Analyzed source data for potential data quality issues and addressed these issues in ETL procedures.
  • Developed technical design documents and mappings specifications to ETL adhering to the business rules.
  • Provided support for existing systems and worked on new development initiatives simultaneously.
  • Actively participated in design and analysis sessions to ensure sound team decision-making.
  • Supported system and user acceptance testing activities, including issue resolutions.
  • Completed technical documentation to ensure the system was fully documented.
  • Strong communication skills (both oral and written) and the ability to work effectively in a team environment as required.
  • Strong exposure to legacy data mapping from source to target, data conversion and data cleansing using cleansing transformation rules.
  • Hands on experience in designing the data models such as star and snowflake schemas using Erwin as a tool.
  • Special emphasis on the administration, support and performance tuning of the ETL, OLAP and the overall architecture flow of the sources, transformations, targets and the data warehouse.
  • Developed UNIX scripts for scheduling the ETL jobs. Involved in the creation of Autosys jobs.
  • Designed, developed, tests and implemented andtroubleshoot ETL mappingsand workflows in a large data warehouse environment.
  • Developed logical and physical data model for the data warehouse projects.
  • Experience in identification of tasks, estimations, project planning, project co-ordination and status reporting.
  • Experienced in developing test plans, test cases and executed test scripts.

TECHNICAL SKILLS

Development Technologies: Informatica Power center 9.1/8.x/7.x/6.x, UNIX Shell Script, (BTEQ, Fast Load, Multiload), Oracle PL/SQL

Case Tools: Erwin 8/ R7/ 4.x / 3.x

Tools: TOAD, SQL*Navigator, Oracle Enterprise Manager, Autosys, MS Office, MS Projects, MS Visio, HPQC, Microsoft Visio, Lotus Notes, Microsoft Outlook.

Operating Systems: Windows XP/2000/NT, UNIX (Solaris, AIX), LINUX (SUSE, Redhat)

Databases: Oracle, SQL Server 2008/2005, Teradata (V2R5, V2R6, V12, DB2 UDB, MYSQL, XML, Netezza

Reporting Tools: Cognos, Business Objects, Micro strategy

Systems: SAP R3 (ECC 6.0/4.6c), SAP BW, PeopleSoft, Callidus.

Configuration Management: PVCS, Clear case, SharePoint.

PROFESSIONAL EXPERIENCE

Data Warehouse Architect/ Project Lead

Confidential

Responsibilities:

  • Design an information strategy that maximizes the value of data as an enterprise asset
  • Maintain logical/physical data models. Coordinate the metadata associated with the application
  • Develop technical design documents. Develop and communicate data standards
  • Maintain Data Quality metrics. Plan architectures and infrastructures in support of data management processes and procedures
  • Support the build out of the Data Warehouse, Data Marts and operational data store
  • Effectively communicate with other technology and product team members
  • Qualifications/Certifications
  • Under data integration concepts, multiple data architectures that can support a Data Warehouse
  • Translate functionalrequirementsinto technical design specifications
  • Develop technical design documents. Optimizing data loads and data transformations
  • Translate client user requirements into technical architecture vision and implementation plan
  • Design and develop the architecture for all data warehousing components (e.g. tool integration strategy; source system data
  • ETL strategy, data staging, movement and aggregation; information and analytics delivery; and data quality strategy)
  • Design of the data warehouse data storage strategy/technique (ODS, EDW, DM, ROLAP, MOLAP, etc.)
  • Design of data warehouse sub-system (e.g. QA/QC, ETL and Query metrics)
  • Oversight of tool evaluation and selection Hardware recommendations, sizing and configuration RDBMS installation, configuration and tuning Oversight and/or coordination of system testing phase Problem and issue resolution
  • Mentoring and developing junior staff Participation in proposal development and client presentations

Environment: IBM Infosphere DataStage v8.x, Informatica Power Center RT 9.0.1/ 8.6.1 , Informatica Developer (Data Profile), TOAD (Data Modeler, Oracle), Microsoft Office 2007, Microsoft Projects 2003, Microsoft Visio 2007, Teradata 12, Cognos, SharePoint, Autosys, SAP ECC 6 / 4.6, Oracle 11G/10g, PL/SQL, HP Unix, F-Secure SSH Client, MS Windows, Relay, SAP BW, TOAD 9, HP Quality Center, SQL Server 2012/2008/2005 , Seibel, UNIX, Netezza, DQ Analyzer, TOAD Data Modeler 4.2, Mainframe (JES 3), CICS, VSAM dataset files, Big Data (1010 Data)

Project Manager / Solution Architect

Confidential, Columbus, OH

Responsibilities:

  • Leadthe technical architecture and design for a new Data Warehouse.
  • Interact with the project team members responsible for developing reports, interfaces, data conversion programs, and application extensions.
  • Oversee activities for all assigned projects from planning to delivery and sustaining support to ensure that projects meet established business objectives, time and budget constraints.
  • Provide scoping and estimating on Data Warehouse activities
  • Present technical information in easily understood terms in both verbal and written form
  • Work closely with fellow IT staff and project management to document standards and procedures for the definition of reference architectures (architecture roadmap)
  • Interact and work directly with customer team members on projects and support issues.
  • Facilitate communication upward and across project teams
  • Follow change management and problem management processes.

Environment: Clarity, Erwin R7, Informatica Power Center 8.1, Clear Case, Microsoft Projects 2003, Microsoft Visio 2003, Microsoft Office 2003, SQL*Plus, TOAD, Linux, Unix(Sun Solaris), MS Windows, Teradata V2R6, Oracle 10g, Micro strategy, Oracle 10g, PL/SQL.

Project Lead / Data Warehouse Architect

Confidential, Brooklyn, NY

Responsibilities:

  • Participate in requirements definition, analysis and the design of database solutions
  • Map business requirements to logical and physical data models
  • Reverse engineer source system data structures
  • Collaborate with Data Architects for data model management and version control
  • Conduct data model reviews with project team members
  • Capture technical metadata through data modeling tools. Create data objects (DDL)
  • Enforce standards and best practices around data modeling efforts
  • Ensure data warehouse and data mart designs efficiently support BI and end user Requirements
  • Collaborate with BI teams to create reporting data structures
  • Collaborate with ETL teams to create data landing and staging structures
  • Collaborate with application and services teams to design databases which fully meet business and technical requirements
  • Maintain expertise and proficiency in the various application areas
  • Develop a thorough knowledge and understanding of cross system interactions and relationships in order to develop an enterprise view

Environment: Oracle 10g/9i, PL/SQL, SQL*Loader, Informatica Power Center RT6.2, Business Objects XIR2, Erwin 4.x, PL*SQL, SQL*Server 2000, TOAD, Microsoft Project 2000, Visual Source Safe, Rational Clear Case, UNIX Sun Solaris, MS Windows, Excel

Business Analyst / Project Lead

Confidential

Responsibilities:

  • InformaticaAdministrationincluding Installation, upgrades, Configuration, maintenance and troubleshooting.
  • Review database design and setup to ensure that new or modified data bases meet acceptable database standards. Proactively monitor databases and provide feedback to application teamson performance. Mentors other team members on technology and processes.

Environment: Oracle9i/8i, Oracle Tools (Export, Import, SQL*Loader, PL/SQL, RMAN), UNIX (HP, AIX), Informatica Power Center RT6.2, Business Object 6.5, Microsoft Word, Excel, PowerPoint, TOAD, SQL*Navigator, Oracle Enterprise Manager, PeopleSoft, Oracle Warehouse Builder, SQL Server 2000.

Hire Now