We provide IT Staff Augmentation Services!

Senior Technical Architect Resume

NY

SUMMARY:

  • Around 8+ Years of Experience in the field of Software Design, Development and Implementation with Proficiency in Oracle 9i/10g, 11gR1 and 11gR2, SQL, PL/SQL that includes Complete System Development Life Cycle from Analysis and Design to Implementation.
  • Expertise in writing Packages, Stored Procedures, Functions, Views and Database Triggers using SQL and PL/SQL in Oracle.
  • Exposure to concepts of Data warehouse like Design, Data Modeling, OLTP, ETL and Reporting.
  • Hands on experience in defining Technical Requirements for ETL processes and developing Complex Mappings to load data into enterprise data warehouse and data marts.
  • Excellent hands on experience in the entire Life Cycle of Data warehouse/Business Intelligence, designing and developing ETL objects, performance tuning.
  • Worked with query tools like Toad, SQL*Plus, SQL Developer.
  • Manipulated Stored Procedures, Triggers, Views, Functions and Packages using PL/SQL Developer.
  • Experience in Performance Tuning & Optimization of SQL statements.
  • Data modeling and design of data warehouse and data marts in snowflake and star schema methodology with confirmed and granular dimensions and FACT tables.
  • Experience in development and design of ETL (Extract, Transform and Loading data) methodology for supporting data transformations and processing, in a corporate wide ETL Solution using Informatica Powercenter (9.x/8.x).
  • Experience in creating Complex Spotfire Dashboards, Reports Using Tibco Spotfire Professional Client (Analyst), TIBCO Web Player Client (Consumer), Regression and Predictive Modeling using TIBCO TERR and Automation Server.
  • Expertise in development of ETL flows using Information Builders iWay Data Migrator and development of reports using WEBFOCUS Developer Studio.
  • Worked on data warehousing and decision support systems with relational databases such as Oracle design and database development using SQL, PL/SQL and TOAD.
  • Experience with Unix Shell Scripting (KSH - Korn Shell Scripting).
  • Hands on experience in tracking down the bottlenecks in query using trace files.
  • Extensive experience in utilizing Collections to boost performance in PL SQL block.
  • Strong Background in implementation of RDBMS concepts.
  • Experience in debugging and performance tuning of sources, targets, mappings and sessions.
  • Ability to learn new tools, concepts and environments.
  • Ability to explain technical concepts and communicate with users and system administrators at all levels.
  • Excellent communication, presentation, project management skills, a very good team player and self-starter with ability to work independently and as part of a team.

TECHNICAL SKILLS:

Operating Systems: Windows 98 / NT / 2000 / XP, UNIX

Languages: JAVA, C, SQL, PL/SQL

Oracle Tools: ANSI SQL, Oracle PL/SQL, SQL*Plus, TOAD, SQL*Loader

Development Tools: Developer 11g/10g/9i/6i/2000 Release 1 & 2, Reports 10g/9i/6i, Forms 6i/9i/10g

ETL Tools: Informatica Power Center 8.6/8.1/7.1, iWay Data Migrator

Reporting Tools: WEBFOCUS Developer Studio, TIBCO Spotfire

Scripting Languages: Java Script, UNIX Scripting

Web Technologies: HTML

PROFESSIONAL EXPERIENCE:

Confidential, NY

Senior Technical Architect

Responsibilities:

  • Extensively worked on understanding the business requirements and designing iWay Data Migrator ETL jobs, Spotfire Analytics and Oracle PL/SQL Packages, Procedures and Functions.
  • Implemented dimensional models (logical and physical) for all the data marts.
  • Created mapping document for source to target.
  • Developed PL/SQL Packages to extract the data from the source systems.
  • Developed iWay Data Migrator Synonyms, Flows and Procedures to extract and load the data from source system and load into DW.
  • Developed Spotfire Information Links using Information designer.
  • Developed Spotfire Analytics reports and Dashboards using Spotfire Professional Client (Analyst)
  • Successful in developing SQL Scripts, database objects, procedures, functions and packages to check supplied data for sense, consistency and accuracy.
  • Perform code review and make changes/improvements as required.
  • Ability to develop unit test documents and perform unit testing to ensure overall functionality and technical quality of deliverables.
  • Created tables, Correlated sub queries, Nested Queries, Views for Business Application Development.
  • Involved in optimizing database performance by analyzing database objects, creating indexes, creating materialized views etc.
  • Develop Functional Specifications, high Level Design documents
  • Data Modelling through Generic Data Modelling, Dimension-Fact/Star Schema Modeling.
  • Worked on testing and gathering statistics and monitoring the run times for the performances and fixing it.
  • Worked on Business support activities
  • Develop and handle Migrations from source to destination

