SUMMARY

• Over 19+ years of IT experience as Cognos BI Manager/Lead, Architect, Cognos Developer/Report Writer & Administration, software analysis, design and development. Still Work hands on data base Architect and Bi development and at the same time keep users request a top priorty. Experience in being a BI Lead BO Developer/Admin, Qlikview, Tableau, Domo, software analysis, design and development. Analyze new tools and recommend new tools to the management.
• Have experience as technical lead/manager in various projects. Helped clients evaluate and recommended various BI tools and admin tools. The tasks were done and achieved on time and deadlines were met.
• Always try to keep up with latest trend and upgrade myself with the new technologies and implement where ever possible to make the users life easier.
• Experience in creating Estimates for a project. Have experience in On Shore and Off Shore model.
• Experience in Requirement gathering and driving discussion with business and IT Teams. Documenting the requirements and able to translate into technical terms.
• Experience as Cognos architect, involving Installation, configure, design Datamarts, set up security, Create FM Models, Setup ETL Jobs, Automate ETL Jobs, Reporting and Powerplay Cubes.
• Area of expertise encompasses Database designing, ETL phases of Data Warehousing.
• Created Business User type reports and Dashboard using Cognos 10. Optimized the reports and the dashboard.
• Experience in Reporting tools like Cognos, Business Objects and trained in OBIEE.
• Extensive experience with administration & maintenance of Cognos Tools, Upgrade Cognos to Cognos 11.0.7 from Cognos 10.
• Experience in various kinds of reports (Dashboard, List report, grouped list report, summary report, crosstab report, mailing report, form report, freestyle report).
• Experienced with working with users, collecting information and requirement from users, Analyzing, plan and create Reports.
• Involved in connecting to corporate database, to setting up effective catalogs, joins, folders, filters, ensuring that adequate security procedures.
• Working knowledge of the Star Schema and Snow Flake Schema Design strategies.

TECHNICAL SKILLS

LANGUAGES: SQL*plus, PL/SQL, VisualBasic5, 6, JAVA, Sun Solaris Administration.

ETL : Cognos Decision Stream, Cognos Data Manager, SSIS, Informatica Power Center 6.2/6.1/5.1./4.7/3.8

BI TOOLS: Cognos 11.0.7, Cognos 10, 8.4,8.3,8.1, Cognos Express, Reportnet, Query Studio, Report Studio, Event Studio, Analysis Studio, Cognos TM1, Framework manager, Datamanager, Cognos Impromptu 7.0/6.0, Cognos Transformer6.5/7.6, Cognos Powerplay 6.5/7.6, Cognos Decision Stream, Impromptu Web Reports (IWR), Cognos ICM, Cognos Metrics Manager 2.0, Cognos ReportNet, Business Objects, Crystal Reports, TIBCO Spotfire 6.5.1, Qlikview, Tableau.

DATABASES : Oracle 9i/8i/8/7.x, MS Access, SQL server, Netezza, Teradata, DB2

GUI/TOOLS: Toad, DB Artisan, ERWIN, Aginity, SQL*Plus, Excel, Golden32 and PLSQL Developer.

PROFESSIONAL EXPERIENCE

BI Arch/Team Lead

Confidential

Responsibilities:

• The off - Shore team consists of 3 Cognos Writers and 2 ODI ETL developers. I picked up the slack as report Writer and Off Shore team at the end of their day went off line.
• Managing multiple projects. Involved in engaging users into project requirement and testing process. Track every step of the project plan. Train users On Cognos Tools and also provide Training Document.
• Upgrade Cognos 10.0.2 to Cognos 11.0.7
• Lead a team of 5 developers through each step of ETL process as well as report development in Cognos. Involved in Troubleshooting Database Issues and Cognos Reports.
• Involved in Migrating Oracle Discoverer reports into IBM Cognos.
• Day to day activity involves Engaging users, taking requirements, translate into technical Documents, Documenting the requirements, Provide Status to the Director, take part in ETL development issues and troubleshoot them, assign work to the developers, engage various technical teams and managers to get issues resolved. Maintain Design Documents on SharePoint.

Environment: Cognos 11.0.7, Cognos 10.2, Oracle 11g, EBS, AWS, UNIX, Framework Manager, SQL developer, Oracle Discoverer, ODI.

BI Lead/ ETL Tech Lead

Confidential

Responsibilities:

• While Migrating Upgrade Data Stage to 11.3 and Cognos 7 to cognos 10.2.1.
• Analyzed the system with 22 different data warehouse and database source system into one data warehouse GPCR.
• Converted about 1300+ etl jobs and around 100 reports and setup database for ad-hoc reporting.
• Put up strategy to develop and test the ETL in Phases.
• Assign the Etl developers specific Jobs to develop and assigned cognos developer to develop reports on the Target tables.
• Track work every day and achieved the target on time.

Environment: Oracle 12c, Cognos 10.2.1, Datastage 11.3, Framework manager, SQL server 2008 R2, UNIX, Sterling, SQL Developer.

BI Lead

Confidential

Responsibilities:

• Analyzed current environment and setup the team and the process for Migrating 196 reports for the Lift and shift project. Migrating from Teradata to Oracle 12 data source.
• For Carrier and Engineering project, I have analyzed the system and the database and designed a datamart. Using Complex sql queries to build reports in Tibco Spotfire which will support the Bi reporting.
• Helping Client to migrate from Cognos to TIBCO Spotfire 6.5.1.

Environment: IBM Cognos 10.2, Spotfire 6.5.1, Oracle 12C, Teradata, SQL Server R2.

Cognos Bi Metadata Modeler

Confidential

Responsibilities:

• Create and maintain Framework Models. Implement Best Practices in Metadata Design.
• Meeting with Users to determine the needs and requirements for reports.
• Analyze the database/sources and based on the analysis implement the etl and setup the Metadata designs. Created reports and dashboard in Tableau. Convert some of the reports from Cognos to Tableau.

Environment: Teradata, SQL Server, IBM Cognos Framework Manager 10.2, Tableau 9.0