We provide IT Staff Augmentation Services!

Power Bi Developer / Talend Developer Resume

3.00/5 (Submit Your Rating)

Amelia, OH

SUMMARY

  • Around 8 Years of experience in Implementation of Data Warehousing and Business Intelligence using BI tools MicroStrategy, Power BI and Oracle E - Business suite (Reporting).
  • Strong hands on knowledge using SQL, PL/SQL Skills for data analysis and data wrangling.
  • Proficient in understanding business processes/requirements and translating them into technical requirements.
  • Excellent with PL/SQL, T-SQL, Stored Procedures, Packages, Database Triggers and SQL * Loader utilities of different databases. Oracle, MS SQL Server .
  • Worked on existing OLTP system(s) and created facts, dimensions, data models, star schema representation for the data mart of OLTP and OLAP databases.
  • Good exposure to PowerBI workspace roles and access.Publishing reports via apps and report sharing methodologies
  • Good exposure to managing on-premises gateway data sources and creating schedule refresh for datasets.
  • Experience in creating datasets in tabular model to leverage the PowerBI Live connection based reporting.
  • Experience in creating reports using Power BI, DAX query, Power Query as and when needed and resolve data issues with managed relations or tweaking the data source SQL to address the data issues.
  • Good knowledge on creating MSTR schema objects and public objects by using architect tool.
  • Proficient in creatingMSTR metrics and transformations, prompts,filters,Consolidations and Custom groups.
  • Highly experienced in MS SQL Server 2012/2008/2005 with Business Intelligence in SQL Server Reporting Services, SQL Server Analysis Services and SQL Server Integration Services.
  • Participated in AGILE iterative development methodology.
  • Experience in creating SQL objects such as Tables, Complex Stored Procedures, Effective Functions, Views, Indexes, Triggers, and SQL Performance Tuning to facilitate efficient data manipulation and consistency.
  • Database development experience with Microsoft SQL Server in OLTP/OLAP environments using integration services (SSIS) for ETL (Extraction, Transformation and Loading).
  • Experienced in various Extracting, Transforming and Loading (ETL) tasks using SSIS including tools DTS and SSIS (2005 / 2008) Packages with proper control & data flow elements.
  • Experience in identifying slow running query and optimization of stored procedures and tested applications for performance, data integrity using SQL Profiler
  • Good knowledge on creating SSIS packagesusing data tools.
  • Good exposure to Microsoft Azure and data factory.
  • Experienced on processing the data files through Talend Data Integration.
  • Working knowledge of other ETL tools such as Talend Open Studio.
  • Experience in implementing Talend based solutions for various stages of the ETL process.
  • Experience with data migration and integration process using Talend.
  • Experience in Data Analysis, Data Migration, Data Validation, Data Cleansing, Data Verification, identifying data mismatch, Data Import, and Data Export using multiple ETL tools such as Talend, Power BI, and MicroStratergy.

TECHNICAL SKILLS

ERP: Oracle Apps R12.1.3(PO,INV,BOM,OM,AP,AR)

DBMS: SQL Server 2008/2012/2014 , Netezza, ORACLE11g, MYSQL.

BI Reporting Tools: Microstrategy 9.5,Power BI, Oracle developer suite 10g

ETL/ELT tools: SSIS, Alteryx, Talend

Languages: SQL,PL/SQL,Unix

PROFESSIONAL EXPERIENCE

Confidential, Amelia, OH

Power BI Developer / Talend Developer

Environment: MS SQL Server 2017, SQL, SSIS, SSRS, PowerBI, SSIS, MDS, MS-Visual Studio 2016, MySQL, Talend Studio, MicroStrategy 10, Talend 6.2

Responsibilities:

  • Gathering requirements and translating businessrequirements to technical specifications.
  • Working on data integration of large, complex data setsthat meet functional / non-functional business requirements.
  • Modeling data and target table design of complex data sets.
  • Responding to data inquiries from clientstakeholders and the business team.
  • Developing, testing, monitoring and troubleshooting ETL processes.
  • Tuning query performance and ETL (extract,transform, and load) in order to troubleshoot issues.
  • Designing, building, and maintaining data integration processes in test and production environments of ETL processes, and design data models.
  • Designing and developing Power BI dashboard and visualization.
  • Publishing reports and dashboards using Power BI.
  • Utilizing Power BI desktop version for designing rich visualizations and providing insights.
  • Applying correct filters/slicers on the Power BI report based on business need.
  • Gathering functional specification requirements for the development of dashboards and reports.
  • Interacting with the customers and business analyst to understand and assess the technical requirements and needs, performed analysis, described and documented for demo purpose.
  • Publishing Power BI desktop reports to the Power BI service created using report view.
  • Maintaining the integrity and validity of data throughout the ETL processing cycle by implementing data reconciliation processes and error handling based on source to target data comparisons.
  • Developing, designing, tuning and maintaining SSIS packages to perform the ETL process
  • Designing and developing SQL Server stored procedures, functions, views and triggers to be used during the ETL process.
  • Exploring data in a Variety of ways and across multiple visualizations using Power BI.
  • Using Power BI Gateways to keep the dashboards and reports up to date.
  • Developing ETL technical specifications, designs, tests, implements, and supports optimal data solutions for end-to-end data processing to ingest data from disparate data sources, transform it into information, and produce meaningful and actionable information through analytics
  • Performance tuning of the ETL process and SQL queries, and recommend and implement ETL and query tuning techniques
  • Creating and maintaining documentation of the Data Warehouse/Business Intelligence architectures, objects, standards, and best practices.
  • Designing Talend ETL jobs to fetch the data from various sources like flat files, SQL Server and MySQL.
  • Preparing metadata in Talend Integration studio repository.
  • Analyzing business requirements and creating Mappings using Talend.
  • Designing ETL mappings and workflows to fetch data from multiple sources (.xml, .csv, .txt) and also loading the data from these sources into relational tables or destination sources using Talend Open Studio.
  • Creating Talend jobs for migration of data.
  • Automating Talend Jobs to run the ETL framework for multiple data loads.

