We provide IT Staff Augmentation Services!

Senior Application Developer Resume

Omaha, NebraskA

SUMMARY:

  • 7+ years of IT experience with good knowledge in different phases of software development life cycle (SDLC) including Analysis, Design, Development, Testing and Production.
  • Experience in Cognos 10.x, 8.x (Framework Manager, Report studio, Query Studio, Analysis studio, Event Studio)
  • Experience in creating Models, Packages in Framework Manager and Publishing to cognos connection
  • Knowledge in Cognos Transformer and Power Play Cubes.
  • Knowledge in Amazon Web Services Cloud
  • Excellent knowledge in Data Warehousing Architecture Concepts, and Methodologies like Star Schema, Snowflake Schema used in Relational and dimensional modeling.
  • Experience in Developing List, Cross Tab, Chart, Dynamic Reports and Drill through Reports in Cognos.
  • Developing Dashboard, Report Calculations, Conditional Formatting, Filters and Cascading Prompts using Report Studio.
  • Experience working in Relational Databases like Oracle 10g/9i/8i, DB2, MS SQL Server 2000/2005 and database access tool TOAD, SQL Developer.
  • Knowledge in Teradata, Netezza and Vertica
  • Strong programming and debugging skills on PL/SQL, SQL.
  • Excellent in trouble shooting with quick turnaround in fixing the issues
  • Experience with basic ETL mapping creation using Informatica.
  • Strong Writing and documentation skills for the management, development and control of project.
  • Diverse background with fast learning skills and creative analytical skills.
  • Good communication and interpersonal skills.
  • Excellent work ethics, self - motivated, quick learner with good interpersonal and communication skills.

TECHNICAL SKILLS:

Business Intelligence Tools: Cognos 8.x, Cognos 10.2,Cognos 11

ETL Tools: Informatica 8.6, Informatica 9.5, Informatica 9.6, Abinitio

RDBMS: Oracle 10g/9i/8i., DB2, MS SQL Server2005/2000, MS-Access.

Programming Languages: C, C++, Java, VB.Net, SQL, PL/SQL

Web / Scripting: HTML, Java Script

Web & Application Servers: IIS 5 & 6, Tomcat 4.x/5.x, Sun One Directory Server - iplanet

Testing Tools: Manual Testing, Unit testing

Operating Systems: Windows 2000, 2003 Server, XP

PROFESSIONAL EXPERIENCE:

Confidential, Omaha, Nebraska

Senior Application Developer

Environment: Cognos 10.2.2 (Framework Manager, Report Studio, Query Studio, Cognos Connection), Cognos 11, Abinitio, Oracle 10g, UNIX/AIX Server, TOAD

Responsibilities:

  • Developed Framework Model which supports current operational Reporting System, Dimensional Data models and Data mart models
  • Design and development of Ad-hoc packages involving in user training sessions
  • Experience in working with the Client's infrastructure team to migrate the reports from Hyperion to Cognos
  • Experience in working with Report studio objects like lists, crosstabs, charts
  • Involved in Migration from Cognos 10 to 11 and bug fixes
  • Extensively worked on Java script usage in Cognos Report development to achieve complex features of prompts and display criteria
  • Tracking project progress using JIRA and Scrum board
  • Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts in Report Studio
  • Experience in Scheduling reports by designing regular cognos jobs and using Event Studio for dynamic date parameters.
  • Experience in setting up the object level and package level security for multiple clients.
  • Experience in developing reports using sql query approach to improve the performance of the query.
  • Experience in creating Report template adding reusability for report header and Footer information.
  • Responsible for Unit Testing of Mappings and Workflows for the developed code.
  • Documenting support guides for Support/service center team to handle the go-live process queries and address the after go-live User Queries.

Confidential, Omaha, Nebraska

Senior Application Developer

Environment: Cognos 10.2.1 (Framework Manager, Report Studio, Query Studio, Cognos Connection), Abinitio, IBM DB2, UNIX/AIX Server, TOAD

Responsibilities:

  • Developed Framework Model which supports current operational Reporting System, Dimensional Data models and Data mart models
  • Design and development of Ad-hoc packages involving in user training sessions
  • Experience in working with Report studio objects like lists, crosstabs, charts
  • Extensively worked on Java script usage in Cognos Report development to achieve complex features of prompts and display criteria
  • Tracking project progress using JIRA and Scrum board
  • Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts in Report Studio
  • Experience in Scheduling reports by designing regular cognos jobs and using Event Studio for dynamic date parameters.
  • Experience in setting up the object level and package level security for multiple clients.
  • Experience in developing reports using sql query approach to improve the performance of the query.
  • Experience in creating Report template adding reusability for report header and Footer information.
  • Responsible for Unit Testing of Mappings and Workflows for the developed code.
  • Documenting support guides for Support/service center team to handle the go-live process queries and address the after go-live User Queries.

Confidential, Brooklyn, New York

Cognos Consultant

Environment: Cognos 10.2 (Framework Manager, Report Studio, Query Studio, Cognos Connection), Informatica 9.5, Oracle 10g, TOAD

