Software Specialist / ETL Developer
Keywords
Skills
Tableau, Power BI, Kimball, Inmon techniques, Data Analysis, Expression language, DAX, Informatica Power Center, Database, Cassandra 3.0, Oracle 11g, SQL Server 2005, DB2 10.1, HiRdB SQL Executer, Erwin, Microsoft VISIO, SFTP, SAP, metadata, Cloud, blobs, Azure Cloud Architect, ETL, Alteryx, PowerBI, Visualization, data quality, requirement gathering, data modeling
Project history
07/2016
-
10/2018
* Formulated overall data architecture in Banking, Vehicle fleet services systems and schools
domains that hold key information of both Operational and Regulatory reporting
* Preliminary detail oriented requirement gathering and creation
of Data Model
* Drafted and validated data modeling techniques feasible for loading data into the warehouse
* Systematized design with Users/Product owners to map requirements, align priorities and
interactively develop solutions
* Mentored business users and contributed with team to help provide accurate solutions to cleanse
and optimize data for better performance and continuous data quality improvement for loading
voluminous data
* Liaised with end users on project related inquiries and provided documentation on artifacts as
part of overall technical documentation
* Customized reports so that end user/Product owners can use it for analytic purposes and upscale
the team if required
* Contributed with team to ensure robust and high quality solutions are delivered
domains that hold key information of both Operational and Regulatory reporting
* Preliminary detail oriented requirement gathering and creation
of Data Model
* Drafted and validated data modeling techniques feasible for loading data into the warehouse
* Systematized design with Users/Product owners to map requirements, align priorities and
interactively develop solutions
* Mentored business users and contributed with team to help provide accurate solutions to cleanse
and optimize data for better performance and continuous data quality improvement for loading
voluminous data
* Liaised with end users on project related inquiries and provided documentation on artifacts as
part of overall technical documentation
* Customized reports so that end user/Product owners can use it for analytic purposes and upscale
the team if required
* Contributed with team to ensure robust and high quality solutions are delivered
04/2008
-
06/2012
Software Specialist
Mastek Limited
Reporting Tools:
Tableau, Microsoft Power BI
Database:
Cassandra 3.0, Oracle 11g, SQL Server 2005, DB2 10.1, HiRdB
SQL Executer
Design Tools:
Erwin, Microsoft VISIO
* Gathered overall architecture based on fast moving consumer goods (FMCG)
* Collaborated with Users/Product and Business owners to understand requirements, align priorities
and interactively develop solutions
* Analyzed source data sets from multiple sources like SFTP,SAP systems and Nielsen csv metadata
files across 9 European markets, incorporated it using Cloud Tools like Data Factory, Data Lake,
Data bricks and rewrote in blobs for multiple stakeholders
ON-GOING
* Azure Cloud Architect Certification
* Dutch A2 Level
* Streamlined a self service platform to handle data and maintain integrity for users from source
until target
* Improvised ETL processing using Alteryx - Data blending tool
* Based on output provided from Alteryx, delegated with team to create PowerBI -Visualization
strategic reports using DAX queries across European markets with advanced analytic programs by
enforcing best practices and providing solution to data quality issues
Tableau, Microsoft Power BI
Database:
Cassandra 3.0, Oracle 11g, SQL Server 2005, DB2 10.1, HiRdB
SQL Executer
Design Tools:
Erwin, Microsoft VISIO
* Gathered overall architecture based on fast moving consumer goods (FMCG)
* Collaborated with Users/Product and Business owners to understand requirements, align priorities
and interactively develop solutions
* Analyzed source data sets from multiple sources like SFTP,SAP systems and Nielsen csv metadata
files across 9 European markets, incorporated it using Cloud Tools like Data Factory, Data Lake,
Data bricks and rewrote in blobs for multiple stakeholders
ON-GOING
* Azure Cloud Architect Certification
* Dutch A2 Level
* Streamlined a self service platform to handle data and maintain integrity for users from source
until target
* Improvised ETL processing using Alteryx - Data blending tool
* Based on output provided from Alteryx, delegated with team to create PowerBI -Visualization
strategic reports using DAX queries across European markets with advanced analytic programs by
enforcing best practices and providing solution to data quality issues
Local Availability
Only available in these countries:
Poland
Currently in Mumbai, India.
I am ready to relocate to any location.
I am ready to relocate to any location.
