Business Intelligence Developer
- MaintenantDéveloppement informatique Responsibilities
• Working as a Developer in MSBI technology from New York, USA.
(2 years from Pune, India and 8 months from NY,USA)
• Requirement gathering from Project Owners, and to design the solution for it.
• Aware of MS SQL 2008 R2, MS SQL 2012 (Experience in writing complex queries)
• SSIS- Have experience in creating packages. (Loading data from text, csv, excel files, cleansing data (use of different transformations), use of SQL, Oracle database and different file formats as destination.)
• PDW (Parallel Data warehouse).Was involved in migration of old Data Warehouse based on SQL to PDW (APS appliance). The change was done to transform from batch file load to near real-time load using Tibco BW. Was involved in Mapping (extensive data analysis and understanding domain and handling exceptions), Coding, Unit testing, Bug Fixing and Production Deployment.
• SSAS (multidimensional) . Worked on existing cubes to add an attribute, to change a dimension, Change in MDX queries, Deploy the cube on Analysis Server. Can work independently if assigned on SSAS.
• Also worked on SSRS,, to change the colour of the field on value, tables, Tablix, add a particular field, Change underlying Dataset queries, Deploy the report on SSRS server. Can work independently if assigned on SSRS.
• Involved in Production Data Bug fixing (Understanding Data, Designing a logic to incorporate ,Coding the logic in SQL and SSIS, Fixing present and old data(One time fix))
• For maintenance, provide on call production support for SQL Server Agent jobs.
• Guides offshore colleagues in terms of technical aspects.