SUMMARY

• Highly Skilled Professional with over Eight Years of experience in System Analysis, Design and Development in the fields of Data Warehousing, Database and Client - Server Technologies.
• Around Eight Years of experience with Cognos BI Tools such as ReportNet Cognos 8,10 Report Studio, Framework Manager, Impromptu 7.x/6.x, Cognos IWR 7.x/6.x, and Analysis Tools such as Cognos Transformer & PowerPlay 7.x/6.x, Cognos Visualizer 7.0, Cognos Query 7.x, Cognos Script Editor, Power Prompts, Access Manager, Metrics Manager, Notice Cast, Netscape Directory Server and Server Installation & Maintenance and ReportNet 1.01/ 1.02/1.1.
• Experience in installing and configuring Cognos ReportNet and Cognos 8,10.2 BI.
• Expertise in Migrating Catalogs and reports from Impromptu 7.3 to Cognos Reportnet1.1MR2 and Cognos 8,10.2.
• Expertise in Upgrading ReportNet, Cognos 8 to Cognos10.2 BI.
• Experienced in building analytical queries and reports to support the business requirements.
• Experienced in designing data flow, process flow, technical specs, and business specs.
• Extensive experience in Data Warehousing tools including Informatica and Data Modeling Tools like Erwin using DB2 UDB, Oracle, MS SQL Server databases.
• Strategically extracted/cleansed data from multiple data sources including SQL, Excel Spreadsheets, CSV Files, and MS Access Databases through application of refined Decision Stream modification and design techniques.
• Excellent interpersonal and communication skills, technically competent and result-oriented with strong problem solving and leadership skills.
• Experienced in Preparing Joint Application Development (JAD) Sessions documents.
• Experienced in creating security setup in Cognos 8 BI/CRN environment.
• Experience in writing shell scripting, stored procedures using PL/SQL.
• Extensive knowledge in processing jobs by using Batch Processing.
• Experience in writing SQL queries.
• Experience in Tableau Desktop, Tableau Server.
• Experience in Big Data Hadoop and MapReduce

TECHNICAL SKILLS

BI Tools: Cognos 10, 8 BI, Analysis Studio, Event Studio, ReportNet 1.02/1.1 MR2, Report Studio, Query Studio, Framework Manager, Metrics StudioCognos Impromptu 6.0/7.x, Cognos Transformer & PowerPlay, Impromptu Web Reports (IWR), Cognos Upfront, Cognos Visualizer, Cognos Script Editor, Metrics Manager, Notice Cast, Cognos PowerPlay Enterprise Server, Cognos Architect. Tableau Desktop, Tableau Server.

Hadoop and MapReduce: ETL Informatica Power Center 5.0/5.1/6.1, Informatica Power Mart 4.5, AbInitioData Stage, DecisionStream.

Databases: MS SQL server, Oracle 8i/9i, DB2 UDB, MS-Access, Informix, Teradata.

Data Modeling: ER/Studio 3.5/4.0, Erwin 4.1

Languages: C, VB, Java, SQL, PL/SQL, HTML, XML, Korn Shell scripting.

Other tools: TOAD, Test Director, MS-Visio, MS OneNote.

PROFESSIONAL EXPERIENCE

Confidential, Jamaica, NY

Tableau/Cognos Developer

Responsibilities:

• Understand existing System design and its components and make recommendations towards the development of new code or reuse of existing code to create framework packages.
• Involved in Designing and Creating various Projects in Framework Manager
• Work with back office operations teams, project managers, business analysts and end users to understand business requirements and translating them to technical specifications.
• Participated in JAD Sessions provided the session Deliverables to the client for the approval
• Created complex reports based on business user requirements.
• Created Tableau dashboards using Cognos reports
• Created Tableau reports using Tableau server.

Confidential, Edgewood, NY

Cognos Administrator

Responsibilities:

• Understand existing System design and its components and make recommendations towards the development of new code or reuse of existing code to create framework packages..
• Migrating Reports from 8,4 to 10,2 using Cognos Administration tool .
• Migrating Reports from 8,4 to 10,2 using MotioCI
• Migrating reports threw all environments ( DEV,QA,UAT,PROD) using Cognos Administration tool.
• Implementing Cognos Security based on user credentials.
• Adding and removing users to their respected groups
• Creating data source connections using Cognos Administration.
• Troubleshooting and resolving all administrative issues faced by developers on and offshore.
• Updated business logic on various reports based on feedback from stakeholders and management.
• Worked with offshore teams to create complex reports based on business user requirements.
• Developed dashboards with on and offshore teams based on business requirements.
• Updated various Cognos Configuration files to enhance the look and feel of Cognos UI.
• Enhancing Congos Architecture within Cognos configuration to better support business needs.
• Responsible for overlooking the designing and creating of various projects in Framework Manager by onshore and offshore teams.
• Updating Framework packages according to business feedback.
• Lead a small team of onshore/offshore developers through the development and QA process.
• Conducting weekly status meeting with onsite and offshore teams.
• Involved in integration of MotioCI (Versioning tool) with cognos 10.1.
• Involed in Cognos Planning.
• Responsible for updating end users for down time needed for any Cognos server updates.
• Conduct meetings with end users to better understand requirements.
• Conduct meeting with IBM to discuss hardware and software updates needed to support higher number of endusers.
• Work with Tableau Desktop/ Tableau Server.
• Knowledge of Big Data Hadoop and MapReduce

