Experience with a demonstrated history of working in computer software industry as Data Warehousing and Business Intelligence combined. Skilled in Data Analysis, Data Visualization, Data Warehousing and Structured Query Language, T-SQL/PL-SQL Store Procedure and Packages. Currently working as ETL and BI developer on multiple projects in finance and E-commerce related domains and Scripting of complex SQL Queries. Have good analytical & design skills, focused approach and professional attitude to work
SKILLS:
• BI application development,deployment and UAT.
• Expertise in conceptual, logical and physical data modeling.
• Hand-on experience with market leading ETL tools like Talend Data Integration, Pentaho Data Integration
• Experience in DWH with Substantial knowledge of E-Commerce and Finance domains
• Experience in working Agile Application Development Structure like JIRA
• Working knowledge of complete Data Warehouse development life cycle
• Exposure to large data volumes in major database systems like MSSQL Server, Oracle, Postgres, MySQL
• Deep knowledge of SQL and reporting Experience in Tableau, MicroStrategy and power BI
TECHNOLOGIES:
Data Integration Tools
Pentaho Data Integration:- 6.0 , 6.1
Talend Data Integration:- 6.3 , 6.5 , 7.1
SSIS
Informatica Power Center
BI Tools
MicroStrategy V15
Tableau
Power BI
Databases
Oracle
MSSQL
TeraData
MySQL
Postgres
• Analyze the source data coming from various heterogeneous data sources to be consumed in the ETL
procedures to load data in to data warehouse Targets using Talend.
• Working on Talend Data Integration tool.
• Created ETL routines for banking industry from different sources.
• Scheduling of Talend routines.
• Uploading and extracting data from API’s by sending request through Talend rest component
• Developed different KYC dashboard using Power BI
• Design different SQL and PL/SQL queries for data integration
• Developed various mappings to perform ETL of source data into the OLAP/data warehouse.
• Complex analytical reports with strong coding of SQL by using SQL Developer.
• Developed different types of reports (group reports)
• Developed complex store procedure using T-SQL
• Query Optimization
Confidential Khyber-Pakhtunkhwa Elementary & Secondary Education and Higher Education Department required consolidation and prompt reporting for multiple operational systems in place for Education domain, in order to enhance monitoring, evaluation and planning of Elementary & Secondary Education department, an Integrated EMIS Solution.
Roles and Responsibilities:
• To attend meetings and get the business requirements.
• BI application planning, design, development, deployment and UAT.
• Develop data marts and cubes used in business intelligence analysis
• Performing Data Integration and Data processing using SQL Developer.
• Integration of data from heterogeneous sources such as MS SQL Server, MYSQL, flat file MS Excel, csv files.
• Design different SQL and PL/SQL queries for data integration.
• Managed and Performed ETL operations.
• Developed various mappings to perform ETL of source data into the OLAP/data warehouse.
• Apply Aggregation and Reconciliation on data for reports
• Complex analytical reports with strong coding of SQL by using SQL Developer. • Dashboard, analysis and KPIs using FORIS Analytics, Product of Sitronics Telecom Solitons.