Summary

• Expertise in Cognos Enterprise Business Intelligence Tools - Cognos 8 BI,
• Comprise excellent knowledge in Cognos ReportNet, which includes Framework Manager, Query Studio, Report Studio, and Cognos Connection.
• Strong fundamentals in OLTP/OLAP technology, Database Schemas (Star Schema and Snowflake Schema)
• Provide extensive End User Training and Support.
• Involved in the entire Life cycle development process in the data warehousing
• Expertise in data analysis, data warehousing,data modeling, and data migration
• Excellent communication, presentation, project management skills, and a very good team player

TECHNICAL SKILLS

• Reporting Tools:Cognos8 BI, Cognos Report Net, Business Objects XI,Crystal Reports, iReport 3.0
• ETL Tools :Informatica (Power Center 7.1.216.215.1)
• Operating System: Windows 2000/NT/98/95, Sun Solaris 2.x, HP-Unix
• RDBMS:Oracle 10g/9i/8/7 (SQL, PL/SQL, Stored Procedures, Functions), MS Access 2002/2003, SQL Server 2000
• Database Tools: Toad, SQL Navigat or 4.0, SQL Loader, Navicat MySQL
• Data Modeling Tool: Erwin
• Languages: PL/SQL, C++

Experience

Confidential, Richardson, Texas
Business Intelligence Analyst Dec 2008 - present

Confidential, Incorporated is a United States Federal government contractor providing work in Information Technology and Automated Building Technology.

Responsibilities include:

• Collected, processed, analyzed and reported on metrics and quality control data to meet specific customer reporting requirements (CDRL’s, dashboards, etc.)
• Performed various tests to identify problems/areas for improvement, or risk, in company and customer operations
• Developed statistical models for equipment reliability and lifecycle costs
• Communicated/present analysis results and recommendations as required
• Identifed, developed and implemented new statistical measures and techniques as part of continuous improvement process
• Prepared and maintain summaries and comprehensive data files
• Provided technical guidance on statistical policies, procedures, and programs
• Managed service company that does business with the government sector
  Experience in Maximo/Operations Research /Mathematics/SQL Programming/Cognos 8 BI
• Worked with Business Units to define Business strategy and create a centralized reporting capability for users to work perform analytical, and ad-hoc reporting for business applications and provided accurate information for the Decision Makers.
• Worked with users, business analysts to define reporting requirements for various services and processes using Cognos v8 series.
• Created reporting packages in Framework Manager.
• Organized reporting applications into different folders in Framework Manager for sales and distribution department.
• Created various reports viz. List, Cross-tab and drill through as per the requirement.
• Generate Promotional marketing sales/revenue statement for each quarter.
• Creating and publishing several packages in Framework Manager.
• Created Calculations, Filters and Prompts in Report Studio reports.
• Created groups and users, roles, folder deployment, grant access permissions, scheduling reports and setting up default prompt values,
• Generated various kinds of reports (Daily, monthly etc) in Report Studio for managerial decision support.

Environment: Cognos 8 BI ,Report Net, Framework Manager, Report Studio, Cognos Connection, Windows 2000, Sql Server 2000, Query Analyzer, Maximo

Confidential, Carrollton, Texas
Business Intelligence Developer June 2008 - September 2008

Confidential, is a world class leader in the aviation MRO industry focused on providing top-quality customer solutions. The Company is comprised of AESS and CT Aerospace, LP ("CTAerospace"). Through AESS, Avatas is introducing a revolutionary brand of PT6A engine maintenance - ushering in a new era of freedom, participation and alternative for the aircraft operator. Headquartered in the Dallas/Forth Worth area, AESS is an Independent MRO Company for small gas turbine engines and components including parts sales and overhaul management. The Company is a full-service, FAA-approved Repair Station specializing in the PWC PT6A engine series and operates in a 65,000 sq.ft.facility.

