SUMMARY

• BI Developer, Business Systems Analyst & Report Developer who has a track record of delivering key business information solutions in complex and technical areas
• Over 9 years of extensive experience in software industry focusing on data warehouse reporting environment such as design, development and deployment
• Over 9 years of working experience with Cognos Analytics (V11), Cognos 10.1.1, Cognos 8 (8.4/8.3/8.2) (Report Studio, Analysis Studio, Query Studio, Cognos Connection, Framework Manager and Transformer).
• Expert in Designing and developing Complex Reports (List Reports, Cross Tab Reports, Chart, Maps, Dash board Reports) using Report Studio.
• Experience in creating Prompts, Cascading Prompts, Conditional Variables and Bookmarks with multiple Report pages and multiple Prompt pages in Report Studio
• Created Complex Reports with advanced features such as Master Detailed sections, Conditional formatting, Render variables, Drill - through, Page set and bursting using Report Studio.
• Developed OLAP solutions using Cognos products
• Customized the Cognos Portal (Cognos Connection/Upfront) according to requirements
• Data Mining to identify the right variables for data Models
• Strong analytical skills to enable analysis of large and complex data sets over space and time axes
• Excellent appreciation of business needs and requirements couple with the ability to translate these into technical solutions
• Provide insight and solutions in a day to day fast paced environment
• Focus on relationships between performance indicators, and maintaining system/team structure
• Agile, efficient with the vision to look ahead
• Attention to detail and focus on data integrity
• Experience in modeling the metadata dimensionally.
• Interacted with end-users to gather requirements for reporting
• Expertise in SQL - used in reports and in model query subjects.
• Experienced in the process analysis and performance optimization of BI reports.
• Provided extensive end-user and support.
• Self-motivated and excellent critical thinking ability, good interpersonal and communication skills.

TECHNICAL SKILLS

Reporting Tools: Cognos Analytics, Cognos 8.1,10.x,11 BI/SDK MS Reporting Services 2008, 2005, BIRST, Crystal Reports,, Microstrategy.

Development Languages: Transact-SQL

Server Applications: SQL Server, IEX TotalView Workforce Management (call center forecasting and scheduling methodology)

Content Delivery: SharePoint 2010, 2007, 2005

Desktop Applications: Microsoft Word, Excel, Access, PowerPoint, Active Directory, Report Manager, Visual Studio, Outlook, Internet Explorer

PROFESSIONAL EXPERIENCE

Confidential, Oakland, CA

Cognos Lead BI Developer

Responsibilities:

• Getting together with Business Analyst and the business owners to gather the requirements.
• Once the requirement is finalized create new package or update existing package using Framework Manager.
• Once the package is deployed unit tested create new report mockup using Cognos as the report development tool and Hadoop as backend tool.
• Expert in creating reports using different functionality, such as Prompts, Conditional Variables, List reports, Dashboards, drill through etc.
• Work with business users to demo the mockup, get signoff on the mockup and start development of new reports.
• Create Report Specification document for the new report and also update the existing specs documents.
• Once the report is developed do a unit testing and get actively involved with the Analyst with the use testing.
• Deploy reports and packages from one environment to other such as DEV to UAT to PRD.
• Using bug tracking tools such as JIRA to track the process of the work and defects as the sprint progresses.
• Attend Stand Ups every morning for Scrum meeting.
• Making sure the reports and the environment is operationally sound after the patches.
• Actively involved with the Managers, Analyst, Backend team and outside vendor teams within the projects.
• A team player always ready for the team in need.
• Good experience in working/handling with offshore team.
• Quick learner and always willing to learn or tech with excellent communication skills.

Environment: Hadoop, JIRA, Cognos 11.5, SQL, Microsoft Windows 10, Slack, Zoom, Jabber, Agile Scrum

Confidential

Cognos Lead BI Developer

Responsibilities:

