SUMMARY:

• Experienced SQL Programmer and Data Analyst.
• Extensive experience in Data Mining, Data Warehousing, Big Data, Data Integration and Reporting Services.
• Hands on experience in MicroStrategy platform
• Extensive knowledge in SDLC
• Strong foundation in software engineering and programming principles across multiple platforms.
• Working knowledge in object - oriented programming; developing, testing and debugging code;
• Working knowledge in C# .Net, ASP.Net, MVC, C, C++, SQL, SSIS, SSRS, SSAS, Java Script, Lisp, COBOL, HTML, CSS, Linux, Unix, Windows.
• Exposure to Oracle, Java, VB.Net, PHP, XML.
• Experienced with Microsoft Office tools
• Could work efficiently with embedded technologies and development of applications programs
• Can manage to work on various operating systems.
• Quickly learn and master new technologies; successful working in both team and self-directed settings
• Excellent mathematical and problem solving skills, and ability to tackle any urgent situations
• Good grasping capacity and problem solving capacity

TECHNICAL SKILLS:

• C#.Net
• ASP.Net
• C
• C++
• Java
• PHP
• . Net
• HTML
• JavaScript
• Lisp
• CSS
• SQL
• MySQL
• COBOL
• Windows
• Linux
• Unix.

PROFESSIONAL EXPERIENCE:

Confidential

Senior .Net/ SQL Developer

• Perform Data Warehousing required for critical data analysis resulting in the discovery of over 200 providers who have not had any members for over 5 years but were still contracted and being paid by the Applecare, and thus saving the company a significant amount of money
• Hand on experience in MicroStrategy in supporting interactive dashboards, highly formatted reports, ad hoc queries and automated report distribution.
• Develop a program to automate compliance processes, which resulted in saving time, effort and maintaining data integrity.
• Develop Various SSIS Packages to achieve data migration between AppleCare and Essette (a healthcare case management application)
• Design and develop various SSIS packages to perform complex ETL processes
• Write various complex SQL Stored Procedures to generate data from MEDMC
• Troubleshoot various import errors
• Integrate data between AppleCare and Essette to accommodate the transition from Essette 3.3 to Essette 3.9
• Document data integration process and mapping
• Develop SSIS packages to achieve health plan code conversion
• Automate various SSIS packages
• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server and Flat files.
• Used Configuration Files in SSIS to ease the process of moving the packages across servers.
• Designed packages which utilized tasks and transformations such as Execute SQL Task, Data Flow Task, Sequence Container, For Each Loop Container, Lookup, Aggregate and Derived Column.
• Developed packages in SSIS with error handling.

Confidential

Senior .Net/SQL Developer

• Implemented complex Data Warehousing required for critical data analysis
• Develop employee & project databases in SQL
• Develop web applications using ASP .Net and Javascript
• Develop Windows forms applications using C# .Net
• Database management using SSMS
• Generate various reports using SSRS and SSIS
• Update and modify already existing code
• Troubleshoot various code errors
• Created packages and scheduled them in SQL Agent jobs to get data from OLTP.
• Modifying SSIS packages for business logic enhancements. Writing/modifying C# scripts for performance files and data loads.
• Created SSIS Packages using Fuzzy Lookup, Derived Columns, Pivot Transformation, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Scheduled the SSIS package services to run at different intervals to fetch the data and for transferring the data into other database.
• Created Package Configuration files to support the SSIS packages in different environments.
• Designed and implemented Parameterized and cascading parameterized reports using SSRS.
• Deploying and scheduling reports using SSRS to generate daily, weekly, monthly and quarterly reports run periodically.
• Modify SQL code in applications to eliminate SQL injection attacks and cross-browser scripting hacks.

Confidential

.Net/SQL Lead Developer

• Implemented complex Data Warehousing required for critical data analysis
• Hands on experience in BI tools
• Develop Web applications in ASP .Net
• Develop code in SQL Server 2008 & 2012
• Database management
• Develop an inventory management system
• Develop in HTML and CSS
• Develop in JavaScript.
• Update and modify already existing code.
• Troubleshoot various code errors
• Build, Published and Scheduled SSRS Reports for both Dev and Test Environment.
• Database backups and troubleshooting production databases and cube sync processing issues and SSAS issues.
• Performed system data analysis. Created, modified, documented, and enhanced data specifications included identifying and mapping data elements from source systems into staging areas, the data warehouse, data marts, and OLAP cubes.

Confidential, TORRANCE, CA

.Net/SQL Developer

• Develop code in C# .Net
• Develop code in SQL Server 2008
• Database management
• Develop an inventory management system
• Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
• High Level Design of ETL DTS Package for integrating data from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data).
• Developed a multi-dimensional database (MDDB) and OLAP cube using SQL Server 2000 that stored and maintained the data.
• Designed reports, Graphs and deployed reports to web applications using SSRS.
• Developed in HTML and CSS
• Troubleshoot various code errors

Confidential, LOS ANGELES, CA

C++ Programmer

• Debug and test already existing C++ code to assess various errors.
• Revise C++ code in UNIX environment to troubleshoot and correct errors.
• Write new C++ code to achieve various functions in relations to the CSULA general database

Confidential, OMAHA, NE

Software Engineer

• Modify and revise department's website.
• Debug and test department's website for various errors and troubleshoot them.
• Implement Java Script and CSS into department's website.
• Modify and manage department's database.

Confidential, OMAHA, NE

IT ASSISTANT

• Assist various departments across campus with general IT problems.
• Install new equipment in various departments and setup network.
• Modify and revise several university departments websites.
• Troubleshoot various network problems across campus.
• Troubleshoot various website errors for various departments.