SUMMARY

• Over 12 years of exclusive experience in the Data realm including Data Warehousing, Analytics, Big Data and AI.
• An integral part of Data Analytics and AI Centre of Excellence (CoE) providing fineness across delivery, research, support, training internal teams, presales, and conducting technical interviews on various tools and technologies in the data universe.
• Proficient Data Warehousing skills using Microsoft technologies including Azure Data Factory, Azure SQL Warehouse, Azure DataLake, Azure HDInsight Power BI, and Microsoft BI - SSIS, SSRS, SSAS, SSMS.
• Delivering robust solutions in ETL and Integration solutions using Informatica on cloud, on-prem and hybrid platforms.
• Experience in Google Cloud Platform services including - Cloud SQL, Dataflow and BigQuery.
• Act as a liaison between business owners and technical associates to ensure the completeness and correctness of the data being processed.
• Hands-on experience with various products and services offered by Informatica - PowerCenter, Data Integration, Application Integration to name a few.
• Build complex Data Pipelines using Python to extract data from various sources.
• Hands-on experience on storing large volume of data on Hadoop ecosystem namely HDFS, Hive, Spark, Kafka
• Professional level in writing SQL queries to understand and explore data.
• Strong knowledge about API and Web Services usage and consumption using Informatica’s Cloud Application Integration and commonly used software like Soap UI and Postman.
• Experience on all aspects of Software Development Lifecycle (SDLC) - Requirement gathering and analysis, Design, Development, Testing, Implementation, Support and Documentation.
• Perform Root cause analysis and end to end testing to verify complete functionality of application.
• Design interactive Dashboards and visualizations using Power BI and Tableau.
• Extensive leadership skills resulting in successful delivery of up to three mid-sized projects simultaneously.
• Enabling teams to work independently on end-to-end tasks with focus on timely delivery with high quality standards.
• Strong believer of objective driven discussion, accepting criticism as constructive feedback thus resulting in effective conflict resolution.
• Proven leadership on initiatives involving collaboration with different members working from diverse locations and taking various missions to a prodigious success.
• Exceptional communication skills have helped gather precise requirements and resolve issues in Daily and Weekly scrum meetings. Showcase overall project status in Monthly Dashboard meetings with clients.
• Create detailed project plans including tasks, resource allocation, effort estimation and Cost burn down analysis.
• Excellent team management skills that include Training/Mentoring, Task Delegation and Review, Risk assessment and mitigation planning.
• Conduct weekly and monthly one-to-one sessions with team members to discuss .
• Monitor individual team member’s performance and work with leadership to create performance plans.
• Streamlining processes and implementing agile practices by using tools like Jira.
• Partner with multiple clients on their journey to cloud.
• Handling teams of different sizes from one to sixteen members scattered globally.
• Enable Onshore and Offshore teams on several technologies ra nging between commonly used Services like Informatica, Microsoft SQL Server, Oracle, Cloudera to Niche Software Tools and Technologies like Pentaho Suite and Magic XPI.

TECHNICAL SKILLS

ETL tools: Informatica Cloud Data and Application integration, SSIS, Azure Data Factory, DataStage, Informatica PowerCenter. Google Dataflow

Big Data: Hadoop, Hive, Spark, Kafka, Sqoop

GCP Technologies: Cloud SQL, Dataflow, BigQuery, AutoML, Deepmind, DataProc, Cloud Pub/Sub

Microsoft Technologies: Azure VM, Azure HD Insights, Synapse/data warehouse, MSBI

Databases: Azure SQL, SQL Server 2005 - 2016, Oracle (SQL, PL-SQL), DB2, Access

Programming: Python

Development Tools: Visual Studio 2005 - 2015

Management Tools: SVN, TFS, GIT, Rally, Bugzilla, Jira, Trello, ServiceNow, Microsoft Teams

Visualization: Power BI, Tableau, Cognos, SSRS, Crystal Reports, MS Excel

Domains: Healthcare, Finance, Manufacturing

PROFESSIONAL EXPERIENCE

Confidential

Practice Manager

Responsibilities:

• Enable internal teams on multiple data and analytics tools and technologies.
• Be a strategic partner to clients for all types of technical assistance.
• Design easy to understand frameworks for complex business problems involving on-prem, cloud and hybrid architectures.
• Make suggestions to client on tools and technologies based on the nature of business and the landscape in use.
• Facilitate automated loan application using Informatica's application integration (IICS).
• For Bio-Rad Laboratories and ANBTX, orchestrate real-time integrations between several applications for instance - SAP, DocuSign, SalesForce ServiceMax, Experian credit checks, LaserPro Loan processing and document generation, OFAC Checks, Snowflake Warehouse.
• Design near real-time experience with JD Edwards (ERP) and newly implemented Warehouse management system (JDA) for DiversiTech using niche software - Magic XPI.
• Development and delivery of projects using Data and AI tools for major clients in Banking, Insurance, Healthcare and other domains.
• Drive technical discussions with clients to discuss requirements and demonstrate Confidential System’s capabilities in terms of Data and Analytics.
• Execute POC as a part of presales to demonstrate practicality of the framework designed for relevant use cases.
• Create presentations and Technical documentation material to illustrate POC.
• Be an active part of Presales team to find, win and keep customers.
• Create responses for RFP bids to win customer/project.
• Participate in conferences across US to support Sales teams technically.

Confidential

Manager – Data Analytics and AI

Responsibilities:

• Create design diagrams to visualize Platform-as-a-Service.
• Configure Kafka Pub-Sub model to ingest live streaming data.
• Ingest data using Sqoop for structured data from MS SQL Server.
• Design Hive Database to store and process data sourced from different systems.
• Create detailed project plans to be implemented by in-house and offshore teams.
• Actively participate in design meetings to create a robust AI platform.
• Review code and testing documents to ensure development

Confidential

Technical Architect

Responsibilities:

• Design ETL solutions for provider search (physician and facility) using Azure Data Factory.
• Develop new reports using Power BI.
• Cater requests for enhancements/bug fixes of legacy applications.
• Resolve issues in existing SSRS reports.
• Translate business problems to high level design using Microsoft Visio and delegate to offshore team for development.
• Allocate User Stories and defects to team members.
• Daily coordinate with offshore team to ensure timely completion of tasks.
• Review work done by the team members.
• Communicate with client for understanding of requirements and discuss issues.
• Host Daily, Weekly, Monthly status and Dashboards meetings with client.
• Assess Risks of resources and make mitigation plans.
• Represent the project status in the fortnightly A&P meeting with CxO leadership.
• Support medical team to update clinical codes and their associated agreements into the Isaac system.
• New development for Service Rule Engine, Match Criteria Database, and Web Platform redesign.
• Resolve production issues impacted or caused by system configuration settings.