SUMMARY

• Senior Reporting Architect/ Cognos Business Intelligence Developer/ Administrator/ Analyst wif 17+ years of very high - level advanced SQL, PL/SQL and reporting/administration experience wif Cognos and other BI tools.
• Tech Lead skills managing reporting team, both onshore and offshore.
• Excellent BSA/ Product Owner skills.
• Demonstrated experience in designing, documenting, reporting and programming robust applications for education, sales operations, marketing and manufacturing units
• Key expertise in business process engineering and software development life cycle including reporting, analysis, design, development, testing, training and implementation of software applications.
• Defined the scope, financial projections, Cost/Benefit analysis and wrote the Business Requirements Document (BRD) by working wif the IT staff, project managers.
• Expert report writing skills including IBM Cognos, Oracle BI Discoverer, Tableau, Crystal Reports and MS Access.
• Experience managing multiple priorities and leading the deployment of major cross-functional initiatives.
• Excellent communication, analytical, interpersonal and presentation skills; expert at quantitative analysis, data interpretation and managing multiple projects simultaneously.
• Strong skills in writing functional documents defined by the business requirements using Microsoft Office (Microsoft Word, Excel and Visio)
• Key skill sets include excellent teamwork, problem analysis, prioritize work, identify the solution and implement solutions quickly.
• Impeccable follow-up, strong delivery focus, positive attitude and collaborative style.
• Capable multi-tasker who can drive projects to completion while effectively collaborating and working across business and technical team resulting in high-functioning effective partnerships.

TECHNICAL SKILLS

RDBMS: Oracle7x/8x/9x/10x/11x/12x

Tools: TOAD, SQL Plus, Tableau, IBM OpenPages, IBM Cognos 8.4., 10.1, 10.1.1,10.2.0, 10.2.1, 10.2.2, CA 11.x (Cognos Report Studio/ Cognos Query Studio/ Cognos Analysis Studio/ Cognos Workspace/ Cognos Workspace Advanced/ Cognos Insight/ Cognos Framework Manager/ Cognos Transformer/ Cognos Cube Designer/ Cognos Administration), IBM OpenPages, SunGard Ellucian Banner 8.x, Oracle BI Discoverer, Tableau, IBM Infosphere Server, IBM Infosphere Business Glossary, IBM Lifecycle Manager, crystals, Crystal Reports, BO XI, Active Directory, Cognos Series7 (Access Manager), MetaManager, SVN, NetVisn, Motio, Atlassian Jira, Microsoft Visual Studio Team Foundation Server (TFS)Operating System Windows-NT/95/98/2000/XP/Vista/7/8/10

Languages: SQL, PLSQL, C, C++, Visual Basic, HTML, XML

Applications: Microsoft Office Suite (Word/Excel/PowerPoint/Visio/Access/Project)

PROFESSIONAL EXPERIENCE

Confidential

Reporting Lead/Sr. Cognos Developer

Responsibilities:

