Data warehouse Developer
Resume:
Archana
ac167y@r.postjobfree.com
SUMMARY:
Around 6+ 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, iSQL*Plus, 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.1/7.1, iWay Data Migrator
Reporting Tools
WEBFOCUS Developer Studio, TIBCO Spotfire
Scripting Languages
Java Script, UNIX Scripting
Web Technologies
HTML
Work Experience:
Worked as Technical Architect for New York State Insurance Fund(NYSIF) from Oct 2014 to till now
Worked as an Informatica Developer for Sonata Software Ltd from Aug 2013 to Feb 2014
Working as a ETL Developer for Wipro, Hyderabad from Aug 2010 to June 2013
Worked as an ETL Developer for IGATE, Bangalore from June 2008 to July 2010.
PROFESSIONAL EXPERIENCE:
NYSIF, NY Oct 2014 – Till Date
Senior Technical Architect
Project: Enterprise Data Warehouse/Business Intelligence
Description: This Project includes design and development of multiple Data Marts, BI Reports and Analytics for SIF Claims (CLIO, SLU, CMRP), Underwriting (PPP, PAD) and Finance (MedBill).
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
Broadridge Financial Solutions, Inc Aug 2013 - Feb 2014
Data warehouse Developer
Description: This warehouse is projected to assist financial information distribution and transaction reporting services to both financial institutions and securities issuers. These services include the processing and distribution of account statements and trade confirmations. The purpose of this project was to integrate data from various sources and build a strategic global data warehouse for decision support and business metrics.
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.
Regions Bank, Memphis, TN Aug 2010- Feb 2013
ETL Developer
Description:
Worked on design, development and implementation FODW (Finance and Operations Data Warehouse). This project allows the company to store historical information of its credit card holders, account holders, respective credit scores of all its customers and also for generation of detailed monthly reports based on the company business requirements.
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.
Avnet Inc, Phoenix, AR Jan 2009-July 2010
ETL Developer
Description:
Avnet sales and marketing is one of the leading distributor of electronic equipment and a major producer of specialty Electronics products. This Project involves the creation of a Data Warehouse for the Sales Reporting System. Data from Operational Source System is extracted, transformed and loaded into Data warehouse using Informatica.
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).
IBMS-ICICI Ltd, India Jun2008-Dec2008 Informatica Developer
Description:
Developed an Integrated Banking Maintenance System. This system consisted of New Depositor, Interest Warrant, Maturity, Premature & Renewal, and Enquire modules. The system was capable of calculating the annual percentage rate, interest period, and amount due on maturity date. Banking maintenance system generated fixed deposit receipts, duplicate fixed receipts, interests warrants, duplicate interest warrants, premature withdraw receipts, maturity receipts and monthly statements.
Responsibilities:
Used Informatica Designer for developing mappings using transformations, which includes aggregation, Update strategy, lookup, Stored procedure and Router.
Extracted the data from Sybase, Oracle, Files, and Access into Data warehouse.
Extracted Erwin physical models into repository manager using Informatica.
Studied the existing OLTP system(s) and Created facts, dimensions and star schema representation for the data mart.
Used Informatica Power center 7.1 for extracting data from heterogeneous source systems.
Utilized Unconnected Lookup to update slowly changing dimensions.
Developed and Monitored Tasks and Workflows using Informatica Workflow Manager.
Finely tuned Transformations and workflows for better performance.
Scheduled the batches comprising of different Tasks in order to load data into Target database.
Environment: Informatica Power Center7.1, BusinessObjects5.1, PL/SQL, Sybase, Oracle9i, Windows NT, MS SQLServer2000, ERWIN 4.0, UNIX.
EDUCATION: B.Tech Electronics and Communication Engineering, India.
Immigration Status: Green Card
Contact this candidate