We provide IT Staff Augmentation Services!

Sql Sql/etl/ssis//bi/developer Resume

Arlington, VirginiA

OBJECTIVE:

SQL/ETL/SSIS//BI/Developer with 5 years of experience in implementing database development and data management solutions in Microsoft SQL server, writing complex queries to develop database objects, developing and maintaining ETL frameworks, data modeling, developing data warehouse, database design, dynamic reporting platforms, business intelligence applications and solutions, data management and analysis. Looking for dynamic working environment and competent firm, where I can contribute and further advance professionally.

PROFESSIONAL SUMMARY:

  • 5 years of experience in developing BI applications utilizing SQL server, BI stack, ETL Power BI SSIS.
  • Manage end - to-end change implementation planning including project management, issue management, and communications
  • Develop test plans and protocols for evaluation of system performance
  • Capacity to work with business units in analyzing business processes and recommending new ideas and/or efficiency opportunities
  • Develop user acceptance test scenarios, test scripts and results to validate configuration of the PDM system
  • Performs well under pressure; shows diplomacy, tact and good judgment when conflict arises
  • Collaborate with other IT and functional area personnel on routine and major system upgrades activity
  • Support internal and external audits
  • Developed parameterized reports which were used for making current and future business decisions.
  • Developed Stored Procedures to generate various Drill-through reports, Parameterized reports, Tabular reports and Matrix reports using SSRS.
  • Created reports that projected business goals for future.
  • Used table variables and Common Table Expressions (CTEs).
  • Worked closely with the offshore team in finding solutions to arising problems.
  • Identify the associated Store Procedures and parameters used for the reports
  • Followed a priority based
  • Involved in job scheduling and alerts.

TECHNICAL SKILLS:

Database: MS SQL Server, MS Access, Oracle, DB2, PostgreSQL SQL Server 2012, T-SQL, SSMS, Excel, SSIS, SSAS, SSRS, SharePoint, Power BI, Tableau, TFS, DTA, SQL Profiler, MS Azure, Data Factory, Visual Studio, C#.

Programming Languages: T-SQL, PL/SQL, C, HTML, DHTML, XML, VB.NET, C#.Net

ETL Tools: SQL Server Integration Services (SSIS), Data Transformation Service (DTS), Tableau

Reporting Tools: SQL Server Reporting Services (SSRS), Crystal Reports, Report Studio, Report builder.

Database Tools: SQL Server Management Studio, Oracle SQL Developer

SQL Server Tools: SQL Server Business Intelligence Development studio, Enterprise Manager, SQL Profiler, Query Analyzer, Import & Export (DTS), SSAS

Other Tools: MS Office Suite (Microsoft Word, Power Point, MS Visio), OLAP &OLTP, Adobe Photoshop, Abode Flash, Hyper-V Manager

PROFESSIONAL EXPERIENCE:

SQL SQL/ETL/SSIS//BI/Developer

Confidential, Arlington, Virginia

Responsibilities:

  • Developed complex database objects like complex stored procedures and complex UDFs
  • Created database objects like tables, views, indexes and triggers in MS SQL Server that support relational and dimensional database models.
  • Developed script for data manipulation and ensuring data integrity.
  • Developed complex SQL queries, and performed optimization of databases and tuning of long running SQL Queries by using SQL Server Profiler and SQL Tuning Advisor.
  • Designed, developed and maintained a data warehouse
  • Involved in requirements gathering, logical and physical data modeling, developing fact and dimension tables, configuring ETL work flows to populate fact and dimension tables, and developed Cubes and reports for analysis.
  • Developed and automated SSIS packages to perform Extraction, Transformation and Loading (ETL) of data from various sources like Flat file, MS Excel, CSV, MS Access to SQL Server.
  • Created SSIS Packages by using advance transformations (i.e. Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Aggregate) and used Custom components such as Audit on Pre-Execute, Audit on Post-Execute and Statistics Logging Component.
  • Created Dynamic SSIS packages using complex expressions, variables and control flow components such as for each Loop Container to loop over a Directory to load inbound files coming daily.
  • Prepared the Migration document showing the paths for input and output files, configuration files, table scripts, stored procedures and SSIS packages.
  • Tested, Cleaned and Standardized Data to meet the business standards using Fuzzy lookup and Exact lookups and String manipulations.
  • Enforced the Business Rules to filter bad data from the system by using Complex T- SQL Statements, and implemented various Constraints and Triggers for Data Consistency.
  • Responsible for creating the reports based on the requirements using SSRS.
  • Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel formats using Reporting Services (SSRS).

SQL SQL/ETL/SSIS/BI/Developer

Confidential, Alexandra, VA

Responsibilities:

  • Planned and designed data collection and survey tools and performed data analysis.
  • Created and tuned database objects such as tables, stored procedures, triggers, views, indexes and joins in MS SQL server to support relational and dimensional databases.
  • Developed SSIS packages to Extract, Transform and Load (ETL) data from different sources into database; and to transfer data from various sources including MS Excel, MS Access, and Flat Files to SQL database.
  • Scheduled SQL Server jobs to load data periodically using SQL Server Agent.
  • Created ad-hoc reports and complex enterprise reports such as drilldown, drill through, parameterized and cascading reports using SQL Server Reporting Services.
  • Designed and created report templates, plots, bar graphs and pie charts; and scheduled periodical reports to run automatically.
  • Writing T-SQL queries and stored procedures, creating various database objects as well as optimizing T-SQL code for faster performance.
  • Query Optimization and Performance Tuning by analyzing execution plans, handling Index fragmentation and using SQL profiler and Database Tuning Advisor (DTA) tools.
  • Loaded data to the interface tables from multiple data sources using OLEDB, ODBC, ADO.NET connections.
  • Migrated SSIS packages from development and QA servers to production environments using SSIS XML configuration files, environmental variables, and deployment wizards.
  • Created report crucial stored procedures and functions to support reporting dataset manipulation.
  • Created Solution Architecture based upon Microsoft Azure PaaS Services
  • Designed solution for various system components using Microsoft Azure.
  • Developed T-SQL stored procedures, functions and views to implement the business logic for front end applications, reports as well as ETL processes.
  • Wrote custom T-SQL stored procedures and scripts to provide application functionality and tuned them by creating indexes and ensuring optimized query design.
  • Designed SSIS Packages to transfer data between servers, load data into database from various heterogeneous sources like SQL Server, Excel and CSV and archive data files.

Junior SQL/ETL/SSIS/SSRS/SSAS/BI/Developer

Confidential

Responsibilities:

  • Involved in complete Software Development Lifecycle (SDLC).
  • Created Database Objects like Tables, Stored Procedures, Views, Triggers
  • Created complex SQL stored procedures, Triggers, Functions, Views, Indexes
  • Used both System and User-Defined functions to enhance the functionality of my T-SQL code
  • Developed Dynamic SQL for user customizable queries to be answered by the SQL Server
  • Designed and deployed reports in MS SQL Server environment using SSRS report services configuration manager.
  • Developed T-SQL stored procedures, functions and views to implement the business logic for front end applications, reports as well as ETL processes.
  • Developed interactive and static reports, sub reports, drill through, drill-down reports using various features like Matrix, Table, Charts, Graphs and Dashboard.
  • Follow and contribute to database best practices.

Hire Now