SUMMARY

• Having 10 years of experience in working wif Data Warehousing Technologies.
• Having sound noledge on Cognos business intelligence tools like Report Studio,Query Studio, Event Studio, Cognos 7.1 Impromptu, Power - play, Transformers and Framework Manager.
• 1+ years of experience in development on Big Data technologies like Hadoop HDFS/MapReduce and its echo systems.
• Experience in all phases of Software Engineering (SDLC), Project management (Waterfall & Agile/Scrum Methodology) including Requirement Gathering, analysis, Define project scope, Design, Coding, Manual Testing, TTD and Implementation.
• Responsible for interacting wif users to identify information me.e., business requirements.
• A Team Player wif analytical and problem solving Skills, ability to communicate TEMPeffectively at all levels of teh development process.
• Flexibility and adaptability in regards wif new technologies and environments.
• Certified in COGNOS 8.4 and 10.1 Report Author.
• Certified in COGNOS Meta-Data Modeling.
• Trained, Tested and Certified in Quality “Green Belt Six-Sigma” and applied in a project showing a sayings of 1440 Man Hour Savings
• Trained, Tested and Certified in Quality ‘LEAN’ showing teh savings of 300 Man hours
• Trained in Hadoop Technologies
• Trained in Basic SAS Reporting Tool
• Got a Best-in-Class certificate for teh performance in teh project.
• Research-oriented, motivated, proactive, self-starter wif strong technical, analytical and interpersonal skills and zeal in learning new Technologies.
• Developed POC’s on Hadoop technologies.

TECHNICAL SKILLS

BI Tools: IBM Cognos (Report Studio, Query Studio, Event,Studio, Frame Work Manager, Impromptu, Power-play, Transformers)

ETL Tools: InformaticaHadoop Eco System: Hadoop- HDFS, HIVE, PIG

Platform: Windows, Linux.

Database: MYSQL, Oracle.

Design Methodologies: UML, Rational Rose.

Scripting Languages: Java Script

Verticals: Insurance, Banking, Auto Financial, Aero-Space, Automobiles and Telecom

Documentation Tools: MS-Word, MS-Excel, MS-Power Point.

PROFESSIONAL EXPERIENCE

Confidential, Portland, ME

Sr. Cognos Developer

Environment: Cognos Report Studio, DB2 (TeraData SQL tool)

Responsibilities:

• Involved in gathering reporting requirements from Business users.
• Strategy & Planning, Results Accountability Complete ownership of end to end of single application related to Claims.
• Analyzing teh complexity of teh requirements and reframing them to get teh better clarity.
• Involved in Daily and Weekly Status Meetings to track down teh report developments.
• Created 1 Standard Report for all customers and 19 Application reports for teh Specific group (Data Analyzer Group) of users for internal purpose.
• Involve in testing teh modified reports in different environments.
• Played a key role while modifying existing reports to has a better view from teh point of Business users.
• Involve in teh process of moving teh reports to User Acceptance Environment through a specified process.
• Involved in creating teh Technical specifications of teh reports that are developed by me.
• Played a key role while modifying existing reports to has a better view from teh point of end users.

Confidential, GA

Hadoop Developer

Environment: Apache Hadoop, Amazon EC2,CDH 4,MapReduce, Oracle RMB, J2EE,IBM AIX, Oracle 11g, Ganglia, SVNHadoop Eco System: Hive,PIG, Sqoop, Oozie

Responsibilities:

• Importing and exporting data into HDFS and Hive using Sqoop
• Involved in creating Hive tables, loading wif data and writing hive queries
• Load and transform large sets of data.
• Implementing MR programs to analyze large datasets in warehouse for business intelligence purpose
• Experienced in managing and reviewing Hadoop log files
• Supported Map Reduce Programs those are running on teh cluster
• Customizing batch Java programs & Shell script development
• Controlling & ownership of teh major application & batch servers
• Writing custom made crons/scripts for proactive alerting mechanism to benefit support teams

Confidential, Detroit, MI

Technical Lead/ Sr. Cognos Developer

Environment: Cognos Report Studio, Event studio, Query Studio, Frame Work Manager.

Responsibilities:

• Involved in gathering reporting requirements from end users.
• Involved in tracking effort and schedule of teh project understanding and participating teh planning activities Identifies risks and prepares mitigation plans.
• Strategy & Planning, Results Accountability Complete ownership of end to end project.
• Analyzing teh complexity of teh requirements and reframing them to get teh better clarity.
• Leading teh team by assigning teh work and accountability of results
• Conduct Weekly Status Meetings and Report Weekly Status to Client/Management.
• Created more TEMPthan 250 reports for various sectors me.e., Audits, Outstanding, Dealer Performance, Risk, Review
• Modified teh Cognos models for adding teh data elements using COGNOS Frame Work Manager.
• Involve in testing teh modified models in different environments.
• Played a key role while modifying existing reports to has a better view from teh point of end users.
• Involve in teh process of moving teh reports to productions through a specified process.
• Schedule teh reports to limited audience on a monthly, weekly and daily basis.
• Interact wif teh offshore team and assign teh work based on teh criticalities.

Confidential, Detroit, MI

Sr.Cognos Developer

Environment: Cognos Impromptu 7.1, Transformer

Responsibilities:

• Involved in gathering reporting requirements from end users.
• Created a Catalog in order to reach teh Reporting Requirements by defining teh Business Rules.
• Resolved various joins that lead multi facts and cross-joins.
• Performed optimization on teh existing reports to decrease teh run time to meet teh real time requirements and made changes to teh existing reports for good look and feel for teh users.
• Created Reports (*.iqd) using teh Cognos Impromptu.
• Impromptu Query Definitions are used as source for developing teh cubes using Transformers
• Improvising teh Cubes performances by doing Cube Partitioning.
• Managed teh project very well to ensure teh project delivered on Time.

Confidential

Cognos Developer

Environment: Cognos Framework Manager, Report Studio, Query Studio, Analysis Studio.

Responsibilities:

• Involved in various stages of project like Gathering Requirements, Designing, Developing and Testing.
• Involved in status calls for creating teh Design document based on teh requirements.
• Involved in developing teh DMR models using teh existing models
• Used DMR models in teh Analysis for creating some Analysis (Reports)
• Created various prompts (Cascading Prompts), filters, conditional formatting, and conditional blocks according to teh report specifications.
• Generated various reports including List, Grouped List, Cross tab, Combinational Chart and Drill -Through Reports.
• Tested (Unit, Regression and User Acceptance Testing- on behalf of end user) for most of teh reports against its database-Oracle.
• Played a key Role in Developing & Documentation of teh Reports.
• Modifying teh existing reports based upon teh change request by teh user.

Confidential

Project Engineer

Environment: Cognos Report Studio

Responsibilities:

• Developing Design Specification Documents for Reports as per client requirements.
• Involved in status calls for updating teh requirements in teh Design document.
• Involved in teh discussion wif different stakeholders across teh world (USA, France, Germany, and U.K) to update teh design Document.
• Developed a proof of concept wif sample Reports to show all stakeholders about teh look and feel of teh Reports.
• Extensively presented them teh features of teh Cognos through which teh reports can be developed.

Confidential

Software Developer

Environment: Java, Oracle and SIP (Session Initiation Protocol)

Responsibilities:

• Developing Design Specification, Functional Requirement Document
• Designed teh database and Detailed Technical design document
• Developed (Coded) Front End and at server side
• Developed a POC using SIP that handles teh distress.
• Complete Documentation of Technical solution.