We provide IT Staff Augmentation Services!

Tech Lead/architect Resume

PROFESSIONAL SUMMARY:

  • Over 14 years experience in Information Technology.
  • Over 10 years of professional expertise in implementing Data Warehouses, Expertise in BI (Business Intelligence) using various Tools.
  • Expertise in Architecting Solutions for Implementing Enterprise wide Data warehouses using COGNOS 10.2.x Tools
  • Developed, implemented Cognos Enterprise Planning Models using Enterprise Planning suite.
  • Hands on experience on Visualization tools TABLEAU and location intelligence tools ESRI.
  • Hands on experience of Cognos TM1 10.2.x.
  • Expertise in Architecting Solutions for ETL Processes using COGNOS Decision Stream and Microsoft DTS, Informatica Power Mart Tools .
  • Expertise in Administering and supporting COGNOS Environment
  • Project Management activities: Managed a Team (maintaining the project schedule, preparing reports, time sheets, and preparing testing Reports).
  • Well versed with Datawarehouse Concepts of Star Schema and Snow Flake Schema.
  • Well versed with SDLC (software development life cycle)
  • Well Versed with Database Administration.
  • Strong experience in client interaction and understanding business application, business data flow and data relations from them.
  • Expertise in Designing, Developing and Deployment Data models using COGNOS FRAMEWORK MANAGER in COGNOS Environment, Physical and Logical Implementation using ERWIN.
  • Excellent communication and interpersonal skills.
  • Knowledge on other BI Tools like MicroStrategy, proclarity, BRIO tools.
  • Skilled in Testing applications and the design of the applications.
  • Domain knowledge in Banking, Insurance, Education Industries.

TECHNICAL SUMMARY:

Business Intelligence: COGNOS, LDAP, Framework Manager, Transformer, Report Studio, Query Studio, Analysis Studio, Score carding, Workspace, Active reports.

BI Visualization Tools: Tableau, MS Power BI

Planning Tools: COGNOS Planning: Analyst, Contributor and Planning Manager, TM1 10.2.x

ETL Tools: SSIS, COGNOS Decision Stream, Microsoft SQL Server DTS 2000/7.0, Informatica

Data Modeling: ERWIN

Databases and Tools: MS SQL Server 7.0/2000/2005 , Oracle 8i/9i, MS Access, SQL*Plus, SQL*LoaderTeradata

Reporting Tools: Crystal Reports, COGNOS REPORTNET, BRIO QUERY, SSRS, Business Objects

Web Technologies: IIS, ASP, MS Site Server Commerce Edition 3.0, HTML, DHTML, Active X, COM, VBScript, JavaScript, Visual Interdev, MTS

Front End: Visual Basic 5.0/6.0, ASP

Operating Systems: Windows, UNIX

PROFESSIONAL EXPERIENCE:

Confidential

Tech Lead/Architect

Responsibilities:

  • Worked with Purchase SME’s to Confidential various data sources required to build the metric equations.
  • Analysed Data from raw sources for Data relationships.
  • Developed Logical Data Model for Staging, QA and Prod environment.
  • Articulated the design into ETL Design for the ETL team to work on Data Loading.
  • Working with Reporting and Analytical Tools to author reports, Cubes and Dashboards for better Data visibility in Cognos V11 version
  • Working on Site - offshore models to guide the team for Data Reporting, Data loading.
  • Worked on Migration from cognos 10.2.2 to Cognos V11 .

Environment: /Tools: Teradata (Database), Cognos, QlikView, ERWin

Confidential

Snr Consultant

Responsibilities:

  • Designing BI solutions for various departments in the enterprise based on Data discovery and data availability.
  • Gathering Requirements from different categories of Users.
  • Developed cubes.
  • Developed Dashboards .
  • Developed transactional reports, tuned for performance.

Confidential

Snr Consultant

Responsibilities:

  • Designing BI solutions for various departments in the enterprise based on Data discovery and data availability.
  • Developed cubes.
  • Collaborating with different teams (Data management, Quality assurance, Systems) for Optimization.
  • Gathering Requirements from different categories of Users.
  • Accountable for delivery of the Deliverables.
  • Ensuring of implementation of Best practices across all the stages of the Solution.
  • Developed Dashboards using various Dash boarding tools.
  • Have done training on Cognos V11(Analytics).
  • Developed reports, cubes and done performance tuning.

Confidential

Snr Consultant

