Candidate Information | Title | Sql Server Software Development | Target Location | US-NC-Waxhaw | | 20,000+ Fresh Resumes Monthly | |
|
|
| | Click here or scroll down to respond to this candidateSummary10 years of total experience in software industry.5 years of experience in data analysis, reporting, design, and visualization of data to drive business actions using Tableau, Alteryx, and SQL Server.5 years of experience in software development and testing of EFT banking application CONNEXTM Tandem Advantage to support ATM and POS terminals, authorization, network monitoring, transaction routing and card processing services.Led efforts of several Tableau dashboard development projects including defining metrics, dashboard design and creation, data modeling, deployment and maintenance to support business stakeholders.Creating high quality interactive dashboards to effectively tell a story for various audiences using the right charts to represent data.Experience in collaborating with instructional designers, HR Business Partners and Leaders, and business stakeholders from cross functional teams to understand, collect and translate their requirements into actionable dashboards and reports.Writing SQL Scripts/Alteryx Workflows.Experience with ETL processes.Experience in analyzing and interpreting large volumes of employee and HR training data.Establishing data processes for quick reporting.Automate processes as required.Experience with testing APIs and designing tables from API data in Hadoop.Experience with Cornerstone, Xyleme, Mindmarker, PeopleSoft Applications.Developed documentation including project scope documents, design documents, process documentation, guidelines, templates, and user manuals.Adaptability to take on projects single handedly as well as be a team player based on team needs and requirements.Combination of technical skills with good understanding of business processes.Ability to quickly learn new technologies, applications and concepts as needed.Good communication and presentation skills for sharing business insights.Passionate about data and very organized.Technical SkillsData Visualization/Reporting ToolsTableau Desktop, Tableau ServerData Processing ToolAlteryx DesignerDatabasesMS SQL Server 2017, MS Excel, TeradataData Lake TechnologyHadoopAPI PlatformPostmanDatabase Management ToolsDbeaver Enterprise 22.2.0Tandem testing toolsMC Debit Financial Simulator 6.1, MEAS Simulator 7.2, FINSIM, IBM CrosscheckOperating SystemsNonstop Kernel, MS Windows, UNIXCertificationsCertified Tableau Desktop Qualified Associate (expired Oct-2020)Work HistoryBusiness Intelligence Analyst, 01/2024 to currentCharter Communications Charlotte, NCResponsible for querying and reporting on Charters Construction data stored in Teradata database.Responsible for working with business stakeholders to analyze Charters Construction Performance and ROI in serviceable areas.Performed address mapping and location analysis to solve business questions.Created KOMs (Key Operating Manuals), user guides, data flow documents and presentations to provide detailed insights into the features of the business product and service..Data Analyst, 04/2019 to 12/2023Charter Communications - Charlotte, NCResponsible for writing SQL Scripts / build Alteryx workflows to extract and process data, define metrics, and design and develop Tableau dashboards for Corporate HR Learning Solutions for business consumption.Designed and developed a successful dashboard product Audience Analysis with insights to enable business leaders to devise learning strategies for various audiences in the company singlehandedly.Experience in creating payroll reports. Developed strategy and built Alteryx Workflow and automated it to run biweekly to send training completion reports to payroll for bonus payouts. Handled duplicate removal, application issues, provided solutions and supported business stakeholders with employee queries. Provided error free reports leading to both business and employee satisfaction.Responsible for extracting and loading data from raw csv files to SQL Server Database for Mindmarker application.Identified automation opportunities in projects and converted SQL Scripts to Alteryx Workflows to automate processes to achieve less human interference by saving time and efforts.Experience with API testing. Using Postman, tested Cornerstone and Mindmarker API endpoints to analyze and validate data.Was responsible for analyzing, validating and transforming data, coding, and designing tables in Data Lake (Hadoop) from API data for Mindmarker application.Was responsible for pulling variance reports between Cornerstone and Mindmarker applications to help stakeholder spot application issues and initiate action.Was responsible for identifying and providing documentation for PI (Personal Information) and SPI (Sensitive Personal Information) in the data stored in applications (SQL Server, Plural Sight, Kaltura Media Center, Xyleme, AWS, Mindmarker) used by Charter Learning Solutions for Data Privacy Project for the Legal Counsel.Collaborated with Instructional design team to test and determine data formatting for eLearning course in SCORM format into LMS.Reviewing ESG/CHRO quarterly reports.Data Structuring/Data ModelingAd hoc reporting.Cornerstone reporting.Tableau skills include creating parameters, calculated fields, bins, groups and hierarchies, geographical maps, trendline, forecasting, clustering, various charts including heat maps, box and whisker charts, scatter plots, pie, donut and bar charts.Senior Software Engineer, 2003 to 2008E-funds, IndiaResponsible for designing, validating, and executing test cases for troubleshooting EFT application CONNEXTM Tandem Advantage.Responsible for configuring database in preparation of test environment to perform functional and regression testing.Responsible for Switch maintenance.Member of team that was involved in converting Advantage V1.4 to V1.5 Switch conversion activities including CED file conversion and testing utility programs.Validation of PIN, CVV/CVV2 requests.Tested EMV (chip card) authorization requests to validate cryptographic requests related to PVV, CVC/CVC2, ARQC validation and ARPC generation.Configured FINSIM test tool to the switch and executed a variety of ATM/POS transactions to research on different kinds of CO-OP transactions the test tool supports.Performed User Acceptance testing of ATM/POS transactions for CO-OP network. Quickly identified and resolved database setup issues successfully within the timeframe of call duration.Mentored team members on user acceptance testing process, client interaction and communication skills.Designed and Developed web-enabled application Facilities Management System using ASP 2.0, VB Script, JavaScript, HTML, DHTML and SQL Server 7.0 Database.EducationMaster of Science in Computer Science Madurai Kamaraj University, IndiaBachelor of Science in Computer Science Manonmaniam Sundaranar University, India |