We provide IT Staff Augmentation Services!

Data Warehouse Analyst & Lead Sql Developer Resume

4.00/5 (Submit Your Rating)

WatforD

PROFESSIONAL SUMMARY:

  • Have end - to-end experience in Software Requirement Analysis, Estimation, Documentations,
  • ETL Development, Execution and Management, Defect Resolution, BI Reporting,
  • Implementation/Deployment, Support/Enhancement and Maintenance.
  • Have in-depth knowledge in Extract, Transform and Load (ETL) development using SQL Server
  • Management Studio (SSMS) and SQL Server Integration Services (SSIS).
  • Designed conceptual data model based on the requirement, Interacted wif non-technical end
  • Modeled the logical and physical diagram of the future state, Delivered BRD and the low level
  • Discuss and develop Data model, data flow and data mapping wif the development team.
  • Discuss and Develop Conceptual Data Model
  • Integrate multiple data Models and create a Single Unified Model
  • Translated and assembled business requirements into detailed, production-level technical
  • Specifications, detailing new features and enhancements to existing business functionality.
  • Experience in database design which includes the concept of fact and dimension.
  • Experience in debugging, fixing, query optimization and performance tuning.
  • Software Development Life Cycle -Waterfall and Agile Methodologies
  • Unit Testing of T-SQL code by creating test data.
  • Experience in reporting using SAP Business Objects and SAS Enterprise Guide.
  • Troubleshooting of Production issues wifin SLA.
  • Excellent oral and written communication skill.
  • Adaptable to change, Strong Attitude, Creativity and Analytical approach to problem solving and
  • Highly task oriented.
  • Ability to handle multiple assignments wif critical deadlines and changing priorities.
  • Create and refine data visualization and interactive dashboards using QlikView, Tableau, Power
  • BI, SQL Server Reporting, and other software.
  • Created the data models for OLTP (online transaction processing) and OLAP (online analytical processing) systems.
  • Engaged in data profiling to integrate data from different sources and Performed the gap
  • Analysis and impact analysis.
  • Assisted DBAs on support needs and provided guidance on architectural issues.
  • Participate in the maintenance and development of online web reporting capabilities.
  • Work closely wif clients from academic and administrative units to define requirements and
  • Solutions and provide decision support consultations.
  • Partner wif IT staff to develop efficient data structures, provide access to data and participate in
  • Data conversion and data migration efforts.
  • Collaborate wif financial analysts on complex analyses.
  • Document best practices, processes, utilities, and reports.
  • Experience working in JIRA, Confluence, Service-Now.
  • Facilitated QA for developing test plans and test cases for unit, system, and Enterprise testing.
  • Collaborated on the data mapping document from source-to-target and the data quality

TECHNICAL SKILLS:

Software: SQL Server Management Studio (2005 & 2008 R2), Microsoft Business Intelligence Development Studio (2005, 2008 R2 & 2012), SAP Business Objects XI 3.1, SAS Enterprise Guide 9.1, and SAS Enterprise Guide 9.4

Tools: Analytical Tool + ETL Tool + Reporting Tool - SQL Server Management Studio (2005, 2008 R2 & 2012)ETL Tool - Microsoft Business Intelligence Development Studio (2005, 2008 R2 & 2012) Reporting Tool - Microsoft Business Intelligence Development Studio (2005, 2008 R2 & 2012), SAP Business Objects XI 3.1, SAS Enterprise Guide 9.1, and SAS Enterprise Guide 9.4

Methods: Waterfall and Agile methodologies of Software Development Life Cycle

Domain Experience: Mortgage Loan Business, Banking

PROFESSIONAL EXPERIENCE

Confidential, Watford

Data Warehouse Analyst & Lead SQL Developer

Responsibilities:

  • Offshore lead role where actively participated in Requirement gathering from different Business users, project planning, effort estimation, design, and development of ETL framework and Quality assurance.
  • T-SQL programming through SQL Server Management Studio
  • Reporting by SQL Server Integration Services (SSIS).
  • Requirement gathering and coordination wif Client and team
  • Attend daily status call and provide inputs on day to day activities and share thoughts on important decisions.
  • As a Data Warehouse Analyst, the responsibility was to assume a key role in day-to-day support of Business Intelligence tools, Decisions and Reporting solutions, Business Objects, and underlying ETL framework.
  • Involved in analysis and cleansing of data. Developed reporting tools for use by other Transmission staff.
  • Reviewed the logical model wif application developers, ETL Team, DBA's, and testing team to provide information about the Data Model and business requirements.
  • Prepared Logical Data Modelling using ERWIN dat contains set of diagrams and supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the data elements to analyse and document business data requirements.
  • Responsible for analysing huge data sets wif basic statistical methods, interprets results, and provides written summaries of data analysis.
  • Collaborated on the data mapping document from source-to-target and the data quality assessments for the source data.
  • Database programming in T-SQL through SQL Server Management Studio which includes the concept of Join, Cursors, Ref-cursors, Procedures, Functions, Partitioned Tables, Triggers, Table Indexing for Extract, Transform and Load (ETL) of source data.
  • Writing complex queries, aggregating tables, truncating, dropping, modifying tables joins and source queries to pull data from other sources to integrate in the data warehouse, Full and Incremental loads.
  • Designed scalable, flexible, and affordable Data warehouse models, created surrogate keys, and worked wif bridge tables.
  • Facilitated QA for developing test plans and test cases for unit, system, and Enterprise testing.
  • Documented monthly status reports for enhancement and modification requests for the development team to assist them in efficient tracking and monitoring of open issues of the project.
  • Created the data models for OLTP (online transaction processing) and OLAP (online analytical processing) systems.

