PROFESSIONAL SUMMARY:

• Around 7+ years of IT experience in Requirement Analysis, Designing, Development, Testing and Implementation in Business Intelligence teams.
• Played a key role in business requirements gathering / analysis, data warehouse designing / development, integration and testing.
• Excellent understanding of SDLC (Software Development Life Cycle) and worked in Agile and Waterfall methodologies.
• Familiar wif Change Management and Promotion to Test / Production processes.
• Worked wif Business Users in understanding teh requirements to develop Technical Documents.
• Familiar wif Data warehousing concepts along wif implementation of Business Intelligent systems, Operational Databases, Data Marts, understandingof Star and Snow Flake schemas.
• Working experience in developing Relational and Dimensional models using Framework Manager and Transformer by connecting to multiple data sources.
• Worked wif windows security team in creating Active Directory Security groups and applied data level, object level, and package level securities while creating models.
• Worked wif Report Studio, Query Studio, Analysis Studio, Metric Studio, Event Studio, Active Reports, Cognos workspace and workspace advanced.
• Developed Complex prompt, conditional, Drill up, Drill down and Drill though reports.
• Extensively worked on Design and Building Dashboards and Scorecard reporting.
• Strong working experience wif different Databases like Oracle 12c, 11g/10g/9i, SQL Server 7.0/2000, MS Access and DB2.
• Proficient wif accessing data in TOAD, MS SQL Server 2008 and implementing data solutions utilizing PL/SQL.
• Desire to learn new skills, technologies, and adapt to new information demands.
• Excellent oral and written communication skills and inter - personal skills.
• Have teh strength to handle teh project independently as well as handling/managing teh team.
• Strong in design, development and implementation of applications on Microsoft technologies using different versions of MS Operating Systems
• Self-starter and Team player, capable of working independently and motivating a team of professionals.

TECHNICAL SKILLS:

BI Tools: COGNOS 10 BI Suite (Framework Manager, Report Studio, Query Studio, Analysis Studio, Event Studio, Metric Designer, Metric Studio, COGNOS Connection), COGNOS SPSS, LDAP Server, SDK Tools), Tableau 9.1,9.2

Data Base Applications: Oracle 12c, 11g/10g/9i, SQL Server 2008/2005, Teradata, DB2, Sybase, MS Access.

Programming Languages: SQL, PL/SQL, C, Java, C#

Web Technologies: HTML, XML, JavaScript, CSS, JQuery

Scripting: Unix Shell Scripting, Java Scripting

Other Tools: MS Project, TOAD, WINSQL, IBM Data Studio

Operating Systems: Windows 10, 7, 2000/NT/98/95, UNIX / Linux /AIX.

PROFESSIONAL EXPERIENCE:

Confidential, San Diego

Cognos Consultant

Responsibilities:

• Worked wif Business users to analyze teh business process and user requirements.
• Interacting wif Business Users for gathering Business Requirements to develop teh report mockup and reports.
• Managed teh on-site and offshore team and developed client relationship through all phase of teh implementation cycle.
• Planned, and successfully implemented teh cross functional projects wifin defined budgets and timelines.
• Created teh changes and tasks for implementation process.
• Modeled Star schema in Framework Manger for better performance using different data sources.
• Designing Relational and DMR models using Framework Manager and deployed packages to teh Cognos Connection.
• Applied Package level, Object level and Data Level Securities.
• Developed complex prompt pages wif multiple styles of prompt functionality.
• Created Complex List, Cross tab, and Chart reports using Report Studio.
• Created joins between Queries to create Complex Reports in Report Studio.
• Created Drill thru and Drill Downs on Dashboard reports to details reports.
• Created Dashboards, Scorecards, Active Reports, complex reports using Report Studio,Cognos workspace.
• Created Conditional formatting and Conditional Block reports.
• Used Java Scripts used to achieve various functionalities in Report Studio.
• Developed various dimensional and relational reports.
• Bursting teh Reports in Cognos Environment and distributed to different user groups.
• Involved wif Scheduling and Distributing Reports through Schedule Management in Cognos Connection.
• Created OLAP reports using cubes and DMR as data source in Analysis Studio.
• Exposed to Transact-SQL, PL/SQL, Stored Procedures, Packages, UNIX Shell scripting and Windows batch file creations for Oracle, SQL Server2k databases.
• Handled pre implementation and post implementation issues as part of implementation process.
• Developed SQL queries to test teh database values for data integrity.
• Coordinated wif testing and business team for UAT, UTC and resolving teh support issues.
• Assisted ETL team to develop summarized tables
• Working wif different client teams to support issue and enhancement based on tickets created by users. Handled Production Support issues.

Environment: Cognos BI 10.2/10.1/8.4 (Framework Manager, Cognos Connection, Query Studio Report Studio, Metric Studio, Analysis Studio, Business Insight, Business Insight Advance and Event Studio), SAP Business Objects, Crystal reports, Informatica, IBM DB2, Teradata, SQL/PLSQL and Windows server and Unix.

Confidential, Richardson, TX

Cognos Consultant

Responsibilities:

