Education

B.S. in Computer Science

Technical Skills

Databases: MS Access 2000 - 2010, SQL Server 2008R2., MySQL
Languages: Visual Basic, HTML, ASP.Net, CSS, C#, Java
Software: Visual Studio 2010, Crystal Report Writer XI, SSRS, SSIS, SSAS, Pentaho

Professional Summary

IT professional with over 5 years experience. Highlights:

• Most recent experience as a Business Analyst and reports developer.
• Extensive experience writing complex stored procedures, functions and views.
• Strong working knowledge of SQL server 2005/2008/2008R2.
• Experience in integrating third party API in a web based application.
• Ability to work independently and as part of a team in a dynamic work environment.
• Actively participated in the software development projects in all phases from gathering requirements to deployment.
• Reviewed code of the team members and mentored them on using best practices.
• Experience in developing software in C#,Net using ASP.Net.
• Created ETL packages and developed reports in SSRS.
• Actively participated in SCRUM meetings to discuss the projects.

Experience

Confidential, Moorpark, CA 02/2012 - Present
Business Systems Analyst IV

Confidential, is a leading assets management firm created to address the dislocations in the U.S. mortgage market.

• Develop conceptual relational and dimensional data models.
• Imported data files using SSIS packages from various sources.
• Assist in migration and integration of data and processes using SSIS, from different databases.
• Created SSIS script transformations for data validation using C#.
• Work closely with other teams of application developers, system administrators and central operations management.
• Develop individual department reports detailing key performance indicators (KPI).
• Develop parameterized, drill down, linked and sub reports in SSRS.
• Develop stored procedures and functions for SSRS reports.
• Write dynamic SQL statements, CTE, ranking queries.
• Troubleshoot slow reports.

SQL Master's Program 06/2011 - 12/2011
Confidential,

The SetFocus SQL Server Master's Program is an intensive, hands - on, project oriented program where participants gain knowledge and valuable experience putting the SQL Server skill set to use in a simulated work environment.

• Created numerous simple to complex queries involving self joins, correlated sub queries, CTE's and XML techniques for diverse business requirements. Tuned and optimized queries by altering database design, analyzing different query options, and indexing strategies.
• As part of a team, analyzed the business requirements and systematically designed a database for an online-movie (DVD/Blu- Ray) rental company. Employed best practices in creating a complete schema including tables, relationships, stored procedures, views, clustered and non-clustered indexes and triggers, and implemented the import and export of data using XML and SSIS.
• As part of a team, created various reports according to the business requirements for the movie rental company. Individually authored, installed, deployed and managed reports using SSRS for a library database.
• Individually designed a bank application according to business requirements, and implemented robust stored procedures, functions, and triggers to implement required functionalities.
• Created an ETL solution that reads Product, Vendor, and Order data from .CSV files on a network share into a SQL Server database. The solution also validated incoming data and performed notifications when jobs complete. The order data thus loaded into SQL Server was used to generate reports using the new SSRS 2008 reporting functionality (including the Tablix control). The reports were set up for automatic delivery based on standard report subscriptions.

Confidential, Simi Valley, CA 04/2011 - 02/2012
SQL Developer

Rapattoni provides software services to Real Estate industry. Member of data management department.

• Gather and analyze business requirements to develop and modify stored procedures, triggers, views, and functions.
• Used SQL profiler to debug application issues.
• Work with managers and developers to optimize query performance from SQL Server 2008.
• Work with different clients' databases to change schema and update or extract data.
• Restore and backup databases.
• Map and import data from different real estate vendors.
• Participate in the Scrum meetings.
• Writing Coded Web Tests to check various functionalities in the clients' websites.

Confidential, Buena Park, CA 11/2010 - 04/2011
SQL/MS Access Developer (contract)

Confidential, provides custom software solutions for the money exchange and money transfer industry.

• Performed high complexity analysis, design, development and unit testing of software applications.
• Resolved defects encountered during various testing cycles.
• Reviewed gathered requirements.
• Analyzed and modified applications to ensure that customer specifications were satisfied.
• Developed and maintained existing application and created new user interfaces using MS Access.
• Converted Access database into SQL.
• Wrote complex stored procedures for data retrieval programming accounting principles.
• Developed and modified financial, accounting and sales reports using BIDS.

Confidential, Visalia, CA 05/2010 - 11/2010
MS Access Programmer (contract)

Performed programming, modification, maintenance, and documentation to improve overall application, database, and reporting.

• Optimized SQL queries and data relationships.
• Created a multi-user database that allows sending of customized email messages from the application.
• Imported data from complex text files into the tables.
• Created interface scripts with mainframe application using Jolly Giant Software.
• Complete familiarity with MS Access Object hierarchy and VBA programming in multi-user environment.
• Created forms in MS Access with SQL Server backend using ODBC.
• Programmed an application to extract data from a secured website into MS Access Database.

Confidential, Fresno, CA 08/2010 - 10/2010
Report Analyst, part-time (contract)

Non-profit agency providing services to disabled individuals.

• Created various user interfaces for data entry purposes and designing reports.
• Created front end user interfaces in Access 2007 with AS400 backend using ODBC.
• Worked with users to understand their reporting needs.
• Used VS 2010 to write a file copy program.
• Modified Crystal Reports linked with SQL Server 2005.
• Created parameterized tabular reports using SSRS and integrated with VS 2010.
• Automated the process of data extraction from AS400.
• Developed SSIS packages to transfer data from Excel, text and XML files.

Confidential, Selma, CA 10/2006 - 05/2009
Database Support Analyst

• Provided phone support to assigned clientele utilizing the proprietary software.
• Managed and maintained assigned clientele and delivered a high degree of customer service that resulted in customer satisfaction and client retention.
• Researched and responded to all internal and external communications related to software troubleshooting in a timely manner.
• Provided software training through web conferencing.
• Main point of contact for report writing and creating ad hoc queries.
• Modified and developed functions, stored procedures in SQL Server 2005.
• Designed reports using SSRS and Crystal Reports, utilized group sorting, created formulas for calculations and combined sub report.