| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidate Top of FormCandidate's Name
Street Address Shonan Gold DrWinter Garden, FL Street Address
Phone PHONE NUMBER AVAILABLEE-mail: EMAIL AVAILABLEObjectiveSeeking a career opportunity that will maximize my technical abilities and, other transferable skills; which includes problem investigation with focus on solution design , implementation and database Management.
EducationMajor: Information System Management (MISM)
Professional ExperiencesAlight Solutions (August 2021 Current)ETL Manager Lead a team of 10 (4 Onshore and 6 offshore employees). Coordinated activities among business stakeholders, ETL developers, Scrum Master and Product Owner Lead the team in migrating entire ETL infrastructure (informatica, Unix Servers, SQL Databases) during company s acquisition from AON to Alight Held weekly meetings with Senior Management advising of any work impediments as well and ETL status updates. Responsible for Hiring new ETL developers Partnered with Scrum Master during scrum meetings and grooming sessions, ensuing workload is evenly distributed among ETL developers Played an integral part in Informatica upgrades from on Prem to IICS and CRM Dynamics 365
Florida League of Cities (January 2016 August 2021)Lead ETL Developer In-charge of all the leagues ETL Development, loading data to both SQL Server and cloud based MYSQL platforms. In charge of designing and updating existing Data Warehouse dimension, fact tables, ETL flow from source to target DataMart's, with the aid of python scripts, custom TQSL scripts as well as SSIS dataflow transformations for Type 1 and 2 slowly changing dimensions. Administrator of all SSRS Reports from development to deployment to report server, using Visual studio 2013/2016 platforms. Created custom reports, mobile reports, KPIs, Paginated reports with the aid of SSRS Report server 2016 and Tableau Modified and created SSIS packages to facilitate existing Data Warehouse, with the aid of custom T-SQL. Automated numerous processes with the aid of SSIS, stored procedures, SQL Server jobs. Data Mining and extraction from websites, PDF, databases with the aid of PythonInstitute of Internal Auditors November 2014 - November 2015Senior ETL Developer (contractor)
In charge of Updating existing ETL flow into existing Data Warehouse and created new Fact and dimension tables based on business requirements Created and modified existing stored procedures, views, functions Created ETL packages utilizing SSIS and Simego Administrator of Logi Analytics (BI Tool) Main ETL Developer, responsible for migrating data from the company s existing platform Netforum to CRM Dynamics, utilizing custom built stored procedures, views and ETL packages (Simego ETL Tool) Created customized SSRS and Logi Analytics Reports Modified CRM Dynamics Workflows
CNL Dec 2013 - November 2014
Senior ETL Developer (contractor) Responsible for Business Intelligence Projects Automated data flow for Oracle to SQL 2012, with the aid of SQL Server Integration Services 2012(SSIS) Created customized stored procedures within the transformation process from both Oracle and Salesfoce to SQL Server 2012. Automated data flow from Salesforce to SQL 2012, with the aid of SQL Server Integration Services 2012(SSIS) Responsible for the maintenance of current COGNOS reports, by ensuring that they are delivered to senior executives, in a timely manner Created adhoc reports based on customer s and business needs, with the aid of SQL Reporting Services 2012 Updated and maintained Financial Data Marts and existing Data Warehouse
Universal Orlando Resorts August 2013 - Dec 2013(contractor)Senior SQL Analyst Created adhoc queries, stored procedures, functions & views Created SSRS reports (Business Intelligence studio) Automated existing processes Established connections between Excel and SQL Server 2010 with the aid of VBA programming Marketing and CRM Analysis
Avatar International June 2012 - August 2013Senior Systems Analyst Tracked incoming data files and analyzed receipt dates and content to ensure no gap in surveys fielded. Ensured that all data files are processed and that the system converts information into customized surveys. Reviewed output of survey generation process to determine if all parameters have been properly executed. Corrected any discrepancies identified before surveys are fielded whenever possible. Worked with client to resolve any system or data file issues. Generated ad hoc reports for clients. Executed client survey design change requests Administrator for ETL tool Pervassive. Modified existing workflow processes and maps. Created and customized numerous Excel user forms, utilizing ADOB connection strings that connects to SQL SERVER 2010 database, and retrieves information with the click of a button. Created batch scripts for automation purposes
Reed Elsevier (MeDai) April 2010- February 2012Senior Applications System Analyst Analyzed and problem-solved new data issues (flat files and HL7 Medical Data) through modification of current programs or creation of new programs to correct errors that conforms to client-specific requirements. Validate and assure data integrity, communicating results to Production Manager with appropriate escalation, where required Updated existing programs and process documentation within various test environments, as dictated by modified client requirements.. Maintain and enhanced quality assurance efforts to support client needs Expert at meeting client-directed deliverable requirements, timelines and established priorities for ongoing monthly and/or quarterly deliverables. Designed and Administered Department's Sharepoint site Member of implementation and software testing teams Automated daily processes utilizing BATCH programs on a Windows platform. Excellent planning and decision making abilities. Trained and provided guidance to junior analyst. Lead numerous impementation projects Used data tools such as DME Express, Data Junction,Putty, SQL PLUS WORKSHEET, SQL PLUS,Sharepoint 2007, Salesforce,Cloverleaf, SSRS,SSIS, and other proprietary reporting tools to accomplish assignments.
LexisNexis Boca Raton, Fl June 2005 - April 2010Senior Data Production AnalystPerformed extraction, transfer and load processes (ETL) defined for data sets through a production system using various types of automated and manual processes. Duties include Monitor daily production jobs to ensure successful completion. Identify and report layout changes to ETL team for development needs, escalating appropriately to maintain currency metrics. Maintain Currency and Quality metrics set on annual basis Perform standard quality processes as part of daily processing of data sets. Review transformation statistics and load process logs to verify the success of data processing. Performed independent and detailed data quality analysis on current or new processes Participated in analysis of issues and gave recommendations to ensure that the highest level of data quality is presented.Used data tools such as Informatica , Sync-Sort, Data Junction,TOAD,Putty, Test Director and Bugzilla, Linux and Unix environments in daily processing on Oracle platform (Oracle 10g)
PHH ARVAL/First Fleet (contract) Ft Lauderdale Fl Jan 2005 - May 2005Data Mapping Analyst Designed a tool which captured the client's data structure Designed a tool which captured code Database values, extracting data from current system using MS Access SQL statements And SQL SERVER 2000. Design methods of performing data mapping between databases. Created SQL views. Implemented tasks related to document controls within databases. Identified the controls within databases. Devised methods to compensate for a deficiency between current systems Created an automated tool to search for customer records with the aid of Microsoft access forms. Assist in testing software applications. Used data tools such as SQL SERVER,SSRS,SSIS, Microsoft Access
Spherion Corporation Ft Lauderdale Fl, June, 2002 - December 2004Senior Configuration Analyst Maintained and configured internal databases. Implemented and provided support for Client Resource Center &Customer Configuration automated forms with the aid of Visual Basics Editor,& Microsoft Access. Design and configured interactive recruiters workbench automated forms(Microsoft Access). Liaison between company s corporate offices and field executives. Monitored major accounts. Implemented and assigned Customer Workflows. Resolved all issues with payroll discrepancies, and provided feedbacks to upper management.Used data tool such as SQL SERVER and other in house tools .
AccomplishmentsParticipated in the development and implementation of Recruiter's Workbench (an enhanced tool developed to assist employees in finding potential employees for clients. Workflows were created according to the customer s blueprint). Automated workflow ids were generated using this tool.Developed and Implemented automated form, utilized by over 700 field offices, this allowed for the creation of new customer accounts, monitored and updated existing customer accounts, and change status from prospect to regular. Form completion was with the aid of visual basic programming language and the manipulation of excel spreadsheets. In order to track the customer s history, a database was also created (Microsoft access).Member of the PROVADE Configuration Team
Bellsouth (TAG Answer Group) Ft Lauderdale, FL -March 2002-Nov 2002Technical Support Engineer Monitored and resolved hardware and software issues Troubleshoot Dialup Networking, Windows 98, 2000, XP, ME Implemented and managed customers accounts with DSL service Assisted customers with basic computer issues
United States Marine Corps Okinawa, Japan January, 1997- August, 2001Supply and Administration (NCO) Supervised and Managed over 20 Marines Processed and ordered supplies Coordinated shipments of supplies for the entire West Region (50,000 Marines) Supported the overall objective of the United States Marine Corp
Computer SkillsProgramming Languages: Visual Basic, C++, SQL SERVER, batch scripting, PythonSoftware: Microsoft Excel, Microsoft Access, Microsoft Project Manager, Pervassive Data Integrator, Salesforce, SSIS 2012. SSRS 2012/2016, COGNOS,SIMEGO, Logi Analytics, Python, Jupyter Notebooks, ATOM, TableauOperating Systems: DOS, Windows 95, Windows 98, Windows 2000, WindowsME, Windows XP, Linux, Unix, Informatica, Pervasive, Data JunctionOracle platform, Sharepointe
References available upon request
Bottom of Form |
