K SUBHASH NAIR
Dublin,OH
Summary
Designs, develops and maintains highly scalable, secure and reliable data structures. Accustomed to working closely with system architects, software architects and design analysts to understand business or industry requirements to develop comprehensive data models. Proficient at developing database architectural strategies at the modeling, design and implementation stages.
Have around 16 years of Strong IT experience in the analysis, design, development, implementation of complete software development life cycle in Information Management. Have written data pipelines using various data technologies - ETL/ELT and spark technologies. Drawing on Experience in all aspects of analytics/data warehousing solutions (Database issues, Data modeling, Data mapping, ETL Development, metadata management, data migration and reporting solutions).Have been key in delivering innovative database / data warehousing solutions to the Healthcare and Insurance Industries. Extensive experience in developing stored procedures, functions, Views, Complex queries using SQL Server and Oracle PL/SQL. Hands-on experience working in AWS and cloud platform. Hands-on experience in working on scripting languages like python,unix. Hands-on experience working on Docker and Kubernetes. Have built CICD pipelines for projects using Git/Jenkins/Harness. Have supported Data scientist in building EC2 and EMR machines.
Overview
16
16
years of professional experience
1
1
Certification
Work History
Senior Data Engineer
Anthem
10.2022 - Current
- Leading team of 6 resources offshore and 2 onshore along with development deliverables
- Handling Findcare system where end users search for Doctors and Hospitals
- Have improved over customer UI experience by 5% by enhancing data backend
- Increased overall performance by pushing EMR codes to DocDB and Glue scripts which reduced cost
- Building PySpark codes to ingest data from Oracle RDS to S3
- Working with business to build robust solution and work from inception to production
- Building data pipelines and working on build enhancements
- Written AWS Glue extract jobs for Downstream teams
- Writing Elastic search queries to analyze data
- Scheduler - Apache Airflow
- SQL server Procedures for Legacy loads and Informatica Powercenter.
Application Development Specialist Team Lead
Accenture
08.2017 - 09.2022
- Building data pipelines using Streamsets and data bricks
- Handled overall 30 streams of data sources from database and filesystems to build unique one-stop shop for data
- Streamsets was used to ingest data from files
- Databricks was used to ingest data from Tables
- Identify any automation areas and build it using python
- Work with Data scientist to build CICD pipelines
- Help migrate tools from On prem to Cloud servers
- Help and Support AWS platforms for Data scientists
- Build and Support Tableau reports for Business
- Work on requirement gathering from client converting them to technical design document and code using ETL tools, unit test, deploy and support process
- Build reports based on client requirement
- Develop automated script and reduce manual efforts
- Working closely with Architect to design ETL/ELT solution and data modelling.
- Mentored junior developers, fostering professional growth and enhancing team productivity.
- Participated in design and planning exercises for future software rollouts.
- Explained project technical risks and benefits during project kick-off.
- Collaborated with cross-functional teams to align application development goals with overall business objectives.
- Estimated work hours and tracked progress using Scrum methodology.
Application Development Specialist
Accenture
05.2012 - 07.2017
- Build datamart on investment division
- Working with business users and business analyst for requirement gathering and business analysis
- Converted business requirement into high level and low level design
- Build reports on investments division to meet client requirement
- Extracted data from different flat files, MS Excel, MS Access, tables and transformed data based on user requirement using Informatica Power Center and loaded data into target, by scheduling sessions
- Perform Informatica environment setups and handling migration activity closely working with Informatica admins
- Created complex ETL's from SRC-STG and STG-TGT
- Worked on data mapping, data cleansing, program development for loads and data verification of converted data to legacy data
- Developed Interfaces using UNIX Shell Scripts to automate the bulk load & update Processes
- Developed PL/SQL scripts.
ETL Technical Lead & Senior Software Developer
Accenture
03.2010 - 04.2012
- Developed Complex ETL's in Informatica and Teradata Scripts (BTEQ's) and Complex SQL's on Teradata
- Guide and assist team members for technical/functional issues
- Analyze Approach Documents/Templates and Suggest for Corrections
- Create Business Specific Documents and Technical Design Documents for different initiatives
- Develop Quality Code and Deliver Project Deliverables meeting all Standards and SLA's
- Perform Integration of various data sources like Teradata, Oracle, DB2, Sybase, SQL Server and Flat Files
- Creation of Shell scripts to automate SQL queries
- Optimization of Complex SQL queries
- Schedule ETL's, BTEQ Scripts, UNIX shell scripts using WLM tool
- Perform Testing and debugging of all ETL's, Teradata and UNIX objects in order to evaluate performance and to check whether code is meeting business requirement.
- Led team of developers to successfully deliver high-quality software projects on time and within budget constraints.
- Enhanced system performance with thorough code reviews, debugging, and optimization techniques.
- Led team of developers to successfully deliver high-quality software projects on time and within budget constraints.
Software Developer
Accenture
05.2008 - 03.2010
- Involved in data requirements gathering via: SQL data profiling of existing data sources and targets
- Coordinating with client team on daily basis for issues and status update
- Analyzing existing design and direct interaction with client data services /List mangers and list design team
- Conducting technical design presentation to client and getting sign off
- Design and develop ETL's to load data into staging and EDW and SQL's on Teradata
- Involved in creation of shell scripts to accommodate functionality of ETL's
- Preparing BSD's and TSD's of project phase by phase
- Developed (SCD 1) and (SCD 2) to capture new changes while maintaining historic information and also worked on building complex queries to capture only required data
- Implement enhancements/defects raised by business team
- Tuned mappings, sessions, workflow to improve performance.
- Discussed issues with team members to provide resolution and apply best practices.
- Collaborated with cross-functional teams to deliver high-quality products on tight deadlines.
Education
Bachelor of Technology - Computer Science
MVJ College Of Engineering
Bangalore,IndiaSkills
- ETL development
- ELT development
- Database
- AWS
- Azure Databricks
- IICS
- Pyspark Programming
- Python Programming
- Docker
- Kubernetes
- CICD Pipelines
- Airflow
- Informatica
- Git Version Control
- Agile methodology
- Snowflake
- Streamsets
- SSIS
- NoSQL Databases
- Data Modeling
- Kafka Streaming
- Data Pipeline Design
- Data Warehousing
- Spark Development
- Advanced SQL
- SQL and Databases
- Database Design
- SQL Programming
- Data Migration
- Data Analysis
- Data programming
- Large dataset management
Certification
- Informatica Certified Developer in Informatica Power Center - 8.x
- AWS Solution Architect Associate
Timeline
Senior Data Engineer
Anthem
10.2022 - Current
Application Development Specialist Team Lead
Accenture
08.2017 - 09.2022
Application Development Specialist
Accenture
05.2012 - 07.2017
ETL Technical Lead & Senior Software Developer
Accenture
03.2010 - 04.2012
Software Developer
Accenture
05.2008 - 03.2010
Bachelor of Technology - Computer Science
MVJ College Of Engineering
Similar Profiles
Aparna AGAparna AG
Tech Lead, Sr. Developer, Co-ordinator at AnthemTech Lead, Sr. Developer, Co-ordinator at Anthem
Maxine DavisMaxine Davis
Palliative Care Nurse Practitioner at AnthemPalliative Care Nurse Practitioner at Anthem
Tomie FaulknerTomie Faulkner
Claims Rep II at AnthemClaims Rep II at Anthem
Anthony PaskettAnthony Paskett
Provider Service Team Leader at AnthemProvider Service Team Leader at Anthem
Hollianne KanoskiHollianne Kanoski
Bindery Associate /Front Desk Receptionist at PressworksBindery Associate /Front Desk Receptionist at Pressworks