SPECIFIC EXPERTISE:

• Highly skilled IT Professional with over 7 years of experience working for major corporate clients, with an extensive and wide range of IT leadership, planning, programming knowledge, skills, abilities, and experience working as Applications Analyst, Systems Analyst, Project Manager, Solutions Architect. Experienced in translating the business requirements into Business Requirement Documents (BRD), Functional Requirement Documents (FRD), Requirement traceability matrix and System Requirement Specification.Expertise in Business Process Modeling, Process Improvement, Feasibility Analysis, Gathering - Elicitation & Management of requirements, GAP Analysis, Design & Development of Business Applications & Project Management Skills.Acted as a liaison between business people who have a business problem and technology Efficient in creating Use Case Diagrams, Activity Diagrams and class diagrams, using Unified Modelling
• Hands on experience in Full Life Cycle design & development of Data warehouse, ETL and Cognos Reporting Process. Relevant industry experience in SAP HANA and IBM COGNOS.
• Good experience in Administration, designing, development and deployment of Data Warehousing and Business Intelligence applications using COGNOS Suite 8/10/11 and Cognos Report Net
• Extensive experience working with Cognos 11/10.x/8.x Business Intelligence Reporting Suite (Framework Manager, Event Studio, Report Studio, Query Studio, Transformer, Dynamic Cubes, Workspace, Workspace Advanced, Tableau, QlikView, Visio, Datastage,TM1).
• Expertise in Framework Manager Modeling (Physical Layer, Business Layer, Packages) with Relational & DMR and Complex Report building with Report Studio
• Involved in Installation, Configuration, and Administration of COGNOSSeries10& 11 Suite.
• Well-versed in developing reporting applications using Cognos Business Intelligence components like Report Studio, Framework Manager, Query Studio, Analysis Studio, Metric Studio and Cognos Connection.
• Installed, configured and worked on Cognos BI Suite, including Business Insight & Advanced, Report Studio, Workspace Advanced, Framework manager, Transformer and Cube Designer.
• Involved in COGNOS administration and security implementation among COGNOS Applications using Cognos Access Manager, LDAP, Custom Authentication Provider. Performed administrative roles in COGNOS Connection and set security permissions, configured and maintained users, groups and roles using COGNOS Administration.
• Technical expertise in Data Warehousing (Relational, Dimensional Relational (DMR), &OLAP Cubes) modeling and development, schemas (Star & Snowflake), logical data marts & table structures (fact & dimension) using Modeling tools such as Cognos Transformer, Cube Designer and Framework Manager.
• Experience in Creation of Models, Project and Publishing Packages using Framework Manager and created IQD’s in Framework Manager to use in Cognos Transformer using externalized method and also in Cognos Data Manager.
• Complex Report building experience in Report studio by using filters customized prompts, conditional formatting, drill-through, Cross tab, bursting, Master/details queries.
• Expertise with SAP HANA Studio with Modelling and Administration Perspectives. Has extensively worked with Accelerated SAP Methodology in Implementations.
• Good exposure and hands on experience with Data Replication scenarios of SAPHANA which include SLT, BODS (ETL Extraction), DXC and Flat files.
• Expertise in creating various Information Models like Attribute, Analytic and Calculated Views.
• Worked on all database management applications and executed retrieval of complex database effectively. Strong experience in creating and publishing packages in Framework Manager.
• Generated different kinds of reports in Report Studio, created templates and multilingual reports.
• Assisted business users in validating the data. Interacted with Customers for requirement gathering, effective analysis and also to provide end-user training.Experienced in developing Dashboards Reports in Cognos 10 and 11.
• Experience in conducting Joint Application Development (JAD) sessions and interviewing Subject Matter Experts (SMEs), asking detailed functionality aspects of business process and carefully updating the information to the requirements in an easily understandable format.
• Prepared and executed functional Test Plans for User Acceptance Testing (UAT) to support business users.
• Energetic, self driven and passionate with good relationship management, team management and communication skills. Extensive experience with cross country teams and working directly with offshore teams also.

TECHNICAL SKILLS:

