About
Over the years, I have acquired a wide range of transferable skills such as team work as well as strong problem-solving, a combination of organizational and interpersonal skills to deliver solutions in a pressurized and time-bound environment. I am a well-organized, highly motivated, effective individual and I am also self-motivated and always eager to learn new things. With the experience and the skills that I have over the years I am confident that I will be a great asset to your organization.
Hours Available / Wk - 40 hrs
Portfolio
US Border Crossing Entry (1996-2021)
Gathering Border Entry and Freight information from Transportation Service Index (TSI) plays a vital... ... More
Zendesk Ticketing
The project displays the Clients support staff handling mechanism and by analyzing the ticketing sys... ... More
Employment History
-
Power BI Developer
Colaberry Inc.
September 2016 - Present
• Provide expertise in writing complex DAX functions in Power BI and Power Pivot.
• Write useful calculated columns, measures in Power BI desktop that are useful in visuals including KPIs.
• Successfully plan, define, and design database based on the business requirement to increase efficiency.
• Create applicable dashboards, Tabular reports, Matrix reports, Charts and Graphs as per customer requirements using Power BI and SSRS.
• Utilize SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases.
• Present weekly updates to the business users about the reports, status, and take note of changes they wish to be done.
• Create database (DDL, DML, DCL), perform database tuning, SQL tuning, and performance planning.
• Transform complex business logic into database design and maintain it by using SQL objects like Stored Procedures, UDFs, Views, T-SQL scripting, and jobs.
• Successfully create SSIS packages to import and transform data between databases and external data sources using various transformations like Data conversion, File system task, Row counts, OLE DB Command, Merge Join, Look up, Sort, Data flow task.
• Carefully configure both Report Servers to manage paginated reports, mobile reports and KPI’s, allowing clients to consume them using a web browser, mobile device or as an email in their in-box.
• Create and develop Sub-Reports, Drilldown, Drill-through, and Parameterized reports using SSRS.
• Participate in Project Management and Software Development Life Cycle (SDLC) including analysis of business function, testing and documentation, and planning for redesign or transition to another platform.