A short-term project is to set up the whole Business Intelligence involving all different systems.

Responsibilities:

• Designed and set-up Business Intelligence using Jasper products.
• Installed, configure JasperServer 3.0
• Designed and developed reports using ireports.
• Uploaded reports using JasperServer.
• Trained users, reports designers.
• Worked as a liaison with a Quantam (SQL)database expert and trained on the Database Structure
• Performed business intelligence work in respect to trending analysis of both financial and shop performance.

Environment: Firebird 2.1, Quantum Control, IBX, IBO, Oracle 10g, iReport 3.0, JasperServer 3.0, mySQL

Confidential, Irving, Texas
Analyst/Report Developer Feb 2007-March 2008

Confidential, is the world leader on the mobile phone market. Nokia is also aiming for the top of the emerging mobile Internet market. The company's products are divided primarily among four divisions like mobile phones, multimedia, networks, and enterprise solutions. It has combined its network equipment business with that of Siemens a joint venture also known as Nokia Siemens Network. The main projects were developing reports and models for supporting users, worldwide.

Responsibilities:

• Work with Business Units to define Business strategy and create a centralized reporting capability for users to perform analytical, and ad-hoc reporting for business applications and provided accurate information for the Decision Makers.
• Involved in Designing and Creating various Projects in Framework Manager
• Involved in Designing Models using Framework Manager.
• Involve in testing and verifying model if the results of queries are accurate.
• Created and Published Packages using Framework Manager.
• Set user roles, define governors and set access authority for the packages to different users.
• Create report using Query Studio and Report Studio component of Cognos 8 BI.
• Trained End Users in developing the Ad Hoc reports using Query Studio.
• Developed Standard reports, Charts, Drill through Reports, and Master Detail Reports using Report Studio.
• Responsible for the delivery of solution-oriented complex reports using Cognos Report Studio.
• Developed filters, calculations, prompts in different reports to customize reports according to reporting requirement using Report Studio.

Environment: Cognos 8 BI ,Report Net 1.1 MR2, Framework Manager, Report Studio, Cognos Connection, Windows 2000, Sql Server 2000, Query Analyzer.

Confidential, Irving, Texas
Applications Support Specialist/Administrator May 2000- June 2007

• Supported client server management applications with Oracle as backend, for the software department.
• Designed database, implemented, and maintained for large scale, high transaction, high availability databases in a telecom environment.
• Worked on data modeling, data architecture, query optimization, performance tuning, replication, backup and recovery design, and data warehousing. Maintain and refine database architecture and standards.
• Provided documentation for alterations to current state systems and future project designs.
• Created and maintained user accounts. Trained end users.
• Designed project reports using SQL queries.
• Used Oracle SQL queries extensively and created all program-level ad-hoc reports.
• Provided advisory support for project and resource management system (ProgRess) for R&D programs and projects.
• Supported and facilitated upcoming product and system programs from E-1to E5.
• Contributed to planning, including product creation process (PCP), program structures (PRS), work breakdown structures (WBS) and code categories for project.
• Encouraged and motivated project planning, time reporting and resource management.
• Maintained resource management analysis throughout programs.
• Compared program need and actual data monthly.
• Advised process management and development.
• Supported process- and tool-related trainings and advanced support.
• Built up and maintained need pool and structure and defined guidelines for PRM system usage.
• Supplied all business areas with status information from PRM system on all levels.
• Identified improvement issues to PRM development, including SQL queries, PRM reports and application development requirements.

Environment: Windows NT, 4.0, Oracle 8.0.5, Oracle 8.1.7, Oracle 9.2.0.4, Toad, SQL*Loader, Remedy, Citrix and Artemis.

Training

Radiant Systems, Richardson, TX , 1997 Diploma in Client Server Programming
APTECH, Kathmandu, Nepal,1996, Diploma in Information System Management

Education

B.S., Business Administration

Personal

US Citizen - Security Clerance