Confidential,Watford

Data Warehouse Analyst & Lead Onshore Developer

Responsibilities:

  • Worked as a Lead Onshore Developer actively participated in Requirement gathering from different Business users, project planning, effort estimation, design, and development of ETL framework and Quality assurance
  • Development on development on T-SQL programming through SQL Server Management Studio
  • Reporting by SQL Server Integration Services (SSIS).
  • Requirement gathering and coordination wif Client and offshore team
  • Attend daily status call and provide inputs on day to day activities and share thoughts on important decisions.
  • As a Data Warehouse Analyst, the responsibility was to assume a key role in day-to-day support of Business Intelligence tools, Decisions and Reporting solutions, Business Objects, and underlying ETL framework.
  • Involved in analysis and cleansing of data. Developed reporting tools for use by other Transmission staff.
  • Reviewed the logical model wif application developers, ETL Team, DBA's, and testing team to provide information about the Data Model and business requirements.
  • Prepared Logical Data Modelling using ERWIN dat contains set of diagrams and supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the data elements to analyse and document business data requirements.
  • Collaborated on the data mapping document from source-to-target and the data quality assessments for the source data.
  • Database design/Data warehousing which includes the concepts fact and dimension tables.
  • Responsible for analysing huge data sets wif basic statistical methods, interprets results, and provides written summaries of data analysis.
  • Writing complex queries, aggregating tables, truncating, dropping, modifying tables joins and source queries to pull data from other sources to integrate in the data warehouse, Full and Incremental loads.
  • Designed scalable, flexible, and affordable Data warehouse models, created surrogate keys, and worked wif bridge tables.
  • Facilitated QA for developing test plans and test cases for unit, system, and Enterprise testing.
  • Documented monthly status reports for enhancement and modification requests for the development team to assist them in efficient tracking and monitoring of open issues of the project.
  • Created the data models for OLTP (online transaction processing) and OLAP (online analytical processing) systems.

Confidential,Watford

Data Warehouse Analyst & SQL Developer

Responsibilities:

  • Database design/Data warehousing which includes the concepts fact and dimension tables.
  • Database programming in T-SQL through SQL Server Management Studio which includes the concept of Join, Cursors, Ref-cursors, Procedures, Functions, Partitioned Tables, Triggers, Table Indexing for Extract, Transform and Load (ETL) of source data.
  • For reporting of source data by SQL Server Integration Services (SSIS), SAP Business Objects XI 3.1, SAS Enterprise Guide 9.4
  • Automation of daily, monthly, and quarterly ETL activities by creation of jobs and streamlined the entire load process.
  • Built the DW environment using SQL server tables wif Terabytes of Data. Using SQL Server Integration Services (SSIS) as an ETL Tool, the data has Extracted, Transformed and Loaded (ETL) from Excel and Flat file to MS SQL Server.
  • Modeled the logical and physical diagram of the future state, Delivered BRD and the low-levels design document.
  • Discuss and develop Data model, data flow and data mapping wif the application development team.
  • Discuss and Develop Conceptual Data Model
  • Experience in Query Optimization, Debugging, and Tuning for improving performance.
  • Reviewed basic SQL queries and edited inner, left, and right joins by connecting live/dynamic datasets.
  • Attend daily status call and provide inputs on day to day activities and share thoughts on important decisions.
  • Collaborated on the data mapping document from source-to-target and the data quality assessments for the source data.
  • Database programming in T-SQL through SQL Server Management Studio which includes the concept of Join, Cursors, Ref-cursors, Procedures, Functions, Partitioned Tables, Triggers, Table Indexing for Extract, Transform and Load (ETL) of source data.
  • Writing complex queries, aggregating tables, truncating, dropping, modifying tables joins and source queries to pull data from other sources to integrate in the data warehouse, Full and Incremental loads.
  • Designed scalable, flexible, and affordable Data warehouse models, created surrogate keys, and worked wif bridge tables.
  • Created the data models for OLTP (online transaction processing) and OLAP (online analytical processing) systems.

Confidential,Watford

Application Administrator & Data Warehouse Analyst

Responsibilities:

  • User creation for SAS Enterprise Guide 9.4 and SAS Enterprise Guide 9.1
  • Library creation both ODBC and Flat file for SAS Enterprise Guide 9.4 and SAS Enterprise Guide 9.1
  • Creation of jobs in SQL Server Management Studio, SQL Server Integrated Services and SAS Enterprise Guide.
  • Creation of Web Intelligence Report by creation of object (Dimensions and Measures), universes in SAP Business Object.
  • Worked extensively as a data analyst. Worked extensively wif the business users to gather requirements.
  • Writing complex queries, aggregating tables, truncating, dropping, modifying tables joins and source queries to pull data from other sources to integrate in the data warehouse, Full and Incremental loads.
  • Designed scalable, flexible, and affordable Data warehouse models, created surrogate keys, and worked wif bridge tables.
  • Worked extensively on troubleshooting different production issues wifin Service Level Agreement (SLA).
  • Prepared knowledge documents of the daily, monthly, quarterly daily load process.
  • Automated different processes by eliminating manual intervention and streamlined it.
  • Documented monthly status reports for enhancement and modification requests for the development team to assist them in efficient tracking and monitoring of open issues of the project.

We'd love your feedback!