Sid Khan Email & Phone Number

Redwood City, Ca

Develop and customize solutions in Dynamic AX R3 using X++ and morphx IDE. Experience in Inventory, Transportation, Procurement and Sourcing, AR, AP, and GL modules, good understanding and experience in supporting manufacturing, sales order processing, distribution and shipment operations involving third party logistics , support data migration using DIXF, Support Sales Order Processing and FDA quality compliance SSIS Packages, jobs, stored procedures and functions, support data analytics with Power BI and OLAP Cubes, set up batch processing, Support in Dynamics AX users security set up and administration, performance monitoring and tuning using Dynamics AX Trace Parser. Multiple global implementations

Greater New York City Area

• Creating database objects such as tables, views, Triggers, Stored procedures, and indexes • Configure Database Mail, Operator and Notifications • Using Joins and sub-queries for complex queries involving multiple tables from different databases. • Performance tuning for better running of queries. • Designing a warehouse system to maintain periodic data in SQL Server working with SSDT, which include SSIS, SSAS, and SSRS • Created SSIS packages to retrieve data from Legacy sources and also to retrieve user data from the Flat files in a scheduled manner. • Designed SSIS Templates for developing SSIS Packages in such a way that they can be dynamically deployed into Development, Testing and Production Environments. • Created packages in SSIS using proper control flow and data flow elements. • Created checkpoints and configuration files in SSIS packages • Design incremental data load packages in SSIS using CDC, meta-data based extraction and other implementations • Creating Tabular, Dynamic Matrix reports, Charts and graphs using SSRS. • Implemented Drill Down/up functionality in various reports. • Scheduling subscription reports with the subscription report wizard. • Creating Dashboard Reports to view personalized reports based on user requirements. Environment: SQL Server 2008, SQL Server 2012, SSIS, SSRS, T-SQL, Windows XP.

Bachelor'S Degree, Computer Science

Master Of Science (Ms), Computer Science