Confidential

Power BI Developer

Environment: Power BI, Oracle, Hyperion Reporting, Talend, ETL, Informatica

Responsibilities:

  • Created report spec based on the user story to help in report development.
  • Participated in business requirement meetings and interacted with the business users to discussthe report logicand design.
  • Developedcomplex reports and advance dashboards based on the report Spec and validate report data.
  • Created SQL scripts based on the user story/ requirement for the report.
  • Design how the report data set needs to be created to cater multiple reportsand also if it is in Direct query or Import mode based on the user requirement.
  • Analyzed the data by writing Complex SQL queries in Data Engineering Phase
  • Defined development standards and create report templates to be used for all the reports.
  • Created production checklist and UAT checklist documents t ease the report development life cycle ( from requirement to production).
  • Utilized Power BI Components like Power Pivot,PowerQuery,PowerQ&A,Power View.
  • Worked on Power Bi Paginated Reports by using Report Builder.
  • Worked on performance test on the report and fixed the issue either by tweaking the relation in the data set or the SQL used to pull the data for the report.

Confidential

Data Analyst

Environment: Power BI 5.x, SQL server, SSIS, Talend

Responsibilities:

  • Developed tabular model from scratch and enhancing the performance of the model
  • Created reports and Power BI dashboards based on tabular model, DAX language.
  • Developed paginated report to match the invoice formats.
  • Extensively created Calculated Measures, Custom columns using Power BI Desktop to generate reports for Business analysis.
  • Analyzed the business requirements and creating Mappings using Talend.
  • Prepared metadata in Talend Integration studio repository.
  • Designed Talend ETL jobs to fetch the data from various sources like flat files, SQL Server and MySQL.
  • Tested reports by writing SQL to match the report calculations and data validation.
  • Performed Data engineering using SQL and analysis to meet the report requirements and build data model in Power BI.
  • Created specification based on SSIS package for development teams.
  • Created packages to validate, extract, transform and load data to a centralized SQL server using SSIS/ETL.
  • Worked on performance tuning and Query Optimization.
  • Extracted the data using SSIS from OLTP to OLAP.
  • Implemented various tasks and transformations for data cleansing and performance tuning of packages by using SSIS.
  • Set-up configuration data required for the SSIS jobs and perform test validations on the data loaded by ETL jobs using SQL.
  • Designed SSIS packages to bring data from existing OLTP databases to the new data warehouse by performing different kinds of transformations like lookup transformations, merge joins, data conversion, derived columns, conditional split, data conversion with multiple data flow tasks.
  • Worked with different Control flow tasks in creating SSIS packages especially For Loop and For Each Loop containers with Execute SQL/Package, script tasks, send mail and file system.
  • Scheduled jobs for executing the stored SSIS package which were developed to update the database on Daily basis using SQL Server Agent.
  • Wrote quality check store-process in SQL server to monitor and report the quality of the data.

Confidential

MicroStrategy Developer

Environment: MicroStrategy 10.2, Oracle, Netezza

Responsibilities:

  • Developed schema objects and Public Objects for reporting based on user requests.
  • Created reports and dashboards using the schema and public objects as per client requirement.
  • Designed Public objects like Metrics, filters, prompts, Custom groups, Consolidations etc.
  • Created loader scripts in Netezza to bulk load huge volume of data using UNIXscripts.
  • Worked on Object Manager to migrate the objects B/W environments.
  • Created users and groups using command manager.
  • Worked on different Admin tasks.
  • Created and maintained Intelligent Cubes for aggregate tables and scheduled on monthly basis to refresh the cube data.
  • Created the reports like Grid Reports, Drill Reports, and Graph Reports, Free-form SQL Reports and dashboards.
  • Performed Unit Testing of developed Report with different test cases.
  • Monitored the scheduled jobs to ensure the availability of the reports on time to users.
  • Participated in business requirement meetings and interacted with the business users to discuss the report logic and design

Confidential

Oracle Apps Developer

Environment: Oracle applications R12 E-Business Suite,Teradata 12, Microstrategy

Responsibilities:

  • Developed Sales Order reports, Excise Invoice Reports, Purchase Order Reports.
  • Customized Finance Module Report.
  • Created Periodic and Event alerts for all modules
  • Wrote Interfaces and prepared Technical Design Documents.
  • Customized reports and Development of new report.
  • Registered concurrent programs and executables andcreated responsibilities.
  • Worked extensively to the SQL sub queries, joins, set operations and Functions.
  • Utilized knowledge in DWH and BI concepts

We'd love your feedback!