We provide IT Staff Augmentation Services!

Datebi Architect Resume

SUMMARY

  • 13.5 years of IT experience in analysis, data modeling, testing, development, documentation and implementation of Cognos applications and development of Data Warehouses/Data Marts using Informatica.
  •  Hands on experience on Cognos, Oracle Discoverer, OBIEE, Business Objects, Tableau, Tibco SpotFire.
  •  concept to design implementation of visualization projects using Tableau, Tibco SpotFire & Cognos Rave engine.
  •  Implementation of tactical and strategic dashboards serving internal and external user groups using Cognos workspace, Active reports, Rave engine & Cognos Portals.
  •  Implementation of security at Database, Cognos Server, Cognos portal, Meta data model & Report level.
  • Design of customized tables for reporting solutions. Implementation of security at data level, Experience in Dimensional data modeling using Kimball’s Star schema and Snow Flake schema methodologies.

TECHNICAL SKILLS

Data Warehousing: Informatica8.5.1/8.X, Data Mart, OLAP, OLTP, SQL*Plus, Toad, Cognos 7.3,8.2,8.3,8.4,10.1,10.2,10.2.1,10.2.2, OBIEE 10g and Qlik view. Oracle Discoverer 10g

Data Modeling: Star - schema Modeling, Snowflake Modelling, Fact and Dimension Tables

Databases: Oracle 10g/9i/8.0/7.x, MS SQL Server 2000,2005,2008,2012, DB2, MySQL, MS Access 7.0, Teradata 12,13.1

ERP: SAP, Baan, JD Edwards, Custom ERP systems.

Programming Languages: C, SQL, PL/SQL, Java script

Web Technologies: HTML, CSS, Java Script

Operating Systems: UNIX, Windows NT/98/2000, XP, Window 7, Windows Server 2012 R2

PROFESSIONAL EXPERIENCE

Confidential

DateBI Architect

Responsibilities:

  • Confidential specialize in software development, custom software solutions in the areas of Mobility, Web Applications, Security Testing, and Enterprise computing.
  • The company began in 2008 and has enjoyed a rapid growth within the United States and globally.

Sr. BI Technical Consultant

Confidential, Raleigh, NC

Responsibilities:

  • Did Gap analysis with the help of Arcplan developers, Data architects & Business BPO’s.
  • Categorization and development efforts estimation.
  • Setting up the security groups in Cognos and Cognos specific views in Oracle.
  • Meta data model building supporting Adhoc and canned reporting.
  • Development of Canned reports in both relational and MDX.
  • Day to day Cognos related Administrative activities.
  • Expand and collapse functionality which is not native in tool like Cognos.
  • Custom java scripting and use to Cognos functionalities to achieve some of native Arcplan ease of use.
  • Integration of TXI Cement reporting system into Confidential environment.
  • Workshops and presentation at major Organization Divisions.
  • Performance testing using scripting.

Environment: IBM Cognos 10.2.2, 11.07, Tableau 10.2, 10.3. Oracle 12 C, Super cluster, Data stage 11.2, SharePoint, SQL Server 2014, Windows server 2012 R2. JD Edwards.

Sr. Cognos consultant/BI Lead

Confidential, Seattle, WA

Responsibilities:

  • Creating strategies that use business intelligence and data platforms.
  • Requirement analysis and defining the technical scope.
  • Resolves conflicts between models, ensuring that data models are consistent with the ecosystem model (e.g., entity names, relationships and definitions).
  • Story boarding on tableau desktop and on power point for steering committee approval.
  • Served as BI administrator to implement report promotion procedures that developers follow to design, test and promote reports to production.
  • Worked with developers to make sure that all data solutions are consistent.
  • Identified issues, provide root-cause analysis and take required proactive actions to prevent them.
  • Served as BI expert for performance tuning of the reporting servers, metadata models and reports.
  • Implementation of DMR model to support PACE analytical report and dash boarding services.
  • Provides technical assistance to junior team members.
  • Write test scripts and validate the technical deliverables from the development team in UAT.
  • Lead resolution of production support problems in accordance with incident management and service level agreements.

Environment: IBM Cognos 10.2.2, Framework manager, Report Studio, Cognos Workspace advanced, Active Reports, Teradata 14.10, IBM DB2 9.1, tableau 9.2,9.3, Motio, and Meta manager 10, MS SharePoint, Windows 7.

Confidential, Los Angeles, CA

