Responsibilities

• Power BI developer- Built Analysis Services reporting models.
• Successfully delivered 15 System Use Cases (SUC) as per the requirement.
• Developed visual reports, dashboards and KPI scorecards using Power BI desktop.
• Connecting to data sources, importing data and transforming data for Business Intelligence.
• Excellent in analytical thinking for translating data into informative visuals and reports.
• Able to implement row level security on data and have an understanding of application security layer models in Power BI.
• Proficient in making DAX queries in Power BI desktop and also expertise high level calculations on dataset
• Able to develop tabular and multidimensional models that are compatible with warehouse standards.
• Adept in developing, publishing Power BI reports as per the business requirements and also developed custom visuals
• Able to properly understand the business requirements and develop data models accordingly by taking care of the resources.
• Having strong knowledge and skills for secondary tools such as Microsoft Excel , SQL data base etc.
• Successfully created new hierarchy in DRM and modified the prevailing hierarchy
• Strategically involved in wide spectrum of tasks entailing – development of action scripts, tab files to load data to DRM; generation & supervision of DRM functionalities like import/ export/blend/query/properties/validations and migration of DRM metadata like properties/exports /validations from one server to another using DRM Migration utility
• Efficiently generating users for the Data Governance workflows and granting permission to insert/update/delete data in DRM based on requirements.
• Lead a cross-functional team through all stages of project delivery, leveraging either Waterfall or Agile methodologies, resulting in a high-quality deliverable to the client.
• Used excellent communication skills to develop strong, trusting relationships with clients and internal staff across all levels of the organization
• Successfully managed all IT project scope, deliverables, goals and milestones including reviewing and signing off on all IT documentation and reports.
• Monitored  and controlled execution of project though analyse, design, build, test and release phases with proper documentation.
• Provided project status reports to executives. Coordinated team activities ensuring completion of the project on schedule and within budget constraints.

• Developed  high quality database solutions 
• Developed, implemented and optimized stored procedures and functions using SQL
• Reviewed and interpreted ongoing business report requirements
• Researched  required data
• Built appropriate and useful reporting deliverables
• Analyzed existing SQL queries for performance improvements
• Used SSIS to load the data from Microsoft Excel to the SQL Server Database Table
• Mapped the columns of the source to target and also changed the rules which ever applicable to make data accurate for entering into the table
• Corrected the error if any while running the SSIS job for loading data into the database table/
• Involved in creation and update of SQL Queries, procedures  to find required data value at certain point of time
• Leaded  project teams and manage cross-functional teams comprised of resources from the Professional Services delivery, sales, support, and R&D organizations as well as partners
• Managed 10 active projects of varying sizes
• Professionalism appropriate for working with Fortune 500 clients
• Having Knowledge of Project Management Methodologies

• Proficiently engaged in the wide scope of activities like – development/modification of Smart View Reports; connected to Essbase to load data amongst others.

• Diligently changed database objects in SQL Server/Oracle such as table/view/store procedure
• Used Master Data Service (MDS) Tool to enter , update delete data from SQL database
• Publish the data into SQL server from MDS tool once the data is set to view.
• Created/Maintained Data models/hierarchies in MDS using the data from database
• Created/modified the Rules in MDS for any data governance task in SQL database.
• Performed requirement analysis and provide solution architecture for MDM integration project.
• Supported  data architecture for Contract Management analytics initiative
• Reviewed requests from the field and business users providing guidance to requisite development team on required correction.
• Provided guidance to MDM operational requests and suggest operational efficiencies in MDM operations
• Strategically involved in wide spectrum of tasks entailing – development of action scripts, tab files to load data to DRM; generation & supervision of DRM functionalities like import/ export/blend/query/properties/validations etc.
• Efficiently generating users for the workflows and granting permission to insert/update/delete data in DRM based on requirements.
• Actively handled wide array of tasks which included - managing exports/blend/import functionalities; migrated DRM Metadata utilizing DRM migration utility from source server to destination server and generated Tab files for the Hierarchies to be newly created.