SCREEN

Profile

Cpanel

Data Mart developer resume new jersey nj

AddThis Social Bookmark Button
Untitled Document

SUMMARY

  • 7+ years of experience in Information Technology including Data Warehouse/Data Mart development using ETL/ Informatica Power Center, and Power Exchange
  • Two years of Telecoms Project Management experience.
  • Proficiency in utilizing Informatica PowerCenter 9.1x/8.x/7.x for developing the Data Warehouse loads as per client requirement.
  • Experience in designing and developing ETL Environment involving various source and target databases like Oracle, Flat Files, DB2 (fixed width, delimited), XML, SQL Server
  • Excellent knowledge in identifying performance bottlenecks and also in tuning the Mappings and Sessions by implementing various techniques like partitioning techniques and pushdown optimization.
  • Extensive experience in developing the Workflows, Worklets, Sessions and configuring the Informatica Server using Informatica Power Center.
  • Experience in designing and developing complex mappings applying various transformations such as Connected - Unconnected Lookup, source qualifier, Filter, Expression, Router, update strategy, router, sequence generator, aggregator, rank, stored procedure, joiner and sorter transformations, Mapplets
  • Proven experience with ETL the development, and implementation of large-scale, enterprise data warehouse and reporting solutions
  • Extensive database experience and highly skilled in SQL Server, Oracle, DB2, Teradata, Sybase, XML Files, Flat Files, MS Access.
  • Involved in ETL process from development to testing and production environments
  • Experience in integration of data sources like Oracle, DB2, Teradata, COBOL, SQL Server, and Flat Files.
  • Proficient experience in different Databases like Oracle, SQL Server and DB2, Teradata.
  • Expertise in Developing PL/SQL Packages, Stored Procedures/Functions, triggers.
  • Automated and scheduled the Informatica jobs using UNIX Shell Scripting.
  • Exposure to OLAP reporting tools: Business Objects and Cognos.
  • Adept in statistical analysis, data management, documentations, and preparation of technical presentation and reports.
  • Consistency in demonstrating leadership skills, decision making, and resourcefulness in responding to job challenges
  • Good exposure to overall software development life cycle with good knowledge of processes like version control, bug tracking
  • Strong Interpersonal and communication skills, ability to work in a team as well as independently with minimal supervision
  • Very methodical and well organized with excellent bottom-line for work
  • Sound experience in System analysis, design, and development using UML methodology
  • Good understanding of design patterns
  • Motivated problem solver with strong analytical skills

EDUCATION

Confidential.

SKILLS

ETL Informatica 7.1/8.1/8.6.0 (Power Mart and Power Center)

OLAP Business Objects 5.0, Cognos 8.0

Modeling Erwin 3.x/4.x

RDBMS Oracle 8i/9i/10g, 11g,Teradata, DB2, SQL Server 2000, MySQL, MS Access

Utilities SQL *Loader (Oracle)

OS Windows 9x/NT/2000/XP, UNIX (Solaris, HP-UX, AIX)

Languages SQL, PL/SQL, Java Script, C, C++

Web HTML, XML, CSS, JSP

Productivity MS Office 97/2000/XP, Open Office Suites

Quality Trillium 4.0

EXPERIENCE

Jun 11 - Present, Confidential