Responsibilities:

  • Reporting on various Marketing Leading Indicators for Higher Management for visibility into the marketing business cycle starting from Student Admission to Student Graduation.
  • Daily, weekly, monthly reporting of leading marketing indicators and complex transactional reporting for various sources (web, media, Marketing Channels etc).
  • Have developed Cognos Cubes, Data Models using Framework Manager and reported using Cognos report and query studio.
  • Have been the front face for the senior management meetings for better understanding of the requirements and collaborated with various departments across Marketing, student admissions, evaluations, finance and IT Departments.
  • Have converted budgeting and planning models into Cognos TM1 for Planning purposes. working experience in TM1 including all aspects of design and implementation including: Perspectives, Active Forms, Architect, TM1 Contributor, Web, Café, Turbo Integrator, Feeders, cube design, reporting & security
  • Have Developed Dashboards for Top level management utilizing TM1 Cubes.
  • Have Designed and Deployed Dashboards using TABLEAU Tools.

Confidential

Team Lead/Snr Associate

Responsibilities:

  • Front face for the Business in analyzing the Requirements Design part and helped in converting the Business Requirements into Technical Specs.
  • Provided detailed analysis of tools which can best suit the Requirements.
  • Have implemented transactional Reports from Cognos 10.2.x suite.
  • Have Demonstrated the usage of reports through Mobile app.
  • Have worked on Dynamic Cubes Implementation.
  • Provided Training to Business Users for all the projects above. .
  • Leading a team of 4 from offshore.
  • Built Executive Dashboards for Data Visualization using TABLEAU desktop and TABLEAU server for higher Management.
  • Developed TM1 Cubes for users for contributing their quarterly, annual numbers for budgeting and forcasting periods.
  • Have used Cognos Insight to represent data from TM1 Cubes.
  • Building Processes that feed cubes and running multiple processes in parallel in TM1.
  • Scripting business rules in TM1
  • Data Modeling in TM1.

Environment: Cognos 10.2, Oracle, Teradata, Tableau

Confidential, IL

Senior Cognos Consultant

Responsibilities:

  • Provided best practices for Modeling
  • Developed a Data Model out of SalesForce.com Transactional System.
  • Developed Reports using report Studio, Query Studio (adhoc).
  • Provided Support for the Reports and Model.
  • Involved in Cognos TM1 Cubes development.
  • Developed Dashboards and designed Bursting feature for Distributing the Data.
  • Leading a team of 4 people.
  • Written Complex PL/SQL and SQL Queries.
  • Mentored users for the Cubes and the DashBoards.
  • Implemented Best practices in design.
  • Prepare and review technical and logical design and artifacts
  • Recommended various aspects of improving the solution delivery.

Environment: Cognos 8.4 / TM1 9.x, Oracle, SalesForce.com, Sungard Banner

Confidential, NJ

Cognos Data Architect

Responsibilities:

  • Involved in Data modeling, Provided best practices for Modeling
  • Did Data profiling, Data Mining, Developed and maintained Cubes.
  • Developed Cognos Meta Data model for reporting.
  • Relational and multi-dimensional data modeling, including the use of standard data modeling tools
  • Lead all aspects of the delivery of Business Intelligence (BI) solutions and related components.
  • Analyze business challenges and translate into requirements/solutions. Understand and articulate complex BI implementation.
  • Work with BI Competency Center to define BI strategic roadmap.
  • Convert requests into requirements. Design logical models to meet business requirements.
  • Developed Healthcare Dashboards for senior Management.

Environment: Cognos 8.4, Teradata, Oracle, IBM AIX

Confidential, IL

Cognos Consultant

Responsibilities:

  • Implemented DMR techniques for aggregations, Drill down, Drill Up and drill through capabilities.
  • Created segments and re-linked the segments.
  • Implemented Security in the Framework Model.
  • Implemented Business Modeling using Star Schema Grouping approach to work with Conformed Dimensions.
  • Used Best Practices to achieve Model performance.
  • Writing Technical Specifications for Reporting.
  • Created a Framework Model from Planning Applications.
  • Used Prompts to provide user Interface for the reports to filter out based on a selection of user inputs.
  • Externalized IQD's for development of Cubes.
  • Developing of BI Framework Model with Dimensional Concepts
  • Implementation of Data Security for the BI Model
  • Development of Financial Reports
  • Planning Analyst Models design
  • Managing of Contributor Tool
  • Worked with SSIS Packages (developing, deploying, scheduling and automating).
  • Installed, Configured Planning Components.
  • Design and Developed Budget and Forecasting Models using Planning Tools.
  • Created D-Lists, D-Cubes and D-Links for applications like Income Statement and forecast Budgeting applications
  • Followed with Best Practices from Cognos Corporation with Administration and Configuration of Analyst and Contributor Applications
  • Used Allocation Tables in a D-Link to import data from another application and to copy data between D-Cubes
  • Used file maps in D-Links to import data from text/csv files and other sources.
  • Using Planning Manager designed Flow Chart reports with macros to update the Cubes
  • Created contributor web application by using Contributor Administration after developing the model in Analyst tool
  • Involved in Configuring Contributor Administration Console and Managing Job Servers
  • Created Publish Containers
  • Developed architecture for Integrating Planning Models with Cognos BI Components for Reporting

