PROFESSIONAL SUMMARY:

• Around 9 years of experience in Data Warehousing (DWH) environment.
• Experience with development in Full Software Development Life Cycle (SDLC) using Agile Scrum methodology and waterfall mode.
• Hands on Experience with Architecture design, New Installations, Configuration, Administration and Security & Migration processes of all COGNOS (11.x/10.X, 8.X/7.x) versions and TM1 10.1, 9.5.X versions.
• Involved in Cognos Analytics migration plans and Analysis.
• Experience in Cognos Administration tasks such as Migration, SSO, and Bursting setup in Cognos.
• Experience with HTML and JavaScript, as used for Cognos reporting.
• Mastered the ability to design and deploy rich Graphical Visualizations in Cognos and Tableau.
• Configuration of Cognos environment, setting up the Security, Notification (email) server, Content store and other Cognos components in a distributed Multi - Tier Environments.
• Experience in Installation and configuration of Oracle 9i, 10g, 11g on a variety of operating systems including LINUX, Solaris and Windows environment
• Expert in Analysis Design, implementation of Business intelligence systems (BI), E-R Modeling, OLTP, OLAP Normalization and developing database schemas like star schemas and snowflake Schema.
• Designed and administer ETL architecture for flow of data from Data warehouse to DataMarts.
• Good understanding of ETL tools Hyperion, Informatica power center for Extraction,
• Extensive experience in Extraction, Transformation and Loading of data from multiple sources into Data warehouse using Informatica. SSIS, Data Manager ETL tool.
• Experience in peer reviewing interactions with Quality Assurance Team (QA) and detailed documentation on each report.

TECHNICAL SKILLS:

Operating Systems: Red Hat,s Linux, Centos, Ubuntu and Windows Server

BigData: Hadoop

Distribution: Cloudera, Hortonworks

Cloud: Google Cloud Platform (GCP) and Amazon Web Services

BI /ETL Tools: Cognos, PowerPlay, SSIS, SSRS, Informatica

Monitoring Tools: Nagios, Ganglia, Cloudera Manger, Ambari, Stack Driver

Ticketing Tools: Jira, Service Now, Cism

RDBMS: Oracle, PostgreSQL, SQL

Scripting: Shell Scripting

Tools: /Utilities: RMAN, OEM, SQL*Loader, Management Studio 2008 and 2012, TOAD.

Hardware Platforms: Sun Fire 15K, Sun Fire 6800, Sun V480 Sun Enterprise 6500 / 450, HP XP256 / XP512, IBM X series Server, and various PC desktop and servers.

PROFESSIONAL EXPERIENCE:

Confidential

Senior Cognos Administrator

Responsibilities:

• Installation and administration of the COGNOS environment 10.2.2.
• Perform system administration duties such as software deployments, system backups, software patching and upgrades.
• Monitor the environment to proactively identify, troubleshoot and resolve issues. Conduct root cause analysis to identify and resolve complex problems impacting service levels.
• Participate in the on-Call rotation to support the environment and user community, Administer security permissions and ensure compliance to required corporate standards, procedures, guidelines and processes, including audits.
• Creation and development of reports, including training using report studio and query studio.
• Develop metadata models as required using Cognos Framework Manager, Transformer, Reports, Dashboards.
• Document the configuration of the system, system controls, and procedures.
• Maintain and monitor all BI environments including development, test, production, and disaster recovery.
• Communicate status of production issues (describing issue, resolution, and status) with both the business and the Business Intelligence team in a timely manner.
• Cross-train with and serve in backup administrator role for other Business Intelligence Applications team members. Coordinate with backup team members and IT monitoring departments in order to provide occasional after-hours system support.

Environment: Cognos 10.x (Framework Manager, Report Studio, Query Studio), Cognos Connection, DB2, Tableau, TM1, Excel, DB2, Netezza, Cognos Data Manager, Active Reports and Ad-hoc Reports.

Confidential

Senior Cognos Administrator

Responsibilities:

