HIGHLIGTS

• MBA with 14 years of experience in IT and business operations excellent communication organizational and interpersonal skills well-rounded with 9 years in full life cycle enterprise software development in a Fortune 100 company plus 5 years overseeing IT and business operations of a US-based multi-national technology company.
• 9 years of experience with full life cycle enterprise application development in a Fortune 100 company using .NET SQL Server and Oracle PL/SQL.
• 5 years of experience overseeing business and IT operations including finance and accounting sales manufacturing HR IT infrastructure and security data backup and SOX compliance.
• Strong drive for success problem-solving and analytical skills.
• Consistently delivered high-quality products on or ahead of schedule.
• Strong verbal and written communication skills.
• Substantial experiences in project management requirement analysis systems design testing working closely with customers vendors team members and stakeholders at all levels.
• Substantial experience building effective teams and developing people including offshore team members.

PROFESSIONAL EXPERIENCE

Confidential

Manager of Finance and Operations

• Owned and managed all accounting and finance functions including G/L A/P A/R payroll revenue inventory cost intercompany equity cash management banking relationships fixed assets risk management insurance procurement month-end year-end closings GAAP-compliant international consolidations SOX and regulatory compliance FP A financial reporting budgets and forecasts external audits federal and state income tax.
• Owned and managed corporate IT system including a multi-point VPN network Microsoft Exchange Server Active Directory File Servers Linux Server SQL Server VoIP System Accounting Systems and EMC SAN storage. Owned all corporate data records management and disaster recovery planning and SOX compliance. Planned and implemented system changes with minimum interruption to business operations.
• Enforced corporate IT policies on document and data retention data security and integrity audit trail backup and disaster recovery internal controls for financial reporting and SOX compliance. Managed offshore IT team and ensure system and processes are in compliance with overall corporate IT processes.
• Strong system skills. Evaluated various accounting systems and selected one best suited the business. Cleaned up chart of accounts and converted and consolidated multiple legacy accounting systems into one and improved the financial system infrastructure.
• Reviewed and updated internal control procedures including cash receipts and disbursements expense reporting customer terms and PO sales and accounts receivables month-end closing procedures inventory control and management fixed assets accounting and control and IT system controls and processes.
• Owned the day-to-day accounting operations including A/P A/R payroll general ledger expense reports and cash management.
• Owned the end-to-end close financial reporting and variance analysis processes. Prepared journal entries for month-end closing all balance sheet accounts reconciliation including cash revenue inventory inventory to book inventory to physical fixed assets intercompany transactions prepaid and accruals. Consolidated financials with foreign subsidiary financials and produced timely and accurate consolidated financial statements and variance analysis.
• Owned cost accounting functions. Worked with foreign subsidiary operations team to develop standard costs for new products. Maintained periodic updates of standard costs and ensured accurate standard costs in the GL system. Worked with offshore warehouse manager in monthly cycle counts maintained detailed inventory transaction register reconciled inventory from transaction register to GL and from GL to physical. Maintained inventory reserve worksheet prepared journal entries for reserve adjustments and reconciled worksheet against GL.
• Liaised with external auditors on periodic audits. Prepared consolidated financials and liaised with external CPA firm to prepare timely federal and state income tax returns. All audits were incident free. Also resolved county property tax audit issues to 0 tax liability.
• Prepared timely and accurate reports and returns for regulatory compliance including state franchise tax reports sales and use tax reports county 571L property tax report federal 1099 and 1096 statements and annual 5500 filings.
• Prepared budgets forecasts project cost and benefit analysis to assist CEO in strategic planning.
• Prepared report package for board meetings. Presented in board meetings recorded meeting minutes and maintained minutes book.
• Managed sales operations. Reviewed negotiated terms and conditions with distributors sales representatives and customers. Researched customer business status and determined payment terms. Reviewed all customer POs for acceptance. Liaised with offshore warehouse and support teams for shipping and customer support.
• Owned customer relations in several geographic regions. Retained some long-time customers whose revenue made up 30 of total revenue while company was undergoing major uncertainty.
• Managed supply chain. Re-negotiated contracts with existing fabs and assembly houses and reduced product unit manufacturing cost by 35 . Forecasted demands planned and executed production plans.
• Managed IT vendor relations. Negotiated with vendors on co-location services software licenses Telephony and web hosting contracts and saved 20 on recurring IT contract expenses.
• Managed all vendor relations. Maintained contract templates reviewed and negotiated vendor contracts for favorable terms and minimized risks. Identified cost saving opportunities and implemented plans to save monthly recurring operating costs by 65 .
• Analyzed and reviewed business processes and operations contracts and agreements in effect documented risks in business continuity product warranty management practice health and safety disaster recovery drafted risk mitigation plans and defined and procured proper insurance policies.
• Managed shareholder relations. Maintained records of shareholders assembled and distributed regular communication materials managed share buyouts with DTCC and DTCC participants.
• Managed HR functions. Established owned and managed HR benefit plans and compliance work.
• Analyzed large amount of data and documents and discovered key findings during an investigation consequently brought in 860 000 in recovery for the company.

Confidential

Software Developer

