Erp Administrator/analyst Resume
4.00/5 (Submit Your Rating)
Westbury, NY
TECHNICAL SKILLS:
Operating Systems: Windows Servers, Linux Red Hat.
Suites & Applications: VB 5, VB 6, VB.NET, C#, MS Office, MS SQL Server 7 - 2014, BO Crystal reports 7-XI, SAP Crystal reports XI, Active Reports.
MS: Exchange, MS IIS, Terminal Services, MS VMM.
PROFESSIONAL EXPERIENCE:
ERP Administrator/Analyst
Confidential, Westbury, NY
- Designed and managed reporting procedures in Crystal Reports 8.
- Implemented business processes using WorkFlow at Infor Visual ERP.
- Created various stored procedures & triggers in SQL Server 2014 for ERP.
Business Analyst/Software Engineer
Confidential, Brooklyn, NY
- Performed a successful migration from POINT Force ERP to Dynamics AX.
- Administrated Windows 2008, IIS, FTP for entire organization.
- Implemented modifications to various reports in Point Force (Crystal Reports).
- Designed and implemented an application for UPC scanning in a receiving process at warehouse (C# VS 2017, T-SQL).
Corporate Reporting and Database Developer
Confidential, Brooklyn, NY
- Ran a migration project from QB to SAGE 300 ERP systems.
- Was responsible for creating reports using Crystal Reports XI SAP.
- Implemented various sales reports involved in “Day End” and ” Week End “ operations.
- Implemented stored procedures on SQL 2014 for interactions between SAGE DBs.
IIS Admin/SQL Server Developer
Confidential, NJ
- Built and maintained a corporate website on IIS.
- Was responsible for creating of financial reports on Crystal Reports XI BO using CR Universe, SQL Queries, SQL stored procedures.
- Created a scheduled backup and replication processes on SQL 2012.
Senior Systems Engineer
Confidential, New York, NY
- Managed a Merchant Processing Portal hosted on IIS.
- Developed and implemented a fully functional CRM system using VB6 and SQL.
- Built and supported a Data Center for more than 500 users.
- Managed SQL databases (SQL 2000, 2008) holding daily transactions for over 30,000 clients.
- Built and Managed VoIP network with Cisco 7900, created phone usage reports based on Cisco Call Manager and BO Crystal Reports XI.
- Produced a merchant statement distribution system based on Crystal Reports XI server.
- Created and implemented Gift Card Statement using WEB Intelligence of Crystal Reports XI server BOE.
- Collaborated with migration team and other business groups to accomplish a successful migration task.
- Ensured Daily Backups were successfully completed.
- Implemented automation Powershell & VB Scripts to reduce administration overhead of Windows Servers, Active Directory.
Systems Engineer
Confidential, New York, NY
- Responsibilities included SQL server, IIS Web Server, Windows 2003 administration
- Designed and implemented a DB of auto parts for web sites running on IIS.
- Created and implemented an order and invoice system based on Crystal Reports 8.
- Rolled out and administrated Exchange 2003 in a clustered environment.
- Built a complex 4 cluster system of SQL servers.
- Built and administered 2000 servers and an NLB web server cluster.
Software Developer
Confidential, New York, NY
- Designed and developed user applications using VB 5 and VB 6.
- Created a “conflict report” on Crystal Reports 7.