We provide IT Staff Augmentation Services!

Etl Architect Resume

SUMMARY:

  • 10+ years of strong Data Warehousing experience using Informatica PowerCenter 9.0/8.1.1/7.1/7.0/5.1.1/1.6/1.5 , Informatica Power Analyzer, Ascential DataStage 7.0/ 6.0/5.2/5.1/4.2/3.6 (Manager, Designer, Administrator, Director), Orchestrate, Integrity, MetaRecon, Informatica Power mart 5.1.1/5.x/4.7/3.8, Transformations, ETI, ETL, MS Excel, OLTP
  • 10+ years of strong Business Intelligence experience in OLAP using various reporting tools like OBIEE,Business Objects, Cognos7.0/6.6, Data Reports, Seagate Crystal Enterprise, Seagate Crystal Reports 8.0/7.x/6.x and SQR 3.0.
  • 11 years of professional experience in IT Industry including around 8 and half years of expertise in Design, Development and Implementation of state of the art Data Warehouse Applications.
  • Strong background working with clients, designers, and programmers to identify requirements, provide cost analysis, assist with creating user interfaces, and develop implementation timelines. In - depth understanding of project life cycle, including all phases of system and software development.
  • Experienced in Business Analysis, Source system analysis, Architectural Reviews, Data Modeling, Data validation, Data testing, Resolution of data discrepancies.
  • 7+ years of Data Modeling experience using Dimensional Data Modeling, Star Join Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, ERWin3.x, Oracle Designer. Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
  • 10+ years of high-end programming experience using SQL, PL/SQL, ANSI SQL, Transact SQL, SQL*Plus, SQL*Loader, Very Strong Unix Shell Programming/Scripting, Visual Basic 4.0/5.0/6.0, Developer 2000, C, HTML 4.0, DHTML, XML, Windows 3.x/95/98/2000, Win NT 4.0, Sun Solaris8, HP-UX and AIX 4.3

SKILL:

Data Warehousing: Informatica PowerCenter 9.0/8.1.1/7.1/7.0/5.1.1/5.0/1.7 (Designer, Server Manager, Repository Manager), Informatica PowerMart 5.1.1/5.0/4.7 , Power Connect, ETL,AscentialDataStage 6.0/5.2/5.1/4.2/3.6 (Designer, Director, manager, Administrator), Orchestrate, Integrity, MetaRecon, Data Mining, Datamart, Metadata, OLAP, OLTP, SQL*Plus

Business Intelligence: OBIEE 11g, Business Objects XI, Cognos 7.0/6.6/5.0, Actuate 9.0

Databases: Oracle 10g/9i/8i/8.0/7.0, Sybase Server 11.x/12.0, MS SQL Server 6.5/7.0/2000 , DB2 UDB, MS Access 7.0/ 97/2000, Teradata 6.2.

Tools: Erwin 4.1/3.5, Data Reports, Seagate Crystal Reports 6.x/5.x/4.x/3.x, Toad, SQL*Loader, Developer 2000 (Forms 4.5/5.0, Reports 2.5/3.0), MS Access Reports

Programming: SQL, PL/SQL, ANSI SQL, Transact SQL, SQL*Plus 3.3/8.0, Visual Basic 6.0/5.0, ASP, Java, JSP, C, C++, Unix Shell Scripting, Dbase III

Others: HTML 4.0, ASP 3.0/2.0, JSP, CGI, PERL, JavaScript, DHTML, MS Excel, MS Office, MS-Project.

Environment: Sun Solaris 2.6/2.7/2.8, HP-UX, IBM AIX 4.2/4.3, MS DOS 6.22, Win 3.x/95/98/2000, Win NT 4.0, SCO Unix.

PROFESSIONAL EXPERIENCE:

Confidential

ETL Architect