• As an administrator, involved in the complete cycle of Project Plan, Design, Installation, Development, Testing, Production Cutover, End User Training and Post Production Maintenance of the system.
• Successfully directed the on-time, on-budget completion of multi-divisions. upgrade to Cognos BI 10.2.2 impacting more than 5000 business users over a global environment
• Installed and configured Cognos 11.0.5 Analytics on the lab machine for the POC purpose.
• Involved an application (CognosUserForm) using Java to enter user information as User Folder, User Class and Security Section to use in Access Manager.
• Created new Users in Cognos using Access Manager - Batch Maintenance by importing text files in testing and production environments.
• Created Import and Export jobs Automation of Audit report, Monitor the Cognos environments, package and Reports Migration(DEV QA PERF PROD).
• Expert in the Installation/Rollback of the hot site or the fix packs provided by the IBM Cognos team.
• Responsible for setting up permissions to secure the models and packages using LDAP groups, Cognos Roles and Groups based upon requirements
• Communicated with users and other technical roles to understand critical error fixes, non-critical error fixes, and application enhancements that require a change to the system baseline.
• Created Dashboards based on requirements.
• Trouble shooted Cognos problems and tuned for performance.
• Provided administrative support for production issues.
• Performed cubes, report unit, system and acceptance testing.
• Involved in data migration process between different versions of Cognos.
• Addressing the Performance and other Production issues with the Cognos 8 BI reports and Power Play cubes.
• Provided documentation, training users and Business Partners on Query Studio for ad-hoc Reporting.

Environment: Cognos10.x,8.x,ETL/InformaticaPowerCenter 9.1/8.6.1/8.5.1 , InformaticaPowerxchange9.1,Oracle11g,SqlServer2012,SSIS,IDE,IDQ,PL/SQL,PostgreSQL,Telecordia,XML,FlatFiles,UNIX,Toad,impromptu,CognosTransformer,PowerPlay,CognosSDK,SQL,FrameworkManager,HTML,VSAM,CSV,XMLfiles,AS400,DB2,ShellScripting,HPQualityCenter,Autosys, WinSCP.

Confidential, CA

Cognos Administrator

Responsibilities:

• Gathering and analyzing the end user requirements
• Implementing star schema and snow flake schema grouping using congos Framework Manager
• Creating cubes and importing them as a package to congos connection and analyzing them using Analysis Studio, Workspace and Workspace Advanced
• Developing and modifying Powerplay reports and graphs in different layouts and formats
• Performing metadata modeling for creating business and presentation layers using Framework Manager
• Enhancing reports by highlighting report data using conditional styles, applying report templates and setting scope using summary and detail filters
• Developing standard reports, charts, drill through reports and master detail reports, bursting reports and multidimensional reports
• Assigning category level and dimension level security to cubes by creating cube views
• Working with the Cognos Administrator and carrying out data and Congos product verification activities
• Developing Framework Manager model with best practices in both compatibility mode and DQM
• Creating ad hoc reports using Query Studio and Workspace
• Knowledge in creating Reports and Dashboards using Active Reports and Business Insight and also in SSRS/SSIS/SSAS worked on netezza.
• Involved in forming joins, Segregating Tables in Folders according to reporting needs of users and hands on experience in selenium tool and had experience in LCM.
• Involved in Branching and merging enables multiple users to work on the same model at the same time and involved in linking the segments to other projects that contain related information to maintain consistency and reuse information.
• Scheduled Burst Reports for regions, zones and districts which delivered the appropriate output for the concerned mangers in Congos Connections by email.
• Created Backups of the content store and Public folders and involved in performance tuning of several Reports and also involved in migrating the Packages/Reports across environments (DEV, UAT, and PROD).
• Used Java Scripts for validating Date/Time controls and adding customized buttons to facilitate the Show/Hide requests.

Environment: Cognos 10.x (Framework Manager, Report Studio, Query Studio), Cognos Connection, DB2, Tableau, TM1, Excel, DB2, Netezza, Cognos Data Manager, Active Reports and Ad-hoc Reports.

Confidential

Cognos Administrator

Responsibilities:

• Involved in system study, analyze the requirements by meeting the client and designing the complete system
• Interacted with internal team and external team for Cognos project allocation and service requests.
• Developed a high-level design to work with PM for project planning purposes
• Maintained strict adherence to all project milestone and timely execution for all issues
• Provided technical assistance, training and mentoring to Users and business analyst
• Involved in migration process to map the scope of the reports from Cognos 8 to Cognos 10
• Extensively worked on multidimensional Cognos cubes with multiple data sources to facilitate OLAP Reports and other analytical tools across the organization using Cognos Transformer 10.x
• Worked on enhancement and creation of new cubes with various optimization techniques
• Performed the administrative duties of scheduling, creating User Groups, triggers etc
• Troubleshooting and tuned FM models.
• Used multiple data sources for building FM model.
• Report Design using Cognos Report Studio, Analysis Studio and Query Studio
• Developed and tuning report studio reports using TM1 cubes and Transformer cubes
• Created relative time categories and customized calculations to be used for reporting purpose
• Created and maintained complex report studio reports with multiple complex queries, joins, unions, conditional formatting and customized SQL based reports.
• Provided inputs to design global reporting template across all business segments
• Performed Unit Testing and User Acceptance Testing
• Performed and interacting with database team to tune the SQL
• Wrote and tuned Pass Through SQL for ad hoc report requests
• Implemented security at Package level, Object level, Data level using Framework Manager
• Enhanced Transformer cubes with new reporting updates
• Developed test cases for the validation and verification of the reports.
• Worked on the design documentation, deployment guide and user guide.
• Worked on ticket tracking system to work with priorities
• Involved in the production support activity to resolve the issues with high priority reports

