Senior Power Bi Developer Resume
Boca Raton, FloridA
SUMMARY:
- Over 9 years of experience in IT industries, proficient at quickly learning new processes and taking ownership of diverse processes.
- Hold several Confidential s and looking forward to getting more this year.
TECHNICAL SKILLS:
Advance knowledge in Power BI, SSAS Tabular model, Confidential Dynamics CRM, Sugar CRM, Salesforce, Migration to SQL Azure, Advantage fee, Birst, Data Modeling, Azure, SQL Server 2005/2008 R 2/ 2012/2014/2016, SSRS, POSTGRESQL, ORACLE/ MYSQL, SQL development, Views, ETL, DMV and DMF, database administration, optimization and development of SQL code, stored procedures, index creation, design and analysis of databases, database continuity, moderate knowledge in programming languages, Agile, SCRUM, UML, Integration services, Analysis services, Datawarehouse / cubes development, SharePoint, extensive data analyst experience.
PROFESSIONAL EXPERIENCE:
Confidential, Boca Raton, Florida
Senior Power BI Developer
Responsibilities:
- SSDT TABULAR cube development, SQL, DAX and data modeling.
- Power BI desktop development for Power BI PRO environment.
- Dax development.
- T - SQL / Views and stored procedures development.
- Power BI Report Server Development and migrations of SSRS to power BI pro.
- Gateway configuration, giving access to users, Testing reports, others in Power BI.
- Azure Dev ops, Agile environment.
- Power BI connected to SSAS Tabular Model with live connection.
- Cube on premise migration to Azure.
- Power BI migration of reports from on premise to Azure
- M Query development for SSAS tabular model connected to Azure.
- Data Modeling and data Modeling optimization.
Confidential - Atlanta GA, USA
Senior Power BI Developer
Responsibilities:
- T-SQL development, DAX Programming to create dashboards in Power BI (including query's that join different databases.)
- Migrate tableau reports and dashboards to Power BI (development on Power BI based on older tableau reports).
- Run Monthly and adhoc reports in Power BI, Tableau and Confidential excel.
- Create ad hoc reports in Power BI, Tableau and Confidential excel.
- Import data into database tables to join with Power BI / Tableau reports.
- Created reports on metrics and user adoption.
- Posted documents into SharePoint and intranet sites to share with stakeholders.
- Held meetings with directors to collect requirements for new dashboards.
Confidential, GA, USA
SQL Developer / Dynamics Navision Admin
Responsibilities:
- Uploads documents into Navision to maintain products and client information updated Salesforce administrator
- Birst Development for dashboards
- Kanban management and review created purchase orders. Receives sales orders directly from clients, checks in several of the client’s portals SAP, Volution, Supplier Portal for new orders from important clients, sends order acknowledgment.
- Registered sales orders in Navision, managed inventory, checks inventory and creates purchases orders for
- Resources
- Wrote NAFTA s for exports/imports.
- Trained other users, and documented processes
- Develops T-SQL queries to get information and then Creates Reports and dashboards (Excel)
- Creates product designs documentation in AutoCAD.
- Managed the company’s portal, price, product description, created pages and updated links to product pages.
- Created Video content for the web site and picture galleries.
- Developed PR email campaigns with pictures and videos to retain customers.
Confidential, GA, USA
SQL Developer / BI Developer
Responsibilities:
- Worked with Account Manager to increase productivity by improving and creating workflows on Sugar CRM.
- Developed SQL code using MySQL and ORACLE to consult, update or delete data, also to modify a data warehouse, create dashboards
- T-SQL development, queries, procedures, functions and views. for SQL Server 2016.
- Customized different CRM Suite sites by customizing based on account management need as a Business Analyst role.
- Power BI / QLIK and Excel report development.
- Optimized CRM sites by using database indexes, performance tuning on Open Suite CRM.
- Installed Deployed and implemented new CRM applications, moves the applications and databases from different servers in Linux environments, Agile methodology environment.
- SQL Tuning Support for software developers.
- Developed an ETL for data migration from several sources to MySQL, and flat files to CRM.
- Data analysis development created Pareto, pie, line, and graph charts for data analysis.
- Attended meetings with managers to build user stories with an objective, made a plan that contained the information collected with the priority and detail, owner of the process, then divided the requirements in Releases. Had weekly meetings with key managers for their approval on the work being performed.
Confidential, GA USA
Database Administrator
Responsibilities:
- Client Facing, held meetings with clients to collect requirements and do Live upgrades for Advantage fee, web and call meetings with banks.
- Migrated SQL Server Databases to SQL Azure Database and vice versa
- Implemented and upgraded Several Advantage fee instances on different environments
- SQL development in SQL Server 2014 and PostgreSQL to develop Dashboards, index creation to optimize queries.
- Designed, created and implemented ETL to extract data from different RDBMS to update to newer versions.
- Monitor tablespaces and Data Base schemas for any performance issues, that may come along the way, Backup, Recovery, High availability plans, and Capacity Plans, usage of DMV and DMF to monitor severe health.
- Worked with large databases, hundreds of millions of rows of data on the database for report creation.
- Business Intelligence and data warehouse configuring/patching
- Advantage fee administration, creating users, groups, rates, security roles, managed opportunities, report validation, exported data to excel and Power BI to create reports, DAX Development
- Installed, Configured, Patched and Upgraded SQL Server Software
- Client tech support for several US Banks using advantage fee
- Optimized SQL queries for the software department
- T-SQL Development to develop dashboards and make structural changes in Databases.
- Advantage Fee support by creating security groups, users, roles, and auditing roles.
- Worked on a new process with the objective of measuring the workload of several project managers, by consolidating different data sources and developed a dashboard, database and software migration.
- SQL SERVER 2014 administration: Database server clean up, and optimization of space.
- Used virtual machines on windows server 2014, security, IIS, troubleshooting.
- Conducted Database full backups and restores.
- Created Azure storage accounts to store SQL Server backups
- The banks asked the team to upgrade their databases and they wanted us to do the official installation, sometimes they did the installation while following our instructions, on instances the calls were directed to bug fixing and requirements. Reduced rework and the delivery time of the projects by 20%, without escalations by finishing the work earlier than the delivery date on projects in 2016.
- Creation of Store procedures in T-SQL.
- Power BI and six sigma.