We provide IT Staff Augmentation Services!

Etl Designer/developer Resume

Alpharetta, GeorgiA

SUMMARY:

  • Over 6 years and 6 months of IT experience in Data warehousing applications, ETL using Oracle data integrator (ODI) and Informatica Power Centre, Business Objects data Integrator (BO DI),OLAP using Business Objects and OBIEE with SQL 2000/2005 and Oracle, Teradata, Netezza databases.
  • Excellent knowledge and experience in Data Warehouse development life cycle, requirement analysis, dimensional modeling, repository management and implementation of Star or Snow Flake Schema.
  • Proficient in Data Modelling using tools like Erwin. Involved in Relational Database design and development of data warehouse, developing logical and physical models and implementing them in Oracle, problem solving, logical and analytical abilities, good communication and interpersonal skills.
  • Design/development an operational data store, data warehouse, or data mart.
  • Proficient in Data Mart, Star Schema, Snowflake Schema, Extract, Transform and Load of Data, Requirement Analysis, Design, Development, Testing. Documentation and Implementation of Business Applications.
  • Worked on Oracle Data Integrator Interfaces, Packages/Scenarios, ODI Security, admin and Topology. Member of ODI Centre of excellence team and served and helped for many different projects at implementation level across Nielsen Company. As of DMCOE team attended workshops of ODI in Oracle Company and learnt best practices for implemtation, security, admin etc..
  • Worked on Business Objects Data Integrator Mappings, Data Flows, Workflows, DI scripting and Projects to develop an ETL application. Also worked as an DI admin for the project in Confidential .
  • Worked extensively Incremental and Delta Loads, Change Data Capture and Slowly Changing Dimensions.
  • Worked on Informatica Power Center Transformations such as Source Qualifier, Look up, Filter, Expression, Router, Normaliser, Joiner, Update Strategy, Sequence generator, Stored Procedure, Sorter Transformation, Aggregator, XML Source Qualifier, External Procedure Transformation, Rank, Performance Optimizations, provided various levels of production support.
  • Worked on Power Mart to transfer the data from legacy systems to common / different targets, worked with mainframe applications, writing stored procedures (PL/SQL), triggers, packages and shell scripts to apply / maintain the Business rules and writing simple/ complex SQL Queries.
  • Participate in the creation and maintenance of standards for coding, documentation, error handling, error notification, logging, etc. Work with information support groups and management teams to define and support system and information needs.
  • Log bugs in test director and coordinated with other team members to achieve goals and objectives.
  • Creative, independent thinker, self - starter; attention to detail and ability to work independently as well as within a team, demonstrated ability to multi-task work assignments and mentored other ongoing projects.

TECHNICAL SKILLS:

Operating Systems: Windows, UNIX, Sun Solaris, Linux

Data warehousing Tools: SAP (formerly Business Objects) Data Integrator, Oracle Data Integrator(ODI), OBIEE, Informatica 7 1.4, Business Objects XI, Ab Initio

Special Software: Teradata SQL Assistant, Teradata Utilities, Maestro Scheduler, Erwin,Tibco

Data modeling: Erwin

Programming Language: C, C++, JSP

Database: Netezza Twinfin,Oracle 11g, Teradata V2R5,Microsoft 2005

Database Programming: Native SQL, Oracle PL SQL

Scripting Language: Unix Shell Script, Linux shell script and Perl.

PROFESSIONAL EXPERIENCE:

Confidential, Alpharetta, Georgia

ETL Designer/Developer

Responsibilities:

  • Analyze the data and Design the ETL specifications.
  • Design and Develop the ETL process using BO DI and Netezza
  • QA support and Production support the the existing application like ePremis,DBQ and Recon along with Archetype.
  • Performance and fine tuning the ETL process.

Confidential, Richardson, Texas

BI Architect & Designer