Environment: Cognos 8.3 & 8.4, Framework Manager 8.3 & 8.4, ReportStudio, Query Studio, Cognos Planning(Analyst, Contributor).

Confidential, IL

Senior Developer/Report Architect

Responsibilities:

  • Designing the Data Model using Cognos Framework manager on Version 8
  • Developing ETL routines using Informatica and deploying the routines.
  • Involved in all phases of SDLC from requirement, design, development, testing, training and rollout to the field user and support for production environment
  • Worked with Informatica PowerMart client tools like Source Analyzer, Warehouse Designer, and Mapping Designed and developed mapping, transformation logic and processes in Informatica for implementing business rules and standardization of source data from multiple systems into the data warehouse
  • Maintained source and target mappings, transformation logic and processes to reflect the changing business environment over time.
  • Involved in developing source to target mappings and scheduling Informatica sessions
  • Created various UNIX Shell Scripts for scheduling various data cleansing scripts and loading process. Maintained the batch processes using Unix Shell Scripts.
  • Developing Cognos Reports on Version 8
  • Developing Cognos Cubes using Transformer and testing them using Analysis Studio on ver 8
  • Educating the business users on how to do adhoc queries using Query Studio ver 8
  • As a senior developer, suggesting best practices to the team.
  • Designed and developed Cubes.

Environment: Cognos 8.2, Informatica, Teradata.

Confidential, IL

Senior Associate/Business Analyst

Responsibilities:

  • Designing and Architecting the Data Model using Cognos Enterprise Suite .
  • Interacting with the Business Users, Data Modelers and Database Team
  • Managing the Offshore Resources.
  • Reviewing the Work done by the offshore and fixing the Bugs.
  • Responsible in delivering the reports to the Business at the said deadline.
  • Converted Crystal Reports to Cognos .

Environment: COGNOS ReportNET 1.1, Teradata

Confidential, Sunamerica, CA

Cognos Administrator

Responsibilities:

  • Involved in Disaster Recovery Plan and Implementation.
  • Configured, Installed COGNOS Components.
  • Involved in up gradation, migration of COGNOS products.
  • Installed, Configured ReportNET 1.1 for Windows.
  • Installed, Framework Manager Components. Administering and Managing the ReportNET Server.
  • Developed Framework model from the EDW BI Data warehouse using Framework Objects (Query Subject, Filter, Namespace, Parameters, and Calculation).
  • Generated Packages out of the Framework Model.
  • Published Packages to the COGNOS ReportNET Server.
  • Imported Packages into the ReportNET Server.
  • Using Report Studio, Developed various Reports(List, Cross Tab, Chart)
  • Deployed Reports and Granted Permissions (Read, write, Execute etc) to the user Classes.
  • Implemented security using Access Manager.
  • Maintenance of Decision Stream Jobs.
  • Creation of Decision Stream Processes.
  • Production Support for Business Intelligence.
  • Enhancing, Maintenance of BI Portal using Upfront server
  • Expertise in building and maintaining of Impromptu Catalogs.

Environment: COGNOS EP series 7 version 3, ReportNET 1.1, UNIX,, Oracle 9i, Toad, Upfront, Impromptu, Access manager, Transformer, Impromptu Web reports, SUN ONE, Decision Stream

Confidential

Project Lead /COGNOS Administrator

Responsibilities:

  • Involved in building logical and physical data model using ERWIN Tool.
  • Managing project activities, coordinating with users to understand the requirements.
  • Involved in defining the process flow, designing interfaces for users for maintenance.
  • Decision Stream.
  • Created Decision Stream Catalogs to Extract, Transform and Deliver the Data.
  • Created a Connection to SQL Server 2000 using OLEDB.
  • Built DataStream to Connect to the Data Sources.
  • Designed Dimensional Framework (Reference structures, Templates).
  • Designed, Created and Executed the Dimension Builds, Fact Builds.
  • Designed a Transformation Model (Attributes, Derivations, Dimensions and Measures). Mapped DataStream’s to the Transformation Model, Added the Transformation Model Element to the Fact Builds.
  • Added Fact Deliveries to the Fact Build while creating a Fact Build using Wizard.
  • Built Job Streams for automation of the Building Tasks.
  • Involved in setting up the star schema.
  • Involved in designing the cube structures using COGNOS Powerplay Tool.
  • Involved in setting the infrastructure for the implementation.
  • Involved in designing high end financial reports for the top floor (Dashboards).
  • Will be responsible to promote the features and market the warehouse.
  • Developed reports and quries using BRIO tools.

Environment: ReportNET 1.02/1.1, Framework Manager, Query Studio, Impromptu 7.0, Power Play 7.0, Powerplay Transformer, Impromptu Web Reports, Upfront, Access Manager, Power Play Enterprise Server, Windows NT/2000, Oracle 9i.

Hire Now