We provide IT Staff Augmentation Services!

Technology Analyst  Resume

2.00/5 (Submit Your Rating)

KY

Hire Now

SUMMARY:

More than 8+ years of strong MSBI experience with deep technical expertise in SSAS, SSIS, SSRS and Power BI. Have strong knowledge in data modelling for a data warehouse. Have developed and administered SQL server databases. Have vast experience in data analysis. Have considerable knowledge in visualization tools like tableau and qlikview. Worked in agile methodology.

TECHNICAL SKILLS:

Business Intelligence Tools: Visual Studio (SSAS, SSIS and SSRS)

Databases: SQL Server, Oracle, Teradata

Visualization Tools: Power BI, Tableau, Qlikview

Languages: C#, MDX, SQL, DAX

Others: Team Foundation Server, SharePoint

Development Model: Agile, Waterfall

PROFESSIONAL EXPERIENCE:

Technology Analyst

Confidential, KY

Responsibilities:
  • TTA Data Dictionary project provides detailed database analytics and metadata information of the manufacturing and logistics systems. Responsibilities includes Assessment of the systems, Requirement Elicitation, Provide assessment document and Data Dictionary document.
  • Responsible for Data analytics across multiple manufacturing and logistics applications to get a better understanding of transactional data and to find a pattern of data usage across the applications, using which data can be considered for further analytics and ensures the data quality, master data implementation across systems.

Data Analyst

Confidential,KA

Responsibilities:
  • This project gives an understanding on how much investment is made on the campaigning activities of the organization across geo. It also helps the user to understand the investment made by the organization in collaboration with the partner on the campaign to market their various products. This data helps the business to forecast their future investment area for their campaigns.
  • The project was implemented using agile methodologies and has lot of tailored power bi dashboards and tabular cubes across business users with dynamic row level security implemented.

Confidential

Technical Lead

Technology: Microsoft SQL Server, Teradata, SSAS, PowerBI, SSIS, SSRS

Responsibilities:

  • Understanding and converting business requirements into functional requirements document.
  • Perform Architecture review, Impact analysis, prepare proof of concepts (POC).
  • Develop ETL Packages in SSIS with proper configuration and audit templates along with checkpoint setup to perform a seamless data flow from various sources to Staging area and then to Data Mart dimension and fact tables.
  • Develop mid to high complex SQL store procedures and SQL query to accomplish business logics.
  • Create Tabular models using SSAS on top of Mart with proper relationships between tables using Star/Snowflake schema and to apply mid to high complex level of DAX code to apply data/Row level security.
  • Develop SSRS reports with rich graphic representation of data in form of Charts/PPS dashboards to give a consolidated view of relevant information.
  • Create Excel and Power BI reports on top of Data warehouse and tabular cubes to provide business users with interactive charts and drill through functionalities in Power view and PowerPivot.
  • Develop the deployment document, migration checklist to ensure all objects are migrated correctly to other environments.
  • Deploy the developed ETL to production and perform Unit Testing along with User Acceptance Test cases and resolve issues if any.
  • Prepare User documentation and to support team in prepare content for KT sessions
  • Post production support to business

Hire Now
Report an issue

We'd love your feedback!

Privacy Policy
Resume Categories
Client Services
Job Seekers
Visa Sponsorship