-
Hello, my name is Rene Valenzuela. Thank you for taking the time to view my profile. Several years ago, I serendipitously came upon the world of Business Intelligence and began a training program with Colaberry, my current company. Since then, I’ve been fortunate enough to work in the field with Colaberry. During my tenure at Colaberry, I’ve received comprehensive training and valuable opportunities to learn and advance my career. I’m well-versed in SDLC methodologies such as Waterfall and Agile practices and sub-methodologies.In my most recent project, I was tasked with creating a Power BI report to track export data for a company. I took charge of much of the process, from loading the data to deploying the report. Through identifying and implementing KPI’s, I provided end-users with actionable insights. These metrics enabled users to identify the most profitable export categories and products, pinpoint lucrative markets, and observe significant trends across different time periods.I’ve developed and published highly interactive and efficient Power BI reports in various dataset modes while following best practices such as query folding, building efficient data models, proficient DAX usage, appropriate report structuring and visualization selection, and more. I’m knowledgeable in key DAX concepts such as row context, filter context, context transition, and the significance of CALCULATE and CALCULATETABLE to these concepts. In the service, I’ve worked with and managed deployment pipelines, dataflows, shared datasets, workspaces, apps, and have set scheduled refresh.I’ve worked extensively with SQL Server where I have ample experience with several types of JOINs and various objects such as Stored Procedures, Views, Temp Tables, CTE’s, UDF’s, Variables, and a variety of system functions. I’ve used SQL Server Agent to automate different processes such as running SP’s and SSIS package execution. Over time I’ve learned how to better optimize queries and how to look into Execution Plans.I’ve also had the privilege of working with SSIS (SQL Server Integration Services), where I have learned how to create, maintain, and troubleshoot packages with error handling. Within the Control Flow, I am proficient in utilizing all three types of containers, as well as the Data Flow Task, Execute SQL Task, and BULK Insert Task. Within the Data Flow, I’ve successfully worked with various data sources such as OLE DB, Excel, XML, and Flat Files and I’ve applied an array of transformations, including Conditional Split, Derived Column, and Multicast.In closing, I’ve learned a great deal in my years of experience, and I’ve enjoyed my journey so far. I’m a thorough individual and I enjoy learning about the applications and services I work with, both through hands-on experience and research. Over the years, I’ve learned to balance thoroughness with resourcefulness and efficiency. I always strive to give my best to my employers while meeting the requirements of a given situation and I’ll continue to do so when I start working for your company.
- SQL Server
- SSIS
- SSRS
- SSAS
- Power BI
- Microsoft Office
- Visual Studio Data Tools
- Software Design Pattern
- Etl
- Sql
- Html
- Visual Studio Code
- Access
- Outlook
- Snowflake
- Dax
- Microsoft Excel
- Case Study
- Data Analytics
- Data Mining
- Deployment
- Product Overview
- Reporting
- ETL
- Instructions
- Data Warehousing
- Construction
- Finance
- Mortgage Banking
- Retail
Hours Available / Wk - 40hrs
-
Team-oriented individual with a reliable and enthusiastic approach to working collaboratively with others as well as independently. My expertise lies in designing, developing, deploying, and visualizing business reports using Microsoft Power BI. Additionally, I am highly skilled in developing SSIS packages to extract, transform, and load (ETL) data and working with Microsoft SQL Server in both OLTP and OLAP (Data Warehousing) environments. I have a deep understanding of database management and data modeling principles, which allows me to contribute effectively to any project. With strong analytical skills, attention to detail, and quick learning ability, I am confident in my ability to work with various data sources and tools and provide valuable insights for data-related projects.
- SQL Server
- SSIS
- SSRS
- SSAS
- Power BI
- Microsoft Office
- Visual Studio Data Tools
- Software Design Pattern
- Etl
- Sql
- Html
- Visual Studio Code
- Access
- Snowflake
- Dax
- Microsoft Excel
- Microsoft Power Point
- Case Study
- Data Analytics
- Data Mining
- Deployment
- Product Overview
- Reporting
- ETL
- Instructions
- Data Warehousing
- Construction
- Healthcare
- Mortgage Banking
- Manufacturing
- Technology
- Transport
- Sales
Hours Available / Wk - 40hrs
-
My impression based on the job description is that you need someone who can do key responsibilities of the job. In my last role, I did similar task or accomplishment you’ve done in the past, so I’m confident I will be able to step into this role and begin contributing quickly for you. As a side note, I’m also personally very interested/passionate about topics related to the job you’ll be doing, so I’d be very excited for the opportunity to step into this role.I enjoy meeting new people and learning about their lives and backgrounds. I easily find Common interests with strangers tend to make most people feel comfortable. I find this skill Especially advantageous when I am kicking off projects with mew clients.opportunity to step into this role.
- SQL Server
- SSIS
- SSRS
- SSAS
- Power BI
- Microsoft Office
- Visual Studio Data Tools
- Etl
- Sql
- Outlook
- Dax
- Dashboards
- Microsoft Excel
- Agile Methodologies
- Microsoft Power Point
- Case Study
- Data Analytics
- Data Mining
- Deployment
- Product Overview
- Reporting
- ETL
- Instructions
- Data Warehousing
- Computer Software
- Construction
- Education
- Mortgage Banking
- Real Estate
- Technology
Hours Available / Wk - 40hrs
-
With my fair experience in SSIS, I am adept at designing and customizing data integration workflows, including data transformations and package development. Furthermore, I have gained proficiency in managing package execution and scheduling. As I continue to explore advanced features and best practices, I am eager to further refine my skills and deliver even more effective data integration solutions.With my experience as a Tableau Developer and my educational background in data analytics from Colaberry School of Data Analytics, I bring a strong foundation to excel in this role. My expertise in building dashboards in diverse fields such as Housing and Mortgage showcases my ability to adapt to different industries. Additionally, my knowledge in software maintenance and hardware repairs adds value to my skill set.At Colaberry Inc, I have had the opportunity to work on various projects, including completing a dashboard on \"Subsidized Housing in the US,\" highlighting my ability to tackle complex and relevant topics. My fair experience in SQL and SSIS further complements my skill set, enabling me to retrieve and analyze data effectively while delivering impactful reports.With a proven track record in developing visually appealing and user-friendly dashboards, combined with my proficiency in SQL and SSIS, I am confident in my ability to contribute to data-driven decision-making processes. My dedication to expanding my knowledge and refining my skills ensures that I stay up-to-date with the latest industry trends. Choose me, and I will bring a valuable combination of technical expertise, adaptability, and a commitment to delivering high-quality insights to your organization.
Hours Available / Wk - 40hrs
-
I am a goal driven oriented and enthusiastic in finding a long lasting solution to challenges or problems facing the group, I have an opportunity of solving some problems in my previous experience and I am one of the leading group driven the overall company goals to success, I always keep this energy to add value anywhere I belongs and I love what I do.I am a Power BI developer with experience in developing business intelligence applications, Data Visualization with Scorecards, KPI\\\'S and Dashboard Reports by using Power BI Desktop, creating calculated columns and measures, troubleshooting report performance. Troubleshoot Slowly running reports and Dashboard elements to improve report performance. Business Analysis through SQL, SSRS, SSAS.
- SQL Server
- SSIS
- SSRS
- SSAS
- Power BI
- Visual Studio Data Tools
- Data Analytics
- Deployment
- Product Overview
- Reporting
- ETL
- Auto Mechanics
- Computer Software
- Construction
- Education
- Finance
- Food
- Healthcare
- Insurance
- Marketing
- Mortgage Banking
- Pharmaceutical
- Financial Services
- Manufacturing
- Real Estate
- Retail
- Technology
- Telecommunications
- Transport
- Travel
- Timeshare
- Sales
- Customer Service
- Criminal Justice
- Government
- Career
- JobSearch
Hours Available / Wk - 40hrs
-
I have all the skills and experience to match your job description, and I\\\'m confident that I can make an immediate impact on your company. It\\\'s not just my background in leading successful projects for companies, but also my passion for the industry that drives me to succeed. If chosen for this role, I will continue to deliver high-quality work for the continued success of your organization.
- SQL Server
- SSIS
- SSRS
- SSAS
- Microsoft Office
- Visual Studio Data Tools
- Etl
- Sql
- Snowflake
- Dax
- Dashboards
- Microsoft Excel
- Data Analytics
- Data Mining
- Deployment
- Product Overview
- Reporting
- ETL
- Data Warehousing
- Auto Mechanics
- Computer Software
- Construction
- Education
- Finance
- Food
- Healthcare
- Insurance
- Marketing
- Mortgage Banking
- Pharmaceutical
- Financial Services
- Manufacturing
- Real Estate
- Retail
- Technology
- Telecommunications
- Transport
- Travel
- Timeshare
- Sales
- Customer Service
- Criminal Justice
- Government
- Career
- JobSearch
Hours Available / Wk - 45hrs