PROFESSIONAL SUMMARY:

• Working as a Senior BI Architect/Tech Lead with over 18 years in information technology experience of which over 16 years of experience are in administering, installing, configuring, upgrading, patching various reporting and BI applications to include Tableau, Cognos, Cognos TM1 (occasionally), SSRS, Power BI and Actuate eRporting in very large distributed environments. Worked extensively on setting up Tableau, Cognos, SSRS, Power BI environments in very large distributed environments for both internal and external customers. Strong leadership skills managing large BI and Data warehouse and 24/7 Production support teams. Complimented by strong analytical and problem solving skills.

TECHNICAL SKILLS:

BI/Report Servers: Tableau, Cognos 8/10.X/11.0.X/11.1, Power BI, SSRSActuate iServer

Reporting Tools: ReportStudio, QueryStudio, PBI Desktop, Report builderActuate eRdPro 3 - 10, eSpreadsheet

Business Intelligence: Tableau, Cognos - (Impromptu, PowerPlay, Transformer, Framework Manager, ReportStudio, QueryStudio, Analysis Studio), Power BI, Motio, GenwareMetaManager, JasperSoft, Pentaho

Languages: PERL, ASP, HTML, Kron Shell, Java Script, XML, XSLT, X- Path, COBOL, and ActuateBasic.

RDBMS: ORACLE 7-11i, Teradata, DB2, SQL, PL/SQL, SQLSever, Sybase & ACCESS.

O/S: Windows 95/98/XP/2000, Windows NT 4.0, Mac OS and UNIX

Tools: Autovisn, Netvisn, Metamenager, Genware, MS Project, Visio, RapidSql

Other: Actuate Administration, Actuate Web Services, IIS, Apache, Java WebServer1.1.3/2.0, Actuate Report Server (iServer), IDAPI, Report Cast, Web Agent, Actuate Server Utilities, Actuate Performance Tuning, Excel Reports Using Macros.

EXPERIENCE:

Confidential

Sr. Platform Administrator/Architect

Responsibilities:

• Worked extensively upgrading existing Cognos 10.1 and 10.2.1/10.2.2 to Cognos 11 R8/12 and Cognos 11.1.
• Worked extensively with Power BI Report Server, Power BI Saas in Azure cloud, SSRS.
• Working on enabling mobile capability for Power BI. Also evaluating Data Factory express route.
• Migrated Tenants content by waves to avoid risks and complexity.
• Performed vulnerability and penetration tests for externally facing Cognos and Tableau environments.
• Developed 90 Day disablement process for both Cognos and Tableau environments.
• Developed multiple customizations to get rid of recents, quick links etc from Cognos 11 Analytics home page.
• Worked on a variety of Tableau projects in a distributed environment.
• Extensive experience upgrading Tableau server in a distributed environment.
• Setting up DR environments in both Stage and Prod for external facing Tableau environment.
• Spun up servers to assist Tableau external customers.
• Implemented Role based security within Tableau environments.
• Created a process to automate Cognos cube build process.
• Spun up Power BI Dev server and setting up security and folder structure for Tenants
• Set up the process to onboard new Tenants.
• Worked with LDAP and Active Directory integration.

Confidential

Senior BI Cognos and Tableau Architect/Sr. Manager

Responsibilities:

• Delivery of multiple accounts, administering, managing and supporting Cognos 10.X and Cognos 8.X, Tableau7/8X, migration of Cognos 8.4.1 to Cognos 10.X.
• Built Cognos 10.X from scratch on new windows 2008 R2 64 bit servers to support End State Project.
• Spun up Tableau environment with 4 workers to support external customers
• Implemented Role based authorizations to Tableau external environment
• Worked on Capacity planning, installing & configuring Cognos 10.X suite and configuring third party tools such as Metamanager, Univisn, Autovisn, Print to File, SharePoint delivery, etc. Worked extensively on integration and consolidation of multiple Cognos BI environments, process improvements.
• Hands-on experience with Oracle to Teradata migration, migrating Cognos related packages, reports, Transformer cubes from Oracle to Teradata.
• Implemented Query Band functionality to support row level security in Teradata.
• Installation and configuration of Tableau Server to include work with security, schedules, and extractions.
• Developed several reports using Tableau Desktop with rich Visualizations.
• Responsible for Tableau Server administration.
• Currently working on implementing a solution within Cognos notifications schema to get rid of zombie schedules.
• Extensive work installing, configuring, upgrading and patching services on Cognos BI environments in a huge distributed environment.
• Managed multiple Cognos BI, TM1 environments including multiple production environments and several Non-Production Cognos Environments such as Preproduction, Testing, Training, Development and Sandbox.
• Installed and configured TM1 server
• Used Workspace & advance to create dashboards with rich visualizations for material inventory, SLA metrics, Close cycle Cubestats, etc.
• Managed production support BI & DW teams and worked extensively with upstream and downstream teams
• Set up standards and architecture of the meta data layer
• Performance monitoring and tuning of services on BI server platforms
• Responsible for Oracle to Teradata migration, modified several models using Framework Manager, Transformer and impacted Reports.
• Designed Dashboards using calculations, parameters in Tableau.
• Set up the security in Tableau.
• Used various Tableau reporting objects to include facts, attributes, filters, prompts, calculated fields, parameters, drop downs etc.
• Developed rich dashboards that use visualizations, parameters, filters, prompts using Tableau Desktop
• Created row level filters to limit/secure data in Tableau/ Dashboard reports
• Created and scheduled weekly script to back up Tableau during dark window
• Developed scripts to reduce the installation efforts to install Cognos content in a distributed environment.
• Extensive work in delivering Cognos report content on SharePoint
• Created test cases, and worked with several testers to facilitate the testing.
• Extensive experience in setting up and managing multiple environments for application and report development, testing, training and production environments
• Extensive experience in documenting installation steps, environments custom configurations, production system
• Assisted developers with test plans, test conditions and obtaining test data
• Extensive experience in supporting Cognos reports, migrations to different environments
• Consulted with the business community to gather requirements
• Set up Teradata 32 bit and 64 bit ODBC connections on Windows servers for Teradata connectivity
• Extensive work in root-cause-analysis, problem identification and resolution, optimization and performance tuning, security, etc.
• Worked closely with the client to design, implement, and architect an enterprise environment that spans multiple divisions and groups, and integrates data and processes throughout the organization.
• Cognos support and ticket escalation
• Extensive experience in Design and validate Cognos Content before migrating over to production.
• Performance tuning/optimization of the packages
• Designed and developed scorecards, dashboards and multi-dimension data cubes using Cognos
• Developed project plan with the development of project scope, project effort, project time estimates
• Extensive work in Cognos administration from installation to Configuration and troubleshooting with Root cause analysis.
• Extensive experience in Security model knowledge: roles, permissions, groups
• Extensive work on the configuration of the Cognos environments such single server and multiserver components, failover, load balance mechanism including the underlying IIS Web Server and database components such as Audit and Cognos Content Store.
• Provided 24x7 on-call support and draft required documentation for incident responses and service request submissions
• Daily, Weekdays, Weekend, off-hour support to developers with the Cognos framework engineers, as needed, to assist in problem determination of complex issues including assistance in analyzing application performance problems.
• Daily operational support such as problem diagnosis, root cause analysis, troubleshooting, resolving the high priority remedy tickets and documenting the solutions that serves as KB.
• Implemented the environments for both Disaster Recovery and Operational Support Continuity.
• Designed architecture and implemented fail over and load balancing mechanisms on Cognos Application Servers
• Implemented Logical models of Cognos 8 and Cognos 10, row level security, report burst output to file storage, database versus local processing.
• Developed complex reports, ad-hoc reports, drill-through reports, custom java scripts reports as needed.
• Multiple Cognos server builds to include sizing, troubleshooting, tuning, POC & disaster recovery exercises.

Environment: : Actuate9 eRdPro, DB2, Oracle 9i, HTML, JSP, JavaScript.

Confidential

Software Engineer

Responsibilities:

• Established the reporting environment.
• Developed several reports using Actuate eRdPro.
• Implemented Page level security.
• Implemented Single Sign-on.
• Extensively used Multi Input and Memory Data Sorters to limit the number of hits to database.

Environment: Actuate 5.0, Oracle 8I, Windows-NT 4.0, Java

Confidential

Software Engineer

Responsibilities:

• Developed several Reports using Actuate Developer workbench.
• Implemented report bursting.
• Created a high-level web interface for report navigation.

Environment: Actuate 4.0, AS - 400, Windows NT 4.0, HTML, JavaScript.