• Lead a team of 5 developers including solutioning business needs and recommending the best approach for reporting.
• Primary architect/ tech liaison for all data analytics needs.
• Instrumental in strategizing & building a data lake solution through APIs for data consumption by business partners.
• Responsible for data feeds to Tableau Server and implementing reports along wif security access.
• Subject matter reporting expert for Governance, Risk & Compliance (IBM OpenPages GRC).
• Working on integration of IBM Watson wif IBM OpenPages/ Cognos.
• Actively involved in integration and setting up of the Risk Technology RDX Datawarehouse platform which houses all risk applications data for business partners’ consumption.
• Highly noledgeable/experienced wif IBM OpenPages GRC application.
• Primarily responsible for Cognos report development. Conduct user request analysis, query development, framework and dashboard development.
• Developed various reports for business which included dashboards, list reports, cross tabs, charts.
• Developed reports wif complex design dat included prompts, filters, master detail, tables, calculations, variables and formatting.
• Developed Framework models by defining the 3 layers Database layer, Business layer and Presentation layer, and publishing packages to the Cognos Connection.
• Used Relational Modeling and Star Schema modeling technique to develop Framework models.
• Meeting wif users and handling issues related to Cognos reporting environment including troubleshooting and root cause analysis.
• Created advanced reports in Cognos including multi-prompt reports, drill down reports, master detail reports, burst reports and conditional layout reports, etc.
• Create reporting fragments to be used in the OpenPages objects.
• Active participation in Agile scrum ceremonies (grooming, sprint planning, retrospectives, daily stand-ups, etc.)
• Development and maintenance of advanced Database views, Functions and Packages using PL/SQL for report usage and data integration wif 3rd party tools.
• Proficient indeploying reportsandpackagesfrom one environment to other environment.
• Used Cognos Scheduler to schedule jobs/reports/events.
• Used Cognos Event Studio to manage scripts, report runs and notifications.
• Involved in performance tuning, and resource management of Cognos reporting.
• Worked wif QA team to design test plan and test cases for User Acceptance Testing (UAT).
• Worked actively wif leadership team to develop and implement the data and reporting strategy.
• Provide regular and timely status updates to the users on their reporting projects.
• Documentation of requirements, design document and other generic documentation for Cognos report maintenance.
• Very good understanding of risk management processes, and how those processes integrate wif OpenPages and relates to in terms of reporting.
• Apply technical and business noledge in the design, build, test and deployment of Cognos reports.
• Documentation and maintaining report source control through Microsoft Visual Studio TFS.
• Knowledge on the inner workings of the OpenPages platform to leverage its power and PL/SQL Database development.
• Well versed in the OpenPages Data Model and the Reporting Framework.
• Report building using advanced custom SQL queries to help improve report performances.
• Regeneration of Reporting Schema and Framework Manager when new objects are created in OpenPages for reporting.
• Meeting wif project team members and business partners on requirements, negotiating priorities and timelines.

Confidential

Sr Cognos Business Intelligence Developer/ Cognos Administrator

Responsibilities:

• Primarily responsible for Cognos report development and administration. Conduct user request analysis, query development, framework & cube design, security administration, data modeling, and dashboard development.
• Developed Framework models by defining the 3 layers Database layer, Business layer and Presentation layer, incorporating model level stand-alone and embedded filters and publishing packages to the Cognos Connection.
• Involved in Requirement Gathering, Dimensional Modeling, ETL Design, Data Mapping and Client Interaction.
• Developed and validated summary cube objects from relational data sources to provide ad-hoc and regular reporting for customer
• Created the ODS models for Finance, Student & HR in Framework Manger for end user reporting.
• Lead in the business requirements gathering to create dimensions and levels, build PowerCubes for use in IBM Cognos BI and easily analyze data by creating dimensional analyses in IBM Cognos Analysis Studio
• Responsible for maintaining and upgrading of Cognos Software on all instances.
• Used Relational Modeling and Star Schema modeling technique to develop Framework models.
• Set upuser level, data levelsecurity for the published Cognos packages.
• Responsible for managing the Cognos security strategy for users/groups using Meta Manager for security autantication and provide BI publishing and Monitoring reports. Setting up groups, roles and users in Cognos application.
• Responsible for debugging packages built in Cognos Framework Manager in terms of performance and tuning
• Developed various reports for business which included list reports, cross tabs, charts.
• Developed reports wif complex design dat included prompts, filters, master detail, tables, calculations, and templates.
• Worked on performance tuning of the dispatchers to handle requests better and optimize the performance of the application.
• Administeredsetting up the Cognos security settings at package, report level using theCognos connection administration portalwif restricted features depending on the class of user.
• Participate in meetings wif users, fielding questions from the functional areas, and handling issues related to Cognos reporting environment or Banner databases including troubleshooting and root cause analysis.
• Developed advanced dashboards for HR/Payroll, Presidents office
• Created advanced reports in Cognos including multi-prompt reports, drill down reports, master detail reports, burst reports and conditional layout reports, etc.
• Worked on the various HR and Payroll related reports like compensation, benefits statement, new hire state and federal reports using Cognos Report Studio, Analysis studio and Cognos Workspace Advanced.
• Developed Active reports for users to use offline and on mobile devices.
• Responsible for generating Project Plan wif respect to Upgrades, conversion from BO/Crystal Reports to Cognos.
• Responsible for maintaining DEV, TST, STG, PROD, DR environments in Cognos 10.2.0 platform.
• Used MetaManager for report auditing, security management, metadata management and manage Cognos Content Store.
• Proficient indeploying reportsandpackagesfrom one environment to other environment.
• Used Cognos Scheduler to schedule jobs/reports/events.
• Used Cognos Event Studio to manage scripts, cubes refreshes, report runs and notifications.
• Involved in installing Fix Packs, Patches and Upgrades.
• Responsible for defining and maintaining data sources on Cognos Connection.
• Involved in Change Control to deploy fixes in Production environment
• Responsible for tracking issues wif scheduled agents/reports/jobs by debugging the log files and .dmp files
• Develop and deliver training related to Cognos reports/reporting environment, provide mentoring to campus report developers.
• Worked wif DBA to maintain stability of application by load balancing the servers, content store maintenance.
• Close interaction wif the Server Administrators, DBA’s, Window Administrators, Database Services and System services to install patches In the Oracle/SQL server environment.
• Involved in Change Management process for deploying packages from DEV/TST/STG environments to PROD.
• Involved in writing API’s using SQL, PL/SQL to integrate wifin Cognos.
• Proactively managed multiple environments to ensure high availability, high performance, and minimization
• Involved in performance tuning, load balancing, and resource management of various applications.
• Involved in validation of data and user testing for data from Banner to ODS.
• Worked wif QA team to design test plan and test cases for User Acceptance Testing (UAT).
• Responsible for report scheduling, platform maintenance and upgrades.
• Worked actively wif leadership team to develop and implement the data and reporting strategy.
• Provide regular and timely status updates to the users on their reporting projects.
• Documentation of user manual and other generic documentation required for the tools.
• Provided Training to different business users to develop dashboards in workspace and workspace advanced.

