We provide IT Staff Augmentation Services!

Production Specialist Resume

Dallas, TX

SUMMARY:

  • Over 16 years of development experience to include over six years of Informatica ETL.
  • Extensive Extract Transform and Load (ETL) and a solid understanding of Data Warehousing.
  • Over six years of experience in analysis, design, development, customization, testing, implementation, support and user training of Software applications.
  • Three years supporting Cognos Suite, OLAP/Data Warehousing, reporting tools of Impromptu Administrator, Powerplay, Transformer, Access Manager, Impromptu Web Reports (IWR), Powerplay Cubes, Upfront, Cognos Scheduler, and Informatica.
  • Good experience in Cognos 8, Cognos ReportNet Cognos connection, Query Studio, Report studio, Framework Manager .
  • Good understanding Physical and Logical Data Modeling using Erwin.
  • Worked in various industries to include Financial Services, Retail, Telecommunications, Healthcare, Education, Travel and Manufacturing.

TECHNICAL SKILLS:

BI Tools: Cognos 8, 10 Connection, Query Studio, Report Studio, Framework Manager, Cognos Suite, Scheduler, Impromptu Web Reports (IWR), Upfront, Cognos Impromptu 7.x/6.x, PowerPlay 7.x/6.x, Access Manager

ETL Tools: Informatica 10.x/9.x/7.x/6.2/5.1, Data Modeling Erwin 3.5.2

Languages: Java, JavaScript, HTML, XML, SQL, PL/SQL

Operating Systems: Windows 98/NT/2k/2003/XP, Unix

Testing Tools: LoadRunner 7.x/6.x/5.x

Web Servers: SunOne and Web Servers

Databases: Oracle 9i/8i, SQL Server 7.x/2000, MS Access

PROFESSIONAL EXPERIENCE:

Confidential - Dallas, TX

Production Specialist

Responsibilities:

  • Developed interactive live reports using Power BI.
  • Produced Impromptu reports.
  • Produced and published packages.
  • Used Erwin for data modelling.

Confidential

ETL Informatica Developer

Responsibilities:

  • Extraction of Teradata and Oracle 11g relational database.
  • Analyzed relationships of Flat Files and to extract teh analyzed systems, met with end users and business units to define teh requirements.
  • Documented user requirements, translated requirements into system solutions and develop implementation plan and schedule.
  • Extracted data from excel files, high volume of data sets from data files, Oracle, DB2, SalesForce.com (SFDC) using Informatica ETL mappings/SQL PLSQL scripts and loaded to Data Store Area.
  • Developed data Mappings between source systems and warehouse components.
  • Developed ETL procedures to ensure conformity, compliance with standards and lack of redundancy, translates business rules and functionality requirements into ETL procedures.
  • Developed and tested all teh backend programs, Informatica mappings and update processes.
  • Created and Monitored Batches and Sessions using Informatica PowerCenter Server.
  • Responsible to tune ETL procedures and STAR Schemas to optimize load and query performance.
  • Extensively worked in teh performance tuning of teh programs, ETL Procedures and processes.
  • Written documentation to describe program development, logic, coding, testing, changes and corrections.
  • Created adhoc reports to users in Tableau by connecting various data sources.
  • Handled Tableau admin activities granting access, managing extracts and Installations.
  • Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
  • Published Workbooks by creating user filters so dat only appropriate teams can view it.
  • Embedded Tableau views in to SharePoint.
  • Analyzed teh source data and handled efficiently by modifying teh data types.
  • Used excel sheet, flat files, CSV files to generated Tableau adhoc reports.
  • Generated context filters and used performance actions while handling huge volume of data.
  • Generated tableau dashboards for sales with forecast and reference lines.

Tools: and Environment: Informatica PowerCenter 9.1, Oracle 11g, Tableau (7.x), PL/SQL, Flat Files, MS Access, XML, Windows, Informatica 10.

Confidential

Cognos Developer

