Name: Teena Jose
Visa status: Green card
Skills: SQL Server Developer
Having 5+ years of experience as a SQL SERVER DEVELOPER, and software developer on Object oriented (OOPS) design and development, database programming, Server, Oracle.
SQL Server including BI Developer on SQL 2005/2008
Knowledge of SSMS for T-SQL
Created various database objects (tables, indexes, views, stored procedures and triggers) and implemented referential integrity constraints for enforcing data integrity and business rules
Extensive knowledge of RDBMS and expert in T-SQL.
Extensive experience in designing databases and writing T-SQL, working on DTS, SSIS, SSRS, SSAS, Data Cleansing, Data Scrubbing and Data Migration.
Proficient in designing highly flexible Database Architecture and Data Modeling, Data Mapping, Data Normalization, Optimization and Tuning.
Skilled in storing the data and defining the subtotals for the reports.
Experience in writing complex SQL queries, stored procedures, functions, indexed views and triggers for data consistency and manipulation.
Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like table, matrix and chart report.
Expertise in reviewing requirements for their correctness, completeness, consistency and testability.
Excellent communicational skills, intuitive, problem solving.
Ability to meet deadlines, quickly adapt to different project environments and ability to work with different team across geographical locations.
In addition to excellent technical abilities possesses strong oral and written communications skills, analytical and interpersonal skills.
Working on T-SQL programming, stored procedures, user-defined functions, cursors and views, triggers, indexes and constraints
Helped in integration of the front end with the SQL Server backend.
Adept in creating drill-down, sub-Report, parameterized, cascading parameterized, drill-through, chart, tabular, matrix reports.
Programming Languages .NET, NET and 3.5 and 2.0, ADO.Net, SQL,T-SQL, PL/SQL,
Internet Development ASP.NET and ASP
DBMS Oracle 9i and 10g, SQL-Server 2005
Reporting Tools: SSRS, Crystal Reports 9.0 and 10.0
Design and CASE Tools MS Project
Operating Systems: Windows 10/8/7/Vista/XP/2003/2000
Tools & Technologies: SQL Server Management Studio (SSMS), BI Development Studio (BIDS), Data Transformation Services (DTS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL Profiler
Client: Thomas Consulting Services,Texas August2016 - February 2019
Role: Technical Assistant
Created excel reports on company expenses and revenue
Maintained record book keeping
Created Microsoft Presentations for training
Created step by step training documents
Submitted Weekly status reports on assigned tasks.
Assisted clients with contracts and retained excellent communication for future contracts.
Client: Datamatrix systems,India Sep 2014 to Feb 2016
Role: SQL Developer
Involved heavily with SQL Server stored procedures, triggers, database schema on several web based applications. Created Triggers for an engineering application. Used stored procedures and views for all of the web applications I created.
All of my applications were data driven. 90% of all SQL code for my ASP.NET applications I have written. Hundreds of stored procedures, including one over 1500 lines long, views written without the designer, Scalar and Table functions, as well as insert, update and delete triggers.
Involved in SQL Database administration for entire company during the beginning of my time there.
Helped to other employees with company wide security, performance optimization, backups and created scripts for Jobs and DTS packages for daily, nightly processes.
Involved in SharePoint development, was a part of installation and setup process. Administered Security. Managed the process of connecting to active directory and updating share point from Active Directory.
Client: Syscon Systems Ltd,India January 2012–April, 2014
Role: SQL Developer
Actively participated in gathering Business Requirements and System Specification from system users.
Implementation of MS SQL Server Management studio 2008 to create Complex Stored Procedures using T-SQL to evaluate result for the reports.
Developed different Scripts for the Data analysts for verification of reports.
Transferred data from flat files, Excel spreadsheets and heterogeneous data to and from SQL Server using DTS and also used BCP and Bulk Insert for ETL purposes.
Used Temp Tables to reduce the number of rows for joins, to aggregate data from different sources for different reports.
Modified the current database by removing unwanted columns and also adding proper constraints, rules and defaults to tables.
Strong understanding of finance module and loan center application. Performed dynamic calculations, developed, reviewed, and optimized queries in SQL Server.
Created Indexes on tables for new database to faster retrieval of data for the Reports.
Responsible for deploying reports to Report Manager and Troubleshooting for any error occurring in execution.
Used SSRS to create customized reports and ad hoc reports.
Involved in developing and modifying VB and exporting the reports to web application.
Scheduled the Reports to run on daily and weekly basis in Report Manager and also emailing them to director and analysts to be reviewed in Excel Sheet.
Generated DTS packages to schedule migration for old system data to a new system and verify by making different reports on new system
Converting all existing DTS package old system to new system by adding extra SSIS task.
Develop backup & restore scripts for SQL Server as needed
CLIENT: STERLING SYSTEMS LTD, INDIA JAN 2011 – DEC 2012
ROLE: SOFTWARE DEVELOPER
Developed Web based ERP solution using oracle 9i DB/9i development suite.
Worked with application developers and production teams across functional units to identify business needs and discuss solution options.
Successfully installed and configured SQL Server 2008 on the production server.
Automated the migration of data from Oracle DB to SQL Server 2008 DB using Microsoft SQL Server Migration Assistant (SSMA).
Generated assessment reports to analyze the scope and complexity of the migration projects.
Converted the Oracle DB objects to SQL Server 2008 DB objects like tables, views, and stored procedures.
Designed a new schema design for the data warehouse using dimensional modeling and developed it using the Erwin tool.
Migrated the entire schema as well as data into MS SQL Server 2008 and also validated the migration process to ensure that it has been successfully migrated.
Daily SQL Server database query processing, data maintenance and new stored procedure programming.
Development of new ASP applications for various yearly campaigns.
Conversion of all reporting to Crystal Reports.
Proposed and fully redesigned the corporate website. Redesign included a versatile global navigation, data driven sub-websites and rich multimedia content.
Automations of data transfers between MySQL and SQL-Server systems using ODBC and DTS Packages.
Worked closely with clients to establish requirement specifications and system designs.
Performed regression and system-level testing to verify software quality and function before it was released.
CLIENT: SUBEX SYSTEMS LTD INDIA MAY 2010 - DECEMBER 2010
ROLE: SOFTWARE DEVELOPER
·Built, tested and deployed scalable, highly available and modular software application to configure the tables where through Call Detail Record Data is stored.
·Modified existing scripts to correct errors, adapt to new hardware and improve performance.
·Debugged and modified software components.
·Bachelor of Business Management, Mysore University. Karnataka,India
·Masters of Computer Application, Bharathidasan University, Trichy, India