Responsibilities:

  • Developed Framework Model which supports current operational Reporting System, Dimensional Data models and Data mart models
  • Experience in working with the Client's infrastructure team to migrate the reports to production servers
  • Experience in working with Report studio objects like lists, crosstabs, charts
  • Extensively worked on Java script usage in Cognos Report development to achieve complex features of prompts and display criteria
  • Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts in Report Studio
  • Experience in Scheduling reports by designing regular cognos jobs and using Event Studio for dynamic date parameters.
  • Experience in creating and using session parameters in Framework manager and cognos Reports.
  • Experience in developing reports using sql query approach to improve the performance of the query.
  • Experience in creating Report template adding reusability for report header and Footer information.
  • Experience in working with the Onsite and Offshore team and delivering task as per schedule
  • Responsible for Unit Testing of Mappings and Workflows for the developed code.
  • Used various Informatica Transformations like Source Qualifier, Rank, Filter, Router, Filter Lookup, Joiner, Aggregator, Normalizer, Sorter etc.
  • Responsible for Unit Testing of Mappings and Workflows for the developed code.
  • Documenting support guides for Support/service center team to handle the go-live process queries and address the after go-live User Queries.

Confidential

BI Modeler and Report Author

Environment: Cognos 8.4, 10 (Framework Manager, Report Studio, Query Studio, Cognos Connection), SQL Developer Tool, Windows 2003 server, Oracle 11g, Informatica 8.6

Responsibilities:

  • Experience in working with Report studio objects like Page sets, lists, crosstabs, graphs
  • Experience in building Master-Detail, Drill-thru, Drill-down reports
  • Creating and Modifying business Data Model according to Business requirements
  • Documenting System Requirements and technical requirements
  • Designing of Complex Cross Tab Reports using Report Studio
  • Involved in Migration from Cognos 8.4 to 10 and bug fixes
  • Designing Jobs to Schedule reports and Bursting Reports to various Pay Group’s
  • Generating reports by creating groups, Sections, defining filters, defining prompts and creating summary fields
  • Involved in Deployment of Reports from Development Environment to QA and Production Environment
  • Experience in Scheduling reports by designing regular cognos jobs and using Event Studio for dynamic date parameters.
  • Experience in creating and using session parameters in Framework manager and cognos Reports.
  • Experience in developing reports using sql query approach to improve the performance of the query.
  • Experience in creating Report template adding reusability for report header and Footer information. Ex: company logo, page numbers, Report Run date, Database update date.
  • Involved in extracting data from different types of Data Sources like Oracle, Sql Developer and Flat Files.
  • Involved in identifying the bottlenecks for the long running jobs and performance tuning of the ETL's.
  • Developed Slowly Changing Dimension Mappings for Type 1 SCD and Type 2 SCD
  • Used various Informatica Transformations like Source Qualifier, Rank, SQL, Router, Filter Lookup, Joiner, Aggregator, Normalizer, Sorter etc.
  • Responsible for Unit Testing of Mappings and Workflows for the developed code.
  • Involved in unit testing.

Confidential

BI Modeler and Report Author

Environment: Cognos 8.x (Framework Manager, Report Studio, Query Studio, Cognos Connection), SQL Developer Tool, Windows 2003 server, Oracle 10g, Informatica 8.6

Responsibilities:

  • Designing of reports using Report Studio and Query Studio
  • Updating FM Model according to the requirement and publishing package when required
  • Defining Usage Properties, Validating cardinalities according to the requirements
  • Generated reports by creating groups, defining filters, defining prompts and creating summary fields
  • Customization of prompts and report pages functionality using JavaScript.
  • Involved in Deployment of Reports from Development Environment to QA and Production Environment
  • Unit testing the application and providing best approaches for quality improvement.
  • Involved in Migration from Cognos 8.3 to 8.4 and bug fixes
  • Understanding existing business Data Model and customer requirements
  • Experience in Scheduling reports by designing regular cognos jobs and using Event Studio for dynamic date parameters.
  • Experience in creating and using session parameters in Framework manager and cognos Reports.
  • Experience in developing reports using sql query approach to improve the performance of the query.
  • Experience in creating Report template adding reusability for report header and Footer information. Ex: company logo, page numbers, Report Run date, Database update date.
  • Used various Informatica Transformations like Source Qualifier, Rank, SQL, Router, Filter Lookup, Joiner, Aggregator, Normalizer, Sorter etc. and all transformation properties
  • Involved in extracting data from different types of Data Sources like Oracle, Sql Developer and Flat Files.
  • Used Informatica Workflow Manager to schedule jobs in Informatica and execute workflows
  • Responsible for Unit Testing of Mappings and Workflows for the developed code.
  • Used different workflow variables, session parameters, Mapping Parameters, Mapping Variables and Parameter files

Confidential

Training/Development

Responsibilities:

  • Expertise in conducting training on Data warehousing concepts, report creation in Query and Report Studio applications in class room setup and web ex sessions.
  • Expertise in conducting training on basics and best practices in developing and building of data models, reports.
  • Expertise in explaining and defining different levels of security and groups in cognos
  • Responsible for writing technical documentations, and user manuals for data warehousing to guide and support the technical learning process

Hire Now