PROFILE SUMMERY

• Over 5+ years of experience in developing BI applications utilizing SQL server, BI stack, Power BI, and Tableau.
• Hands on experienced with various transformations such as lookup, conditional split, multicast, Derived column, merge, for each, for loop, Multi - cast, sorting, Data profiling, Bulk insert, Sequence container, Delayed validations etc. in Integration Services development.
• Translated the business requirements into workable functional and non-functional requirements at detailed production level using Workflow Diagrams, Sequence Diagrams, Activity Diagrams and Use Case Modeling.
• Proficient in Developing SSIS Packages to Extract, Transform and Load (ETL) data into the Data warehouse from Heterogeneous databases such as Oracle, DB2, SQL Server and MS Access
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Extensive database programming experience in writing T-SQL, User Defined Functions, Triggers, Views, Temporary Tables Constraints and Indexes using various DDL and DML commands.
• Developed complex and customized Stored Procedures and Queries for implementing business logic and process in backend, for data extraction, reports and other client interfaces.
• Trained in Design, development of Business Intelligence Solutions using Tableau.
• Developed data transformation using M query editor formula bar
• Skilled in Data warehousing tools, Data Mapping, Unit Testing, Migration, Conversions.
• Experienced in managing and automating control flow, data flow, events.
• Generated reports with parameters, sub reports, cross tabs, charts using Crystal Reports.
• Thorough understanding on connection managers, Checkpoint, Transactions, logging etc.
• Created Drill through reports, drill down reports, Sub reports, Cascading Parameters, Linked reports, Matrix etc. using BIDS.
• Expertise in dealing with RDBMS including E/R Diagrams, Normalization and De-Normalization, Constraints, Data Import and Export etc.

PROFESSIONAL EXPERIENCE:

ETL /POWER BI DEVELOPER AT

Confidential

Responsibilities:

• Interpreted business requirement and translate them into power bi model, report and dashboards
• Supported transfer excel based analysis tools to advance analysis product in power bi
• Leveraged GitHub project and Repository to manage code base and file for project
• Designed report using single /multiple value dependant and cascading parameter
• Created and managed Power BI App workspace (classic and modern)
• Published Power BI visualization into app workspace
• Developed AD HOC date analytic platform using power bi desktop
• Configured power bi data gateways in power BI service for data refresh
• Created and modify report and reporting template using power BI
• Developed simple and easy to use interface to make data appropriate to the varies user
• Leveraged data visualization tools to provide a single source data availability for multiple user community
• Worked with project manager to refine technical requirement
• Worked with agile team with streamline task in sprint cycle
• Gathered and blend from varies source using third party tools, FTP and Sharepoint list
• Developed data cleansing, mapping process using SSIS integration service
• Imported and exported data from flat file, csv file, excel/from SQL server data base using SSIS
• Developed and maintained complex SQL store procedures and function
• Worked with type 1and type 3 dimensions, fact table, star schema, operational data store (ODS), levelling and other data warehouse concept
• Automated SSIS package using SQL server agent
• Developed data transformation using M programing language
• Excellent follow through and initiative, and ability to complete task accurately and on-time

ETL/POWER BI DEVELOPER AT

Confidential

Responsibilities:

• Applied DAX expression to calculate measure, calculated column and table to analysing the data
• Developed power bi report and dashboard
• Developed /checked data modelling to avoid many to many Relationship between tables
• Configured alert notification on dashboard using (KPI, GUAGE and matrix)
• Created workspace and assigning the admins, member, contributor and viewer roles
• Develop ETL process using data integration tools, scripts, and stored procedures to extract data from multiple system, application, and other sources, and load data into enterprise data warehouse
• Created database object (table, views, stored procedures and functions) to support application team
• Participated in Agile Scrum team and work collaboratively with team member and key stakeholder to gather and validate requirement as well as deliver features /enhancement
• Extracted analysing and transforming complex batches of data from multiple internal and external sources
• Configured varies event driven e-mail notification process in SSIS package
• Created a reusable /repeatable process in SQL Server integrations services (SSIS) that transforms data into a specific format
• Manage business intelligence intuitive
• Migration to azure
• Migration to power bi and configure getaway
• Deployed and executing SSIS package using stores procedures
• Create and modify report using SQL service reporting service(SSRS)
• Developed a complete SSIS life cycle creating SSIS including building, deploying, and scheduling the package
• Involved normalization and demoralization of existing table for fast query retrieval Cleansing data in power query using R/Python script and its visualization for better utilization and performance of power BI.
• Migrating on premises data to Cloud service (ADF), lift and shift existing ETL packages in SSIS integration run time. Deploy and trigger the packages.

Chief electrician

Confidential

Responsibilities:

• Contracting residential electrical and DATA system installation work that includes installation of power intake lines, CAT-5E/CAT 6 data cables, lighting points and luminaries, socket lines and socket outlets, telephone/data lines and socket outlets, bell circuits
• Installation, troubleshooting and maintenance of home appliances such as stoves, dish washer for hotels and cafes.
• Configuration and troubleshooting of audio and video devices and systems.
• Installation of electrical systems and control boards for elevators and escalators
• Facilitated impact assessment study for engineering internship program on the employability of engineering graduates in the country
• Electrical installation work ranging from residential buildings to hotel apartments and industrial plants.
• LV/MV/HV line installation in relation to compact substation, Medium voltage switchgear and GENSET connection
• Electrical distribution panel assembly and erecting
• Electrical machine installation, testing and commissioning
• Elevator/Escalator installation, troubleshooting and maintenance
• Data network installation including Wi-Fi and telephone lines
• House appliances and air conditioner maintenance