SUMMARY

• Over 12 years of IT experience in the Business Requirement Gathering, Application Design, Data Modeling, Development, Implementations and Testing of Data warehousing and Database systems for Financial, Telecom, pharmaceutical and Insurance industries.
• Experience in Cognos 10.x, Cognos 8 BI Report Studio, Query Studio, Analysis Studio, Event Studio, Metric Studio, Active Reports, Cognos Insight, Insight Advanced, Workspace, Workspace Advanced.
• Extensive Data warehousing experience using Cognos ReportNet 1.1(MR1, MR2, MR3)/1.0, Cognos Impromptu 7.x/6.x, Cognos Power Play, Cognos Architect, Cognos Power Play Transformer, Cognos Visualizer, Impromptu Web Reports (IWR), Upfront, Cognos Query, Power Play Enterprise Server.
• Strong experience in Cognos ReportNet Framework Manager, Report Studio.
• Knowledge of Cognos Metrics Manager, Notice Cast, Decision Stream.
• Proficient in Report Studio, Query Studio, Analysis Studio and Cognos Connection.
• Extensively used Framework Manager, Query Studio and Report Studio for model design, ad - hoc reporting and advanced report authoring.
• Installed and configured various components, such as the Framework Manager and Content Manager.
• Experience in building multidimensional models and creating Power Cubes for distribution using Power Play Transformer.
• Strong experience in Dimensional Data modeling, Star Schema/Snowflake modeling, FACT & Dimensions tables, Physical & logical data modeling.
• Involved in the full Project Life Cycle of the Data Warehouse Project.
• Exposure to client interaction and user-requirement analysis.
• Data warehousing ETL experience using Informatica Power Center/Power Mart
• Knowledge of SDK.
• Data warehousing experience using Business Objects.
• Experienced in Ralph Kimball’s methodology and Inmon’s approach.
• Provided technical and functional consulting to corporate and divisional users for Cognos.
• Experienced in working Databases like Oracle, MS SQL Server 2005/2000, DB2.
• Wrote Triggers and Stored Procedures using PL / SQL
• Proficient with Java, ASP, EJB, Swing, Java Scripts, RMI, Servlets and XML.
• Worked with different data sources like Flat Files, XML files, Databases and ERPs.
• Extensive hands on experience handling duties such as Creation, Implementation, Monitoring, Performance Tuning, Backup / Recovery.
• Trained Business users for Ad-Hoc reporting
• Have excellent problem solving, time management skills, communication skill, good organizational skill, self-motivated, hard working, ability to work independently or cooperatively in a team and eager to learn.

TECHNICAL SKILLS

Cognos Suite: Cognos 10.2/10.1/ 8 BI (8.1,8.2, 8.4.1) Report Studio, Query Studio, Analysis Studio, Event Studio, Metric Studio, Cognos Insight, Insight advanced, Workspace, Workspace Advanced, Cognos Report Net1.1(MR1, MR2, MR3)/1.02(Query Studio, Report Studio, Framework Manager, SDK), Cognos TM1,Cognos Impromptu 7.x./6.x, Cognos Power Play Transformer 7.x/6.x, Impromptu Web Reports (IWR) 7.x/6.x, Upfront Server Administration, Power Play Enterprise Server 7.x/6.x, Access Manager, Cognos Script Editor, Cognos Scheduler, Visualizer, Metrics Manager, Notice Cast

Data Modeling: Erwin

Business Intelligence: Cognos, Business Objects, SSRS, SSAS, MSBI

ETL: Informatica PowerCenter, Power Mart, Data Stage, DTS, SQLServer Integration Services.

DatabasesTools & Utilities: Oracle 11g/10g/9i/8i/, SQL Server 2012/2008/2005/2000, DTS, DB2, Teradata, MS-Access.

Languages: SQL, PL/SQL, UNIX Shell scripting.

Programming Languages: C, C++, C#, JAVA, VB, VISUAL STUDIO.NET.

Operating Systems: UNIX (Sun and HP), Redhat Linux, Windows2000/XP, DOS.

Other Tools: TOAD, SQL Loader.

PROFESSIONAL EXPERIENCE

Confidential, Richardson, Texas

Process Design / Report Consultant

Responsibilities:

