We provide IT Staff Augmentation Services!

Dw Bi Architect / Etl Lead Resume

SUMMARY:

  • DW BI ETL Architect/Developer having 10+ years of IT experience specialized in Data Warehousing, Data integration, Business Intelligence, Master Data management, Data Migration, Data Governance, Data Modeling, Project Management, Estimations and Proposals.
  • Extensive experience in full life cycle of software development process, requirement definition, analysis, designing, modeling, coding, testing, implementation, and maintenance.
  • Executed projects for aerospace, retail banking, investment banking, retail & energy domain.
  • Expertise in requirement gathering, analysis, conceptual, logical and physical data modeling and implementation of data mart, data warehousing & BI solutions.
  • Expertise in solving complex data integration problems.
  • Experience in effort estimation, proposal and presentation creation.
  • Expertise in implementing complex business rules by creating robust mappings, mapplets, reusable transformations, sessions, worklet and workflows using Informatica Power Center.
  • Expertise in installation, configuration and upgrade of Informatica 9.x/8.x.
  • Expertise in fine tuning the mapping and sessions by identifying the bottlenecks to improve the performance, well versed in data integration and data migration among Oracle, MS SQL Server, DB2, UDB, Informix and MS Access.
  • Worked as Cognos administrator & experience on usage of Cognos Framework Manager, Report Studio, Query Studio and Cognos Connection.
  • Experienced in UNIX shell scripting and using pmcmd commands to create schedule.
  • Familiarity with big data solutions such as Hadoop.
  • Led DWH engagement initiatives from envisioning, setting up and actively maintaining Road Map for Data Integration and ETL CoE.
  • Established Data Governance framework for clients.
  • My technical abilities are complemented by excellent written and verbal communication and user interaction abilities.
  • Excellent inter - personal and leadership skill, with the ability to adapt quickly to new and challenging environments.
  • Contribute to internal projects, develop and document ETL best practices, taught Informatica classes internally, run the internal Informatica User Group and act as a liaison to Informatica Corporation.
  • Provide input and guidance into the staffing process, interview prospective employees, mentor consultants.
  • Experience in leading and managing teams, handled multiple roles as Project manager, DW BI Architect, ETL Architect, Technical lead, Module lead.

TECHNICAL SKILLS:

Data Modeling: IBM InfoSphere Data Architect 8.1.1, ERWIN 7.0

ETL Tools: Informatica 9.x/8.6/8.1, Data stage v8, SSIS for SQL server 2005

BI reporting: Cognos 10.1/8.4, OBIEE 10.1.3, Business Objects XI R2, Hyperion 9

Database: Oracle 11g/10g/9i, DB2 8, SQL Server-2000, Informix, IDMS/R, Sybase

Languages: SQL, PL/SQL, UNIX Shell Script, COBOL, JCL, CICS, ASP, VB Script

Tools: TOAD 10, Visio 2003, Microsoft project 2003, Clear case

Packaged Software: PeopleSoft GL, Confidential Serv, DBS

Mainframe Utilities: Vsam, Xpeditor, AFP, Eztrieve, Endevor, File-aid, Rexx, Queryman

Scheduler: Autosys, Expresso, CA7

PROFESSIONAL EXPERIENCE:

DW BI Architect / ETL Lead

Confidential

Technology: Informatica PowerCenter 9.1, UNIX, Oracle 11g, Cognos 10

Responsibilities:

  • Leading and managing data warehousing application team.
  • Worked closely with business analysts to gather requirements.
  • Conceptual, logical and physical data modeling.
  • Solution design and estimations.
  • Solve complex data integration problems.
  • Worked on applying data & file retention policy.
  • Involved in data migration from legacy systems.
  • Involved in deciding partitioning & Index strategy for big tables.
  • Review code and ensure standards & best practices are followed.
  • Bug-fixes and release into production.
  • Performance tuning of Informatica mappings and back-end objects to ensure productivity.
  • Installation, configuration and upgrade of Informatica.
  • Deployment of ETL code to Integration, QA and PROD environment.
  • Manage Informatica services, locks, connection & logs from Admin console.
  • Maintain Informatica level security (Users, groups, folder permissions).
  • Conduct reviews for critical projects and provide strategy during project initiation.
  • Provided training to new team members and the processes to be followed in the project.

Confidential

DW BI Architect / Technical Lead

Technology: Informatica PowerCenter 8.1.5, UNIX, Oracle 10g, Expresso

