sr data analyst support engineer resume example

• Led the development of Data Mart for supply chain,marketing departments along with analysis of existing data warehouse for performance improvements.
• Worked on all phases of data warehouse development life cycle, from gathering requirements, implementation, testing, training and support.
• Interviewed Business Users of the Data Warehouse and the Business Analysts to understand and troubleshoot the existing bottlenecks and problem areas.
• Developed applications and designed processes for transformation and data management from company-wide databases.
• Developed automated data dictionary for Enterprise Data Warehouse using SSRS and SQL.
• Completed a thorough analysis of the issues with the cube processing and query processing to identify bottleneck for the existing facts and dimensions.
• Designed and developed ETL packages to facilitate incremental load process.
• Created aggregates, partitions, attribute relationships and user defined hierarchies with the goal to reduce the cube processing time and query processing time.
• Created stored procedures and performed index analysis for slow performing SSRS reports to bring down the report rendering time.
• Developed Enterprise wide cascading reports in SSRS that were used throughout the agency to monitor the performance of the cube, logging of the nightly ETL loads and also to monitor most active users of the cube.
• Created robust and high-performing ETL mappings using SSIS and Metl.
• Migrated existing self-service reports and adhoc reports to Power BI.
• Developed custom calculated measures using DAX in Power BI to satisfy business needs.
• Assisted users in accessing databases, troubleshooting malfunctions and removing system-based barriers to task completion.

Client: Cvs Caremark, Irving, Tx

• Worked on ambitious project to develop an Enterprise Wide Drug plan Record system data warehouse connecting Insurance companies and Drug Manufacturers for CVS Caremark.
• Worked with Business Intelligence Manager to plan BI strategies, create BI road map and budget plans to deliver on organizations Business Intelligence needs.
• Assessed the impact of current business processes on users and stakeholders.
• Developed multiple dashboards, analytical reports, KPIs and Interactive reports based on business requirements using SSRS to support executive business needs.
• Transferred data from various data sources/business systems including MS Excel, MS Access, Flat files,COSMOS etc. to SQL Server using SSIS.
• Implemented Query Optimization and performance tuning for slow performing SQL queries.
• Involved in writing complex T-SQL queries and stored procedures to perform data transformations and to support SSRS Reports.
• Involved in creating User Security and Roles in reporting services at both parent level and report level.
• Supported maintenance of Data Quality Service's (DQS) knowledge base and development of Master Data Service's database.

Client: Sun Trust Bank, US

• Designed, Implemented, and aided End-to-End data migration project using Microsoft SSIS.
• Assisted in creation of internal applications for marketing and customer relations departments, including financial reporting tools and reports.
• Designed SSIS Packages to extract data from various data sources such as Excel spreadsheet, and flat files and load data into destination databases for further Data Analysis and Reporting.
• Performed rigorous business case analyses and proposed various process improvements.
• Used Excel and Access applications for visualizing the data functionality.
• Led an initiative to convert all excel files which were used in in-house time/expense reporting wherein I automated the process to find discrepancies in timesheets by creating tables, views using stored procedures.

Client : Marks and Spencer,UK

• Improved business direction by prioritizing customers and implementing changes based on collected feedback.
• Analyzed open orders, backlog, and sales data to provide sales team with insights.
• Created tables and define their relations by using foreign key and primary key relationship.
• Involved in creating database objects using stored procedures, Triggers, Functions, Views and T-SQL Joins using T-SQL.
• Performed normalization of database to reduce redundancy and achieve maximum system performance.
• Wrote custom T-SQL stored procedures and triggers to improve performance, preserve referential integrity, and provide additional application functionality
• Worked as ETL Developer for an End-to-End implementation of Operation Data Warehousing Project.
• Responsible for data integration and transformation using SSIS.
• Formulated and documented the physical ETL process design based on business requirements and system specifications with strong ETL design skills.
• Created source to target mappings, transformations, lookups, aggregations, expressions
• Involved in scheduling reports, creating snapshot reports and subscription for the reports Using SSRS.