Candidate Information Title Sql Server Ms Target Location US-GA-Cumming Email Available with paid plan Phone Available with paid plan	20,000+ Fresh Resumes Monthly     View Phone Numbers     Receive Resume E-mail Alerts     Post Jobs Free     Link your Free Jobs Page     ... and much more Register on Jobvertise Free
Search 2 million Resumes Keywords: City or Zip:	Related Resumes Systems Engineer Sql Server Duluth, GA Data Engineer Sql Server Alpharetta, GA .Net Developer Sql Server Atlanta, GA Software Engineer Sql Server Acworth, GA Power Bi Sql Server Cumming, GA Sql Server Disaster Recovery Lilburn, GA Solutions Architect Sql Server Atlanta, GA

HEMAPRIYADHARSHINIAlpharetta, Georgia. Mobile PHONE NUMBER AVAILABLEEMAIL AVAILABLEDB Analyst cum ETL DeveloperResults-oriented professional with 6 years of experience in the IT industry, specializing in database programming using MS SQL Server, SSIS, and SSRS. Highly proficient in writing efficient and optimized T-SQL queries, stored procedures, triggers, functions, views, and cursors. Experienced in analyzing complex data requirements, designing scalable database solutions, and developing robust applications. Skilled in installing, configuring, and deploying the MS SQL Server suite of products, with a strong focus on Business Intelligence using SQL Server Integration Services (SSIS). Expertise in handling diverse data sources, including flat files, Excel spreadsheets, and OLEDB connections. Demonstrated ability to create advanced SSIS packages for seamless data extraction, transformation, and loading processes. Proven track record of generating insightful and visually appealing reports using SSRS, enabling data-driven decision-making.TECHNICAL SKILLSPlatform : MS SQL Server 2016,2022Languages : SQL, Transact SQL 2012,2016,2022Tools & Utilities : SSIS, SSRSEducationBachelor of Technology (Information Technology), Anna University, ChennaiMaster of Engineering (Computer Science and Engineering), Anna University, ChennaiHIGH LIGHTSExtensive experience in developing BI solutions for various types of projects, including data migration, data integration, data conversion, and data mart projects, used a variety of tools such as SSIS and SSRS to successfully deliver these projects.Providing a top-quality solution to Data Engineering, Solution Architecture, Design, and Deployment.Significant experience in working with customers, project managers and technical teams for executing multi-vendor projects.Experience of leading Governance/Status Report meeting.PROFESSIONAL EXPERIENCEProject 1Title : HCPCS (Healthcare Common Procedure Coding System)Role : Senior Software Engineer/Lead AnalystDuration: 10 MonthsTeam Size: 8Technologies: SQL Server 2012/SSIS 2012Architecture Details  MS SQL Server 2012, SSIS, T-SQL, DTSXHealthcare Common Procedure Coding System (HCPCS) coding system is used primarily to bill Medicare Part-B for supplies, materials, injections, various services and procedures that may or may not be defined in Current Procedural Terminology (CPT).About HCPCS Processor Integration:PharmPix is currently processing few Medicare Part-B claims using manual crosswalk of HCPCS-NDC code. PharmPix wanted to automate this process of mapping HCPCS/J-codes and NDC-UPC-HRI codes for processing its drug claims to its Medicare Part-B beneficiaries. Health plans such as MCS and CareMoreRx, sends claims using NDC-UPC-HRI codes to PharmPix which should be mapped to appropriate HCPCS/ J-code through this automated mapping process using SSIS package.Key ChallengesUnderstanding about Entire database architecture and entity relationships and learning aboutAdapting of the newer version of DTSX Packages and implementing the same.Responsibilities:Writing SQL queries and stored procedures to retrieve and manipulate data efficiently.Creating SSIS packages to extract, transfer, and load data into the data warehouse on a daily basis.Developing robust processes to extract, cleanse, transform, and integrate source data into the data warehouse.Identifying areas for improvement and implementing process enhancements to optimize performance and prevent defects.Engaging in regular communication with clients, providing updates on assigned tasks, and actively participating in meetings.Conducting thorough root cause analysis to investigate and resolve production issues, ensuring system stability and reliabilityPrimary Contribution:Implementation and testing of DTSX packages.SSIS packages deployment and automated jobsProject 2:Title: APPLIED MATERIALSRole: Senior Software EngineerDuration: 10 MonthsTeam Size: 2Technologies: SQL Server 2012/SSIS 2012Architecture Details  MS SQL Server 2012, SSIS, T-SQL, DTS, DTSXApplied Materials is a strategic partner and an enabler of the semiconductor and solar manufacturing ecosystem in India, and works with various stakeholders towards enabling a robust semiconductor and solar manufacturing ecosystem. The reports are the final output that are generated from AMAT Application systems (AMCBMS, AMCWFP) used to get the reports from its applications and transfer to some other shared locations of the AMAT engineers to review about their business logics.Key ChallengesGaining a comprehensive understanding of the existing DTS Packages, analyzing their functionality, and redesigning packages as needed.Acquiring knowledge of the entire database architecture, including entity relationships, and adapting to the newer version of DTSX Packages for seamless implementation.Responsibilities:Proficient in writing SQL queries and developing stored procedures to ensure efficient data retrieval and manipulation.Utilized T-SQL to create Tables, Views, and Stored Procedures, ensuring optimal database performance.Created and configured SSIS packages to extract, transfer, and load data into the data warehouse on a daily basis.Developed robust processes for extracting source data, performing data cleansing, transformations, and integration before loading it into the data warehouse.Extensively involved in designing SSIS packages to handle diverse data sources (e.g., Excel, CSV, Flat file) and efficiently transfer data to staging tables in the SQL Server Database.Proactively identified opportunities for process improvement and implemented preventive measures to minimize defects and enhance overall efficiency.Maintained regular and effective communication with clients, providing updates on assigned tasks and actively participating in meetings to address project requirements.Conducted thorough Root Cause Analysis for Production issues, identifying underlying causes and implementing appropriate solutions to prevent recurrence.Primary Contribution:Implementation and testing of DTSX Packages and jobsHandling production support issues of the dtsx packages and automated jobsProject 3:Title : Call Center ApplicationRole : Software EngineerDuration: 16 MonthsTeam Size: 8Technologies: SQL Server 2012/SSISArchitecture Details - Architecture is based on Microsoft .Net (MS SQL Server 2012, SSIS, T-SQL and DTSX)SPSS is a third-party tool used by Nielsen call center for surveys on TV/Radio, Hollywood Movies, and Sports. The surveys generate extracts for another application to retrieve related data. Reports from SPSS provide survey ratios for end customers. Our application automates data extraction and report delivery by directly pulling data from SPSS and SQL Server, ensuring accuracy and efficiency. Job failure notifications help us quickly identify and resolve any issues during scheduled runs.Key ChallengesUnderstanding and analyzing requirement of creating new DTSX PackagesLearning and using various SSIS transformation, expressions and variables according to project requirements.Responsibilities:Clarify and Grasp the Business Requirements specified by the clientsBased on the Business Requirements, perform a System Analysis to identify the System Impact and Scope of DevelopmentExtensively involved in designing the SSIS packages to export data of heterogeneous data (like Excel, CSV, Flat file) source to tables in SQL Server Database.Code Walkthroughs, Code Reviews, Technical Design Reviews and Test Case Reviews and Defect Causal Analysis for Testing DefectsInvolved in communication with the client directly on daily basis on the task assigned and also in the meetingsInvolved in development of SSIS Jobs and Scheduling jobs of the SSIS Packages.Root Cause Analysis for Production issues.Involved in communication with the client directly on daily basis on the task assigned and also in the meetingsPrimary Contribution:Implementation and testing of SSIS Packages with required SSIS dataflow and control flow data transformations.Handling production support issues of the DTSX packages and automated jobsProject 4:Title: PS PrintRole: Software EngineerDuration: 16 MonthsTeam Size: 11Technologies: SQL Server 2008PsPrint is a famous and reputed online store that prints postcards, business cards and many more. They even offer a number of other online printing services. PsPrint prints amazing brochures, calendars and business cards just for their valued customers. The design tool available online makes it possible to create and innovate Customers own designs in not more than some minutes. The PsPrint code is attached with all their products. Customizable templates are also available at the website.Key ChallengesUnderstanding and analyzing requirement of creating new stored procedures and functions.Responsibilities:Involved in requirements gathering, analysis, design and development.Written various stored procedures for the purpose of application development.Designed and implemented data access stored procedures and triggers for automating tasks.Creating reports and hosting it in the web for the users.Created reports for the senior management.Successfully tested all the stored procedures on SQL 2008 server.Primary Contribution:Implementation and testing of MS SQL Stored procedures and functions.Writing of queries to provide various test case scenarios.Project 5:Title : Word of ChristRole : Software EngineerDuration: 8MonthsTechnologies: SQL Server 2005The Project has been designed for the Trust Word of Christ, Chennai. The trust Word of Christ decided to take up the WOC (Word of Christ) Project to sell Christian Books, DVDs across India through Online Shopping. WOC categorized into two types of Webpages. The first one is Static Page. It is used to make on Line Book Selling Process across Indian Customers. The Another One is WOC Application Page is designed to make Transactions (Sales and Purchase of Books) between Main Branch and Various Sub Branches involved under the trust across the India.Key ChallengesUnderstanding and analyzing requirement of creating new stored procedures and functions.Responsibilities:Web page designingCoding using ADO.NetWriting Sql queries and Stored proceduresSuccessfully tested all the stored procedures on SQL 2005 server.Primary Contribution:Implementation and testing of MS SQL Stored procedures and functions.Writing of queries to provide various test case scenarios.Project 6:Title: DMS (Dealership Management System)Role: Software EngineerDuration: 15MonthsTeam Size: 3Technologies: SQL Server 2005Technologies - SQL Server 2005Architecture Details - Architecture is based on Microsoft .Net (MS SQL Server 2008 and T-SQL).TVS undertook the "DMS (Dealer Management System) Project" to benefit dealers nationwide. DMS facilitates business growth through improved enquiry conversion, sales promotion, inventory management, and customer insights. It enhances productivity by eliminating time wastage, report inconsistencies, and data duplication. DMS provides a competitive edge by detecting customer leakage and analyzing financial schemes, while also enabling customer database management for loyalty programs and attracting new customersKey ChallengesUnderstanding and analyzing requirement of creating new stored procedures and functions.Understanding entire database architecture of various dealership databases.Responsibilities:Involved in requirements gathering, analysis and development.Written various stored procedures for the purpose of application development.Tuned Stored Procedures.Created many complex Stored Procedures used them in Table Reports.