• Gather, analyze, document and manage user and business requirements (both functional and non-functional) for technology solutions that address business needs.
• Assist in identifying potential solutions for the business and provide input to issues or risks.
• Identify project interdependencies and communicate requirement/scope issues and participate in driving them to resolution for inclusion in system requirements.
• Translate business and user requirements into technical requirements documents.
• Conducted Offshore meeting on a daily basis as well as involved in users demo sessions.
• Created complex report studio reports based on HANA views as well as the SQL server database.
• Created reports using SQL queries as a data source.
• Created packages using Framework Manager and published to Cognos Connection to create reports.
• Used Workspace Advanced for slicing/dicing of data for validation purpose.
• Used Transformer to update the cubes logic based on requirement changes from the users.
• Used Orange Scrum to update the assigned work.
• Created multiple prompt-based reports as well as drill through reports.
• Scheduled reports based on the locations specific users.
• Created test scenarios as well as test cases.
• Created Wireframes as well as Technical Specification documents.
• Performed manual back-end testing using SQL to connect to an SQL server and HANA database on a windows server
• Wrote SQL Statements to extract data from Database to verify the output data of the reports
• Was also involved in the migration project for Beer Division of Reyes Holding. Migrating from Cognos 10.2.2 to Cognos V11.

Environment: Quick Test Pro, Windows Professional XP /2000, SQL Server 2008/2012, Cognos 10.2.2, Cognos Analytics, Framework Manager, Transformer, Orange Scrum, Citrix Receiver.

Confidential, Oakland,CA

SR Cognos Bi Developer

Responsibilities:

• Responsible for BI reporting deliverables and the work associated in designing, building, testing, and deploying new reports and enhancements, and maintaining the existing reporting portfolio.
• Collaborated with business users and members of the ERMIS Team, including the BI functional lead, SDSC data center staff, system analyst and ETL developers to help analyze the business problems to design, develop and test intuitive information systems, i.e. dashboards, scorecards, alerts, reports, cubes and embedded analytics using the Cognos suite of tools.
• Created, enhanced, and maintained Framework Manager Models using Cognos v11 Framework Manager (relational and dimensional), which connect to a star schema, DB2 warehouse database, including packages designed for report development and for ad hoc reports.
• Created different complex Report Studio reports using Congos v11, with multiple prompts, multiple style variables, and conditional variables.
• Created new visualization dashboards, giving users ability to filter the data based on a single click.
• Created report specifications and all related documentation.
• Developed and executed test plans that ensured deliverables meet user requirements, and usability and performance metrics.
• Was involved in production and operational support.
• Trained and supported system wide Cognos users.
• Wrote technical documentation in a clear and concise manner.
• Exhibited a commitment to data quality by validating results compared with the data warehouse database at each step of the development process.
• Involved with offshore IBM team to get better understanding of current system and environment.
• Involved in installing and configuring Cognos Analytics (v11) in Test environment for testing and establishing new reporting environment
• Involved with ETL team to get better understanding of data loads and identifying which loads affected which reports and dashboards.
• Used IBM Data Studio Client v11 for testing and validating the data against the database.
• Involved on Reports deployment from one environment to another environment such as from DEV to UAT to PRD using Cognos Export Import Feature.
• Experienced using tortoises sub (Version Control) for check-in and checkout of codes.
• Experience in writing user stories for the data and reports.
• Experience in using bug-tracking tool such as JIRA.
• Gained knowledge with enterprise risk management data in a HIPPA environment, which is confidential and sensitive data.
• Handled multiple tasks, set priorities, schedule and meet deadlines.
• Worked with a team of developers on a coordinated, integrated development effort.
• Excellent interpersonal skills to successfully collaborate with a broad range of personnel at all levels of the campus and within OIT with varying levels of technical knowledge.
• Excellent analytical, organizational, critical thinking and problem solving skills.

