SUMMARY:

• 8+ years of IT experience in analysis, design, implementation & administration of business intelligence solutions wif Microsoft SQL server 2012/2008/2005/2000 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.
• Extensive experience in Relation modelling for creation logical and physical design for bases and proficient in creating E - R diagram using Erwin andVisio.
• Highly proficient in writing functional specifications and translating business requirements to technical requirements
• Strong concepts of Warehousing, strategies for ETL, identifying metrics, dimensions, hierarchies and design dimensional schema (Star, Snowflake) and implementing slowly changing dimension etc.
• Extensive experiences in developing Stored Procedures, Views, Triggers, XML and Complex Queries on SQL Server 2012/2008/2005/2000 .
• Expert in T-SQL Programming, query optimization and performance tuning.
• Proficient in using SQL Profiler, creating Execution Plan, Performance Monitor and DBCC Commands.
• Highly proficient in design and development of SQL Server Integration Services (SSIS) packages and using various control flow tasks and flow transformations.
• Experienced in designing ETL Packages using SSIS and scheduling integration packages using SQL Server Agent.
• Successfully performed SCD transformation and deployed SSIS package wif security.
• Expert in dimensional modelling, and cube development, partition, aggregation and optimization using SSAS.
• Highly Proficient in designing MDX in accessing cubes and hands-on experience in query structuring, performance optimization.
• Hands on experience work wif MDX queries and partition of cubes in OLAP.
• Excellent command in deploying analysis projects using SQL Server Analysis services.
• Extensive experience to creating teh dashboards and dashboard elements by using SSAS.
• Extensive experience to work wif OLAP cube in SSRS.
• Expertise in creating various type of reports such as Complex drill down & drill through reports, parameterized reports, Matrix reports, Sub reports and Charts using SQL Reporting Services (SSRS) based on Relational and OLAP bases.
• Highly proficient in handling parameterized, drill down, drill through and chart reports using SSRS.
• Excellent hands-on experience wif modelling tool like Erwin and strong noledge of Relational base modelling and Dimensional base modelling concepts wif star schema and snowflake schema’s design and implementation.
• Experience in implementing MDM (Master Management) using SQLServer 2012
• Experience in implementing DQS( Quality Services) using SQLServer 2012
• Exceptional versatility and adaptability, extremely diligent, strong team player wif an ability to take new roles. Excellent communication and strong analytical skills.

TECHNICAL SKILLS:

RDBMS: SQLSERVER 2012/2008/2005/2000, Oracle 10G/9i, Mysql

D Confidential base Tools: BIDS, SS Management Studio, Query Analyzer, System Performance Monitor, Event Viewer, SQL Profiler, Index Tuning Wizard, Upgrade Wizard, D Confidential bases Maintenance Plan Wizard, D Confidential Transformation Services (DTS), MSCS, D Confidential base Engine Tuning Advisor, Bulk Insert and BCP, Business Intelligence Development Studio, SQL CMD, SQL Server DBA Dashboard, Toad for SQL,D Confidential Quality Services, Master D Confidential Services

Programming Languages: SQL,T-SQL,PL\SQL C,C++, VB 6.0, VB.Net,C#.Net, HTML, XML, Java script.

Reporting Tools: SQL Server Reporting Services (SSRS), Crystal Reports 9.0/8.5,Business Objects.

PROFESSIONAL EXPERIENCE:

MS SQL Server BI Developer SSIS,

Confidential, Columbus,GA

Responsibilities:

• Involved in gathering requirements and designed teh logical modeling and physical modeling for OLTP applications.
• Created d Confidential base objects such as Tables, Views, StoredProcedures, Triggers, Indexes and functions.
• Implemented complex business logic wif Store procedures, User Defined Functions,Views and wrote T-SQL batches wif CTE (Common Table Expressions) for recursive operations.
• Wrote DML operations for OLTP systems using T-SQL, Dynamic T-SQL.
• Designed teh number of SSIS packages for d Confidential transfer between flat files,XML, Sales Force, Oracle,MYSQL and SQL Server using different transformations like Lookup, Derived Column, Merge Join, Fuzzy Lookup, Script Component and etc
• Created SSIS Templates for developing SSIS Packages, Implemented SQLServer configurations and error handling in SSIS Packages.
• Involved in deploying SSIS Packages to production from different environments and scheduling and administrating SSIS Packages, wrote best practices for deploying SSIS Package to Production.
• Involved in scheduling SQL Agent Jobs as per business requirements.
• Involved in gathering requirements for EDW and designed teh work flow diagrams and wrote teh best practices and naming standards.
• Involved in designing ODS and EDW d Confidential bases.
• Designed teh Dimensions and facts using Star Schema and slow flake schema.
• Created materialized views as per business requirements and wrote number of stored procedure and dynamic SQL.
• Designed teh SSIS Packages to Load teh d Confidential into ODS from different sources like Oracle,MYSQL, files,XML and Sales force, used various types of control flow tasks like foreachloop,sequence container and script task and used different types of transformations like derived column, lookup, SCD,script component.
• Designed teh SSIS Packages to load teh d Confidential from ODS to EDW and implemented logging, security and error handing for SSIS Packages.
• Involved in implementation of Master D Confidential Services through D Confidential Quality Services, Designed teh SSIS packages move teh d Confidential between MDS and EDW.
• Designed SSIS Packages to cleanse, remove duplicates and matching d Confidential through D Confidential Quality Services.
• Created SSAS Cubes wif multiple dimensions, measures and hierarchies based on OLAP reporting needs.
• Wrote MDX to create d Confidential sets to perform reporting and include interactive drill down reports.
• Created hierarchies, named calculations, relationships and designed KPI by using SSAS
• Involved in administration and scheduling of SSAS jobs.
• Involved in cube partitioning, refresh strategy and planning and dimensional d Confidential modeling in SSAS.
• Developed SQL queries for generating drill down reports in SSRS and Adhoc reports through report builder.
• Developed simple and complex reports supporting multiple, multi-select and cascading parameters, subreports and were all linked to other stage reports using hyperlinks for ease of navigation and to give teh drill-through feature using SSRS.
• Wrote parameterized for generating tabular reports and sub reports using global variables and expressions, functions and defining d Confidential sources for SSRS Reports.
• Created performance reports to mangers to show holding against various measures like time, area and product.
• Involved in scheduling SSRS reports and administrating of SqlServerReportingServer.

