BI Developer/ Information Analyst Resume Lewisville, TX - Hire IT People

SUMMARY:

Recognized BI Database Developer, developing database models and designs that unify data into a single, cohesive platform from geographically and operationally dispersed systems and servers.
Track record of success leveraging data - driven solutions to improve or automate business processes, cut costs, and facilitate revenue growth.
Adept Confidential instituting robust reporting mechanisms, executive dashboards, and ad hoc reporting tools.

EXPERTISE AREA:

TECHNICAL SKILLS:

Databases: Oracle 9i/10g/11g/ MS SQL Server 2005/08/12

Development Languages: PL-SQL, Confidential -SQL, PHP/MySQL, HTML/XML

Business Intelligence: IBM Cognos 8/10, SSRS And SSIS

Data Management & Administration: TOAD, SQL Server Management Studio

Project Management & Documentation: JIRA, SharePoint, MS-Office Suite.

PROFESSIONAL EXPERIENCE:

Confidential, Lewisville, TX

BI Developer/ Information Analyst

Responsibilities:

Development and deployment of MIS solutions requested by various Defaults, Foreclosure & Servicing Businesses.
Provides technical leadership as well as analytical to the business analyst and new approaches to solving problem .
Effectively work independently and handle multiple projects simultaneously.
Created and maintained databases for Development Environments using SQL Server 2008,2012.
Created and Modified complex stored procedures, and functions.
Worked for Performance Tuning, Query Optimization and indexes analysis
Created reports using SSRS from OLAP and OLTP data sources and deployed on the report server.
Created ad hoc reports in Excel Power Pivots.
Configured and maintained Report Manager and Report Server for SSRS.
Worked with a diverse team consists of business analysts, data analysts and ETL/BI developers and Business users.
Support business users during User Acceptance Testing.
Maintain emails, files, updates and Documentation with SharePoint.
Coordinate between onsite and offshore team to ensure better turnaround in productivity and on-time delivery.

Confidential, Seattle, Washington

Senior Application Developer & Technical Lead

Responsibilities:

Created database, functions, triggers, stored procedures, views, tables, packages and Confidential -SQL script for application.
Fine-tuned database queries and created appropriate indexes for better performance plans.
Worked on complex reports (Drill down, Drill through, Drop down, Multi- parameterized and linked reports).
Used SSIS packages/jobs broadly to migrate and transform data from legacy database system.
Actively participated in creation of logical and physical database design implementation
Created data mapping document and isolated each business attributes to design the effective model.
Documented the results of analysis, workflows and acquired sign-off from the internal Clients.
Designed and executed the test scripts and test scenarios to make sure source data are matching with target.
Performed quality reviews and recommended process improvements for the SSRS Reports

Confidential, Irving, Texas

BI Developer

Responsibilities:

Involved in requirement gathering for User Interface of the reports on Cognos.
Identified the associated RDL file for each report in visual studio.
Identify the associated Store Procedures and Parameters used for the reports.
Validated SSRS reports against the source system.
Modify Store Procedure to align with the Cognos, such as Data types.
Administered Data Source Connection and secure the connection for various user groups.
Created test users, assigned roles and permissions.
Import Store Procedures in Framework Manager and add prompts.
Apply object level security in the Framework Manager and publish the package.
Converted 59 SSRS reports to Cognos report using report studio on chart, list, crosstab and dashboard

Confidential, Irving, Texas

Operation Manager

Responsibilities: