Profile image of gnrupesh
@gnrupesh
Flag of Canada Calgary, Canada
Member since November 20, 2010
0 Recommendations

gnrupesh

Online Offline
IT engineer with 11 years of experience with Python, SQL, PL/SQL, Informatica, SQL Server, Oracle, MS Access, MS Office, Analytics, Reporting (Python, Power BI, Tableau), Data Warehousing, Database and SQL Performance Tuning, SSIS, SSRS, SSAS, MS Access, MS Project, VBA (Macros), Application and Data Warehouse Integration, C, VB .Net, C#, HTML, CSS, PHP, JavaScript, Shell and Batch Scripting. Looking forward to take up multiple freelance assignments.
$60 USD/hr
2 reviews
1.5
  • 100%Jobs Completed
  • 100%On Budget
  • 100%On Time
  • N/ARepeat Hire Rate

Portfolio Items

Recent Reviews

  • image of Ashok M. SQL server to MYSQL conversion $25.00 USD

    “process steps are simple to understand.”

  • image of Rio S. Sql Server Analysis Services (To develop Apriori Algorthim) $30.00 USD

    “Great coder with amazing analytical skills and strong communication skills. He pick up things quite quickly and know exactly what his client looking for. I recommend this coder, I'll definitely work with him in future. Once again strongly recommended!”

Experience

Data & Analytics Specialist

Apr 2019

• Responsible for gathering Business Intelligence (BI) reporting requirements from clients • Responsible for implementation and development of Data Virtualization layer for client Business Intelligence (BI) and Analytics requirements, using Data Virtualization tool Denodo • Responsible for development of BI reports and corresponding processes using tools such as Power BI, Microsoft MDS (Master Data Services), Power Apps, Flow etc.,

Senior ETL Developer & Lead & Data Analyst

Mar 2015 - Mar 2019 (4 years)

• Worked with tools such as Hadoop (Hive), IBM DataStage, IBM CDC, SQL, Microsoft SQL Server, Microsoft SSIS, Altova XMLSpy, MariaDB, JIRA, Confluence, Integration Bus, MQ Explorer, etc., • Responsible for Analysis, Design & Development of the interfaces between various applications associated with Mark’s, FGL & Canadian Tire Corporation businesses.

Enterprise Data Warehouse Specialist

Feb 2014 - Jan 2015 (11 months)

• Responsible for the development and maintenance of Enterprise Data Warehouse (EDW) of Canadian Pacific Railway and the ETL data feeds that provide data to the EDW • Worked with Informatica Power Exchange & Power Center, Business Objects, QlikView, CDCs, Informatica Mainframe Connector for SEQ and VSAM files; coordinated scheduling of Control-M jobs; provided on-call support

Sr. Technical Consultant

Jun 2008 - Oct 2013 (5 years)

Over 5 years of experience with Oracle, SQL Server, SQL, PL/SQL programming, Informatica, Data Warehousing, Database and SQL Performance Tuning, SSIS, SSRS, SSAS, MS Access, MS Project, MS Office, VBA (Macros), Application and Data Warehouse Integration, Shell and Batch Scripting

Education

B. Tech

2004 - 2008 (4 years)

Certifications

  • US English Level 1
    98%
  • Numeracy 1
    94%
  • SQL Level 1
    90%

Verifications

  • Facebook Connected
  • Preferred Freelancer
  • Payment Verified
  • Phone Verified
  • Identity Verified
  • Email Verified

My Top Skills

Browse Similar Freelancers