Project Manager
United States
•Data AnalyticsCreation of automated reports for different business lines in MicrosoftData validation to ensure data accuracy for different KPI in Microsoft Use of SQL, SSRS, Power Pivot and Power View, Visual Studio, as well as SharePoint Services to deploy on demand “live” reportingDeploy different levels of security access based on SQL as well as SharePointRemoval of manual processes, reducing timeline for execution from 3 days to one hour in some cases•New Program implementationDeployment and implementation of new programs with in the business, applying business rules as well as ensuring data accuracy.Clean up and validation of data provided by 3rd party provider in order to ensure all business rules are meet.Creation of reports based on SQL, SSRS , Power Pivot and Power View, as well as SharePoint Services•Deployment of calculation engineDeployment of a calculation engine for different programs in Microsoft, using and applying predefined rules and exceptions for +5,000 partners around the world – Based on SQL codeImplementation and deployment of a Windows Server as well as the entire database to process all required dataConnection to multiple Databases with in Microsoft, in order to map, all the relevant details needed for the calculation.Creation of an XML generation tool in order to load data into a third party interfaceCreation of a web interface in order to support the business:ASP basedUsed by support team to resolve inquiries from the field and internal stake holdersUsed by transactional team to process day to day activities without direct access to the databaseIntensive test, validation and approval of the entire automated calculation against manual calculation to ensure all rules and exceptions were properly appliedCreation of an audit trail of all activities performed by the transactional team, in order to be able to track down changes by the transactional teamTool allowed to maintain in SLA all processes