Crop Picture
NOTE: Do not upload any image that violates our Picture Policy. Doing so will result in the removal of the concerned image without prior notification.
Summary
A highly motivated individual having 4.5 year’s plus solid experience in Database Systems / ETL / Business Intelligence / Data Warehouse designing and development for leading international and domestic clients in various business domains including Leasing , Financing and Wholesale, Apparel and Textiles where I have performed in different roles like Technical/Delivery lead, Architect, Sr. developer, and business analyst. I have successfully performed in different projects and also have experience to work parallel on multiple projects. I have good experience of team management and also have managed multiple projects in parallel as Delivery/technical lead. I have strong analytical, problem solving and communication skills.
Skills
Currently working as Technical/Delivery Lead in 2 Business Intelligence (ETL/EDW/BI) Projects in leasing and financing domain. (Summit OTO Indonesia and Mercedes Benz China)
Strong expertise in designing, implementing and supporting the ETL jobs for data extraction from transactional systems to data warehouses systems.
Expertise in the concepts of Data Warehousing, Data Marts, ER Modeling, Dimensional Modeling, Fact and Dimensional Tables.
Strong expertise in designing, development and managing of different database systems.
Solid experience of Import/ Export data from different data sources like flat files, Oracle and SQL server through DTS, SSIS and Migrating SQL Server 2012 data bases into SQL Server 2014.
TOOLS TECHNOLOGIES
Business Intelligence, Data warehouse, MSBI Stack (SSIS,SSAS,SSRS), .Net
ETL Development SQL, PLSQL, SSIS, Unix Scripts
Databases SQL Server, Oracle, MySQL , Microsoft Access
Minor Tools and Technologies (Self Learning R&D)
• BI Tools == Power BI , Micro Strategy
• ETL Tools == Pentaho , Informatica
• Big Data == HDFS , MapReduce , Hive , Pig , Spark
• NoSQL == Casandra , Hbase , Mongo DB
Projects
Experience
Senior Software Engineer (Databases/ETL/Data Warehouse/BI)
Project: Summit OTO MIS (Jakarta Indonesia)
Role: Senior Databases/ETL/Data Warehouse/BI Developer
Team Size: 7 (6 Sr. Developers and 1 Associate Developer)
Task Performed:
• Design, development, implementing and supporting the ETL jobs for data extraction from transactional systems to data warehouses systems.
• Import/ Export data from different data sources like flat files, Oracle and SQL server through ETL, SSIS SQL Server 2014.
• Development activities include design and configuration of Send email task reports on success and failure of job.
• Prepare data ETL plans including migration risk, milestones, quality and business sign-off details
• Perform source system data analysis in order to manage source to target data mapping
• Perform migration and testing of static data and transaction data from one core system to another
• Perform data migration audit, reconciliation and exception reporting
• Manage cross-program data assurance for physical data items in source and target systems
• Creating and restructure the stored procedure, rebuild indexes at regular intervals for better performance, designing, coding and developing the same using the TSQL programming.
• Responsible for delivering tasks, task’s analysis and design, work estimations, assignments and client meetings for technical and status reporting.
• Perform unit testing of developed packages with respect to its flow and performance issues and solve the bugs reflected by the testing team.
• Development activities include design and development of database objects like Functions, Procedures, Packages and DB Triggers.
• Support activities which includes Proposal, Contract and Wholesale BI Production issues
• Analysis and providing solutions, ETL jobs monitoring and support, root cause analysis and suggesting solutions in case of production job failure.
Tool/Technologies Used: Microsoft (SSIS, SSAS, SSRS) 2013, SQL Server 2014, MS Visio, Red Gate SQL compare, Oracle 10g, PL\SQL, Toad.
Software Engineer
• Designing and Developing of ETL package to extract data from multiple data sources.
• Functions, Procedures, Packages, DB Triggers and Oracle reports development.
• Investigate user problems, identify their source, determine possible solutions, test and implement solutions.
Software Engineer
• Designing and Developing of ETL package to extract data from multiple data sources.
• Functions, Procedures, Packages, DB Triggers and Oracle reports development.
• Design and development of in-house business applications to support the organizational business processes.
• Investigate user problems, identify their source, determine possible solutions, test and implement solutions.
Software Engineer
•Import/ Export data from different data sources like flat files, Oracle and SQL server through ETL, SSIS SQL Server 2014.
• Development activities include design and configuration of Send email task reports on success and failure of job.
• Prepare data ETL plans including migration risk, milestones, quality and business sign-off details
• Perform source system data analysis in order to manage source to target data mapping
• Perform migration and testing of static data and transaction data from one core system to another
• Perform data migration audit, reconciliation and exception reporting
• Functions, Procedures, Packages, DB Triggers and Oracle reports development.
• Design and development of oracle forms and reports.
• Design and development of in-house business applications to support the organizational business processes.
• Investigate user problems, identify their source, determine possible solutions, test and implement solutions.
