freiberufler Expert Data warehouse,Business Intelligence Developer with demonstrated experience working in multiple domains like retail,logistics,Insurance,Capital Markets. auf freelance.de

Expert Data warehouse,Business Intelligence Developer with demonstrated experience working in multiple domains like...

offline
  • auf Anfrage
  • 503002 Nizamabad
  • auf Anfrage
  • hi  |  en  |  de
  • 01.01.2019

Kurzvorstellung

Skills : Data warehouse,SQL,ETL Tools,MS SQL,Business Intelligence.I have worked with tools like SSIS,SSAS,Power BI,Informatica,Azure Data Factory,Azure Data Lake,Big Data,Machine Learning.

Qualifikationen

  • Datawarehouse / DWH
  • Microsoft Business Intelligence (BI)
  • Microsoft SQL-Server (MS SQL)
  • Microsoft SQL Server Analysis Services (SSAS)
  • Transact-SQL (T-SQL)

Projekt‐ & Berufserfahrung

Technical Leader (Festanstellung)
Kundenname anonymisiert, Client Location
12/2016 – 8/2017 (9 Monate)
Automobilindustrie
Tätigkeitszeitraum

12/2016 – 8/2017

Tätigkeitsbeschreibung

Data warehouse Design, development, participating in requirement gathering. Working on Logical, Physical Design of Database, ETL documentation, Design Documentation, Developing and executing reports and scheduling the daily data loads for reporting purposes Developing Stored Procedures for SSRS reports, Optimization & Performance tuning SQL code using Execution plan, profiler, interacting with the clients and finalizing the requirements and code deployment.. Participate in Proposal preparation, use cases for the analytics and cloud migration and POC activities.
Train and Mentor the team on product deliverables and prepare product documentation and KT to the clients.

Eingesetzte Qualifikationen

Microsoft Business Intelligence (BI), Predictive analytics, Transact-SQL (T-SQL), Microsoft SQL Server Analysis Services (SSAS), Datawarehouse / DWH, Microsoft SQL-Server (MS SQL)

Sr. BI Developer (Festanstellung)
Kundenname anonymisiert, Offshore
7/2016 – 11/2016 (5 Monate)
Dienstleistungsbranche
Tätigkeitszeitraum

7/2016 – 11/2016

Tätigkeitsbeschreibung

Working in SSAS Cube development, data warehousing, Report development using Power BI and Tableau tools. Worked on end to end implementation of the data warehouse using SSIS/SSAS and preparing Dashboards/reports using Power BI and Tableau, Data analytics, pattern finding, story building and visualizations using modeling techniques and tools
Worked on SVM, Linear Models for pattern recognition for validating the items shipped and tax levied for the exported and imported items
Applied data manipulation, cleansing and tuning the models developed by R.
Developing T-SQL code for reports and work performance tuning of Stored Procedures and mentor the team for best practices on SQL Coding, performance Optimization, tuning Design and reports
Assigning Tasks to the Team and updating the Client the status on day to day calls
Preparing ETL documentations, working on POC, Proposal preparation, validating the solution for presenting to the client and Code documentation and participate in client meeting to gather requirements.

Eingesetzte Qualifikationen

Microsoft Business Intelligence (BI), Transact-SQL (T-SQL), Microsoft SQL Server Analysis Services (SSAS), Datawarehouse / DWH, Microsoft SQL-Server (MS SQL)

Technical Lead (Festanstellung)
Kundenname anonymisiert, Offshore
12/2015 – 3/2016 (4 Monate)
Dienstleistungsbranche
Tätigkeitszeitraum

12/2015 – 3/2016

Tätigkeitsbeschreibung

Working in Analytics project, data analysis and transformation, reporting using Hadoop based Microsoft Azure, Power View visualization
Data is processed using the Azure server and reporting is done using Power View tool.
Working on development of SQL stored procedures, views for loading the data working on the data model for schema design and creating the tables for the application as per the ETL specification documentation.

Working on the design and development of data loads for the Operational Data Store and processing the information for the daily reports. Forecasting the estimated budget, billing hours required for the employee based on the task, project, and resource availability and utilization factors using the Power View tool.

Eingesetzte Qualifikationen

Microsoft Business Intelligence (BI), Transact-SQL (T-SQL), Microsoft SQL Server Analysis Services (SSAS), Microsoft SQL-Server (MS SQL)

Senior Software Engineer (Festanstellung)
Kundenname anonymisiert, Onshore
1/2015 – 10/2015 (10 Monate)
Dienstleistungsbranche
Tätigkeitszeitraum

1/2015 – 10/2015

Tätigkeitsbeschreibung