Environment: Cognos 8.x (Framework Manager, Transformer, Query Studio, Analysis Studio, Report Studio,), Informatica 9, Teradata, BSP Meta Manager

Confidential

ETL Developer

Responsibilities:

• Worked with business team to gather requirements.
• Used Informatica Power Center 9.6.1/9.5.1 for extraction, loading and transformation (ETL) of data in the data warehouse.
• Implemented the slowly changing dimensions (SCD) type1 and type2 to maintain current information and history information in the dimension tables.
• Used Informatica Power Center Workflow manager to create sessions, batches to run with the logic embedded in the mappings.
• Created E-mail notifications tasks using post-session scripts.
• Designed and developed unit test cases for system integration testing.
• Involved with the users in the creation of test scripts for the user acceptance testing
• Worked on tuning some individual mappings and oracle queries that causing performance bottlenecks.
• Written documentation to describe program development, logic, coding, testing and changes made.
• Working on data request tickets and assisting business users (non-technical) to understand the quality of the data.
• Worked on Mainframe COBOL programs to informatica migration project.
• Worked on VSAM COBOL sources and process using Informatica.
• Tuning the ETL-Informatica code in Mapping level and session level.
• Worked on mappings sourcing XML files from message queues into informatica and writing XML files to the target system.
• Worked on stored procedures to informatica migration project.
• Created materialized views to increase the speed of queries.
• Developed some scripts to take weekly backups of certain tables using korn shell and import/export utilities.
• Performed a proof of concept in ETL to categorize junk records before data is pushed to landing, mocking the same functionality of post landing user exits.
• Normalized data schema across four different source systems and successfully delivered projects within budget.
• Configured source systems collaboratively and performed Batch group with Stage and Load jobs.
• Implemented Land Process for loading the customer Data Set into Informatica MDM from various source systems.
• Unix Scripts were written at various situations like event automation and job scheduling.
• Generated SQL Loader scripts and Shell scripts for automated daily load processes.
• Worked as a team member for design and development of Ad-hoc reports using Business Objects.

Environment: Informatica Power Center 7.1, Oracle 9i/8i, SQL*Loader, Erwin, SQL, PL/SQL, UNIX Shell Script, Sun Solaris 2.6, and Windows N

Confidential

Hadoop Administrator/ETL.

Responsibilities:

• Responsible for architect Hadoop clusters.
• Assist with the addition of Hadoop processing to the IT infrastructure.
• Load log data into HDFS using Flume.
• Monitoring Hadoop cluster using tools like Nagio’s, Ganglia and Cloudera Manager.
• Automation script to monitor HDFS through cronjobs.
• Experience in Upgrading hadoop cluster, hbase/zookeeper from CDH3 to CDH4 by Copy the New version of logging files, Update the HDFs Metadata and finalize the upgrade.
• Checking Alert log, Backup-Log and other files.
• Oracle Cluster ware installed to provide infrastructure for RAC and configured 3 node Oracle 10g/11g R2 RAC with ASM.
• Cloning and Refreshing oracle databases from Production Database.
• Created Users, Groups, Roles, Profiles and assigned users to groups and granted privileges and permissions to appropriate groups.
• Working on Tablespace growth and management increasing the size if necessary.
• Backup management, Hot and Cold backups. Restarting the Backups.
• Configuration, maintenance and tuning of Oracle 11g/10g/9i RAC.
• Performed various tasks like administering RAC using SRVCTL, adding nodes and instances, administering storage components, parameter management, configuring high availability features for RAC.
• Create and maintain Oracle Data Guard configuration.
• Upgrading development and production databases to Oracle 10g.
• Applied Security patches and Patch set on Oracle Databases.
• Configured ASM and handled issues and suggested feasible workarounds for ASM Metadata corruption.
• Extensively worked with ASMCMD for managing ASM environment.
• Implemented backup/recovery procedures using RMAN, Data Pump, and performed database recoveries.
• Implemented flashback technology.
• Installation and Implementation of Oracle Data Vault on 10g. This helped to maintain the security feature in well-controlled manner and as of single point with role.
• Extensively used AWR, ADDM, TKPROF, SQL and MySQL Trace for database performance statistics.