ASCO fluid automation solutions increase customers’ speed to market and rapidly turn their ideas into measurable outcomes. With the industry’s broadest range of ultra-reliable products, delivered and supported with exceptional speed and responsiveness, our portfolio includes more than 50,000 solenoid and pneumatic valves, cylinders and actuators, air preparation equipment, and accessories.

Working on below technologies for this project:

SSIS,SSAS,SQL,PowerBI

• Worked with integration services for transferring and reviewing data from heterogeneous sources like Excel, CSV, flat file, Text Format Data.
• Experience in SSIS (Integration Service) package design, constructing, and deployment.
• Worked on the Power BI reports & dashboards with SQL Server/Tabular SSAS sources.
• Used Table , Matrix , Bar, Card , Gauge , Slicers visualizations.
• Worked on Custom Visualizations like multi slicer and Hierarchy slicer.
• Worked on DAX expressions like filters, Aggregate, Mathematical Functions etc.
• Comfortable in working with filters/calculated columns/measures/relationships and transformations of Edit Query section.
• Worked on all administration part of PowerBI.
• Always involved in Sprint Planning with Manager.
• Use TFS (Team foundation server) source control tool to check in all of the codes in daily basis.
• Coordinate with development team, assign them tasks and help with any technical queries.
• Interacting with client on daily basis and providing team updates to them.
• Worked with integration services for transferring and reviewing data from heterogeneous sources like Excel, CSV, flat file, Text Format Data.
• Experience in SSIS (Integration Service) package design, constructing, and deployment.
• Worked on the Power BI reports & dashboards with SQL Server/Tabular SSAS sources.
• Used Table , Matrix , Bar, Card , Gauge , Slicers visualizations.
• Worked on Custom Visualizations like multi slicer and Hierarchy slicer.
• Worked on DAX expressions like filters, Aggregate, Mathematical Functions etc.
• Comfortable in working with filters/calculated columns/measures/relationships and transformations of Edit Query section.
• Worked on all administration part of PowerBI.
• Always involved in Sprint Planning with Manager.
• Use TFS (Team foundation server) source control tool to check in all of the codes in daily basis.
• Coordinate with development team, assign them tasks and help with any technical queries.
• Interacting with client on daily basis and providing team updates to them.

• Handling all data related to promotions and advertisements of the Products.
• Gathered business requirements, definition and design of the data sourcing and data flows.
• Primary responsibilities involved development of ETL job as per client requirements.
• Extracted data from various sources like SQL Server 2008,.CSV, Excel and Text file from Client servers and through FTP.
• The packages created by using a variety of transformations, for example Look up, Aggregate, Derived Column, Conditional Split, Multicast, Data Conversion, Merge join, Union all, etc.
• Expert in creating the SSIS Packages by applying the Business logic

• Primary responsibilities involved design and development of ETL job Flow with packages.
• Understanding of domain and business logics for various enhancements.
• Designing ETL to process the raw feeds.
• Testing the raw feeds against volumes and structures.
• Data Processing and Fault Handling for SQL / PL SQL queries.
• Studying the requirements and estimating accordingly.
• Conducting conference calls for review and maintain performance of front end and database.
• Uploading data in database tables on daily basis (ETL) data from various sources like Oracle, SQL Server and Flat files.