Ankur Jain

•Migrate data to consolidate legacy ERP & Financial applications data to MS Dynamics AX 2012 R3 databases in MS SQL Server 2014
•Create & maintain SQL Server Integration Services(SSIS) projects, design/data mapping documents on Team Foundation Server using Visual Studio 2013 for data migration projects
•Regularly check-in, check-outs & communication in TFS to ensure no conflicts in development phase
•Perform data profiling, cleansing & validation activities for ETL
•Developed more than 15 ETL (SSIS packages) to load data to destinations using CSV, FLAT Files, Excel, Oracle, SQL Server as sources
•Key ETL’s created to load Items Master, Vendor & Customer, Bank Account, Address, Fixed Assets, Product Master, Open AP/AR, Current/Operation GL
•Created databases, tables, stored procedure, trigger to maintain consistency for different stages of projects
•Perform database maintenance activities (backup, restore, indexing, job monitoring) for project development & test instances
•Working on LCN project to migrate data from AS400 & MFG/PRO to MS Dynamics AX database
•Automate the source file download process from Share-Point (Office 365) to the server location
•Create project Technical, Functional, Design, Data mapping & Data flow documents for all ETL used to migrate data from source to destination
•Requirements gathering by coordinating with the stakeholders within US & EMEIA region
•Conduct status call to provide update on In-Progress projects
•Coordinate with onsite counterparts to manage the pipeline projects
•Performed post Data migration activity by running AX consistency checks on all AX program/modules to ensure no redundant data exists in database
•Assist Business Intelligence team in defining the data flow in SSIS packages for Data warehousing activities
•Provide training/knowledge transfer on project scope, requirements, SSIS process to new joiners in team

•Act as one of the primary contacts for support calls escalated to the Application team for applications like iScala, eBackOffice, Doclink, GetPaid, Cognos, etc.
•Perform application (iScala) configuration, monitoring, and security administration
•Assist with projects to improve the business process and work to understand the needs of the departments
•Work closely with database and systems administrators on current production system changes
•Support application development, testing and implementation
•Work with 3rd party vendors to achieve support for some applications
•Upgrade application platform such as iScala with newer versions when necessary and convert legacy data to new systems
•Creating reports and reporting tools to assist the business in Management information
•Creating solutions using SSIS to assist with Integration to/from other systems to ensure integrity of data flows in ERP applications like ERP 10, iScala
•Creating data transformation & migration solutions in SQL Server (T-SQL, SSIS) to enhance applications workflow and for better user reporting experience
•Customization & administration of internal SharePoint portals UI to capture details of business functions like Human Resources, Facility, Finance and IT
•Alignment of iScala administration console for users, security, permissions & reports
•Developed various SQL objects for reporting needs from Account Receivable, security, compliance & audit teams
•Created SSRS reports for user access, application security, permissions & audit
•Implemented SQL solutions to store data from Qualysguard’s XML’s to database
•Supporting onshore counterpart in IT service management to maintain high SLA’s for incidents, tasks & requests
•Deployed solution to automate time analytics report for facility time utilization

•Continuous interaction with the users, developers, architects for functionality issues prioritization
•Took responsibilities to lead various client interactions to elicit requirements from stakeholders
•Developed & Deployed T-SQL, SQL Server, ETL solutions, data fixes, data transformation, integrations & data migrations in Application Minor Enhancements (AME) & Application Development (AD) projects
•Requirements gathering, planning, designing, developing, testing by adhering SDLC with waterfall model
•Worked as individual contributor & team player on multiple small (70-150 hours), mid-level (200-350 hours), major (500+ hours) projects
•Led the division involved in defining test cases, test scripts, test scenarios, UAT coordination
•Demonstrated excellence in preparing functional/technical document, system requirements, design requirements & user guides for the applications in an effective manner
•Supported project releases and produced documents for change, deployment, configuration and deployments
•Migrated MS Access database to SQL Server using SQL Server Migration Assistant
•Managed the source code & administer the MS Visual Source Safe 6 & Team Foundation Server 2010 for application version Control
•Proven Proficiency in data transformation like Derived Column, For-Each & Sequence container
•Produced weekly, dart, monthly reports & dashboards in excel (macro) for incident, tasks & change records from ITSM tools like Maximo & Cherwell
•Developed a web application on for internal project knowledge sharing sessions tracking and employee time utilization on trainings
•Coordinating with multiple teams and 3rd parties involved in project to make sure correct and accurate information were gathered for user/client support
•SME for credit control application which process more than 100, 000 policies, claims and transactional data on daily basis for final settlements
•Successful 4 month’s onsite role in client office as delivery engineer for multiple enhancements entitled to improve the application workflow for the client