Data Base Developer (Intern)
Bizprac octal8 pty ltd
Working as a data base developer (Microsoft Sql server) for Bizprac estimating software
Installing, Upgrading and Configuring Microsoft SQL Server 2012.
Data Base migration from firebird inter base database to Microsoft sql server DB
Design of logical and physical database
Developing T-SQL stored procedures and triggers.
Creation of tables, views, sequences, index, constraints
Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS Client requirement Analysis, Physical, Logical design, development (using SQL Server Enterprise manager), Resource Planning, Coding, Debugging, Testing, Deployment, Support and Maintenance of business applications using SQL Server 2008/2005/2000, SSIS, SSAS and SSRS 2005/2008.
Creation of complex SQL queries involving multiple tables inner and outer joins.
Expert in creating various type of reports such as Complex drill down & drill through reports, Matrix reports, Sub reports and Charts using SQL Server Reporting Services (SSRS) based on Relational and OLAP databases.
Data base backup, restore.
Absolute knowledge of software development life cycle, database design, RDBMS, data warehousing and data modelling concepts.
Good understanding of Financial Domain.