SUMMARY:

• 7 years of IT experience with strong experience in Data Warehouse, Modeling, andReporting.
• 5+ years’ experience in creating financial/retail/insurance reports and dashboards.
• Highly skilled problem solving, analytical, interpersonal and communication skills.
• Strong team player and a self - starter.
• Experience with all phases of Software Development Life Cycle (SDLC).

TECHNICAL SKILLS:

Technologies: SSAS, SSRS, Power BI,SQL Server Management Studio, MS Access, SQLServer Azure, PgAdmin4, AWS

Data Modeling: Physical and Logical Data Modeling

Data Warehousing & BI: Star Schema, Snowflake schema, Facts and Dimensions tables

PROFESSIONAL EXPERIENCE:

Confidential

Power BI Developer/ BI Analyst

Responsibilities:

• Design, develop, and deploy business intelligence solutions and reporting methodologies for communicating status and trends to leadership in both ad-hoc and automated formal reports
• Develop and implement compelling dashboards using data to “tell a story” and provide insights into key data points
• Partner with business stakeholders to gather business requirements and translate business needs into comprehensive reporting solutions for data analysis
• Identify ways to streamline report generation and provide business leaders with resources to enable informed decision-making, including self-service tools that enable users to analyze data through various business dimensions with visibility to granular and historical data
• Identify and resolve data reporting and data integrity issues in a timely fashion while looking for continuous improvement opportunities
• Support BI tools and database updates through development, testing, debugging and documentation
• Maintain up-to-date documentation, including diagrams, on all BI/applications development, database systems, integration services, and connectivity
• Be customer service oriented and maintain a professional approach regarding all district matters
• Perform R&D, remain knowledgeable of emerging trends in technology, and keep abreast of innovative practices
• Attain and keep current, relevant technology certifications
• Perform special projects, after-hours support and upgrades, and other related duties
• Gather and document business requirements for analytic reports. Participated in requirements meetings and data mappings sessions to understand business needs.
• Develop sample visuals options (POC) for discussion with the business.
• ·Created complex SQL queries, stored procedure, Common Table Expression (CTE) temporary table to support Power BI reports.
• Created calculated columns and measures using Data Analysis Expression (DAX).
• Embedded Power BI reports on web and managed access of reports and data for individual users using roles.
• Implemented Row Level Security (RLS) on reports.
• Provided continued maintenance and development of bug fixes for the existing and new Power BI reports.
• Pulled data from various sources like Data lakes, Azure SQL DB and imported it into Power BI.
• Created Paginated reports to export huge datasets from Power BI
• Conduct unit testing and troubleshooting

Confidential

BI Developer

Responsibilities:

• Import data from SQL Server DB, Azure log Analytics to Power BI to create reports.
• Used complex Dax functions to implement logic based on requirements.
• Imported data into Power BI and used the query editor to perform data cleansing using (M Code).
• Published Power BI Reports in the required origination and made dashboard available to end users.
• Installed and configured gateway in Power BI Service and use it to keep data from on premise up to date on the reports and dashboards.
• Explore data in various ways and across multiple visualization using Power BI.
• Created and modified Stored Procedures, Joins, Indexes, Data Import/Export, Triggers and Normalization.
• Implemented complex business logic using T - SQL, Views, and advance query
• Extract data from various enterprise data sources and connect, import and transform data for business intelligence and analysis
• Relate business goals to data elements and structures to support performance measurements and indicators
• Develop best practices and resolve technical issues
• Manage multiple priorities effectively
• Develop and maintain effective working relationships concepts.

Confidential

Data Analyst

Responsibilities:

• Updated reports based on new requirements and system changes, captured report requirementsfrom end - users, and documented requirements.
• Work closely with the IT Managers to develop graphs, Matrix reports, drilldown, drill through,sub reports, dashboards and presentations for quality activities, patterns or trends and operationalmetrics.
• Modified existing reports in SSRS using charts, graphs, tables and matrices.
• Performed ad-hoc analysis, translated results into clear and concise reporting, and created jobaids for report generation.
• Migrated data from various sources into data warehouse using SSIS.
• Used SQL to analyze, query, sort and manipulate data according to defined business rules andprocedures.
• Used various data transformations like, conditional Split, derived column transformations tomove data to/from various sources to different destinations.
• Used Joins to combine multiple tables and use as a dataset +to create reports in SSRS.
• Imported multiple daily and weekly CSV files (using bulk insert SQL command) into Tables togenerate Reports.
• Gathered and analyzed data; developed and built SSRS reports in support of the business.
• Responded to requests for specific customized reports.
• Interpreted business needs and translated them into easy-to-follow written documentation.
• Translated customer needs into application requirements, documented details of the project.
• Provided analytical support for a variety of business processes such as capacity managementand new product development.