Environment: Oracle 11G, PL/SQL, PLSQL Developer, iWay Data Migrator, WEBFOCUS Developer Studio, TIBCO Spotfire

Confidential

Data warehouse Developer

Responsibilities:

  • Analyzed the system, met with end users and business units in order to define the requirements.
  • Wrote SQL Queries, Triggers, and Shell Scripts to apply and maintain the Business Rules.
  • Extracted the data from SQL Server, Flat files and load into Data warehouse.
  • Translated business requirements into Informatica mappings/workflows
  • Used Source Analyzer and Warehouse designer to import the source and target database schemas, and the Mapping Designer to map the sources to the target.
  • Creating Stored procedures for loading the staging tables.
  • Designed and developed number of complex mappings, mapplets and reusable objects for the credit marketing systems to facilitate daily and monthly load of data
  • Extensively worked in the performance tuning of the programs, ETL Procedures and processes.
  • Generated SQL scripts for crating tables, Views, Primary keys, Indexes, Constraints, Sequences and Synonyms.
  • Wrote complex SQL queries to retrieve information from the database depending on user requirement.
  • Involved in fixing invalid Mappings, testing of Stored Procedures and Functions, Unit and Integration Testing of Informatica Sessions, Batches and the Target Data
  • Extensively worked in the performance tuning of the programs, ETL Procedures and processes.
  • Review high level business reqs, technical specs, data mapping documents and create detailed test cases.
  • Migrated existing mappings to production environment.

Environment: Informatica Power Center 8.1, Greenplum 4.3, PostgreSQL, SQLServer2008, Toad, Windows NT, UNIX.

Confidential, Memphis, TN

ETL Developer

Responsibilities:

  • Worked on Power Center client tools like Source Analyzer, Warehouse Designer, Analyzed the system, met with end users and business units in order to define the requirements
  • Extracted the data from Oracle, SQL Server and load into Data warehouse.
  • Wrote SQL Queries, Triggers, PL/SQL Procedures, Packages and Shell Scripts to apply and maintain the business rules.
  • Translated business requirements into Informatica mappings/workflows.
  • Used Source Analyzer and Warehouse designer to import the source and target database schemas, and the Mapping Designer to map the sources to the target.
  • Used Informatica Designer to create complex mappings using different transformations like filter, Router, lookups, stored procedure, joiner, update strategy, expression and aggregator transformations to pipeline data to Data Warehouse/Data Marts.
  • Performance Tuning of existing mappings.
  • Developed Mappings that extract data form ODS to Data mart and Monitored the Daily and Weekly Loads.
  • Created and monitored Sessions/Batches using Informatica Server Manager/Workflow Monitor to load data into target Oracle database.
  • Worked with Mapping parameters and variable functions like Setvariable, Countvariable, Setminvariable and setmaxvariable.
  • Migrated existing mappings to production environment.
  • Designed the reports and Universes as per the requirements.

Environment: Informatica PowerCenter8.6, Oracle 9i, PL/SQL, SQL Server, Toad, Windows NT, UNIX Shell Scripts, Business Objects.

Confidential, Phoenix, AR

ETL Developer

Responsibilities:

  • Worked on Informatica client tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformations Developer.
  • Used Informatica to extract and load data from Oracle database and flat files to Oracle tables.
  • Developed and modified PL/SQL packages, procedures, functions as per customer requirement to make new enhancements or resolve problems. Created various mappings using Designer which include Expression, Router, Aggregator, Stored Procedure, Update strategy and Look-up Transformations.
  • Created Mapplets using Mapplet Designer to reuse in different mappings.
  • Created FTP connections, database connections for the sources and targets.
  • Created and Monitored Workflows using Workflow Manager and Workflow Monitor.
  • Handled performance tuning by checking bottlenecks also created partitions, SQL override in Source qualifier.
  • Wrote stored procedures, functions and triggers using Oracle PL/SQL.
  • Involved in developing multidimensional data modeling using star schema and snow flake schema.

Environment: Informatica Powerenter8.1, Oracle9i,PL/SQL, SQL Server 2000,WINDOWS NT,UNIX Scripting (Ksh).

Hire Now