Data Analyst / BI Developer Resume Atlanta, GA - Hire IT People

SUMMARY

More than 4 years of experiencein Software Development Life Cycle Phases like Analysis, Design, Development, Documentation, Deployment and System Support.
Involved in business to develop Entity Relationship/data models, requirements document, and ETL specifications.
Advance noledge in RDBMS concepts,conceptual/logical/physical data models & Dimensional/Star/Snow Flakeschemas.
Experienced in ETL design, development,andimplementation.
Proficient in working with SQL statements to extract data from data tables and verify teh output data of teh reports.
Experienced in using ETL tools to design SQL Server Integration services SSIS) packages for Data Management applications.
Expert in creating Power BI Reports, Dashboards, Power BI Apps using Power BI Desktop and Power BI Service.
Expert in Configuring/Managing Power BI Gateways, Shared Datasets, Roles, Security Groups and Automated Refresh of Power BI Reports/Dashboards.
Extensively used Date/Time, Filter, Logical, Time Intelligence and Math DAX functions in Power BI Reports.
Expert in creating Calculated Tables, Calculated Columns, Complex Measure/Measure Groups, Hierarchies in Power BI Reports.
Excellent analytical and communication skills to present points precisely and solve problems efficiently.
Detail - oriented multi-tasking with strong technical concepts and organizational abilities.

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Data Analyst / BI Developer

Confidential, Atlanta, GA

Responsibilities:

Designing teh ETL architecture for incremental load to keep old and new applications in sync.
Worked with Change Data Capture (CDC) tasks in SSIS packages to achieve incremental loads.
Design and implement staging, landing and archive layers to bridge teh gap between applications and improve performance for incremental load.
SSIS packages design for data migration from scratch including package configurations and error handling.
Complex SQL queries and store procedures to perform data transformations as per mapping documentation
Designed and developed Power BI reports and Dashboards and published reports to Power Bi service for end users.
Created Pie chart, Line Chart, Tree Map, waterfall chart, Clustered Bar chart, Scatter charts, table, and Matrix charts in power BI reports.
Extensively used Date/Time, Filter, Logical, Time Intelligence and Math DAX functions in power BI reports.
Installed Power BI Personal/Enterprise Gateway and scheduled automatic refresh of reports on Power BI Service.
Involved in Technical Design Specification Documentations and Data Dictionaries.

Programmer Analyst

Confidential

Responsibilities:

Involved in Database planning in relation to physical and logical data architecture.
Created data-related documentation (e.g., file descriptions and definitions, entity relationships and attributes).
Designed new SSIS packages and deployed them.
Used SSIS to populate data from various data sources, creating packages for different data loading operations for applications.
Writing Stored Procedures, Triggers, cursors and creating indexes.
Checked Performance Tuning, Indexing, Query Optimization.
Optimized teh performance of queries with modification in T-SQL queries, normalized tables, established joins and created indexes wherever necessary.
Provided on - call 24/7 provide support.