Highlights:

Skills:SSIS, SSAS

Technology Architect 11/2014 - 11/2019
Infosys Ltd., Milwaukee, Wisconsin United States
Industry: Information Technology
Working as Technology Architect, managed teams of data engineers and analyst for SSIS & Informatica ETLs, SSAS tabular model and data warehosing. Data visualization with Power BI and data analysis with SAS, Alteryx.
?Requirement gathering from metrics owners to understand the analysis that is expected out of the data. Developing business logic for importing the data for such analysis. ?Developing data labs to store data from diverse sources including flat flies, spreadsheets, different RDBMS databases such as Sybase, DB2, and SQL Server. ?Utilizing ETL tools SSIS and Informatica for developing the Data warehouse loads with Data Acquisition and Data Integration involving source databases such as DB2 , SQL server, Sybase or flat files, Excel files and Target databases such as SQL server, Excel files and Flat Files. ?Developing operational dashboards using Power BI for showing the performance of various divisions of Insurance operations of process improvement initiatives. ?Designing complex mappings in Informatica 10.2, creating workflow tasks and sessions, and moving it to production environment from staging with repository manager. ?Designing Fact and Dimension Tables as per the reporting requirements and ease of future enhancements. ?Designing and developing complex mappings applying various transformations such as lookup, derived column, aggregator, merge, merge join, conditional split and sort transformations. ?Creating database objects such as tables, views, stored procedures, Triggers etc. ?Maintaining referential integrity, domain integrity and column integrity by using the available options such as constraints. ?Identifying and creating columns for Primary Keys, Foreign keys in all the tables at the design time. ?Developing tabular model on the relational tables to generate the analysis, and developing quad chart reporting based on these tabular models. Analyzed the data stored in the datawarehouse with Alteryx tool and created reports for decision management--

Login to view resume: Vivek_Singh_Resume -