SUMMARY

• 13 years of extensive domain experience in Banking, Financial, Healthcare and Insurance in diversified fields of Application Software Development, Testing and Maintenance of BIDW (Data Lake) related applications.
• I have extensive knowledge on Data warehousing concepts and hands on ETL tools (Informatica Power Center, Talend and SSIS). Designed and developed ETL logics using Informatica Designer tools such as Source Analyzer, Transformation Developer, Mapping Designer and Warehouse Designer.
• I have extensive knowledge on various databases (Green plum, Teradata, DB2, SQL Server and Oracle). Worked extensively on analysis, design and development/ Trouble shooting of Stored Procedures and Functions.
• Strong Experience in Development and Testing of various BI Analytics and reporting tools likeTABLEAU,SPOTFIRE, POWER BI,Crystal Reports (XI),BO, Cognos (10) and developed many dashboards /worksheets and various complex reports. Very strong in data visualization and dashboard building using guided analytics.
• Developed multi tab reports and dashboards using Tableau, Spotfire and Power BI. Optimized the report queries and run times to provide near real - time views of data.
• Performed event and time based scheduling of Spotfire/Tableau Reports and Dashboards.
• Performed Administrative tasks for Spotfire/Tableau like Installing and upgrading server, server monitoring, scheduling dashboards, troubleshooting the Spotfire reports/data files for performanceand Administrating Users and groups for managing security.
• Worked extensively on defect tracking management tools like JIRA, ALM (HPQC).
• Extensive experience in acting as a liaison between client and IT department to relate expectations, oversee progress, and resolve conflicts. Adept at reducing development costs and providing traceability of projects.

TECHNICAL SKILLS

Analytical tools: Tableau, Spotfire, and PowerBI

BI Reporting Tools: Crystal Reports, BO and Cognos.

Data Virtualization tools: Denode

ETL: Informatica Power Center and IDQ (9.x)), SSIS and Talend (5.6.x)

Databases: Green plum, TERADATA, ORACLE, DB2 and MS SQL SERVER

Database utilities: Aginity workbench, PgAdmin Client, TOAD, SQL Developer and Teradata SQL Assistant

Tools: & Utilities: Approx., WinSCP, Putty, Visual Interdev, CLEAR CASE, VSS, RMS, VMWARE

Languages: PL/SQL, JAVA, Unix scripting

Application Maintenance and Development: Microsoft Technologies (VB, ASP, ASP.net and COM), Java

Server Admin: Tableau, TAC, Crystal Reports, BO, Web Sphere and, IIS

Big Data: Hadoop (HDFS System)

Languages and Scripting: PL/SQL, Unix shell

Project and Defect Management tools: SERVICENOW, JIRA, ALM(HPQC)

Web Related: HTML, JavaScript, XML, ASP (3.0), IIS (5.0), Web sphere (7.0.0.X)

Domain Knowledge: Health Care, Insurance, Aviation, Finance and Banking

Operating Systems: Windows 7/NT/ 2000/XP and Linux

PROFESSIONAL EXPERIENCE

Confidential

BI Lead/Analyst

Responsibilities:

• Interacting with business users to get accurate and detailed requirements and specifications for the deliverables. Understand business requirement documents for the new source systems/regions
• Created technical specifications document as well as functional documents in support of the user requirements.
• Design Architecture for Treasury Data Lake (Predix/Green plum Environment) and development of Green plum scripts, Informatica workflows, Denodo jobs and Spotfire dashboard to streamline the process platform for strategic and operational BI reporting &Analytics.
• Responsible for end to end implementation/Administration/maintenance and development of Informatica workflows, Denodo Jobs and Spotfire dashboards manage the requirement gathering process from enterprise analysis to requirement sign off.
• Coordination with the offshore team during design/development/testing and resolving queries from offshore team. Providing technical and functional assistance to the offshore team.
• Responsible for technical solutions to support and streamline data reporting/visualizations requests requiring integration of data from multiple systems and testing/validations of analytics reports(spotfire).
• Ensuring timely defect resolution by debugging and troubleshooting data verifications with source systems at onsite.
• Creating standards SOP’s and templates & Review all the documentations and reports developed by offshore team.
• Integrated data from various data sources and developed ad-hoc Spotfire dashboards, Information links, In-memory and On-demand reports.
• Performed event and time based scheduling of Spotfire Reports and Dashboards and Shared and follow the best practices in the areas of reporting, modeling and dashboards.

