We provide IT Staff Augmentation Services!

Technology Analyst Resume

Atlanta, GA

PROFESSIONAL SUMMARY:

  • Almost 6 years of IT experience as a ETL Developer having strong Data Warehouse Design/Development experience using ETL tools like Informatica 8.6/8.1, Ab Initio 1.15/3.1.
  • Experience in all phases of Data Warehousing development life cycle - Estimation, Requirement gathering, Design Documentation, Unit test planning, System test Planning, Implementation planning.
  • Experience in OLTP/OLAP System - Study, Analyze and Develop Database Schemas like Star flake schema and Snowflake schema used in relational, dimensional and multidimensional modeling.
  • Extensive experience in Data Extraction, Transformation, and Load from disparate Data sources like Relational Databases, Flat Files.
  • Worked on scheduling tools like - Autosys and CA7
  • Expertise in performance tuning of mappings, sessions, workflows - Throughput analysis, Session partitioning, caching technique - static, dynamic, and persistent.
  • Business Intelligence experience using Business Objects XI R2.
  • Excellent communication, presentation, interpersonal skills and leadership qualities.
  • Experience in different database like SQL Server, Oracle and MS-Access.
  • Good interpersonal skills, commitment, result oriented, hard working with a quest and zeal to learn new technologies.

TECHNICAL SKILLS:

ETL Tools: Informatica PowerCenter 8.6.1, Ab Initio, Data Stage

Data Modelling: Dimensional Data Modelling, Star Schema Modelling, FACT and Dimensions Tables

Databases: Oracle 9i/8i, DB2, SQL Server

Reporting Tools: BUSINESS OBJECTS XI R2 - Designer, Desktop Intelligence

Programming: SQL, Unix Scripts

Environment: Windows/2000/XP, Unix, Citrix

Configuration Management: Visual Source Safe/ PVCS

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, GA

Technology Analyst

Environment: Ab Initio 3.1, DB2, CA7, UNIX

Responsibilities:

  • Work with business clients to deliver strategic and tactical solutions
  • Involved in Production Support of the daily load process.
  • Involved in end user support and bug fixes and tuning the code for better performance.
  • Identify, diagnoses, and resolves problems for users of Merchant DSS and communicates solutions to end-users.
  • Serves as a liaison between internal/external business community and the IT organization in order to provide technical solutions to meet user’s needs.
  • Translates business requirements into functional specifications for the IT development teams, manages changes to such specifications, and educates the IT organization on the direction of the business.
  • Documents existing process in order to evaluate and define new IT solutions and implementation process.
  • Posses understanding of technical trends and uses this knowledge to bring solutions to business groups supported to enhance the enterprise’s competitive advantage.
  • Study and understand all the functional and technical requirements to better serve the project.
  • Developed Ab Initio graphs using different components for Extracting, Loading and Transforming external data into data mart.

Confidential

Data Warehouse Analyst

Environment: Data Stage, Business objects XI R2, Oracle 9i, SQL

Responsibilities:

  • Participated in solution and technical design, development, testing and delivering of data warehousing solutions.
  • Designed and developed analytic and reporting solutions using BI tools, Business Objects.
  • Performed data requirements analysis and prepared appropriate documentation to communicate and validate the information
  • Developed new reporting data marts, ETL processes, BO universes and reports.
  • Involved in production support and interaction with users.
  • Involved in documentation of solutions (e.g. technical specs, etc.)

Confidential

Informatica Developer

Environment: Informatica Power center 8.1.3, Oracle 9i, PL/SQL, Flat Files, UNIX

Responsibilities:

  • Involved in deriving Technical Specifications based on Functional Specifications.
  • Developed and tested ETL components using Informatica Power Center.
  • Worked on Informatica Designer tools like Source Analyzer, Transformation Developer, and Mapping Designer.
  • Involved in creating Tasks, Sessions, Workflows and Worklet by using the Workflow Manager tools like Task Developer, Worklet and Workflow Designer.
  • Worked extensively on Lookup, Router, Filter, Aggregator, Expression, Stored procedure, Sequence Generator and Update Strategy Transformations.
  • Worked with mapping parameters and variables to load data from different sources to corresponding database table.
  • Performed testing of the developed components.
  • Involved in System testing and UAT support.
  • Involved in Production Support.
  • Involved in writing shell scripts for file transfers, file renaming and few other scripts to be executed from UNIX.
  • Dealt with mappings that in corporate Incremental loads, Constraint Based Loading.
  • Worked on PowerCenter Versioning (Check-in, Check-out), Querying to retrieve specific objects, maintaining the history of objects.
  • Involved in end user support and bug fixes and tuning the code for better performance.
  • Performed Integrated and System testing of the complete system.
  • Responsible for configuration control using VSS

Confidential

Data Warehouse Developer/Analyst

Environment: Informatica Power center 8.1.3, Oracle 9i, SQL, Unix

Responsibilities:

  • Involved in Business requirement gathering, Technical Design Documents, Business use cases and Data mapping.
  • Prepared documentation such as Functional Specifications document, Technical or ETL Specifications document,
  • Worked on Data Analysis, Mapping, Identify Data Quality issues, Data Cleaning, Data validation and Loading.
  • Performances Tuning & recommending tuning strategies in Informatica Mappings, Sessions, Workflows and sending automated email on errors, failures, success of the sessions/workflows.
  • Hands on experience leading all stages of system development efforts, including requirement definition, design, architecture, testing, support and administration.
  • Expertise in developing and running Informatica Mappings, Sessions/tasks, Workflows, Worklets, and Batch processes on Informatica server.
  • ETL Architect, Define ETL Standards, ETL process, batch processing, bulk loading, initial data capture, change data capture, implementation process.
  • Create & Perform Unit & Integration Test Cases, UAT Test Case Review, Migration to Production.
  • Worked on Informatica Designer tools like Source Analyzer, Transformation Developer and Mapping Designer.
  • Involved in creating Tasks, Sessions, Workflows and Worklet by using the Workflow Manager tools like Task Developer, Worklet and Workflow Designer.
  • Worked extensively on Lookup, Router, Filter, Aggregator, Expression, Stored procedure, Sequence Generator and Update Strategy Transformations.
  • Involved in exhaustive testing of the developed components.
  • Involved in System testing and UAT support.
  • Involved in end user support and bug fixes and tuning the code for better performance.

Hire Now