Responsibilities:

  • Cross-functional role that combined software, data and business architect responsibilities focused on integration projects and business intelligence/data warehousing projects. Provided technical leadership to enterprise wide projects affecting external customers and end users, internal customers and partners (300,000+ end users in 10,000 companies, 10+ large partners - major wireless carriers and VAR’s in US and Europe).
  • Evangelized, designed and implemented architecture that directed streams of data from main data sources (NOC, customer facing portal, multiple ordering systems, and partner integration services) into central data repository that represents complete business model of the enterprise. This approach has drastically reduced LOE and complexity of cross-systems projects and most of the operational reporting and created launch-pad for data warehousing projects.
  • Designed new data architecture for partner integration services, which consisted of unified core and customizable integration modules. This approach significantly streamlined and improved quality of partner billing and reduced LOE and complexity of partner on-boarding implementations.
  • Defined roadmaps, project plans and steps to implement data and DSS architectures.
  • Worked with business users and SME's to best determine approaches to satisfy user requirements, gaps and risks.
  • Developed prototype solutions to verify capabilities for new systems development, enhancement, and maintenance of decision support.
  • Created complex mappings using Informatica to load data.
  • Created Pipeline partitioning to improve Session performance
  • Designed and implemented audit balance and control
  • Scheduled workflows and sessions to schedule the loads at required frequency using workflow manager. Generated completion messages and status reports using session.
  • Provided technical solution to support product enhancement, operational, billing and management reporting needs for a mobile user community across 40 carriers (operators) who uses several mobile application solutions like email, social networking, IM etc…
  • Designed and implemented a data warehouse and business intelligence reporting solution which is integrated with Carrier partners.
  • System is designed to handle high volume data processing, 40 - 100 million records daily.
  • Maintained and Administered Business Objects Reporting Environment.
  • Extensively created reports and deployed as per Carrier requirements using Infoview and BO designer.
  • Data captured from heterogeneous systems including log files.
  • Implemented database partitioning, dbms job routines, analytical queries and parallel queries to improve the performance of the existing backend processes.
  • Improved the performance of the database queries using Explain Plan, TKPROF.

Environment: Oracle 11g/10g/9i, Oracle Applications ERP, Erwin, Informatica 9.01 ,OBIEE 11g, PL/SQL, SQL*Loader , Business Objects XI R2, Perforce, Python, Perl, Actuate 9.2, UNIX, Toad, XML Spy, Windows XP Professional, Windows 2003 Server, Web Services.

Confidential, CA

ETL Consultant/Systems Analyst

Responsibilities:

  • Extensively involved in System Study & Business Requirements Analysis required for data warehouse planning phase and the creation of deliverables required to develop a comprehensive alternative analysis and cost benefit analysis for an enterprise data warehouse.
  • Worked with business and data analysts, developers, database administrators and requirements analysts to translate business requirements into technical requirements.
  • Responsible for preparation and/or review of any technical designs and/or documents
  • Advised other groups in the organization on data warehouse development and conducted ETL (code/documentation) reviews before migration and ensured best practices are followed.
  • Responsible for administration and maintenance of all Informatica environments.
  • Performed impact analysis and Implemented Informatica Upgrade from Powercenter 7.1 to Informatica Powercenter 8.1.1.
  • Responsible for designing and development of logical, physical dimensional data models using Erwin
  • Developed Oracle Stored Procedures, Functions, Packages and Triggers and defined security.
  • Informatica Administration - Developed data mapping documents to present the transformation process
  • Implemented handshaking methodologies between wide variety of Systems
  • Extensively used the versioning in Informatica
  • Created complex mappings using Informatica to load data.
  • Created Pipeline partitioning to improve Session performance
  • Scheduled workflows and sessions to schedule the loads at required frequency using workflow manager. Generated completion messages and status reports using session.
  • Saved thousands of dollars in development costs and processing time by designing and implementing the groundwork for pipeline partitioning of high volume transactional data loads from four ERP systems.
  • Onsite administrator for all Informatica installations at client - configured servers, installed software, development and implementation of backup strategies, disaster recoveries, exports, imports. Performance tuning. Established benchmarks.
  • Developed integration programs extensively using Informatica, PL/SQL, Unix scripting, sql Loader
  • Implemented automation of ETL cycles supporting N sources and N targets applications including warehouse and downstream applications
  • Designed the standards for ETL coding, reviewed code of developers
  • Designed and implemented audit balance and control
  • Led teams in offshore model for support of the integration efforts
  • Extensively used UNIX-shell Scripting to process files and execute Informatica jobs
  • Creation of Business Objects Universes. Generating various numbers of reports on a daily, weekly and monthly basis.
  • Deployed the reports to different users using Broadcast Agent Server.