Business Intelligence,Reporting & ETL Tools: Cognos 10 & 11 BI tools (Report Studio, Analysis Studio, Query Studio, Cognos Connection), Framework Manager, SAP, Cognos 10.1/8.4 Suite (Framework manager, Report Studio, Analysis Studio, Cognos Connection, Event Studio, Query Studio) Cognos EP Series 7.3, Business Objects 5.1, Cognos Impromptu 7.3, Power Play Transformer, Cubes, IWR, Visual Studio, SAP Business Objects DataServices 4.0, IBM InfoSphere 8.7. Data Stage, ERWIN, TM1, Tableau, Qlikview

Databases: Oracle 9i/10g/11g, SQL Server 2000/5.0, DB2-400, DB2-UDB, Teradata, IBM Netezza

Modeling Tools: Cognos Cube Designer, Cognos Transformer& Cognos Framework Manger.

Computer System: Win95/98/2000/XP/7, Windows NT, AS400,Unix, Linux

Programming Languages: SQL, Cobol, Java, Sequel Query

Data Modeling/Reporting/ETL: SAP HANA Studio, MS Access, Excel, Visio, MS Project, SVN, OMS, Database Monitor (DB Mon), Performance Explorer (PEx), Framework Manager, Erwin, MS SQL Server, PowerPoint

Methodologies: OLAP,HOLAP,RAD, AGILE, RUP &Waterfall.

Testing Tools: Quality Center, QTP, Load Runner

PROFESSIONAL EXPERIENCE:

Confidential, Greensboro, NC

Lead Business Intelligence Expert

Responsibilities:

