PROFILE

• Systems Analysis and Design Business Analysis and Requirements Business Objects Data Analysis Mining LAN/WAN Networks TCP/IP Protocols
• Mathematical Modeling/Trend Analysis Business Requirements Cloud and Virtual Computing
• Computational Methods Process Improvement Networking/Routers/Switches
• Analytics/Problem Solving Project Lifecycle Network Design/Decision Making
• Data Analysis/ SQL Queries Active Directory Engineering Research Projects
• Telecommunication billing systems Disaster Recovery Language: Fluent in French

TECHNOLOGY SUMMARY

• LANGUAGES: C , SQL, Python, SAS
• PLATFORMS: Windows 9.x/2K/XP/Vista/7/8, Linux, Macintosh OS X
• APPLICATIONS: Delta, Siebel CRM, PeopleSoft CRM, Dell Serv, DOMS, GFX Fulfillment and Yoda, MS Explorer, Harmony Composer, Oracle/Novora, Minitab, eCATS, Business Objects SAP Webi, DiamonD Software Management, GuestVision, FileZilla, Altigen phone systems, Microsoft Office 365, Microsoft Office Suite.
• DATABASE: Microsoft SQL Server

EMPLOYMENT HISTORY

Systems Business Analyst

Confidential

• Coordinated projects gathered business requirements performed systems administration duties communicated effectively with end users, IT/technical teams and Executive Management
• Analyzed requirements, constructed work flow charts, studied system capabilities, and wrote specifications improved systems by studying current practices and designing modifications recommended controls by identifying problems and writing improved procedures tested purchased software GuestVision and wrote all required documentaions
• Created Data Flow Diagrams, Use Case Model and Unified Modeling Language UML utilized Microsoft Project for planning and scheduling
• Monitored project progress by tracking activities, resolving problems, publishing progress reports, and recommending actions to the IT Director maintained system protocols by writing and updating standard operations and procedures provided references for users by writing and maintaining user documentations provided help desk support, and trained users on the GuestVision software for the inventory management system
• Utilized Microsoft CRM Dynamics to assist the Marketing team with tasks such as incorporating students' admission goal results in reports, charts, and dashboards as well as support for workflow and customizations
• Managed user accounts with Active Directory management console based on requests via emails and spiceworks ticketing system utilized Microsoft SQL Server Management Studio to execute queries for Search Express and DiamonD tasks via V-Lookup function
• Provided inputs to the development team in performing extraction, transformation and load ETL for data marts and data warehouses from source to target systems using Informatica assisted in data cleansing and data integration financial aid data defined and implemented Quality Assurance tools and processed in Python utilized SAS application to identify trends and translate analytical findings into risk management
• Analyzed and diagnosed data quality accurately using data profiling tool like BDQ Business Data Quality Analysis

Data Analyst

Confidential

• Analyzed and investigated usage Early Termination Fees ETF issues to assist sales Account Managers via email provided ETF calculation/breakdown exported Event Queues EQs daily from eCBR systems, imported EQs into the database DB
• Validated ETFs on the EQs in the termination DB by reviewing contract terms and running Business Objects reports Contributory Report via Business Objects Web Intelligence billed applicable ETF in eCBR or via the billing office noted billing systems, ROME and eCATS databases executed SQL queries via Teradata ODBC or Excel for end-of-month data reporting
• Was responsible for on-boarding new team members, training them and auditing their work provided webinar on the termination process to other internal teams wrote training process/manuals provided cashflow data reporting for revenue compliance using Excel
• Performed data analysis and data profiling using SQL on sources systems like Teradata
• Investigated and established critical control algorithms to analyze various sources of new data monitored and resolved data warehouse ETL production issues
• Created a high-quality statistical-grade data set, optimized for Modeling Analytics, emphasizing data validation, data mining, data cleansing and data reduction

Banker

Confidential

• Marketed, sold and up-sold bank product and services to potential and existing customers on-boarded new clients utilizing superior customer service and product solutions, consistently exceeding sales expectations
• Assisted new and existing clients with educational financial online courses was accountable for referral acquisition, growth, retention and satisfaction of profitable small business clients
• Processed transactions, opened new accounts and balanced cash drawer efficiently

Data Analyst

Confidential

• Analyzed financial data for the Microsoft Software Licensing business reconciled invoices from Microsoft for Dell customers, ensuring services purchased were services invoiced if any discrepancies, utilized analytical skills to research and resolve issues
• Supported a historical review of billings in the software business and identified errors
• Collaborated by correcting and categorizing discrepant billings, referring to Sales/Accounting departments requiring a vendor credit or as a write-off
• Performed data mining with querying and mining large datasets to discover transition patterns and examine financial data worked on claims data and extracted data from various sources such Oracle and Mainframes
• Evaluated functional and non-functional categorized data elements for data profiling and mapping from source to target data environment created remote SAS sessions to run the jobs in parallel mode to cut off the extraction time as the datasets were generated simultaneously

Technical Support Specialist

Confidential

• Handled a high influx of inbound calls within a dynamic technical call center environment
• Assisted customers by diagnosing and resolving technical issues related to Windows Server 2003, Exchange, Active Directory, Windows Vista and 7 managed multiple priorities and maintained effective results in the IT department
• Created trouble tickets in Siebel and escalated issues to the upper level as needed