Environment: Informatica Power Center 8.1.1/7.1 (Designer, Workflow Manager, Workflow Monitor, Repository Manager), Business objects 5.1.5 (Reporter, Designer, Supervisor, Broadcast Agent, Web Intelligence), ERWIN4.1, Redhat Linux, Shell Scripting, SQL, PL/SQL (Procedures and Functions), Oracle 9i, TOAD 7.4.0, Win XP/2000.

Confidential, Roseland, NJ

ETL Consultant/Systems Analyst

Responsibilities:

  • Involved with needs assessments and proposals, design and implementations in Development, staging and production environments.
  • Designed, architect the complete informatica power center suite.
  • Installed and configured repository server and Global repository on oracle 9i DB in RISC (IBM pSeries 650s and on sun Fires 440, 6800 and 210) for Different sources of Confidential .
  • Design the complete Database suitable for DATAMART implementation for different sources of Confidential and for repositories involved in INFORMATICA
  • Implemented Row level Security for users using VPD( Virtual Private Database)
  • Involved in creating LDAP to Oracle Database architecture design.
  • Physical and Logical designing of the Database. Implementing the OFA at OS Level and Oracle level. Creation of the data Flow diagrams and ER diagrams Creation of database. Security to database through user, role, profile management. Development and testing the Backup and Recovery strategies. Reverse engineering using ERwin. Shell scripts have been used to perform all the OS level jobs and to call the batch jobs and to monitor the database.
  • Evaluated ETL Vendors (Informatica, Ascential) and performed a POC for impact on source system performance and LDAP connectivity.
  • Analyzing ORACLE Architecture to get the technology used for CDC (Change Data Capture) to implement the Datastage CDC and Datastage OmniReplicator, Datastage (mercator) LDAP connector to source systems to Co-Ordinate with Developers for develop internally the same CDC technology.
  • Installed Informatica 7.0 on Aix 5.1 and Informatica 7.1 on Sun solaris 9.0 and configured the Pmserver and pmrepserver and installed the global repositories.
  • Installed the Ldap plugin connector and registered the plugins using the Informatica Repository administrator console.
  • Imported various Sources, Targets, and Transformations using Informatica Power Center 7.0/7.1 - Server, Server Manager, Repository Manager and Designer.
  • Developed various Mappings with the collection of all Sources, Targets, and Transformations.
  • Developed various Sessions, Batches for all Mappings for data loading from Source TXT files, Tables to Target tables.
  • Created and managed the global and local repositories and permissions using Repository Manager in Oracle Database.
  • Created Mappings between Source and Target using PowerCenter Designer.
  • Used multiple Sources and Multiple targets.
  • Used Dimensional Modeling Techniques to create Dimensions, Cubes and Fact tables.
  • Created and Scheduled Sessions and Batch Process based on demand, run on time, run only once using Informatica Server Manager.
  • Involved in Designing Logical and Physical Database Designing.
  • Involved in admin tasks like analyzing Table Space requirement, load balancing and Performance.
  • Analyzed and Created Facts and Dimension Tables.
  • Creation of reports like, Reports by Product, Reports by Customer, Reports by Period, Demographic reports and Comparative reports.
  • Writing PL/SQL procedures for processing business logic in the database. Tuning of SQL queries for better performance.

Environment: Informatica PowerCenter 7.0/7.1,Persistent Ldap connector, Ascential Datastage, Mercator, IBM IDI, Web Report, XML,DB2 UDB 8.1, Oracle8.x/9.x, AIX 5.x,Sun Solaris 9 and Windows2000, Suse Linux, Java, PHP scripting.

