| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
EMAIL AVAILABLE Palmetto, FL, Street Address , US PHONE NUMBER AVAILABLEProgrammer Analyst II/ Technical Resources/ Data Analyst/Data Scientist/PLSQL DeveloperData Analysis / ManagementConversion Project DevelopmentDatabase Creation & ManagementData Analyst (2013-2023)Strong problem-solving banking issues, transaction and data quality issues by pulling logs and analyze it to see root causing issues by utilizing SPLUNK.Maintain and improve data qualityEstablish Data quality MetricsTo identify stale dataExcellent Data AnalyticsUnderstand and review Audit tableTo keep track of transactionsResearch ratio of data to errorsKey Stakeholder ManagementEffective CommunicationStaff Coordination & SupportPerformed ETL (2016-2019 FIS)Performed ETL (1999- 2003 Principal Financial Group)Experienced to utilize PL/SQLTo researchCareer ExperienceFIS, Saint Petersburg, FL 9/2013 to 2/2023Data Analyst / Programmer Analyst II / Technical Resource, Mobile BankingDesign complex data maps and for demonstrating methods of data populated. Write new business processes, including ETL, ACH or Bill Pay with raw data.Ensured the delivery of exceptional web-based banking services in alignment with FIS Mobile Online banking needs.Added, removed, and updated new features in staging tables (as requested by PM), populated staging tables with correct data, refreshed production tables, validated changes, and fixed errors to ensure smooth functioning of operations.Retrieved logs from Splunk and troubleshot issues, while assisting PM in day-to-day activities.Resolve issue if it is in my resource or assign issue to correct department and monitor until issue resolved.Served as a liaison between departments, while analyzing and resolving issues through JIRA.Performed a multitude of activities, such as writing custom PL/SQL and SQL code, refining maps through iterative validation, sharing data maps with programmers, simplifying scripts for non-technical personnel, and providing solutions relevant to each exception.Optimized customer satisfaction and retention by delivering phenomenal services, such as customizing software based on needs and specifications, reviewing conversion results (reports, balancing, data load, software changes) and managing revisions, and providing two weeks post-implementation support.Here is an example of Data management in ETL process.It is critical to identify records without Unique ID. Made sure Identify schema with each matching columns and I added extra columns if I found records with missing IDs while validating source data.Understand business requirement to set up test case and all tables werent in normalized at this time. Denormalized tables are easy to use for testers and PMs. They have access to most tables without using joins. Get all reports and count data and compare with source data. Meta data testing, Data transformation testing and quality of data. I closed test cases if test went well. I started investigating tables for normalization process. This would prevent bottle neck and made perform better if we expected high traffics. We tested again once initial data integration and table normalization done.This process repeated until We added all services. We assume main programs and Core worked fine for a week then We were done with initial implementation. FI went live and issues found and corrected. I started adding other services one at a time such as ACH, WIRE, BillPay or mobile banking etc. All data stored away or backed out until purge date.Data Scientist role: Certified Data Scientist (California State University, Fullerton 2018)ETL Developer: I have been an excellent Oracle PL/SQL developer. I can write oracle queries and perform data analysis in tables by executing multiple queries.I have been processed ETL, extract, clean, transform, load, and analyze.Utilize SQL LoaderI can analyze structured/Unstructured data and clean data with PowerShell.Denormalization / NormalizationETL testing process.Additional experience as Consultant and IT Analyst, Retirement and Investor Services Business Systems within diversified organizations.Such as Principal Financial Group, EDS, NCR.EducationData Science Certification, 2018 California State University, FullertonBA in Computer Science, Minor in Mathematics Coe College, Cedar Rapids, IowaTechnical SkillsStatistical Analysis, Data Modeling and Data Mining, Data Visualization, ETL, Data Integration, AI, HADOOP, NoSQL database, Machine Learning, DB2, SQL, PL/SQL Developer, PYTHON, Power BI, Minitab, PowerShell, Access, SharePoint, JIRA, Confluence, Rally, SplunkKYC Enterprise LLC, Tallahassee, FL 2011 to 2013Network ManagerDirected property renovation and operational upgrade, including configuring Cisco router, SQL Server, and backup server.Oversaw 60 PCs with a focus on enhancing / optimizing network performance.Offered technical support to three facilities in Florida and North Carolina and streamlined operations efficiently.Ramada Limited, Salisbury, NC 2003 to 2011General ManagerLed full-scope operations, including staffing, team leadership, guest satisfaction, and IT infrastructure.Boosted revenue over 75% by increasing RevPAR (revenue per available room), ADR (average daily rate) and GSI (guest satisfaction) scores.Spearheaded the management of rooms, marketing, and revenue generation departments, while administering property renovation and technology upgrade. |
