We provide IT Staff Augmentation Services!

Sql Database Developer/bi Analyst Resume

Springfield, VA

SUMMARY:

  • Highly motivated and experienced SQL Server / BI developer with over 5+ years in database and reporting technologies.
  • Proficient in database development life cycle including data modeling, database coding, testing, and implementation.
  • In - depth knowledge and understanding of data warehousing and business intelligence.
  • Capable of collecting and analyzing business requirements through the lens of the development life cycle.
  • Hands on experience in designing complex reports using SQL Server Reporting Services (SSRS).
  • Experienced in writing complex stored procedures and script optimization and performance tuning.
  • Exceptional problem solving and verbal and written communication skills.

CORE COMPETENCIES:

  • Database Admin
  • Data Modeling
  • Testing and supporting next-generation database and application
  • SQL Performance Tuning, Optimization & Capacity Monitoring
  • Data Security, Backup & Recovery
  • SSIS, SSAS, SSRS
  • Crystal Report
  • Software Development Life Cycle
  • TFS
  • Agile (SCRUM/Urban Turtle)
  • MS SQL Server 2000/2005/2008 R2/2012
  • Strong analytical skills
  • Team Player

PROFESSIONAL EXPERIENCE:

Confidential, Springfield, VA

SQL Database Developer/BI Analyst

Responsibilities:

  • Worked with Business Analyst, Data Architect and business users to understand business processes, document project requirements.
  • Performed data extraction, transformation, and loading (ETL) between systems using SSIS. Utilized multiple sources and destinations, including Excel, Flat File, XML, and OLEDB connections.
  • Performed data validation and error handling and routed error files to flat file destination and notified sales officer via email.
  • Designed, developed, and maintained complex stored procedures, user defined functions, triggers, views, indexes, CTEs, temporary tables and other SQL objects to meet business objectives.
  • Created trace in SQL profiler and used database engine tuning advisor for performance tuning on stored procedures and scripts.
  • Designed tables for data marts using a star schema
  • Created complex stored procedures, views, joins to populate shared and embedded datasets
  • Created reports using KPIs, charts, gauges, bars, columns, matrix
  • Created executive-level dashboards used by upper management to gauge regional and district level sales performance on a daily, monthly, quarterly, and annual basis by product and brand.
  • Created SQL Server Drill down, Drill through, Adhoc, dashboard, Cross tab report using SSRS to fit business requirements.
  • Designed and created Report templates, bar graphs and pie charts based on the financial data.
  • Generated reports using SSRS which were send to different Primary Vendors, Clients, and managers.
  • Created reports using Global Variables, Expressions and Functions using MS SQL Server Reporting Services.
  • Designed and delivered dynamic reporting solutions using MS SQL Server Reporting Services.
  • Worked closely with DBA team to regularly monitor system for bottlenecks and implement appropriate solutions.
  • Deployed reports to Report Manager, managed subscriptions, and performed troubleshooting when execution errors occurred.
  • Performed optimization for reports running slow.
  • Scheduled reports to run on a daily and weekly basis in report manager and to email them to managers and analysts for review.

Confidential

ETL and Reports Developer

Responsibilities:

  • Worked with business users and stakeholders to understand business processes, project requirements document
  • Responsible for enhancement of daily ETL Packages from excel files and oledb sources.
  • Formulated and documented the physical ETL process design based on business requirements and specifications. Demonstrated strong ETL design skills, including source to target mappings, transformations, lookups, aggregations, and expressions.
  • Created complex SSIS packages which loaded multiple files using foreach loop containers, and utilized a wide-variety of data transformations, including conditional splits, data conversions, derived column, merge joins, script components, etc.
  • Created User Defined Functions, views, stored procedures to encapsulate frequently and commonly used business logic making the system more modular, secured, and extensible.
  • Implemented Error Handling in SSIS packages and notified process results to various users and business units.
  • Created complex stored procedures, views, joins to populate shared and embedded datasets
  • Created executive-level dashboards used by upper management to gauge sales performance on a daily, monthly, quarterly, and annual basis by product type and brand.
  • Created interactive reports for upper management with functionalities like drilldown reports, drill through reports, parameterized reports, reports with multiple levels of cascading parameters.
  • Identified problem areas performed troubleshooting when execution errors occurred and Deployed reports to Report Manager
  • Identified problem areas Performed Optimization and Performance Tuning of Stored Procedures, SSIS packages and reports

Hire Now