PROFESSIONAL SUMMARY:

• 12+ years of experience in DW - BI tools like Informatica (8.x, 9.x & 10.x) and Cognos BI (7.x, 8.x, 10.x and Cognos Analytics), and SAP BO along with core BI administration and Experience MS Azure with Azure Data Factory, Azure SQL, Spark SQSL, ADLS, BLOB storage with Power BI analytics.
• Expertise in setting up Azure Cloud platform setup with PaaS & IaaS along with Azure security policies and Monitoring setup using Log analytics.
• Expertise in Big data Administration on Azure and Hadoop platform, HDFS along with Pig, hive, Oozie and zookeeper tools in Apache platforms.
• Expertise in Informatica Data Archive with Data Vault setup, Informatica Secure At Source with Informatica test data management suite with policy setup and Data Masking.
• Exposure to Power BI with MS Azure & Tibco Spotfire analytics.
• Certified RPA practitioner with process automation design & roadmap.
• Extensive experience in Informatica GRID architecture design, environment setup, performance-tuning, upgrade.
• Worked multiple Informatica upgrades and handled end of end Informatica upgrade life cycle including resolving upgrade issues, and troubleshooting.
• Implemented end-to-end Cognos upgrade life cycle and published multiple white papers for IBM.
• Expertise in Hadoop environment setup with single node cluster and multimode cluster environment including high availability.
• Extensive experience in Informatica data quality platform setup and real-time web service implementation.
• Worked as part of COE for Informatica data platforms and MDM platforms to implement best practices across enterprise.
• Expertise in MSBI (SSRS, SSIS & SSAS) development and Administration. Worked on multiple MSBI upgrade projects right from MSBI v & MSBI v .
• Exposure to Informatica MDM upgrade and platform maintenance.
• Expertise in Statistica enterprise environment setup including Batch & live score engine (Real-time).
• Extensive knowledge on SAP Power Designer setup and configuration for enterprise data modeling.
• Expertise in Informatica Data Archive & Data Vault tools, setup, configurations, and troubleshooting.
• Worked on setting data governance tools like Informatica TDM and Secure at Source.
• Proficiency in Maintenance & Production Support models and Engineering models.
• Proficient in Oracle, SQL Server (2005, 2008) and SAP BO.
• Familiar with UNIX basic level shell scripting and exposure to Z-Os environments.
• Excellent analytical and logical programming skills with a good understanding at the conceptual level.
• Proactive Self Learning ability and can be quick to cope up with new technologies as required.
• I work to build a strong relationship with customer and work towards gaining a 100% confidence towards my work.
• Extensive experience in working with multiple clients globally in Europe and US regions across different domains.
• Practical Knowledge on complete SDLC (Software Development Life Cycle) and Agile Methodology.
• Trained in Scrum Master for BI Implementation projects.
• Have ample domain knowledge in Manufacturing, Energy, Retail and Human Capital Management.
• Proactive in handling the NEW techniques and new features in BI applications.
• Flexible to work on any BI application.
• Worked in BI disaster recovery team and BI COE for BI applications like Cognos, Informatica, MSBI and SAP BO.
• Exposure working on “Robotic Process Automation” to automate daily operations with chat bots.
• Mid-level expertise in writing batch scripts and Power shell scripting for automation processes.
• Expertise on Agile methodologies and worked as Scrum Master for multiple projects.

TECHNICAL SKILLS:

Primary Skills: Azure Solutions Architect, Azure Data Factory, Azure SQL, Spark SQL, ADLS & Blob storage, Proficiency in Azure cost analysis and Cost control optimization Informatica PC, Data Quality, MDM & Address doctor (DaaS) & Cognos BI & Hadoop enterprise environment setup and Administration.

Secondary skills1: MSBI Admin, BI Infrastructure & Solution Designing

Secondary skills 2: Oracle PL/SQL, SQL Server and SAP BO.

Unix and Z: Os command line exposure.

Domain Skills: Manufacturing, Sales, Energy, Retail, Banking & Insurance, Health.

WORK EXPERIENCE:

Confidential

Cloud Solutions Architect (Azure)

