PROFESSIONAL SUMMARY:

• 8+ years of IT experience in analysis, design, implementation & administration of business intelligence solutions with 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 Data modelling for creation logical and physical design for databases 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 Data 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 data 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 with security.
• Expert in dimensional data 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 with MDX queries and partition of cubes in OLAP.
• Excellent command in deploying analysis projects using SQL Server Analysis services.
• Extensive experience to creating the dashboards and dashboard elements by using SSAS.
• Extensive experience to work with 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 databases.
• Highly proficient in handling parameterized, drill down, drill through and chart reports using SSRS.
• Excellent hands-on experience with data modelling tool like Erwin and strong knowledge of Relational database modelling and Dimensional database modelling concepts with star schema and snowflake schema’s design and implementation.
• Experience in implementing MDM (Master Data Management) using SQLServer 2012
• Experience in implementing DQS(Data Quality Services) using SQLServer 2012
• Exceptional versatility and adaptability, extremely diligent, strong team player with an ability to take new roles. Excellent communication and strong analytical skills.

TECHNICAL SKILLS:

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

Database Tools: BIDS, SS Management Studio, Query Analyzer, System Performance Monitor, Event Viewer, SQL Profiler, Index Tuning Wizard, Upgrade Wizard, Databases Maintenance Plan Wizard, Data Transformation Services (DTS), MSCS, Database Engine Tuning Advisor, Bulk Insert and BCP, Business Intelligence Development Studio, SQL CMD, SQL Server DBA Dashboard, Toad for SQL,Data Quality Services, Master Data 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:

Confidential, Columbus, GA

MS SQL Server BI Developer SSIS/SSAS/SSRS

Responsibilities:

• Involved in gathering requirements and designed the logical modeling and physical modeling for OLTP applications.
• Created database objects such as Tables, Views, StoredProcedures, Triggers, Indexes and functions.
• Implemented complex business logic with Store procedures, User Defined Functions,Views and wrote T-SQL batches with CTE (Common Table Expressions) for recursive operations.
• Wrote DML operations for OLTP systems using T-SQL, Dynamic T-SQL.
• Designed the number of SSIS packages for data 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 the work flow diagrams and wrote the best practices and naming standards.
• Involved in designing ODS and EDW databases.
• Designed the 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 the SSIS Packages to Load the data 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 the SSIS Packages to load the data from ODS to EDW and implemented logging, security and error handing for SSIS Packages.
• Involved in implementation of Master Data Services through Data Quality Services, Designed the SSIS packages move the data between MDS and EDW.
• Designed SSIS Packages to cleanse, remove duplicates and matching data through Data Quality Services.
• Created SSAS Cubes with multiple dimensions, measures and hierarchies based on OLAP reporting needs.
• Wrote MDX to create datasets 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 data 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 the drill-through feature using SSRS.
• Wrote parameterized for generating tabular reports and sub reports using global variables and expressions, functions and defining data 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,Data Quality Services and Master Data Services.

Confidential, Los Angeles, CA

MS SQLServer BI Developer SSIS/SSAS/SSRS

Responsibilities:

• Involved in requirements gathering and design documents for developing the project.
• Wrote complex queries, stored procedures, and functions, views to ensure data integrity, data consistency and to meet the business rules.
• Created SSIS packages to extract data from text files, Teradata, oracle, XML to SQL Server.
• Used various SSIS transformations such as conditional spilt, derived column, look up which were used for data scrubbing, data validation checks before loading the data into Data warehouse.
• Used SCD (Slowly Changing Dimension) transformation to maintain the history of data.
• Created SSIS package to automate maintenance, database back up, update statistics, re-build indexes as well as create error log for event during data load.
• Used event handlers to capture the run time error message in SSIS package.
• Involved in scheduling and administering the 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 data and used MDX to access them.
• Created calculated fields with MDX code to meet additional measures needs that 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 the data, Defining Data sources and Subtotals for the reports using SSRS.
• Developed and implemented procedures to ensure the 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

MS SQLServer BI Developer SSIS/SSRS

Responsibilities:

• Involved in Planning, Defining and Designing data based on business requirements and designed diagrams logical modeling and converted logical design to physical design.
• Developed, implemented and maintained various database objects such as Stored Procedures, Triggers, Functions, Indexes and Views.
• Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data warehouse.
• Developed and maintained ETL packages to extract the data from various sources.
• Involved in debugging and upgrading of several ETL structures as per the requirements.
• Involved in performance tuning of the various ETL packages and stored procedures.
• Created several data validation and data cleansing packages during extraction and load.
• Used various SSIS tasks such as Conditional Split, Derived Column, lookup which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Developed and deployed data transfers packages to the 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 the advanced SSRS Dashboard Reports, tabular, Matrix, Chart reports with 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 that captures errors in the database 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

MS SQLServer BI Developer SSIS/SSRS.

Responsibilities:

• Migrated SQL server databases from 2005 to 2008 by using side-by- side execution.
• Identified slow running query and optimization of stored procedures and tested applications for performance, data 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 data transfer from the source server to the Enterprise Services Warehouse which encompasses server name, database name, accounts, tables and direction of data flow, data dictionary and Metadata using SSIS.
• Extracted data using SSISfrom OLTP to OLAP. Based on the required reports, identified various data sources and established the connections usingSSIS and constructed data source view.
• Created cube structure for the 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 data 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 the data, Defining Data sources and Subtotals for the reports using SSRS.
• Wrote the 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

MS SQLServer Developer

Responsibilities:

• Created SQL Server Reports using SSRS 2005.
• Identified the Data Source and defined them to build the Data 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 the reports.
• Identified and worked with Parameters for parameterized reports in SSRS 2005.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Deployed the generated reports directly on the client’s workstation.
• Responsible for transferring the data using SSIS packages.
• Developed, monitored and deployed SSIS packages.
• Experience in Extracting Data From XML and flat files using SSIS
• Expert in SSIS Deploying and Scheduling.
• Developed, monitored and deployed SSIS packages.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Data Transfers between various servers using BCP and Managing Disk space on NT systems.
• Created calculated fields with MDX code to meet additional measures needs that are calculated from existing measures.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Created calculated fields with MDX code to meet additional measures needs that 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 the models.
• Managed index, statistics and optimizing queries by using execution plan for tuning the database.
• Maintained the physical database 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

Junior SQLServer Developer

Responsibilities:

• Installing and Configuring of SQL Server 2000 on windows 2000/NT OS.
• Created tables, indexes, sequences, constraints, triggers and procedures.
• Managing of databases 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 database objects.
• Used DDL and DML for writing triggers, stored procedures, and data 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 the data between SQL Serverdatabase and files.
• Creation and management of database maintenance plan for various database consistency checks.
• Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.

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