SUMMARY

• Around 6+ years’ experience on Business Intelligence tools like Cognos with deep knowledge of Data Warehousing along with 2 years of hands on Manufacturing Engineering experience.
• Created models and reports in Cognos 10.1 and 8.4.1/8.4/8.3/8.2 (Framework Manager, Report Studio, Query Studio, Analysis Studio, Metric Studio, Event Studio, and Business Insight).
• Designed and implemented data cubes using OLAP services, Cognos Impromptu, and PowerPlay, Transformer to facilitate executive, management and end user reporting.
• Working experience with Oracle 11g/10g/9i/8i, SQL Server 2010/2008/2005/2000 , PL/SQL, SQL Plus, Teradata, and DB2 V10/9.7.
• Proficient with planning, troubleshooting and performance tuning support of Cognos BI.
• Upgraded Framework Models, Packages and Reports from Cognos 8.4.1 to Cognos10.1.
• Experience in Dimensional Data Modeling, Star and Snow Flake Modeling, Fact & Dimension tables.
• Complex Report Building Experience by using Customized Prompts, Conditional Formatting and Complex Layouts like Cross tabs, Charts and Scorecard reports, and bursting.
• Usage of Query Studio to build ad hoc Business reports and Report Studio to build advanced reports (multi - page, multi-query reports).
• Worked on performance tuning for existing reports in Report Studio and testing and improving Report Performance and performing Query optimization.
• Experience in SQL during development and testing of reports, analyzing data, Cardinality between tables and Joining tables.
• Involved in Installation and Configuration of Cognos series 7, Cognos 8.4 and Cognos 10.1.
• Experience in Autodesk software suite, statistical software Minitab and scheduling software MS Project.
• Experience in interacting with Business Users and gathering the requirements for report purposes.
• Excellent problem solving, time management and communication skills, good organizational skills, self- motivated, hardworking, ability to work cooperatively in a team and eager to learn.

TECHNICAL SKILLS

Business Intelligence Tools: Cognos 10.1, Cognos 8.4/8.3/8.2/8.1 , Cognos Report Net 1.0/1.1 (Report Studio, Query Studio, Cognos Connection, Analysis Studio, Metric Studio and Framework Manager), PowerPlay 6.3//7.0/7.1/7.2 , Cognos Impromptu, Cognos Transformer, Business Insight Advanced, Business Insight.

Data Modeling: Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables.

Database: Oracle 8i / 9i/10g/11g, MS SQL Server 2000/2005/2008/2010 , DB2, My SQL, Teradata

Programming Languages: C, C++, Java, SQL

ETL Tools: Informatica Power Center 7.1/6.2.

Other tools: MS Office, MS Project, Autodesk Suite, Minitab

Operating Systems: Windows 98/2000/2003 Server/ Advanced Server, Windows XP/Vista/7, Linux

Web Technologies: HTML and XML.

Web Servers: IIS and Apache

PROFESSIONAL EXPERIENCE

Confidential, Arlington, TX

Cognos Developer

Responsibilities:

• Developed Standard Reports, Charts, Drill through Reports, Cross tab Reports, List Reports, Summary Reports and Multi Object Reports using Report Studio.
• Designed and Developed Framework Manager Models to be deployed as packages
• Developed Prompt Pages, Calculations, and Variables & Filters
• Developed scorecards using Metric Studio.
• Extensively used Report Studio and Business Insight on lighter vein in designing Complex Dashboard Reports.
• Assigned various types of Securities using Governor Settings.
• Ability to work independently with minimal supervision and effectively meet project deliverables on time.
• Played a key role while modifying existing reports to have a better view from the point of end users.
• Involve in the process of moving the reports to productions through a specified process.
• Schedule the reports to limited audience on a monthly, weekly and daily basis.
• Interact with the offshore team and assign the work based on the criticalities.

Environment: Cognos 10.1/8 (Cognos Connection, Framework Manager, Query Studio, Report Studio, Event Studio, Metric Studio, Business Insight, BIA, Analysis Studio), Oracle 11g/10g, SQL Server 2008/2010, JavaScript, Windows XP.

Confidential, Holdingford, MN

Manufacturing Engineer

Responsibilities:

• Created and modified BOM in company ERP system.
• Created professional reports in Infor ERP XA and Microsoft Excel.
• Utilized SPC in Minitab to Control or Improve Process' to Reduce Waste.
• Experience in handling Administration tasks like bursting and scheduling the reports.
• Created and analyzed 3D models in Autodesk suite and Scheduled Projects in Microsoft Project.
• Performed Stress Analysis, FMEA, Gauge R&R, Time Standards
• Ability to work independently with minimal supervision and effectively meet project deliverables on time.

Environment: Infor ERP XA 2011, Autodesk Suite 2012(Inventor, AutoCAD, Factory design), Microsoft Project 2010, Minitab 2012, Windows XP, Windows Vista, Windows 7.

Confidential, Cambridge MA

Cognos Developer

Responsibilities:

• Created and supported the development of Complex Reports in Cognos while working with features including Conditional Formatting, Drill Through, Cascading Prompts, Query Calculation, Layout Calculation, Conditional Blocks, Master-Detail Relationship, Page Breaks, and Render Variable.
• Created List, Crosstab, Chart, and Repeater reports using Report Studio and Ad-hoc reports using Query Studio.
• Created both relational and DMR models using Framework Manager and extensively used the Cognos Transformer to build the cubes.
• Traced the performance of the reports from the Framework Manager level to the Report Studio level and tuned the reports for better performance.
• Working knowledge of security within Cognos at both the Cognos connection level and Framework Manager Level.
• Trained users in Creating Ad-hoc business reports using Query Studio
• Interacted with Business Analyst and gathered business requirements.
• Involved in the installation and configuration of Cognos 10, Cognos tools, web server and assisted in upgrading reports from Cognos 8.4 to Cognos 10.
• Developed scorecards and executive dashboards, as means for measuring activities and outcomes for effective performance management.
• Developed and Implemented Best Practices (Development Standards, Modeling Standards & Security Model).

Environment: Cognos 10/Cognos 8.4 (Framework Manager, Cognos Connection, Query Studio, Report Studio, Metric Studio, Business Insight Advanced, Business Insight, Analysis Studio, Transformer and Event Studio), HTML, Teradata 12, SQL Server 2008/2010, Cognos Transformer 8.4, Windows 2003 Server, Windows XP.

Confidential, Boston, MA

Cognos Developer

Responsibilities:

• Interacted with Business Analysts in gathering reporting needs.
• Responsible for mapping report fields with data base tables and columns that ultimately led to the creation of framework manager model required for report building.
• Created Projects, Namespaces, Models and Packages using Cognos Framework Manager and deployed packages on Cognos Connection.
• Created folders, filters, prompts, and complex financial calculations in Framework Manager and Report Studio.
• Created charts, lists and crosstabs, using Report Studio and ad hoc reports using Query Studio.
• Introduced Java Script customizations to the report elements and also for advanced sorting, hide and show reports
• Developed various dimensions, measures and calculation in Cognos Transformer.
• While working on Transformer, created PowerCubes that user can further use to slice and dice data.
• Created Export and Import of Cognos Packages from one environment to another for deploying the content store information in testing schemas used for UAT.
• Trained users to use the Cognos connection to access their corresponding reports and cubes.

Environment: Cognos 8.3 BI (Framework Manager, Report Studio, Query Studio, and Analysis Studio), Oracle 10g, IBM DB2, Windows NT/2000, Windows XP, JavaScript, Cognos Transformer, PowerCubes.

Confidential

Jr. Cognos Developer

Responsibilities:

• Queried data from different database tables as per the requirement.
• Customized data by adding calculations, summaries and functions.
• Developed Complex Report Studio Reports.
• Created Drill- through reports and Customized Reports with Prompts (List. Cross tab).
• Creating IQD files from Report net and designed Power play models in Transformer.
• Involved in building the Cubes and optimizing the cube creation.
• Responsible in the weekly refresh of multiple multi-dimensional cubes.
• Designed extensive sample business Reports to cater the needs of business users.
• Assisted users in troubleshooting their reports.
• Created Drill-Down Hierarchies and used slicing and dicing technologies to provide optimized Reports.

Environment: Cognos ReportNet 1.1 (Report Studio, Query Studio, Cognos Configuration, Cognos Connection), Cognos Power Play 7.2/7.3, Power Play Enterprise Server 7.3, Power Play Transformer 7.2/7.3, Access Manager, Oracle 9i, SQL Server, Oracle 9i, Windows XP.