SUMMARY:

• A well - grounded database administrator, with outstanding skills in computer programming.
• Expert in SAS, PL/SQL, SQL, TSQL, Oracle, VB, C++, RDBMS, Visual Studio(.Net,2005,2008,2010,2012,2013).
• Proventrack record as a DBA in both production and development environment.
• Possesses broad based and in-depth knowledge of complex technologies, tools, methodologies, the software industry.

COMPUTER SKILLS:

Over 15+ years of experience in: ERP Development/Implementation/Support. Specialist in Microsoft Dynamics NAV, Microsoft SQL Server, Application Development, VB.Net, C#, COBOL programming, Prologue Programming.

Languages: PL/SQL, SQL, TSQL, Oracle Express/Forms/Reports /Workflow, VB, VB.Net, C, C++and VC++.

Operating System: UNIX, Linux, Windows 9x/NT/XP/2000/2003 server/Vista/7, 8, 10, OS/2, MSDOS.

RDBMS/DBMS: Oracle 9i, 10g, 11g, MS SQL 2000/2005/2008/2012/2014/2016 , MS Access 2/2000, IBM DB2

MS SQL Tools: T-SQL, ANSI SQL, DTS, SSIS, SSAS, SSRS, SQL Server Management Studio, Configuration Manager, Enterprise Manager, Query Analyzer Profiler, SQL Server Agent, Database Engine Tuning Advisor and Reporting tools.

Other tools: MS Office suite, MS Visio, Crystal reports, MIS Reports, TFS and Visual Studio.

SAS base and Advanced programming/ SAS macros: SQL Server programming/ SQL Server 2000, 2005, 2008, 2012, 2014, 2016 Programming, Visual Studio(.Net,2005,2008,2010,2012,2013) Programming, Programming in Microsoft windows environment, MS-PowerPoint, Ms-Word / EXCEL, Pivot Tables.

WORK EXPERIENCE:

Sr Software Developer

Confidential, Atlanta

Responsibilities:

• Development of processing software and automating the sales management process.
• From quotation to invoicing and chaining effectively the logical steps of the administrative circuit and mastery of traceability (quotes, orders, invoices, delivery notes, have) .
• Develop, a software to manage the payroll of the company using the tools of MS Visual Studio 2012, VB.net,Sql Server Management studio 2016, Cristal Report 2010.
• Experienced in object-oriented programming; developing, testing and debugging code, designing interfaces and administering systems and networks.

IT Manager and Database Administrator

Confidential

Responsibilities:

• Maintenance of database, monitoring and support. Maintains the health of the supported databases. Provides recommendations of experts for future growth with the ability to work on multiple operating systems and hardware platforms.
• Management platform, focusing on the analysis, storage and ingestion of large amount of information.
• Construction and optimization of data models, implemented physical data page, configuration, optimization and monitoring of RDBMS and Hadoop and efficiency circles treatment overall improvement to meet the needs of the company.
• Performs and validates the database, backup/restore management and configuration backups. Develop policy and procedures standardized for acceptance documents.
• Experience in the construction of Business Intelligence platforms in an enterprise environment. Analyse data using SQL OLAP, MicroStrategy technology.
• Integration of data (batch, micro, real-time data streaming) on Hadoop, RDBMS, and data warehousing.
• Created and blinded history dated on the UNIX server using SAS and SQL to create, manage and publish programming tables and queries in SQL Server Management studio.
• Use of CRYSTAL Reports. Developed high performance automation applications using Microsoft tools. Migration of Server SQL Server 2005 to SQL Server 2008R2, 2012, 2014, 2016.
• Used Visual Studio(.Net,2005,2008,2010,2012,2013) IDE to created computer’ programs.
• Manage Team Project and Team Code using Visual Studio Team Management Server(TMS).
• Dynamics Nav versions worked with: Dynamics AX , Dynamics NAV 2009, NAV 2013, NAV 2015 .
• Use of Dynamics NAV Inventory Management to:
• Maintaining accurate inventory level, assign multiple stock-keeping units (SKUs), units of measure, serial numbers, lot numbers, physical attributes, expiry dates, and much more.
• Assign items and SKUs to locations/bins based on product storage requirements, sales rates, special handling requirements, and other criteria.
• Manage returns to inventory, damaged goods, or scrap.
• Make manual adjustments to inventory quantities, transfer inventory from one location to another.
• Generate automatic notifications to alert employees, suppliers, or partners to changes in critical inventory levels, order status, or replenishment needs.

IT Manager

Confidential

Responsibilities:

• Supervised a team of 5 IT Technicians,
• Experienced with datacenter server hardware technologies from HP, Dell, and Cisco.
• Configured Cisco VPN tunnel, maintain inter-site connection and resolve all routing protocol issues.
• Worked with routers and switches, designed network architecture and performed Lan, Wan troubleshooting.

IT Manager

Confidential

Responsibilities:

• Software Development Processes including requirements elaboration, design, coding and unit-testing.
• Developing T-SQL stored procedures, functions, triggers, views. Debugging and optimizing SQL Server performance. Designing and creating SSIS packages to ETL data from databases.
• Experience with SQL Server, virtualization technologies, and Windows Servers in a variety of configurations including advanced server clustered systems. Strong knowledge of computer hardware architecture and Windows Operating Systems in a multi-system environment.
• Hardware/Software Remote Support experience.

IT Manager

Confidential

Responsibilities:

• Contributed software engineering expertise in the development of products through the software lifecycle, from requirements definition through successful deployment.
• Design, implement and deploy packaged software solutions that have been developed to accommodate business and management.
• Developed and conducted sophisticated exploratory data analysis, predictive modeling and data mining solutions to identify customer purchasing parameters, characteristics, and critical demographics.
• Analyzed large pools of data to discover trends, patterns, correlations that assisted operations managers in making better business decisions.
• Managed effectively and efficiently multiple, interrelated and complex data information sources.
• MSI consulting freelance, manage different phases of a project and provide initial project templates.
• Manage and coordinate cross functional team members under minimal supervision. Develop and maintain project scope, communication, risk, resource, time, quality management plans. Manage; track, and report project status, costs, and overall profitability, assist with business development efforts.
• Custom Software Development, Database Design (RDBMS), Systems, engineering, System Migrations/Integrations, Enterprise wide implementations.
• Perform other job duties as assigned by management as needed. Developed sophisticated forecasting models using historical and externalities to improve operations, analyzed and interpreted results.
• Used SAS and SQL to access various databases such as Oracle, DB2, and SQL Server. Created and store historical data on the UNIX server using SAS and SQL programming. Developed and implemented a systematic approach to managing marketing impact on sales and profitability. Provided support in the enhancement of existing databases to simplify the collection and analysis of data.
• Extracted data from various sources and create reports monthly and quarterly of taxes and social security products types. Monitored and enhanced the SAS queries. System Integrations/Migrations: Project- managed large-scale initiatives involving the transition of programs to new platforms and the merger of disparate systems from acquired client companies.
• Identified any issues related to database performance and provide corrective measures. Ensured data quality and integrity in database. Created functions, scripts, stored procedures and triggers to support application development.
• Install, configure, deploy and administer Dynamics NAV. Install Dynamics NAV Classic Client (Dynamics NAV C/SIDE), Dynamics NAV Role Tailored Client (RTC), and Dynamics NAV Classic Database Server on the computer to manage enterprise data such as SOS Inernational Village. Connect Dynamics NAV clients to the Database Server in the earlier versions and also the latest Dynamics NAV 2009 version. Accomplish administrative tasks such as securing and maintaining databases using Dynamics NAV.
• Use of Microsoft Dynamics NAV (Navision) for Financial Management to manage the General Accounting, Analytical accounting, Payables, receivables, inventory, fixed assets and the cash flow, perform bank reconciliations and manage financial processes in several currencies, locations, or companies.
• Knowledge of C/AL programming to Design custom functions and triggers, connect database objects, Read, write, and modify data.

Project manager

Confidential

Responsibilities:

• Project manager Confidential, Product manager Confidential, publisher of software of management for 250 companies. Participation in the writing of the software Confidential Administration and installation of networks Intranet, Ethernet, protocol TCP /IP.
• Software, (RDBMS) development, enterprise implementation and systems engineering
• Managed all aspects of a project life cycle such as project planning, development, change control, implementation, issue management, customer relationships, and team leadership. Develop security procedures to protect databases from unauthorized usage.
• Managed multi-sites, projects in systems and application development and customization. Developed users-interface to update data in various databases systems such as Ciel Account, Saarimaestria account, Sage Account line 100,500.
• Built, reviewed, and improved the actual code that solves complex data manipulation problems (SAS, and SQL Server). Developed and maintained advanced SAS and SQL queries to automatically generate Excel reports daily, weekly, monthly, and quarterly.
• Experience in managing outsourced fixed price projects and in a complex "Software development" or "Software package customization" projects. Good experience in test coordination on a big multi-site project: test strategy, test plans, tests management, test campaigns coordination. Determines operational feasibility by evaluating analysis, problem definition, requirements, solution development, and proposed solutions.
• Responsible for ensuring that the software developed for multiples business partners meets the quality expectations and the functional needs of business partners.
• Technical leader on medium and large development projects and provided priorities for project teams while delivering high quality code across multiple projects.
• Documented and demonstrated solutions by developing documentation, flowcharts, layouts, diagrams, charts, code comments and cleared codes. Prepared and installed solutions by determining and designing system specifications, standards, and programming.
• Optimized database systems for performance efficiency. Perform space management and capacity planning for database system and ensure data quality and integrity in database.
• Performed data back-up and archival on regular basis troubleshoot database related issues in a timely Fashion.

IT department Officer

Confidential

Responsibilities:

• Acted as the DBA, designed system specifications and programmed in native COBOL.
• Trained the company staff and redesigned company-wide help desk procedures.
• Supervised team 8 technical consultants.
• Maintained computer systems of editorial and design. Installed the software development