Confidential, Roseville, CA

Sr. Data Warehouse Developer

Responsibilities:

  • Extensively involved in the Analysis, Design and Modeling. Worked on Star Schema, Data Modeling, Data Elements, and Issue/Question Resolution Logs, Source to Target Mappings, Interface Matrix and Design Documents.
  • Created Informatica mappings using Designer with PL/SQL Procedures, Functions and transformations (such as Aggregators, Filters, Router, Normalizer, store procedure & Sequence) to build business rules.
  • Performed various Informatica Administrative tasks & managed Informatica Repository.
  • Involved in the design of Informatica sessions, batches, refresh strategy, scheduling, dependency, event triggers & post/pre using workflows and various Tasks (session, command and event).
  • Extensively used ETL to load data from various sources like Oracle, SQL Server, Sybase and DB2 into the target Oracle database.
  • Created Test plans and Test Scenarios.
  • Wrote stored procedures for application using Oracle PL/SQL.
  • Extensively worked on the Database Triggers, Stored Procedures, Functions and Database Constraints.
  • Generated reports using Brio 6.x
  • Used Brio Report Builder Suite Query Designer and Report Designer.

Environment: Informatica Power mart 6.0/5.1 Brio Report 6.x, Oracle 8.0/9i, DB2, COBOL, Sybase 10.0, MS SQL Server 7.0, Unix Shell Scripting, PL/SQL, AIX 4.3, Windows NT 4.0, IBM Compatibles and Sun Classic

Confidential, Orange County CA

Data Warehouse Developer

Responsibilities:

  • Involved in the high-level design of the ETL system, which comprises of re-engineering of existing CPMS system.
  • Developed low-level design to depict the functionality of each individual system.
  • Worked on all components of Ascential Datastage 7.0/6.0 for various requirements. DataStage Designer for developing various jobs to extract, cleansing, transforming, integrating and loading data into Data Warehouse, used DataStage Manager for importing metadata from repository, new job categories and creating new data elements and used DataStage Director and the runtime yengine to schedule running the server jobs, monitoring and debugging its components.
  • Worked extensively on Parallel Extender (DataStage 6.0) for splitting the data into subsets and to load data, utilizing all available processors to achieve job performance.
  • Hands on experience in working with Dynamic data re-partitioning using Hash File for Lookup tables and to add desired degree of Parallelism for data transfer.
  • Worked on DataStage Administrator to assign privileges to users or user groups to control purging of Repository and DataStage client applications or jobs they run, move, rename projects and manage or publish jobs from development to production status.
  • Wrote custom and complex user defined Routines and Transformations.
  • In the process of re-engineering the CPMS system, the previous code was replaced with Build-ops which tremendously improved the performance.
  • Developed some complex Unix and PERL Scripts for Backend Interface program, input file validations and event automation
  • Imparted for Users of this CPMS project on the new re-engineered and modified CPMS project.
  • Responsible for supporting production and development environments;
  • Setting up test data for system testing;
  • Conducted the Unit testing, Event & Thread and System testing of the individual modules of CPMS
  • Responsible for documenting expected and actual testing results;
  • Communicating with business users during user acceptance testing;
  • Involved in the end user in basic and advanced reporting as well as create queries, format results, and share them with others within the enterprise and beyond using Business Objects;
  • Responsible for developing the reports Using Business Objects and creation of Universes for different data marts.
  • Generated various types of reports right from simple to complex by making most use of Business Objects Functionalities, created reports with Multiple Data Sources, Drill Down, Slice/Dice and Charts.

Environment: DataStage 7.0/6.0, (Parallel Extender, Integrity, Meta Broker, Meta Stage) and Orchestrate, ERWIN 3.5 2, DB2 UDB 8.1, Universe Basic, Business Objects 5.1, WEBI, ZABO, Korn Shell Scripting, UNIX AIX 4.3x and Windows NT 4.0.

Hire Now