Technical Lead
CurrentImplementation:•Developing and implementing new technologies to improve efficiency or quality of operations•Designing information systems architecture and infrastructure to support organizational goals•Managing external vendors and contractors to ensure that projects are completed on time and within budgetFinancial & Data Warehouse:•Determine and define data warehouse project scope & objectives, design and develop data staging area. Manage vendors by assigning tasks and communicating expected deliverables•Preparing source-target data mapping, data modeling, and data validation. •Transform functional business to technical representation including STTM, BRS, SRS and design document. •Build and modify queries for faster and aggregated data loading into staging area.•Create best practices for data extraction, transformation, and loading (ETL) using Talend. Create Talend ETL job, security for job scheduling, file transfer management, code management, service up-&-running and platform upgrades. •Develop data architecture, data modeling like Dimensional, Fact, and Cube. Build master data management approach to represent org setup.•Stored & load the bulk data to staging area using ETL and make the best practices of data warehouse. Designs and builds data models for data to use in reporting and analytics using Power BI.• Working in Oracle FCCS to making dimension, data extraction ,loading, mapping and visualize it to oracle FCCS application. Build forms, reports using form builder and reporting studio. Manage oracle EPM agent.Software Development:• Leading to planning, business analysis and writing well-designed, test-driven & efficient code using the best practices of ASP.NET MVC, C#, OOP, SQL Server, Store procedure, Crystal Report, AngularJS, JQUERY, AJAX, JSON, HTML/CSS/Bootstrap. • Ensure integration through .NET web API between HR, Payroll, CBS, Accounts,JIRA, Redmine, Oracle Financial and closing, SAP SuccessFactors, ERP and so on.