• Has over 12 years of database Administration & development experience with Oracle and MS SQL Server 2012/2014 in OLTP/OLAP/BI environments.
  • Highly experienced in all aspects of system development life cycle such as requirement analysis, design, development, testing, implementation, deployment & maintenance of projects. Capable of handling responsibilities independently as well as a proactive team member.
  • Excellent knowledge in RDBMS concepts and constructs along with Database Objects creation such as Tables, User Defined Data Types, Indexes, Stored Procedures, Views, User Defined Functions, Cursors and Triggers.
  • Hands on expertise in migrations from various source to various destination.
  • Experience in developing applications using oracle form and reports Forms 5.0 to forms 10g.
  • Extensive experience in writing Transact-SQL (DDL/DML) queries.
  • Design different kind of Data Models and DFD’s (Data Flow Diagrams) for different kind of databases by using ERWIN and Visio 5.0.
  • Expert in Extracting and Transforming data using DTS in SQL Server 2014, SSIS, SQL Server Import Export, Bulk Insert and BCP and XML based customized application (Ice Processor).
  • Experience in creating reports using SSRS (SQL Server Reporting Services)
  • Experience in creating Indexes for faster performance and Views for controlling user access to data.
  • Experience in optimizing performance of various long running queries and stored procedures using SQL Profiler and Database tuning wizard.
  • Experience developing Cubes, Aggregation, KPIs, Measures, Partitioning Cube, Data Mining Models, and deploying and processing objects.
  • Five years’ experience in OLAP cubes, dashboards or scorecards based on business requirements.
  • Experience in BI solutions using Foris5.0, Performance Point and Dashboard concepts as required.
  • Experience creating, populating and maintaining data marts. Thorough knowledge of Features, Structure, Attributes, Hierarchies, Star and Snow Flake Schemas of Data Marts.
  • Five years experienced in Building Cubes and Dimensions with different Architectures and Data Sources for Business Intelligence.
  • Expert in writing T-SQL, working on DTS, SSIS, SSRS, SSAS, Data Cleansing, Data Scrubbing and Data Migration.
  • Expert in Extraction, Transforming and Loading (ETL) data flows using different tools; creating mappings/workflows to extract data from SQL Server and Flat File sources and load into various Business Entities.
  • Experience in creating SSIS packages. Experience in DTS Migration and Metadata Management: Migrating DTS packages to SSIS, Package Migration Wizard, and Storage Management.
  • Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, Logging.
    Self-motivated and able to work independently as well as in a group environment with an active team player attitude.
  • Excellent communication, interpersonal and analytical skills.

Extremely motivated, able to work smoothly even under pressure, meet deadlines in advance, ready to accept new challenges and adapt quickly to new technologies.

Technical skills

RDBMS/DBMS: Microsoft -SQL Server 2014/2012/2008, Oracle 8i & 9i, 10g and 11g, MS Access, mysql.
BI /Data model Tools Microsoft SSIS, OBEE, Pentaho, Tablue, Informetica9.0, Foris BI 2.0, Erwin and Visio.
Languages : SQL, T-SQL, PL/SQL, C++, PHP, Visual Basic, R Language;
Operating Systems: Windows 9x/Windows 2000/Windows NT/ Windows Server 2003/2008/2012 R2 & Linux.
Database Tools SQL Server Management Studio, Oracle Enterprise Manager, SQL Server Profiler, SQL Server, Business Intelligence Development Studio, Team Foundation Server (TFS) Proficient, SQL Server Enterprise Manager, T-SQL, Data Transformation Services (DTS), ODBC, OLAP, MOLAP, ROLAP, OLTP, DBCC, BCP.


Development Tools: Oracle Forms & Reports 6i/9i/10g, Toad, SQL Developer, PL/SQL Developer, Microsoft Office Suite