Environment: MS SQL Server 2012/2008,SQL Server Integration Services(2012/2008),SQL Server Analysis Services(2008) SQL server Reporting Services(2012/2008), VSS, Microsoft Visual Studio, SQL Server Management Studio, MS Excel, T-SQL,D Confidential Quality Services and Master D Confidential Services.

Confidential, Los Angeles,CA

Responsibilities:

• Involved in requirements gathering and design documents for developing teh project.
• Wrote complex queries, stored procedures, and functions, views to ensure d Confidential integrity, d Confidential consistency and to meet teh business rules.
• Created SSIS packages to extract d Confidential from text files, Terad Confidential, oracle, XML to SQL Server.
• Used various SSIS transformations such as conditional spilt, derived column, look up which were used for d Confidential scrubbing, d Confidential validation checks before loading teh d Confidential into D Confidential warehouse.
• Used SCD (Slowly Changing Dimension) transformation to maintain teh history of d Confidential .
• Created SSIS package to automate maintenance, d Confidential base back up, update statistics, re-build indexes as well as create error log for event during d Confidential load.
• Used event handlers to capture teh run time error message in SSIS package.
• Involved in scheduling and administering teh SSIS packages.
• Migrated DTS Packages (2000) to SSIS Packages (2008).
• Implemented OLAP cubes, Facts and Dimensions for providing summarized and aggregate views of large sets of d Confidential and used MDX to access them.
• Created calculated fields wif MDX code to meet additional measures needs dat are calculated from existing measures.
• Created different types of reports such as cross tab, drill down, conditional and sub reports.
• Designed and implemented Parameterized and Cascading Parameterized reports using SSRS.
• Wrote Parameterized Queries for generating Tabular reports and Sub reports using Global variables, Expressions, Functions, Sorting teh d Confidential, Defining D Confidential sources and Subtotals for teh reports using SSRS.
• Developed and implemented procedures to ensure teh quality, usability and accuracy of reports.
• Scheduled reports using SSRS to generate daily, weekly, monthly, quarterly reports.
• Involved in Debugging and Deploying SSIS packages and reports form development server to production server.

Environment: MS SQL Server 2008,SQL Server Integration Services(2008),SQL Server Analysis Services(2008/2005), SQL server Reporting Services 2008, VSS, Microsoft Visual Studio, SQL Server Management Studio, MS Excel, T-SQL.

Confidential, Los Angeles, CA

Responsibilities:

• Involved in Planning, Defining and Designing d Confidential based on business requirements and designed diagrams logical modeling and converted logical design to physical design.
• Developed, implemented and maintained various d Confidential base objects such as Stored Procedures, Triggers, Functions, Indexes and Views.
• Used SSIS and T-SQL stored procedures to transfer d Confidential from OLTP d Confidential bases to staging area and finally transfer into d Confidential warehouse.
• Developed and maintained ETL packages to extract teh d Confidential from various sources.
• Involved in debugging and upgrading of several ETL structures as per teh requirements.
• Involved in performance tuning of teh various ETL packages and stored procedures.
• Created several d Confidential validation and d Confidential cleansing packages during extraction and load.
• Used various SSIS tasks such as Conditional Split, Derived Column, lookup which were used for D Confidential Scrubbing, d Confidential validation checks during Staging, before loading teh d Confidential into teh D Confidential warehouse.
• Developed and deployed d Confidential transfers packages to teh appropriate destinations using SSIS.
• Involved in creating Jobs, Alerts, SQL Mail Agent, and schedule SSIS Packages.
• Applied XML configurations, logging and error handling for SSIS packages.
• Perform UNIT TESTING at various levels of ETL packages.
• Created teh advanced SSRS Dashboard Reports, tabular, Matrix, Chart reports wif advance features using SSRS.
• Developed SQL queries for generating drill down reports in SSRS and Adhoc reports through report builder.
• Designed and implemented Parameterized and Cascading Parameterized reports using SSRS.
• Configure and maintain Report Manager and Report Server for SSRS.
• Deploying and accessing of reports involved in complete life cycle of project in making an application dat captures errors in teh d Confidential base and through report, we can see detailed report of error information.

