Professional Summary:

• 7 years of IT experience in analysis, design, implementation administration of business intelligence solutions with Microsoft SQL server 2008/2005 in development, testing production environment.
• Extensive experience in Requirement Analysis, Work flow analysis, Design, Development Implementation, Testing Deployment of complete software development life cycle SDLC in field of Desktop Applications, Microsoft web and client/server technologies.
• ETL process experience using DTS, SSIS.

Design of data models and objects including tables, views, user defined functions, triggers and stored procedures for applications.

• Expertise in design and development of SQL Server Integration Services SSIS packages and using various control flow task and data flow transformation.
• Successfully performed SCD transformation and deployed SSIS package with security.
• Experienced in creating various type of reports such as Complex drill down drill through reports, Matrix reports, Sub reports and Charts using SQL Reporting Services SSRS based on Relational
• Excellent command in deploying analysis projects using SQL Server Analysis services.
• Experience in design and scheduling integration packages using SSIS.
• Extensive experience to work with OLAP cube in SSRS.
• Highly proficient in handling parameterized, drill down, drill through and chart reports using SSRS.
• Involved in all phases of SDLC and successfully completed.
• Experiences in developing Stored Procedures, Views, Triggers, XML and Complex Queries on SQL Server 7.0/2005/2008.
• Excellent hands-on experience with data modeling tool like Erwin and strong knowledge of Relational database modeling and Dimensional database modeling concepts with star schema and snowflake schema's design and implementation.
• Expert in T-SQL Programming, query optimization and performance tuning.
• Proficient in using SQL Profiler, creating Execution Plan, Performance Monitor and DBCC Commands.
• Strong experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Extensive of Designing, Developing and deploying various kinds of reports using SSRS using relational and multidimensional data.
• Developed Cubes using SQL Analysis Services SSAS and Experience in Developing and Extending OLAP Cubes, Dimensions and data source view.
• Worked database designer and fluent in all aspects of database development including, design, normalization and optimization.
• Exceptional versatility and adaptability, extremely diligent, strong team player with an ability to take new roles. Excellent communication and strong analytical skills.

Skillset:

MS SQL Server 6.5/7/2000/2005, MS SQL Server Analysis and Reporting services 2005, MS Office 2000/ XP/2003/2007 ,Crystal Reports, DB2, C, C ,T-SQL, ODBC, DTS, MS Access-97/2000/XP, ERWIN Platinum, MS Visio 2003, HTML, XML, ER-Designer, ASP

Projects Summary:

Confidential

MS SQL Server Developer/SSRS/SSIS

Responsibilities:

• Gathered functional requirements and Business requirements and wrote the technical specifications for building the highly efficient system.
• Involved to write complex T-SQL queries and Stored Procedures for generating reports.
• Created, altered, maintained system roles and permissions to users on various database objects.
• Responsible for creation of new database objects like stored procedures, tables, view, triggers, function according business logics. Inserted XML file parameter in to the database tables using services.
• Transferred data from various data sources/business systems including MS Excel, MS Access, Flat Files etc to SQL Server using SSIS/DTS using various features like data conversion etc. Created derived columns from the present columns for the given requirements.
• Worked on SQL Server Integration Services SSIS for data integration from heterogeneous data sources and ETL related operations.
• Defined report layouts and wrote queries for drill down reports and identified and included report parameters using SSRS.
• Developed complex reports and provided to business people for further analysis. Responsible for make changes in application according to business logic.
• Created various simple to complex reports using different Reporting tools like SQL Server Reporting Services SSRS , Crystal Reports and Business Objects.
• Identified various data sources and established connections between source and the target using SSIS based on the required reports.
• Created Table, Clustered, Non-Clustered Indexes and constraints to the frequently used tables in application.
• Wrote complex SQL query using join, sub queries and correlated sub queries to retrieve data from the databases.
• Generated plan for developing processes, automation of maintenance jobs, tuning SQL Server, locks and indexes configurations.
• Worked on linked servers to run distributed queries between SQL server and other data sources like excel using ODBC, OLE DB Drivers.

Environment: MS SQL Server 2005/2008, MS SQL Server 2005 Reporting Service, Business Intelligence and Development System 2005, XML, T-SQL, Erwin 7.2, Windows XP.

Confidential

MS SQL Server Developer/SSRS/SSIS

Responsibilities:

• Gathered functional requirements and Business requirements and wrote the technical specifications for building the Global Enterprise Data warehouse.
• Worked closely with developers, end users in designing and creating the Global Enterprise Data warehouse for management group using SSIS and Erwin.
• Formulated and documented the physical ETL process design based on business requirements and system specifications with strong ETL design skills, including source to target mappings, transformations, lookups, aggregations, expressions.
• Involved in deploying SSIS packages for various environments.
• Created packages in SSIS with error handling as well as created complex SSIS packages using various data transformations like conditional split, fuzzy look up, for each loop, multi cast, column conversion, fuzzy grouping, script components
• Implemented logical and physical database modeling using Erwin tool.
• Designed and implemented complex SSIS package and scheduled.
• Successfully implemented SCD transformation in SSIS and performed security.
• Responsible for the design, development and maintenance of several cubes.
• Designed and implemented data mart, facts, dimensions and OLAP cubes using dimensional modeling standards.
• Performed partitioning of cubes as well as secured cubes with perspective and roles.
• Extensive of Designing, Developing and deploying various kinds of reports using SSRS using relational and multidimensional data.
• Created in dimensional modeling Star Snowflake and creating the Data Source Views DSV and Cubes using the identified Fact and dimension tables.
• Provided technical guidance and support to end-users by developing documentations required.
• Involved in the complete data warehouse development life cycle.
• Designed MDX queries in accessing cubes and hands-on experience in query structuring, performance optimization.
• Assisted users to work with OLAP cubes into SSRS for enterprise reports.
• Audited and enforced database security, code and procedural standards.

Environment: MS SQL Server 2005, MS SQL Server Integration Services 2005,MS SQL Server Report Services 2005, T-SQL, Windows 2003,BIDS, Erwin.