Joseph Nemuri

• GT Analytics supports IT and business partners by providing support with Reference Architecture, Playbook and infrastructure implementation, these artifacts should be used as guidelines/guardrails for projects implementing technical capabilities like Analytics, Application, Cloud Data, Integrations, Networking and Security.
• Employed Software-as-a-Service (SaaS) and Platform-as-a-Service ( PaaS) products to reduce initial outlay in systems purchasing 50%.
• Conduct training Azure ADF/Synapse for different groups
• Helped charting out Azure Strategy and created Out-of-Box Solutions
• ADF/Synapse workspaces, SQL Server DB, Blob Storage, GitHub Configuration, Key Vaults, AAD Security groups. Linked Services, SHIR configuration.
• Lift and Shift the Alteryx community into the Azure Cloud platform.
• Employed Software-as-a-Service (SaaS) and Platform-as-a-Service ( PaaS) products to reduce initial outlay in systems purchasing 50%.
• Led successful database conversion projects that resulted in significant improvements in processing speed without compromising on accuracy or integrity.

Project Scope: Data point process various medical client files and ingest, extracts data based on the requirements

• Implemented technical capabilities of Cloud platforms
• Managed project management and IT-related projects as a Data Architect, including Data Architecture, ETL, Databases, and Machine Learning technologies. Assisted clients in Informatica Development and Program Structure/Governance
• Oversight, which helped them manage their current structure and project stakeholders effectively.
• Designed and provided architecture solution that is reusable, maintainable, and scalable
• Architected and implemented medium to large scale BI solutions on Azure using Azure Data Platform services such as
• Azure Data Lake, Data Factory, Data Lake Analytics, Stream Analytics, Azure SQL DW, HD Insight/Databricks, NoSQL DB.
• Designed and implemented migration strategies for traditional systems on Azure, including Lift and shift/Azure.
• Reviewed Data Engineers RFC and signed off work tasks deploying into higher environments, ensuring quality of work
• Helped Data Engineers abide by company structure and timeline for immediate remediation efforts with minimal cost and compliance, demonstrating attention to detail and problem-solving skills
• Worked with external vendors such as Thought Spot and Pentaho for POC/Support, broadening scope of project
• Created agile tasks in VSTS and adhered to vision/direction of senior managers, focusing on completing the tasks in agile methodology.

Project Scope: MyMetrics project for, helps create the User Experience for all the PwC employees and brings in different Cards/Metrics for enhancing the individual actions

• Developed conceptual model using Erwin based on requirements analysis and developed normalized logical and physical database models to design OLTP systems for insurance applications
• Created dimensional model for reporting system by identifying required dimensions and facts using Toad Data Modeler 7.1
• Experienced in creating, deploying, configuring and scaling resources in Azure, including Azure web application, App services, Azure storage, Azure SQL Database, virtual machines, fabric controller, Azure AD, Azure search, and notification hub.
• Provide IaaS support to clients, creating virtual machines through PowerShell scripts and Azure Portal
• Designed and implemented database solutions in Azure SQL Data Warehouse, Azure SQL
• Recreated existing application logic and functionality in the Azure Data Lake, Data Factory, SQL Data-base, and SQL
• Data warehouse environment, with experience in DWH/BI project implementation using Azure DF
• Migrated data from traditional database systems to Azure databases. Designed network security groups (NSGs) to control inbound and outbound access to network interfaces (NICs), VMs, and subnets
• Deployed VMs, storage, network, and affinity groups through PowerShell scripts. Created storage pool and stripping of disk for Azure virtual machines, backup configuration, and restore Azure virtual machine using Azure Backup
• Set up full CI/CD pipelines so that each commit a developer makes will go through the standard process of software lifecycle and gets tested well enough before it can make it to production
• Created agile tasks in VSTS and adhered to the vision/direction of senior managers.

Project Scope: As a senior developer, I worked in Data Services that loaned into Client Aligned Teams (CAT) comprising of agile framework

• Utilized expertise in CRM, ETL, SQL, C#, and API development to create and enhance various data services for CAT teams.
• Create/Enhance CRM Outbound data feeds, Distribution process for Order Fulfillments, Field Force Alignments, Web API process and other Requests for the Client Aligned Teams.
• Created a web API process for a client-aligned team, resulting in a 50% reduction in manual data entry and a 25% improvement in data accuracy.
• Develop custom process for preferred clients to decrease manual operational interventions on the PP+ CRM platform. Recent program included Patient-Nurse Auto Alignments with respective Patient/Provider zip codes.
• Created/update C# programs, SSIS Dataflow, and wrote complex T-SQL queries to process data feeds, inbound/outbound distribution files, and field force alignments.
• Designed web-based ASP.NET internet applications linked to firm-wide SQL databases.
• Used Team Foundation Server (TFS) for versioning data services work items and keeping track of them in Scrum calls.
• Completed peer reviews and adhered to Lash Standard processes to ensure quality work, including proper handling of SDLC Release Plan, Release Notes, and other requirements before handing over to testing teams.
• Utilized ServiceNow for all change requests, incidents, and sprint releases.
• Completed standard documents for change release approvals, including SDLC Release Plan, Release Notes for all environments, Technical Design Document, Production Validation Checklist, and TFS Change sets.

Project Scope: As an ETL Lead helped client to getting into gear and ball rolling for Informatica Overall Structure

• Client adopted Informatica as the tool for migrating “Clergy Pension Plan Review” (CPPR) CPG pension data into new Enterprise
• Data warehouse (EDW).

• Project Scope: As a senior at EY helped various clients to increase efficiency of project time, budget, and risk management in the company
• To get acquainted with techniques of working in multi-project environment and provide recommendations on corporate project management system development.

• Project Scope: The CS is going the overall remediation effort to counter all the massive data quality issues (20+TB
• SWAPS/Trades Data), which are the key decision makers and dependencies on which the management relies
• ETL (Informatica) plays a huge role in pulling these Source feeds and process them into extracts for dif-ferent applications on daily basis.

Project Scope: The Guardian Life Insurance Company of America and its subsidiaries are committed to protecting individuals, business owners and their employees with life, disability income, dental insurance products, and offer 401(k), annuities and other financial products.

Project Scope: IMS plays a central role in advancing global healthcare — revealing the insights within the most comprehensive market intelligence available

• ETL developer involved in integrating between SAP systems and
• Salesforce Development platform.
• Analyzed work to generate logic for new systems, procedures and tests.
• Developed next generation integration platform for internal applications.