Data Management Analyst (SQL / SSIS/ Power BI)
ECS
Total years of experience :14 years, 11 Months
Highlights and Key Responsibilities:
• Support the US Department of Veterans Affairs (VA) Electronic Health Record Modernization Integration Office (EHRM-IO) program.
• Gathering business information needs from stakeholders and translating into requirements and functional specifications.
• Using Excel to analyze the data.
• Using Visual Studio to develop SSIS ETL packages for extracting, cleaning, transforming and loading data into target tables in SQL Server.
• Developing T-SQL code, stored procedures, views, functions, and other database objects to supply data needed for the reports.
• Importing raw date into SQL Server database and building SQL scripts to validate the Power BI reports and dashboards before delivery.
• Using DAX and Power Query to perform complex calculations based on requirements.
• Using GitHub to manage and keep track of source code history.
Highlights and Key Responsibilities:
• Gathered requirements from business users for Power BI reports and dashboards.
• Created new stored procedures and optimized existing queries and stored procedures.
• Developed ETL scripts using Python and processed and loaded data into SQL Server.
• Imported data from SAP, SQL Server and Excel into Power BI to generate reports and dashboards.
• Created DAX queries in Power BI to create measures and calculated columns.
Highlights and Key Responsibilities:
• Imaged and deployed laptop and desktop computers using System Center Configuration Manager.
• Provided remote support to customers regarding connectivity issues, hardware, software problems using TeamViewer.
• Tracked all issues using ServiceNow and ensuring timely resolution of problems and reducing response time.
• Installed and configured IP printers and troubleshooted printing issues.
• Created email accounts for new users using Active Directory and provided training.
Highlights and Key Responsibilities:
• Participated in business analysis activities to gather and understand business requirements to set functional specifications for reporting and dashboard applications.
• Translated business requirements into technical specifications that would be used to implement reports and dashboards.
• Developed new SSRS reports and performed maintenance of existing reports.
• Developed and modified Crystal Reports.
Highlights and Key Responsibilities:
• Participated in business analysis activities to gather and understand business requirements to set functional specifications for reporting and dashboard applications.
• Translated business requirements into technical specifications that would be used to implement reports and dashboards.
• Created database objects like Tables, Views, Stored Procedures and User Defined Functions and ad hoc complex queries to support SSRS reports.
• Created complex dashboards, drill down and drill through reports, parameterized reports, cascaded dropdown lists, charts, sub-reports and gauges using SSRS and MS Excel for analyzing the data at an enterprise level.
• Modified SSRS configuration files to include JPEG formats using XML tags which would allow exporting SSRS reports and dashboards as JPEG files.
• Exported SSRS subscription reports/dashboards as JPEG files and uploading to SharePoint Online using PowerShell and Windows Scheduler.
• Developed stored procedures using MERGE statement to modify data in the target tables based on data in the source tables and using SQL Agent to run the stored procedures on a given schedule to load data in the data warehouse.
• Used Power BI Desktop to develop reports and dashboards and publishing to Power BI Service.
• Integrated Power BI reports to SharePoint Online for distribution.
Highlights and Key Responsibilities:
• Interacted with business and end users for gathering requirements.
• Used ADO.NET objects such as Data Reader, Dataset and Data Adapter, for consistent access to SQL data sources.
• Modified existing web service applications using C# and XML and transformed XML documents using XSLT.
• Involved in developing T-SQL stored procedures in SQL Server 2008 R2 for fetching data and binding it to web controls.
• Used Microsoft Team Foundation Server for the purpose of version control and source code maintenance needs.
• Performed back-end testing using SQL queries, generating reports to ensure data integrity and validating the data being inserted and updated.
• Created virtual directories and application pools in IIS.
Highlights and Key Responsibilities:
• Developed and maintained user interfaces for a web-based application which is being used by various departments in the organization.
• Created and updated T-SQL stored procedures based on requirements to retrieve data and present on web forms.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Instrumental in performing bulk inserts from CSV files into SQL Server database tables and importing data from Access to SQL Server using SSIS.
• Designed and developed SSRS reports using Business Intelligence Development Studio (BIDs) and deployed the reports on the report server.
Previous Experience