Informatica Etl Olap Resume

Document Sample
Informatica Etl Olap Resume Powered By Docstoc
					                                                          1125 Route 22 West, Bridgewater, NJ 08807
Contact : Deepica Wadhwa                                   (908) 429-8008 Ext 347, Fax (908) 429-8005
                                                            Email: deepica.wadhwa@cyberthink.com
                                                                               www.cyberthink.com

                                           Resume # 4029
SUMMARY OF EXPERIENCE:
 SIX years of IT experience in diversified fields like Data warehousing & OLAP tools, Client/Server
  Technology as application software designer, Developer and Business analyst.
 FOUR Years of Experience in Architecting, Installation & development of Business Intelligence
  Solutions using Cognos - Impromptu, Power Play, Transformer, IWR, Upfront, Query, Architect,
  Finance, Visualizer, Business Objects, Access Manager, IMR, OLAP, Power Prompt. Worked with
  IWR Server and Cognos-Enterprise Server on publishing of (IWR). Impromptu web Reports and
  Power play Cubes.
 FOUR years of strong Data warehousing ETL experience using Informatica Power Center
  5.1.2/1.7.x, Power Mart 5.1.2/4.7.x (Repository Manager, Server manager, Mapping Designer, Mapplet
  Designer, Transformations Designer, Warehouse Designer, Workflow Manager and Workflow Monitor).
 Experience in installation of Cognos Impromptu, Power Play, Impromptu Web Reports.
 Experience in publishing the reports to the Web using Cognos Distributed Shuttle Builder and
  Upfront.
 Experience in generating List Reports, Crosstab Reports.
 Experience in developing models using Cognos Transformer.
 Experienced in the design and development of data warehouses/data marts using Informatica Power
  center/Power mart and Power Analyzer.
 Experience in Oracle 8i/8.x/7.x, PL/SQL, SQL, Pro*C, SQL*Plus, Shell Scripts, Developer 2000
  (Forms 4.5/5.0, Reports 2.5/3.0), Oracle Reports, Erwin 3.5, SQL*Loader, Autosys, TOAD, Stored
  Procedures /Triggers on Unix and Windows platforms, Export, Import and SQL*Plus.
 Prepared and Updated documentation related to backups, restoration, disaster recovery and other DBA
  related activities.
 Worked with Business Users to analyze the business process and made necessary changes to schema
  objects to cater their reporting needs.
 Experience in Web Development, Database Administration, Design, Testing and implementing
  various projects on Client/Server applications.
 Experience in coding using SQL, SQL*Plus, PL/SQL, Stored Procedures, Functions, Triggers,
  Packages and UNIX Shell Scripting.
 Involved in the complete life cycle development process in the data warehousing.
 Expert in ASP.Net, VB.Net, C#. Net, SQL Server, MS Access, HTML, CSS, Java Script etc.
 Excellent communication skills, management and leadership qualities.

TECHNICAL SKILLS:
Languages:             C++, C#, Visual C++, Visual C#. NET, Visual Studio. NET, VB.NET, VB6.0,
                       JAVA, VLSI Chip Design, VHDL, Assembly Language, Shell & System
                       Programming in UNIX, AS 400 System Programming, Lotus Notes, Lotus Script,
                       EJB, Java, JMS, Web logic server 6.0, J2EE.Cold Fusion, Flash, Quark etc.
Operating Systems: Windows’ 95/98/NT/2000/XP/ME, MS-DOS, Macintosh, UNIX, Sun Solaris.
Database:              Oracle 9i/8i/8.0/7.3, MS SQL Server 2000/7.0/6.5, MS Access 7.0/’97/2000, DB2
                       UDB7.2/6.0, Sybase12.0/11.x.
Business Intelligence: COGNOS-Impromptu, Power play, Power play Transformer, Cognos query, Power
                       Prompt, Cognos Upfront, Visualizer, Access Manager, Cognos Architect, IWR,
                       Scheduler, Cognos Finance and Business Objects, Informatica and Crystal Reports.
OLAP Servers:          Oracle Express, MS SQL 2000 Analysis Server, SAS MDDB Server and MS-DTS.
Data Modeling:         Erwin 3.5.
Resume of BIRAL PATEL

BI Tools:               COGNOS EP Series Ver.7.0, Power Play, Transformer, Impromptu, Impromptu
                        Web Reports (IWR), Visualizer, Notice Cast, Upfront, Access Manager.
Data Warehousing:       Informatica Power Center 6.1/5.1.2/1.7, Power mart 6.1/5.1.1/5.0/4.7 (Source
                        Analyzer, Data warehousing designer, Mapping Designer, Mapplet,
                        Transformations), ETL, Data Mining, Data mart, OLAP, OLTP, SQL*Plus,
                        SQL*Loader.