Environment: - Cognos Analytics (v11), Framework Manager v11, Cognos 10.2(Report Studio, Framework Manager, Query Studio, Analysis studio), TM1, ETL Data Stage, DB2 Data Studio, DB Visualizer, Windows 7, MS Office 360, JIRA, SVN, SharePoint

Confidential

Senior Cognos/BI Developer

Responsibilities:

• Utilize in-depth knowledge of corporate data structures and reporting environments to produce reporting solutions, with the goal to provide quality information for fact-based decision-making
• Used All Cognos studios, Report Studio, analysis Studio, query studio create Cognos Dashboards, reports, queries, metrics etc.
• Upgraded Cognos version 8 and 10.1 to Cognos 10.2.1
• Proactively work to investigate new areas of interest for the business to gain competitive advantage
• Participate in Quality Assurance of reporting code and deliverables
• Develop, enhance and maintain reports leveraging best available technology to meet business requirement (e.g., Cognos Tools)
• Performed requirements analysis, report, dashboard, and analytics solution design and consulting
• Design, develop, and unit test standard, complex and ad-hoc reports
• Work to enable business partners in the development of their own reports and dashboard
• Collaborate with the various stakeholders to gather requirements and perform business analysis in order to develop meaningful proactive reporting metrics to support the company’s strategic direction
• Develop and maintain a wide variety of business-critical reports (daily, weekly, monthly and Ad hoc to meet multiple customer and business requirements) using IBM Cognos, SQL and Excel
• Respond to incoming Ad hoc report requests and facilitate the development of clear reporting requirements
• Maintain an awareness of changing business needs and recommend enhancements to reports accordingly
• Designed the metadata model(s)in Cognos 8 using Framework Manager
• Created a package with appropriate security for reporting in Query Studio/Report Studio
• Upgraded from Cognos 8.3 to Cognos 10 as part of POC and then tested/validated the reports, cubes for data, formatting, structures etc
• Constantly interacted with business users and data architect to manage requirement changes
• Provided end-user and support
• Created test case to validate data and formats of the reports. Tested the reports thoroughly before moving the reports to various environments.
• Clearly documented the design of all models and complex reports

Environment: - Cognos 10.x,TM1, Datamanger,Oracle, SQL Server 2012, Toad, Windows 7, MS Office

Confidential

Cognos Developer

Responsibilities:

• Designed the metadata model(s)in Cognos 8 using Framework Manager
• Worked closely with the BI team to gather business requirements and specifications.
• Developed technical specifications, data identification and also recommendations on the preferred solution for development, and deploy efficient BI solutions.
• Worked on technical design specifications for the reports and reporting per the requirements.
• Converted the Impromptu Reports to Cognos 8 Report studio reports based on the relational package.
• Converted the Powerplay reports to Cognos 8 Report studio reports using OLAP cubes.
• Used Cognos 8 Transformer to design the OLAP cubes using the Cognos 8 reports as the data sources.
• Designed complex reports (List, Crosstab) using OLAP transformer cubes and implementing complex MDX functions.
• Created various List Reports, Grouped Reports, Cross Tab Reports, Charts and Drill Through.
• Created Reports using Conditional Formatting, multiple Prompts and queries, Filters, Slicers, master-detail relationship, aggregation function.
• Worked on developing complex PLSQL code to generate ETL to populate warehouse from various sources.
• Converted complex Cognos 7 reports, which were based on, excel into Cognos 8 Report Studio reports, which included multiple Report pages.
• Executed SQL queries to validate the data.
• Documented Cubes, Reports in the Lotus Notes Database.
• Validated the converted reports and Cubes to the existing Reports and Cubes to make sure the data are matching.
• Constantly interacted with business users and data architect to manage requirement change.
• Made changes on the Existing cubes as per the user’s requests.
• Performed Month End work for the Cognos 7 Powerplay reports.
• Attended weekly status meeting with the BI team.
• Provided extensive and support to end-users.

Environment: - Cognos 8.3/8.4.1, SQL Server 2005, Access Database,DB2, UNIX, Windows XP, MS Office.