Environment: MS SQL Server 2005/2008,, SQL Server Integration Services, SQLServer Reporting Services,VSS, Microsoft Visual Studio, SQL Server Management Studio, MS Excel, T-SQL,Erwin.

Confidential, Richmond, VA

Responsibilities:

• Identified slow running query and optimization of stored procedures and tested applications for performance, d Confidential integrity using SQL Profiler.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules.
• Designed high levelETL architecture for overall d Confidential transfer from teh source server to teh Enterprise Services Warehouse which encompasses server name, d Confidential base name, accounts, tables and direction of d Confidential flow, d Confidential dictionary and Metad Confidential using SSIS.
• Extracted d Confidential using SSISfrom OLTP to OLAP. Based on teh required reports, identified various d Confidential sources and established teh connections usingSSIS and constructed d Confidential source view.
• Created cube structure for teh analysis of business condition and for creation of report using SSAS.
• Scheduled reports and exported in PDF, Word and Excel format.
• Worked on error handling a module consisting of d Confidential from bank, transactions, currencies, countries, master, static etc.
• Designed, deployed, and maintained various SSRS Reports in SQL Server.
• Designed and implemented Parameterized and Cascading Parameterized reports using SSRS.
• Wrote Parameterized Queries for generating Tabular reports and Sub reports using Global variables, Expressions, Functions, Sorting teh d Confidential, Defining D Confidential sources and Subtotals for teh reports using SSRS.
• Wrote teh conditional expressions in SSRS by using C#.Net

Environment: MS SQL Server 2005/2008, SQL Server Integration Services 2008/2005,SQL Server Analysis Services (2008/2005),SQL Server Reporting Services 2005/2008,C#.NET,T-SQL, Windows XP, MS Excel and SQL profiler.

Confidential,

Responsibilities:

• Created SQL Server Reports using SSRS 2005.
• Identified teh D Confidential Source and defined them to build teh D Confidential Source Views.
• Developed Query for generating drill down reports in SSRS 2005.
• Designed and implemented stylish report layouts.
• Expert in calculating measures and dimension members using multi dimensional expression (MDX), mathematical formulas and user-defined functions.
• Generated Reports using Global Variables, Expressions and Functions for teh reports.
• Identified and worked wif Parameters for parameterized reports in SSRS 2005.
• Responsible for scheduling teh subscription reports wif teh subscription report wizard.
• Deployed teh generated reports directly on teh client’s workstation.
• Responsible for transferring teh d Confidential using SSIS packages.
• Developed, monitored and deployed SSIS packages.
• Experience in Extracting D Confidential From XML and flat files using SSIS
• Expert in SSIS Deploying and Scheduling.
• Developed, monitored and deployed SSIS packages.
• Created complex SSAS cubes wif multiple fact measures groups, and multiple dimension hierarchies based on teh OLAP reporting needs.
• D Confidential Transfers between various servers using BCP and Managing Disk space on NT systems.
• Created calculated fields wif MDX code to meet additional measures needs dat are calculated from existing measures.
• Created complex SSAS cubes wif multiple fact measures groups, and multiple dimension hierarchies based on teh OLAP reporting needs.
• Created calculated fields wif MDX code to meet additional measures needs dat are calculated from existing measures.
• Analyzed reports and fixed bugs in stored procedures.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Implemented different types of constraints on tables.
• Designed and applied entity and attributes description and definition for teh models.
• Managed index, statistics and optimizing queries by using execution plan for tuning teh d Confidential base.
• Maintained teh physical d Confidential base bymonitoring performance, integrityand optimize SQL queries for maximum efficiency using SQL Profiler.
• Used Visual SourceSafe for source control and versioning

Environment: MS SQL Server 2000/2005 Enterprise Edition, ASP.Net, SSIS, SSAS, SSRSErwin 4.1, Windows Server 2003.

Confidential,

Responsibilities:

• Installing and Configuring of SQL Server 2000 on windows 2000/NT OS.
• Created tables, indexes, sequences, constraints, triggers and procedures.
• Managing of d Confidential bases objects like Tables, views, indexes etc.
• Implementing Backups and restoring when necessary.
• Used BCP utility to publish table output to text files.
• Managing of users including creation/alteration, grant of system/db roles and permission on various d Confidential base objects.
• Used DDL and DML for writing triggers, stored procedures, and d Confidential manipulation.
• Extensively used joins and sub queries to simplify complex queries involving multiple tables.
• Developed scripts for maintaining administration tasks.
• Developed DTS Packages to transfer teh d Confidential between SQL Serverd Confidential base and files.
• Creation and management of d Confidential base maintenance plan for various d Confidential base consistency checks.
• Used SQL Profiler to monitor teh server performance, debug T-SQL and slow running queries.

Environment: MS SQL Server 2000, DTS, and Windows NT/XP, Crystal Reports 7.0.