Confidential, Colorado Springs

Sr Cognos Business Intelligence Developer/ Cognos Administrator

Responsibilities:

• Involved in Requirement Gathering, Dimensional Modeling, ETL Design, Data Mapping and Client Interaction.
• Primarily responsible for Cognos report development and administration. Conduct user request analysis, query development, framework & cube design, security administration, data modeling, and dashboard development.
• Responsible for maintaining and upgrading of Cognos Software on all instances.
• Used Dimensional Modeling (DMR) and Relational Modeling and Snow Flake Schema modeling technique to develop Framework models.
• Developed Framework models by defining the 3 layers Database layer, Business layer and Presentation layer, incorporating model level stand-alone and embedded filters and publishing packages to the Cognos Connection.
• Set upuser level, data levelsecurity for the published Cognos packages.
• Developed various reports for business which included list reports, cross tabs, charts.
• Developed reports wif complex design dat included prompts, filters, master detail, tables, calculations, and templates.
• Created the ODS models for Finance, HR and Payroll in Framework Manger for end user reporting.
• Participated in defining and designing OLAP cube structures. Lead in the business requirements gathering to create dimensions and levels, build PowerCubes for use in IBM Cognos BI and easily analyze data by creating dimensional analyses in IBM Cognos Analysis Studio
• Developed and validated summary cube objects from relational data sources to provide ad-hoc and regular reporting for customer
• Tested the security settings usingautanticationinformation of different classes of users.
• Responsible for setting up groups, roles and users in Cognos application.
• Responsible for managing the Cognos security strategy for users/groups using Cognos Series 7 for security autantication and provide BI publishing and Monitoring reports.
• Administeredsetting up the Cognos security settings at package, report level using theCognos connection administration portalwif restricted features depending on the class of user.
• Involved in license maintenance by using Metamanager.
• Participate in meetings wif users, fielding questions from the functional areas, and handling issues related to Cognos reporting environment or Banner databases including troubleshooting and root cause analysis.
• Created advanced reports in Cognos including multi-prompt reports, drill down reports, master detail reports, burst reports and conditional layout reports, etc.
• Worked on the various HR and Payroll related reports like compensation, benefits statement, new hire state and federal reports using Cognos Report Studio, Cognos Analysis studio and Cognos Workspace Advanced.
• Designed and developed Framework manager models and Packages wif the source as DB2 and Transformer cubes.
• Developed advanced dashboards for HR/Payroll, Presidents office.
• Created advanced reports including Transcripts, All Colege Course Evaluation, Class Schedule, Faculty Review using Report Studio, Event Studio.
• Developed interactive customized maps for Regions, district and Territories in Cognos Report studio.
• Authored various types of reports in Report Studio using dimensional (Cube & DMR) and Relational data sources.
• Developed Active reports for users to use offline and on mobile devices.
• Responsible for generating Project Plan wif respect to Upgrades, conversion from BO/Crystal Reports to Cognos.
• Responsible for maintaining DEV, TST, STG PROD, DR environments in Cognos 10.1.1 platform.
• Responsible for debugging packages built in Cognos Framework Manager in terms of performance and tuning
• Worked on performance tuning of the dispatchers to handle requests better and optimize the performance of the application.
• Used NetVisn for report auditing, security management, metadata management and version control and manage Cognos Content Store.
• Proficient indeploying reportsandpackagesfrom one environment to other environment.
• Used Cognos Scheduler to schedule jobs/reports/events.
• Used Cognos Event Studio to manage scripts, cubes refreshes, report runs and notifications.
• Involved in installing Fix Packs, Patches and Upgrades.
• Main point of contact for resolving issues wif the Cognos Servers.
• Responsible for defining and maintaining data sources on Cognos Connection.
• Involved in Change Control to deploy fixes in Production environment
• Responsible for tracking issues wif scheduled agents/reports/jobs by debugging the log files and .dmp files
• Install/Upgrade of IIS, TOMCAT application server and Cognos.
• Develop and deliver training related to Cognos reports/reporting environment, provide mentoring to campus report developers.
• Worked wif DBA to maintain stability of application by load balancing the servers, content store maintenance.
• Close interaction wif the Server Administrators, DBA’s, Window Administrators, Database Services and System services to install patches In the Oracle/SQL server environment.
• Involved in Change Management process for deploying packages from DEV/TST/STG environments to PROD.
• Proactively managed multiple environments to ensure high availability, high performance, and minimization
• Used ITSM tool Cherwell for reporting bug fixes and defects.
• Involved in performance tuning, load balancing, and resource management of various applications.
• Involved in validation of data and user testing for data from Banner to ODS.
• Involved in writing API’s using SQL, PL/SQL to integrate wifin Cognos.
• Responsible for analysis, design, implementation and administration of Enterprise Business Intelligence platforms including Cognos Business Intelligence 10.1.1, InfoSphere Business Glossary 9.0 and Tableau Server.
• Worked wif QA team to design test plan and test cases for User Acceptance Testing (UAT).
• Built several dashboards for management using Cognos Framework and Cubes.
• Responsible for report scheduling, platform maintenance and upgrades.
• Provide regular and timely status updates to the users on their reporting projects.
• Documentation of user manual and other generic documentation required for the tools.
• Provided Training to different business users to develop dashboards in workspace and workspace advanced.
• Serve as resident expert for colege’s reporting needs, and influence the colege towards an integrated reporting environment.
• Worked actively wif leadership team to develop and implement the data and reporting strategy.
• Primarily responsible for interacting wif the President’s office, Registrar’s, Advancement, Business office wif respect to questions regarding data, security and Cognos reporting.
• Worked wif IBM in developing solutions and maintaining the Production environment
• Actively involved in keeping self-updated through user group meetings, online webinars and user forums.
• Responsible for multiple development tasks simultaneously.

