Power BI Developer
Location : Noida
Experience : 3.6 Year
Rate: $9 / Hourly
Availability : Immediate
Work From : Any
Category : Information Technology & Services
Professional Summary:
3.6years of experience in using ETL methodologies for supporting Data Extraction, Data Migration, Data Transformation and loading using SSIS and Other ETL Technologies.
Excellent working and conceptual knowledge ofPower BI, SQL, Python, Advanced Excel , Extensively worked on data extraction, Transformation and loading data from various sources like Oracle, Salesforce,Talend, SQL Server and Flat files
Had experience in data modeling using Star Schema Modeling, and Snowflake modeling, FACT and Dimensions tables, physical and logical modeling
Well versed in developing the complex SQL queries, unions and multiple table joins and experience with Views
Good exposure to development and enhancement of a project.
Involved in assisting clients over various critical technical issues and solved them successfully.
Has experience in writing efficient SQL queries to check the data set along with proficiency in database concepts.
Has experience in UNIX commands and Shell scripting.
Experienced in creating Tables, Stored Procedures, Views, Indexes, Cursors, and User Defined Functions.
Creating DDL and DML scripts in T-SQL to full fill the requirements, Creating views and procedures as per requirements.
Creating user defined functions for the purpose of complex calculations.
Worked on ranking functions to fetch records according to the customer requirement.
Expertise in implementing business logic using Views and Stored Procedures.
Experience in data normalization and de-normalization.
Created and Monitor Jobs and parse queries to get Desired Result.
Experience on Power BI(Desktop and Service) and DAX.
Worked on the Power BI reports & dashboards with SQL Server and Other sources. Used Table, Matrix, Bar, Card, Gauge, Slicers visualizations.
Experience in business solution implementation, development activities and Support. Has experience in development of reports and dashboards in Power BI integrated with SQL Server and Excel, SharePoint and Online Web Services.
Very good communication skills, good interpersonal skill & desire to excel, fast learner, hardworking and a versatile team player.
Work Experience:
Company Name : AWC Software Pvt. Ltd., Noida.
Position Title : Software Developer
Work Duration :May 2019 to till date.
Job Description : Currently, I am working on Power ETL Developer and Power BI Services to develop Report and Dashboards for different Project. My basic role is to understand the requirement of the client, integrate user database with power bi from different source, prepare the module, create measure, design report, dashboard and deliver to client.
Educational Qualification:
Bachelor of Science in Computer Science,. S.S.C.B.S, University of Delhi New Delhi, IN May '15
Fundamentals of Programming | DBMS |Operating Systems| Linear Algebra and Matrices | Networking |Computer System Architecture | Microprocessors | Software Engineering| Data Structures and Algorithms.
Secured First Class with Distinction.
Senior Secondary School Examination, C.B.S.E New Delhi, IN May '12
Skill Set:
Programming Languages:Python, SQL, Advanced Excel -VBA
Operating System : Window7, Window8, Window10.
Databases : SQL Server, SQL Server 2012, 2014 and 2016.
Database Tool : ETL, Power BI.
Architecture : Relational Database, Client server Architecture.
MS Technologies: DAX and Data Modeling.
Web Technologies : HTML, CSS, MVC, Bootstrap and PHP
Excel Skills : VLOOKUP, Hlookup, Pivot Tables, Power Pivot , Cascading , Complex Excel
Formulas
Project Profile:
Client: PVR Corporate Pvt. Ltd., Gurgaon
Duration: Feb2023 - March
Technology: ETL, MicrosoftSQL Server 2019 (T-SQL), Advanced Excel, Python libraries
Roles& Responsibility:
Learned and grasped the knowledge of Salesforce and Dashboards, SQL and Data Warehouse concepts.
Assisted the senior team members in their tasks such as creating source/target definitions, comparing the data, creating documents etc.
Created understanding document and verified them from the senior members.
Interacted with clients to gather the requirements.
Created the detail design documents and SOP’s.
Writing SQL queries as per business requirement.
Creating user defined functions for the purpose of complex calculations.
Worked on ranking functions to fetch records acco
{{contact.cdata.phone}}
{{contact.cdata.email}}
View Resume
