- Overall 10+ years of experience developing BI Applications using Cognos, Sql Server, Oracle, Argos, SSAS,SSIS,SSRS, MS Access and MongoDB, Denodo.
- Experienced in Writing Stored Procedures, Functions, Views, Indexes, Triggers, Query optimization and Performance tuning, Creating OLAP Cubes and Data Visualizations using Dashboards.
- Excellent Data Warehousing skills, Star and Snowflake Design, Data Modeling and Normalization
- Knowledge of SDLC, Agile Scrum, Waterfall development methodologies and Project Management.
- Expert in OOAD(OOPs), ERDs, DFDs, Use Cases, Class Diagrams, State Diagrams, Sequence Diagrams, Activity Diagrams.
- Knowledge of Salesforce, PeopleSoft, Puredata(Netezza), Azure, MySql, Sybase, Banner Systems and Developer 2000.
- Experience in working on Windows, Linux, Unix and Mac Operating System environments.
- Creating and updating .Net Applications for the Engineering Division at Department of Public Works - Los Angeles County.
- Creating and updating Cognos Framework Manager Models for use in reports by Users.
- Helping the customer with Cognos migration from 8.4 to 11.
- Worked on Flood Fund Budget project for managing the Budget Fiscal and the Confidential Infrastructure Project using C# ASP.Net
- Created Dashboards for the Road Maintenance Division and Reports for the Aviation Division.
- Researching on creating models in Framework Manager using Denodo for use in Cognos.
- Maintaining $6Billion Campaign data with Annual Fundraising of $800million by creating Analytical Reports and Dashboard Visualizations.
- Building Datawarehouse tables, Creating Functions and Stored Procedures in SQL and Oracle to Populate/Load the aggregated data into the Warehouse; Writing complex PL/SQL, T-SQL Queries, Creating and modifying reports using Cognos, Cognos Administration, Scheduling jobs, Managing User Groups and Roles, Creating DataStores, and Creating maps using Informatica.
- Developed an Event Bursting application using Cognos, VBscript, Batch Files, Triggers, Sqr and PeopleSoft interface.
- Worked on Salesforce implementation of our CRM system. Agile team environment with daily briefs with Operations and Technical teams. Made sure the data flow is correct and consistent from Salesforce into our Datawarehouse and into the reports.
- Creating and modifying reports using SQL and Argos, Troubleshooting, Creating and Maintaining Banner accounts, Patches, System maintenance, Processing Common Applications and Transcripts.
- Creating and modifying Reports using Cognos Reports on Banner system; Creating packages using Framework Manager; Analyzing, designing, development and maintenance of software applications for Institutional Research and Surveys; Consulting users in the areas of data retrieval and analysis; Error message interpretation and analysis.
- Developed a Student Report Generator application called MyStudents using ASP,SQL and ASP.net for retrieving information from Student Information System.