We provide IT Staff Augmentation Services!

Sr. Business Intelligence Developer Resume

3.00/5 (Submit Your Rating)

SUMMARY:

  • More than 10 Years of professional experience as MS SQL Server Developer/DBA and developing complex projects for major financial, entertainment and health care firms.
  • Extensive knowledge in MS SQL Server.
  • Expert Level of experience in designing and coding SSIS packages, SSRS reports, Crystal Reports, stored procedures, triggers, views and indices using T - SQL.
  • Expert Level of experience with ETL, SSIS, SSAS and SSRS.
  • Experience with Oracle PL/SQL
  • Experience in SQL Server to Oracle database conversion and transferring data using Replication.
  • Extensive knowledge of Software Development Life Cycle.
  • Experience in Autosys, TFS, CVS, SVN and Toad.
  • Experience in PERL and UNIX Shell scripting.
  • Familiarity with AbInitio ETL.
  • Managed a team of 7 developers.
  • Excellent interpersonal communication and analytical skills.
  • Self-motivated, responsible and willing to assume responsibility.

SOFTWARES:

  • MS SQL Server 2014/2008/2005
  • C#/ASP.NET
  • Visual Studio / BIDS
  • Crystal Reports
  • Tableau
  • Clearcase / CVS / VSS / TFS
  • Sybase 12.5
  • Oracle 10g
  • Teradata/SAS
  • ColdFusion
  • MS Access
  • Perl
  • Rapid SQL
  • PowerDesigner
  • Visio
  • Autosys
  • Azure

WORK EXPERIENCE:

Sr. Business Intelligence Developer

Confidential

Responsibilities:

  • Work with users to gather business requirements
  • Design the conceptual schema for the health care application
  • Develop and implement the database for the application
  • Use SQL Profiler to resolve performance related issues
  • Create SQL Agent jobs for automation of processes
  • Wrote a number of ETL/SSIS packages to input data from different sources into the database.
  • Wrote a number of complicated reports using SSRS and Crystal Reports for the metrics dashboard
  • Wrote a number of stored procedures, functions, views and SQL scripts that contains the business logic.
  • Code optimization and performance tuning of existing stored procedures
  • Wrote a number of C# scripts in SSIS to validate results
  • Create logins and maintain user roles for database security
  • Develop a front end web application to run SSIS packages manually on demand by changing configuration parameters in the front end.

Environment: SQL Server 2014/2008, SSIS, SSRS, Crystal Reports, TFS, SAS, C#.NET, ASP.NET, Tableau

Sr. Business Intelligence Developer

Confidential

Responsibilities:

  • Work with users to gather business requirements
  • Design the conceptual schema for the Tax Analysis application
  • Develop and implement the database for the application
  • Wrote a number of stored procedures and SQL scripts to interface with the UI.
  • Wrote a number of complicated SSRS reports to report the Tax data
  • Mentor and help junior developers into writing efficient code
  • Code optimization and performance tuning of existing stored procedures
  • Wrote a number of ETL/SSIS packages to retrieve data from Teradata and XML based vendor files and insert data into SQL Server.
  • Production system support

Environment: SQL Server 2008, Teradata/SAS, .NET, TFS, Sharepoint 2010

SQL Server Developer/BI Solutions Developer

Confidential

Responsibilities:

  • Evaluated existing BI solution, identified areas for improvement, and suggested new data model and reporting solution that involved integration of both self-service and IT developed reports.
  • Developed OLAP cube containing 3 years worth of data. Included multiple dimensions and measure groups, complex date related calculated fields and conditional formatting.
  • Designed and developed data warehouse based on operational systems and optimized for enterprise wide reporting. Data warehouse was designed using SQL Server 2008.

Environment: SQL Server 2008/2005, Azure, SSIS, SSAS, SSRS, ColdFusion.

Senior SQL Server Developer/DBA

Confidential

Responsibilities:

  • Designed, developed and implemented code using Perl, Oracle and SQL Server for Four major modules
  • SQL Server and Oracle back-end development which included writing SSIS packages, stored procedures, SQL scripts, triggers, views, and indices
  • Production system support
  • Work on SQL Server to Oracle 10g database conversion
  • Write scripts to transfer data from SQL Server to Oracle using Replication
  • Used Autosys for automated job scheduling
  • Prepare SDLC documents for auditing purposes
  • Worked on loading data into Axiom Risk Analysis tool

Environment: SQL Server 2008, Oracle 10g, Perl, Unix, Axiom, AbInitio.

We'd love your feedback!