BI Lead

Responsibilities:

  • Identifying areas of deficiencies, reviewing IT requirements/design/development of Cognos solutions, solution architecture development, proof of concept/prototype design, infrastructure requirements development, database design, architecture and administration,
  • Application development, testing and analyzing user interfaces, cubes and various reports.
  • Performance tuning at database and reporting level.
  • Setting up the tables and views based on the flat files structure
  • Completed the assignment in very short duration, the work impacted 1000’s of users.

Environment: IBM Cognos Express, Framework manager, Report Studio, Cognos Workspace advanced, Active Reports, SQL Server 2008 MS SharePoint, Windows 7.

Sr. Consultant

Confidential

Responsibilities:

  • POC design of Security system in Cognos, which handles the entire external customer’s user access the sensitive data content.
  • Designed the common model for both internal and external customers supporting 40 custom reports and Standard reports.
  • Responsible for gathering reporting requirements from Business users.
  • Strategy & Planning, Results Accountability Complete ownership of end to end of single application related to Claims
  • Responsible for design and maintenance of FM model for Data Analyzer and ICR Project Model.
  • Lead role in Customizing of Security model for ICR in Cognos in compliance with HIPAA rules.
  • Responsible for security design and implementation (CAP security) for both external and internal customers.
  • Responsible for Standardizing the metadata model and Report designs.
  • Hands on experience on Performance Tuning of existing reports for Claim and Leave reports.
  • Hands on experience on the report query design and query optimization to meet the SLA.
  • Played a key role in refactoring the existing reports and Framework model for performance and query optimization.
  • Design of UI reports supporting the UI frontend interface and assisting the UI developers in integration of the Standard and custom reports with front end UI.
  • Provided User Training and Documentation of the Framework design and custom reports.
  • Involved in Designing the Unit test scripts for the Custom and Standard Reports.
  • Involved in Trouble shooting at Report Level, Model level and Data level.
  • Designs and coordinates a curriculum for coaching and training customers in the use of business intelligence tools to enhance business decision-making capability.
  • User training in Workspace and workspace advanced tool for adhoc reports.

Environment: IBM Cognos 10.2, 10.2.1, Framework manager, Report Studio, Cognos Workspace advanced, Active Reports, Teradata 14.10, IBM DB2 9.1, Motio, and Meta manager 10, SAP R/3, MS SharePoint, and Windows 7.

BI Technical SME

Confidential, San Jose, CA

Responsibilities:

  • Enhancements of the existing FM model to meet the new requirements and also to meet the Performance related issues.
  • Refactoring of existing standard reports to meet the industry SLA.
  • Design and development of Key Performance Metric Report (KPM), Student, parent, and Staff Climate survey reports all the Elementary, Middle & high school.
  • Consolidation of all the drill through reports for all School and District reports into one single report.
  • Optimization and enhancements of OPSTAT Lir. Reports.
  • Provide end user training and documentation for School and District reports analysis.

Environment: Cognos 10.2, 10.1.1, Transformer 10.2, SQL Server 2008, Control M v8, MS SSIS, MS office 2010. Window server 2008

Confidential, Philadelphia, PA

BI Solution Architect/Data modeler/Administrator

Responsibilities:

  • Responsible as dedicated resource for any technical assistance and knowledge base for Cognos BI analytics.
  • Educating the end users in Database usage and Cognos BI analytics in using EMD system.
  • Data modeling to meet the needs of Marketing and Campaign analyst needs.
  • Implementation of Stored procedures and materialized views for customized solution.
  • Responsible for designing and developing Cognos reports of moderate/high level of Complexity.
  • Data modeling for Adhoc and as well as Standard enterprise report solutions
  • Troubleshooting day-to-day reporting issues in the EMD.
  • Writing and testing backend views or Oracle procedures for EMD reporting system
  • Development and testing of Standard and Dashboards reports.
  • Design and build Campaign user retention dashboards on Workspace advanced.
  • Design and development of multi dimensional cubes in Transformer.
  • Use of Dimensional functions to customize the dimensional reports.
  • Setting up the security and automating the cubes.
  • Performance and optimization of EMD reporting system to meet the standards.
  • Performance tuning of dashboards reports on Cognos Workspace Advanced.
  • Code reviews of the team members following the standard and best practices of the industry.
  • Assigning custom roles/groups for Cognos portlets, Workspace advanced and report directories.