Environment: Cognos 10.2, 10.1, 8.4 BI, Framework Manager, Oracle 10G, Windows 2000, Microsoft Excel, Microsoft Word, MotioCI, Tableau Desktop, Tableau Server, Hadoop and MapReduce

Confidential, Fort Washington, PA

Sr. Cognos Consultant

Responsibilities:

• Involved in analyzing, documenting functional and technical requirements for developing packages and reports.
• Developed complex reports and analytics to meet the needs of business analysts.
• Updated business logic on various reports based on feedback from stakeholders.
• Proven experience building ad-hoc and complex reports using prompts and parameters in Report Studio and Query Studio.
• Involved in designing and creating various projects in Framework Manager.
• Participated in JAD Sessions provided the session Deliverables to the client for the approval.
• Created complex reports based on business user requirements.
• Involved in Migration from Cognos 8.4 to 10.1

Environment: Cognos 10.1, 8.4 BI, Framework Manager, Oracle 10G, Windows 2000, Microsoft Excel, Microsoft Word.

Confidential, Hartford, CT

BI Technical Lead Cognos

Responsibilities:

• Work with off-shore operations teams, developers, project managers, business analysts and end users to understand business requirements and translating them to technical specifications.
• Work with on-site operations teams, project managers, business analysts and end users to understand business requirements and translating them to technical specifications.
• Involved in analyzing, documenting functional and technical requirements for developing packages and reports.
• Developed complex reports and analytics to meet the needs of business analysts.
• Updated business logic on various reports based on feedback from stakeholders
• Proven experience building ad-hoc and complex reports using prompts and parameters in Report Studio and Query Studio.
• Extensive use of Drill-through reports
• Involved in designing and creating various projects in Framework Manager.
• Participated in JAD Sessions provided the session Deliverables to the client for the approval.
• Created complex reports based on business user requirements.

Environment: Cognos 10.1,8.4 BI, Framework Manager, Oracle 10G, Windows 2000, Microsoft Excel, Microsoft Word.

Confidential, Hartford, CT

Sr. Cognos Consultant

Responsibilities:

• Work with back office operations teams, project managers, business analysts and end users to understand business requirements and translating them to technical specifications.
• Involved in analyzing, documenting functional and technical requirements for developing packages and reports.
• Developed complex reports and analytics to meet the needs of business analysts.
• Updated business logic on various reports based on feedback from stakeholders
• Proven experience building ad-hoc and complex reports using prompts and parameters in Report Studio and Query Studio.
• Extensive use of Drill-through reports
• Involved in designing and creating various projects in Framework Manager.
• Participated in JAD Sessions provided the session Deliverables to the client for the approval.
• Created complex reports based on business user requirements.
• Creating Cubes using PowerPlay Transformer.

Environment: Cognos 8.4 BI, Framework Manager, Oracle 10G, Windows 2000, Microsoft Excel, Microsoft Word.

Confidential, Alpharetta, GA

Sr. Cognos Consultant

Responsibilities:

• Involved in Designing and Created various Projects in Framework Manager
• Imported the Metadata from Third Party tools like ERWin.
• Created filters within the Model for improving performance of the Model.
• Created CPF (Project files) and Published projects from the FM Models
• Build complex packages using various tool options.
• Updated various database changes into the Framework manger model
• Generated Various Reports (List, Crosstab, Chart, Repeater)
• Used Conditional explorer for the usage of variables and hide and show the different reports on the same selection criteria
• Created drill-through reports for detail reports.
• Build complex reports using various tool options
• Interacted with the business users and assisted them to use query Studio to develop ad - hoc reports.
• Created Dashboards for a better understanding of the business performance metrics
• Scheduled reports to run on a monthly, weekly, and daily basis using Cognos Connection Scheduler.
• Provided day-to-day support for all COGNOS Report studio users.
• Communicated report development progress and issues to management and team members.
• Ensured compliance with standard software development practices, processes and enterprise standards

Environment: Cognos 8.3 (Framework Manager, Report Studio, Query Studio, SDK) Oracle 9i and Windows 2003.

Confidential, Pittsburgh, PA 

Sr. Migration Consultant/Cognos 8BIAdmin

Responsibilities:

• Performed Analysis on existing Cognos 7.x reports to explore them with the new capabilities of Cognos 8 BI.
• Participated in upgrading Cognos 8.1 to Cognos8.2
• Participated in walk through meetings with Business Analysts from various departments to determine reporting and security requirements for reports.
• Migrated the Report sets and Reports based on the Information pulled from the Audit Database.
• Provided the technical support to the offshore Developers in Cognos 8 BI to bring the same functionality as compared with the impromptu after migration.
• Participated in JAD Sessions provided the session Deliverables to the client for the approval.
• Experienced in creating security setup in Cognos 8 BI environment.
• Created complex reports based on business user requirements.
• Analyzed and reused the same mapping functionality which is not properly migrated to Cognos 8 BI as compared with the Impromptu.
• Reformatted the Report layout to reflect the same nature as in impromptu
• Performed the UAT on migrated reports before promoted to QA Server.
• Created reports by using data from various data marts created by DataStage jobs.
• Provided the technical support in the QA and in Production Environment.
• Created scorecards and Dashboards in Cognos8BI.
• Created Frame Work Manager models using PL/SQL stored procedures.

Environment: Cognos 8.2 BI, Cognos 8.1 MR2, Cognos 7.x, Impromptu, IWR, PowerPlay, Upfront, Informatica, Oracle, SQL Server, PL/SQL, Windows 2000, Microsoft Excel, Microsoft Word.