PROFILE:

• 9+ Years of IT experience
• 6+ years of Cognos experience
• 6+ years of Data Warehousing experience
• 6+ years of Data Modeling and Database experience

SUMMARY:

• SDLC: 9+ years of IT experience with expertise in Analysis, Administrating, Design, Development, Implementation and Testing Environments in Various Business Intelligence systems and Application Development.
• IBM COGNOS BI: 6+ years of extensive experience in implementing Business Intelligence (BI) solutions.
• Designed, built and implemented long - term financial planning and reporting systems for multi-billion dollar systems project using IBM Cognos.
• Extensive experience Cognos BI Tools including Cognos BI Version ( 8.X /10.2) (Framework Manager, Report Studio, Query Studio, Analysis Studio, Event Studio, Cognos Connection), Transformer, Power play, Access Manager, Data Manager, Meta Manager, SDK (Software development kit), Cognos Go-office, and Cognos Enterprise Planning tools 8.x (Analyst and Contributor) and BIRT.
• Developed and Published Packages using Framework Manager against relational model and dimensional models.
• Expert at creating Multi-dimensional Cubes / Dynamic cubes with user and role level security using multiple corporate data sources.
• Administration - Installation, Configuration, Administration, performance tuning across multiple environments (Development, Test, Production) and Ensure solutions and deliverables are 100% compliant with the Client’s SDLC and meet controllership and audit standards (e.g., SOX compliance). Proficient in Unix/Linux systems administration (deployment, monitoring, security, maintenance).
• Data Warehousing: 6+ years of extensive experience in Data Mart Development Life Cycle. Performed all dimensions of development including Extraction, Transformation, and Loading (ETL) data from various sources into Data Warehouses and Data Marts.
• Data Modeling: 6+ years of Modeling Experience in Dimensional Data modeling, Star Join Schema/Snowflake modeling, FACT & Dimensions tables, Physical & Logical data modeling, Erwin and Oracle Designer.
• Database: 6+ years of strong analytical and conceptual skills in database design and development using Oracle 10G/9i/8i, IBM DB2, MS SQL Server, DB2, MS Access, PL/SQL, SQL*Plus, SQL*Loader and Developer.

TECHNICAL SUMMARY:

IBM Cognos BI Tools: Cognos Enterprise Planning tools 8.x (Analyst and Contributor)Cognos BI version 10.2/8.X (Framework Manager, Report Studio, Query Studio, Analysis Studio, Event Studio, Cognos Connection ),Cognos Go-Office, SDK, Data Manager, Cognos Series (Impromptu, Transformer, Power play and Access Manager), Decision Stream and Cognos Migration.

Data Warehousing: Informatica Power Center 8.0/7.1/7.0/6.2/6.1/5.2 , Informatica Power Mart 6.2/6.1/5.2/5.1 , Informatica Power Analyzer, Power Connect, Data Cleansing, OLAP, ROLAP, MOLAP, Autosys 3.1/1.1, Star Schema, Snowflake Schema, OLTP.

Data Modeling: Data Modeling, Fact and Dimension Tables, Physical and Logical Data Modeling, Erwin 4.0/3.5, Oracle Designer, Data stage 7.0/7.5, Ab Initio, Framework Manager, System Architect 2001, and Rational Rose

Databases: Oracle 10g/9i/8i/8.0, DB2 UDB 8.0/7.0, MS SQL 7.0, SQL Server 2000.

Programming: C, C++, VBScript, ASP SQL, PL/SQL, SQL*Plus, Visual Basic 6.0/5.0, Java, HTML, DHTML, UNIX Shell Scripting

Environment: HP-UX11/10/9, IBM-AIX 4.0/3.1, AS/400, SunSolaris9/8/7./2.6, SCO-UNIX, Linux, Windows 95/98/2000/XP, WinNT 4.0, MSDOS

Web servers: Sun One 5.2, Microsoft Internet Information Server (IIS) 4.0/3.0, Netscape Directory Server.

Others: MS Office Suite, SPSS 10, Remedy, VPN Client, HTML, SAS, TOAD 8.0.