Confidential, Abilene - TX

Sr Cognos Business Intelligence Developer/ Analyst

Responsibilities:

• Involved in Requirement Analysis, Design, Data Mapping and Client Interaction.
• Involved in all stages of SDLC - including requirements gathering, design, development, testing, production and post-production support.
• Designed and developed Framework manager models and Packages wif the source as DB2 and Transformer cubes and applying data level and user level security for Framework Manager Packages and reports.
• Developed Framework packages for Professional report authoring and Ad Hoc Query Reporting wif embedded filters and calculations.
• Used Cognos Event Studio to manage scripts, cubes refreshes, report runs and notifications.
• Involved in defining and designing OLAP cube structures using Transformer and implemented security into the cube model.
• Developed reports wif complex design dat included prompts, filters, master detail, tables, calculations, and templates.
• Modified Power Cubes by adding new Dimensions, Levels, Categories and Measures.
• Responsible for setting up and maintaining Cognos users through Access Manager for secured autantication.
• Developed report templates to adhere policies and standards.
• Developed various reports for business which included list reports, cross tabs, charts.
• Created advanced reports in Cognos including multi-prompt reports, drill down reports, master detail reports, burst reports and conditional layout reports, etc.
• Built several dashboards for management decisions using Cognos Transformer, Analysis Studio, Cognos Connection and Tableau by working directly wif senior management/executives.
• Designed and Implemented new dashboards using Portlet pages and Cognos workspace
• Developed Active reports for users to use offline and on mobile devices.
• Developed various financial reports including income statements, balance sheets and cash flow reports.
• Involved in design and development of complex reports like Top donors by school, Total Giving to various departments, Donor segregation by gift officers.
• Developed interactive Dashboards using in-report prompts, custom portal pages and inter-portlet communication techniques.
• Expertise in SQL Plus and PL/SQL programming, developing complex code units.
• Involved in converting Oracle Discoverer reports, SQL reports and MS Access Reports to Cognos 10 reports for Advancement, Finance and HR.
• Involved in converting Crystal Reports to Cognos 10.
• Supported the reporting requirements of Advancement, Alumni, Finance, HR and various departments across campus.
• Heavily involved in performance tuning of Cognos reports.
• Involved in data migration process between different versions of Cognos.
• Involved in upgrade of reports from Cognos 8.4.1 to Cognos 10.1
• Key point of contact for support of Production related issues which included performance, defects tracking, enhancements and development.
• Set up various user level and group level security using Cognos Administration.
• Prepared business process models; used Visio to create use case diagrams.
• Proficiency in using MS Excel for manipulation of data using Pivot Tables, Vlookup, Decision making/String Manipulation functions, Charting and Formula Auditing
• Worked wif the functional and technical staff of university IS team to implement SunGard HE Banner applications.
• Worked on performance tuning of existing reports and dashboards using concurrent query execution for better performance.
• Developed project plans and provided project status updates to key stakeholders
• Reviewed, evaluated, designed, implemented and maintained reporting needs to support current business initiatives.
• Reviewed existing system scripts and created new scripts to improve data integrity in Banner ERP.
• Create and maintain automated plan, scheduling and documentation for scripts loading and report creation.
• Design and execute data extraction practices to support the university’s business processes.
• Responsible for integration and support for all third party software applications wif Banner ERP.
• Responsible for report scheduling, platform maintenance and upgrades
• Defined analytical and problem solving skills and judgment to quickly identify problem areas and proactively escalate and resolve issues.
• Responsibilities included maintenance, identifying and fixing bugs and unit testing applications.
• Involved in data analysis, data modeling, business analysis and work flow analysis ranging from data aggregation to data mining.
• Interacting wif the university IS on resolving the reported bugs and various technical issues.
• Provided timely updates to users regarding their reporting requirements.
• Provide ongoing support for functional users after go live.
• Provide consistency in use of data across the university to ensure accurate management analyses and reports.
• Documentation of user manual and other generic documentation required for the application.
• Provided training for end users/ power users/ business users on using Cognos Report Studio, Cognos Analysis Studio and Cognos Query Studio.

