We provide IT Staff Augmentation Services!

Tech Lead/architect Resume

5.00 Rating

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 SKILLS

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

Project Planning Tools: Microsoft Project.

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 discover 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: Teradata (Database), Cognos, QlikView, ERWin

Confidential

Tech Lead/Architect

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

Tech Lead/Architect

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

Tech Lead/Architect

Responsibilities:

  • 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

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

We'd love your feedback!