PROFESSIONAL EXPERIENCE:
Sep ‘03 – Present                                                               MediaCom Corporation
Sr. Solutions Developer, Cognos & Business Analyst                              Middletown, NY

Responsibilities:
 Developing Cognos Impromptu and Powerplay reports over Microsoft SQL Server database.
 Designing and building Cognos Powerplay Cubes and setting up automated update scripts.
 Creating Catalog in Impromptu Administrator to create Reports.
 Involved in all aspects of impromptu, from connecting to the corporate database to setting up Effective
   catalogs, joins, folders, and filters, to ensure that adequate security procedures are in place.
 Written macros for Automation process for all reports and this report contains multiple Prompts.
 ?Responsible for requirement definition, analysis, scope and time estimation in addition to the building
   of cubes, scripts, reports and queries. ???Created Views from Data Mart for various reports.
 Creating SQL Server 2000 DTS Packages and Scheduling.
 Writing Stored Procedures, Triggers and Functions using SQL Server 2000.
 Working on Data Mart and Data Designing. & Power Prompts to User Defined Filters.
 Developed the OLAP cubes and Created dimensions, levels and hierarchies.
 Involved in Report Administration and server Administration. Hanging Reports from one Catalogue
   to another Catalogue. Creating various Drill through reports from report to report.
 Deploying Power Cubes on Cognos Power Play Enterprise Server. Used slice and dice techniques
   for use in creating ad hoc and standard reports using Multidimensional cubes.
 Providing data analysis and feedback on electronic transaction accounts.
 Developing Oracle SQL scripts to provide data mining capability for Excel reports.
 Design, developing and building built a server using Microsoft IIS to host Cognos Web Reports.
   Maintaining Cognos IWR as administrator capacity.
 Development and Maintenance of Cognos Web Server. Also developing Cognos Impromptu Reports.

Environment: COGNOS Impromptu, Powerplay, Dashboard, Shuttle Distributor, IWR, UNIX, Oracle 9i,
             PL/SQL, Microsoft SQL Server 2000, OLAP etc.

Jan ‘03 – Aug ‘03                                                                       Mega Hut
Data Warehouse Consultant/DBA                                                           Jersey City, NJ

Responsibilities:
 Involved in the process design documentation of the Data Warehouse Dimensional Upgrades.
 Involved in Installation of Cognos Impromptu, Power Play, Impromptu Web Reports.
 Created Catalog in Impromptu Administrator to create Reports.
 Created Cubes by using Cognos Power Play Transformer.
 Involved in all aspects of impromptu, from connecting to the corporate database to setting up Effective
   catalogs, joins, folders, and filters, to ensure that adequate security procedures are in place.
 ???Extensively involved with Cognos Support Partners regarding requirements and project issues.
 Responsible for requirement definition, analysis, scope and time estimation in addition to the building of
   cubes, scripts, reports and queries. ???Created Views from Data Mart for various reports.
                                                                                                          2
Resume of BIRAL PATEL

   Worked on Data Mart and Data Designing. Created Power Prompts to User Defined Filters.
   Generated reports using Cognos Impromptu tools querying database.
   Developed the OLAP cubes and Created dimensions, levels and hierarchies.
   Involved in Report Administration and server Administration. Hanging Reports from one Catalog to
    another Catalog.
   Created various Drill through reports from report to report.
   Deployed Power Cubes on Cognos Power Play Enterprise Server. Used slice and dice techniques for
    use in creating ad hoc and standard reports using Multidimensional cubes.
   Primarily responsible for developing specs and coding oracle procedures, functions, Triggers, Unix
    Shell scripts.
   Involved in fixing invalid Mappings, testing of Stored Procedures and Functions, Unit and Integration
    Testing of sessions, Batches and the Target Data.
   Used Business Objects Designer, Reporter and Supervisor.
   Analyzed the existing database and designed the Universes using Business Objects Designer Module.

Environment: Cognos (Impromptu & Power Play, Transformer, Access Manager, Upfront, Power Prompt,
             Cognos Query, Cognos Architect, Power play Enterprise Server, IMR, IWR), Sun Solaris
             2.6, Java, SOAP, Windows NT, Teradata, Oracle, XML, XSL, Excel, HTML, SQL
             Navigator, SQL * Plus, PL/SQL, UNIX Shell Scripting, Oracle 9i, Microsoft SQL Server
             2000.

Jan ‘02 – Dec ‘02                                                               NDP Cosmic Systems
Data Warehouse Developer                                                        Norwalk, CT

