PROFILE SUMMARY:

• Highly skilled Business Intelligence professional bringing more than 15 years in analysis, design, development, testing, integration, implementation, production support, co - ordination, management, estimation and planning.
• Experienced in full project life cycle from design to implementation.
• Involved in Requirements analysis, Estimation, HLD and DDD preparation.
• Worked on Impact analysis, estimation and Scope of Reports to be re-mediated.
• Came up with Reporting tool upgrade and roll out plan to User machines.
• Implemented tool upgrade in non-production and production environments
• Involved in various testing activities - Unit testing, Regression testing, Smoke Testing and User Acceptance Testing
• Provided post deployment support, bug fix and end user training
• Worked with other external vendors to implement the tool upgrade in user machines.
• Provided co-ordination within the team and with onsite
• Involved in Change and Release management activities and Knowledge transfer sessions.
• Converted spreadsheets to BO reports by getting the data from required sources and transformed as per requirement.
• Implemented the remediated reports in production environment and provided post-production support
• Trained the end users on how to access and schedule these reports.
• Involved in BO admin activities like Adding/removing Users, providing required access to universes and reports, support to unlock accounts etc.
• Provided support to BO report issues, analyzing and fixing the issue.
• Performed some Project Management activities like Project Code creation, merging child codes to Master codes and setting up tasks in timesheets for team members.
• Involved in Requirements analysis, Estimation, HLD and DDD preparation, Design, Build, Test, Review, and Implementation of ETL jobs using Informatica PowerCenter tool.
• Have rich working experience with PowerBI reports, dashboards and datasets.
• Created new ETL mappings, tasks, sessions and workflows.
• Played the role of Quality Anchor of Delivery Unit, responsible to make sure all the Accounts in the DU meet the required Quality Standards and took part in monthly quality audit.
• Involved in preparing detailed Implementation plan and handover documents.
• Implemented solutions in Live and provided post deployment support, bug fix and end user training Liaised with client teams on the UAT and sign offs,
• Ensured all the nightly ETL jobs are completed, recover failed jobs and fix any bugs/issues and coming up with Root Cause Analysis and steps to prevent the issues happening again.
• Led a team of 15-member from offshore, came up with shift ROTA, provided night and week end support.
• Implemented Service Improvement Plans to improve job run time and automated a few manual jobs.
• Implemented small ETL quick wins to improve the stability of the system.
• Performed the role of KM prime and Quality Assurance meetings.
• Analyzed and prepared System appreciation document and system AS-IS architecture.
• Performed coding in .NET for a few modules, unit testing and issue fixes.
• Rich exposure working from multiple US Client locations.

TECHNICAL SKILLS:

BI Reporting: Business Objects, PowerBI, SSRS

ETL: Informatica Power Center

Databases: Oracle, Netezza, DB2, HP Vertica, Snowflake, PostgreSQL, MS SQL Server

Other Tools: BMC Remedy, WinSQL, HP ALM, TOAD

Domains: Retail, Telecom, Energy

PROFESSIONAL EXPERIENCE:

Confidential

Offshore Technology Lead

Responsibilities:

• Create new PowerBI reports and Dashboards for iServer Application.
• Work with Business and come up with Technical requirements and develop reports/dashboards using various visuals following Agile Methodology.
• Perform Unit Testing, support UAT, obtain UAT signoff, deploy reports/dashboards to Production Workspace.
• Set up PowerBI Gateway, schedule dataset to refresh periodically.
• PowerBI Desktop, MS SQL Server
• Credit Risk Liberation Project - Migrating BO and PowerBI reports from Oracle to PostgreSQL

Confidential

Offshore Technology Lead

Responsibilities:

• Involved in End - to-end implementation - Impact Analysis & Assessment, Unit, System and Integration Testing, UAT Support, Implementation and Post Go-Live Support.
• PowerBI - Configured PostgreSQL Data Source, converted Datasets to PostgreSQL equivalent, tested Datasets and Reports, published Datasets to Workspace, set up Gateways and Schedules.
• BO - setting up and repointing connections, validating, and converting BO universe objects, joins, derived tables in IDT and WebI Custom SQL reports, validating report data, migrating objects across env, setting up and testing report schedules/packages based on events.
• Worked on conversion of Oracle specific functions and identified performance bottlenecks, worked with DBAs to improve performance of reports run times
• Business Objects WebI, IDT, Rich Client, PowerBI Desktop, Oracle, PostgreSQL

Confidential

Offshore Technology Lead

Responsibilities:

• Impact analysis, Estimation and Scope of Reports to be re - mediated.
• Usage of Audit report to find out the report usage pattern.
• Migrate Universes and WebI reports to AWS Cloud.
• Remediate WebI reports from Vertica DB to Snowflake DB, re-architecture few reports to overcome non-compatibility issues between Vertica & Snowflake.
• Set up new ODBC connectivity, create new connection in universe for non-prod and prod env and publish to repository.
• Remediate/correct the definition of objects, custom LOV queries, correct the syntax of functions that are different between Vertica and Snowflake in DFX/BLX layers in universes.
• Perform Integrity check and make sure no new issues are introduced.
• Correct custom SQL in WebI query providers and validate the report output.
• Work closely with TCC team to fix the issues raised and get their sign off.
• Co-ordinated the migration activities within the team and with the client teams.
• Review and provide technical assistance to offshore team members.
• Stakeholder and Release management.
• Manage work/deliverables from offshore and daily/weekly status reporting.
• Participate in client and status calls.
• Analyze and fix issues raised during hyper care/post deployment.
• Manage user scheduled instances using instance manager.
• Assist business users to create/fix recurring instances and schedule options.
• Promote objects to different environments by creating BIAR files using LCM tool.
• Come up with detailed plan for BO tool upgrade from BO/Live Office 4.1 to 4.2.
• Plan and communicate BO downtime to Business users.
• Co-ordinate with BO admin team on tool upgrade.
• Liaise with SAP support team and BO Admin to fix any product issue/bug and apply the fix patches.
• Enable SAML authentication in Tableau with OKTA, test and release to production.
• Business Objects WebI, IDT, UDT, Rich Client, CMC, Snowflake, Tableau

Confidential

Technology Lead

Responsibilities:

• Elicit requirements from Business Users.
• Provide estimation and timelines.
• End - to-end delivery: capture business Requirements, Build, Test and Release in 2-week sprints
• Develop DAGs that involve copying files from S3 location, create custom SQL scripts, config files and run DAGs in Airflow
• Deploy codes in different environments.
• Provide support handover and warranty support.
• Worked closely with TCC team and participated in daily scrum calls
• AWS S3, Scripts, Snowflake, Airflow

Confidential

Offshore Technology Lead

Responsibilities:

• Work closely with Business Users and SMEs to capture requirements.
• Analyze and provide estimation and timelines.
• Design/create new WebI reports.
• Exposure to creating reports with multiple data providers, standard/cross tab reports, prompts, query/report filters, sections/breaks, graphs etc.
• Enhance/modify/fix existing universe/ WebI reports based on Jira requests.
• Add new tables/columns, perform Refresh structure, define new joins and context, use Derived tables when required in DFX layer.
• Define new BLX objects, modify existing ones, validate objects and publish changes to repository.
• Perform design review, unit and regression testing.
• Promote objects to different environments using LCM tool.
• Liaise with business users during UAT phase.
• Manage work/deliverables from offshore.
• Release management.
• Assign and close tickets that require code change within SLAs both individually and as a team.
• Offshore/onsite co - ordination
• Business Objects WebI, IDT, UDT, Rich Client, CMC, Vertica, ServiceNow

Confidential

Technology Lead

Responsibilities:

• Analyze current excel reports
• Create System Appreciation Document
• Come up with Estimation, HLD and DDD
• Design Review
• Offshore/onsite co - ordination
• Excel, SSRS, Oracle