SUMMARY:

• 15 years of Broad technical knowledge combined with creative problem solving skills and experience in managing, designing and developing systems in both strategic and tactical areas in different industries.
• Effective communicator able to simplify, clarify technical concepts, and ideas for non - technical individuals and resolve customer complaints in a timely manner.
• Automated procedures/ developed effective systems
• All system’s development lifecycle phases
• Multiple Technology domains (mainframe, client-server)
• Strong negotiation and influencing skills
• Provide operational efficiencies at the process and systems level
• Excellent problem solving skills and ability to make effective decisions quickly
• Ability to collaborate between infrastructure, quality assurance, and project management teams
• Manage projects from scratch to production.
• Data Migration Specialist.
• Specialist in gathering user requirements and converting to functional requirements.
• Specialist in providing prototypes or proof of concept in MS Access and Excel.

TECHNICAL SKILLS:

OS/Environments: Windows3.1, 95, 98, NT, 2000, PC-DOS, UNIX: Sun-Solaris, HP-UX, IBM/AIX, VAX/VMS, and Novell.

Development Applications: SQL, VB.NET, ADO.NET, ASP.Net, Visual Basic(DHTML, ODBC, ADO, ACTIVEX CONTROLS, COM, DCOM), MS ACCESS, HTML, FORTRAN, COBOL, C, CSHELL, Visual J++, JAVA, ORACLE (PL/SQL, FORM, REPORT, AND PROJECT BUILDER), PERL, BASIC, MAPLE, PASCAL, INGRESS, SAP, ASP, CRYSTAL REPORTS, Visual C++, C++.

Object Oriented Methodologies and Development Environments: Jacobsen: Objectory

Networking: LAN: Ethernet, Token Ring, Remote Access, Frame Relay; WAN: terminal servers, modem, CSU/DSUs, routers, switches, RJE; Protocols: TCP/IP, SNA, NETBOIS, and DLC

Hardware: Sun SPARC and HP UNIX Servers; HP and IBM Netfinity NT and 2000 Servers; Sun, IBM, HP, Macintosh workstations; HP printers, scanners and other peripherals.

Software: CICS, RMDS, AIS, MS Office (Word, Excel, Access, PowerPoint, Publisher), MS Project, Oracle, DBASE, SQL SERVER, Visio and Visual Studio and .NET.

Languages: Fluent in English and Arabic

PROFESSIONAL EXPERIENCE:

Confidential, Detroit, MI

IT Consultant

Responsibilities:

• Analyzing data and developing VBA/Excel financial reports from Oracle and SQL data warehouse
• Creating Pivot reports in Access 2010.
• Creating T-SQL, Stored Procedures, Functions, and views in Oracle 10g and SQL 2012 using TOAD.
• Gathering using requirements and converting them to functional requirements
• Creating tables, queries, forms, reports, macros, and VBA modules in Access 2010.
• Creating Technical Design Documents
• Converting SAS code to VBA.
• Analyzed existing business process and simplified and modified existing tools
• Provided scalable solutions in Access 2010 once the business process solution is completed.
• Viewing and Extracting txt files from IKA using EDI tool and importing to Medicaid data warehouse in SQL and Oracle servers and creating required reports using Access and Excel for the finance and Accounting Departments.

Confidential, Sunnyvale, CA

IT Consultant

Responsibilities:

• Working on migrating data in to central data warehouse from SAP and mapping the old Data Mart QAD to the new Data Mart SAP and creating Sales reports from new data warehouse.
• Analyzing data and developing VBA/Excel financial reports from data warehouse.
• Creating ETL solutions using SSIS to migrate data to SQL 2012 using Visual Studio 2012.
• Creating SSRS reports using Visual Studio 2012.
• Creating T-SQL, Stored Procedures, Functions, and views in SQL 2012.
• Creating Prototypes in Access 2010 and Excel 2010 using Power Pivot and VBA.
• Gathering using requirements and converting them to functional requirements
• Creating Sales Pivot reports data coming from SAP.

Confidential

IT Consultant

Responsibilities:

• Working on migrating data in to central data warehouse and upgrading Insurance software system to accept new regional branches.
• Analyzed data and creating ETL solutions using SSIS to migrate data from Sybase to SQL 2008.
• Modified data windows, reports, functions and classes in Power Builder
• Creating Prototypes in Access 2010 using VBA.
• Modified tables and stored procedures in TOAD.