Business Domain: Health Care Insurance, HIPAA, Life Sciences Regulatory management, Clinical Study Trial Management, Retail Banking Services, Retirement Financial Services. Purchasing & Inventory, Supply Chain management

PROFESSIONAL EXPERIENCE:

Confidential, VERNON HILLS, IL

Cognos Developer / Analyst

Responsibilities:

• Extensively worked very closely with business Partners to pay particular attention to detail and accuracy, and be able to recognize key requirements, analyze business scenarios, define and implement successful business strategies into Cognos BI.
• Proactively able to handle diverse situations, multiple projects and rapidly changing priorities and successfully delivered fast Faced and intelligence solutions that expand to meet the business needs.
• Involved in the full software development life cycle from scoping, analysis, design, implementation, and quality assurance to delivery and support using Waterfall, Agile/Scrum, RUP (Rational Unified Process) and Software Testing Life Cycle (STLC).
• Extensively worked on Cognos Business Intelligence products including Framework Manager, Transformer, Report Studio, Query Studio, Analysis Studio, Metric Studioand Cognos Administration.
• Worked on relational, OLAP, Star Schema, Snowflake Schema, Multi-Dimensional database modeling and design.
• Extensively worked on Dashboards, Reports, Portal tabs and Single sign on using Cognos BI.
• Build dashboard-style reports to give executives an at-a-glance look at the key metrics of the organization using Cognos 10 Business Insight.
• Extensively worked on Active reports for Cognos BI Mobile interactive applications.
• Designed and build multidimensional models and cubes for reporting and analysis.
• Designed automated solutions for creating Cognos Cubes using macros and batch files.
• Proficient in implementing user level and data level security in Cognos.
• Setting up projects across multiple environments (Development, Test, Production) and Ensure solutions and deliverables are 100% compliant with the Client’s SDLC and meet controllership and audit standards (e.g., SOX compliance)
• Coordinate with Software Testers and Release Management to integrate the final work product into the production environment and provide off hours support as required.
• Provide user training and functional and technical documentation.
• Generated and delivered senior-level communication on strategy, status, schedule, and performance.

Environment: IBM COGNOS BI 10.2 (Report Studio, Query Studio, Analysis Studio, Event Studio, Metric Studio),Cognos Go-Office, Framework Manager, Cognos Transformer, Access Manager, Cognos 8 SDK, Decision Stream, Cognos Enterprise Planning tools (Analyst and Contributor), UNIX, LINUX, IBM DB2, SQL Server 2008, Oracle 10g.

Confidential, CA

Cognos Developer / Analyst

Responsibilities:

• Gathered and translated business requirements into functional specifications for planning and reporting systems deliverables.
• Conduct project planning sessions with Project Managers and development team members to analyze business / technology requirements and outline the proposed technology solution
• Designed and implemented consolidated BI data mart for ongoing reporting and analysis.
• Build sophisticated reports/dashboards/scorecards, analysis and queries using Cognos Report Studio, Cognos Query Studio, Cognos Analysis Studio.
• Develop macros/create job/event schedules to automate report execution & delivery.
• Design and develop metadata model in Cognos Framework Manager and published packages.
• Extensively worked on multidimensional cubes Cognos cubes with multiple data sources to facilitate OLAP Reports and other analytical tools across the organization. Designed automated solutions to create cubes
• Setup data level and user lever security in Cognos BI environment.
• Design and maintain all system tools for all scripts and automation processes.
• Performance troubleshooting and Worked on Tuning, Scheduling, changing environment variable settings and other admin related activities.
• Create documents according to system requirements and evaluate all design and perform tests on all development activities and administer all complex methodologies.
• Provided production support, user training and documentation.

Environment: IBM Cognos OLAP/BI Tools (Enterprise Planning, Controller, Analyzer, TM1, Framework Manager, Report Studio, Metric Studio and Cognos Connection), Windows Server, UNIX/LINUX, Erwin, Oracle Designer, Oracle Warehouse Builder, Oracle 9i, Informatica, Data Stage, Decision Stream, Data Manager, SQL, Java and Jscript

