Ashwin Chaudhari Email & Phone Number

Mississauga, Ontario, Canada

Toronto, Ontario, Canada

Discuss the System Requirement Specifications for the project's sprints with the Business System Analyst on the Portfolios. Create Table, Views and Stored procedures on the SQL Server Cloud environment– with complex validation, transformation code and logic to meet the project specification outlined in the SRS. Identify any flaws with the requirement and discuss with the BSA's to get new requirement for the same. Create the framework script that supports the data imports, validations, dependency checks, transformations, exports and rejections. Create SQL Server Agent jobs that references Batch files to import the feed files, export the transformed data and report the rejections. Compare the database and check in the changes on the Team Foundation Server. Create the Deployment package from TFS (Full or Incremental release) deploy it to the DIT, SIT, and BAT (Sprint release) environment. Create the Release Notes for each deployment, keep track of the release version on each environment and coordinate the offshore testing team on the release. Daily create or update the defect tracking system such as JIRA or HP ALM on defect tracking for the Sprints.

Mississauga, Canada

Create and implement ETL (Extract, Transform, Load) processes and schemasCreate and maintain existing T-SQL code and DTS/SSIS packagesDefine and implement data transfer and data conversion strategiesDesigning data architectures to minimize duplication of data and maximize data consistencyCreating and managing database design, document and diagram logical database structureParticipating in the analysis of Client business objectives and scoping of projectsCoordinating and applying modifications to the database with project management and development staffCreating new SSIS packages and testing it in multiple environments (Demo, Development & Production)

Toronto, Canada

Responsible for all ETL(SSIS) operations using Microsoft Visual Studio within the Engineering group including client feeds, warehouse loads, and data extraction; transported the data to the target warehouseCreate reports using SSRS and provide data insights using SSAS cube to create dashboards for analysis to meet business needsParticipate in all aspects of data warehouse architecture in terms of design, development, testing and support Create packages, stored procedures, table schema, SQL code and overall solutions based on design specifications; this includes the improvement of existing processes or the implementation of new functionality Create automate streamlined process for a smooth flow of data from source vendor feed to datamart and finally to an offshore team using SSISTroubleshoot problems in ETL functionality and database during monthly maintenance cycle or Ad Hoc request using SQl Server ProfilerEngage with different source vendors and offshore teams regularly on the data feed issues and ongoing projectsManage clients by providing them weekly status update on projects, giving presentations on current system design and provide solutions to further enhance the systemCollect user requirements and maintain documentation related to current projectsInvolved in performance tuning, code promotion and testing of application changes