Tools:

• Datastage
• Cognos Analytics
• Power BI
• MS Azure Cloud
• Azure Data Factory
• Azure Log Analytics & Monitoring
• Azure SQL & Spark SQL.
• Azure DFT in ADF.

Responsibilities:

• Working with client Architect to design enterprise level platform setup, capacity planning.
• Installation and configuration of Informatica, Cognos and HDInsight domains.
• Working with multiple development teams to implement best practices as a COE lead for data platforms.
• Participate in business requirements for EDW team to assess platform impact for upcoming new processes into Informatica platforms.
• Deployments, Server procurements and Informatica issues RCA.
• Promoting Informatica Objects across different environments using different deployment techniques.
• Automation lead to implement automated solutions for daily operations to reduce manual errors and efforts.
• Informatica code deployment.
• Using deployment wizards
• Export and import of objects using XML
• Copy and Paste from one environment to other.
• Debugging the deployment and connectivity issues.
• Scheduling and monitoring the regular repository and domain backups.
• Creating users, user groups, folders and connections.
• Creating Informatica connections and assigning permissions to users/groups.
• Informatics user security, workflow monitoring and start/abort workflows upon user request. And Informatica services recycle process when required.
• Server capacity planning and Cognos infrastructure designing by considering all parameters and with proper forecasting.
• Installing and Configuring Cognos Components (Gateways, Dispatchers and CM).
• Creating jobs and schedule Maintenance.
• Cognos Server (Weekly twice) Maintenance and monitoring.
• Informatica weekly Maintenance and monitoring.
• Creating Data Sources in Cognos and connections in Informatica upon user requests.
• Package Creation and publishing in Cognos.
• Responsible to Root Cause Analysis of the issues in Cognos servers and Cognos environment to fix them.
• Cognos content deployments and Migrations in case of new releases.
• To develop various types of reports using Report studio, query studio and workspace dashboards.
• Exposure to Cognos Framework Manager, Transformer and Life cycle manager.
• Developed multiple reports using Report Studio and Query Studio
• Expertise in Cognos Dynamics Query Mode architecture and working.
• Expertise in resolving Cognos root level issues and thorough knowledge on Cognos product and its relevant tools.
• Cognos Performance tuning and troubleshooting issues.

BI Administration and Infrastructure Design

Confidential

Tools: Informatica Powercenter 9.5, informatica DVO Cognos 8.x and Cognos 10.x.

Responsibilities:

• Installations, Deployments, Server procurements and Informatica issues RCA.
• Promoting Informatica Objects across different environments using different deployment techniques.
• Using deployment wizards
• Export and import of objects using XML
• Copy and Paste from one environment to other.
• Debugging the deployment and connectivity issues.
• Scheduling and monitoring the regular repository and domain backups.
• Creating users, user groups, folders and connections.
• Creating Informatica connections and assigning permissions to users/groups.
• Informatics user security, workflow monitoring and start/abort workflows upon user request. And Informatica services recycle process when required.
• Server capacity planning and Cognos infrastructure designing by considering all parameters and with proper forecasting.
• Installing and Configuring Cognos Components (Gateways, Dispatchers and CM).
• Creating jobs and schedule Maintenance.
• Cognos Server (Weekly twice) Maintenance and monitoring.
• Informatica weekly Maintenance and monitoring.
• Creating Data Sources in Cognos and connections in Informatica upon user requests.
• Package Creation and publishing in Cognos.
• Responsible to Root Cause Analysis of the issues in Cognos servers and Cognos environment to fix them.
• Cognos content deployments and Migrations in case of new releases.
• To develop various types of reports using Report studio, query studio and workspace dashboards.
• Exposure to Cognos Framework Manager, Transformer and Life cycle manager.
• Developed multiple reports using Report Studio and Query Studio
• Expertise in Cognos Dynamics Query Mode architecture and working.
• Expertise in resolving Cognos root level issues and thorough knowledge on Cognos product and its relevant tools.
• Cognos Performance tuning and troubleshooting issues.

Confidential

BI Technical Consultant - Technical Lead

