SUMMARY

• Sr. BI Solutions Architect with over 20 years of experience in Information Technology and possess extensive experience with Data Modeling, Reporting and Dashboards. Proficient with BI Tools (Cognos Analytics 11.1.4, TM1 10.2.2, Cognos 10.x/8.x/ReportNet 1.1/Cognos Series 7.x, Databases (Teradata, Oracle 12c/11g/10g, DB2/UDB, Netezza and SQL Server 2014/2012) on Windows and LINUX/UNIX/Sun Solaris Platforms.
• Subject - Matter Expert (SME) or domain expert in Cognos Analytics 11.1.4, Cognos 10.x/8.x, TM1 10.2.2, ReportNet 1.1, with Cognos Connection, Framework Manager, Tableau, ThoughtSpot, SSAS, SSRS, Cognos Workspace, Cognos Workspace Advanced, Active Reports, Report Studio, Analysis Studio, Query Studio, Event Studio, Metric Studio, Metric Designer, TM1, Turbo Integrator and SSIS.
• Sound understanding and experience with Hadoop ecosystem (Cloudera). Able to understand and explore the constantly evolving tools within Hadoop ecosystem and apply them appropriately to the relevant problems at hand.
• Experience in working with a Big Data implementation in production environment.
• Experience using Hadoop technologies (HDFS, Hive, Impala, Map Reduce, Pig, Yarn, Kafka/spark)
• Experience with Tableau application performance monitoring, capacity planning, Health Checks and tuning for multiple members on multiple projects
• Extensively worked on Cognos SDK development for Cognos Security Sync Process using REST API.
• Proven experience building data warehouses using the Kimball methodology for data modeling.
• Very good experience in translating requirements into flexible semantic layers Framework Manager and deploy solutions that provide easy to build ad-hoc analyses and visualizations.
• Administration: Very strong in install (Multi Server - LINUX/UNIX/Windows), upgrade, configure, tune, troubleshoot, and maintain all the components in an enterprise level BI architecture.
• Experienced in Database Design/Development in Oracle 12c/11g, Teradata, Netezza, DB2/UDB, SQL Server 2014/2012, and MS-Access.
• Actively involved in System Analysis, Design, Development, Data Modeling, Testing, Maintenance and On Going Support of Process and Development Procedures.
• Experienced in Developing Data Mart, ROLAP, MOLAP, Star Schema, Snowflake Schema, Extract, Transform, and Loading of Data Requirement Analysis, Design, Development, Testing, Documenting and Implementation of Business Applications.
• Extensive usage in writing, testing, implementation of the Stored Procedures, Triggers, Functions, Packages at Database level using PL/SQL and SQL Server 2005.

TECHNICAL SKILLS

Big Data/Hadoop Eco Systems: Cloudera, HDFS, Hive, Impala, Map Reduce, Pig, Yarn, Kafka/spark

BI Tools: IBM Cognos Analytics 11.1.4, Cognos 10.2.2/10.1.1 , TM1 10.2.2, Cognos 8.x, ReportNet 1.1, Cognos Connection, Framework Manager, Report Studio, Cognos Workspace, Cognos Workspace Advanced, Active Reports, Tableau, TM1 Architect, Perspectives for MS Excel, TM1 Web, Analysis Studio, Query Studio, Transformer, Event Studio, ThoughtSpot, SSAS, and SSRS.

ETL Data Warehousing: Informatica 9.6/8.x/7.x/5.1, Data Stage, Oracle Warehouse Builder 9.2, Data Manager, and Decision Stream.

Databases: Oracle 11g/10g/9i, Teradata, Netezza, DB2/UDB, SQL Server 2005/2008 and MS Access.

Languages: Python,, JAVA, C#, C, C++, SQL, PL/SQL and COBOL.

GUI: ASP.Net, HTML, DHTML, XML, Java Script, VB Script, Crystal Reports 8.5.

Others: Erwin 4.0/3.5.2, Designer 2000, TOAD, MS Project, SQL*Loader, Visual Studio, Visual Source Safe 6.0, GIT, MS Office, SAP BW 3.5. Qwest Central 4.8, Queryman 6.0.

Operating Systems: Windows Server 2012/2008 R2, Linux 6.9, UNIX, Sun Solaris and MS DOS

Web Services: Apache, WebSphere and WebSphere Liberty

PROFESSIONAL EXPERIENCE

Confidential

Sr. Solutions Architect/Team Lead

Responsibilities:

• Responsible for running the day to day operations of the production support.
• Worked on Production Services roles include Problem/Incident Management, Release/Deployment, Operational Readiness, Capacity/Availability Management, Application Monitoring, Service Analytics and Reporting, Production Governance, Triage, Associate Support, Change/Configuration Management, etc.
• Analyze production failure scenarios, creates incident tickets, enhancements and/or problem tickets in ticket tracking system, and communicates effectively with development and internal business operations teams.
• Create and enhances administrative, operational and technical policies and procedures, adopted best practice guidelines, standards and procedures.
• Takes ownership of escalations and perform trouble shooting, analysis, research and resolution using advanced query and programming skills.
• Involved in install, upgrade, configure, troubleshoot, tune and maintain all the components in an enterprise-wide BI architecture for multiple Solutions.
• Extensively supported the patching activities for Informatica, AbInitio, Report Plant and Cognos BI servers.
• Developed and Designed models in Framework Manager according to business specifications to build reports.
• Experience developing dimensional and relational data models for reporting purposes using different Cognos components.
• Performed analytical, technical, and administrative work in planning, installing, designing and supporting new and existing equipment and software under moderate supervision.
• Worked on REST API calls using JSP for large file download option from Cognos.
• Extensively Implemented Bursting mechanism to Burst the reports at User Level and send the report output as an email attachment in different formats.
• Created Session Parameters at user level and implemented the data level security.
• Scheduled reports to run on a monthly, weekly, and daily basis using Cognos Connection Scheduler.
• Extensively used Event Studio to schedule the reports with different events and send the email notifications to the recipients based driving table.
• Created Users and Groups/Roles for business customers.
• Involved in developing queries using SQL, Transact-SQL and PL/SQL
• Involved in the Cognos Analytics 11.0.7, Cognos 10.x, extensively involved in multi-server installation and configuration of the multiple BI environments.
• Involved in developing the Stored Procedures in order to use them in the framework model.
• Created dimension views and Custom views to implement the data security in the Transformer Model.
• Participated with management in the development of technology products, service standards and development efforts that impact the client/business area.
• Served as an escalation point between the client/business area and internal management for the resolution of moderately complex unresolved problems, complaints and service requests.
• Able to debug and fix production issues by analyzing Confidential / Hive scripts and Java code.
• Monitor the ETL batch jobs and handle job failures with in timelines.
• Monitor daily data load jobs, application and server logs.
• Participate in high priority incident triage calls which may include but not limited to DB server issues, application server issues and network issues.
• Be able to work with team members & support partners located in multiple geographical locations.
• Good in UNIX / AutoSys scheduling tools.

Environment: Cognos Analytics 11.1.4/10.2.2/ , Informatica 10.1.0, Framework Manager, Cognos Connection, Cognos Workspace, Cognos Workspace Advanced, Query Studio, Analysis Studio, Event Studio, Tableau, Salesforce, Arcadia Data, Cloudera, HDFS, Hive, Impala, Map Reduce, Pig, Yarn, Kafka/spark, HDFS, Hive, Impala, Map Reduce, Kafka/spark LDAP, Active Directory, Oracle 12c, Transact-SQL, SQL Server 2014, Toad 11.6.0, Visio, Apache, WebSphere, IIS Server, Java, Java Script, Eclipse, GIT, Java SDK, XML, WinSCP, PuTTy, AutoSys, Confidential Scripts, Microsoft SharePoint, PaPa, Windows Server 2012/2008 R2 Server and Red Hat Enterprise Linux Server release 6.9.

Confidential, Richardson, TX

Sr.BI Architect

Responsibilities:

• Responsible for overall project and enhancements delivery for BI Team.
• Responsible for overall health of different Cognos environments.
• Identification and mitigation of conflicts with other projects, resource needs, drives technical and process innovation.
• Involved in gathering functional requirements from business users, analyzed their requirements and transformed them into business intelligence specifications.
• Involved in install, upgrade, configure, troubleshoot, tune and maintain all the components in an enterprise-wide BI architecture for multiple Solutions.
• Developed and Designed models in Framework Manager according to business specifications to build reports
• Experience developing dimensional and relational data models for reporting purposes using different Cognos components.
• Developed Transformer Models using different data sources.
• Developed Dashboards using Tableau and Thought Spot for data Visualization.
• Deployment of Tableau Server in clustered environment and performing upgrades.
• Tableau User Group and User Entitlement Administration,
• Experience with Tableau application performance monitoring, capacity planning, Health Checks and tuning for multiple members on multiple projects
• Worked Cognos SDK using Java for Cognos External Namespace Auto SecuritySync process.
• Worked on REST API calls using JSP for X12 for large file download option from Cognos.
• Extensively Implemented Bursting mechanism to Burst the reports at User Level and send the report output as an email attachment in different formats.
• Created Session Parameters at user level and implemented the data level security.
• Scheduled reports to run on a monthly, weekly, and daily basis using Cognos Connection Scheduler
• Extensively used Event Studio to schedule the reports with different events and send the email notifications to the recipients based driving table.
• Created Users and Groups/Roles for business customers
• Involved in developing queries using SQL, Transact-SQL and PL/SQL
• Involved in the Cognos Analytics 11.0.5, Cognos 10.x, TM1 Administration, extensively involved in multi-server installation and configuration of the multiple BI environments.
• Involved in developing the Stored Procedures in order to use them in the framework model.
• Created dimension views and Custom views to implement the data security in the Transformer Model.
• Involved in budgeting, planning for operational IT models
• Documented the process of developing reports.
• Coordinating with the team on outages and changing TM1 chore schedules as necessary
• Integrated Cognos TM1 with Cognos BI and performed BI Reporting.
• Performed Troubleshooting by Diagnosing errors by viewing error log files.
• Created temporary Views, Subsets using Turbo Integrator and populated data for Actuals.
• Sound knowledge on Work Sheet Functions and Strong Excel skills.
• Proficient in creating complex Active Forms and enhanced the performance of existing Active forms.
• Installed TM1 prospective on User’s machine and performed Troubleshooting.

Environment: Tableau, Cognos Analytics 11.0.6/ 10.2.2/10.1.1 , Informatica 9.6, TM1 Architect, Turbo Integrator, TM1 Web, Framework Manager, Cognos Connection, Report, Cognos Workspace, Cognos Workspace Advanced, Query Studio, Analysis Studio, Transformer, Event Studio, Thoughspot, Salesforce, LDAP, Active Directory, Oracle 12c, Transact-SQL, SQL Server 2014/2012, Toad 12.9, Visio, Apache, Data Power, Sharepoint, WebSphere Liberty, Java, Java Script, Eclipse, CVS, GIT, Java SDK, XML, X12, WinSCP, PuTTy, Power Confidential, Tidal, Confidential Scripts, Microsoft SharePoint, Windows Server 2012/2008 R2 Server and LINUX 6.9.

Confidential, Irving, TX

Sr. BI Architect/Analyst

Responsibilities:

• Involved in gathering functional requirements from business users, analyzed their requirements and transformed them into business intelligence specifications.
• Responsible for overall health of different Cognos environments.
• Identification and mitigation of conflicts with other projects, resource needs, drives technical and process innovation.
• Involved in install, upgrade, configure, troubleshoot, tune and maintain all the components in an enterprise-wide Cognos BI architecture.
• Created dashboards using Business Insight and created Ad Hoc reports using Business Insight Advanced.
• Created OLAP cubes using Transformer with different Packages and published Power Cubes to Cognos Connection
• Developed and Designed models in Framework Manager according to business specifications to build reports
• Experience developing dimensional and relational data models for reporting purposes using different Cognos components.
• Developed Transformer Models using different data sources.
• Developed and Designed Chart reports, List reports, Cross Tab reports, Master Detail Reports, Drill Through Reports, Drill Up/Down Reports and Map Reports in Report Studio that are required for the business users.
• Using the Analysis Studio/PowerPlay Studio, the cubes are analyzed to make decisions for upcoming seasons
• Responsible for publishing cubes to the Cognos Connection as a Package and Publishing the packages and assigning the security for Business User Community and also Deployment of Packages and reports from Development to Production Servers.
• Extensively Implemented Bursting mechanism to Burst the reports at User Level and send the report output as an email attachment in different formats.
• Created Session Parameters at user level and implemented the data level security.
• Scheduled reports to run on a monthly, weekly, and daily basis using Cognos Connection Scheduler
• Extensively used Event Studio to schedule the reports with different events and send the email notifications to the recipients based driving table.
• Involved in developing queries using SQL, Transact-SQL and PL/SQL
• Incorporating Corporate Active Directory for authentication in Cognos Connection.
• Involved in developing the Stored Procedures in order to use them in the framework model.
• Created dimension views and Custom views to implement the data security in the Transformer Model.
• Involved in budgeting, planning for operational IT models
• Documented the process of developing reports.
• Involved in Installation and Configuration,
• Coordinating with the team on outages and changing TM1 chore schedules as necessary
• Metadata Changes (e.g. setting up new scenarios for what-if analysis, creating new roll-ups, etc.)
• Mass data updates/migration (i.e. when a cost center or account number changes )
• Proficient in writing Cube Rules, appropriate Feeders and fine tune Feeders for better performance.
• Created temporary Views, Subsets using Turbo Integrator and populated data for Actuals.
• Sound knowledge on Work Sheet Functions and Strong Excel skills.
• Proficient in creating complex Active Forms and enhanced the performance of existing Active forms.
• Provided Production Support for Applications and Models in Production.
• Installed TM1 prospective on User’s machine and performed Troubleshooting.
• Integrated Cognos TM1 with Cognos BI and performed BI Reporting.
• Responsible for assigning user Sign-Ons for the New Users.
• Increased Performance by Monitoring Stats by Cube and TM1 Top Utility.
• Performed Troubleshooting by Diagnosing errors by viewing error log files.
• Scheduled Chores and Monitored Data Loads on timely manner.
• Knowledge on Cognos TM1 Work flow and TM1 Executive viewer
• Experience in guiding users through TM1 Web and TM1 Reports.

Environment: Cognos 10.2/ 10.1.1/8.4.1 , TM1 Architect, Turbo Integrator, TM1 Web and Contributor, Framework Manager, Cognos Connection, Cognos Go Office, Report Studio, Business Insight, Business Insight Advanced, Query Studio, Analysis Studio, PowerPlay Studio, Transformer, Metric Studio, Metric Designer, Event Studio, Tableau, Active Directory, Oracle 11g, Transact-SQL, SQL Server 2008, Toad 9.1, Visio, Apache, Java Script, Eclipse, CVS, Java SDK, XML, Confidential Scripts, Microsoft SharePoint, IssueNet, RSS Feed, Windows 2008 R2 Server and UNIX.

Confidential, Fort Worth, TX

Sr. BI Consultant

Responsibilities:

• Involved in functional requirements gathering from business users, analyzed their requirements and transformed them into business intelligence specifications.
• Translated requirements into flexible semantic layers via Cognos and Tableau and built solid semantic layers within BI tools in support of developing ad-hoc analyses and Data Visualizations.
• Collaborated with business users to capture and document their analytical requirements.
• Developed and Designed models in Framework Manager according to business specifications to build reports
• Troubleshoot errors/issues with production reports.
• Developer/Mentor assistance and Supported end user ad-hoc query requests and helped with report development.
• Developed and Designed Chart reports, List reports, Cross Tab reports, Master Detail Reports, Drill Through Reports, Drill Down Reports and Map Reports in Report Studio that are required for the business users.
• Involved in developing the report Views in order to use them in the Framework Manager model
• Created Ad Hoc reports using Business Insight Advanced.
• Developed Transformer Models using different data sources.
• Created OLAP cubes using Transformer with different Packages and published Power Cubes to Cognos Connection.
• Using the Analysis Studio/PowerPlay Studio, the cubes are analyzed to make decisions for upcoming seasons.
• Extensively Implemented Bursting mechanism to Burst the reports at User Level and send the report output as an email attachment in different formats.
• Created Session Parameters at user level and implemented the data level security
• Involved in developing queries using Teradata SQL Assistant 12.0

Environment: Cognos 10.1.1/8.4.1 , TM1 Architect, TM1 Turbo Integrator, Framework Manager, Cognos Connection, Business Insight, Business Insight Advanced, Turbo Integrator, Active Reports, Report Studio, Query Studio, Analysis Studio, Transformer, Event Studio, Tableau, Active Directory, Teradata, Oracle 11g, SQL, T-SQL, Server 2008, Toad 9.1, Visio, Java Script, Eclipse, Java SDK, XML.

Confidential, Fort Worth, TX

Sr. Cognos 8 BI Developer/Architect

Responsibilities:

• Gathered requirements from end users, analyzed the client needs and proposed solutions.
• Involved in the best practices creation and implementation for the data warehouse.
• Developed advanced report Templates, List, cross Tab, Drill through, Master-Detail, Repeater, Union, Chart, Burst and complex reports which involved Multiple Prompts, Filters, multi-pages reports with executive Dashboards, multi-query reports against multiple databases.
• Provided expert level COGNOS 8BI metadata models with Database View, Presentation View and Dimension View based on the requirement.
• Managed DEV, UAT & PROD environments and migration across these environments.
• Created OLAP cubes using Transformer and published Power Cubes to Cognos Connection.
• Imported Cubes into Framework Manager and published them as packages to Cognos connection for analysis in Analysis Studio.
• Created dashboard reports using Cognos Go Office (Excel Add-In) and published executive presentations.
• Implemented JAD/RAD methodologies for the application development.
• Migrated around 700 reports from ReportNet 1.1 to Cognos 8BI v8.4 and validated Framework Models.
• Scheduled and distributed reports through Schedule Management in Cognos Connection.
• Involved in Query Optimization and UAT Test Plans on all the user reports.
• Extensively worked on SQL, PL/SQL and created Stored Procedures.
• Data analyzed and extracted the data from existing database and involved in query optimization.
• Involved in testing and exploring Report Studio, Query Studio, and Analysis Studio.
• Created Metadata models and several packages using Framework Manager.
• Created updated and managed User accounts in Access Manager.
• Involved in Multi server installation and configuration of the Cognos 8 BI, deployed the packages into multiple environments.
• Implemented security in Cognos Connection, on packages, maintained user authentication and authorization with LDAP and Cognos groups and roles.
• Conducted end user training sessions and prepared the training documentation.
• Administered the reporting environment, assign user permissions, creating user accounts, providing security access to users and groups with help of Access manager.

Environment: Cognos 8BI 8.4GA, ReportNet 1.1, Framework Manager, Cognos Connection, Cognos Go Office, Report Studio, Query Studio, Analysis Studio, PowerPlay Studio, Transformer, Metric Studio, Metric Designer, Event Studio, PowerPlay 7.3, PPES, LDAP, Clear Quest, Oracle 10g, SQL Server 2005,SSIS, SSAS, Cognos Migration Utility, Toad 8.4, Erwin 4.0, Apache, Java Script, Eclipse, CVS, Java SDK, XML, Confidential Scripts, Microsoft SharePoint, RSS Feed, Windows 2003 Server and Sun Solaris

Confidential, Richardson, TX

Sr. Cognos 8 BI/Report Net Developer

Responsibilities:

• Gathered requirements from end users, analyzed the client needs and proposed solutions.
• Involved in Joint Application Design (JAD) sessions to determine end-user and infrastructure requirements.
• Involved in the best practices creation and implementation for the data warehouse.
• Created reports, simple and complex including conditional formatting, prompted, reports, reports with customized queries, filters, case statements, conditions, and hyperlinks.
• Developed List, cross tab, drill through, master-detail, Repeater, Union, chart, burst and complex reports which involved Multiple Prompts, Filters, multi-page, multi-query reports against multiple databases.
• Provides expert level COGNOS 8BI metadata modeling services builds the conceptual, logical and physical database model, both relational and dimensional.
• Migrated the reports from ReportNet 1.1 to Cognos 8BI v8.3 and validated Framework Models.
• Created the Stored Procedures to extract the data from XML files.
• Migrated from Actuate reports to Cognos 8BI using Report Studio.
• Scheduled and distributed reports through Schedule Management in Cognos Connection.
• Involved in Query Optimization and UAT Test Plans on all the user reports.
• Involved in testing and exploring Report Studio, Query Studio, and Analysis Studio.
• Involved in installation and configuration of the Cognos 8 BI and deployed the packages into multiple environments.
• Customized the reporting environment by adding new portal skin including corporate logos and approved colors and new links.

Environment: Cognos 8.3/8.2, ReportNet 1.1, Framework Manager, Cognos Connection, Report Studio, Analysis Studio, Event Studio, Query Studio, Transformer 7.3, PowerPlay 7.3, PowerPlay Enterprise Server (PPES) 7.3, Access Manager, Actuate, Siebel 7/8, SQL Server 2000, DTS, DB2/UDB, Cognos 8 SDK, Microsoft SharePoint, RSS Feed, Visual SourceSafe 6.0, LDAP, Toad 8.6.1, Erwin 4.0, MS-Excel, XML and Windows 2003 Server.