SUMMARY

BI Developer with multiple years of experience architecting and developing business intelligence and data analytics solutions. Highly motivated with strong SQL, ETL, Datawarehouse, data analytics, and reporting skills and a commitment to ensure strong operations, quality control, and compliance delivered to both internal and external business partners.

TECHNICAL SKILLS:

• ETL SQL Server Agile SCRUM
• SQL Excel (Power User) MySQL Data warehousing MS PowerBI Data Modeling
• Dimensional Modeling

PROFESSIONAL EXPERIENCE:

Confidential

Business Intelligence Developer

Responsibilities:

• Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems.
• Worked with DBA to design/implement/maintain the Data Warehouse solutions.
• Designed and developed SQL Server Databases, Tables, Indexes, Stored procedures, and Views
• Develop complex ad - hoc queries, triggers, views, Common Table Expression (CTE),User Defined functions and Stored Procedures using T- SQL, facilitate data transforms from source systems into the enterprise data warehouse
• Designed and developed (ETL) Extract, transform and load solutions for data warehousing using SSIS packages from diverse data sources like CSV, Excel, SQL server, Access database and flat files
• Compiled interactive business dash boards, Visualizations and reports using Excel and Power BI
• Led efforts to identify key performance indicators and metrics that facilitated reporting
• Implemented several (DAX) Data Analysis expressions functions for various fact calculations for efficient data visualization in Power BI.
• As part of a team, worked with other BI developers to design and document data structures.

Confdiential

Data Analyst/SQL Developer

Responsibilities:

• Developed business intelligence solutions (Dashboards and Reports) using Excel to deliver operational and strategic reporting to external clients.
• Worked closely with internal and external clients to provide meaningful insights (trends and patterns) into their data by developing data models using PowerPivot and establishing operational metrics and key performance indicators.
• Developed complex reports in Excel using pivot tables, pivot charts and advanced Excel formulas.
• Acted as the liaison between business and other technical staff; gathered requirements and participated in design sessions to provide reports and dashboards according to business specifications.
• Identified and corrected exceptions and inconsistencies in reporting data and continuously enhanced data quality based on requirements gathered from clients and business units.
• Created T-SQL queries to implement medium and complex business logic for reporting and analysis purposes.
• Participated in the development of the data analytics roadmap for external clients by evaluating and incorporating emerging standards, best practices, and new technologies.
• Created and maintained high profile Excel reports that assisted financial department reporting and disbursement analysis.
• Worked with database developers and business users to design, develop, and implement entity relationship models for transactional systems.
• Created physical data models by applying normalization methodologies; created tables, keys, relationships, and constraints using SQL.

Jr. Data Analyst

Responsibilities:

• Developed complex reports in Excel using pivot tables, pivot charts, and advanced excel formulas.
• Built medium to complex visualizations in PowerBI for operational reporting and analytics.
• Created multiple medium to complex T-SQL queries to extract data from databases into Excel and PowerBI for reporting purposes.
• Analyzed and reported financial data using Excel and PowerBI; provided recommendations to senior management and clients for decision making.
• Created project scheduling and performance dashboards using PowerBI; implemented native functionalities like row level security, custom visuals and themes, data modeling, and data transformation using Power Query.
• Extracted data from SQL Server databases and Excel files, transformed and built data models in Excel to provide a centralized source of truth for reporting and analytics purposes.
• Wrote and executed numerous ad hoc T-SQL queries to support data requests from multiple business units.
• Ensured that the reporting solutions and business processes met business user needs by participating in team review and developing requirements/specifications.
• Assisted management staff in the design of key performance metrics for operational analytics and forecasting.
• Participated in special projects and research assigned by the organization that required creating and running ad hoc queries for selected small work groups.
• Performed technical research and data gathering to support highly critical projects.
• As part of team, created and maintained business requirement documents as well as technical documents.

Confidential

Jr. Business Intelligence Analyst

Responsibilities:

• Created datasets by utilizing SQL quires to pull and create dataset to be used by various departments.
• Collaborates with other departments to design business reports for future forecasting and plan
• Design effective business strategies to enhance business growth and customer base
• Pulled daily reporting data using SQL, and used Power BI to create visuals, dashboards for business reporting
• Ensured that the reporting solutions and business processes meet the business user’s needs by participating in team review and developing requirements / specifications