Harun R.
Passed Allshore's advanced assessmentPortfolio
Folio3
Optimized ETL for Oracle Data Mart and reduced time from six hours to 30 minutes. Optimized other PostgreSQL and Oracle databases from 12 hours to three hours including back up. Reduced downtime from two hours to zero. The report queries optimized from an average of 10 minutes execution time to a few seconds.
Tradekey
Established BI and Data Warehouse team for Tradekey, the world’s second largest B2B portal. Designed and developed data warehouse, BI dashboards, and reports for sales, marketing, and finance.
Experience
- MS SQL Server - 10+ years
- Oracle - 10+ years
- Power BI - 8 years
- SSRS - 10+ years
- SSIS - 10+ years
Availability
Preferred Environment
The most amazing...
You must do the things you think you cannot do.
Projects
Folio3
Optimized ETL for Oracle Data Mart and reduced time from six hours to 30 minutes. Optimized other PostgreSQL and Oracle databases from 12 hours to three hours including back up. Reduced downtime from two hours to zero. The report queries optimized from an average of 10 minutes execution time to a few seconds.
Tradekey
Established BI and Data Warehouse team for Tradekey, the world’s second largest B2B portal. Designed and developed data warehouse, BI dashboards, and reports for sales, marketing, and finance.
Work Experience
Allshore Virtual Staffing
- Hands on overall experience in project management, analysis, design, development, and support of business applications.
- Extensive experience with ERP applications, data warehouse and business intelligence solutions.
- Well versed project life cycle, PMI processes, business process re-engineering, and gap analysis.
- Mapping business functional requirements into technology solutions and project work plans.
- Managing complex project tasks and deploying distributed systems.
- Expertise in planning, modelling, implementation and management of IT/business policies/ controls, standards and procedures, development and deployment processes, and implementation strategies.
- Excellent technical skills in development of data models and data architecture strategy for 3 and n-tier applications, designing user interfaces, mapping business rules, writing business reports, normalization, de-normalization, physical database design, relational models, and star and snowflake schemas.
- Expertise in planning, designing and implementation of enterprise level IT setup, data center, and cloud based services like SaaS, PaaS, IaaS.
- Expertise in customer relationship management, client training, presentation, product proposal and demonstration, orientation seminars, documentation, development of manual and other print materials.
Chief Architect
Websorg Pvt. Ltd.
- Responsible for overall company operations including analyzing, proposing, and designing software solutions and infrastructure.
- Managed several large scale projects for textile industry.
- Worked on point-of-sales and Salesforce systems with SMS integration.
- Worked on IBM Maximo to Oracle EBS data migration and interface.
- Worked on project to standardize the item classification, attributes, measurements, values, and descriptions.
- Customized screens to display and search functionality for 1300 raw material items with approximately 150k attributes.
- Designed a simplified excel format and used Oracle External Table to develop generic ETL job to load, clean, and update data.
- Worked on query optimization and actuate report development project.
- Consulted on an SAP-Maximo integration project to help with seamless integration.
Senior BI/Data Architect
Shinesoft Pvt. Ltd.
- Worked with U.S. based team members on offshore BI/Data Warehousing projects.
- Worked on Data Warehouse for Hilton Hotels and Resorts.
- Worked for optimization of ETL SPs.
- Analyzed and optimized ETL packages being developed on IBM Datastage.
- Supported local development team on architecture and design of multiple applications regarding different business domains.
Education
Masters in Computer Science
University of Karachi
Bachelor in Physics
University of Karachi
- Schedule A
Free Consultation - Interview remote
Professionals - Meet Your team
- start your
10-day free trial
UNPRECEDENTED CUSTOMER SUPPORT
You have complete control over project management, priorities, and deadlines, but we’re here to help you succeed. Your Client Success Manager and Technical Success Managers are with you every step to ensure that our work for you it top notch. Feel free to use your project management system or our complimentary Basecamp account.
COMMUNICATION AND TRANSPARENCY
No project can be successful without effective communication. Our remote professionals are fluent English speakers, vetted and trained in effective communication and are available to you directly in real-time. We allow direct, real-time access to your team via Skype, GoToMeeting, or other communication software. You can have meetings on your time and get demos anytime you want.
AMERICAN OWNED AND OPERATED
Work with an American company under American laws and regulations. Our offshore employees work U.S. business hours so you can communicate directly with them. Our month-to-month contracts protect our clients’ intellectual property and projects, so you can focus worry-free on your work.
QUALITY WORK - GUARANTEED
Even after passing our rigorous interview process, our remote professionals are continuously training to learn new skills and keep up with changing trends in their fields. We guarantee our associates work, and have a 99.5% customer satisfaction rating. We take quality, and your success, seriously.