SUMMARY:

To obtain a Sr. analyst (Business, Financial, Data or Technical) position, where I will be able to utilize my experience and education, (BS in Accounting and BBA in Computer Information System), to make a significant contribution to the growth of the company.

TECHNICAL SKILLS:

Operating Systems: DOS, Windows (3.1, 95/98/98SE/2000/XP/7), NT and UNIX (Solaris)

Programming Languages: BASIC, Visual Basic, COBOL, Advance COBOL, C, Advance C, LAN, Assembler (UNIX), PL/SQL, AS - 400

Software: Supported and experienced on Internet Explorer, Internet Connection Sharing (ICS), Outlook, MS-Office suite including Excel Power Pivot, MS SQL server (SSRS, SSAS), MS-Access, Crystal, Oracle (8.0/8i/9i), PeopleSoft, Clarity, Clarify (Microsoft s internal), Visual KB (MS Internal), MS Knowledge Base (MS internal and public), dBase IV, Peachtree Accounting, QuickBooks

Networking: Foundation knowledge of Internet protocols (TCP/UDP/IP, IPX/SPX), Security Policy, Firewall, Secure Sockets layer (SSL).

Systems: IBM PC Compatibles, Compaq, HP, IBM-3090, HP-9000, VAX 3000, and AS-400 Mainframe systems

PROFESSIONAL EXPERIENCE:

Sr. Business/Data Analyst

Confidential

Responsibilities:

• Create, execute and manage daily and weekly processes on PE (pricing Exception) reporting for divisional sales executives of 13 region including every branches and sales managers
• Improve and automated existing Excel processes utilizing SQL queries, Access, Excel Power Pivot Models, SSRS, Scheduler, MS Dynamics CRM, Excel Macros & VBA etc.
• Analyze and validate any data anomalies or model output on a timely basis for current processes as well as ad - hoc reporting.
• Support pricing/operation team with reporting and data aggregation for analytics and presentations to various partners within the organization.

Sr. Business Application Analyst

Confidential

Responsibilities:

• Prepare reports on Asset Acquisition, Leasing, Resident Services and Operations for all 14 region on a daily, weekly and monthly basis using SQL Scripts, SSRS, SSAS, Excel Power Pivot models, Tableau, Yardi Voyager, and Power Point
• Validate monthly financial data from Yardi and salesforce using MS-Access and BI Tools to prepare monthly P&L report (Combined Balance Sheet and Income Statement) along with variance analysis for all regions with different funding.
• Manage, update, automated and documented various reporting process and models for Asset Management group using Excel VBA and Macro.
• Support Director and Managing Director of Asset Management group with various task such as data extraction, validation, ad-hoc reports and power point presentation
• Sr. Business Reporting Analyst (AVP), Citibank, N.A 2
• Successfully transitioned and take over all reporting processes related to credit card and Mortgage from Albuquerque, NM due to site closing. Administer these processes on a daily, weekly and monthly basis which includes but not limited to documentation, managing all related databases, data extraction and validation using Oracle, Mainframe AS-400, SQL Server Data Base, SSRS, Access and Excel.
• Performed variety of specialized duties that involved collection, validation and reporting of data for a comprehensive department management information system. Support Confidential Global Collections Operations across multiple lines of business (Cards, Mortgage, Personal Loans, etc.) as well created Ad-hoc reports on a daily basis.

Sr. Financial/Business Analyst

Confidential

Responsibilities:

• Created and distributed monthly and quarterly Divisional Workforce packages for 53 VP and Directors using MS-Access, Excel, Power Point, Clarity, and PeopleSoft
• Analyzed, validated and prepared weekly external and internal workforce movements, attrition, funded positions and budget related reports for multiple divisions across the enterprise
• Reconciled weekly and monthly divisional budgeted resources with actual
• Coordinated and tested data extraction process with Finance department
• Researched, analyzed and validated extracted data received from other departments.
• Communicated with team, management and other departments to gather and analyze data so all reports were accurate and process runs error free
• Analyzed and Validated reports created by other team members
• Administered and maintained Tier 1-2 project listing database and Position Funding database
• Organized meetings with VP, directors and users to gather business and functional requirements
• Designed, implemented and updated process/procedure documents in a daily basis

Sr. Financial Analyst

Confidential, Texas

Responsibilities:

• Maintained Fixed Asset area of Accounting in the Financial Management System (FMS). This is accomplished by prepare, review, analyze and reconcile fixed asset data for all department to the FMS and then create reports for the managements using SQL and Oracle database.
• Prepared quarterly and annual financial reports for the City’s nine department and six Capital Improvement Program (CIP) funds in accordance with GAAP. These reports included combined statement of Revenues, Expenditures, Balance Sheet and Cash Flow.
• Implemented Fixed Asset Register and Job Costing in every Department of the City. This is accomplished by analyze the needs and requirements of other department for Asset Register and Job Cost setup and then design and test those needs in the FMS test environment on a trial and error basis and then provide required training and follow support.
• Created Queries and Reports for department users upon their request using Oracle 9i database, MS-Access, Crystal 8.0 and MS-Excel.
• Converted City’s Comprehensive Annual Financial Report (CAFR) and quarterly reports to web base format (PDF, JPEG) and uploaded them to city’s Website in a timely fashion.

Technical/System Analyst

Confidential, Garland, Texas

Responsibilities:

• Troubleshot issues on Win95, Win98, NT, Internet Connectivity, Modem, DUN, networking in a peer to peer/LAN environment, DOS, and PC hardware architecture.
• Provided Supports on other Microsoft products such as Internet Explorer, Outlook Express, Microsoft Office, Net meeting, Direct X and Java applets to corporate and general users.
• Delivered quality technical resolutions in a timely manner within established guidelines and prescribed procedures. Rated “Outstanding” 90% of the time.
• Documented case wellness. Assumed responsibility for 40 plus cases from start to resolve.
• Conducted extensive research using partner and public Microsoft Knowledge Base.