• Worked wif Business users to analyze teh business process and user requirements to cater their needs for reports and multidimensional cubes.
• Develops and maintains Framework Manager Models and apply proper securitiesand publishing packages.
• Building data source query subjects and using stored procedures to create query subjects that are used to build reports for specific users.
• Interacted wif business and technical users to gather requirements and created design document
• Responsible for creation of metadata models in Framework Manager and cubes in Transformer.
• Created database, business and Presentation Layers and defined appropriate relationship between query subjects based on teh user requirements.
• Upgraded Models and Reports from Cognos 8.4 to Cognos 10.1.1 and Cognos 10.2
• Developed various dimensional and relational reports by deploying lists, crosstabs, charts, union, joins, burst, master-detail, drill through and drill down, reporting techniques.
• Creation of analytical reports, modifications to existing reports in Base Product.
• Developed complex prompt report and dimensional reports using different features like slice &dice, Drill capabilities, queries, Master detail and cross tab tables wif multiple breaks.
• Created different Dashboards in report studio using combination of List, Crosstab, and Chat andMap reports.
• Develop dimensions, measures and calculation using Transformer for OLAP Analysis of data.
• Developed dashboards reports using Business Insight, Business Insight Advanced and Cognos Workspace.
• Creating teh Teradata views as per teh business and reporting requirement.
• Importing teh Teradata Views to teh model and creating teh relation between teh views.
• Developed UTC (unit test cases) and helped Business Partners in UAT (user acceptance test cases) documentation as part of testing.
• Created implementation plan and component documents for Change Management Approvals.
• Involved in providing estimates and deliverable plan to Project by analyzing teh business requirements.
• Developed most of teh reports along wif teh team, made them understand teh requirements and deliverables.
• Handled pre implementation and post implementation issues as part of implementation process. Handled Production Support issues on call basis.

Environment: Cognos BI 10.1/10.2/8.4 (Framework Manager, Cognos Connection, Query Studio Report Studio, Metric Studio, Analysis Studio, Business Insight, Business Insight Advance and Event Studio), PL/SQL, Informatica, SQL Server 2008, Oracle 10g and Windows server and Unix.

Confidential, San Francisco

Cognos Developer

Responsibilities:

• Worked on complete life cycle ofCognos8 Administration andCognosBI (Installations, Security, Configurations, Migration and deployment.
• Worked closely wif Clients and Business Users to analyze and understand business requirements and Participated in requirements gathering meetings / Sessions.
• Developed technical specifications, data identification and also recommendations on teh preferred solution for development, and deploy efficient BI solutions
• Worked on technical design specs for Framework manager, and reporting as per teh requirements.
• Created Relational and dimensional models using Framework Manager. Provided Data level security in Framework Manager.
• Worked on multiple database, and multiple data source in Framework Manager to generate reports
• Created standard reports inCognosReport Studio, and Analysis Studio.
• Responsible to build teh Framework Manager Models and packages as per teh business requirements.
• Created folders, filters, prompts, and complex business calculations in Framework Manager and Report Studio.
• Worked on various reports like, List, Crosstab, drill-thru, multi-query, master/detail, prompted, dashboards, port lets, and tabular reports.
• Designed complex reports wif union queries, and SQL queries
• Improved long running reports performance thru writing SQL queries, resolving complex joins in framework manager, filters, and using stored procedures.
• Written java scripts for report prompts automation.
• Expertise to understanding, analyze,Cognos, data warehouse(OLAP), and OLTP data.
• Designed transformer models, and PowerPlay cubes using PowerPlay transformer.
• Worked on PowerPlay studio to slice/diceCognoscubes
• Worked on performance tuning to maintain fast performance of teh cubes and Transformer models.
• Recommended to do teh complex database calculations in teh database to improve report query performance.

Environment: Cognos10/8.4, Report Studio, Framework Manager, Query Studio, Event studio, Powerplay Studio, Analysis studio, Powerplay transformer8.4, Teradata12.0, and Oracle10g, Informatica, Linux

Confidential

Cognos consultant

Responsibilities:

• Created database, physical, and presentation layers in framework Manager, defining appropriate relationship between query subjects and fact tables.
• Developed teh packages in Framework manager and published into theCognosconnection server.
• Designed star-schema model inCognosFramework Manager.
• Designed teh UI for teh Dashboard and created a Dashboard inReportStudio as per teh requirement.
• Created catalog, standard filters, calculations, prompts, conditions.
• Developed List, Cross Tab, Charts, Drill ThroughReports, Master DetailReports.
• Testing theReportdata wif teh Oracle SQL scripts.
• Applied Package level, Object level and Data Level Securities.
• Worked wif Business Analysts and End Users in order to design and develop various types of report; educated teh End Users on implementation of new process or change in teh processes.
• Modifying teh existedreportbased upon teh changes requested by end users.
• Actively worked wif Business Analysts and Database Administrators to resolve various data related issues including rapid data adjustments, database related change such as table structure changes.
• Designed & developed thereportsfor daily, weekly and monthly usage.

Environment: Cognos BI 8.4 (Framework Manager, Cognos Connection, Query Studio, Report Studio, Metric Studio,) PL/SQL, Informatica, SQL Server 2008, Oracle 10g and Windows server and Unix.