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.