Confidential

Cognos Lead Developer/Administrator

Responsibilities:

  • Played a key role in setting up the Dev. and QA server for C10.2 and requested configuration and customization.
  • Carried out Validation and benchmark project for old CRN reports in Cognos Life cycle manager and responsible for any issues that surface out during the LCM project.
  • Responsible for the Migration of all the reports from old CRN environment to new server 10.2.
  • Regression testing of all the reports on the new server against the old reporting system.
  • Played a key role in customization of the Cognos 10.2 server machine to meet the branding requirement of the client.

Environment: Cognos 10.2, 10.1.1,10.1,8.4, CRN 7.3, Transformer 10.2, Oracle 11g, Oracle SQL developer 4.0, SQL Server 2008, Control M v8, Tableau 9.1, Abnitio 3.05, SAP, MS office 2010. Window server 2008

Confidential

BI Technical Advisor/Cognos Architect

Responsibilities:

  • Running Audit Reports for the entire Discoverer reports and Documentation of Report Requirements.
  • Designing and development of Framework Manager models for all the three LOBs SC-Shipping Order History, SC-Bill of Landing, SC-Customer Order, C0-Commercial Sales activity, CO-POS Data marts & FI-Accounts Payable and Accounts Receivable.
  • Designing and creation of database views in Teradata to meets the needs of various subject areas in new BI system.
  • Responsible for Code migration from Development to QA and Production.
  • Setting up Security in Cognos connection for all different LOBs for AN division.
  • Performance tuning and Optimization of Meta data models to suite the Business Requirement.
  • Assigning and Leading the report development to the developer, which involves both Adhoc Query Studio reports and Report Studio Reports.
  • Responsible for Regression testing of all the reports developments against Teradata DB.
  • Responsible for various troubleshooting of the reports and models designs
  • Responsible for backups of the entire framework manager models periodically.
  • Demonstration and presentation for Migration into new Cognos 10.1 from Cognos 8.3 system.
  • Designing and development of Active Report Dashboards & Business Insight Dashboard.
  • Creating and maintenance of Cognos data source with custom security for each user group.
  • Scheduling and maintenance of monthly, quarterly and Yearly reports.
  • Setting up the environment of Report Bursting on network along with regular Directory and Email Bursting.
  • User training on Cognos reporting using Cognos workspace and Cognos Workspace advanced.
  • Responsible for troubleshooting the issues resolving the open tickets created by user for application reports.
  • Demonstration of Cognos BI reporting, analysis, & Dashboard capabilities to the client.
  • Designing the mock up reports & Dashboards for Client.
  • Requirement gathering based on their current excel based reporting system and their expectations.
  • Design and Development of operational reports based on PeopleSoft Supply Chain Management.
  • Designing Framework Manager model and reports
  • Designing active reports dashboard for both mobile users and desktop users.

Environment: Cognos 8.3,10.1.1, Report Studio, Query Studio, Analysis Studio, Framework Manager, business insight advanced/workspace advanced, Transformer 8.3, Power play 7.3, Oracle Discoverer 10g, Oracle 10g, Toad 9.5, SAP, PeopleSoft SCM 8.1, Oracle SQL Developer 3.2.2, JavaScript, Windows XP, MS Office 2007., Mata Manager.

Confidential

Cognos Administrator/Cognos Developer/Cognos Analyst

Responsibilities:

  • Administration and maintenance of Cognos Reporting Application, which includes installing patches, fixes, and deployment of code to higher environments.
  • Designing, deployment and maintenance of Oracle packages, procedures, views, and functions and tailoring them to meet the reporting requirements of the client.
  • Implementation of Metadata modeling either through stored procedures or physical tables in the framework manager.
  • Designing and Organization of Framework Models and assigning to different development groups.
  • Performance tuning and Optimization of Meta data models to best suite the Business Requirement
  • Hands on experience on working in the Multi user development environment for metadata modeling in Framework Manager.
  • Designing of Allocation statements for DHS office provider for fiscal year 2011-2012.
  • Maintenance and troubleshooting the court reports which are the part of KIDS release 5.
  • Created OLAP cubes for Phase I, Phase II, and Phase III Data Mart using Power Play Transformer.
  • Responsible for Performance tuning and optimization of cubes and automation of Cube refreshes.
  • Trained users on Analysis Studio and PowerPlay for accessing cubes and analyzing the data.
  • Hands on experience in multidimensional functions (MDX).
  • Setting up and Demonstration of Cognos 10.1 environment to the client.
  • Integration of .NET application with Cognos reports using Cognos SDK.
  • Scheduling and maintenance of monthly and weekly reports.
  • Setting and maintenance of Dashboards and distribution of Cognos reports file system and bursting of the reports (Network Bursting, Directory Bursting & Email bursting).
  • Responsible for Auditing reports in all 4 Cognos environments (Dev/TEST, UAT, Training, Production)
  • Responsible for maintenance and backup of Content store all the environments
  • Hands on experience on Performance tuning and Optimization of the reports and FM models.
  • Responsible for troubleshooting the issues resolving the open tickets created by user for application reports.