• Worked on Audit Engagement Management Systems being used by Auditors across the globe for the Audit purpose. Audit application enables the auditors to capture and record the financial, asset details of a company and perform and recommend the necessary the risk and compliance procedures.
• Participating in the SQL CRUD (Create, Read. Update & Delete) data cycles. Reviewing the Physical Data Model required for each sprint changes.
• Documenting the SQL code, maintaining version control and Code Release management by TFS.
• Working on index tuning and query optimization and SQL performance improvement.
• Debugging SSIS job failures and development/modifications of ETL as per the client requirements and enhancements.
• Prepare documentation related to Code enhancement and requirement analysis for the development efforts.
• Code debugging using SQL logs and SQL Profiler and Execution Plans and Error logs.
• Participate in Scrum meetings and Train, mentor junior team members on the Product and technical difficulties.
• Work on POCs and proposal for the solution approach to various use cases in Cloud environment.

Eingesetzte Qualifikationen

Microsoft Business Intelligence (BI), Transact-SQL (T-SQL), Microsoft SQL Server Analysis Services (SSAS), Datawarehouse / DWH, Microsoft SQL-Server (MS SQL)

Software Engineer (Festanstellung)
Kundenname anonymisiert, Offshore
4/2010 – 4/2013 (3 Jahre, 1 Monat)
Dienstleistungsbranche
Tätigkeitszeitraum

4/2010 – 4/2013

Tätigkeitsbeschreibung

• Worked in Data warehouse/database development role for Insurance based applications/products for a renowned North American Insurance Company.
• Resolved customer’s requirements on insurance application and database. The insurance applications were used to record the automobile insurance claims and process them.
• Study the business requirement and accordingly work on the SSIS ETL and SSAS Data mart development and deployment of packages. Study and prepare the design document for as LLD, HLD and SRS for application development.
• SQL Data- Analysis, support Participating in Data warehouse , Data modeling, Data Profiling activities T-SQL querying data and providing workarounds, scheduling and troubleshooting performance issues of MSBI batch jobs, packages, reporting to the clients
• Working closely with the QA team and participating in bug fixes/testing and sending the reports to the clients.

Eingesetzte Qualifikationen

Microsoft Business Intelligence (BI), Transact-SQL (T-SQL), Microsoft SQL Server Reporting Services (SSRS), Microsoft SQL Server Analysis Services (SSAS), Datawarehouse / DWH, Microsoft SQL-Server (MS SQL)

Engineer (Festanstellung)
Kundenname anonymisiert, Offshore
4/2008 – 3/2010 (2 Jahre)
Dienstleistungsbranche
Tätigkeitszeitraum

4/2008 – 3/2010

Tätigkeitsbeschreibung

Business data analysis, Maintenance of the database, troubleshooting any T-SQL query performance problems, maintenance of Back up and Restore jobs and scheduled batch jobs for data loading. Requirement gathering, enhancement and maintenance of the product

Eingesetzte Qualifikationen

Microsoft Business Intelligence (BI), Transact-SQL (T-SQL), Microsoft SQL-Server (MS SQL)

Support Specialist (Festanstellung)
Magic Software Enterprises Pvt Ltd, Offshore
12/2006 – 4/2008 (1 Jahr, 5 Monate)
Dienstleistungsbranche
Tätigkeitszeitraum

12/2006 – 4/2008

Tätigkeitsbeschreibung

Resolved database issues reported by customers related product functionality, participating in requirement gathering, documentation, enhancement, functional testing process.Involved in Level 2 support of the product,

Eingesetzte Qualifikationen

Microsoft Business Intelligence (BI), Transact-SQL (T-SQL), Microsoft SQL-Server (MS SQL)

Ausbildung

Bachelor Of Engineer
Computer Science Engineering
2005
Aurangabad

Über mich

I am an experienced IT professional and I am looking for for a full time long term contract.

Weitere Kenntnisse

MS SQL,T-SQL, SSAS,SSIS,SRS,MSBI,Power BI,Azure,ETL,Dimension Modelling,Data Modelling,Microsoft Business Intelligence,Data warehouse

Persönliche Daten

Sprache
  • Deutsch (Grundkenntnisse)
  • Englisch (Fließend)
  • Hindi (Muttersprache)
Reisebereitschaft
auf Anfrage
Arbeitserlaubnis
  • Europäische Union
Profilaufrufe
2068
Berufserfahrung
14 Jahre und 11 Monate (seit 04/2009)
Projektleitung
1 Jahr

Kontaktdaten

Nur registrierte PREMIUM-Mitglieder von freelance.de können Kontaktdaten einsehen.

Jetzt Mitglied werden