Might be available
(Updated 2022-04-01)Data Engineer
Malmö, Sweden
Native English, Hindi, Fluent Kannada, Beginner Svenska
- 12+ years of experience as Data Engineer/BI Developer
- Strong knowledge of Cloud
- Great communication skills
Skills (38)
Amazon Cloudfront
Microsoft SQL Azure
SQL Azure
BI
Data Analysis
Business Intelligence
Amazon Elastic Block Storage
Amazon Elastic Compute Cloud
BEST PRACTICES
CloudFront
AWS EC2
Amazon Simple Storage Service
EBS
EC2
Clinical Trial Reports
BUSINESS REQUIREMENTS
ACROBAT
MARKETING ANALYSIS
STATISTICS
AWS
CLINICAL STUDIES
Load Balancing
ELB
BUDGET
CAM
SCHEDULING
DMS
AWS CERTIFIED
Amazon Web Services
FINANCIAL REPORTING
HEAT MAPS
Excel
SAS
PUBLISHING
CLINICAL TRIAL
Telecom
AWS S3
Summary
Proficient in AWS services like VPC, EC2, S3, ELB, Autoscaling Groups (ASG), RDS, EFS, IAM, CloudWatch, CloudFront, CloudTrail.
- Expertise in implementing AWS data engineering solution using AWS DMS, S3, Lambda, IAM, Firehouse, AWS RDS, Redshift.
- Experienced in creating multiple VPC's and public, private subnets as per requirement and distributed them as groups into various availability zones of the VPC.
- Created NAT gateways and instances to allow communication from the private instances to the internet through bastion hosts.
- Used security groups, network ACL's, internet gateways and route tables to ensure a secure zone for organization in AWS public cloud.
- Used IAM for creating roles, users, groups and implemented MFA to provide additional security to AWS account and its resources.
- Created and configured elastic load balancers and auto scaling groups to distribute the traffic and to have a cost efficient, fault tolerant and highly available environment.
- Design and Development of reports and dashboard out of cubes and FM package.
- Created EBS volumes for storing application files for use with EC2 instances whenever they are mounted to them.
- Configured S3 buckets with various life cycle policies to archive the infrequently accessed data to storage classes based on requirement.
- Maintained the monitoring and alerting of production and corporate servers using Cloud Watch service.
- Created snapshots to take backups of the volumes and images to store launch configurations of the EC2 instances.
- Expertise in Power BI, Power BI Pro, Power BI Mobile and Tableau.
- Expert in creating and developing Power BI Dashboards into rich look.
- Developed Power BI model used for financial reporting of P&L and Headcount.
- Designed and documented the entire Architecture of Power BI Poc.
- Expertise in writing complex DAX functions in Power BI and Power Pivot.
- Automated Power Query refresh using power shell script and windows task scheduler.
- Used various sources to pull data into Power BI such as Sql Server, SAP BW, Oracle, SQL Azure etc..
- Installed and configured Enterprise gateway and Personal gateway in Power bi service.
- Created Workspace and content packs for business users to view the developed reports.
- Scheduled Automatic refresh and scheduling refresh in power bi service.
- Wrote calculated columns, Measures queries in power bi desktop to show good data analysis techniques.
- Weekly presentation to the business users about the reports and their changes as required.
- Worked on all kind of reports such as Yearly, Quarterly, Monthly, and Daily.
- Worked on all types of transformations that are available in Power bi query editor.
- Hands on experience on Tableau Desktop versions 7/8.2, Tableau Reader and Tableau Server
- Built dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices.
- Involved in trouble shooting of performance issues which were associated with Tableau reports.
- Also involved in administration tasks such as publishing workbooks, setting permissions, managing ownerships, providing access to the users, and adding them to the specific group and scheduled instances for reports in Tableau Server.
- Primary contact for BI solution design, develop and server maintenance.
- Responsible for architecting, designing, implementing, and supporting cloud-based infrastructure and its solutions.
- Providing BI solutions using Tableau, Cognos Analytics, Power Bi.
- Design, Development, and deployment of Cognos Dynamic cubes.
- Expertise in Cognos Analytics installation and configuration.
- Experience with dimensional modeling using star schema and snowflake models.
- Migrate on prime server to AWS environment.
Professional Experience
2021-11 - Present
Company: Leoware IT Role: Data Architect BI tools: Power BI, Tableau.
AWS Cloud: AWS EC2, S3, VPC, AWS Glue, AWS RDS, Lambda, Firehouse, Athena DB: Oracle, Data Lake, Postgres.
Role & Responsibilities: • Migrated large oracle DB to cloud using AWS DMS and hosted in AWS RDS Postgres.
• Created set of json files out of postgres DB and created Data Lake in S3.
• Reading these json files from AWS glue and created catalog to further harmonize the data and convert the data frame to Parque and saved it in another S3 Bucket.
• Accessing this data lake from Athena and analyze the data.
• Implemented the Lambda solution to real time process of data from s3 bucket to firehose.
• Finally hosting the data in Amazon redshift cluster.
• Implemented Incremental Load to improve Load Time.
• Designed an end-to-end analytical landscape involving Power BI dashboards connected to Cloud source.
• Installed and configured Enterprise gateway and Personal gateway in Power bi service.
• Proficient in AWS services like VPC, EC2, S3, ELB, Autoscaling Groups (ASG), EBS, RDS, IAM, CloudWatch.
• Experienced in creating multiple VPC's and public, private subnets as per requirement and distributed them as groups into various availability zones of the VPC.
2019-08 - 2021-10
Company: Ellucian - Bangalore, India Role: Senior Consultant BI tools: Power BI, Tableau, Cognos, Argos.
Data Engineering: Data bricks, data lake, big data, Azure Data factory, ETHOS.
Cloud: AWS EC2, S3, EBS, VPC.
DB: Oracle, SQL Server, Data Lake.
Role & Responsibilities: • Implemented large Lambda architectures using Azure Data platform capabilities like Azure Data Lake, Azure Data Factory, Azure SQL Server and Power BI.
• Expertise in Data Factory, Data Lake, Storage.
• Designed and architected analytics solutions, including technical feasibility, integration, development for intelligence (Reporting Services, Power BI), Data Factory.
• Created different types of sheet objects like List boxes, Buttons, Multibox.
• Sound knowledge of various functions of QlikView technology.
• Implemented Incremental Load to improve Load Time.
• Designed an end-to-end analytical landscape involving PowerBI dashboards connected to backend SQL Server 2016 system on Azure to enable.
• Expertise in Power BI, Power BI Pro, Power BI Mobile.
• Expert in creating and developing Power BI Dashboards into rich look.
• Developed Power BI model used for financial reporting of P&L and Headcount.
• Designed and documented the entire Architecture of Power bi Poc • Expertise in writing complex DAX functions in Power BI and Power Pivot.
• Automated Power Query refresh using power shell script and windows task scheduler.
• Used various sources to pull data into Power BI such as Sql Server, SAP BW, Oracle, SQL Azure etc.
• Installed and configured Enterprise gateway and Personal gateway in Power bi service.
• Created Workspace and content packs for business users to view the developed reports.
• Scheduled Automatic refresh and scheduling refresh in power bi service.
• Wrote calculated columns, Measures queries in power bi desktop to show good data analysis techniques.
• Weekly presentation to the business users about the reports and their changes as required.
• Worked on all kind of reports such as Yearly, Quarterly, Monthly, and Daily.
• Worked on all types of transformations that are available in Power bi query editor.
• Migration of prime servers to AWS environment.
• Proficient in AWS services like VPC, EC2, S3, ELB, Autoscaling Groups (ASG), EBS, RDS, EFS, IAM, Route 53, CloudWatch, CloudFront, CloudTrail.
• Experienced in creating multiple VPC's and public, private subnets as per requirement and distributed them as groups into various availability zones of the VPC.
• Implemented domain name service (DNS) through route 53 to have highly available and scalable applications.
• Created NAT gateways and instances to allow communication from the private instances to the internet through bastion hosts.
• Implementation of inhouse Analytics tools: Ellucian Analytics Application on cloud • Development of Analytics Report and Dashboard using Power BI, Cognos, and Argos.
• Driving scrum calls to achieve project goals.
2016-11 - 2019-08
2016-11 - 2019-08
Data Engineering: Data bricks, data lake, Azure Data factory.
Roles & Responsibilities: • Designed complex data intensive reports in Power BI utilizing various graph features such as gauge, funnel.
• Developed complex calculated measures using Data Analysis Expression language (DAX).
• Analyzed business requirements, facilitating planning and implementation phases of the OLAP model in Team meetings.
• Created EBS volumes for storing application files for use with EC2 instances whenever they are mounted to them.
• Configured S3 buckets with various life cycle policies to archive the infrequently accessed data to storage classes based on requirement.
• Maintained the monitoring and alerting of production and corporate servers using Cloud Watch service.
• Created snapshots to take backups of the volumes and images to store launch configurations of the EC2 instance.
• PAW (Planning Analytics Workspace) Installation and configuration on multi server with CAM authentication.
• Hands on experience on Tableau Desktop versions 7/8.2, Tableau Reader and Tableau Server.
• Produced attractive visuals/dashboards to convey the story inside the data.
• Built dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices.
• Involved in trouble shooting of performance issues which were associated with Tableau reports.
• Also involved in administration tasks such as publishing workbooks, setting permissions, managing ownerships, providing access to the users and adding them to the specific group and scheduled instances for reports in Tableau Server.
• CAM integration with all Controller, Planning Analytics and Cognos Analytics.
• Installation of Planning Analytics for Excel and trained the end user on PAX.
• Installation of Cognos TM1, updated the patches and SSL certification and involved in TM1 administration.
• Administered the Cognos TM1 reporting environment including security, upgrades, content storage and usage.
• Designed, developed, and implemented Cognos TM1 Applications to Budget and forecast portfolio revenues.
• Developed TI Processes to load and retrieve data from database tables and other data sources and leveraged the processes to create dimensions, hierarchies, and cubes.
• Expert in creating and developing Power BI Dashboards into rich look.
• Developed Power BI model used for financial reporting of P&L and Headcount.
• Designed and documented the entire Architecture of Power bi Poc.
• Expertise in writing complex DAX functions in Power BI and Power Pivot.
• Used various sources to pull data into Power BI such as Sql Server, SAP BW, Oracle, SQL Azure Achievements: ◦ Business Travel to UK to train the business users on BI applications.
2015-05 - 2016-10
Data Engineering: Blob Storage, Data bricks.
DB: SQL Server, Oracle, Netezza.
Roles & Responsibilities: • Worked on all types of transformations that are available in Power Bi query editor • Created stored procedures and SQL queries to pull data into power pivot model.
• Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
• Database creation (DDL, DML, DCL), database tuning, SQL tuning, performance planning.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Transformed complex business logic into Database design and maintaining it by using SQL objects like Stored Procedures, User Defined Functions, Views.
• Creating and Modifying Tables, Stored Procedures, Views, Indexes, User-defined Functions, and Triggers as required.
• Developed Excel Power View, Power Query and PowerPivot dashboards for data analysis.
• Developed confidential proprietary analytical tools and reports with Confidential Excel, and Power Pivot and Power Point.
• Designed and created data extracts, supporting SSRS, Power BI, Tableau, or other visualization tools reporting applications.
• Created different KPI using calculated key figures and parameters • Developed Tableau data visualization using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart.
• Developed donut charts and implemented complex features in charts like creating bar charts in tooltip.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics and table calculations.
• Hands on building Groups, hierarchies, Sets to create detail level summary reports and Dashboard using KPI's • Strong Dashboard design experience and passionate practitioner of effective data visualization. Familiarity with best practices around visualization and design.
• Provided Production support to Tableau users and Wrote Custom SQL to support business requirements.
• Utilized Tableau server to publish and share the reports with the business users.
• Also involved in administration tasks such as Setting permissions, managing ownerships, and providing access to the users and adding them to the specific group.
• Distributed Tableau reports using techniques like Packaged Workbooks, PDF to different user community.
• Created Drill Down Reports, Drill Through Report by Region.
• Helping users to develop the adhoc report in Cognos Café.
• jobs for the automatic delivery of standard reports by daily, weekly.
• jobs for automatic refresh of the cube once the data load is finished.
• Handling the adhoc request from the user to create the business report.
• Training users on using the cubes for analysis in "Cognos Café".
• Created visualization using RAVE.
• Defects handling.
2012-04 - 2015-05
2012-04 - 2015-05
DB: Oracle 10g, SQL Server, DB2, Netizza.
Scripting: SQL.
Roles & Responsibilities: • Expertise in Cognos Analytics installation and configuration.
• Providing BI solutions using Cognos Analytics.
• Experience with dimensional modeling using star schema and snowflake models.
• Design and Development of reports and dashboard out of cubes and FM package.
• Around 1 year of system analysis and solution designing experience in the client location Sweden. Primary contact for BI server maintenance.
• Interacting with requirement analyst and finalizing the business requirement.
• Helping users to develop the adhoc report in Cognos Café.
• Upgrading the reports from 10.1 to 10.2.2 • Responsible for code migration across environments (DEV, SIT, UAT, Prod) • Creating events to pop up the alert messages when the cube is down.
• Work on change request and enhancement.
• Create the Meta data model using framework manager and publish package.
• Point of Contact for project progress.
• Used some advanced features like Conditional Formatting in Report Studio in generating multipage Reports.
• Dynamic column changing in the report based on selection criteria in prompt page.
• Developed simple as well as complex reports using report studio.
• Manually modified the SQL in Report Studio to tune and/or to write complicated reports. Used union/Join objects in ReportStudio.
• Applying different functionalities like filters, prompts to retrieve relevant data from the database.
• Created drill-through and sub reports according to the Customer Needs.
Achievements: Worked in Sweden for H&M to implement the analytical solutions effectively and received Diploma from H&M for my best performance.
2009-01 - 2012-03
2009-01 - 2012-03
Role: Analyst Programmer.
BI tools: SAS, Cognos BI.
DB: SQL Server.
Scripting: SQL.
Roles & Responsibilities: • Worked on SAS to create clinical trial reports.
• Extensively used SAS reporting tool to report adverse event, progression of clinical trial and drug efficacy tests.
• Effectively implemented reporting solutions for ongoing clinical studies and statistical reports.
• Part of various scrum calls.
• POC for data loading to ETL systems.
• POC for weekly calls for status update.
Academic Background
2005-01 - 2009-01
2002-01 - 2005-01