Responsibilities:

  • Involved in design and development of user classes, joins, filters, calculations, prompts and conditions in Catalogs in Impromptu Administrator.
  • Created various report types like simple reports, cross tab, sub reports, dashboard and drill through dat cover teh entire range of enterprise reporting requirements.
  • Teh reports output desire was in Excel sheets with format, so they could archive it and if required they could manipulate data, which is useful to them.
  • Dealt with highly complex business logic, and a complex data sources to meet business requirements.
  • Created various reports (List, Cross tab, Mailing Labels, Form Letter, Free Style) using Cognos Impromptu tool by querying teh database.
  • Enabled users to access teh distributed HTML reports through local network intranet/internet, and via email.
  • Generated reports as per teh requirements using Cognos Impromptu.

Environment: COGNOS (Impromptu Administrator, PowerPlay, Transformer, Access Manager, Cognos Script, Scheduler, Server Administrator, MS SQL Server 2000, Informix, MS Access, Informatica (PowerCenter/PowerMart), Commercial ware, CW Direct Web Applications 7.5, Visio, UNIX Sun Solaris, AS 400, IBM iSeries Access for Windows and Windows XP Professional.

Confidential

ETL Informatica/Cognos/ReportNet Developer

Responsibilities:

  • Worked closely with client resources to understand, gather, document business requirements, develop technical specifications, recommendations on teh preferred solution for development, deploy efficient BI solutions
  • Involved in teh analysis, design, develop, testing of analytical & transactional reporting systems and user training.
  • Involved in building models, packages using Framework Manger and published teh packages to ReportNet Server.
  • Used Cognos Connection to administer and scheduling reports to run at various intervals as well as teh ReportNet Server.
  • Created list reports, cross tab reports, chart reports and reports with lot of conditional formatting using Report Studio.
  • Created Query Prompts, calculations, Conditions using Report Studio.
  • Used Framework Manager to administer security.
  • Scheduled reports to run on a monthly, weekly, and daily basis using Cognos Connection Scheduler.
  • Involved testing, validation and documenting test results
  • Involved in teh process of design, develop and testing ReportNet reports

Environment: Cognos ReportNet 1.1/1.0 (Framework Manager, CognosConnection, Cognos Configuration, Report Studio and Query Studio) Informatica 6.2 Cognos Series 7.3 (Impromptu, PowerPlay, Access Manager, IWR Server, PPES) Business Objects, Oracle 10g, SunOne Web Server, Directory Server, Windows 2000 Prof and UNIX.

Confidential

ETL Informatica Developer

Responsibilities:

  • Financial transformations for teh administration responsible for all financial logic transactions in Informatica.
  • Creating folders, user groups and users within them and assigning selective privileges and permissions.
  • Involved in Training Business Users on IWR (Impromptu Web Reports).
  • Used Informatica Designer to develop jobs for extracting, transforming, integrating and loading data to targets.
  • Involved in development of Informatica Jobs with required Transformations like Aggregator, Filter, Expression, Lookup, and Sorter Transformer etc.
  • Did teh scheduling according to teh requirement as daily, weekly or monthly basis depending on teh precedence diagrams, Metadata reporting.
  • Gatheird requirements, analyzed requirements, prepared technical documentations for Corporate Reporting Project.
  • Designed Impromptu catalogs and created reports using Impromptu Administrator
  • Created models using PowerPlay Transformer to build multi-dimensional cubes

Environment: Windows/Unix, Oracle 9i, Informatica 5.1/6.2, Workflow Manager, and Workflow Monitor, Toad, Erwin

Confidential

ReportNet Developer/Administrator

Responsibilities:

  • Interaction with management and development teams in gathering information for creating Framework Packages.
  • Worked extensively in creating models and publishing teh packages on Cognos Connection for reporting purposes.
  • Imported teh Metadata from Third Party tools.
  • Created teh cubes with halp of Framework Manager to change teh Source Hierarchy.
  • Created filters within teh Model for improving performance of teh Model.
  • Involved in designing and creating various projects in Framework Manager.
  • Involved in designing models using Framework Manager.
  • Created various packages using Framework Manager in ReportNet.
  • Involved in migrating catalogs into report net using migration utility.
  • Created Multi Lingual packages for various Geographic Locations.
  • Used Cognos Connection to administer and scheduling reports to run at various intervals as well as teh ReportNet Server.
  • Set security for individual reports in Cognos Connection.
  • Scheduled reports to run on a monthly, weekly, and daily basis using Cognos Connection Scheduler.
  • Bursting Reports and Multilingual Reports Using Report Studio.
  • Created list reports, cross tab reports, chart reports and reports with lot of conditional formatting using Report Studio.
  • Created Query Prompts, calculations, Conditions & Filters, Prompt Pages using Report Studio.
  • Created various prompts like value prompt, search prompt, date, etc.
  • Involved in scheduling Report Studio and Query Studio reports and sending reports via email to several business users.
  • Trained power users to use Query Studio for Ad-hoc reporting.
  • Involved in migrating Impromptu reports to ReportNet.
  • Involved in teh analysis, design, develop, testing of analytical & transactional reporting systems and user training.
  • Involved in setting up Groups/Roles to secure teh Models and packages
  • Involved testing, validation and documenting test results.
  • Extensively used Informatica Workflow Manager and Workflow Monitor for creating and monitoring workflows, worklets and sessions.
  • Extensively used transformations like lookups, update strategy, sorter, expression, aggregator.
  • Assist teh ETL architect on teh design of star schema, fact and dimension tables required for OLAP and reports in conjunction with ETL team Moved projects from development to production servers.

Environment: Cognos 8 & 10, Framework Manager, CognosConnection, Query Studio, Report Studio, Cognos Configuration, Cognos Scheduler, CognosSeries 7.x, Access Manager, Impromptu IWR, Upfront, Oracle9i, Informatica 7.1/6.2, MS SQL Server 7.0/2000, Erwin, SunOne Web Server, Windows 2000 / Pro and UNIX.

Confidential

Cognos/ReportNet Developer

Responsibilities:

  • Worked closely with client resources to understand, gather, document business requirements, develop technical specifications, recommendations on teh preferred solution for development, deploy efficient BI solutions.
  • Involved in teh analysis, design, develop, testing of analytical & transactional reporting systems and user training.
  • Involved in building models, packages using Framework Manger and published teh packages to ReportNet Server.
  • Used Cognos Connection to administer and scheduling reports to run at various intervals as well as teh ReportNet Server.
  • Created list reports, cross tab reports, chart reports and reports with lot of conditional formatting using Report Studio.
  • Created Query Prompts, calculations, Conditions using Report Studio.
  • Used Framework Manager to administer security.
  • Scheduled reports to run on a monthly, weekly, and daily basis using Cognos Connection Scheduler.
  • Involved testing, validation and documenting test results
  • Involved in teh process of design, develop and testing ReportNet reports

Environment: Cognos ReportNet 1.1/1.0 (Framework Manager, CognosConnection, Cognos Configuration, Report Studio and Query Studio) Informatica 6.2 Cognos Series 7.3 (Impromptu, PowerPlay, Access Manager, IWR Server, PPES) Business Objects, Oracle 10g, SunOne Web Server, Directory Server, Windows 2000 Prof and UNIX.

Confidential

Java PL/SQL Developer

Responsibilities:

  • Developed Model-controller for assigned use-cases.
  • Developed Oracle stored procedures.
  • Developed JSPs to test teh module.
  • Developed Struts configuration files.
  • Unit and Integration test of teh Presentation JSPs with teh Model-Control.
  • Assembly test teh use-case on WebLogic Application Server

Confidential

Java & LDAP Developer

Responsibilities:

  • Analysis of existing system and refactoring to implement MVC pattern and Struts.
  • Provide support and noledge for development LDAP.
  • Development: Architecture classes for LDAP connectivity and access, Data access objects and beans, Subscriber Transfer of Service use case action, conversation and channel classes and jsps, JUnit test classes for all teh classes specified above.
  • Testing teh use cases: Using JUnit test teh classes, Configure own workstation and assembly test entire use case. Assembly test teh entire package.

Hire Now