PAREXEL is a leading global bio/pharmaceutical services organization that helps clients expedite time-to-market through our development and launch services. These include a broad range of clinical development capabilities, integrated advanced technologies, regulatory affairs consulting, and commercialization services

  • Gathered requirements from business analysts for designing and development of the system
  • Developed Transformation logic and designed various complex Mappings in the Designer for data load and data cleansing.
  • Assessed data to understand its quality challenges using data profiler
  • Handled a team of 4 members in various projects and coordinated with the onsite-offshore team in delivering the projects.
  • Worked with Business Objects developers in writing SQL queries and creating customized reports.
  • Created Mappings using Mapping Designer to load the data from various sources, using different transformations like Source Qualifier, Expression, Lookup (Connected and Unconnected), Aggregator, Update Strategy, Joiner, Filter, and Sorter transformations
  • Implemented Slowly Changing Dimension Type 1 and Type 2 for inserting and updating Target tables for maintaining the history
  • Used Normalizer transformation to handle the COBOL files.
  • Extensively used the capabilities of Power Center such as File List, pm cmd, Target Load Order, Constraint Based Loading, Concurrent Lookup Caches etc.
  • Created and Monitored Workflows using Workflow Manager and Workflow Monitor.
  • Created several Procedures, Functions, Triggers and Packages to implement the functionality in PL/SQL.
  • Developed Teradata FLOAD and MLOAD for populating new and already existing Teradata tables
  • Extensively worked on Mapping Variables, Mapping Parameters, Workflow Variables and Session Parameters.
  • Used shortcuts (Global/Local) to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically.
  • Used the Workflow manager to create workflows, worklets and sessions
  • Created post-session and pre-session shell scripts and mail-notifications.
  • Used debugger to test the mapping and fixed the bugs.
  • Worked on Powerplay transformer to create models, Powerplay cubes and published in the cognos connection.
  • Scheduled various reports using Schedule Management tool/Event Studio.
  • Developed Unit Test Cases to ensure successful execution of the data loading processes.
  • Used Shell Scripts & Perl scripts for better handling of incoming source files such as moving files from one directory to another directory and extracting information from the log files on Linux server.
  • Documented Informatica mappings, design and validation rules

Environment: Informatica Power Center 9.1/8.6, Oracle 11/10g, ERWIN 4.1, SQL, PL/SQL, Toad, Cron, data explorer, Perl 5, Unix, Teradata, Windows 2003 Server, Tidal

July '10–May '11 ETL / Informatica Developer

Confidential

MIS Data Marts

CIGNA Corporation (CIGNA) is an investor-owned health service organization in the United States. The Company's subsidiaries are providers of healthcare and related benefits, life and accident insurance, and workers' compensation case management and related services. The project includes developing Data Warehouse from different data feeds and other operational data sources. This applicationwas specifically designed for Disease Management module of healthcare program

  • Interacted with End user community to understand the business requirements
  • Prepared required application design documents based on functionality required
  • Worked with heterogeneous sources from various channels like Oracle DBMS, SQL Server and flat files
  • Design and Development of ETL routines, using Informatica PowerCenter within Informatica Mappings, usage of Lookups, Aggregator, Ranking, Mapplets, connected and unconnected stored procedures / functions / Lookups, SQL overrides usage in Lookups and source filter usage in Source qualifiers and data flow management into multiple targets using Routers were done
  • Implemented dimensional model(logical and physical)data model in existing architecture using Erwin
  • Created Data Marts for both kinds of applications, CRM and financial and used effective querying and formatting tools to present the data to the end users
  • Monitored sessions that are running, scheduled, completed and failed
  • Used ETL to load data from flat files (Excel/Access), SQL Server to Oracle database
  • Designed and developed the logic for handling slowly changing dimension table's load by flagging the record using update strategy for populating the desired
  • Cleansing and extraction of data and defined quality process for the warehouse
  • Involved in performance tuning and optimization of Informatica mappings and sessions using features like partitions and data/index cache to manage very large volume of data, persistent cache
  • Designed ETL processes using Informatica to load data from DB2, Oracle, SQL Server, Flat Files (Excel/Access) and XML Files to target Oracle Data Warehouse database
  • Developing testing strategies for efficient and error free testing
  • Used Workflow Manager for creating, validating, testing and running sequential, concurrent batches, sessions and scheduling them to run at specified time with required frequency
  • Involved in Unit testing, System testing to check whether the data is loading into target, which was extracted from different source systems according to the user requirements
  • Involved in production support working with various mitigation tickets created while the users working to retrieve the database. Created Stored Procedures to transform the Data

Environment: Informatica Power Center 7.1.2, Business Objects 6.5, Oracle 10g/9i, TOAD, Erwin 4.5, SQL, PL/SQL, XML, Windows XP, HP-UX, Test Director / Quality Center

Oct '08 – May '10 ETL Developer/Analyst,

Confidential

Customer Data Integration

