Uploaded File
no photo
Lead Programer
14 years experience Houston Heights, TX
Actively seeking
no photo
Lead Programer
Average rating
Profile views
Windows ADO.NET ASP.NET MS Visio VB.NET HTML Java SQL Oracle SQL Server
Remove Note
View Note
Recent Experience
Lead Programer 08/15 - present
Senior Programmer 05/14 - 08/15
VB.NET ASP.NET WebServices ADO.NET HTML JavaScript MS Visio SQL Crystal Reports Java Oracle SQL Server SSAS SSIS SSRS Stored Procedure T-SQL Triggers XML Windows
Senior Programmer 10/07 - 05/14
VB.NET Java JavaScript ASP.NET WebServices HTML MS Visio SQL ADO.NET Oracle SQL Server SSIS SSRS Stored Procedure T-SQL Triggers XML XSL Windows

  • Ten plus years of IT experience in the Analysis, Design, Development, Testing and Implementation of business application systems for Health care, Financial, and Telecom Sectors.
  • Strong experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, BI, Client/Server applications.
  • Strong experience in Dimensional Modeling using Star and Snow Flake Schema, Identifying Facts and Dimensions, Physical and logical data modeling
  • Expertise in working with relational databases such as Oracle, SQL Server, MS Access and Teradata.
  • Strong experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica and SSIS as ETL tools on Oracle, SQL Server, Teradata Databases.
  • Experience in Error handling, Debugging, error logging for production support in SSIS.
  • Experienced in Extracting, Transforming and Loading ETL data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.
  • SQL Server 2008/2005/2000 OLAP database development including KPIs, Data mining, working with changing dimensions.
  • Performed Logging and Deployment of various packages in SSIS.
  • Experienced in enhancing and deploying the SSIS Packages from development server to production server.
  • ETL implementation using SQL Server Integration Services SSIS, Reporting Services SSRS
  • Strong ASP.NET, VB.NET knowledge.
  • Developing reports on SSRS, Tableau, and QlikView
  • Extensive experience in developing Stored Procedures, Functions, Views and Triggers, Complex SQL queries using SQL Server, and Oracle PL/SQL.
  • Created stored procedure for generating reports using SQL Server Reporting Services SSRS
  • Implemented parameterized, cascading parameterized, drill-down, drill-through and sub-reports using SSRS.
  • Experienced in administrating the created reports and assigning permission to the valid users for executing the reports.
  • Developed MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.
  • Worked on OLAP Data warehouse, Model, Design, and Implementation.
  • Logical Data Modeling, Data warehouse design concepts, Dimensional Modeling using Star, Snowflake, Normalized and De-normalized Schemas with respect to query and analysis requirements.
  • Experienced in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services SSAS
  • Experienced in Creating and Updating Statistics to improve the SQL Server Performance.
  • Experienced in managing Data and Transaction log files, Files Groups.
  • Experienced in Normalizing and De-normalizing the tables and maintaining Referential Integrity by using Triggers and Primary and Foreign Keys
  • Experience in all phases of Data warehouse development from requirements gathering for the data warehouse to develop the code, Unit Testing and Documenting.
  • Proficient in the Integration of various data sources with multiple relational databases like Oracle11g /Oracle10g/9i, MS SQL Server, Teradata, VSAM files and Flat Files into the staging area, ODS, Data Warehouse and Data Mart.
  • Excellent interpersonal and communication skills, and is experienced in working with senior level managers, business people and developers across multiple disciplines.
  • Good Experience in SAS/BASE, SAS/Access, SAS/ SQL

Top 5 Skills
SkillsProficiencyLast Used
MS Visio
Education and Certifications
Willing to relocate?:Yes
Relocation preference
Any location
Prepared to Travel:Up to 25%
Employment Type:Contract
Security Clearance:No clearance
Citizenship:H-1B Visa