Lakshmi KONDAPALLI

Having 15+ years of total IT experience involving in Analysis, Design, Development and Implementation using Microsoft Technologies 10+ years of comprehensive experience encompassing Microsoft SQL Server 2008/2012/2014/2016,MSBI Suite of products(SSIS,SSRS,SSAS) as SQL Developer and Business Intelligence Developer using OLTP/OLAP/BI environments As a lead technical consultant, gained experience in Full software Development Life Cycle(SDLC) in implementation and supporting projects for retail, banking and insurance industries Expertize in Software Development, Design, Development, Customization, Testing, Implementation & Support of Microsoft based applications, Data Modeling and ETL Design Excellent in Application architecture and design, Development of stored procedures, Triggers, Packages, TYPE Objects, Cursors, REF cursors, T-SQL Development Designed and Developed efficient SSIS packages for processing fact and dimension tables using transformations like Fuzzy look up, look up, merge, merge join, script component and slowly changing dimension. Documented ETL process Design based on business requirements and system specifications with strong ETL design skills, including source to target mapping, transformations, look-ups, aggregations. Experienced in creating configuration files, error handling, logging, deploying and execution of packages in various environments like development, testing and production. Deft in implementation of Data warehouse methodology, schema designs like Star schema and Snowflake Schema etc. Having Good knowledge on Inmon and Kimball data warehouse methods Strong knowledge and real time working experience in Logical and Physical data models (Relational). Having good knowledge in T-SQL for developing complex store procedures, triggers, tables, views, user defined functions, SQL Joins, Relational database models and data integrity. Demonstrated strengths in troubleshooting, root cause analysis, resolving complex technical problems, utilizing advance tools and resolution procedures, isolating product defects, and providing product enhancement opportunities Deft in Database creation and performance tuning and triggers, analyzing performance impact of SQL statements, query optimization, Tuning, ETL Optimization. Deft in SQL Server Database Performance Tuning and Query Optimization using various types of Hints, Partitioning, and Indexes Experience in writing detailed technical specifications for developers; design, validate and execute software test plans Proficient in current programming language and technologies, writes code, completes programming, and performs testing and debugging of applications Dexterous in software development using SSIS ETL tool, Unix Scripting, Data modeling using Erwin, Job monitoring and maintenance with Control-M,ESP, MS SQL server DB programming, MSBI, Data Warehousing(DW) & OLAP concepts Demonstrated experience in creating/implementing database architecture for new applications and enhancements to existing applications Adept in Azure Fundamentals, AWS Fundamentals , Python, Git Bit bucket & SVN Repositories Currently Pursing new technologies such as AWS, Data bricks, GEN AI Strong knowledge of database architecture and best practices for T-SQL coding style and application tuning Skilled in Sql Server Management Studio, MSBI (SSIS, SSRS, SSAS),Toad, Erwin, Version Control tools etc. Capable to operate effectively in ambiguous situations Ability to learn quickly, manage work independently and good team player Familiar with Agile software development methodologies to ensure the early and continuous delivery of software Exposure to working in a global client based environment for 5+ years in USA

• Certificate of recognition for EIT projects as good team player
• Gained Certificate of recognition from Transamerica Client for good performance
• Achieved Certificate of recognition for IDI Commission implementation project
• Certificate of recognition from NYL client for good performance