SUMMARY

• Over 5+ years of experience in Development, Client Analysis, Database Design, Reporting and Presentation using SQL Server, SSMS and Power BI.
• Over 20 years of IT and Non - IT experience.
• Experience in developing Dashboard, Ad-hoc and Parameterized Reports, create complex reports (ex: drill down reports using different objects).
• Experience in the Data Analysis, Data Cleansing, and Data preparation for developing Power BI Dashboards
• Experience with Data Loading from various data sources like SQL Server DB, SSMS, Excel sheets, Text/CSV, Web Pages, Azure Data warehouse, Folder.
• Experience with various Data Transformation techniques for formatting and filtering the data, Merge Queries, Append Queries.
• Excellent experience with creating new columns based on Column by Examples, Conditional Columns, Custom Columns based on the Business requirements.
• Excellent experience in Data Modeling techniques to build/manage relationships between various data tables.
• Excellent experience with Create new custom tables, new measures, Quick measures, new columns, Hierarches, Groups, DAX formulae and syntax.
• Excellent experience with Data Visualization techniques to display the dashboard reports using various visualization charts, graphs, tables like Stacked/Clustered Bar charts, Maps, Matrix Tables, Pie charts, Slices etc.
• Excellent experience in designing and developing Navigation and Bookmarks, with visualization formatting, Paint roller, and mobile views
• Excellent experience creating various Workspaces and Publishing reports. Scheduling reports and data refreshes
• Experience in using ETL methodology for performing Data Migration, Extraction, Transformation and Loading using SSIS and designed data conversions from wide variety of source system.
• Experience working in Agile and Waterfall model working methodologies.
• Strong analytical and problem-solving skills coupled with excellent written, verbal and inter-personnel communication skills.

TECHNICAL SKILLS

Databases: MS SQL Server, Oracle, PL/SQL, SQL Server Management Studio(SSMS), Query Analyzer

Programming Languages: T-SQL, XML, ABAP, Python

Tools: /Utilities: Power BI, SQL Server Integration Services (SSIS)

PROFESSIONAL EXPERIENCE

Confidential

Power BI Data Analyst

Responsibilities:

• Collection of data from different sources such as GitHub, Web, and Excel or CSV files.
• Transform data using column profiling, changing data types, column renaming, and many other transformations according to the requirements.
• Created calculated columns and measures using DAX queries
• Created data visualizations using various visual objects (Line chart, Bar chart, Single card, KPI, Map, Pie chart, custom visuals).
• Created Bookmarks and custom tooltips

Confidential

Responsibilities:

• Performed ETL processes to data ready for creating business analysis visuals which help the leadership team to make the right business decisions.
• Worked on visuals as Employee Info, project details, skills, leaves, calendar, time sheet
• Created measures.
• Created and shared the dashboards within the organization for updating and editing the report as per the business requirement.
• Developed system standards, architecture, scenarios, detailed screen specifications and documented logical and physical data mode
• Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI
• Implemented role-based security and row level security on data in Power BI.
• Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.
• Created Power BI dashboard and generated reports using the SQL server tables as source. Lock objects on the reports.
• Performed Incremental load with several Dataflow tasks and Control Flow Tasks using SSIS.
• Deployed, Tested and Scheduled SSIS packages.
• Prepared the Layouts by placing the fields to the appropriate place according to the requirement of the final Report.
• Performed data extraction, transformation and loading (ETL) between systems using SQL tools such as SSIS.
• Generated multi parameterized reports in Report Builder allowing users the ability to make selections before executing reports; thus, making them user friendly.
• Extensive experience delivering OLAP cubes solutions by developing Corporate Dashboard Reports using MS SQL Server Reporting Services (SSRS), Report Model and Ad Hoc Reporting using Report Builder functionality.
• Developed dashboards to show survey, design, construction and information to field contractors.
• Developed various packages to extract the data from different source like relational tables and flat files.
• Analyzing and understanding the Excel Data and Creating SSIS Packages accordingly to dump the data in to SQL Database.
• Designed and developed a full-scale reporting solution for a multi-client environment using MS SQL Server R2 and Report Builder.
• Developed Sub Reports, Matrix Reports, Charts, and Drill down reports, using SQL Server Reporting Services.
• Involved inunderstanding their requirements and translating functional requirements to technical specifications.

Confidential

Sr Programmer

Responsibilities:

• Involved in development Client Analysis, Database Design, Reporting and Presentation using SQL Server, SSMS and Power BI.
• Leveraged multiple programming languages to develop applications for various platforms.
• Met with stakeholders, product teams, and customers throughout system development lifecycle.
• Resolved customer issues by establishing workarounds and solutions to debug and create defect fixes.
• Performed regression and performance tests for updated systems.

Confidential

High School Mathematics Teacher (Non-IT)

Responsibilities:

• Adapted teaching methods and instructional strategies to promote learning in students of differing skill levels.
• Taught various kinds of math at standard, remedial and advanced levels.
• Met with parents and guardians to discuss student progress and areas for improvement.
• Prepared, administered and graded assignments and examinations.
• Managed consistent, learning-focused classroom environments by establishing and communicating clear objectives for students.
• Instructed students and supported understanding of math concepts.
• Documented student assignments, attendance and test scores in online reporting systems.
• Assessed student progress with course material through routine quizzes, final examinations and standardized assessments.
• Evaluated submitted assignments for clarity and skills, assigned grades and discussed results with struggling students to enhance understanding of course objectives.