Confidential

BI Lead(Analyst)

Responsibilities:

• Interacting with business users to get accurate and detailed requirements and specifications for the deliverables. Understand business requirement documents for the new source systems/regions
• Created technical specifications document as well as functional documents in support of the user requirements.
• Developed various mappings using informatica power center and IDQ tools. Used various IDQ transformations like Address validator, parser, joiner, filter, labeler, case, merger and Exception for data quality.
• Involved in migration of the mappings from IDQ to power center and applied the rules and profiled the source and target table's data using IDQ.
• Created SSIS packages to load data into staging table and data mart and also Performed logging in SSIS packages to capture error data and for error handling.
• Monitored user queries and stored procedures by database tracing using SQL Server profiler.
• Development of Green plum database scripts/objects for B2P Data Lake and streamline the integration process (Ensuring adherence to programming standards and best practices).
• Responsible for technical solutions to support and streamline data reporting/visualizations requests requiring integration of data from multiple systems and testing/validations of analytics reports(spotfire).
• Integrated data from various data sources and developed ad-hoc Spotfire dashboards, Information links, In-memory and On-demand reports.
• Scheduled reports for delivery through email in various formats and maintenance Spotfire Server, Web Player, Users and Groups authentication and Library administration.
• Performed event and time based scheduling of Spotfire Reports and Dashboards and Shared and follow the best practices in the areas of reporting, modeling and dashboards.
• Performed unit, integration, system testing and all required quality control activities and responsible for analyzing and trouble-shooting technical issues related to reporting.
• Tracked the incidents/defects using Confidential -Service now and JIRA tools.
• Provided support during user acceptance testing (UAT). Tracking all the issues during acceptance testing and coordinating with the offshore team to get those resolved.
• Ensured timely defect resolution by debugging and troubleshooting data verifications with source systems at onsite.
• Coordinated with the offshore team during design/development/testing and resolving queries from offshore team. Provided technical and functional assistance to the offshore team.
• Status reporting and attending status calls / meetings and creating standards and templates. Reviewing all the documentations and reports developed by offshore team.

Confidential

BI Lead(Analyst)

Responsibilities:

