Analyst with experience in business and finance area, with 6 years of experience organizing, modeling and analyzing data to forecast business trends. Efficient, decisive and thorough professional.
Worked in Microsoft WDG team. Responsible for handling data about all Windows Devices. Involved in assessing data related to all Microsoft products campaigning and product related information and present inference with managers to better improve their advertising by providing them insights on view by category, subsidiary, Form codes etc.
Worked with O365 Business Planning Team.
● Owned and implemented complete data analysis for Data Science group of O365 Platform.
● Extracted large sets of data, manipulated/transformed data using SCOPE, SQL and C# scripting through COSMOS to derive business interpretation.
● Building structured data pipelines.
● Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.
● Writing SQL stored procedures for displaying and updating data in dashboards with Power BI
● Developing Node.js script to access API's.
● Collaborated with senior management, Data scientists to define business requirements.
● User documentation with technical specifications and methods of process.
● Scheduling jobs on ongoing basis to monitor results.
● Project documentation.
Environment: Visual Studio 2010, SQL Server 2008, ASP.NET, C#, Quality Center, REST API, Visio PowerPoint
Project Description: Monitoring System is intended to deliver a system to support transaction management for the bank. The system is used for accepting loan forms, view history of transactions,
available balances etc.
Involved in development of sophisticated intranet system which performs assessment of the manpower required for accomplishing different projects in ISAC. The system should provide
information about applications, projects various divisions, activities, the required manpower and if necessary, their reallocation in different sections of ISAC. Main modules are: Manpower Assessment,
Scheduling and Control of Divisions.
Responsibilities:
● Involved in analyzing requirements and documenting.
● Prepared requirement analysis, design, coding.
● Involved in designing web forms.
● Client-side programming was done using C#
● Designed the queries, stored procedures using SQL server
● Prepared project documentation.
● performed unit testing, usability testing, user acceptance testing
Environment: C#.NET, SQL Server, Windows XP, Quality Center, Java script
MS SQL Server 2017 SSRS/SSIS, Power BI, SSRS, Excel, PowerPoint, Tableau, Xflow, MS Visio, MS Excel, MS Power Point, MS Project. C#, DAX, MDX, Cosmos, Knowledge on hive/spark/Python, Excel for Data Analysis, SCOPE script, R, Adobe Analytics omniture, Data analysis, basic Python scripting Excel,
undefined