• Full life cycle software development in a number of mission-critical systems involving Oracle databases with large data volumes PL/SQL Web Services C .NET WCF XML XSLT SQL Server Windows hosted application C .NET WPF NUnit and web applications ASP ASP.NET C NUnit enabling success of Dell s sales operations core to its direct-sell business model. In every project wore many hats and worked with cross-functional teams from project conceptual stage to completion.
• Worked with business partners and other IT teams to perform business analysis gap analysis use case analysis drew diagrams and charts developed rapid prototyping to define project and design software solutions.
• Negotiated with business product manager on the scope and requirements given resource constraints.
• Documented business requirements. Worked with other IT teams to design technical solutions and documented technical specifications. Documented project risks and designed risk mitigation plan.
• Managed and secured dependencies to meet project delivery timeline.
• Collaborated with business partners other IT teams to define and document testing plans for functional and unit testing performance testing development integration testing systems integration testing and user acceptance testing.
• Developed software solutions based on functional and technical specs. Collaborated with shared services teams other development teams and offshore teams in the development effort. Managed change in requirements by conducting technical and risk analysis and communicating to the business partners and the PM.
• Worked with QA team on functional and performance testing other technical teams and shared services teams to conduct integration testing with business partners on UAT and addressed issues found.
• Implemented software install. Managed changes as the needs arose from evolving business requirements.
• Trained end users on effective use of the systems and created user interfaces for business partners to query data to business initiative effectiveness. Ran ad-hoc queries for special requests.
• Major projects included the following
• CDAS/Axis. Back-end operational data store and middle-tier web services that provide data for Mission-critical order entry and management system for Dell s phone agents as well as front-end web customers at support.dell.com.
• Designed and built database in Oracle 10g for customer quote and order data worked with ETL team to set up live Extract/Replicate and loaded all historical data from Dell s mainframe system to the Oracle database.
• Analyzed data and discovered duplicate data accidentally introduced from the ETL process. Created stored procedures jobs and testing plans and executed jobs to clean up the duplicate data.
• Migrated all read-only transactions from mainframe system to Oracle stored procedures and web services using .NET C WCF PL/SQL.
• Expanded user base from sales reps to all Dell phone agents as well as customer-facing applications such as support.dell.com by providing order management and order status related data across US Canada and Latin America regions.
• Re-architectured the database tuned SQL statements and added indexes as the data need evolved to improve query performance.
• Put on many hats. Served as DBA for dev and QA teams dev lead for the project. Liaised with customers to define requirements shared services teams to manage dependencies QA team on test plans and environment. Mentored and led team of 4 offshore developers to successfully deliver projects on schedule. Projects include Dell Purchase ID Canada and Latin America Order Status Quote Management Services Estimated Delivery Date.
• IDD//CDAS. Mission-critical order entry and management system for Dell s phone sales reps. Winner of CIO Enterprise Value Award featured in February 15 2004 issue of CIO Magazine.
• Designed and developed shared Web Services to retrieve customer quote and order data out of backend mainframe system using .NET C WCF SQL NUnit. Services significantly reduced request response time than with existing multi-tier systems.
• Designed and rewrote the web-based user interfaces to Windows-based hosted application within IDD Integrated Dell Desktop for better performance using UML .NET C WPF SQL NUnit .
• Designed and developed functionality for sales reps to up-sell third-party broadband Internet service products to customers using UML .NET ASP.NET C WPF SQL NUnit.
• Team spearheaded automatic code testing using NUnit achieved 98 code coverage.
• Designed and rewrote the functionality of customer information management from ASP and Visual Basic to ASP.NET in C using UML ASP.NET C SQL NUnit.
• Developed sales discount tool enabling business flexibility and greater control over discount promotion and maintenance.

Confidential

• Reporting database for customer registration data with third-party Internet service providers.
• Analyzed business requirements and developed Oracle stored procedures for revenue forecasting developed VB Scripts to automate scheduled data process. Developed Email notification service for data updates. Liaised with customers for new requirements as their needs evolved.

Confidential

• Web-based sales configuration data management tool.
• Configured production servers and successfully integrated software with hardware platforms.

Confidential

• .Maintained the services used in to calculate tax and shipping charges.

SKILLS AND KNOWLEDGE

Software Development Life Cycle Requirements Analysis and Documentation Agile Methodology SOA Oracle PL/SQL Packages Stored Procedures Materialized Views TOAD PL/SQL Developer SQL Server SQL TSQL SQL Tuning Relational Databases Data Modeling Database Design Database Administration Database Reporting ETL SSIS .NET C ASP.NET VB.NET Windows Forms WPF XML XSLT Web Service WCF SOAP Design Patterns MVC Test-Driven Development TDD Methodology Unit Testing NUnit Visual Studio.NET IIS TFS OOA/OOD/OOP UML C C VBA JavaScript SharePoint Visio Perl Unix/Linux User Interface Design Applications Integration Testing Automated Testing Testing Procedures Test Documentation COBOL Business Intelligence Analytics Crystal Reports Change Control Source Control Change Management Systems Administration SOX PCI Internal Control Network Security Active Directory Risk Management Operations Management Incidence Management Corporate Governance e-Discovery Document Production ERP System Implementation Manufacturing Industry.

Financial Analysis Financial Planning Business Strategy Planning General Ledger US GAAP Internal Control Financial Reporting International Consolidations Reconciliations Cash Management Budgeting Forecasting SOX PCI Revenue Recognition Cost Accounting BOM Standard Costs Inventory Reserve COGS Supply Chain Management Accounting System Conversion ERP System Implementation Peachtree Great Plains FRx Microsoft Dynamics AX QuickBooks Oracle EBS ADP ADP EasyNet Payroll in Multiple State Jurisdictions Risk Management Corporate Governance Business Process Improvement Investor Relations Benefits Administration Sales and Use Tax Property Tax State Franchise Tax Corporate Income Tax Records Management Advanced Excel Macros VBA Pivot Tables Formulas Forms Visual Basic Project PowerPoint Access Equity Edge Systems Administration Disaster Recovery User Support and Training Active Directory VMware e-Discovery Document Production Bankruptcy Proceedings Reorganization Semiconductor Industry Manufacturing Industry