We provide IT Staff Augmentation Services!

Data Modeler / Data Architect Resume

Cincinnati, OH

OBJECTIVE:

Seeking a challenging position in IT, R & D |Data Governance | Data Quality | Data Modeling | MDM|DWH | BI | Visualization | Analytics. Excited to learn and adapt the new technologies as and when needed in a fast pace. Highly motivated to excel in DW, ERP and CRM arena

SUMMARY:

  • Started career with RTB (Run the Business) and now working on CTB (Change the Business). Extensive work experience in USA and short term project in Middle East
  • 21+ years of experience in various roles like Sr. Architect /Practice Manager - Technical /Project Manager /Data Modeler / DWH Architect / BA /Technical Lead /Sr. ETL Developer /SAP Functional Analyst /PeopleSoft Consultant and Sr. Exe Customer Support In-Charge.
  • Gathered requirements by interacting with end users, analyzed, modeled requirements and documented as per the CMM standard and managed application development through Software Development / Data Warehouse Life Cycle (SDLC / DWLC) from User Requirement, Design, and Data migration, Testing, Implementation, Training and Support.
  • Governance, Regulatory Risk & Compliance (GRC) /ecommerce & Retail /CFS /Telecom /Logistics /Semi-Conductor & IT / Life Sciences, Healthcare & PBM
  • /Petroleum Gas & by products Production / Mortgage
  • HRMS: Payroll, Time & Labor / CRM: Air Travel Reservation & CRS.
  • Ability to work well in a broad-based inter-departmental team with a broad spectrum of staff (Architects, Designers, Project / Program Managers, Customer & Stakeholders, QA and Functional Managers)
  • Strong leadership and decision-making skills.
  • Ability to take both technical direction, make technical decisions and ability to negotiate to develop win-win situation.
  • Excellent customer management, strong negotiation and business communication skills.
  • Ability to develop and present executive level presentations.
  • Excellent self-management skills to work independently with minimal supervision, collaborative, imaginative, resourceful, and reliable technology savvy.
  • Developed, modified, maintained distributed project documentation, project communications and inter-team knowledge transfers.
  • Ability to manage projects aligned with business and IT strategy and in compliance with the organization’s architectural standards like SEI-CMM, 6 , ISO, Agile, PMP and other International Quality Standards.
  • Worked on Onsite - Offshore and vice versa.
  • 12+ years of experience in Business analyst / Project Management, handled 1-2$ million projects, Pre-sales, RFP, RFI & RFQ.
  • 15+years of experience in EDLM (Enterprise Data Life Cycle Management), ILM (Information Lifecycle Management)
  • 15+years of experience in Data Consolidation, Data Migration, Data Governance, Data Quality, Data masking activities.
  • 15+years of experience in Data Modeling (CA-ERWin/ MS-Visio) OLTP (On Line Transaction Processing) / OLAP (Online Analytical Processing),3rd Normal Form, Corporate Data Model, Conceptual, Logical& Physical Model Designs.
  • 15+years of experience in different databases like MySQL, Oracle, SQL Server, DB2, Teradata MPP and MS-Access2000.
  • 14+years of work experience in DWH / BI with Informatica / IBM Infosphere DataStage / BO / Cognos / SSIS.
  • Experienced in using TOAD, PL/SQL Developer and Win SQL and Handled data’s in large & complex data sets, data movements, data security in Terra bytes.
  • Research or experience in manipulating and analyzing complex, high-volume (VLDB, large data sets), high-dimensionality data from varying sources.
  • Optimize, expand and transform the data and present it effectively through the lens of information.
  • Experienced in Data Warehouse Re-engineering and worked on Forward / Reverse Engineering in Data Modeling.
  • 5+years on Master Data Management (MDM) on Registry, Repository and Hub (Hybrid) Models.
  • Good knowledge in Data Warehousing Concepts (Kimball and Inmon data warehouse Kimball and Inmon philosophies, STAR, Snow Flake Schema and Galaxy Schema, Staging area, SCD Type 1, 2, 3, 6, Granularity, Dimension, Confirmed Dimensions, Fact &Factless Fact, Metadata, Dimensional Modeling, Bus Architecture/ UDM (Unified Dimensional Model),3rd Normal Form, Conceptual, Logical & Physical Designs.
  • Worked on heterogeneous sources, developed common reusable transformations and Mapplets logic to reduce the cost of Development time & efforts.
  • Worked on Informatica, Cognos Cloud for Confidential, Belgium.
  • Having fair knowledge on Big Data, Data Patterns and Predictive Analytics.
  • Having knowledge on IaaS & PaaS.

TECHNICAL SKILLS:

DBMS & RDBMS: Teradata 14 V2R5/ Oracle 7.x / 8.x / 9.i / 10g , SQL Server 2005, 2012 , MySQL, DB2, Access and Foxpro-2.5.

Teradata Tools: BTEQ, FastLoad, FastExport, MultiLoad, and Teradata SQL Assistant

ETL& DWH : Informatica 6.x / 7.x / 8.x / 9.x,10 Designer / Workflow Manager / Workflow Monitor / Repository Manager, SAP BO Data Integrator 11.5-XI R2 / Designer / Confidential DTS / SSIS 2008 R2 / SAS EG 4.3 / IBM Data Stage 8.x, 9.5 Infosphere, DM Express 6.5

BI& OLAP : Crystal 8 , IBM Cognos 10.1.1 / 8.4 / Framework Manager / Report Studio / Query Studio

Tools : Toad , Win SQL 5.0, SQL Data Modeler 9.1 , ER Win 3.0, 4.0, 9.0, Visio, and UML Enterprise Architect, IBM Web Logic Web Content, Version 1 , SmartSheet .

MDM : Stratature - EDM 4.1 ( Confidential MDS) / Talend 5.4 ,Talend Open Studio (TOS) Data Integration, Talend Integration Suite (TIS), Informatica DI / IDQ V8.0 , IBM Infosphere Data Stage MDM V8.0, 9.5

ERP : SAP ver. 4.6 C HR ASAP Methodologies / People Soft ver. 7.5 / 8.0 HRMS, Oracle eBusiness

(People Tools, People Code, SQR, Application Engine, PS-Query, Data Mover, Import Manager, Security Administrator):

Testing : HP Quality Center ALM 11 , QTP 9.2

O/s : Windows Family, UNIX and Dos / Packages MS-Office & Adobe.

PROFESSIONAL EXPERIENCE:

Confidential, Cincinnati, OH

Data Modeler / Data Architect

Responsibilities:

  • Architecture Design and Planning ( Logical Data Model / Physical Data Model)
  • Managing large entities models (e.g. more than 100+ entities )
  • Designing the models as per Confidential Health best practices.
  • Database DDL, DML for designs execution scripts.
  • Co-coordinating production move on every sprint.
  • Troubleshooted database which has issues and causing the problems .

Environment: SQL Data Modeler 9.1, MySQL, MS Office, and Windows XP Professional.

Confidential, Herndon, VA

Informatica/Data Architect

Responsibilities:

  • Done design code reviews , suggested changes, industry standards and best practices
  • Worked on PowerCenter client tools Designer and Talend Design Studio, Workflow Manager, and Workflow Monitor for designing and scheduling mappings for data movements .
  • Defined conversion process to transform the data from Source to Target (Data Cleansing , Profiling)
  • Extracted data from CMDB , legacy Sources, Flat files transformed and loaded into database Targets using Power Center tools.
  • Used shortcuts to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically. It reduced the cost of Development time
  • Mapping was designed in such a way to capture Meta Data for analytics purpose
  • Used Workflow manager / Monitor for Workflow , Session Monitoring , and database connections
  • Worked on UNIX Scripts for copying / moving raw Workday HR files.
  • Worked on CMDB , DB Server databases for validating the results and finding the root causes.
  • Managed Meta data management in Informatica.
  • Worked on MFT servers for file verification and validation.
  • Managed large entities models (like more than 190 entities )
  • Worked on Blade Logic ( BMC ) for scheduling the jobs, root cause analysis, failures and fixes.
  • Worked on production failures & fixes.
  • Troubleshooted / Root Cause analyzed for Servers / databases which had an issues and fixed.
  • Converted business process into structured projects with deliverables identified (mapping specification and data dictionary).
  • Done design code reviews for data model , mappings and & testing reviews, suggested changes, industry standards and best practices.
  • Troubleshooted / Root Cause analysis for Servers / database which has issues and causing the problems and given solutions .

Environment: Informatica PowerCenter 9.6.1, Visio, ER Win 9.0, Confidential Share Point, SQL Server 2012, Oracle 11g & 12c, Sybase 9.6, DB2, ServiceNow, Workday, CMDB, DBServer, MFT Server and MS Office Windows XP Professional.

Confidential, Chicago, IL

Data Architect - MDM Consultant

Responsibilities:

  • Analyzed Customer , Carrier & Geography , suggested the key columns for x-references , and x-references solutions on other entity mappings
  • Done design reviews , suggested changes, industry standards and best practices
  • Analyzed and handled meta data management in various source and target systems
  • Worked stories and sprints on agile methodology
  • Architecture Design and Planning ( Logical Data Model / Physical Data Model)
  • Worked on Power Center client tools Designer, Workflow Manager, Workflow Monitor
  • Used passport provision for password change in Informatica.
  • Defined conversion process to transform the data from Source to Target (Data Cleansing , Profiling)
  • Extracted data from legacy Sources, Flat files transformed and loaded into database Targets using Power Center
  • Used shortcuts to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically. It reduced the cost of Development time
  • Mapping was designed in such a way to capture Meta Data for analytics purpose
  • Managed large entities models (like more than 90 entities )
  • Used extensively Stored Procedure for creating/dropping of constraints
  • Used Workflow manager / Monitor for Workflow , Session Monitoring , and database connection
  • Done Unit Test Case, SOC, UTP, UAT and changes documentation
  • Moved mappings from Development to QA Stage

Environment: Informatica PowerCenter 10.1, Visio, ER Win 9.0, Confidential Project Server, SQL Server 2014 Enterprise, Version1, SmartSheet and MS Office Windows XP Professional.

Confidential, Pleasanton, CA

Data Governance Architect - MDM Lead

Responsibilities:

  • Studied the as-is business process and gathering system requirements by interacting with SME.
  • Overseen all technical aspects of the company's Integration &Development.
  • Implemented Data Governance, Policies, Standards, Best Practices & Processes
  • Defined Rules for Data Cleanse, Profile and De-dup process, Match & Merge Rules for volumes of complex data regardless of language, structure, duplication levels, omissions or errors.
  • Build solution for managing Products , Vendors & Customers , and worked on Reference Data , Metadata .
  • Build 360° Holistic View for Customer & Accounts for SalesForce .
  • Managed new Data request for ensuring proper decision-making on master data creation, data standardization, duplication checks, data field accuracy and completeness while meeting acceptable turnaround time. Complete large database cleanup projects to insure data integrity.
  • Integrated Loqate extensively to fix address issues.
  • Used audit trails and version control to track changes
  • Mentored Data team in their ongoing development issues & best-practices.
  • Managed Metadata .
  • Managed large entities models (like more than 75 entities )
  • Used tableau for data visualization.

Environment: Talend 5.4, Visio, SQL Server 2012 R2, Salesforce (SFDC), Tableau, PaaS, MS Office Windows XP Professional.

Confidential, Schaumburg, IL

Sr. ETL Lead - DM / DWH / BI

Responsibilities:

  • Studied the as-is business process and gathering system requirements by interacting with SME.
  • Overseen all technical aspects of the company's DWH / BI Development.
  • Assisted in the construction of a Data Warehouse, BI and analytics initiative
  • Helped in vendor management and relations, responsible for leading a small internal team and vendor based team
  • Build a small team , managed project timelines and budgets, and produced quality project artifacts
  • Managed and understood priorities of the project accordingly
  • Understood business objectives and problems
  • Worked with the multiple stakeholders for complex technical & non-technical problems
  • Automated wherever possible and suggesting solutions for automations.
  • Analyzed Data Growth volume in RxClaims (PBM) .
  • Build Roadmap and part of Data Governance .
  • Architecture Design and Planning ( Logical Data Model / Physical Data Model)
  • Proactively monitored and provided visibility to who uses which data at what time, to identify dormant and unused data
  • Done Data Masking in ETL using DataStage .
  • Used ETL for Medical Data’s transformation, applied data quality rules (Medical Data Cleansing, Profiling)from Source to Target
  • Used Informatica Passport feature for login and password change.
  • Data Masked for precaution from a business security standpoint and in many cases it was a legal obligation.
  • Defined Rules sets for Data Masking to run as and when necessary.
  • Configured persistent data masking & Subset to mask the sensitive data
  • Managed a team in offshore, done Onsite to Offshore smooth transition .
  • Studied the as-is business process and gathered system requirements by interacting with SME.
  • Overseen all technical aspects of the company's BI Development.
  • Worked on BI Development and Delivery .
  • Worked on Cognos 10.2 client tools.
  • Done Unit Testing and validated in line with design as well as preparing test data and managing .

Environment: Cognos 10.2 BI (Report Studio, FM), Netezza, Showcase, QlikView, Teradata 13 V2 R5, Windows XP Professional.

Confidential, MI

Sr. ETL Lead - DWH / Data Modeler

Responsibilities:

  • Studied the as-is business process and gathered system requirements by interacting with SME.
  • Developed new data models that support the ongoing growth of the business ensuring that model approvals.
  • Overseen all technical aspects of the company's DW Development.
  • Worked on DW Development and Delivery .
  • Architecture / ETL Model Design ( Snowflake schema design, Logical Data Model / Physical Data Model )
  • Worked on Data Stage client tools for Implementation of SCD Type II fact tables.
  • Implemented MDM Governance, Policies, Standards, Best Practices & Processes
  • Defined Rules and build MDM HUB Model solution for managing Products , Vendors & Customers .
  • Defined Rules for Data Cleanse, Profile and De-dup process, Match & Merge Rules for volumes of complex data regardless of language, structure, duplication levels, omissions or errors.
  • Build CC 360° for Product and Customer .
  • Managed Master Data Management request for new requests ensuring proper decision-making on master data creation, data standardization, duplication checks, data field accuracy and completeness while meeting acceptable turnaround time. Complete large database cleanup projects to insure data integrity.
  • Build Multi-Dimensional (Slice &Dice) Cubes for reports.
  • Used Informatica for Medical Data’s transformation, applied data quality rules (Medical Data Cleansing , Profiling)from Source to Target
  • Implemented Data Masking in ETL .
  • Created and Managed Metadata .
  • Managed large entities models (like more than 150 entities )
  • Data Masked for precaution from a business security standpoint and in many cases it was a legal obligation.
  • Defined Rules sets for Data Masking to run as and when necessary.
  • Configured persistent data masking & Subset to mask the sensitive data
  • Mentored EDW team in their ongoing development issues, best-practices, performance tuning etc.
  • Represented Solution to Prospects at Events
  • Assisted in the construction of a Data Warehouse, BI and analytics initiative
  • Helped in vendor management and relations, responsible for leading a small internal team and vendor based team

Environment: Informatica 9.x, IDD, Meta Data Manager, IDQ, DM Express 6.5, ER Win 8.x, SQL Server 2008, SSIS, SSRS, Cognos 10.2 BI, PaaS, Windows XP Professional.

Confidential, SC

Sr. ETL Lead - BI / Data Modeler

Responsibilities:

  • Developed new data models that support the ongoing growth of the business ensuring that model approvals.
  • Worked on Bus Architecture / Unified Dimensional Model ( UDM ).
  • Overseen all technical aspects of the company's BI Development.
  • SPOC (Single Point of Contact) for Confidential & Confidential from Technosoft Prospects on all BI activities.
  • Reviewed the existing product range and, through value- engineering , look for opportunities to reduce costs / improve efficiency.
  • Leaded / Worked on BI Development and Delivery .
  • Architecture Design and Planning ( Logical Data Model / Physical Data Model)
  • Developed Data Model for DWH / BI solutions associated with clinical trials (CTMS) and NDA submissions including
  • Designed mappings in such a way to do Data Cleansing and Profiling after data extraction from flat files
  • Used Informatica for Medical Data’s transformation, applied data quality rules (Medical Data Cleansing , Profiling)from Source to Target
  • Implemented Data Masking in ETL .
  • Data Masked for precaution from a business security standpoint and in many cases it was a legal obligation.
  • Defined Rules sets for Data Masking to run as and when necessary.
  • Configured persistent data masking & Subset to mask the sensitive data
  • Worked on Reference Data and Metadata for Data Integration .
  • Developed dashboard for Audit / Inspection Findings / CAPA / Training / Deviations / HAQ / PMC / CTA / CCDS / CMC based on Therapeutic Area / Region & Products .
  • Cognos Framework Model Design
  • Done POC / Prototype data models ( Confidential, USA / Johnson & Johnson, Belgium)

Environment: Cognos 10.4 BI on Cloud (Report Studio, FM), Informatica (ETL) on cloud 9.6, DM Express 6.5, ER Win 8.x, Oracle 9i, Pl-Sql Developer, PaaS, Windows XP Professional.

Confidential

Practice Manager - MDM - DWH

Responsibilities:

  • Studied the as-is business process and gathered system requirements by interacting with SME.
  • Worked on Data Stage 8 client tools.
  • Implemented MDM Registry Model and Governance, Policies, Standards, Best Practices & Processes
  • Defined Rules for MDM.
  • Managed Master Data Management request for new requests ensuring proper decision-making on master data creation, data standardization, duplication checks, data field accuracy and completeness while meeting acceptable turnaround time. Complete large database cleanup projects to insure data integrity.
  • Mentored EDW team in their ongoing development issues, best-practices, performance tuning etc.
  • Created folders, user groups and users within them and assigning selective privileges .
  • Mappings Optimized for performance and data movements scheduled.
  • Mentored EDW team in their ongoing development issues, best-practices, performance tuning etc.
  • Prepared Unit Test Cases and validated in line with design.
  • Architecture Design and Planning ( Logical Data Model / Physical Data Model)
  • Build Roadmap and part of Data Governance , data management strategy team
  • Build Current and Future state, Data Governance Processes, Policies Controls, and Standards in place.
  • Defined, designed, implemented data processes in place to satisfy Information Management as per the client organization policy standards
  • Implemented Data Masking in ETL .
  • Data Masked for precaution from a business security standpoint and in many cases it was a legal obligation.
  • Defined Rules sets for Data Masking to run as and when necessary.
  • Configured persistent data masking & Subset to mask the sensitive data
  • Created Frame Work Model (Star Schema) .
  • Designed various types of reports like List , Drill-through , Cross-tabs , Column charts & Bar charts.
  • Developed Detail and Summary reports based on management hierarchy with Drill Down and Drill through capability.
  • Developed reports using Master Detail Relationship .
  • Developed prompted reports using different prompts like Value Prompt , Date and Time prompt etc.
  • Developed reports using Conditional Layouts and condition expression like String Variable and Boolean Variable.
  • Enhanced Existing Reports as per change request .
  • Bursted reports based on hierarchy and groups. Bursting reports , event handling, scheduling jobs using CRN
  • Tested newly developed reports & enhanced existing reports.
  • Done Unit Testing and validated in line with design as well as preparing test data and managing .
  • Maintained documentation for each activity process.

Environment: IBM InfosphereDataStage8.x, DM Express 6.5, Cognos 8 BI (Report Studio, FM), ER Win 8.x, Oracle 10g, Teradata Decision Experts, Toad, Visio, Maximo, Confidential Project Server, Windows XP Professional.

Confidential, Palm Desert, CA

ETL / Data Warehouse Analyst /BA

Responsibilities:

  • Studied the as-is business process and gathered system requirements by interacting with SME
  • Extensively used Informatica Power Center 8.1 client tools
  • Designed folders, user groups and users within them and assigning selective privileges
  • Implemented CDC for complex fact tables
  • Informatica Mappings Optimized for performance and data movement scheduled in Informatica Workflows.
  • Used Informatica for Data’s transformation, applied data quality rules ( Data Cleansing, Profiling)from Source to Target
  • Applied Data Masking using Data masking tool.
  • Data Masked for precaution from a business security standpoint and in many cases it was a legal obligation .
  • Defined Rules sets for Data Masking to run as and when necessary
  • Organized Informatica backup and restores
  • Mentored EDW team in their ongoing development issues , best-practices, performance tuning etc
  • Monitored and identified long running queries and suggested to tune, optimize data warehouse design and query performance
  • Monitored, provided visibility to senior management who, when, which, what data used, to identify dormant and unused data by departments to prioritize resources
  • Done Unit Testing and validated in line with design as well as preparing test data and managing .
  • Designed Frame Work Model / Reports in Cognos as per the requirement (List / Cross Tabs )

Environment: Informatica PowerCenter 8.1.1, Cognos 8.3, Oracle 10g, Net 2000, Toad, Visio, Confidential Project Server, Windows XP Professional.

Confidential, Sammamish, WA

Business / Data Warehouse Analyst

Responsibilities:

  • Studied the as-is business requirement document which was prepared by SD, updated the earlier version of Functional Specification and preparing Functional Specifications for version 2.0 (Planning Hierarchy)
  • Served as a liaison between SD, Dev, Testing and OPS in order to implement corporate requirements
  • Mastered Finance as part of Master Data Management
  • Worked with versions, hierarchies , validations, properties and actions
  • Done design reviews , suggested changes, industry standards and best practices
  • Analyzed and handled meta data management in various source and target systems
  • Developed, presented POC for the requirements which is / was sent by SD (Solution Delivery)
  • Communicated effectively with all users, at different levels of hierarchy for all EDM related queries
  • Done Data analysis, Data Cleansing & Profiling
  • Worked on Reference Data and Metadata .
  • Managed large entities models (like more than 120 entities )
  • Implemented Change Data Capture for Planning Hierarchy
  • Created Functional Specification and Test Plan
  • Done Unit Test Cases / Test results reviews and Test Data Management.

Environment: Stratature - EDM, SQL Server 2005, Visio, Confidential Share Point, VSTF, Windows XP Professional.

Confidential, Columbia, SC

Sr. DWH Consultant

Responsibilities:

  • Studied the as-is business process and gathered system requirements , prepared documents and standards
  • Architecture Design and Planning ( Logical Data Model / Physical Data Model)
  • Coordinated the development effort with the system designers and developers
  • Entire migration process in place, it’s very helpful for project on-boarding
  • Build Roadmap and part of Data Governance , data management strategy team
  • Build Current and Future state, Data Governance Processes, Policies Controls , and Standards
  • Defined, designed, implemented data processes to satisfy Information Management as per the client organization policy standards
  • Used SSIS client tools to migrate data’s from flat files to SQL Server 2005
  • SSIS Mappings Optimized for performance and data movement scheduled
  • Designed mappings to do Data Cleansing and Profiling after data extraction from flat files
  • Implemented Data Masking in ETL .
  • Data Masked for precaution from a business security standpoint and in many cases it was a legal obligation.
  • Designed to capture Meta Data for auditing and reporting purpose
  • Managed large entities models (like more than 100 entities )
  • Prepared Test Data for rules and mapping validations.
  • Done Unit Test Cases and validated in line with design
  • Done SOC, UTP, UAT and changes as part of CFS (Child Support & Family Court System)

Environment: SSIS, DTS, SQL Server 2005, DB2, Visio, Confidential Share Point, QS/1 Mainframe, Windows XP Professional.

Confidential, Broomfield, CO

Lead - Informatica Consultant

Responsibilities:

  • Studied the as-is business process and gathered system requirements by interacting with SME
  • Served as a liaison between deployments, COE , offshore team, and functional team in order to implement corporate requirements for our Onsite - Offshore project Model
  • Coordinated the development effort with the Data Modeler , system designers and developers
  • Communicated effectively with all users, at different levels of hierarchy and provided technical support for all migration related queries
  • Worked on Informatica Power Center 8.1 client tools
  • Extracted data from Oracle , legacy Sources, XML & Flat files transformed and loaded into Oracle and Flat files Targets using Power Center
  • Implemented CDC for complex fact tables
  • Designed to capture Meta Data for analyzes and worked on Reference Data .
  • Worked Data Archiving and Data Subsets based on organization policy / standards as part of ILM (Information Lifecycle Management) .
  • Implemented Data Masking in ETL .
  • Data Masked for precaution from a business security standpoint
  • Defined Rules sets for Data Masking to run as and when necessary.
  • Informatica Mappings Optimized tuned for performance
  • Used Informatica for Data’s transformation, applied data quality rules (Data Cleansing, Profiling)from Source to Target
  • Handled large complex data sets, data movements & data securities with Informatica.
  • Prepared Unit Test Cases and validated in line with design
  • Done SOC, UTP, UAT and changes as part of Disconnect
  • Created Frame Work Model (Star Schema)
  • Designed various types of reports like List , Drill-through , Cross-tabs , Column charts & Bar charts
  • Developed Detail and Summary reports based on management hierarchy with Drill Down and Drill through capability
  • Developed reports using Master Detail Relationship
  • Developed prompted reports using different prompts like Value Prompt , Date and Time prompt etc
  • Developed reports using Conditional Layouts and condition expression like String Variable and Boolean Variable.
  • Enhanced Existing Reports as per change request
  • Bursted reports based on hierarchy and groups. Bursting reports , event handling, scheduling jobs using CRN
  • Tested newly developed reports & enhanced existing reports
  • Maintained documentation for each activity process

Environment: Informatica Power Center 8.1, Cognos 8 BI (Report Studio, FM), Siebel 7.8, Clarify 6.3, Kenan, Oracle 9i, SQL Server 2005, DB2, Toad, Visio, Confidential Share Point, and Windows XP Professional.

Hire Now