Big Data Consultant
BCM Tech
Total des années d'expérience :10 years, 2 Mois
Conducting business requirement analysis, data modeling and development. Interacting with clients and compiling requirement specifications from clients. Leading project teams, resolving T-SQL query performance issues by checking execution plan and rewriting query or adding missing indexes
Utilizing T-SQL to pull data from various databases and creating various dashboards, scorecards and reports to support business decision making processes. Handling SQL queries, generating ad-hoc reports, sub-reports, drill-down reports, drill-through reports and parameterized reports to provide visible data for data analysts and business using LANTERN BI Suite. Applying various data transformations like merge, aggregate, sort, multicasting, conditional split and derived column
Extracting data from SQL Server and Oracle tables into flat data files and Excel sheets. Creating database tables with various data types, constraints (primary key, foreign key, unique, check, default, etc.) and indexes (clustered index and non-clustered index) in Oracle DB & SQL Server.
Supported, maintained and developed customized ERP. Assisted in design of tables, databases, forms, procedures, functions and reports; connected forms and reports with Oracle ERP Applications
Developed applications through Oracle using SQL, Pl/SQL. Updated company website and developed new reports and forms using oracle fusion Middleware 11g
Build and manipulate WordPress websites.
Edit and repurpose WordPress plugins in accordance to customer’s needs.
Perform quality assurance tests on all web projects.
Perform activities to optimize websites for search engine optimization.
Comsats Institute of Information Technology - Off Defence Road Raiwind Road, Lahore | BS in Computer Science, 30-Jan 2014
Fazaia Intermediate College, Munir Road, Lahore | FSC (Pre-Eng.), 2009
Fazaia Intermediate College, Munir Road, Lahore | Matriculation, 2007