Confidential

Sr Cognos Business Intelligence Developer/ Analyst

Responsibilities:

• Involved in Requirement Analysis, Design and Client Interaction.
• Developed report templates and implemented BI standards.
• Responsible for framework modeling, report writing (relational and multi-dimensional), and creating dashboard components using the Cognos 8 suite of products.
• Experience on OLAP cubes, relational and multi-dimensional Data models.
• Developed Framework packages for Professional report authoring and Ad Hoc Query Reporting wif embedded filters and calculations and incorporating security wifin the model.
• Used Cognos Event Studio to manage scripts, cubes refreshes, report runs and notifications.
• Set up various user level and group level security using Cognos Administration.
• Developed various PL/SQL packages which included various cursors, procedures and functions.
• Developed reports, dashboards, and scorecards using Report Studio.
• Created advanced reports in Cognos including multi-prompt reports, drill down reports, crosstabs, multidimensional reports wif cascading prompts, filters and calculations.
• Assisted and worked wif ETL developers and data modelers to make sure dat model being developed is according to the business requirements
• Created Finance reports for accounts payable/receivable/reconciliation. Creating monthly reports of sales and expenses by cost center.
• Responsible for collections and interpretation of Global Sales information.
• Developed various reports for business which included list reports, cross tabs, charts.
• Developed reports wif complex design dat included prompts, filters, master detail, tables, calculations, and templates.
• Developed KPI’s and budget plan for Sales Operation Division.
• Involved in converting Oracle Discoverer reports, SQL reports, Web Focus reports and Crystal reports to Cognos 8 based reports.
• Recommended new reporting methods to improve content and completeness of information in the reports.
• Actively involved in data validation and user testing of data provided to the business users.
• Heavily involved in performance tuning of Cognos reports.
• Supported the reporting requirements of Finance, Marketing, Sales & Service Operations team which included around 200 members.
• Collaborate wif end-users to ensure the efficiency level based on report requirements
• Provided timely updates to users regarding their reporting requirements.
• Interacted wif various sales groups/teams/reps in defining sales and marketing report requirements.
• Worked wif business customers to define and document requirements for system enhancements and process improvements.
• Key point of contact for support of Production related issues which included performance, defects tracking, enhancements and development
• Responsible for report scheduling, platform maintenance and upgrades.
• Examined and evaluated the purpose and content of business reports to develop new or to improve current use and control; also in charge of reviewing reports to determine basic characteristics, such as origin, report flow, format, frequency, distribution and purpose of the report.
• Design and execute data extraction practices to support the organization’s strategic/business processes.
• Involved in data analysis, data modeling, business analysis and work flow analysis ranging from data aggregation to data mining.
• Proficiency in using MS Excel for manipulation of data using Pivot Tables, Vlookup, Decision making/String Manipulation functions, Charting and Formula Auditing.
• Evaluating procedures for collecting data and analyzing the market research data through SPSS.
• Map project progress - including defining of sub goals, milestones and tasks, time and resource planning.
• Monitored and documented project progress through project files/logs.
• Worked wif QA team to design test plan and test cases for User Acceptance Testing (UAT).
• Handing over of project results and compiling final project report.
• Prepared and issued instructions concerning generation, accuracy, timeliness and distribution of reports according to new or revised practices and procedures.
• Worked actively wif leadership team to develop and implement the data and reporting strategy.
• Documentation of user manual and other generic documentation required for the application.
• Prepared training materials, developing Business models and training end users/ power users/ business users in Query Studio according to their specific needs and requirements.

