Sunil Panchal

SUNIL PANCHAL AHMEDABAD, INDIA 382350 |- |- Professional Summary Amiable Technical Lead ready to rapidly onboard new personnel and kick start new projects. Achieves rapid and exceptional completion metrics through careful utilization of available skills and technical assets. Assembles effective teams by exploiting complementary competencies and collaborative employee relationships. Skills SSRS,SSIS, SQL Server 2019, VB.NET Automation methods WPF, Web Services, WCF,WPF Good telephone etiquette Microsoft Office Interpersonal Communication Systems Development Lifecycle Management Good listening skills Agile Methodology Planning and Coordination Functional requirements understanding Teamwork Data acquisition Analytical skills Work History Technical Lead Medusind Solutions India Pvt Ltd May 2019 - Current Ahmedabad, India Worked in SSIS to extract data from Text,CSV and Excel Files to Sql Servers with different transformation controls. Worked on SQL server and SSRS Reports Mapped data between source systems and warehouses. Served customers in friendly, efficient manner following outlined steps of service. Exceeded goals through effective task prioritization and great work ethic. Completed quality reviews for designs, codes, test plans and documentation methods. Planned and arranged meetings with external organizations and individuals, enabling all parties to meet and discuss project progress. Managed implementation of medical administration software. Identified innovative and automated approaches to routine tasks, making suggestions that were widely received. Gathered requirements, defined scopes, allocated resources and established schedules meeting or exceeding project demands. Maintained complex T-SQL queries, views and stored procedures in multi-database environment with little supervision. Developed, implemented and optimized stored procedures and functions using T-SQL. Designed and developed customized extract, transform and load (ETL) applications per client specifications. Followed standard practices for migrating changes to test and production environments and provided technology support to meet business requirements. Drafted data mapping documentation for relational databases to establish standardized formats. Investigated and addressed system issues to enhance usability and improve functionality Software Analyst May 2017 - Apr 2019 Medusind Solutions India Pvt Ltd Ahmedabad, India Completed software development lifecycle from requirement analysis to test planning, test case development and test execution. Designed, developed and integrated software solutions based on business requirements and objectives. Collaborated closely with upper management to drive strategy through development and implementation of new processes. Analyzed existing systems and databases and recommended enhancements to solve business needs Troubleshot incidents reported by end-users to schedule system changes and identify permanent solutions. Senior Programmer May 2015 - May 2017 Medusind Solutions India Pvt Ltd Ahmedabad, GJ Worked on Windows projects with VB.NET and WPF with web services and WCF with SQL Server Database Documented technical workflows and knowledge transfer documents for newly hired employees. Led group of 2 trainee engineers in design and development of Windows -based software solutions. Collaborated with developers and performance engineers to enhance supportability and identify performance bottlenecks. Trained and managed team of developers and discussed issues in order to provide resolution and apply best practices. Authored code fixes and enhancements for inclusion in future code releases and patches. Performed regression and system-level testing to verify software quality and function prior to release. Senior System Analyst Apr 2014 - Apr 2015 Medusind Solutions Pvt Ltd Ahmedabad, India Worked closely with business users and business analysts to understand functionality and propose creative solutions to meet business needs. Analyzed existing systems and databases and recommended enhancements to solve business needs Worked on Abbyy Flaxi capture studio to extract data from PDF file. Worked on SSIS and SSRS reports Programmer Jun 2011 - Mar 2014 Medusind Solutions India Pvt Ltd Ahmedabad, India Worked with software development and testing team members to design and develop robust solutions to meet client requirements for functionality, scalability and performance. Worked on Crystal Reports Worked on Workorder allocation project with VB.NET and SQL Server with Dev express UI controls Identified and suggested new technologies and tools for enhancing product value and increasing team productivity. Interfaced with cross-functional team to determine comprehensive list of requirement specifications for new applications. Coordinated technical requirements for projects with internal and external stakeholders. Prepared detailed reports on updates to project specifications, progress, identified conflicts and team activities. Trainee Programmer Feb 2010 - Mar 2011 Medusind Solutions India Pvt Ltd AHMEDABAD, INDIA Developed Windows programs using programming languages such as VB.NET and C#. Developed in-house applications designed for company needs. Worked on Data extraction projects from PDF,Web and Text Files Debugged problems caused by hardware, operating systems software, application programs and network failures. Actively listened to customers' requests, confirming full understanding before addressing concerns. Education BCA: Computer Application Jun 2009 Gujarat University Ahmedabad Languages Gujarati: Native language Hindi: Proficient C2 English: Upper intermediate B2