Responsibilities:

  • Leading and managing data warehousing application teams.
  • Analyzing the business requirements and converting them into Technical documents.
  • Solution design and estimations.
  • Review code and ensure standards & best practices are followed.
  • Bug-fixes and releasing into production.
  • Performance tuning of Informatica mappings and back-end objects to ensure productivity.
  • Informatica Administrator
  • Provided training to new team members and the processes to be followed in the project.

DW BI Architect / IT Architect

Confidential

Technology: Informatica PowerCenter 8.1.5, UNIX, Oracle 10g, Cognos 8.4, Expresso

Responsibilities:

  • Leading and managing data warehousing application teams.
  • Analyzing the business requirements and converting them into Technical documents.
  • Solution design and estimations.
  • Designing and developing mapping, mapplets, session, other tasks, worklet and workflow.
  • Review code and ensure standards & best practices are followed.
  • Bug-fixes and releasing into production.
  • Performance tuning of Informatica mappings and back-end objects to ensure productivity.
  • Informatica Administrator
  • UNIX shell script creation & scheduling
  • Providing production support from offshore for the nightly batch jobs.
  • Cognos administrator
  • Trouble shooting of Cognos job failures.
  • Deployment of Cognos report packages in various regions such as Development, SIT, QA and Production.
  • Provided training to new team members and the processes to be followed in the project.

Team lead/Module Lead

Confidential

Technology: PowerCenter 8.1.5, UNIX, Oracle 10g, Siebal Analytics, ER win 7.0

Responsibilities:

  • Analyzing the business requirements and converting them into Technical documents.
  • Dimensional modeling
  • Designing and developing mapping, mapplets, session, other tasks, worklet and workflow.
  • Preparation of unit test case document.
  • Review code, ensure standards are followed and recommend for better performance.
  • Deployment of ETL code to Integration, QA and PROD environment.
  • Creation of Repository from Admin console
  • Maintaining Informatica security (Users, groups, folder permissions).
  • Backup and restore of repository
  • Informatica Administrator
  • UNIX shell script creation & scheduling
  • Development project estimates

Team Lead/Module Lead

Confidential

Technology: Informatica 7, UNIX, Business Objects, Oracle9i, SQL Server 2000

Responsibilities:

  • Analyzing the business requirements and converting them into Technical documents.
  • Dimensional modeling
  • Designing and developing mapping, mapplets, session, other tasks, worklet and workflow.
  • Preparation of unit test case document.
  • Review code, ensure standards are followed and recommend for better performance.
  • Deployment of ETL code to Integration, QA and PROD environment.
  • Maintaining Informatica security (Users, groups, folder permissions).
  • Backup and restore of repository
  • UNIX shell script creation & scheduling
  • Development project estimates

Analyst

Confidential

Technology: Informatica PowerCenter 8, LINUX, UDB 8, Hyperion

Responsibilities:

  • Analyzing the business requirements and converting them into Technical documents.
  • Dimensional modeling
  • Designing and developing mapping, mapplets, session, other tasks, worklet and workflow.
  • Preparation of unit test case document.
  • Review code, insure standards are followed and recommend for better performance.
  • Deployment of ETL code to Integration, QA and PROD environment.
  • Maintaining Informatica security (Users, groups, folder permissions).
  • Backup and restore of repository
  • UNIX shell script creation & scheduling

Team Member/ Associate Consultant

Confidential

Technology: COBOL, DB2, CICS, JCL, SAS, VSAM, XPEDITOR, FILE-AID, REXX

Responsibilities:

  • Technical Specifications creation, Impact analysis, coding, Test Case preparation, unit testing, and QC review of new Online & Batch programs.

Team Member/ Associate Consultant

Confidential

Technology: COBOL, CICS, DB2, JCL, VSAM, XPEDITOR, FILE-AID, REXX

Responsibilities:

  • Technical Specifications creation, Impact analysis, coding, Test Case preparation, unit testing, and QC review of new Online & Batch programs.

Team Member/Software Engineer

Confidential

Technology: COBOL, IDMS, ADSO, JCL VSAM, AFP, XPEDITOR, FILE-AID, REXX

Responsibilities:

  • Analysis, coding, unit testing, QC review and integration testing of the change requests / enhancements.
  • Providing production support from offshore for the nightly batch jobs.

Team Member/Software Engineer

Confidential

Technology: COBOL, IDMS, ADSO, JCL, VSAM, FILE-AID, REXX, CA-7.

Responsibilities:

  • Analysis, coding, unit testing, QC review and integration testing of the change requests /enhancements.
  • Providing production support from offshore for the nightly batch jobs.

Hire Now