• Analyze real-time, historical pipeline, operational and integrity data.
• Helps customers make better/faster decisions and improve reliability of locomotives.
• Provide the real time analytical capability for predicting road failures and new business insights
• Reducing service cost and frequency of repeated failure
• Data ingestion using HVR and Talend tools, Data Storage using Green plum, Data Consumption and Visualization using Tableau and integrates with custom UI (Angular JS and SOLR).
• Understand the full scope of functions and requirements that are required to be developed under the project. Review the requirements and get it signed off from business owners, data engineers, IT managers and other stakeholders. Data analysis and data management and information dissemination activities.
• Responsible for end to end implementation/Administration/maintenance, development and testing of Tableau reports and dashboards manage the requirement gathering process from enterprise analysis to requirement sign off.
• Experience in working with Tableau server to create data sources, creating users and Tableau installation and providing training to Business users in using Tableau.
• Responsible for technical solutions to support and streamline data reporting/visualizations requests requiring integration of data from multiple systems and testing/validations of analytics reports (Tableau/Spotfire).
• Performed unit, integration, system testing and all required quality control activities and responsible for analyzing and trouble-shooting technical issues related to reporting.
• Tracked the incidents/defects using Confidential -Service now, JIRA and HPQC Tools.
• Provided support during user acceptance testing (UAT). Tracking all the issues during acceptance testing and coordinating with the offshore team to get these resolved.
• Ensured timely defect resolution by debugging and troubleshooting data verifications with source systems at onsite.
• Coordinated with the offshore team during design/development/testing and resolving queries from offshore team. Provided technical and functional assistance to the offshore team.
• Managed the project thorough planning, design, maintenance, control, change management, estimation and scope control.
• Identified and implemented various processes and solutions that would lead to a lean business process.
• Coordinated and facilitated integration design, testing and implementation tasks, manage expectations and partner with (and not limited to) core Digital data lake project team, business users, stakeholders, and other Data lake applications and technology teams.
• Have got excellent feedback from the customer for my performance in this project deliverables.
• Understand the full scope of functions and requirements that are required to be developed under the project. Review the requirements and get it signed off from business owners, IT managers and other stakeholders.
• Developed various mappings using informatica power center and IDQ tools. Used various IDQ transformations like Address validator, parser, joiner, filter, labeler, case, merger and Exception for data quality.
• Involved in migration of the mappings from IDQ to power center and applied the rules and profiled the source and target table's data using IDQ.
• Responsible for technical solutions to support and streamline data reporting/visualizations requests requiring integration of data from multiple systems and testing/validations of analytics reports (Spotfire/Tableau).
• Responsible for end to end implementation/Administration/maintenance, development and testing of Spotfire/Tableau reports and dashboards manage the requirement gathering process from enterprise analysis to requirement sign off.
• Integrated data from various data sources and developed ad-hoc Spotfire dashboards, Information links, In-memory and On-demand reports.
• Scheduled reports for delivery through email in various formats and maintenance Spotfire Server, Web Player, Users and Groups authentication and Library administration.
• Responsible for tool evaluation for Data Integration and Data Visualization and Building Sales, Marketing and Finance reports and dashboards.
• Experience in working with Tableau server to create data sources, creating users and Tableau installation and providing training to Business users in using Tableau.
• Responsible for writing SQL queries to pull data from sources and maintaining weekly/monthly/ quarterly metrics for topics/projects.
• Responsible for technical solutions to support and streamline data reporting requests requiring integration of data from multiple systems.
• Responsible for creating Tableau models, architectures, frameworks and strategies based on business requirements.
• Responsible for technical solutions to support and streamline data reporting requests requiring integration of data from multiple systems.
• Responsible for Analyzing and trouble-shooting technical issues related to reporting.
• Set up processes to interact with inbound and downstream systems to receive and send data.
• Managed the project thorough planning, design, maintenance, control, change management, estimation and scope control.
• Performed unit, integration, system testing and all required quality control activities and responsible for analyzing and trouble-shooting technical issues related to reporting.
• Provided support during user acceptance testing (UAT). Tracking all the issues during acceptance testing and coordinating with the offshore team to get these resolved.
• Tracked the incidents/defects using SYF-Service now, JIRA and HPQC Tools.
• Ensured timely defect resolution by debugging and troubleshooting data verifications with source systems at onsite.
• Coordinated with the offshore team during design/development/testing and resolving queries from offshore team. Providing technical and functional assistance to the offshore team.
• Coordinated and facilitated in design, testing and implementation tasks, manage expectations and partner with (and not limited to) core RFIH project team, business users, stakeholders, and other RFIH applications and technology teams.
• Responsible for tracking the status of work requests and overall project monitoring. Status reporting to applications manager/System Experts.
• Have got excellent feedback from the customer for my performance in this project deliverables.
• Performed requirement analysis of large-scale business systems and translated requirements into Statement of Work, Business Requirement Documents, Use Cases, Functional Specifications, Project Proposals, Testing and Post Implementation Plans.
• Developed various mappings using informatica power center and IDQ tools. Used various IDQ transformations like Address validator, parser, joiner, filter, labeler, case, merger and Exception for data quality.
• Created SSIS packages to Extract, Transformation and Load ETL user data and other data from OLTP to OLAP.Performed SQL tuning and improve the speed of query running.
• Involved in migration of the mappings from IDQ to power center and applied the rules and profiled the source and target table's data using IDQ.
• Responsible for implementing PowerBI/Tableau in distributed environments across organization.
• Integrated data from various data sources and developed ad-hoc POWER BI/Spotfire dashboards, Information links, In-memory and On-demand reports.
• Scheduled reports for delivery through email in various formats and maintenance Spotfire Server, Web Player, Users and Groups authentication and Library administration.
• Responsible for development of Reports and Dashboards using Spotfire/Tableau and Experience in creating Dashboards using Table calculations, Logical calculations, number calculations and creating parameters. Experience in creating Different maps, dual axis charts.
• Maintained weekly/monthly/quarterly metrics for various airline customers using Tableau/Spotfire and Provides meaningful analysis based on available data.
• Presented the analysis to internal and external teams and explain data from a business perspective and relevance to Key Performance Indicators (KPI).
• Executed detailed functional decomposition analysis to redesign the existing process flows for increased efficiency and utility.
• Developed and reviewed of High level design and Low level detailed design documents.
• Resolved the TD, SQL Server database issues about the Data loads, Mappings, Workflows.
• Fixed FCS Production issues using Confidential ’s service now tracking tools.
• Worked in Tableau Desktop & Server and developed various dashboards and fixed the data issues. Created data extracts and schedules, Projects and workbooks, Users and Groups and provided training to Business users.
• Performed unit, integration, system testing and all required quality control activities and responsible for analyzing and trouble-shooting technical issues related to reporting.
• Tracked the incidents/defects using Confidential -Service now and HPQC tools.
• Provided support during user acceptance testing (UAT). Tracked all the issues during acceptance testing and coordinating with the offshore team to get these resolved.
• Involved in Scripts migration, Implementation, Preparation of Productions stats and, Business Process documents.
• Involved FCS - Production stabilization activities like Performance tuning, Adhoc load requests and Unix Jobs monitoring (Sftp).
• Adhered to Quality norms of Confidential Aviation.
• Have got excellent feedback from the client for my performance in FCS project deliverables.
• Import Letters of Credit
• Purchase Order Processing
• Automated Opening Account Processing
• Standby Letters of Credit / Letters of Guarantee
• Export Letters of Credit
• Transfer LC's
• Letters of Direction
• Direct Collections
• Understanding the source systems, dependency between other source systems and business rules and Convert same logics to build mappings using Informatica Power Center(9.1)
• Resolved the DB2, SQL Server database issues about the Data loads, Mappings, Workflows.
• Worked with Tableau Desktop & Server and developed various dashboards and fixed the data issues.
• Responsible for writing SQL queries to pull data from sources and Maintaining weekly/monthly/quarterly/yearly metrics for topics/projects.
• Responsible for technical solutions to support and streamline data reporting requests requiring integration of data from multiple systems.
• Responsible for creating Tableau models, architectures, frameworks and strategies based on business requirements.
• Responsible for technical solutions to support and streamline data reporting requests requiring integration of data from multiple systems.
• Worked in Tableau Desktop & Server and developed various dashboards and fixed the data issues. Created data extracts and schedules, Projects and workbooks, Users and Groups and provided training to Business users.
• Performed unit, integration, system testing and all required quality control activities and responsible for analyzing and trouble-shooting technical issues related to reporting.
• Provided support during user acceptance testing (UAT). Tracking all the issues during acceptance testing and coordinating with the offshore team to get these resolved.
• Fixed EP Product environment issues in IST, QAT and PROD.
• Tracked the defects using JIRA and HPQC Tools.
• Involved in code promotion and packing using Clear case and VSS tools.
• Involved in TEE to EP customer conversion and supported to build the TEE and EP system with latest code received from the third party vendor.
• Adhered to Bank of Nova Confidential - quality norms.
• Have got excellent feedback from the client for my performance both at onsite and offshore.
• Analyzed the source systems, dependency between other source systems and business rules.
• Analyzed the specifications provided by the clients, all procedures and functions are used in this and converted business logic into transformation mappings.
• Resolved the issues about the Data loads, Mappings, Workflows.
• Responsible for overseeing the Quality procedures related to the project.
• Documented required for Six Sigma quality requirements and status reporting.
• Played an active role in production support.
• Supported for all project consulting teams and involved in POCs.
• Reviewed the documents, webinars and POCs prepared by informatica competency team.
• Provided technology and knowledge sharing documents on new features about the informatica to requested teams.
• Responsible for Informatica version upgrades in Informatica competency server.
• Credit Application
• Bid Application
• Risk Participation by Seller
• Risk Participation by Buyer
• Status changes
• Analyzed the source systems, dependency between other source systems and business rules.
• Developed the TLE Reports and Fixed the Reports Bugs.
• Configured the Crystal XI Server side management and deployed reports in IST and QAT Environments.
• Performed unit, integration, system testing and all required quality control activities and responsible for analyzing and trouble-shooting technical issues related to reporting.
• Provided support during user acceptance testing (UAT). Tracking all the issues during acceptance testing and coordinating with the offshore team to get these resolved.
• Fixed EP Product environment issues in IST, QAT and PROD.
• Tracked the defects using JIRA and HPQC Tools.
• Involved in data migration of Encrypted and decrypted versions of ITL database in different environments.
• Responsible for set up project environment with latest builds (version) and completed knowledge transfer.
• Have taken up challenges of removing DB Encrypt from SQL Server 2000, stabilizing it and then improved the TLE application performance substantial.
• Application carries Customer, Print, Trailers, Rates, Coverage, Results and Quote Side By Side Screens.
• Address Standardization provides functionality of validating the Addresses.
• Quote Side By Side Feature allows comparing multiple quotes.
• Analyzed the source systems, dependency between other source systems and business rules.
• Developed the ACRQ(ver 6.0) code for the new states (NJ,ON,AB,NB) and prepared the case
• Performed unit, integration, system testing and all required quality control activities and responsible for analyzing and trouble-shooting technical issues related to reporting.
• Provided support during user acceptance testing (UAT). Tracking all the issues during acceptance testing and coordinating with the offshore team to get these resolved.
• Documented all Six Sigma quality requirements and status reporting.
• Responsible for set up project environment with latest builds (version) and completed knowledge transfer.
• Rewarded Satyam -POB for excellence efforts in the project.
• Have got excellent feedback from the client for my performance in ACRQ project deliverables.
• Analyzed the source systems, dependency between other source systems and business rules.
• Played an active role in product support and fixed the production issues.
• Performed unit, integration, system testing and all required quality control activities and responsible for analyzing and trouble-shooting technical issues related to reporting.
• Provided support during user acceptance testing (UAT). Tracking all the issues during acceptance testing and coordinating with the offshore team to get these resolved.
• Generated various reports as per client requests
• Responsible for overseeing the Quality procedures related to the project.
• Understanding the source systems, dependency between other source systems and business rules. Analysis of the specifications provided by the clients.
• Played an active role in product support and Uploading of databases.
• Generated various reports as per client requests.
• Provided comprehensive support for Client
• Documentation required for Six Sigma quality requirements and status reporting.
• Understanding the source systems, dependency between other source systems and business rules.
• Performance tuning of SQL queries and mappings to minimize the load time and meet the load time SLA.
• Prepared User manuals of various modules of Lifeline V2 Product.
• Developed Reports using Crystal Reports (9) tool
• Performed unit, integration, system testing and all required quality control activities and responsible for analyzing and trouble-shooting technical issues related to reporting.
• Provided support during user acceptance testing (UAT). Tracking all the issues during acceptance testing and coordinating with the offshore team to get these resolved.
• Documentation required for Six Sigma quality requirements and status reporting.
• Environment set up in the project with the new version and completed knowledge transfer.
• Provided comprehensive support for Client as well as various Onsite Teams.