Data/ Cloud - Consultant

• Jan 2020 - Present

Cloud / Big Data Solution Architect

• Sep 2018 - Dec 2019

Lead the team from design/ implementation/ and adoption of AWS cloud Acted as a technology consultant for technology requirements, lead brainstorming sessions, and created prototypes for the team to take the journey forward. Helped in fostering data value drive by enabling incubation area Worked with distributed teams to design and develop frameworks, solution accelerators, proofs of concept, and external customer-facing products. Designed and implemented high scalable/ reliable solution to poll API in high frequency 600 calls per second. Tech Stack used: EKS (Elastic Kubernetes Service), Docker, SQS, SNS, Lambda, Kinesis, polling 110,000 KMS of travel time in 15 mins Architected and implemented a fault-tolerant application to consume Legacy SOAP API and act as a secondary distributor of the data in the Pub/ Submodel. Tech Stack: Elastic BeanStalk, Kinesis, Lambda, JAVA CXF, Talend, SNS Architected internal data market place. Central portal for the data consumer for batch related layer, speed layer, customized report. Enabling Data adoption/ usage and delivering business value Architect internal data hub, primarily API layer for ease of data exchange and reduce barriers of inter-organization data exchange Developed and implemented data science practice using sagemaker. Key highlights of the solution include technology of choice for improved productivity, the capability to use compute/ memory of choice, model performance monitoring and tuning Implemented Near Real-time reporting, data available to consumers in the reporting layer within 20 seconds on average from the time of ingestion, including calculating KPI Established design councils, conducted brown bag sessions on new Proof of concepts, trained and mentored team, create a win-win environment Lead discussion cloud-related security. Created a baseline of control items, adoption of AWS well-architected frameworks, enabled monitoring using cloud-native tools like Security hub, AWS config

Lead Solution Designer/ Architect

• Oct 2017 - Sep 2018

Senior Solution Designer - Analytics and Information (A&I)

• May 2013 - Oct 2017

- Designing end-to-end solutions for the group data warehouse and BI domain, providing advice and guidance on technology architecture in addition to logical and physical designs to meet the needs of the customer while adhering to the direction and strategies applied by the Information Strategy team - Developing technology specifications and ensuring that new technology solutions are designed for optimal access and usefulness, and leveraging existing technologies when possible - Applying architectural and engineering concepts to design a solution that meets operational requirements, such as scalability, maintainability, security, reliability, extensibility, flexibility, availability and manageability - Identifying the technologies to employ based on price, performance and organization constraints - Working as a presales technical consultant for technical proof of concepts, engage with potential business stakeholders, provide architectural direction and convert a lead to opportunity - Collaborating with end users to identify needs and opportunities for improved data management and delivery - Overseeing the ongoing development and operations of a business intelligence architecture that enables fact-based decision making and ad hoc analysis and insight generation

Architect Engineer

• Jun 2012 - Apr 2013

- Played the role of a Technical Architect in the Business Intelligence Domain, guiding the development team and assisting the customer in providing technical direction to the project - Designed and developed the data warehouses and data marts using Microsoft Business Intelligence stack (SharePoint 2010, SQL Server 2008/ 2012, SSIS, SSAS and SSRS) - Ensured compliance with Microsoft BI Best Practices and common coding standards to achieve high quality product design and customer satisfaction - Established and conducted technical code reviews delivered by team members to ensure deliverables are top quality and optimizing the performance of database queries and codes - Provided estimates and allocated resources for a work item and tracking progress to delivery - Contributed to the company’s development of intellectual property by identifying and hiring qualified employees, conducting regular training, and leading code design teams - Worked in close collaboration with the customer’s team to understand Business requirements and to develop Software requirement Specifications (SRS) and Technical Design Specifications (TDS)

Project/ Technical Manager

• May 2009 - Jun 2012

- Designed and developed reliable, scalable, and high performing software architecture, identified design alternatives, and conducted technical feasibility studies - Managed resources, directed and coordinated technical activities to deliver web application projects in Cloud Computing and Microsoft.Net platform to meet specific client needs - Developed proof of concepts for technical evaluation and early customer feedback, algorithms to convert functional specifications into software design, and unit test suites to verify the accuracy of ETL processes, dimensional data, OLAP cubes and various forms of BI content including reports, dashboards, and analytical models - Worked closely with BI, DW, and DB developers to understand, analyze, make solution recommendations and refine solutions by writing high performing code and defining alternative strategies for data design, ETL processes, and unit testing of data - Ensure the consistency between the defined requirements, the implementation of the business logic at the database layer, and the user’s experience in interacting with that data - Successfully delivered more than 20 projects with good success records in .NET, SQL Server 2008, SSIS, SSRS, SSAS, and CRM

Senior Executive - Capacity Planning & WFM

• May 2006 - Apr 2008

- Designed and wrote code to meet business requirements and ensured consistency between the defined requirements by implementing logic at the database layer and monitoring the user’s experience in interacting with that data - Prepared documentation to capture technical specifications and end user usage - Created database tables for the application, stored procedures and functions in the database, implemented user controls for the application, and extensively worked on ADO.NET to access data from SQL Server - Reviewed and tested the developed modules, prepared technical documentation for the application, ran quality tools on software, and analysed reports generated by the tools to incorporate changes/results

Workforce Management Executive

• Jun 2004 - May 2006

- Wrote and maintained code as per Software Requirements Specifications in compliance with coding standards established by the corporation - Communicated with end users to gather and document requirements, developed support tools for the exception management processing application, and wrote business logic code to dynamically validate rule changes in various industries - Conducted internal technical knowledge sharing sessions focused on technical aspects used in the application and exposing personnel to upcoming technology shifts and advancements - Involved in post go live support and stabilization process and drafted a technical help document for technical troubleshooting

Junior Engineer

• Apr 2002 - Apr 2004

•Create and update Software requirement specfication document based upon inputs from business •Design, Write and Maintain MIS report using ASP, MS Access and Excel •Unit test the piece of code •Deploy the code to Production servers •Integrate software with existing systems •Maintain standards compliance •Create and update Software requirement specfication document based upon inputs from business •Design, Write and Maintain MIS report using ASP, MS Access and Excel •Unit test the piece of code •Deploy the code to Production servers •Integrate software with existing systems •Maintain standards compliance