Software Consultant Resume
Dallas, TX
Experience Summary
- Software Consultant with 6 years of experience in full life cycle Data Warehousing projects.
- Expertise with Cognos 8 suite: Framework Manager, Report Studio, Analysis Studio and Powerplay.
- Worked with IBM Information Server DataStage 8.0.1 and Enterprise Edition7.5.2(Parallel Extender)
- Good understanding of Data Warehouse concepts such as Dimensional Data Modeling, Star and Snowflake Schemas.
- Strong database, SQL/ PL SQL skills with databases DB2 UDB, Oracle 9.x and SQL Server. UNIX (AIX, Solaris) shell scripting skills.
- Excellent interpersonal, written and verbal communication skills.
Education Qualifications
MCA (Master of Computer Applications)
B.Sc. (Bachelor of Science)
Professional Experience
Confidential, USA from Sep’07 to till date.Dallas, TX
Duration : Nov 2008to till date
Contribution:
- Created Presentation layer namespace, shortcuts and DMRs using Framework Manager.
- Interacted with Business Users and gather information and requirements.
- Created reports using Report Studio, Query studio and OLAP reports(Analysis studio) based on Framework Manager model.
- Replaced the existing report package from cube to Framework manager package.
- Involved in migration of cognos from 8.3 to 8.4.
- Created simple to complex reports as well as Dashboard like reports using Report Studio by applying various concepts and functionalities such as drill-through, conditional reporting, master-detail, tables, charts, filters, prompts, various calculations and joins using tabular sets and tabular models
- Created several different types of ad-hoc (Simple List, Grouped List, Section Heading, Crosstab, and Nested Crosstab) Reports and represented data graphically by Charts utilizing Query Studio.
Environment : Cognos 8.4 Analysis Studio, Report Studio, Framework Manger, IBM Information Server DataStage, SQL Server SSIS, and UNIX
Confidential, Cincinnati, US
Duration :April 2008 to Nov 2008
Responsibilities
- Involved in analyzing, documenting functional and technical requirements for developing packages and reports.
- Involved in designing Models using Framework Manager.
- Customized data by adding Filters Prompts, Calculations, Summaries and Functions.
- Created Reports using multiple data providers like Packages, Personal data files, Stored Procedures and Free Hand SQL.
- Developed list, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts, Filters, multi-page, multi-query, Burst Reports against database.
- Created custom prompted reports in Report Studio, Bursting reports to different user groups.
- Moved projects from development to QA and then Production servers.
Environment : Cognos 8.1, DataStage PX 7.5.1, DB2 and UNIX
Confidential, Cincinnati, USA
Duration : Sep 2007 to March 2008
Responsibilities:
- Developed different types of reports like List, Cross-tab, Chart, Drill-Thru and Master-Detail Reports. Created multiple Dashboard reports for multiple packages.
- Developed Prompt Pages, Cascaded input Prompts to display only the selected entries in the report and also worked on the customization of prompt parameters.
- Created List Reports, Cross tab Reports and Control Charts.
- Thorough knowledge of Cognos 8 architecture and administration functions including Content Store, Framework Manager, and Report studio/Analysis/Query Studios /Metric Studio reports development.
Environment : Cognos 8.2, Power Play Transformer 7.3, Cognos 8.3 (Framework Manager, Report Studio, Query Studio, Analysis Studio, Cognos Connection) DataStage 7.5.1, SQL Server 2005,
Confidential, Programmer Analyst Mar’02 to Apr’05
Duration : June 2004 to April 2005
Responsibilities
- Developed Standard Reports, Charts, and Drill through Reports, Master Detail Reports and Bursting Reports using Report Studio.
- Developed reports with Prompt pages with HTML items, Multiple Report Pages with Page Breaks and Conditional Variables.
- Fixed the errors in year-end critical Ad-hoc Reports.
- Installed and Configured Metric Studio.
- Provided Production support for managed reports and the users Ad-hoc reports.
Environment: DataStage 6.5 Server Edition, Cognos 8 BI Framework Manager, Report Studio, Query Studio, Oracle 9i.
Confidential,
Duration: Dec 2003 to May 2004
Responsibilities:
- Created database connections for different data sources.
- Created, organized and formatted reports, folders and other contents on Cognos Connection portal.
- Created several different types of Professional Reports (Mailing Labels, Web Page Style, Cascading, Linked / Drill Through, Production, Business, Ranking, etc…) with complex formatting utilizing Report Studio.
- Produce Queries and Reports in Multiple Languages. Format, Present and Distribute Reports utilizing Different Layouts, Multiple Report Objects and Multiple Logical Pages.
- Create Run, and Schedule Reports and Jobs using Cognos Connection.
- Involved with Scheduling and Distributing Reports through Schedule Management in Cognos Connection.
Environment: SQL Server 2000 DTS, Cognos ReportNet 1.01, Framework Manager, Report Studio, Query Studio, Microsoft Access, SQL Server 2000.
Confidential,
Duration: Feb 2003 to Nov 2003
Responsibilities
- Participated in the development of catalogs, multiple queries with complicated reports and query definition files using various join and filter conditions in Impromptu.
- Created Dimensional Maps, Transformer Models, Power-Cubes and Drill through.
- Created Reports using multiple data providers like Packages, Personal data files, Stored Procedures and Free Hand SQL.
Environment: Cognos Impromptu 6.06, Power Play 6.6, Transformer, IWR, PPES, and Upfront
Confidential, India
Duration: March 2002 to Jan 2003
Responsibilities:
- Developed data specific Impromptu reports with various filter conditions
- Improved the usability of the reports by creating prompts and filters
- Published Impromptu, PowerPlay reports and cubes on the web
- Time scheduled the report publishing using the scheduler
Environment: Cognos EP Series 7.0 (Impromptu, PowerPlay, IWR Server, Transformer, Upfront, Access Manager), SQL Server and Windows 2000