Confidential, OAKBROOK TERRACE, IL

BI Programming Analyst

Responsibilities:

• Gathered and understand business requirements and translate into IT solutions with the use of Cognos.
• Developed rapid-prototype or proof-of-concept reporting solutions and demonstrating those solutions to business users to make them familiar with all capabilities of the IBM Cognos product suite.
• Upgraded the existing packages and reports from Cognos 8.3 to Cognos 8.4 and developed new reports and build new frame work models in Cognos 8.4.
• Designed a Corporate Conceptual Model as an architecture migration target and developed procedures to map this model to the database models to facilitate information location
• Architected solutions for budgeting and planning applications using tools TM1, Cognos Enterprise planning and Cognos BI
• Created multidimensional models from various data sources and then distributed as cognos cubes with security using TM1 and Cognos Transformer
• Designed automated solutions for creating Cognos Cubes using macros and batch files.
• Engineered and expanded existing IBM Cognos BI model for capturing financial drivers and Metrics.
• Built original tool set in Microsoft Excel and PowerPoint, then rebuilt system using IBM Cognos Planning and BI tools.

Environment: Erwin, Oracle Designer, Oracle Warehouse Builder, Oracle 9i, Informatica, SQL, Java, Jscript, and IBM Cognos OLAP/BI Tools 8.X (Enterprise Planning, Controller, Analyzer, TM1, Framework Manager, Report Studio, Metric Studio and Cognos Connection), Cognos 7.x (Power Play, Transformer), Power Play Enterprise Server, Windows Server.

Confidential

Data Warehouse Architect / Cognos Developer

Responsibilities:

• IBM Cognos BI Tools - Architecting solutions for budgeting and planning applications using Client/Server, Data Warehouse/Data mart, TM1, Cognos Enterprise planning, BI Reporting tools. Deployed mobile, interactive analytics to Business users using IBM Cognos BI 10.
• Data Warehousing: Extensively worked on Data Mart Development Life Cycle. Performed all dimensions of development including Extraction, Transformation, and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Power Center (Repository Manager, Designer, Server Manager, Workflow Manager, and Workflow Monitor).
• Data Modeling: Proactively involved in Dimensional Data modeling, Star Join Schema/Snowflake modeling, FACT & Dimensions tables, Physical & Logical data modeling, using Erwin and Oracle Designer
• Database - Worked extensively in Web-enabled, three tier and Client/Server computing environments using Oracle, DB2, and SQL Server.
• Administration - Setting up projects across multiple environments (Development, Test, Production) and Ensure solutions and deliverables are 100% compliant with the Client’s SDLC and meet controllership and audit standards (e.g., SOX compliance)

Environment: Cognos Enterprise planning tools 8.x (Analyst and Contributor), TM1, Cognos BI version 10.1/8.4(Framework Manager, Report Studio, Query Studio, Analysis Studio, Cognos Connection), SDK, Cognos Series 7.x (Transformer, Power play and Access Manager) Data Manager, Cognos Migration, Informatica Power Center 8.x, Data stage 7.x, Ab Initio, Oracle 10g, ERwin, Oracle Designer,Oracle Warehouse Builder, Toad 8, Java, UNIX, Linux, IIS, Remedy, VPN Client, SharePoint and MS Office Suite.

Confidential

Software Programmer / Analyst

Responsibilities:

• Solved end user problems in a production support capacity successfully designed, developed, and supported live use applications
• Designed software requirements and implemented code for employee time tracking system. Participated in software testing and code inspections Problem isolation and analysis
• Software quality testing
• Application and requirement analysis
• Responsible for the designing and compiling all the software on pages

The technical environment included: COBOL, C, C++, Microsoft Office, Excel, Word, Microsoft Access, Windows 98/2000/XP, Linux/Unix, IBM Mainframe, AS/400, IBM DB2, Oracle, SQL, PLSQL, MySQL, PHP, DHTML, and CSS.