Abosede S. Email & Phone Number

Richardson, Tx, Us

Richardson, Tx, Us

• Worked on all activities related to the development, implementation, administration and support of ETL processes• Created database objects like Tables, Views, Indexes and Stored Procedures.• Analyzed source system data to determine the data model and ETL solution that will meet business requirements.• Work with Report analysts and operation staff for support in problem resolution and root cause analysis.• Gather requirements from the user community and write Functional Design Specifications.• Performed detailed data analysis to determine the structure, content, and quality of the data through examination of source systems and data samples. • Worked closely with a team of technical and non-technical staff and consultants to iterate through versions of the deliverables. • Involved in creation of various Business Intelligence/ Analytical Dashboards utilizing Power BI with global filters, calculated columns and measures using complex DAX calculations and transformations using Query Editor & Power Query Formula Language (M). • Worked extensively building Power BI Dashboards with quick insights into KPIs and Advance analysis actions, Calculations, Parameters, Maps and Scatter plots. • Publishing of various kinds of live interactive data visualization dashboard reports and workbooks from Power BI Desktop to Power BI servers. • Conducted Training sessions for Power BI users and created the documents for end user support.

Atlanta, Georgia, Us

• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases• Used advanced SSIS tools (i.e. Derived Columns, Condition Split, Data Conversion, Merge Join, Multicasting).• Created complex SSIS packages using various transformations and tasks like Sequence Containers, Script, For loop and For Each Loop Container, Execute SQL, Send Mail, File System, Conditional Split, Data Conversion, Derived Column, Lookup, Merge Join, Union All, flat file source and destination, OLE DB source and destination, excel source and destination etc.• Contributed to the development and modification of coding standards for the team to ensure consistency, efficiency and accuracy in reporting and data analysis.• Performance tuning of Queries and Stored Procedures.• Performance tuning on existing ETL packages.• Designed various SSRS reports as requested by the client• Created and developed Sub-Reports, drill down reports, Drill through reports and Parameterized reports using SSRS.• Created Dashboards, Tabular, Matrix reports, Charts, and graphs as per customer requirements Using SSRS.• Rendered reports in different formats like pdf, excel etc. to be executed automatically on weekly or monthly basis and managed subscriptions.• Generated periodic reports based on the statistical analysis of the data from various time frame division using Power BI.• Supported the Business Intelligence/Analytics data analyst with the understanding of business and data requirements and iteratively designs visualizations for initial concepts and prototypes that can be presented to customers for feedback.