• Gathered Business requirements and designed functional and technical requirements documentation.
• Complex Business specifications developed by the client and generated cubes and reports to meet customer specifications
• Interaction with the Management and Development teams for Requirement gathering.
• Involved in the Installation and Configuration of Cognos BI Development, Test and Production Servers.
• Security Administration for setting up users, groups and roles and creating access permissions
• Incorporating Corporate LDAP in Report for authentication
• Setting up PowerPlay Enterprise Server to publish cubes on to Report Portal
• Created database layer and business layer, defining appropriate relationship between query subjects in Framework Manager.
• Set up the Security at the package level, query subject level and the query item level.
• Implemented Star Schema Grouping and Dimension Hierarchy in Framework Manager Model.
• Expert in Creating DMR Models.
• Experience in Cognos TM1 Administration
• Designed and developed the Framework Manager models and published into the Cognos connection.
• Created Packages in Framework Manager by importing metadata from different data sources.
• Implemented Framework manager security for Data access, Object level access and Package level access based on the Organization Level.
• Expert in Production support for complicated issues.
• Created various complex Active reports, List Reports, Grouped Reports, Cross tab Reports, Chart Reports, Drill-Through Reports and Cognos Insight Advanced
• Deliver advanced/ complex reporting solutions such as Dashboards and Standardized Reporting (including the bursting of reports globally) using Cognos.
• Collaborated with Business Leaders to share and gather Cognos Planning requirements.
• Developed and prepared new and enhance existing Cognos applications.
• Created Transformer models and Power cubes for Multidimensional analysis.
• Maintained Dimension level Security for Cubes in Power Play Transformer.
• Designed models by mapping Business needs using PowerPlay Transformer and created Multidimensional cubes, cube groups, PowerPlay reports.
• Calculated fields, created manual dimensions and used special categories for creating cubes and reports using Transformer models.
• Bursting Reports and Multilingual Reports Using Report Studio.
• Involved in understanding the Business in all Departments within the organization.
• Expert in Cognos Business In sight Advanced and Business Insight reports.
• Used Cognos Workspace to organize the reports.
• Used Cognos Workspace advanced to create Advance Dash boards.
• Created Cognos Mobility Reports using Dashboards
• Experience in Cognos TM1 development
• Used SQL Server Reporting Services (SSRS) for Reporting as per the Business Need
• Created complex Tabular Models, SSRS Reports, Power Shell Scripting Dashboards in using Microsoft Business Intelligence
• Performance tuning by analyzing and comparing the turnaround times between SQL and Cognos.
• Addressing the Performance and other Production issues with the Cognos 8.4 reports and PowerPlay cubes.
• Trained the end users effectively to use the reporting tool, to build and customize their ad-hoc reports.
• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor
• Involved in building the ETL Mappings into Data warehouse
• Used SQL asst to Query the data from Teradata.
• Used Teradata Used Teradata Utilities like Fast Load, Multi Load, Fast Export.
• Used Teradata TPump for highly parallel utility designed to continuously move data from data sources into Teradata tables without locking the affected table
• Expert in Teradata Fast Load for highly reliable, parallel-load utility designed to move large volumes of data — collected from data sources on channel and network-attached clients — into empty tables in the Teradata Database
• Applied Teradata Multi Load for time-tested, highly reliable, parallel-load utility used to create and maintain Teradata Databases

Environment: Cognos 10.2/10.1/8.4 BI Report Studio, Query Studio, Framework Manager, Cognos Connection, Cognos Insight, Insight Advanced, Workspace, Workspace Advanced, SDK, Cognos TM1, Informatica,Teradata, Microsoft Access, Microsoft Excel, SQL Server, SSRS,SSAS, MSBI, Oracle 11g, IBM DB2, Windows

Confidential

Cognos Developer

Responsibilities:

• Upgraded Cognos Development, Test and Production environment from Cognos 8.2 to Cognos 8.4.1
• Configured the Cognos 8 BI Development, Test and Production Servers.
• Configured Security Administration for setting users, groups and roles and creating access permissions.
• Incorporated LDAP with Novell for Authentication for users to log on to the Cognos Connection Portal.
• Configured Cognos8 Namespace to integrate security.
• Interaction with the Management and Development teams for Requirements gathering.
• Extracted operational data from multiple sources, merged and transformed the data to facilitate enterprise - wide reporting and analysis and delivering data to co-ordinate data marts.
• Used Data Manager to transfer data in to single database tables and where complex transformations where required to populate data warehouse fact and dimension tables.
• Delivered metadata to Framework Manager which allows target data warehouse and data repositories to be modeled for Cognos projects.
• Created couple of Dashboards in Cognos 8.4.1 with the help of the Cognos Go dashboard..
• Publishing data movement tasks to Cognos Connection where they can be run and scheduled.
• Designed and created various projects and models using Framework Manager.
• Worked extensively on creating Models and publishing packages on Cognos Connection for Reporting purpose.
• Created filters and calculations within the Framework Manager Model for improving performance of the Model.
• Created the reports template to match the organization’s standard.
• Incorporated the organization’s logo in the reports template.
• Used Cognos Connection to administer and scheduling reports to run at various intervals as well as the ReportNet Server.
• Scheduled reports to run using Cognos Connection Schedule Management.
• Developed new reports in Report Studio upon requests from business users.
• Created, organized and formatted reports, Folders, Tabs and other contents on Cognos Connection portal.
• Communicated report development progress and issues to management and team members.
• Ensured compliance with standard software development practices, processes and enterprise standards.
• Trained staff in all aspects of knowledge for Data Manager, Framework Manager, Report creation etc.
• Troubleshooting was done on issues, which arose while creating data manager Dimension and Fact builds, Job Streams and scheduling the builds on the Cognos Connection and also with Framework Manager and Reports.
• Provided day-to-day support for all COGNOS Report studio users.
• Assist in end user acceptance testing.