MCI Telecommunications is one of the leading local US telecommunications firm. MCI needed to focus on its customers—improving customer retention, increasing cross- and up-sell opportunities, and attracting new customers. So organization focused their attention on Customer Relationship Management (CRM). This Data Warehouse was developed to aid and assist the management committee in analyzing various decisions regarding a customer.

  • Involved with Business Analyst in requirements gathering, business analysis and project coordination
  • Analyzed source data coming from different sources like Oracle, flat files, XML, DB2, SQL Server and worked with business users and developers to develop the model
  • Involved in dimensional modeling to design and develop the STAR Schema using Erwin
  • Developed data Mappings between source systems and warehouse components
  • Worked with data population developers, multiple business units and a data solutions engineer to identify key information that will enhance business decision-making
  • Developed ETL procedures to ensure conformity, compliance with standards and lack of redundancy, translates business rules and functionality requirements into ETL procedures
  • Used Power Exchange to extract DB2 Source from mainframe server
  • Used Industrial Best Practices for Error handling
  • Developed and test all the backend programs, Informatica mappings and update processes
  • Managed the Metadata associated with the ETL processes used to populate the Data Warehouse
  • Worked on SQL, PL/SQL and UNIX Shell Scripts
  • Used UNIX scripting as pre/post-session commands to schedule loads using Crontab jobs
  • Removed bottlenecks for the optimum usage of sources, transformations and targets
  • Used SQL*Loader to load data from flat files to Oracle target database
  • Performed Unit and Integration Testing of Informatica Sessions, Batches and Target Data
  • Involved in generating reports using Cognos Report Net

Environment: Informatica Power Center 7.1/8.1.1 Windows XP, Oracle 8i/9i, HTML/XML, Cognos Report Net, Erwin, Crontab, SQL Server 2000, IBM- DB2, UNIX (Solaris)

Jun '07 - Sept '08 ETL Developers, Confidential

Collection Department Application

State Farm is one of the oldest and largest underwriters of commercial, industrial and general, life insurance companies with offices located around the world. The company Offers health, auto, life, dental, disability and long –term care benefits

  • Interacted with End user community to understand the business requirements
  • Prepared required application design documents based on functionality required
  • Worked with heterogeneous sources from various channels like Oracle DBMS, SQL Server and flat files
  • Design and Development of ETL routines, using Informatica PowerCenter within Informatica Mappings, usage of Lookups, Aggregator, Ranking, Mapplets, connected and unconnected stored procedures / functions / Lookups, SQL overrides usage in Lookups and source filter usage in Source qualifiers and data flow management into multiple targets using Routers were done
  • Implemented dimensional model(logical and physical)data model in existing architecture using Erwin
  • Created Data Marts for both kinds of applications, CRM and financial and used effective querying and formatting tools to present the data to the end users
  • Monitored sessions that are running, scheduled, completed and failed
  • Used ETL to load data from flat files (Excel/Access), SQL Server to Oracle database.
  • Designed ETL processes using Informatica to load data from DB2, Oracle, SQL Server, Flat Files (Excel/Access) and XML Files to target Oracle Data Warehouse database
  • Developing testing strategies for efficient and error free testing
  • Used Workflow Manager for creating, validating, testing and running sequential, concurrent batches, sessions and scheduling them to run at specified time with required frequency
  • Involved in Unit testing, System testing to check whether the data is loading into target, which was extracted from different source systems according to the user requirements
  • Involved in production support working with various mitigation tickets created while the users working to retrieve the database. Created Stored Procedures to transform the Data

Environment: Informatica PowerCenter 7.1.2, Oracle 10g/9i, TOAD, Erwin 4.5, SQL, PL/SQL, XML, Windows XP, HP-UX, Test Director / Quality Center

Mar '05- Apr '07 Software Analyst,Confidential

Fixed mobile project

Alcatel-lucent provides telecommunications services to service providers, enterprises and government. During this period we implemented the outside line fixed plant for both fiber optic and copper cables. , I Performed requirement analysis, designed and implemented a comprehensive Export business application. The application keeps track of Direct, Deemed & Merchant Exports Inventory information, sales analysis and delivery

  • Designed the E-R model and normalized the database
  • Designed optic fiber (OF) and copper network architecture.
  • Prepared engineering activity status reports and other detailed reporting
  • Developed reports for costing analysis, CHAs bill report, BDA report, invoice entry, Advance License report
  • Developed in Forms 4.5 with Oracle7.3
  • Developed Graphical charts for pricing analysis, sales analysis using Oracle graphics
  • Prepared daily, weekly and monthly reports.

Environment: Oracle 7.3/8.0, Forms 4, Reports 2.5, PMS software, and Windows 95

 

Home Resumes Datawarehousing, ETL, Informatica Resumes Data Mart developer resume new jersey nj