Ummul Wara

Umm-ul-Wara Sr. Software Engineer BI – System Pvt. Ltd BI Developer/ETL Developer/Data Analyst/Data Engineer PROFESSIONAL SUMMARY • 5+ years of BI experience with Microsoft technologies in Database Design, Data Manipulation Querying and Reporting on Relational as well as multidimensional databases, Data Integration and Database Administration. • Experience in full SDLC including System Analysis and Design, User Requirements Determination, Coding, Implementation and Testing • Substantial experience in developing several dashboards using SharePoint 2013/Excel/Power BI/SSRS. • Analyzed user requirements and, based on findings, design functional specifications for BI frontend applications. • Involved in Huge data migrations, transfers using utilities like Data Transformation Services (DTS), and SSIS • Designing and Deployment of Reports for the End-User requests using Web Interface, SSRS and SharePoint 2013. • Excellent knowledge of SQL and MS SQL Server writing DRL, DDL, DML & DCL, Stored Procedures, Functions, Views • Good Knowledge of working on SSRS, SSIS and SSAS • Experienced in programming tasks-Stored Procedures, Triggers, and Cursors using SQL Server 2005/2008 R2 with T-SQL. • Expertise in What-If Analysis using Excel, Power Pivot Reports and Drill Through Dashboards using Warehouses and OLTP Connections • Expertise in Proactive Caching, Degenerated Dimensions and Tabular Data Modeling for Moderate to Large Data Systems • Combine technical and analytical aptitudes with problem-solving strengths to drive projects to on-time, on-budget and high-quality completion KEY SKILLS • Exceptional focus on customer service and passion for working in a customer-facing role, while building partnerships with stakeholders across the company. Database Tools • Strong technical analysis and troubleshooting capabilities • Excellent ability to perform programming, debugging, data analysis and system analysis • Excellent written and oral communication skills • Ability to work both independently and within a team-oriented framework Karachi, Pakistan --https://www.linkedin.com/in/ummulwara-6bab0623/ EXPERTIES • • • • • • • • • • • • Database Development Data Modeling and Warehousing Stored Procedures & Complex Queries Data migration Data quality Data analysis Project Planning and Management Agile and Scrum SQL Server MS Azure Oracle MySQL Reporting Tools • • • • • • SSRS SSAS Power BI Power Pivot Excel Pivot Kibana ETL Tools • • • Other • • • • PL SQL/T-SQL SSIS SSAS MS Visio MS Project SharePoint 2013 D365 Data Management and Entities Management EMPLOYMENT HISTORY Sr. Software Engineer BI Oct-2017 - Present System Pvt. Ltd. - Reviewing business requirement, developing conceptual approaches, designing and development of various BI and analytics components. - Partner with application developers, architects, engineers, and various groups supporting applications to develop and test on new initiatives. - Collaborating with project and development teams to ensure on time delivery of projects, production support plans, and knowledge transfer for long-term supportability of upgrades, - EDUCATION -B.E in Computer Information System (2012) N.E.D University of Engineering and Technology - Develop close working relationships and dependencies with members of teams within the organization. - Develop Business Intelligence applications utilizing all possible information delivery channels. - Work closely with data architects, application development, ETL development team to design and implement BI applications using shared architecture and Enterprise Data Warehouse. - Mentor junior team members, develop departmental procedures and best practices standards. -H.S.E in Pre Engineering (2008) Govt. Degree Science College Malir Cantt. -S.S.C in Computer Science (2006) Shaheen Public Sec. School AWARDS & RECOGNITION - Business Intelligence Developer May, 2014-Sep, 2017 Performance Recognition – 2016 From Sybrid Pvt.Ltd Sybrid Private Ltd – A Lakson Group Company - Developed End to End solution of BI Using Microsoft Stack - Developed Dashboards Scorecards and Reports using SSRS Performance Point Excel Services - Develop reports from a variety of data sources including Analysis Services Cubes and relational databases - Design and developed ETL Processes - Provide timely and appropriate communication to business owners stakeholders and users on issue status and resolution - Proactively create and maintain system support and process documentation - Work closely with Operations and Business Owners to ensure accuracy and completeness - Provide data analysis and identify data related issues within the Data Warehouse environment as well as upstream systems, as needed PROJECTS • Dynamics-365: Data Migration and Power BI Dashboard and Reporting Client: Khaadi • Asterisk: Data Migration and Reporting for Call Center Client: MacDonald’s, OPTP, California Pizza, Uniliver, Indus Motors • Transite POS: Data Migration and Reporting Client: OPTP • Online OrderTaking System: Data Structure Design and Reporting enhancements, and deployments. Identify existing productivity issues and opportunities, develop methods and systems to improve these functions, and manage their implementation. Analyst Software Engineer Mar, 2013-Apr, 2014 Client: California Pizza, OPTP DGS Private Ltd. - Extract Transform Load (ETL) development using SQL Server Integration Services (SSIS). Created new database objects like Tables, Procedures, Functions, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2005/2008. • Financial & Budget Reporting • Project Management System: Database Structure Designing and Reporting • Human Capital Management System: Database Structure Designing and Reporting - Tuning queries which are running slow by using different Methods in terms of evaluating joins, indexes, updating Statistics and code modifications. • Inventory Management System: Database Structure Designing and Reporting - Created complex stored Procedures and other SQL Joins and Statements for Applications by using T-SQL. - • Time Management System: Database Structure Designing and Reporting Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS). - • Quiz Management System: Database Structure Designing and Reporting Installed, authored, and managed reports using SQL Server 2005 Reporting Services • Multiple Management Reporting on SharePoint 2013 INTERNSHIPS 9th June 2011 – 7th July 2011 1st Dec 2010 – 12th Jan 2011 7th June 2010 – 15th July 2010 Sui Southern Gas Company Limited (SSGC) Clarinet Pakistan Limited Sidat Hyder Morshed Associate & Management Consulting Pvt Ltd