PROFESSIONAL HIGHLIGHTS:

Over 10 years in data analytics and IT system development field. Proficient in MicroStrategy, Excelsius Business Object and SQL databases such as SQL Server and Oracle.

TECHNICAL KNOWLEDGE:

WORK EXPERIENCE:

Confidential

Data Visualization Developer:

• Develop mobile dashboard for Pizza Hut's digital sale channels, customer acquisition and promotion on iPad, iPhone and Android devices.
• Ensure the best visualization widgets are used and effective use of paneling on mobile devices.
• Customized high resolution graphics for best rendering on iPad's Retina display .
• Working with large sales and promotion databases in Oracle.
• Develop prototype on Big Data using third party tool Cloudera .
• Develop prototype on text analytics using MicroStrategy Developer.

Confidential

Confidential

Report Developer:

• Communicate with client in-person or in-writing when gathering requirements.
• Develop and maintain schema, application and public objects using MicroStrategy Developer.
• Create schema objects such as attributes, facts, logical views, user hierarchies and transformations using MicroStrategy Developer.
• Create public objects such as metrics, filters, prompts, consolidations, custom groups, reports and documents based on client's requirements using MicroStrategy Developer.
• Develop and maintain document services reports based on client's requirements.
• Develop and maintain complex Reports in MicroStrategy Developer and MicroStrategy Web using Templates, Filters, Prompts, Consolidations and Custom Groups.
• Develop and maintain Custom Documents in MicroStrategy reports to combine the Data sets of multiple reports and also created customized Dashboards and scorecards using Report Services.
• Involve in objects update by promoting objects from development to test server, and later to production server.
• ActioNet, Department of Transportation FTA /Transportation Electronic Awards Management Confidential

Tester / Confidential Manager:

• Obtained Public Trust security clearance.
• Involve in the SDLC Software Development Life Cycle including the design, development, integration, testing, and implementation phases.
• Implement publishing codes in all types of releases such as major, minor, critical and critical fix releases.
• Communicate with software developers and DBAs making sure source files are documented and well stored for the upcoming release.
• Follow the configuration management process that is in place and update
• , and learn specific input and output requirements.
• Communicate with internal and external clients' in-person, over the phone as well the process where applicable.
• Confer with team members to analyze current operational procedures, identify problems as via email.
• Maintain and run T-SQL queries ad-hoc reports.
• Prepare, write and perform different types of testing based on requirements from client.
• Perform integration, regression, black, white and other types of testing in the production as well as testing environments.
• Perform UAT User Access Testing with client.
• Resolve HelpDesk issues level 1 and 2 data fixes by identifying and troubleshoot issues.
• Prepare weekly/monthly TEAM statistic report to determine the volume of users who utilizes the reports in TEAM system.
• Prepare weekly report for client on weekly basis.
• Participate in interviewing process to screen for the right candidates for the HelpDesk position.
• Train team members on TEAM system and how to handle request according to SOP Standard Operating Procedure .
• Assist in development of new procedures and SOPs.
• Access each major and minor release by conducting a QA Quality Assurance Audit after the release with data gathers from MR Measurement Repository .

Confidential

Data Analyst:

• Work with Microsoft SQL Server ETL tool.
• Knowledge of the MicroStrategy tool suite I-Server, Architect, Developer, Web, OLAP Services and Report Services .
• Assist with the Metadata mapping in a given project in MicroStrategy environment.
• Knowledge of both logical and physical data modeling.
• Manage progress on the project assigned and report closely to superior on project status.
• Troubleshoot data issues by tracing the data flow and identify the root of cause.
• Maintain T-SQL queries for ad-hoc reports.
• Maintain and enhance stored procedures for production databases.
• Perform testing on the customized in-house developed web-based analytical software.
• Improve the plan/process of a project to maximize efficiency by minimizing time and effort needed.
• Confer with team members to analyze current operational procedures, identify problems, and learn specific input and output requirements.
• Validate and analyze data and convert from raw data to analytical reports for decision-making purposes per client's requirements.

Confidential

Data Manager:

• Report closely to Chief Operation Officer and other department heads on project status.
• Generate report using customized built macro.
• Create, improve and maintain business processes in timely manner.
• Improve and maintain data accuracy stored in SQL 2005 that has more than 10 years of history.
• Download public resources FOIA , analyze, and present them in meaningful reports for financial industry.
• Utilize excel for data verification purposes.
• Enrich and maintain data accuracy on CRM platform known as Salesforce to boost revenue on different products.
• Gather requirements and develop analytical reports using Crystal Excelsius Dashboard .
• Work with BI tools/application using Crystal Excelsius.
• Enhance efficiency of financial reports based on requirements.
• In depth knowledge of data flow relating to Stored Procedures and Triggers.
• Create and update process documentations for internal users.
• Review computer database capabilities, workflow, and limitations to determine if program change is possible within existing system, time, and cost constraints.
• Utilizing macros for automation to enhance the capability for existing processes in data analysis.

Confidential

Confidential Database Operational Analyst:

• Independently carry out technical phases of complex toxicology studies, including study management, data organization, QA audit response, and internal/external client communication.
• Train new staff members.
• Assist in development of new procedures and SOPs.
• Support client visits, debriefings, and study initiations.
• Assume team lead role during supervisor absence.
• Involve in analyzing business requirements.
• Execute test cases based on functional specifications.
• Involve in functionality and performance testing.
• Identify, report and track bugs/defects.
• Interacted with developers to resolve application defects.
• Regression testing was performed after rectification from developers
• Perform different negative tests like Invalid Data Tests and Bad Files.
• Conferred with team members to analyze current operational procedures, identify problems, and learn specific input and output requirements.
• Reviewed capabilities, workflow, and limitations to determine if program change is possible within existing system, and time.