Description
Professional Summary: * 4+years of experience in Information Technology providing professional service as SQL developer in planning, analysis, design, development, enhancement, testing and maintenance using MS SQL database. * Experience in designing and deploying NoSql like MonogoDB, Marklogic database servers. * Extract the data by connect different sources like SQL server, Oracle, Mysql etc to Marklogic. * Experience in Microsoft Business Intelligence technologies like MS SQL Server Integration Services (SSIS), Dynamics AX, MS SQL * Server Analysis Services (SSAS) and MS SQL Server Reporting Services (SSRS). * Experience in integration of various data sources like SQL Server, Oracle, Access DB, DB2 and Flat File, Excel File. * Experience in packages to extract, transform and load data (ETL) using SSIS, designed packages which are utilizedfor tasks and transformations Data Conversion and Pivot tables. * Involved in system study, design, development, and implementation stages of various projects until the maintenance level. * Grouping Sets, Merge/Multiple Table Insert/Loading and logging error in a single statement/Grouping sets/Analytical Functions. * Extensive experience in writing Procedures, Functions, Database Triggers and SQL queries. * Experience in Data Migration usingSQL scripts. * Extensive experience in Analyzing, Designing, Testing, Documenting Database systems and Business applications. * Good knowledge of Data Modeling using Star Schema, Snowflake Schema, and Entity-Relationship Diagrams. * Good experience in performance tuning of SQL and PLSQL code. * Used Execution plan and Query hints in performance tuning the code. * Used RDBMS analysis to identify effective solutions for business control objectives and technical design. * Involved in administrative roles like installing/configuring databases, creating databases, partitioning, creating indexes and migration of databases. * Experience on different data modeling techniques using Star Schema, Snowflake Schema, and Entity-Relationship Diagrams. * Good knowledge in Relational Database Design and Development using MS SQL Server 2005/2008/2012/2014/SQL Express Oracle 10g, 11g My SQL. * Used new features of oracle 11g like INTERVAL, COMPOSITE and REFERENCE partitioning techniques. * Assisted in various configuration and support operations which included Logical/Physical Backup methods. * Assisted in performance testing of databases, creating indexes, creation and migration of databases. * Strong communication and team skills with proven ability to work on projects with minimum guidance and specifications. * Extensive experience in data collection with calculations from different sources to MS Access Database.
Accomplishments
Highlights:
Keywords