• Involved in business discussions, Architecture discussions and reviewing the Technical & Functional documentation.
• Co - ordinate the one integrated team of SAP, Accenture, VF. Master, Transactional data cleansing, migration and validation.
• I was part of the program where project was managed applying the Methodology, represented by the “V-Model” - which helped to illustrate the iterative nature of the methodology.
• Planning and tracking project schedules through the SharePoint list and Excel tracker, Ensuring consistency in planning process, methods and tools across work streams.
• Good proven knowledge of SAP ERP - (Accounts Receivable, Accounts Payable, General Ledger etc., of FI-CO module.
• Worked closely with the Accenture technical team on implementing the customer’s first project on HANA.
• Designed and implemented SAP HANA data modeling using Attribute View, Analytic View, and Calculation View.
• Implemented SAP HANA Smart Data Access which makes it possible to access external data, without having to replicate the data to the SAP HANA database.
• Replicated data using SLT and BODS and created models as per requirement.
• Scheduled reports were developed with Filters and logical calculations to focus on the certain data only in the Cognos Report Studio based on the requirements.
• Reporting, Accessing Analytical and Calculation views from EXCEL as well as Cognos Report Studio.
• Established Cognos connection to the Calculations views which were developed on the Hana Database and deployed it to the Report Studio.
• Generated various List Reports, Cross tab Reports, Chart Reports, Master-Detail Reports, Drill-Down and Drill-Through Reports.
• Created Dashboards to present critical company data in a single report on the Cognos advanced environment 11.
• Created Sophisticated Reports using Report Studio.
• Manually modified the SQL in Report Studio to tune and/or to write complicated reports. Used union/Join objects in Report Studio.
• Developed Prompt Pages, Cascaded input Prompts to display only the selected entries in the report and worked on the customization of prompt parameters.
• Created Query subjects, query items, Filters and logical calculations.
• Writing SQL queries to define search strings and pattern to retrieve specific data from the database.
• Hyper Care was provided to the end business users where defects were managed through HP Quality Centre.

Environment: IBM COGNOS 10 & 11 BI, (Framework Manager, Report Studio, Analysis Studio, Query Studio)SAP HANA, Tableau, TM1, DB2, SQL, HP Quality Center.

Confidential, North Brunswick, NJ

COGNOS Developer

Responsibilities:

• Involved in business requirement discussions and reviewed business requirement documents with the business team to understand the architecture and functionality of the application.
• Developed Metadata models and DMR models using Framework Manager and created filters, prompts, calculations, summaries and functions as per Functional Requirement Specifications.
• Created models using Framework Manager consisting of star schemas, dimensions, facts, calculations, links and multiple namespaces; applying proper securities and publishing packages.
• Worked on framework manager to import metadata from multiple data sources and to create subject oriented business models, create and publish packages to Cognos server.
• Created database layer and business layer, defining appropriate relationship between query subjects in Framework Manager.
• Analyzing existing transactional database schemas and designing star schema models to support the users reporting needs and requirements.
• Created simple to complex reports as well as Dashboard like reports using Report Studio by applying various concepts and functionalities such as drill-through, conditional reporting, block, tables, charts, master-detail, maps, various calculations and joins using tabular sets and models.
• Created reports in Report Studio using Relational and Dimensional Models.
• Created list reports, cross-tab reports and chart reports using multiple queries in a single report, drill trough reports and conditional formatting to highlight the business needs.
• Created custom prompted reports in Report Studio, Bursting reports to different user groups.
• Involved in working with Cascading Prompts and Conditional Blocking.
• Manually modified the SQL in ReportStudio to tune and/or to write complicated reports. Used union/Join objects in ReportStudio
• Closely worked with ETL team to design Data Marts by understanding user requirements and increasing the reporting efficiency.
• Wrote SQL queries to validate data in Cognos reports with database.
• Unit Testing reports built using Report Studio and Query Studio.
• Performance tuning by analyzing and comparing the turnaround times between SQL and Cognos.
• Extensively worked on scheduling and deployments.
• Created reports from DMR models using Dimensional Functions.
• Reviewed Business Requirement Document (BRD) and Function Specification Document (FSD).

Environment: Cognos 10.2(Cognos Connection, Report Studio, Query Studio, Framework Manager), SQL, IBM DB2, Windows.

Confidential, Irving TX

Lead COGNOS Admin/Developer

Responsibilities:

• Interacted with the Business users and documented their Query, Business and Reporting needs and Analyzed the data and business logic underlying the requirement.
• Used COGNOS 10.1.1 to develop Framework Data modeling for inbound/outbound reports for logistic business requirements
• Worked on Cognos10 framework manager to import metadata from multiple data sources and to create subject oriented business models, publish packages to BI server and also involved in Cognos server administration, OLAP administration.
• Used Cognos Connection as Web Portal for managing reports by using folders and security groups.
• Involved in Metadata modeling of both Relational and Dimensional data using Framework manager.
• Implementing security based on groups and roles in LDAP and CJAP.
• Built Multi-Dimensional Models (DMR) with Relational Data using Framework Manager and Deployed Packages to the Report Servers.
• Generated report bursting using Cognos users CAMID
• Implemented Framework manager security for Data access, Object level access and Package access based on the Organization Level.
• Developed Framework Manager Models against Teradata and Oracle Database.
• Tested reports in analysis studio for upgrading it to cognos10.1 from 8.4
• Delivered advanced/ complex reporting solutions such as Dashboards and Standardized Reporting including the bursting of reports globally using Cognos 10.1.
• Developed reports in Analysis Studio from Powerplay Transformer Cube.
• Scheduled and Distributed Reports through Schedule Management in Cognos Connection.
• Designed models by mapping business needs using Power Play Transformer and created multi dimensional cubes, cube groups, Power Play reports.
• Designed multidimensional models using Transformer. Decreased the Cube build times drastically and increased runtime performance.
• Customized Reports by writing complex custom SQL.
• Worked with ETL team for loading /Extracting data from Netezza data base.
• Security Administration for setting up users, groups and roles and creating access permissions.
• Deliver advanced/ complex reporting solutions such as Dashboards, Scorecards and Standardized Reporting (including the bursting of reports globally) using Cognos 8.
• Creating IQD files from Report net and designed Power play models in Transformer.
• Built Power Play Reports based on the cubes and published to Report Net Server.
• Involved in building the complex cubes and optimizing the cube creation
• Third Party Security with LDAP and use those in creating Data Level, Object Securities in Framework Manager Models.
• Assigning work to the offshore team on daily basis.
• Developed technical specification document for the offshore team.

Environment:COGNOS 10.1(Cognos Connection, Report Studio, Query Studio, Framework Manager), Access Manager, SQL Server 2005, Oracle 10g, Windows XP.

Confidential

COGNOS Admin/Developer

Responsibilities:

• Analyzed of business function and looking for current market requirements.
• Prepared data models and identifying data items. Created models and published packages to be used for report building. Upgrading reports to Cognos8.2.
• Modeling data according to the requirements using Framework Manager.
• Created DMR models and relational Model - Import database tables defining database layer, presentation layer, business layer, defining proper cardinality, applying determinants, apply row level and object levels security, applying embedded/standalone filters, providing multilingual support to package, publishing package and applying package security.
• Created Classes and Objects, Joins and Predefined conditions, Custom Hierarchies.
• Created templates to maintain a uniform standard across all the reports.
• Restricting the user access with help of Access Level privileges.
• Modified the existing sales reports through report studio. Created specs and SDLC documentation for them. Tested the data by querying the database and/or by the cubes.
• Used HTML and JavaScript to create complex weekly sales reports. Performed dry runs for the cognos8 qualification purpose.
• Converted business requirements into design artifacts.Recreated Powerplay reports in Analysis Studio.
• Created security in cubes so that the sales reps can see data only for their respective territories.
• Worked with the users to resolve their application and data related issues.
• Modified the current sales cubes to include data for expanded sales force and added new date categories under the date dimension.
• Created/modified/enhanced Lists, cubes and D-Links in Cognos Planning Analyst. Used macros to automate the tasks. Created incident and change control requests (rfc) through remedy.
• Enhanced the report performance by performing database tuning and optimization in (FM) framework manager.
• Determine correct calculation for forecasting year-end and monthly-end headcounts.
• Created Cognos NOW real time continues monitoring the KPIs using Dashboards.
• Created CGP (Corporate Giving Program) reports.
• Worked with Operational Data Store (ODS) to integrate data from multiple sources to facilitate operation, analysis and reporting.
• Provided the security access management by creating users/groups and folders and also involved in Cognos server, PowerPlay and OLAP administration.
• Used debugger to evaluate ETL timings and optimized SQL’s in mappings to run faster.
• Workflow manager to create Workflow sessions to define mapping sequence.
• Optimized mappings by using Aggregator, filter, Joiner, Expression.Optimized the workflows for the better performance.
• Created Unix shell scripts to automate batch jobs through cron. Some of the jobs involved in populating or updating the dimension tables.

Environment: HTML, Cognos 8.2Intel P - 4, AS400 iSeries, Windows XP, SYNON, STRDBG, Data Mirror, Connect Direct, SSH, SSL, MIMIX. DB2, SQL Server Management Studio 2008 R2 database, XML, Excel

Confidential

Associate Developer

Responsibilities

• Created Framework Manger Models and created and published packages into the portal.
• Created Standard Reports using Report Studio and Ad- Hoc Reports using Query Studio.
• Interpreted complex Business specifications developed by the client and generated cubes and reports to meet customer specifications.
• Created standard and Ad hoc reports using Cognos Impromptu Designed catalogs and defined User Classes, Security and Privileges.
• Created Multi-dimensional reports by implementing Multi-Dimensional Cubes using Power Play and Transformer.
• Provided security for Cubes of various User classes. Used Date Wizard to create time dimension in Transformer for creating cubes and Power Play reports.
• Calculated fields, created manual dimensions and used special categories for creating cubes and reports using Transformer models.
• Created Impromptu Web Reports and published them on the web server and later on upfront.
• Created News boxes in Upfront and customized the environment. Set Security for News Item and New boxes in Upfront. Set Privileges for user classes by defining News Index AdminWorked on tickets (ticket is an issue reported by users) in various AS/400 applications.
• The ticket may include the following types of activities like Analysis, Data Correction, and Development of new programs & set up activities.
• Monitored production jobs
• Provided production support to the application users and maintenance
• Estimation of the enhancement.
• Completed all the development activities within the specified time lines with zero defects.
• Resolved support tickets when no development activities.
• SME documentation in Scheduling & Dispatching.

Environment: Oracle 9i, Cognos 10.1, Cognos ReportNet1.1 MR3 (Framework Manager, Cognos Connection, Query Studio, Report Studio),Cognos Impromptu Admin/User, Power play Transformer, Power play for Web/Windows, Cognos Report net 1.1, Windows 2000, AS400 iSeries, Windows XP, Oracle, DB2