Experience

SwiftWIN | A Concord Company

• United States
• Information Technology & Services
• 100 - 200 Employee

• Technical Lead

  • Dec 2018 - Present

  Technologies/Tools : UNIX, IBM Datastage 11.5, win SQL, SQL Developer, Putty, Winscp, Control M, Service Now, Axway, PosgreSQL, Impala and Hadoop (basics)Client : MichaelsPROJECT: MichaelsMichaels is an online E-commerce shopping website in the United States, originally established in 2003. The company maintains multiple databases for maintaining Inventory, Financial data, reporting data, store positioning data. Being in ETL, our role is to bridge the data between these systems.Also Major DB systems migrations were done. So all the transitions from one DB to another DB was handled.Datastage to Talend migration is also underway.Apart from this, the support is also being handled by our team.Axway is employed for File transfers between multiple Vendors. Accounts and route creation and maintenance is handled.Michaels has a lot of subsidiaries and third party vendors, various warehouses which are all connected with one another via ETL.



Tata Consultancy Services

• India
• IT Services and IT Consulting
• 700 & Above Employee

• IT Analyst

  • Jan 2015 - Dec 2018

  Technologies/Tools : UNIX, IBM Datastage 8.5, 11.3, SQL Dbx, Winscp, CognosClient : FCA US LLC (formerly Chrysler Group LLC)PROJECT: Learning Management SystemThe Learning Management System is used to provide training to the Chrysler (FCA) employees as well as the Dealerships that Chrysler (FCA) has across the globe. Training of associates plays a key role in providing them the required knowledge to get their job done without any issues. We have two Learning Management Systems, one for the Chrysler (FCA) Employees and another for Dealerships of Chrysler (FCA). It is utmost important that we as the development and support team maintain the systems availability at all times. The availability and functioning of these two systems is very critical for the Business. As the market is growing every day, we always have a scope for new initiatives that come up which requires the development team to work in an agile environment and deliver the projects without any issues. • Development:> Discuss with clients for requirements gathering, Impact Analysis enabling them to build BRDs, > Provide the estimates, Formulate Design documents. > Design, test and monitor the ETL jobs in Datastage.> Adhering to the business processes and quality to deliver the perfect output. > Propose innovative ideas to enhance and improve the application.> Managing the team of 6, grooming the new joiners, Knowledge Sharing and practical sessions on the tools (Datastage, SQL and UNIX).• Support:> Formulate Requirement Documents for any support enhancements.> Calls on a daily basis with different vendors and weekly meetings with the vendors.> Complete handle on the support activities in the Project and adherence to the SLA’s defined by the client.> Co-ordinate with more than 25 teams (upstream, downstream and vendors) for resolving issues reported by the customers or when needed.> Co-ordinate with the infrastructure team for any infrastructure changes required.



TCS

• Systems Engineer

  • Oct 2013 - Dec 2014

  Technologies/Tools : C++, UNIX and Sybase.Client : FCA US LLC (formerly Chrysler Group LLC)PROJECT: Integrated Sales PlanningThe Integrated Sales Planning (ISP) is a web based planning system for Fiat Chrysler Academy (FCA). ISP deals with Sales planning, Forecasting for FCA. This planning tool helps the regional offices to develop sales forecasts, as well as review, consolidate, create what-if scenarios, and approve forecasts submitted by MPUs/ Distributors. ISP mainly deals with the plan creation and enables MPUs for entering the forecasting numbers. The forecasts from ISP are used to determine monthly allocation requirements and reserve production capacity within the plants. RESPONSIBILITIES: Understanding the business requirements and developing the same using C++, UNIX and Sybase.