About
Dedicated and well experienced Data Analyst with proven expertise in ETL data warehousing and Microsoft Business Intelligence tools (SSIS, SSRS, SQL), strong team player having the ability to build solid relationships with teammates, business partners, and specialists by fostering teamwork, partnership, and collaboration in a virtual or face-to-face environment, well-Organized with the ability to prioritize tasks based on their importance & urgency. Experience with SDLC, Agile, and Waterfall Methodologies approach to deliver business solutions. A detail-oriented person who is paying close attention to all the small details and is keen to utilize my passion for excellent project deliverables in providing the best possible experience.
Looking for Full-TimePortfolio
OFFICIAL Texas Department of Information Resource (DIR) Cooperative Contract Sales Data Fiscal 2019 To Present
DIR’s Cooperative Contracts program is a streamlined cooperative purchasing program with over 750+... ... More
Employment History
-
ETL/DW Developer
Colaberry INC
August 2017 - Present
➢ Create SSIS packages using various control flow and dataflow tasks to extract the data from multiple sources like Excel, XML, JSON, and OLTP and consolidate them into staging tables.
➢ Maintain SSIS packages for production and test environment for incoming source application files.
➢ Implement different Slowly Changing Dimension methodologies and Merge Statements to maintain and update data corresponding to Dimension tables in the Data warehouse.
➢ Monitor SSIS packages validation, error handling, and optimization issues.
➢ Scheduling Jobs and Alerting using SQL Server Agent. Worked on Multidimensional Modelling Development using SSDT.
➢ Design, implement and maintain Database Schemas, Entity-relationship diagrams, Data modeling, Tables, Stored procedures, Functions and Triggers, Constraints, Indexes, Schemas, Functions, Views, and complex SQL statements.
➢ SQL Query Optimization and Performance Tuning, Optimizing Stored Procedures and long-running queries using indexing strategies and query optimization techniques.
➢ Create parameterized reports, drill down, and drill through reports using SSRS.
➢ Held accountable for creating dashboards, Tabular, Matrix reports (crosstab or pivot), Charts, and graphs as per customer requirement using SSRS.
➢ Troubleshoot data integrity issues, T-SQL code defects, SSIS, and SSRS errors of varying complexity and address them as required.
➢ Partner with Business Analysts and Developers on an assigned line of a business project in the requirements definition and documentation of new customer reports/dashboards and oversee the maintenance and development of existing reports.
➢ Serve as a collaborative team member within both project management and software development life cycles (SDLC) including analysis of business functions, design, development, testing, and documentation as required by end-users.