Environment: Cognos 8.3,10.1, Report Studio, Query Studio, Analysis Studio, Framework Manager, Transformer 8.3, PowerPlay 7.3, Qlikview 10 Oracle 10g, Toad 9.5, JavaScript, Windows XP, MS Office 2010.

Confidential, Dallas, TX

Cognos Report Developer/Business System Analyst

Responsibilities:

  • Changes in Framework Manager model as a part of performance tuning and addition of security filters to the model for different type of users based on LanID
  • Adhoc package building based on the existing model and user requirements
  • Enhancements of existing reports in R2 and addition of new requirements like security setup for medical and Behavior Health.
  • Performance tuning of the reports by tuning the FM model and reducing the calculation in report level.
  • Changes in the existing appeal reports and adding java scripts to enhance the user friendliness.
  • Categorization of appeal codes at database level to enhance the data retrieval and performance
  • Handling of issues and errors in testing phase and production.
  • Documentation of both Adhoc and standard reports.
  • Have carried out unit testing and Regression testing on different environments to test the efficacy of reports

Environment: Cognos 8.3 Report Studio, Query Studio, Framework Manager, SQL Server 2005, Appeal Application, Windows XP, JavaScript, MS Office 2003.

Confidential

BI Administrator/BI Developer

Responsibilities:

  • Gathering and analysis of requirements for reporting on EDI Gateway from E-services, EDI Tech support for EDI Gateway Modernization Projects.
  • Developed 835, 837I&D EDI Gateway reporting BRDs using Confidential ’s process methodology such as SIPOC and FMEA.
  • Used Quality Center to Log and report Bugs to the Developers, and Coordinate with Developer to Resolve the Bugs. Maintained the Traceability Matrix for Manual Testing.
  • Technical Requirements Document (TRD) preparation for 835 reporting and screens transactions.
  • Analysis of reporting infrastructure for EDI Gateway including DX console, Cognos and Dashboards.
  • Developed User training materials on Cognos 8.4 and provided user training for EDW team.
  • Gap Analysis of current EDI Gateway Reporting vs future EDI Gateway reporting including mapping the database tables etc.
  • Worked closely with EDI Gateway Modernization implementation partners in architectural designing.
  • Creation of Proof of concept for reporting environment through Cognos and informatica B2B.
  • Involved in installation of Framework Manager Configurations to point to Dev and Production servers.
  • Built Framework Manager Model, and established the cardinalities to suit the business needs.
  • Worked on both DMR and relational model in Framewok Manager.
  • Implemented Framework manager security for Data access, Object level access and Package access based on the Organization Level
  • Involved in deploying the Reports cubes and packages from development to production environments.
  • Hands on experience on all advanced features on Cognos Report studio in 8.4 versions.
  • Cognos query is used to develop set of adhoc queries and published in portal for the users to create an adhoc reports.
  • Report building in Report Studio and its distribution of daily and monthly reports of 835 and 837 D transactions.
  • Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts in Report Studio, Burst Reports against database.
  • Created OLAP cubes using Power Play Transformer against various data sources like Oracle& Flat Files.
  • Dashboard designing for error reports for 835 transaction and financial report on trading partner transaction.
  • Integration of various other dashboards like MOM dashboards and EDIFECS dashboards in Cognos Portlets.
  • Deployment of Cognos Reports and Packages from lower to higher environment.
  • Creation and maintenance of security in Cognos environment.
  • Running Audit Reports and maintenance of Content store
  • Regular monitoring of the performance and Performance tuning.
  • Worked on Template designing on report studio based on the common needs of the user.
  • Worked on Analysis Studio to develop multi dimensional reporting.
  • Scheduled report and job to run weekly and monthly basis.
  • Resolved many performance issues related to reports generation and model designing

