SUMMARY

• 19 years of Information Technology in global (On - Shore & Off-Shore Model), cross-functional & multiple projectized environments for Analytics/Data Science/DevOps/ Business Intelligence, Data Warehousing, Software Development & Technology Projects.
• Decades plus Technology experience & Knowledge in Airlines/Airports, Telecommunications, Biotechnology/Pharmaceuticals, Finance/Banking/Insurance, Manufacturing, Utilities, Government, Retail, Oil & Gas and Security System Integration.
• Azure ADF, Machine Learning, Data Science, AI/BI Data Warehouse Analytics Specialist working extensively in leading & working with Executives, Project/Product/Delivery Managers, Trainers, Contracting Services, Operations, Data Architect, Data Modeler, business analyst, data quality analyst, decision support developer/data science programmers, trainees, DBA and ETL Developers.
• Multiple years of experience with working in BI/Analytics CoE, ODC, and Data Storage/DRC for operations, ensuring smooth functioning of the Delivery and Business.
• Executed all 3-types of cloud technical data architecture using varied technologies including Azure Cloud C#, Amazon AWS Redshift, Luis.ai, BotFramework, GitHub, Python, Machine Learning, NLP, Data Science Libraries, Hadoop, Hive, Java/ Linux/Shell Scripting, Oracle, SQL Server, Web Services on Informatica Cloud- Data Virtualization .
• Multiple Years of IT/Software application/s experience in Analysis, Design, Testing, Development, Documentation and Implementation of System Engineering, Software Development, Data Science, Analytics, BI/DW Applications, Software and ERP (SAP) as a Technical Specialist, Developer and Systems Engineer.
• 14+ years of strong Data Science & Warehousing experience in building and managing various math models, interactive visualizations, prediction datasets, data warehouse, data marts using Open R/RStudio, Python, Informatica, SAP, Denodo, Qlikview, Redshift, Pentaho Analytics software for structured/unstructured data including RDBMS, Flat Files, BigData, SAP/Mainframes/Siebel.
• Experienced on Statistical/Dimensional/NLP/Machine Learning Modeling experience using, Luis.ai, Python, RStudio, Data modeling, Erwin Modeling (ERwin 4.5) Star Join Schema/Snowflake modeling, FACT & Dimensions tables, Physical & logical data modeling
• Excellent working experience with Business intelligence/Data Visualization/Engineering tools using Python, Pentaho Analytics, RStudio, Denodo, and Business Objects XI, Crystal Reports, BigData, MetaData Reporter, Qlikview, Tableau & BO.
• Excellent working experience with Data Warehousing/ Artificial Business intelligence tools using data science, data extraction, data prediction, data cleansing, data integration, data ingestion, data masking, data rounding, data analytics, data presentation among other core data processing tool techniques.
• 18 + years experience in Cloud, Client-Server internet/intranet development experience using ASP .Net, Visual Basic .Net, VBScript, Java Script, IIS, SAP ABAP FICO, HTML, Microsoft Project, Oracle 10g/9i/, USQL, C#, MS SQL Server, IOT, MySQL, DB2, PostGres, MS Access, AI ChatBOT, Data Warehousing, Informatica, NLP, NLTK, Tieano, CNN, SAS Analytics, Python, RStudio, Crystal Reports XI, MS Office 360, PhotoShop, Azure, AWS, Telecommunication & Biotechnology Packages, Linux.

PROFESSIONAL EXPERIENCE

Confidential, CA

DEVOPS - ANALYTICS ARCHITECT

TECHNOLOGIES: AZURE DEVOPS, DATABRICKS, SPARK, AZURE SQL DATAWAREHOUSE, ADLS, INFORMATICA, SQL, SQL SERVER 2017, VISUAL STUDIO 2019, TERADATA, PYTHON, C#

Responsibilities:

• Worked as Azure Devops Analytics Architect, this position carried the responsibility for technical design standards, process implementation, technical implementation and ensuring that the implementation is according to design.
• Conceptualized, Planned, Created the right Azure Analytics DevOps infrastructure for multiple set of solutions and technologies including ADLS, ADLA, DataBricks, Spark, SQL DW, Informatica, Teradata, Python and C# to scale/process millions to a billion record within Seconds & Minutes.
• Design & develop CI/CD pipelines for delivering reliable platform solutions.
• Communicate with multiple stakeholders including senior leaders regarding the architecture, discuss problems and recommend solutions/ improvements and conduct training sessions on Azure DevOps.
• Practice and enforce Agile and Scrum development methodologies.

Confidential, UT

SR. AZURE DEVOPS SPECIALIST

TECHNOLOGIES: AZURE, ADF, USQL, SQL SERVER 2017, VISUAL STUDIO 2017, VSTS, PYTHON, BIG DATA, MACHINE LEARNING, svn

Responsibilities:

• Responsibilities included end-to-end responsibility of migration from On Premise to Azure Data Factory environment. Architected Analytics Solution on Microsoft Azure Platform using Data Factory, Analytical Services, Azure Data Lake, HDInsight
• Recommended Azure Architecture for Analytical Application, worked on Capacity / Sizing options / Predictive Apps on Azure Platform, uSQL, C#, VS 2018, Python.
• Responsible for maintaining DEV, Testing/QA and PROD Environment.
• Implemented a Continuous Integration and Continuous Delivery (CI/CD) pipeline with Azure Container Service. Migrated our Development and Production environment from multiple OnPremise servers to a handful Azure nodes.
• Built a MS Azure team & competency (both Infrastructure/Architecture and Analytics focused)for MS Azure Data lake, Azure Data Factory, Analytical Services and Analytics
• Configured schedule actions for auto scaling to stop servers to minimize running cost for servers based on working hours.
• Supported application in production and worked closely with off-shore/onsite teams.
• Installing and configuring SQL maintaining backups/snap shots and restoring.
• Worked with Developer for Microsoft Power BI or reporting tool, developing, setup, create new reports, reports maintenance
• Integration with other systems to collect the data into Microsoft Azure including data mining techniques and make recommendations on technologies related to data mining.
• Worked on VSTS, Scrum Methodology, SSAS/AAS, Visualization Tools
• Created and configuring custom horizontal & vertical VM’s for auto scaling on Azure.

Confidential, NC

ANALYTICS/DW ARCHITECT

TECHNOLOGIES: Informatica, SQL, SQL SERVER 2015, VISUAL STUDIO 2015, ORACLE

Responsibilities:

• Responsibilities included defining the scope for Technology Re-platform Project consolidation of all the data from third party vendors including NBFSA, Enrollment123,Allied, Tabs - business solver, Mertain, AMR etc. (All the sources are listed in the Appendix)
• Integration & Migration of Assurant Health supplemental Data.
• Massive standardization of Data across multiple sources
• Universal key generation for all the confirmed dimensions like policy, member, Agent, Claims etc.
• Defining Technical and Administrative meta data, Audit, Balancing and Controls data.
• Creating Data dictionary and business glossary, Business logic in shared ETL containers. (Enables NGCI to use the same logic across several entities)
• Conversion of some existing reports to the new EDW.
• Design flexibility to adapt a service oriented architecture.
• Error and Exception processing. (Auto re run of the errored data file after fix.)
• Tracking of loads in detail.
• Historical components will be built on all the primary dimensions Ex: Policy, member etc.
• Build EDR - enterprise data repository consisting of integrated, consolidated, non volatile, historical, non-aggregated, single source of truth for the consolidated version of the data.
• Supplemental data transferred from Assurant health will be maintained in a static database for at least couple of years.
• All the external vendor feeds retained for a period of 15 days for daily feeds, 2 months for weekly feeds, 4 months for monthly & 3 years for yearly feeds
• SSRS and SSAS reports developed as per the requirements. (phase -2)
• Automated the etl process for all the vendor feeds

Confidential, CA

SR. BI/DW CONSULTANT & ARCHITECT

TECHNOLOGIES: DENODO, PENTAHO, INFORMATICA, AMAZON REDSHIFT MPP, ORACLE EBS, HYPERION, ESSABSE, UNIX.

Responsibilities:

• Responsibilities included Project BI/DW solutioning, Client DW investigations and implementation of Data Virtualization & real-time reporting, Bottom line responsibility for execution, ensure project is executed in compliance with the SLA’s and Client and internal processes, Status reporting and issue resolution, conduct process audits, do root cause analysis and apply knowledge to improve productivity and quality.
• Installation & Administration of Denodo 6.0, Informatica 9X, Pentaho includes for UNIX & Windows, Server & Client, Domain & Node, Roles, Services, and License’s.
• Architected, performance tuned & delivered Denodo-Penatho solution using Suite including Scheduler, VDP, DI, Workbench, used adhoc reporting, User Console, CTools,Reporting designer & metadata.
• Conceptualized, Analysed and Architected Complex mappings using Unconnected, Lookup, and Aggregate and Router transformations for extracting data in efficient manner.
• Architected and Created reusable Mapplets, used by complete team in all Mappings for the current project/s.
• Advised, Scheduled and Used different Informatica transformations in an efficient manner and as per requirement to gain maximum mileage for deliverables.
• Designed and Developed the Audit Control Components of the Project from both a Source/Target, Traceability and Reporting perspectives.
• Worked with multiple teams for Business Denodo data virtualization, Database, Flat File, Stored Procedures, Views, Packages, Unix Scripts.
• Conceptualized, Created and worked with all Data Warehousing documentation relating to New Proposals, Solutions, Design, Development, QA, Change and Production.