Confidential

Senior Manager Process Engineer

Responsibilities:

• Applying Software engineering methodology in creating End User Computing Systems form gathering user requirements and documenting functional and non-functional processes to developing a prototype for the developers and aided in helping the development of the product and testing the product before placed in production.
• Resolve highly complex, multi-faceted issues to meet the business needs of Derivative Product Operations with a specific focus on creating tangible and measurable operational efficiencies through the application of business, financial, and process engineering using Access, VBA, Excel, SSIS and SQL to deliver systems using RAD methodology in the Fixed Income Risk Department.
• Upgrade DTS and Access packages to SSIS that exported data from S&P and Moody and imported to Central SQL 2008 Database.
• Developed and Administered Access 2010 databases by creating and modifying tables, queries, reports, VBA Modules and Classes and maintained security of the database and storage capacity.
• Managed Projects using MS Project Server with a team of business analysts, developers and testers.
• Converted Access project to front end Access and Back end SQL 2008 for increasing storage capacity and converted access tables and queries to SQL.2008
• Analyzed, tested and implemented solutions applying software engineering methodology.
• Provided Testing strategy plan for Functional and UAT testing.
• Data Extraction from various financial software such as WSO, Bloomberg, and K2 Mainframe, etc and providing Front end Excel and back end SQL and Access Credit Derivative Ratings Aggregate Logic application for total return swaps using VBA code connecting via ADO or DOA.
• Providing Adhoc Excel Credit Derivative Risk Reports to Clients.
• Providing Financial Reporting and accountability based on changes to the end user software.
• Providing change control processes and audit approved processes and reducing risk control.
• Developing a real time deal monitoring system for all kinds of portfolios such as fixed income, equity, etc.
• Supporting Real Time Deal Monitoring System of 30 portfolios worth of 4 billion dollars.
• Gathering user requirements and developing prototypes to monitor portfolios collateral, DFD, MTM, Obligors breaches based on their concentration such as industry, ratings of asset, capital gains and loss, interest and fees and exposure of the counterparty.

Confidential

Senior Data and Reporting Analyst

Responsibilities:

• Automate Exposure and Data Validation reports that consisted of all kinds of securities and derivatives such as Equities, Stock, Bonds, Options, Futures, Currency Forwards, Mutual Funds, Swaps, and Hedge Funds etc using RAD methodology.
• Upgrade DTS packages to SSIS where data is exported from Bloomberg and imported to Eagle Pace System
• Gathered user requirements and created reports in SSRS, Excel and MS Access 2003 and 2007 where data is extracted from complicated T-SQL stored procedures, functions and views using SQL 2000, 2005 and 2008, SSIS, VBA and VB.net.
• Analyzed and Validated Securities data upload in Eagle Pace System from different sources.
• Automated Counter Party Equity Derivatives reports in VBA Excel.

Confidential

Senior Developer/Analyst

Responsibilities:

• Upgrade DTS and Access packages to SSIS that exported data from financial databases and imported to SQL 2008 and 2005 centralized databases.
• Used SSIS, SSRS, and SSAS to generate ETL solutions for import and exporting data and generating reports in SQL 2000, 2005, and 2008 environment.
• Created Parsers using VB.net 2005 and 2008 to convert PDF pages in to CSV files to be imported and stored code using MS Visual Safe Source.
• Created complicated T-SQL stored procedures, functions and views using SQL 2000, 2005, and 2008.
• Gathered user requirements and created reports in SSRS, Excel and MS Access 2003 and 2007.
• Analyzed and Validated data to ensure correct record output using VBA and VB.net.

Confidential, San Jose, CA

VB.Net/ VB/VBA/SQL Developer Analyst

Responsibilities:

• Design and architect database solutions, integrate databases designs with applications and systems designs and architecture from Access 2003 to SQL 2005, coordinate efforts with the development architect, communicate project status to project manager and ensure business requirements reflect solution delivered.
• Data Migration from different sources in to centralized data ware house.
• Combined 400 databases in Access that some reports were front end in Access and some were in Excel and converted the Access databases into two databases one in SQL2000 and one in SQL2005.
• Modified and converted modules in Access using ADO, ADO.net 2005, VBA, and VBA.net 2005 in order to produce output that are Access reports, txt files, or Excel files.
• Data Migration using DTS packages and SSIS to import text files created form Business Object 6.0 report tools or TOAD that extracted data from Oracle databases and imported into SQL Databases.
• Analyzed and Validated data to ensure correct record output.
• Gathered user requirement for creating MS Access reports or converting excel to Access
• Converted VBA and VB code to VB.net to connect to SQL 2005

Confidential, Largo, FL

IT Manager

Responsibilities:

• Manage the network and software development of the company.
• Plan, direct, develop and coordinate projects to assure that all requirements are being met within the time frame and budget of the projects.
• Recruit personal and provide work plan for each staff member reporting to me with their progress of each phase of the project.
• Negotiate contacts with vendors for purchasing software needed to complete the projects.
• Convert Access MDB application to an ADP Application with front end Access and back end SQL.
• Convert Mini Confidential Software package in Access and VB to VB.net 2005 front end and SQL 2000 back end using ADO.net 2005 for database connection.
• Integrated the processing, accounting, warehousing, customer service, and sales department systems in to one centralized system which prevented duplicate errors, reduced paper work and misplaced jobs and increased speed and productivity, simultaneously improving customer service and reducing warehousing inventory costs, and increased sales by 30% using VBA, and Access 2003 front end and ODBC/OLEDB/ADO connectivity to SQL 2000 and 2005 back end and migrating tables and queries from Access to SQL using DTS packages and creating stored procedures, functions, and views.
• Design, Installed, and Coordinated the Network system having a Domain Windows Server 2003, SQL Server2000, IIS Web Server with ISA 2003, File and Print Server Windows 2000, and Fedora Linux Firewall Server.
• Planned, directed, coordinated and developed New Version software for Pharmacies and Hospitals that is worth $1,000,000 using Access2003, VB.NET 2005, ADO.NET 2005, ASP.NET and SQL 2000 and 2005.
• Planned in Revamping existing websites using Java, FLASH, HTML, and ASP.NET which eliminated some of the customer service tasks and provided new clients which increased sale by 5%.
• Maintained VB applications and converted to VB.net.
• Data Migration of Access databases in to SQL 2005 Server.

Confidential, Tampa, FL

IT Manager

Responsibilities:

• Develop and program two and three-tier applications from scratch to production. Create tables, queries, reports, forms, pages, modules and VBA scripts in VB, Excel, Access and Oracle. Create forms, reports, classes, modules, COMs, DLLs, ADO and ODBC connections, and Active X in VB 6.0 and Crystal Reports.
• Create web pages using Java, Java Script, Access, ASP, HTML, VB Script, and DHTML.
• Manage databases in SQL 7.0, Access 2000, and ORACLE 8.0 using triggers, procedures, queries, and SQL and PL/SQL scripts and migrated Access tables and procedures to SQL using DTS Packages.
• Maintain file and IIS web servers on Windows NT and 2000 operating systems.
• Design optimal relation databases applying the Normalization processes in Access, Oracle and SQL and maintained them.
• Eliminated manual paper work and developed an automated accounting, warehousing, and proxy job systems which prevented duplicate errors, reduced paper work and misplaced jobs and increased speed and productivity, simultaneously improving customer service and reducing warehousing inventory costs by 40%
• Eliminated manual proxy voting resulting in user-friendly e-voting proxy system via Internet, which improved customer service and increased new clients by 3%.
• Eliminated manual prospectus work orders and reduced mailing prospectus materials by developing a prospectus work order system which prevented duplicate errors, reduced paper work and misplaced jobs, and increased speed and productivity while providing the financial analysts (FA) prospectus materials instantly via intranet to their clients, enabling increased sales by 5% and reduction of warehousing inventory cost by 80%.
• Designed new system for downloading and processing data files from mainframe to desktop, which increased speed and productivity and reduced errors.
• Designed new system for viewing text files downloaded from the mainframe on the desktop reducing inventory cost by 80%, improving customer service and increasing speed and productivity.
• Researched and established a virtual private network (VPN) via mainframe which resolved security issues access through Internet and resulted in saving $100,000 in startup costs and additional yearly savings of $60,000.
• Convert VBA application to VB with back end SQL 2000.