Senior Executive Business Intelligence Reporting-Analysis
UFONE
Total years of experience :10 years, 10 Months
Creating and executing complex Teradata SQL queries, managing stake holders for testing and Deployment
o Developing Schema to add new sources into MicroStrategy-Undertake end to end MicroStrategy development to improve upon the existing infrastructure and introduce new sources to enrich current reports and dashboards.
o Adhoc Reporting. o Managing end users (Business users related to their Adhoc reports within given timelines) BI and edw SDM level reports development and reporting over MicroStrategy.
o Communicate and manage expectations of the management and affected stakeholders during development, testing and deployment
o Reporting analysis and development
-Creating and executing complex teradata SQL queries, managing stake holders for testing and Deployment
-Data warehousing test process, mathadolgies, executions and EDW Testing.
-Creating and testing UNIX SHELL scripts.
-Bonus posting and CLM analysis
-Data warehousing related test process, methodologies and tools are applied appropriately and that test phase entry/exit criteria are defined as agreed to by stakeholders and applied by the test team.
-Communicate and manage expectations of the management and affected stakeholders during development, testing and deployment.
-Develop and Design test cases, scenarios, and scripts to ensure build quality of data warehouse.
-Examining test case results for successful ETL operations
-Writing BTEQs, FASTLOADS, SHELL Scripting, FAST EXPORTS and examining test results (ETL Process).
-Managing Revenue Assurance trends, monitoring test results and data quality.
-DWH data quality and testing.
-Reporting analysis and development
Evolving smart operations, automated customers processes, technical support, Web based initiatives, new ideas transformations.
Handling multiple operations for automated simulation.
o Worked on simulators to perform multiple operations, Simulator development for auto requests.
o Worked on CRM (Siebel, ADM, ICBS) for automated operations
o Worked on CRM for regular automation operations and user tax certificates.
o Technical 3G Area Issues, Supporting Technical team, Internet Related Solution including EDGE/GPRS/3G services.
o Devices configuration and ip configurations.
o Area wise ticket creation for connectivity (HSPA, gprs) and voice
o Prepaid and Postpaid related network barring and configuration
o Managing Call Centre of Internet and Devices support, assigning SRs and shift analysis
Worked as a Photoshop designer and IT expert
Worked as a web developer and Photoshop designer (Internship)
HTML, CSS, PHP (Graphic designer)
BS Computer Science BS(CS)-4 YEARS COMSATS INTITUTE OF INFORMATION TECHNOLOGY Major Subjects: Computer Programming (C++) Database Web Engineering Compiler Construction Software Engineering Software Project Management OOP-JAVA
FSc Pre-Engineering Sirsyed College, Wah Cantt Physics, Chemistry, Mathematics
POF Model High School, WAH CANTT Physics, Chemistry, Mathematics, Biology