Environment: Cognos 8.4.1 BI Report Studio, Query Studio, Framework Manager, Cognos Connection, Cognos Data Manager 8.4.1, Microsoft Access, Microsoft Excel, Oracle 10g/9i, IBM DB2, Windows, UNIX, Linux

Confidential

Data warehousing Consultant

Responsibilities:

• Involved in understanding the Business Requirements in all Departments.
• Created Reports (Simple & Complex) using QueryStudio and ReportStudio for training purpose.
• Created, organized and formatted reports, folders and other contents on Cognos Connection portal.
• Created several different types of ad-hoc (Simple List, Grouped List, Section Heading, Crosstab, and Nested Crosstab) Reports and represented data graphically by Charts utilizing Query Studio. Created several different types of Professional Reports (Mailing Labels, Web Page Style, Cascading, Linked / Drill Through, Production, Business, Ranking, etc…) with complex formatting utilizing Report Studio.
• Worked with functional and technical project leads, marketing, sales, finance, and other business groups to identify, analyze, and document Business requirements.
• Identified and worked with various application areas in identifying, analyzing, and documenting various information sources solutions to meet the business requirements.
• Worked extensively on Siebel applications (Siebel Answers, Delivers, and Dashboards).
• Created Dashboards by embedding reports and providing intuitive drilldowns and links to exploit the full benefit of Analytics.
• Involved in design and development of repository (Creating / Modifying objects in Physical, Business and Presentation layer) and the process of repository migration.
• Development of interactive drillable charts such as bar-charts, pie-charts, radars, bubble-charts, etc.
• Analytics Application Response-time Performance management using optimization efforts such as aggregate navigation, indexes and Oracle materialized views.
• Implementation of criteria filters to narrow-down the result set from the analytics requests.
• Developed/Bench-Marked performance tuning strategies with business model-level calculations versus data warehouse level pre-computations and aggregations. Gathered information like attempted calls type of call (long distance, local), length of call, originated number, destination number, rates, time of cal for creating report for billing of a customer.
• Used Workflow Manager for Creating, Validating, Testing and running the sequential and concurrent sessions and scheduled them to run at specified time with required frequency. Developed and executed test plans and played an active role in product rollouts.
• Life-cycle support for migration efforts from development to QA to production analytics.
• Involvement with ETL (Extract-Transform-Load) development team to communicate the specification for the required dimensional, aggregate and indexed data tables.
• Involved in development of many complex Informatica mappings and mapplets to build key interfaces using transformations and reusable transformation units (Update Strategy, Filter, Router, Expression, Lookup, Aggregator) for loading data into Data Warehouse.

Environment: Siebel applications, ReportNet 1.1, Framework Manager, Cognos Connection, Report Studio, Query Studio, Informatica,Microsoft Access, Microsoft Excel, MS SQL Server 2000

Confidential

Financial Analyst

Responsibilities:

• Prepared and analyzed accurate and concise management reports including but not limited to financial reports such as income statements and balance sheets and line of business profitability reports to be used in management decision making.
• Performed hoc reporting and general financial analysis in support of corporate and divisional lines of business. Compiled data and developed reports for the pricing package.
• Data query and research for monthly, quarterly and annual reporting, as well as audit and exam requests, and outage research. Responsible for data mining to support financial decisions.
• Served as a backup for additions, changes, and deletions to the chart of accounts for the general ledger and the planning system. Ensured proper and consistent linking to all reports, including internal, Board and Regulatory reporting, as well as to additional systems if needed.
• Assisted with system upgrades and new releases from an accounting and system reconciliation perspective. Lead the research, documentation and communication of issue resolution with vendors and management as necessary.
• Involved in Installing and Configuring ReportNet Server, FrameWork Manager.
• Configured Cognos8 with Cognos 7 series Namespace to integrate security.
• Involved in understanding the Business in all Departments within SSA Global.
• Involved in Strategic Planning for Cognos ReportNet Framework Model.
• Built Models and published Packages utilizing Framework Manager.
• Created database connections for different data sources.
• Created Reports (Simple & Complex) using QueryStudio and ReportStudio for training purpose.
• Created, organized and formatted reports, folders and other contents on Cognos Connection portal.
• Created several different types of ad-hoc (Simple List, Grouped List, Section Heading, Crosstab, and Nested Crosstab) Reports and represented data graphically by Charts utilizing Query Studio. Created several different types of Professional Reports (Mailing Labels, Web Page Style, Cascading, Linked / Drill Through, Production, Business, Ranking, etc…) with complex formatting utilizing Report Studio.
• Created reports for various departments like HR, Sales, and Production etc.
• Develop Customize and Burst Reports using Report Studio.
• Produce Queries and Reports in Multiple Languages. Format, Present and Distribute Reports utilizing Different Layouts, Multiple Report Objects and Multiple Logical Pages.
• Create Run, and Schedule Reports and Jobs using Cognos Connection.
• Involved with Scheduling and Distributing Reports through Schedule Management in Cognos Connection

Environment: Cognos ReportNet 1.1, Framework Manager, Cognos Connection, Report Studio, Query Studio, Microsoft Access, Microsoft Excel, MS SQL Server 2000