TECHNICAL SKILLS

• BI Tools - SSIS (ETL)
• SSRS
• Visual Studio. Databases SQL Server (2008 R2,2012, 2014)
• MS Access Database Programming T-SQL. Data Access Technology OLE DB
• ODBC
• ADO.NET. Programming Language C#. Windows NT/XP/8/10
• Windows Server. MS-Office-Word
• Excel
• Access
• PowerPoint
• Power Pivot
• Outlook
• MS-Azure
• MS-Project
• Power BI

PROFESSIONAL EXPERIENCE

Confidential, Baltimore, MD

Data Analyst / Power BI Consultant

Responsibilities:

• Pulled the data from ODBC Source to Power BI for Report Generation.
• Created periodic dashboards and visualization using MS Power BI.
• Published Power BI reports to end-user via mobile and Power BI service.
• Development of visualization tools as part of the dashboard.
• Worked with internal team members to define data model and integration points and created dashboards and reports that reflect the integrated data.
• Created Monthly, Yearly, Quarterly and daily reports in Power BI.
• Analyzed actual data structures and data warehouse information as input to the dashboards.
• Created measures, calculated columns, conditional column, custom columns in Power BI.
• Created KPI, Guage, Clustered column chart, Slicers for a better understanding of the report.
• Generated monthly and quarterly reports as bar charts for the management using different techniques like data filtering, adding interactivity, deploying reports to Power Bi Service. shared reports in Power BI service to the entire Organization in Office 365.
• Created document that defines the data model and integration points on the company’s ERP system and ADP system.
• Work with data architects and system owners to understand actual data structures.
• Developed training material and programs to support the organization’s departments including finance, human resources, product development and business development.
• Worked on licensing the whole organization with Power BI and SharePoint access .

Confidential, San Antonio, TX

Power BI Developer

Responsibilities:

• Generated periodic reports for the management in the UHS.
• Hands-on working on dummy projects with creating solution driven views and dashboards by developing different chart types including Pie Charts, Bar Charts, Tree Maps, Gantts, Circle Views, Line Charts, Area Charts, Scatter Plots, and Histograms in Power BI.
• Developed Custom Visualization in Power Bi such as Guage Charts.
• Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel.
• Pulled the data from SQL to Power BI for Report Generation.
• Wrote DAX Expressions, Power Query, Functions in power bi.
• Published Power BI reports to end-user via mobile and content packs.
• Used Power BI Power Pivot to develop data analysis prototype and used Power View and Power Map to visualize reports.
• Designed Data Model in Power BI such Fact and dimensional tables and relationships.
• Generated Monthly, Yearly, Quarterly and daily reports in Power BI.
• Worked and Joining the query's and merging the tables in Power BI.
• Created measures, calculated columns, conditional column, custom columns in Power BI.
• Created KPI, Guage, Clustered column chart, Slicers for a better understanding of the report.
• Generated monthly and quarterly reports as bar charts for the management using different techniques like data filtering, adding interactivity, deploying reports to Power Bi Service.

Confidential, San Antonio, TX

BI Developer

Responsibilities:

• Designed and developed and deployed SQL Server database to keep records of Customer details.
• Defined and implemented the processes required for proper data conversion from the existing system (Excel) to the new system (SQL Server).
• Wrote SQL queries against registration and payment databases, manipulated data for project monitoring and reporting purposes.
• Worked on assisting partner offices in developing an effective database management system. Query data from the relational database and create reports using SQL Server Reporting Services and Excel.
• Participated in the full life cycle of SSRS and Excel Reports (Authoring, Managing, and Delivery of reports) Created and managed SSIS Packages to extract data from various sources.
• Created SQL queries, views, functions, and stored procedures.
• Created parameterized SSRS reports with drill-down, drill-through, and interactive sorting capabilities. Used report builder to create various custom reports. Implemented snapshots, caching and subscriptions in the SSRS Report Manager.
• Worked on SSAS, utilized Multidimensional as well as Tabular models for report development purposes. Implemented database optimization, including indexing and SQL query performance tuning.

BI Developer

Confidential, Dulles, VA

Responsibilities:

• Expertly performed requirement gathering and analysis, analyzed and documented the system specifications and business requirements for database development.
• Designed, developed, modified and enhanced database structures and database objects.
• Developed logical and physical data models, design data access strategies and write SQL code to access and manipulate data stored in databases.
• Developed ETL solutions using SSIS (visual studio 2008R2 to 2012) that involves defining control flow task, data flows, data conversion, remove orphaned data, add derived columns and define database maintenance plans and send email tasks.
• Created and managed database objects such as tables, views, indexes, stored procedures, and triggers & maintaining Referential Integrity.
• Develop numerous simple to complex queries involving joins, correlated subqueries, CTE’s, views, stored procedures and functions for diverse business requirements.
• Tuned and optimized queries by analyzing different query options.
• Created SSIS package configurations, SQL Server Agent jobs, and job schedules.
• Imported data from multiple data sources such as OLTP, flat files, and created data flow solutions to cleanse and validate imported data. Inserted and/or updated newly cleansed and validated data into OLTP or OLAP databases.
• Implemented and maintained SSAS that includes designing cubes, measures and dimensions. Developed power pivot and worked on online excel in while developing reports.
• Created and deployed cubes, perspectives, partitioning, hierarchies, aggregations, KPIs, and roles in SSAS. Created parameterized SSRS reports with drill-down, drill through and interactive sorting capabilities.
• Implemented snapshots, caching and subscriptions in the SSRS Report Manager. Queried OLTP data with T-SQL and OLAP (fact and dimension) data with MDX. Applied data warehousing concepts to SSAS solutions.