SUMMARY

• A result - driven IT Professional with extensive 3 years hands on experience in developing Microsoft Business Intelligence (MSBI) using SqlServer 2005/2008.
• Experience in developing Table, Sub Reports, Matrix Reports, Drill down reports, and Drill through reports using Sql Server Reporting Services (SSRS).
• Creating solutions, projects and packages and managing them.
• Involved in various tasks such as Control Flow(Execute Sql task, For each loop Containers, Data Flow task, File System etc) and transformations such as Aggregate, Sort, Lookup, Fuzzy Lookup, Merge join, Multicast, Conditional split, Derived column etc.
• Involved in Logging and Exception handling.
• Experience in development of SQL Queries, Stored Procedures, Functions, Views and Jobs in SQL Server.
• Knowledge on Oracle Database Administration activities such as Upgrades, Migrations, Patches, Cloning, Backup & Recovery, Performance Tuning, capacity planning and documentation.
• Extensive knowledge on database administration for Oracle 9i, 10g & 11g with experience within very large scale database environment and mission critical OLTP and OLAP systems.
• Fulfilled DBA daily activities including user management (creating users, synonyms, privileges, roles, quotas, table, index, sequence etc.), space management, and monitoring
• Knowledge in installing, configuring and managing Oracle 11g R2 RAC, Oracle 10g RAC
• Knowledge in regular DBA activities such as Upgrades, Patches, Cloning, Backups and Recovery Manager, Performance Tuning, Capacity Planning and documentation.
• Extensive knowledge in performance and tuning of OLTP and Data warehouse applications.
• Data transferring with Export and Import.
• Database backup concepts and options such as user-managed backup, RMAN-managed backup, cold and hot backup, full back up, incremental backup.
• Refresh/Cloning of Database and applications for development and testing purpose.
• Dealing with database security and auditing.
• Excellent communication, interpersonal and strong analytical skills, Documentation & Problem-solving skills with customer service oriented attitude. A very good team player, self-motivated, dedicated in any work environment.
• Dedicated team player with superior technical analysis skills.
• Ability to learn and upgrade to the latest technologies according to the organizational needs.
• Initiative to complete projects and ability to meet deadlines and work in fast-paced environment.
• Quick and eager in learning new skills and positive team player.
• Excellent academic record.
• Capable of working as individual as well as part of team.

TECHNICAL SKILLS

Programming: C, C++

Database: DBMS, RDBMS, PL/SQL,SQL Server 2008, Oracle 10g,11g

Operating Systems: Windows XP, Windows 7, Windows 8, Unix, Linux

MS Office: MS Access, Word, Power Point and Excel

Web Programming: Html, Xml, Basic PHP

BI Tools: SSIS, SSRS, SSAS, Tableau, Pentaho

PROFESSIONAL EXPERIENCE

Research Assistant (SSIS,SSRS)

Confidential

Responsibilities:

• Analyzing and Understanding the business requirements.
• Data Extraction from multiple sources like flat files, Excel and SQL server and Transforming, Cleansing, Validating Data and Loading into final Destination.
• Tasks such as Control Flow (Execute Sql task, for each loop Containers, Data Flow task, File System etc) and transformations such as Aggregate, Sort, Lookup, Fuzzy Lookup, Merge join, Multicast, Conditional split, Derived column etc.
• Created and manipulated many Packages.
• Implemented ETL and business logic with various tasks and transformations.
• Populating the Data from different source systems into DW using SSIS.
• Creating SSRS reports from the data ware house and providing drill through capability from excel reports to SSRS report.
• Performed data reconciliation across various source systems.
• Responsible For SSIS Deployment.
• Build and Deployed packages to SQL server and Scheduling Packages for Intra Day and End of Day execution.

Junior MSBI Developer(Intern)

Confidential

Responsibilities:

• Creation of Dimensions, Facts, Cubes based on Technical specification document.
• Creation of Calculated Measures, Calculated Members, Dimension Security, Cell Security, KPI, Actions, Partitions, Aggregations in SQL Server Analysis Services using Multi-Dimensional Expression (MDX)
• Designed packages Using Control Flow Tasks like For Loop Container, For Each Loop Container, Sequential Container, Execute SQL Task and Data Flow Task.
• Implemented ETL and business logic with various tasks and transformations.
• As per requirements developed the reports in the form of Matrix, Table and Chart using SQL Server 2008 Reporting Services.
• Designed Different Types of reports like Drill Down, Sub Reports and Parameterized Reports.
• Involved in various tasks such as Control Flow(Execute Sql task, For each loop Containers, Data Flow task, File System etc) and transformations such as Aggregate, Sort, Lookup, Fuzzy Lookup, Merge join, Multicast, Conditional split, Derived column etc.

Junior SSIS Developer

Confidential

Responsibilities:

• Extracting data from multiple sources like flat files, Excel and SQL server and Transforming, Cleansing, Validating Data and Loading into final Destination.
• Extracted data from sources and transformed the data using different transformations like Data Conversion, Derived Columns, Look up, Conditional Split, Aggregate, Union all, Merge Join and Multi Cast Transformations. .
• Maintained Log Information in SQL table to tracking Errors and recording package execution status.
• Designed and developing SSIS packages using different transformations like Conditional Split, Multicast, Sort, Look Up, Union-All, Merge, Merge Join and Derived Column.
• Build and Deployed packages to SQL server and Scheduling Packages for Intra Day and End of Day execution.