Environment: Informatica DX, DT, Cognos 8.4, Framework Manager, Analysis Studio, Query Studio, Report Studio, IBM mainframe, DB2, Windows XP. Quality center 9.2, Oracle 10g, Quick test pro 9.2, Application Servers Load Runner 9.1, SQL developer, XML, MS office 2003, MS Project 2007, HTML

Confidential

Cognos Developer

Responsibilities:

  • Team player in wide range of tasks ranging from Procurement of documents and the raw data to report documentation and publication.
  • Performed manual testing as per requirement including negative & positive testing.
  • Developed test plans and test cases according to business requirement given.
  • Performed the Functionality Testing of the business processes & module according to the specification & expected results mentioned in the test cases.
  • Analyzed, Revised and Created test plans according to business requirements.
  • Used Informatica Power Center for (ETL) extraction, transformation and loading data from heterogeneous source systems.
  • Designed, developed Informatica mappings, enabling the extract, transport and loading of the data into target tables.
  • Created Workflow, Worklets and Tasks to schedule the loads at required frequency using Workflow Manager.
  • Created dimensionally modeled relational model (DMR) for dimensional modeling.
  • Building Star schemas in the framework manager.
  • Used calculations and various functions for many of the existing field and added calculated fields in the model in the framework manager.
  • Worked with the report formatting and worked with hiding and unhiding of columns, rows and dynamic custom sorting.
  • Implemented various rules and advanced techniques for report designing like Global filtering, creation of Dashboards, reports involving Filtering Query data from another Query technique, Using Slicers in Dimensional Models, Creating portals with dynamic filters and drill capability
  • Worked on both interactive and scheduled reports composing simple to complex reports.
  • Used Cognos Transformer to build multidimensional cubes and used it in Cognos PowerPlay to build analysis ports, graphs and charts of sales data.
  • Cognos query is used to develop set of adhoc queries and published in portal for the users to create an adhoc reports.
  • Resolved many performance issues related to reports generation and model designing
  • Tested the reports using manual system and manual testing.
  • Done performance tuning at Report level and package level in order to increase the overall performance level.

Environment: Cognos 7.3, 8.4, Framework Manager, Cognos Connection, SQL Server 2005, Oracle 10g Microsoft Visio, Microsoft Project, Plan view, Load Runner, java script, TOAD, PowerPlay Transformer 7.3, Analysis Studio, Query Studio, Informatica 8.5.1, Windows server 2003, Unix/AIX.

Confidential

Business Analyst/Data warehouse Developer

Responsibilities:

  • Involved in creation of tables, writing stored procedures, Triggers, PL/SQL Libraries. Performed Normalization and Logical Database Design Unit Testing of the modules. Developed user-friendly forms for easy data entry.
  • Worked as an Informatica mapping design and report developer. Prepared mapping transformation logic documentation as per user requirements. Designed the ETL processes using Informatica tool to load data from Flat File and Oracle source into the target Oracle 9i database.
  • Developed mappings using Informatica for data loading. Used various Informatica transformations like Lookup, Joiner, Aggregator, Expression, Filter, Router and Update Strategy for framing business logic in the mapping. Involved in the Testing of mappings and loading data in the target tables.
  • Created sessions for mappings and utilized Workflow Manager & Monitor to Create, Schedule and Monitor workflows. Created PL/SQL Procedures and Views for some DW requirements. Generated Universe and Reports using Business Objects 5.1.
  • Developed customized and adhoc reports using Templates and Filters for Business analysis using Business Objects with features of drilling options (drill up, drill down and drill anywhere). Involved in training the end users on Web Intelligence. Used Erwin to update the existing data model.
  • Member of the development team in building up the employee database in oracle.
  • Created optimized, single and cascaded database triggers and stored procedures in PL/SQL to check integrity constraints.
  • Used knowledge of advanced PL/SQL concepts like arrays, tables, cursors, built-in and user defined object types, exception handling and database packages.
  • Utilized SQL plus for SQL coding of DDL statements for creation of the required database objects and DML queries for data retrieval.
  • Involved in loading large amounts of data using utilities such as SQL Loader.

Environment: Informatica 5.1, Oracle 9i, Business Objects 5.1, ERwin, SQL, PL/SQL, Oracle 7.X, SQL*Plus, SQL loader, Windows 2000

Hire Now