Responsibilities:

  • Participate in Business Requirement gathering
  • Understand Business Requirement and write High Level and Low level Design Documents.
  • Build LDM & PDM using Erwin tool based on the FSD.
  • Design the ETL process for crucial and important modules.
  • Develop the ETL process using ODI and netezza
  • Analyze the data with the help of Business customers.
  • QA support and on site coordinator for the Functional testing team.
  • Performance and fine tuning the ETL process
  • ODI admin for the product. Handle all the ODI related tasks like Code Deployment and Security Management.

Confidential, San Francisco CA

Designer and Developer/Jr Database Architect

Responsibilities:

  • Participate in Business Requirement gathering
  • Understand Business Requirement and write High Level and Low level Design Documents.
  • Build LDM & PDM using Erwin tool based on the FSD.
  • Design the ETL process for crucial and important modules.
  • Develop the ETL process using ODI and netezza
  • Analyze the data with the help of Business customers.
  • QA support and on site coordinator for the Functional testing team.
  • Performance and fine tuning the ETL process
  • ODI admin for the product. Handle all the ODI related tasks like Code Deployment and Security Management.

Confidential, Westport CT

Developer & On-site Co-ordinater

Responsibilities:

  • ETL Estimation & Resource planning.
  • TWS LDM & PDM design.
  • Design and Develop the ELT module.
  • Analyze the data with the help of Business customers.
  • On site coordinator for ELT module and reporting module.
  • Prepare Project plan and discuss with the clients in weekly meetings.
  • Develop the custom reports using OBIEE and deliver to customers.
  • Involved in Designing the RPD of OBIEE
  • Unit testing & integrated testing of ELT codes & Reports.
  • Deploy the system in production and schedule the Jobs in production.

Confidential

Analyst

Responsibilities:

  • Analyze the Call Detail Records.
  • Providing the adhoc reports using CDRlive for a wide customer base.
  • Business Objects Universe Design & development based on the user requirements.
  • Development of reports using BO functions like Drill Down, Prompts, Dimensional and Measure variables
  • Responsible for maintaining the Business Objects environment by understanding the issues faced by various teams and troubleshoot the issue to fix/tune the performance of the environment as per the business needs.
  • Developing PL/SQL procedures, functions and packages for automating the monthly reports.
  • Tuning of SQL queries by analyzing the tables and using various hints based on the explain plan.
  • Used SQL Loader for loading the data from flat files into temporary tables for analysis.
  • Involved in the drive test to understand how the CDR’s are generated for the various call scenarios.

Confidential

Analyst

Responsibilities:

  • Performance tuning of the Informatica mappings and SQL scripts used for loading the Data Warehouse Business Intelligence Database (BID)
  • Tier-II support for solving production issues.
  • Deployment of the new code into production after checking the coding standards.
  • Creating Maestro schedules for the new jobs that are deployed into production
  • Appraise the project status to project manager on regular and need basis.
  • Escalations of the production outages and following them to closure.
  • Coordinating with the developer team and PMO to plan the new projects SIS.
  • Involved in automation of manual jobs using UNIX shell scripts to reduce manual intervention
  • Understanding the functional aspects and implementation details of EDS-ETL

Confidential

Analyst

Responsibilities:

  • Involving in the enhancement and development activities of UNIX loader scripts
  • Involving in handling change requests using Ab-Initio
  • Responsible for understanding the requirements of adhoc requests and providing reports generated by developing Ab-Initio graphs.
  • Understanding the functional aspects and implementation details of EDS - ETL
  • Preparing UTPs and testing the modified UNIX scripts for various Change requests & enhancements
  • Providing solutions for ETL Loaders Production Issues in BR
  • Playing a Key Role in Requirement Analysis, Design and Development of Enhancements and Change Requests in MCR
  • Monitoring and providing entire end to end support in MCR
  • Sending Status & metrics report to Client manager and onsite TCS officials.
  • Maintaining the Customer validation Database and fix the data quality issues on daily basis.

Hire Now