Jul 2019 – Present · 6 yrs 8 mos · Washington DC-Baltimore Area · Hybrid

• Lead architecture design and trade-off discussions across performance, scalability, cost, and
• reliability
• Experience leading requirements-gathering activities and translating stakeholder input into
• technical specifications
• Capability to architect, build, and deploy secure Retrieval-Augmented Generation (RAG) and
• Knowledge Graph systems, implementing robust Role-Based Access Control (RBAC)
• mechanisms to ensure data permissions are precisely scoped and access remains tightly
• governed.
• Embed AI into DevSecOps pipelines and CI/CD workflows for automation, code generation,
• and analytics.
• Strong background in SQL development, SQL tuning, and intelligent BI analytics tools
• Familiarity with architectural frameworks and cloud foundations across multiple cloud
• providers like AWS and Azure.
• Experience with cloud-native data engineering and architecture, including services such as
• Redshift, Azure synapse, PySpark, AWS Glue, S3, Kafka, Kinesis, EMR, Athena, Lambda, Lake
• Formation, or Databricks/Snowflake.
• Design and implement star schemas (Fact and Dimension tables) to support enterprise
• analytical, BI tools like PowerBI, QuickSight, and reporting requirements with high
• performance and query efficiency and familiar with multiple file format like Avro, Json,
• Parquet.
• Developed and optimized SQL stored procedures, functions, and queries to support highvolume backend operations.
• Ensure success in building, migrating, and deploying applications, software and services on
• the AWS platform
• Experience in transforming unstructured data from various data sources using SSIS and
• Airflow.
• Monitored infrastructure on RDS, Databases, EC2, Lambda, ECS, AWS Fargate, and EKS using
• CloudWatch, Grafana, New Relic and Datadog.

Mar 2018 – Jun 2019 · 1 yr 3 mos · Washington DC-Baltimore Area

• Work with central infrastructure team on architecture choices and the best practices to
• adopt AWS efficiently and cost-effectively.
• Ensure success in building, migrating, and deploying applications, software and services on the AWS
• platform
• Engage with developers, system administrators, software architects, project manager and directors
• to define cloud strategies and deployments
• Responsible for the end-to-end journey from On-Premise to Cloud with defining strategy,
• transformation, cloud deployment, cloud Integration, Cloud migration, and successful transitions to
• implementation support teams
• Plan, consult, and design architecture and solutions on AWS along with AWS Team

Nov 2014 – Feb 2018 · 3 yrs 3 mos · Washington DC-Baltimore Area

• Experienced in working with Hadoop clusters using Cloudera distributions.
• Developing big data solutions in Hadoop Ecosystem using Apache Spark, Hive and Pig.
• Developed various data ingestion pipelines using streaming tools like Flume, Spark and Kafka.
• Worked with Data lake architecture and setting up Hadoop environment for
• ingesting claim and provider data from multiple sources.
• Import/export data using Sqoop from Relational Database systems to HDFS.
• Involved in creating Hive tables, loading and analyzing data using hive queries.
• Worked on Spark SQL, Data Frame, Spark Streaming, Reading/ Writing data from Avro, Json, Text,Parquet to RDD.
• Exploring with Spark various modules of Spark and working with Data
• Frames, RDD and Spark Context.
• Serve as a mentor and trainer of other members of the team. Provide guidance, assist in building skill sets, and provide knowledge of ETLprocessing, T-SQL debugging, Performance tuning technique, SSIS, SSRS for junior IT operation specialist.

Jul 2012 – Oct 2014 · 2 yrs 3 mos · Washington, District of Columbia, United States

• Gathered user requirements and analyzed and designed software solution and database.
• Responsible for data extraction and data ingestion from different data sources into Hadoop Data Lake by creating ETL pipelines using Pig, and Hive.
• Worked extensively with Hive DDLs and Hive Query language (HQLs).
• Helped in the design of the Architecture of the Data Warehouse and helped in performance tuning of the data base.
• Designed SSIS Packages to transfer data from various sources like Text Files, SQL Server, and Excel to SQL Server using Business Intelligence Development Studio.
• Wrote T-SQL queries, Stored Procedures and used them to build packages.
• Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.
• Stored Procedures, User Defined Functions, Views, TSQL Scripting for complex business logic.
• Worked on QA testing by writing scripts for source and target data to verify the integrity of the data.

Jan 2012 – Jun 2012 · 5 mos · Washington DC-Baltimore Area

• Designed and developed Complex SSIS packages for auditing using SQL SERVER 2008 Integration Services (SSIS).
• Created schema objects such as tables, views, clusters, indexes, procedures, triggers & maintaining Referential Integrity.
• Involved in Maintenance and Deployment of SSIS Packages.
• Create database objects in SQL Server 2008 including Tables, Triggers, Views, Stored Procedures,
• User Defined Functions (UDF) and Indexes.
• Created SSIS packages using SSIS designer for export heterogeneous data from OLE DB Source (Oracle), Excel spreadsheet to SQL Server 2008
• Developed Custom Reports, Ad-hoc Reports by using SQL Server Reporting Services (SSRS).

Oct 2010 – Dec 2011 · 1 yr 2 mos · Plantation,FL

• Design ER diagrams and mapped the data into database objects.
• Wrote SQL scripts to insert update and delete data in MS SQL database.
• Created schema, views, stored procedures, Triggers and functions for Data Migration. Involved in
• the complete life cycle of the project, from Planning Staging and pushing the codes to production.
• Transform data from various data sources using OLE DB connection by creating various SSIS
• packages.

Jul 2009 – Sep 2010 · 1 yr 2 mos · Metro Jacksonville

• Created database and database objects like tables, stored procedures, views, triggers, user defined data types and functions.
• ETL implementation using SQL Server Integration Services (SSIS), applying some business logic and data cleaning in staging server to maintain child and parent relationship.
• Designed, built the dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).
• Worked on improving the performance of the system.

Aug 2008 – Jun 2009 · 10 mos

• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.
• SQL Server 2005 RDBMS database development using T-SQL programming, queries, stored procedures, views.
• Taking weekly database backup and schedules job using SQL Agent.
• Experience in designing and building the dimensions and facts with star schema and snowflake schema using SQL Server Analysis Services (SSAS).