Swetha M Email & Phone Number

Project: Collect the data of customers corresponding to sales of different article types such as Suits, Vests, Pants, Accessories,… etc. Provide order level and customer level data to growth team for forecasting amount based on the actuals. Create custom reports for analysis of sales with respect to targets.· Working on loading data into Master Data Services(MDS) as configuration data. Create tables and update its definition when required.· Written stored procedures , views and sql queries to manipulate the raw data and transform accordingly.· Created SSIS packages to extract the data from different sources such as Snowplow, MySql, MDS..etc.· Updated the existing cubes with new measures and calculated columns.· Import and export solutions of SSIS and SSAS from one server to another.· Deploy solutions based on file system or server methodologies.· Create SSRS reports in report Builder , create data sources, establish connections at server url level.· Writing DAX queries as source to SSRS reports.· Troubleshoot data discrepancies at customer level, sales level, orders level, location level etc· Design, Develop, Test and Validate the packages, reports, cubes and deploy in Dev and Prod environments.· Create Power BI reports for Daily purposes. Schedule the report timings along with refresh. Work on Slicers, Filters to enhance the report functionalities.· Create reports in excel by pivoting the data from SSAS as source.· Provide efficiency and data quality in all the phases of SDLC.· Update Project status and documentation in JIRA , Confluence and Azure Github

 Worked on CRM to create front-end user application. Worked on Kingswaysoft tool to migrate data from sql to CRM. Resolved complicated scenarios while analyzing data about client and providers Working on multiple data types and tuning the performance while loading the data

 Offering technical services to various clients. Deals with the trouble shooting of Microsoft technology. Analyze the volume of the data and develop ETL packages for data transfer Work on establishing the connection between front-end and back-end with ODBC/OLE DB/ADO.NETconfigurations

 Created an android game based on trivia quiz. Designed and developed various modules with .NET and JavaScript frond end coding. Created SQL database to store questions and answers related to quiz game. Created functionality to process backend data to front end, for the customer usage. Developed design and for the answers received by the end users. Implemented coding to rate the skill set of the user based on the answers provided. Launched the application in all Android OS supporting mobiles and tablets.

Developed SSIS incremental load packages with conditional split, lookup transformations and mergestatements. Created daily and hourly scheduled jobs for the SSIS packages. Developed SSIS packages to extract data from azure to on premise with OLEDB and ADO.NETsources. Created the documentation according to the business requirement.

 Created dynamic configuration files for huge data transfers from and to sql server databases Designed star schema based on the facts and dimensions for representing data warehouse. Worked with DSV and cubes using dimension tables. Created datasets with the help of mdx scripts to perform report models