Confidential

Sr Cognos Business Intelligence Developer/ Analyst

Responsibilities:

• Involved in Requirement Analysis, Design and Client Interaction.
• Prepared business process models; used Visio to create use case diagrams.
• Conducted several Requirements Gathering Sessions (RGS) for gaining detailed requirements and finalizing Business Requirement Document (BRD).
• Translated Business requirements to functional and technical language wif the help of use cases and UML diagrams for developers
• Involved in structuring Metadata & Cognos Models using Framework Manager.
• Developed reports utilizing Oracle BI Discoverer, IBM Cognos suite and SQL queries.
• Generated various reports in Cognos including List Reports, Grouped Reports, Cross tab Reports, Chart Reports, Drill-Down and Drill-Through Reports.
• Modifying of SQL in Report Studio to tune and/or to write complicated reports and using Union/Join objects in Report Studio.
• Using advance features like conditional formatting to generate multipage reports in Cognos Report Studio.
• Develop Prompt Pages and Cascaded Input Prompts to display only select entries in reports.
• Implemented Dynamic Filters and Dynamic sorting functionality to give users ability to sort and filter the data in Report Viewer.
• Used Advance techniques like Tabular SQL, Tabular Sets and tabular models, Report Bursting, master detail relationships and conditional formatting.
• Implemented Tables of Contents and hide and show functionality in Reports.
• Migrated reports from Cognos 8.2 to 8.3
• Involved in converting SQL reports, MS Access Reports and Oracle Discoverer to Cognos 8.3 Reports.
• Implementation of data profiling and quality check in Data Manager.
• Worked on performance tuning of existing reports and dashboards.
• Created and ran Data Integrity scripts as needed.
• Functioned as a primary bridge between the business, operations, and the technical areas throughout the project cycle.
• Identified and validated high potential business opportunities for stakeholders and developed customized business strategies dat are aligned wif corporate strategic objectives.
• Provided analysis, understanding and business perspectives on many financial and operational issues.
• Wrote scripts using SQL loader utility to populate the sample data for Unit Testing.
• Used TOAD and SQL Navigator for data analysis and query optimization.
• Created Finance reports for accounts payable/receivable/reconciliation.
• Provided timely updates to users regarding their reporting requirements.
• Developed workflow, screen mock-ups and conversion requirement.
• Worked wif SQL queries for data manipulations.
• Liaised wif Business Analysts at other offshore locations to create data maps and models.
• Maintained and updated the KPI’s. Preparation of sales and service operations reports using analytical and mathematical functions.
• Involved in records & data management for future reporting. Strict maintenance of company policies.
• Analyze potential solutions; perform ROI, risk, and efficiency analysis.
• Worked wif customers to define and document requirements for system enhancements and process improvements.
• Provided training for end users/ power users/ business users on using Cognos Report Studio, Cognos Analysis Studio and Cognos Query Studio.

