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.
• 5 +years Onsite (US and Canada) experience in Confidential ’s Data Lake Projects (Using big data technologies (Green plum, Talend and Spotfire/Tableau) and Canada’s largest bank (Scotia’s bank) - Trade Finance Application Development, Functional Testing, Production Implementation and Maintenance of Trade Finance business domain.
• 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 mgmt 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.
• Data visualizations, Process mapping, Data modeling, Data Quality, Change management (Service now), requirement gathering and data analysis, documentation, project management of software Development and Implementation, Quality Assurance Testing, Business case preparation, provide user training, Migration Cut over plans, reports development, testing and troubleshooting.
• Ability to quickly master new concepts/applications & identify operational deficiencies and system improvements. Strongly self-motivated, willing to assume responsibilities & very detail oriented. Excellent at communication, analysis & presentation.
• I have extensively worked in Confidential Projects ( Confidential - Retail Finance, Confidential -Aviation, Confidential - Energy and Confidential - Money) and well versed with Confidential ITIL Tools (Service now, Support Central and Document Management (One box drive) and Libraries portals).
• I have well versed with version mgmt tools like VSS/CLEARCASE and well conversant with Tech Mahindra’s ISO 9001 quality procedures, while executing his projects.
• I have received many customers applauds for hishighly dedicated and efficient execution of projects and high standards of deliverables with direct exposure to the Customers.
• Good team player and can work individually when required to do so independently.

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,PgAdminClient, TOAD, SQL Developer and Teradata SQL Assistant

Tools & Utilities: Appwrox, 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

Environment:

Software:

Platform:

Big data:

• ETL: Informatica Power Center (10.x)
• Database: Green Plum, Oracle,SQL SERVER
• Analytics Tools: Spotfire
• Data Virtualization tool: Denodo
• Other Tools:Appwrox,Servicenow,JIRA(Rally), ALM(HPQC) and PgAdminIII
• S/w Methodologies: Agile
• O/S: Windows and Linux, Shell Scripting

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)

Environment:

Software:

Platform:

Big data:

• ETL: Talend, Informatica Power Center and SSIS
• Database: Green Plum,Oracle,SQLSERVER
• Analytics Tools: Spotfire,Tableau and PowerBI
• Other Tools:Servicenow,JIRA(Rally), ALM(HPQC) and PgAdminIII
• S/w Methodologies: Agile
• O/S: Windows and Linux, Shell Scripting

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)

Environment:

Software:

Platform:

Big data:

• ETL: Talend,SSIS
• Database: Green Plum
• Server Admin: Tableau
• Analytics Tools: Spotfire, Tableau and R
• UI Tools: Angular JS with Solr
• Other Tools: PgAdmin,Service now, JIRA, ALM(HPQC), Rally
• S/w Methodologies: Agile
• O/S: Windows and Linux, Shell Scripting

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.
• Maintenance of more than 1000 user’s permissions under different group to the project/workbooks/views in both environments.
• Successfully migrated the 9.1 version dashboards into 9.3.6 version
• Scheduling and publishing the large volume of data sources (GPDB).
• Proactively monitoring the stats at server level about the traffic to views, data sources, view load times, space usage of dashboards and user’s actions.
• Deployment of the complex dashboards into production using GitHub tool for tracking the dashboard versions
• Maintenance of more than 20 project folders and 50 workbooks, which contains more than 300 views.
• Weekly monitoring the performance of the complex dashboards in both desktop and server level.
• Create and Maintenance of the data source extract schedules and subscriptions (send user notification about the status of the dashboards).
• Developed and maintenance of LDAP synchronization script which runs daily 5:00AM to add /remove the users to Tableau as per Distribution list (There is no manual intervention to add the users to Tableau).
• 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.

BI Lead(Analyst)

Confidential

Environment:

Software:

Platform:

• ETL: Informatica Power Center and IDQ (9.x)
• Database: Oracle 11.g
• Analytics Tools: Tableau, Spotfire, Power BI,SASVA
• Reporting Tools: BO
• Testing tools: ALM (HPQC) and JIRA
• O/S: Windows and Linux, Shell Scripting

Responsibilities:

• 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.

Confidential

Sr. System Analyst (Onsite and Offshore)

Environment:

Software:

Platform:

• ETL: Informatica Power Center (9.x),SSIS.
• Database: Teradata (13), SQLSERVER2008
• Reporting Tools: Tableau, Spotfire, PowerBI, HPQC
• O/S: Windows and Linux, Shell Scripting

Responsibilities:

• 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 Confidential 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 Confidential - Production stabilization activities like Performance tuning, Adhoc load requests and Unix Jobs monitoring (Sftp).
• Adhered to Quality norms of Confidential .
• Have got excellent feedback from the client for my performance in Confidential project deliverables.

Confidential

Sr. System Analyst

Environment:

Software:

Platform:

• ETL: Informatica (8.6.1)
• Languages: Java, JavaScript, XML.
• Database: DB2 (9.x), IMS DB, SQLSERVER2000
• Tools:BO, Tableau, BIRT, Clear case, VSS, JIRA, HPQC Web sphere (7.0.0.X)
• O/S: Windows XP/2000 and AIX
• Connectivity: VPN

Responsibilities:

• 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 Scotia - quality norms.
• Have got excellent feedback from the client for my performance both at onsite and offshore.

Confidential

System Analyst

Environment:

Database: Oracle 10g

Tools: Informatica (8.6.1),Toad(7.6.0.11),HPSD(4.5)

O/S: Windows XP/2000,Unix

Responsibilities:

• 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.

Confidential

Project Lead for Informatica Competency

Environment:

Database: Oracle 10g

Tools: Informatica (8.1.0)

O/S: Windows XP/2000

Responsibilities:

• 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.

Confidential

Module Lead at Onsite

Environment:

Languages: HTML, JavaScript, ASP, XML, COM.

Database: SQL Server 2000

Tools: Crystal Reports XI

O/S: Windows XP/2000

Responsibilities:

• 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.

Confidential

Team Lead (Systems Analyst)

Environment:

EA-Framework

Languages: HTML, JavaScript, ASP, XML, COM.

Tools: Visual Interdev, RMS(Source safe Tool)

Database: DB2 -Mainframes

O/s: Windows XP

Responsibilities:

• Analyzed the source systems, dependency between other source systems and business rules.
• Developed the Confidential (ver 6.0) code for the new states (NJ,ON,AB,NB) and prepared the case study of this project and presented to the top level management.
• 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 Confidential project deliverables.

Confidential

Module Lead

Environment:

Citrix ICA Client Metaframe 6.0.1

Languages: Omnis Studio 3.3.3

Database: MS SQL Server 2000

O/s: Windows XP

Responsibilities:

• 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.

Confidential

Senior Software Engineer

Module: Admin, Survey, Coordinator, Compliance Officer, Manager

Environment:

Software: Visual Studio. ASP, MS SQL Server

Languages: ASP, JavaScript, VB Script

Database: MS SQL Server 2000

Tools: Visual Studio

O/s: Windows 2000

Responsibilities:

• 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.
• Awarded POB for excellence efforts in the project