We provide IT Staff Augmentation Services!

Etl/reports Developer Resume

Torrance, CA

SUMMARY

  • Microsoft SQL Developer with Over 6 years of experience in designing, analyzing, developing, implementing, testing, deploying and maintaining database solutions usingSQLServer.
  • Strong T - SQL experience in creating database objects like tables, Stored Procedures, Views, Indexes, Functions, joins, unions and DDL/DML statements.
  • Expertise in writing T-SQL Queries, Dynamic-queries, sub-queries and complex joins for generating ComplexStored Procedures, User-defined Functions, CTE’s and Views.
  • Experience in various business domains like Financial Services and Media in high transactional and multi-server production environments.
  • Involved in heavy data migration/ETL activities using BCP, Data Transformation Services (DTS) and SQL Server Integration Services (SSIS).
  • Experience in creating packages to transfer data between ORACLE and SQL Server.
  • Experience in building SSIS packages involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server.
  • Excellent understanding of Relational Database Systems, Normalization, logical and physical data modeling for OLTP and dimensional modeling for OLAP.
  • Experience in designing, developing and deploying Reports using SSRS and Tableau.
  • Strong experience in developingparameterized, drill down, click through, chart, matrix, Ad-Hoc, sub reports using SSRS using data from a variety of sources.
  • Experience in writing and deploying SSRS Projects from development server to production server.
  • Good noledge on SSRS, Tableau, Power Pivot, Power Query, MS Excel and Agile methodology.
  • Experience in writing and debugging complex SQL Stored Procedures.
  • Experience in SQL Server tools like Microsoft Visual Studio, SSMS, SSIS, SSRS, SSDT and Tableau.
  • Advanced noledge in using Microsoft tools, Excel, Access and PowerPoint.
  • Self-motivated with strong time management capabilities and ability to adapt to shifting priorities.
  • Excellent verbal, written and interpersonal communication skills.

PROFESSIONAL EXPERIENCE

Confidential, Torrance, CA

ETL/Reports Developer

Responsibilities:

  • Created data integration and technical solutions for SQL databases and Data Warehouse for providing analytics and reports for improving marketing strategies.
  • Created views as required by front end developers for easier implementation.
  • Created complex stored procedures and functions to support efficient data storage and manipulation.
  • Optimized teh performance of queries with modification in TSQL code, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes wherever necessary.
  • Created and Scheduled SQL Server Agent Services jobs dat periodically extract data from multiple sources.
  • Monitored and tuned teh performance of Stored Procedures and complex T-SQL Queries using Clustered Indexes and implementing efficient coding standards.
  • Created several scripts dat included joins and subqueries.
  • Responsible for documenting Data Dictionaries and versioning them.
  • Created and deployed reports using SSRS and Tableau.
  • Conduct meetings with development team to discuss progress in developmental activities and requirement changes in teh data structure.
  • Perform teh tasks in a timely fashion and in line with teh Project Plan defined by teh Project Manager.

Confidential, Los Angeles, CA

MS SQL Developer (SSIS and SSRS)

Responsibilities:

  • Created and Troubleshoot Store Procedures, Tables, Views, Indexes and User Defined Functions.
  • Designed ETL process using SSIS Packages in which teh data sources include Oracle.
  • Developed complex mappings using SSIS to transform and load teh data from various source systems like Excel, Flat files, Oracle into SQL server database.
  • Designed transformations like Look up, Aggregate, Multicast, Conditional Split, Data Conversion, etc. in SSIS Packages.
  • Wrote SSRS Reports using SSDT and deployed teh Reports into Report Server.
  • Built SSRS project to generate reports with desired formats (Table, Word, PDF, Excel, etc.) to present statistics information according to business requirements.
  • Created complex SSRS reports dat include multiple data sources and stores procedures with nested tabular and matrix forms and formatted teh reports using teh Global variables and expressions (conditional formatting).

Confidential, Playa Vista, CA

Reports Developer (Tableau/SSRS/ Power BI)

Responsibilities:

  • Created, designed, developed and deployed Reports using Power BI, Tableau and SSRS. created new and maintain Power BI reports and dashboards, by taking data from SQL Server.
  • Good noledge of DAX, created calculated columns, measures and calculated tables.
  • Created reports using Cascading parameters and Sub reports, and ad hoc reports using SSRS.
  • Created reports using grouping, drill down, drill through options with parameters.

Confidential, Los Angeles, CA

SQL Developer (SSIS and SSRS)

Responsibilities:

  • Created SSIS packages to extract data from OLTP to OLAP systems.
  • Knowledge in Star and Snowflake schemas as well as Fact and Dimension Table.
  • Developed T-SQL parameterized Stored Procedures, Views, and User Defined Functions.
  • Developed complex mappings using SSIS to transform and load teh data from various source.
  • Utilized teh Dynamic SQL for user customizable queries to be answered by teh SQL Server.
  • Was responsible for identifying sources, creating staging databases, and data warehouse (Facts and Dimensions).
  • Managed teh entire ETL process involving teh extraction, analysis, transformation, loading and presentation of information to teh end users.
  • Identify slow running T-SQL batches, store procedures and generated trace files using SQL profiler to check performance improvements in future.
  • Created Stored Procedures, Views, and User Defined Functions to facilitate teh automation of data entry by a front-end application.

Hire Now