Expert Data warehouse,Business Intelligence Developer with demonstrated experience working in multiple domains like...
- Verfügbarkeit einsehen
- 0 Referenzen
- auf Anfrage
- 503002 Nizamabad
- auf Anfrage
- hi | en | de
- 01.01.2019
Kurzvorstellung
Qualifikationen
Projekt‐ & Berufserfahrung
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.
Microsoft Business Intelligence, Predictive Analytics, Transact-Sql, Microsoft SQL Server Analysis Services (SSAS), Data Warehousing, Microsoft SQL-Server (MS SQL)
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.
Microsoft Business Intelligence, Transact-Sql, Microsoft SQL Server Analysis Services (SSAS), Data Warehousing, Microsoft SQL-Server (MS SQL)
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.
Microsoft Business Intelligence, Transact-Sql, Microsoft SQL Server Analysis Services (SSAS), Microsoft SQL-Server (MS SQL)
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.
Microsoft Business Intelligence, Transact-Sql, Microsoft SQL Server Analysis Services (SSAS), Data Warehousing, Microsoft SQL-Server (MS SQL)
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.
Microsoft Business Intelligence, Transact-Sql, Microsoft SQL Server Reporting Services (SSRS), Microsoft SQL Server Analysis Services (SSAS), Data Warehousing, Microsoft SQL-Server (MS SQL)
4/2008 – 3/2010
TätigkeitsbeschreibungBusiness 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 QualifikationenMicrosoft Business Intelligence, Transact-Sql, Microsoft SQL-Server (MS SQL)
12/2006 – 4/2008
TätigkeitsbeschreibungResolved 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 QualifikationenMicrosoft Business Intelligence, Transact-Sql, Microsoft SQL-Server (MS SQL)
Ausbildung
Aurangabad
Über mich
Weitere Kenntnisse
Persönliche Daten
- Deutsch (Grundkenntnisse)
- Englisch (Fließend)
- Hindi (Muttersprache)
- Europäische Union
Kontaktdaten
Nur registrierte PREMIUM-Mitglieder von freelance.de können Kontaktdaten einsehen.
Jetzt Mitglied werden