Confidential

Cognos Developer/ Report Writer

Responsibilities:

• Interacted wif business users to prepare and update Business process requirements and software system requirements.
• Translated Business requirements to functional and technical language wif the help of Use cases and UML diagrams for developers.
• Conducted requirements workshops among all project stakeholders to verify and validate the business requirements in UI designs.
• Performed gathering, analysis, review and signoff of business requirements and conducting of interviews, sessions etc.
• Developed report templates and BI standards.
• Worked on Framework Manager to import metadata from SQL Server data source and to create subject matter models, create and publish packages to Cognos 8 Server.
• Developed complex Reports using different features like slice & dice, Drill capabilities, queries, Master detail and cross tab tables wif multiple breaks.
• Maintained various ad hoc and custom reports using Oracle Discoverer, MS Access, Cognos Report and Cognos Query Studio.
• Developed Report templates to adhere policies and standards.
• Built several dashboards for management decisions using Cognos Transformer, Analysis Studio and Cognos Connection.
• Worked on the various HR and Payroll related reports like compensation, staff pay plan, new hire state reports.
• Created Physical Data Model and Logical Data Model for business requirements.
• Worked wif SQL queries for data manipulations.
• Responsible for providing maintenance and support of Cognos Environment, build reports, OLAP Cubes, dashboards and scorecards using various data sources.
• Responsible for report scheduling, platform maintenance and upgrades.
• Coordinated project scheduling wif the software project manager.
• Supported the Program Manager in balancing project goals and business needs.
• Involved in various business operations and helped the organization to achieve cost-effective production wif increased quality, efficiency and satisfied customer service.
• Involved in preparation of project plan, user acceptance testing.
• Ensured all artifacts complied wif corporate SDLC policies and guidelines.
• Involved in writing of test plans of the business application.
• Developed Functional and Technical Design Documents and new setup Forms.
• Involved in documenting the business process by identifying the requirements.
• Provided training for end users/ power users/ business users on using Cognos Report Studio and Cognos Query Studio.