We provide IT Staff Augmentation Services!

Business Intelligence Developer/support Analyst Resume

2.00/5 (Submit Your Rating)

UsA

Hire Now

Summary

  • 10+ years of experience in generating value through Analysis, Design, Development and Testing of SQL Objects, Internet/Intranet, Client Server and Object Oriented applications on .NET Framework 4.0/3.5/3.0/2.0/1.1.

SQL Server, Oracle:

  • 2000, 2005, and 2008 R2
  • Database design, data mapping, data modeling
  • Create Objects: Tables, Views, UDF\'s
  • Stored Procedures, T-SQL, PL/SQL, Joins, Query\'s, Sub Query\'s
  • Work with SSMS: SSIS, Server Agent
  • Installation, logging, and security

BIDS (Business Intelligence Development Studio)

  • SSIS, SSRS, SSAS
  • Cleansing Data, extraction, transformations
  • Created Containers, Loops, Bulk Inserts, Script Tasks, Maintenance Tasks
  • Data Flows, Merge, Merge Joins, Lookups, Aggregates, Union All, Conditional Split
  • Reporting Services Configuration Manager
  • Create/Design Reports. Report Server Projects, Report Models
  • Cube processing, hierarchies, MDX, KPI’s, Named Query, Named Calculations

.Net

  • Built web sites in C#, Stored Procedure calls to SQL Server and Oracle
  • UI faces
  • Business requirements and backend connectivity/classes
  • Framework 3.5, 4.0


Professional Experience

Confidential,January 2010 Sept 2011
Strategic Horizons Asset Management: Business Intelligence Developer/Support Analyst

  • Captured data requirements
  • Designed and Developed data models (Conceptual, Logical, Physical)
  • Developed Dimensions and Fact tables
  • Created robust report for different LOB’s to utilize their new reporting infrastructure.
  • Created SSRS for applications converted old Crystal Reports to MS reports
  • Loaded and transformed data for data warehouse and data mart.
  • Createdmulti-dimensional data models for SSAS cube development using ERWIN and EA
  • Prepared Source to Target mapping and transformations
  • Created SSIS packages to load staging tables.
  • Aligned Hierarchies, Named Calculations, Named Queries and SQL to MDX
  • Showed KPI’s and other analysis
  • Attached OLAP to Excel for users to analyze data
  • Created reporting applications

[SSIS, SSRS, SSAS, Crystal Reports XI, C#, SQL Server, LINQ Excel, MS Access, PerformancePoint, Erwin, EA]

Confidential,August 2009 - December 2009
Guide Wire to MAS500 SageGl: ETL Developer

  • SQL programming including stored procedures, functions
  • Created SSIS Packages that moved data from claims to HR for processing
  • Created the ETL process and validation
  • Created UI
  • Implemented business logic for client applications using VS2008

[SSIS, C#, SQL Server, Excel, MS Access]

Confidential,November 2008 - June 2009
Vioxx Claimant Processing and Reporting: Reports Developer

  • Create and modify reports
  • Gathered functional, non functional, and user requirements from attorney\'s
  • Gathered report specifications
  • Create pivot tables and spread sheets
  • Created stored procedures
  • Created and performed ad-hoc queries.

[SSIS, SSRS, Crystal Reports 9, SQL Server, Excel, MS Access]

Confidential,January 2008 - June 2008
Mortgage Delinquencies: Data Analyst

  • Perform data analysis
  • Managed a reporting system and analysis
  • Creation of database objects including tables, views and indexes
  • Gathered data to create new algorithms to determine actions for delinquencies
  • Created dashboards and scorecards
  • Created ETL and data mapping
  • Created multiple SSIS packages
  • Loaded and validated data marts
  • Created cubes for reporting
  • Created job alerts and notifications

[SSIS, SSRS, SQL Server, Excel, MS Access, Visio]

Confidential, January 2006 - November 2007
PTO Project Reporting: Crystal Reports Developer

  • Created stored procedures, functions, triggers
  • Perform database tuning through methods such as reviewing indexing strategies, database and server configurations, data access methods
  • Setup test plans for validation and data integrity
  • Analyzed data and relayed finding to management to determine escalation if needed
  • Manage and implement schema and data dictionary change control.
  • Created and performed ad-hoc queries
  • Created reports in Excel spread sheets for analysis
  • Created new reports for schedule and delivery
  • Completed BRDs, FDDs
  • Translate business requirements detailed technical documents and diagrams
  • Gathered and defined requirements from PMO
  • Code writing and implementation for SharePoint
  • Updated legacy code to more modern practices as needed.

[SSIS, SSRS, Crystal Reports XI, SQL Server, Excel, MS Access, Visio]

Confidential, March 2004 - July 2005
Financials: Reports Developer

  • Designed applications and reports for real estate portfolio management
  • Wrote queries and stored
  • Tested and validated accounting balances

[SSIS, SSRS, Crystal Decision, SQL Server, Excel, MS Access]

Education and Professional Development
Associates Aerospace Technology

Software Answers
Certifications:
SQL Server
T-SQL
Visual Studio
Train the Trainer

Hire Now
Report an issue

We'd love your feedback!

Privacy Policy
Resume Categories
Client Services
Job Seekers
Visa Sponsorship