Responsibilities:
 Retrieving tables, Database Alias and Catalog keys using Impromptu.
 Created Multi-Dimensional Cubes and Reports as per the User Requirements
 Creation of extraction transformation loading model using Cognos Decision Stream 6.5
 Created Star Schema using fact and dimension Tables
 Created dimensions, levels and hierarchies.
 Developed the job streams for scheduling the jobs.
 Created data aggregation, data extraction, and data staging using Cognos Decision Stream 6.5
 Written macros for Transformer model, which adds the security to the model based on the information
   in the impromptu report files.
 Responsible for requirement definition, analysis, scope and time estimation in addition to the building of
   cubes, scripts, reports and queries.
 Developing a Join strategy, Analyzing and testing.
 Identification of the data sources required.
 Creating User Classes, Catalog Prompts conditions and Calculations.
 Developed the OLAP cubes.
 Created Templates for the users.
 Performed Table Weighting, Query Performance, Client server balancing
 Created standard and ADO reports using Impromptu.
 Generated reports using Cognos Impromptu tools querying database.
 Published impromptu reports to web using IWR.
 Customized data by adding calculations, summaries and functions,
 Created list reports and cross tab reports and drill through reports
 Queried from different database tables as per the requirement.
 Created / enhanced catalogs and set User profiles to grant user permissions for querying.

                                                                                                          3
Resume of BIRAL PATEL

   Created different joins according to User requirements.
   Created power play cubes using Transformer (Power Play).
   Created and enhanced existing power cubes as per user requirement.
   Developing and Customizing Impromptu Reports, IWR:
   Used Cognos distribution shuttle builder to Package Impromptu reports and their supporting files
    (IWR)
   Using Portfolio, reports were presented, Created List Reports and Cross Tab Reports and Drill
    Through reports.
   Generated reports using Cognos Impromptu tools querying database.
   Changing Reports from one Catalogue to another Catalogue.
   Created reports in HTML format for easy navigation of data from web browser.
   Developed Impromptu Web Reports and published using Upfront.

Environment: Cognos Architect, Cognos Impromptu, Cognos PowerPlay, Cognos Visualizer, Cognos
             Decision Stream 6.5, Cognos PowerPlay Transformer, Cognos PowerPlay Enterprise Server,
             Cognos Upfront, Microsoft IIS, Oracle 8.0, SQL Server, HTML, MS-Access, MS-Excel,
             Unix, Windows NT

May ‘01 – Dec ‘01                                                            Johnson & Johnson
Programmer/Analyst                                                           North Brunswick, NJ

Responsibilities:
 Involved in designing warehouse database using SQL Server and mapped to Data marts.
 Involved in developing Data Marts for Budgets, Profit and Loss Accounts, ratio Analysis.
 Involved in developing Stored Procedures using PL/SQL to automate the data loading process from
   ORACLE to Data marts
 The reporting tool used was Cognos. The reports were classified into simple report, analysis report,
   statistical report, and statement reports.
 Functioned as Impromptu Administrator for making catalogs for reporting purpose.
 Also developed the reports by retrieving the data from .cat file to make list or cross-tab report.
 Used Impromptu to make .iqd file, which is used in Cognos Transformer to make a Power Cube.
 Involved in performing Administrative tasks like user authentication, creating new users for the cube.
 Used Cognos PowerPlay to analyze, display and present the Cube data in different types of charts.
 Drill down, Slice and Dice and filtering operations done for all OLAP applications.
 Coordinated in training sessions and demonstration of Cognos tools to End-users.
 Assisted users in troubleshooting their reports.

Environment: Cognos Impromptu, Cognos PowerPlay6.5, Cognos Transformer6.5, Decision Stream,
             Erwin4.0, SQL Ser 7.0, OWB, Oracle8.0, Ms Access, Unix and Windows NT

Oct ‘00 – Apr ‘01                                                                    BBUSA Inc.,
Informatica Developer                                                                Norwalk, CT

Responsibilities:
 Studying the existing environment and accumulating the requirements by querying the Clients on
   various aspects.
 Identification of various Data Sources and Development Environment.
 Used Informatica Designer to create mappings, mapplets, transformations, and target tables.
 Used Informatica server Manager and server to read data from sources to write to target databases,
   manage sessions and to monitor server ETL Implemented for Oracle Server.
                                                                                                      4
Resume of BIRAL PATEL

   Worked as a team member for design and development of Finance Data Mart and integrating it with
    Global Data Warehouse.
   Worked extensively with mappings using expressions, aggregators, filters, lookup and procedures to
    develop and feed Data Mart.
   Extensively used Server Manager for creation and scheduling various sessions.
   Performing the Analyze scripts depending on the amount of work done on daily basis to enhance the
    performance of Informatica.
   Taking the Backup of Repository on regular intervals depending on the amount of work done.
   Analyzed the existing database and designed the Universes using Business Objects Designer Module.
   Created number of standard reports and queries based on the existing classes/objects using COGNOS.

