Samiksha Kalpande
Mesa,AZ
Summary
Results-oriented professional with extensive experience in software development, data integration, and cloud migration. Expertise in facilitating stakeholder collaboration and enhancing product development processes through effective communication and technical documentation.
Overview
13
13
years of professional experience
1
1
Certification
Work History
Product Consultant -technical
Cognizant Technology Solutions
Mesa, AZ
04.2020 - Current
- Leading PaaS migration of facets product and services from on-premises infrastructure to Azure cloud, including Oracle to Azure SQL transition.
- ETL and Reporting: Strong experience in creating ETL process via Bulk Copy Program (BCP), SQL Server Integration Services (SSIS) (2005/2008 R2/2012/2014), reporting via SSRS.
- Data Mapping and Profiling: Creation of source to target mappings, transformation rules, and data profiling to ensure data quality and conformity with business requirements.
- Data Extraction and Integration Design: Designing conditions and processes for extracting and integrating data, considering risks and metadata analysis.
- System Development and Quality Assurance: Developing new interfaces as facets .net extensions, ETL applications between systems, maintaining, and enhancing systems with adherence to coding standards, collaborating with teams, and conducting tests to ensure scalability, responsiveness, availability, security, and maintainability.
- Software development life cycle involvement: Active participation in all project phases, including design, development, testing, debugging, maintenance, and updates.
- Translated business needs into functional specifications and created system use cases and low-level designs through interaction with internal stakeholders.
- Coordinated communication between technical teams and business stakeholders to ensure alignment.
Data Analyst
ASTIR IT SOLUTIONS
San Francisco, CA
04.2018 - 03.2020
SQL BI developer
ASTIR IT Solutions
Washington, DC
12.2016 - 03.2018
- Collaborated with World Bank Group – International Finance Corporation during tenure with Astir IT Solutions.
- Developed reports with SSRS, including graphs and charts, by writing stored procedures, triggers, and views based on data models.
- Data Migration and Integration: Developing SSIS packages for data comparison, transformation, and migration, including modifications for third-party DB objects.
- Analyzed, designed, coded, and tested component and assembly for owned application code, ensuring alignment with customer requirements.
- Application Support and Maintenance: Providing ongoing application support, investigating issues, and implementing corrective actions. Interacting with enterprise teams to ensure adherence to defined standards.
SQL Web developer
Tata Consultancy Services
India
01.2013 - 08.2015
- Application Design and Coding: Develop web applications using .Net
- Data Management and Reporting: Understanding data models, writing stored procedures, triggers, views, and developing reports via VBA.
- Data Migration and Integration: Developing SSIS packages for data comparison, transformation, and migration, including modifications for third-party DB objects.
- Supported major US retail client during tenure at TCS by collaborating on various projects.
Education
Bachelor of Engineering -
Yeshwantrao Chavan College of Engineering
Nagpur, IndiaSkills
Data Science Data Analytics Data Analysis Data Modeling Data-Driven Decision Making Statistical Analysis Pandas Library
- Python SQL C# VBA NET
- Cloud & DevOps: Microsoft Azure Cloud PaaS Migration SAFe 5 DevOps Practices CI/CD Concepts Agile Delivery
- Database Technologies: SQL Oracle SQL Server IBM Netezza Microsoft Azure Relational Databases MS Access
- ETL & Data Integration: SSIS SQL Server Data Tools (SSDT 2010/2013/2015) Data Migration Data Transformation
- Reporting & Visualization: SSRS MS Excel Dashboard Reporting
- Development & Database Tools: Oracle SQL Developer SQL Server Management Studio (SSMS) Aginity Workbench TFS SVN
- Microservices Architecture
- Enterprise Platforms: Investran Facets
- Cloud Infrastructure
- Banking & Finance Healthcare Reporting & Automation
Certification
- SAFE – Agile DevOps, 2022
- MCP: Microsoft Certification on HTML5 and CSS3, 70 480
- MCP: Microsoft Certification on MVC, 70 486
- UC Berkeley Executive Education Data Science: Bridging Principles and Practice
- Part of Cognizant set Guinness World Records title for Vibe Coding generative AI hackathon
Timeline
Product Consultant -technical
Cognizant Technology Solutions
04.2020 - Current
Data Analyst
ASTIR IT SOLUTIONS
04.2018 - 03.2020
SQL BI developer
ASTIR IT Solutions
12.2016 - 03.2018
SQL Web developer
Tata Consultancy Services
01.2013 - 08.2015
Bachelor of Engineering -
Yeshwantrao Chavan College of Engineering