Tools: Informatica Power center 9.5, Cognos 8.x and Cognos 10.x.

Responsibilities:

• Installation and configuring Informatica environment.
• Promoting Informatica Objects across different environments using different deployment techniques.
• Using deployment wizards
• Export and import of objects using XML
• Copy and Paste from one environment to other.
• Creating users, user groups, folders and connections.
• Creating Informatica connections and assigning permissions to users/groups.
• Informatics user security, workflow monitoring and start/abort workflows upon user request. And Informatica services recycle process when required.
• Responsible to lead Cognos BI team to reach committed SLAs for the tickets.
• Installation and configuration of Cognos environment.
• Content Migrations from one environment to another environment.
• Patch/Fix pack updates and Server Configurations.
• Single server/Multiple server installations and configurations along with third party securities based on the client needs. Examples: SSO, iBSDNet etc.
• Worked on Most Innovative American NER dashboard.
• Daily interactions with Business Development team and weekly interactions with Client manger
• If any issues with the servers, need to conference the Business Mangers, bring down the servers and FIX the solution ASAP
• Regular Interactions with IBM and Oracle Support.
• Creating Data Source.
• Package Creation and publishing.
• Responsible to Root Cause Analysis of the issues in Cognos servers and Cognos environment to fix them.
• Creating users and user groups.
• Creating Informatica connections and assigning permissions to users/groups.
• To in corporate new service improvement plans to drive team to provide better service.
• Deployment Packages and reports from Dev to Production.
• To develop various types of reports using Report studio.
• Handles user Adhoc queries for reports by using Query studio.
• Exposure to Cognos Framework Manager
• Developed multiple reports using Report Studio and Query Studio

Confidential

BI Application Designer

Tools: Informatica 8.5, Cognos 7.x, Cognos 8.x and Cognos 10.x.

Responsibilities:

• Responsible to lead Cognos BI team to reach committed SLAs for the tickets.
• Installing and Configuring Cognos Components (Gateways, Dispatchers and CM).
• Informatica user security and deployments.
• Informatica workflow monitoring and management.
• Creating jobs and schedule Maintenance.
• Cognos Server (Weekly twice) Maintenance and monitoring.
• Creating Cognos Data Source.
• Package Creation and publishing.
• Assigning Access and permissions in SAP BO, Cognos and Informatica.
• To maintain data warehouse without issues and make the data available for reporting through Cognos reporting.
• Development is part of enhancements and new project. Sometimes involves in report development and warehouse implementations
• Responsible to Root Cause Analysis of the issues in both data and Cognos reports and to fix them.
• To in corporate new service improvement plans to drive team to provide better service.
• Deployment Packages and reports from Dev to Production.
• To develop various types of reports using Report studio.
• Handles user Adhoc queries for reports by using Query studio.
• Played my role as a team member and as a team lead as I was the single point of contact with client for all technical and functional assistance.

Confidential

BI Developer - Sr. Software Engineer

Tools: Informatica 8.5Cognos 7.x, Cognos 8.x and SAP BO.

Responsibilities:

• Load all sales data and make it available for reporting.
• Monitor the Jobs which load all the sales data in DWH.
• Start/abort workflows.
• Fix any errors with data or with Sql scripts.
• Implement new oracle scripts whenever new projects merge into DWH.
• Create new reports using SAP BO Webi and crystal reports.
• Responsible for Cognos server administration along with User administration.
• SAP BO administration along with user creation and security.
• To create new reports in Cognos 7.4 environments.
• Cognos administration like managing users, Cognos servers, upfront reports and report development in Impromptu in Cognos
• Explain User queries on technical and functional levels in project.
• Root Cause Analysis whenever there are issues with reports or at DWH level with database.
• To manage activities from Off shore to reach SLAs of different priority levels tickets.
• Implementation of new projects and Migration of different small DWH into single DWH repository for Centralized reporting of all kind of data.
• Application level KT and technical KT within team every week on new topic.
• Creating jobs and schedule Maintenance.
• Cognos Server monitoring.
• Access and permissions.
• Worked as an off shore lead for BI team and managed all the support activities from off shore when onsite team was completely part of enhancements.