Environment: Oracle 8i, PL/SQL, MS SQL Server 2000, Cognos, Informatica, Business Objects.

Nov ‘99 – Sep ‘00                                                   University of Bridgeport, CT
MS SQL Server DBA

Responsibilities:
 Responsible for Installation and Configuring the MS SQL Servers 7.0.
 Created and Altering the Databases.
 Setting Alerts and jobs.
 Responsible for Backups and Restores.
 Performed query tuning.
 Managing Disk space, memory and user connections.
 Running DBCC checks and fixing data corruption in Application databases.
 Data transfer using DTS.
 Performing query plans and making sure each and every query is using appropriate indexes.
 Created Stored procedures and Triggers related to application purpose using T-SQL.
 Periodic review of performance of the systems.
 Reevaluated indexing strategies and made needed modifications.
 Recommended improvements to existing application’s code to meet performance and scalability
   requirements
 Performance monitoring and trouble-shooting in SQL Server.

Environment: MS SQL Server 7.0, T-SQL, Win NT, MS-DOS, WINDOWS 98/NT

Jun ‘98– Aug ‘99                                                            JetKing, Baroda, India.
Programmer- Oracle PL/SQL

Responsibilities:
 Created temporary tables, indexes automated copying from master tables.
 Wrote complex SQL queries for generating SQL*Plus reports.
 Wrote stored program units for retrieving desired data from Oracle databases.
 Wrote complex SQL queries for generating SQL*Plus reports.
 Wrote stored program units for retrieving desired data from Oracle databases.
 Created various report using Developer 2000(Forms 4.5/5.0, Reports 2.5/3.0), including Drill down
   reports.
 Wrote Unix Korn Shell scripts to automate table creation, execute procedures etc.
 Wrote API’s in Pro*c which will interact with Oracle Advanced features of external functions.


                                                                                                      5
Resume of BIRAL PATEL

  Involved in creating Cron jobs for scheduling to run shell scripts on particular date and time through
   Autosys software.
 Created various reports using Developer/2000 to identify how many socs sold, dealer codes, billing
   accounting information, soc effective dates, activation dates etc. by selecting different options like sub
   market, soc, dealer codes, soc effective date for different date ranges through user parameters.
Environment: Oracle 8i, Reports server, SQL*Plus, Pro*C, Developer/2000, Designer 2000, TOAD, Autosys,
               PL/SQL, Shell Scripting, Stored Procedures/Triggers, Sun Solaris 5.6, HP 11.0

Jun ‘96 – May ‘98                                                              PKD Ltd., Baroda, India.
Programmer- Oracle PL/SQL

Responsibilities:
 Thorough involvement in writing, maintaining, testing, debugging, performance tuning, documenting
   Oracle SQL queries, Pl/Sql packages, procedures, functions and database triggers.
 Extensive use of reference cursors and dynamic SQL in coding of the Oracle PL/SQL packages,
   procedures, functions and database triggers.
 Recommending indexes and creation of temporary lookup tables, views, metadata tables, etc.
 Running data constraint checks on data in the development Oracle database thereby cleaning the data for
   subsequent transfer to the QA and Production Oracle databases.
 Close interaction with the QA department for removing bugs identified in the existing code.
 Provide production support to the existing clients as well as during User Acceptance Tests for new
   clients.
 Using SSH Secure Shell to keep track of DB. Log and identify and remove errors if any pertaining to the
   database aspect of the software.
 Helping the Sr. DBA in data migration from DBII to MS Access as well as from MS Excel and
   subsequently to Oracle 7
   As well as assisting the Sr. DBA in creating ER diagrams of the existing database schemas using
   ERWIN. Also brief hands on experience with Oracle DBA Studio and SQLPlus Worksheet.
 Loaded the data into the database using SQL*Loader.
 Wrote triggers, procedures, functions and packages to reflect low stock, royalty etc.
 Performed DBA functions: Installation, creating user accounts, roles.

Environment: Oracle 7 PL/SQL, Stored Procedures, Triggers, Windows 2000, Java 1.2, MS Access 97,
             MS Excel, SQL*Loader, Unix

EDUCATION:
Master’s Degree in Computer Science. University of Bridgeport, Bridgeport CT.
Bachelor’s Degree in Computer Science. University of Bridgeport, Bridgeport, CT
Associate's Degree in Engineering. M.S. University of Baroda, India.




                                                                                                         6

				
DOCUMENT INFO
Description: Informatica Etl Olap Resume document sample