SUMMARY

• Around 7 years of professional IT experience in designing, developing and maintaining Database using MS - SQL server 2005/2008/R2/2012
• Expertise in conceptual, logical and physical designing and development of Data Models, Data Normalization, OLTP and OLAP Database and Data Warehouse
• Experience in coding, testing, deployment, support and maintenance of business applications using MS-SQL Server 2005/2008/R2/2012, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS)
• Expertise in T-SQL in creating and using Views, User Defined Functions, Triggers, Indexes, Stored procedures involving joins, sub-queries from multiple tables and established relationships between the tables using primary and foreign key constraints
• Proven ability in performance tuning and query optimization using indexes, SQL profiler and SQL Enterprise Manager
• Expert in ETL tools like Import/Export wizard and SSIS for transferring Data from different sources to a centralized SQL server
• Excellent in High Level Designing of SSIS Packages to perform ETL from heterogeneous sources such as Excel, CSV, Oracle, flat file, Text Format Data by using multiple transformations provided by SSIS to generate underlying data for the reports and to export cleansed data.
• Expertise in solving run time issues using SSIS error and event handler, precedence constrain, breakpoint, check point and loggings
• Well experienced in using global variables, expressions and functions for reports using SSRS
• Hands on Experience in creating various types of dynamic reports like Tabular, Matrix, Drill-Down, Cascaded parameterized, Chart reports, Sub reports, Ad-Hoc Reports, Cross Tab Reports and Distributed Reports in multiple formats using SSRS based on client requirements
• Proficient in implementing dimensions and fact tables for star /snowflake schemas to process cubes in SSAS 2008/R2/2012
• Have good experience in implementing MDX queries to design OLAP architecture, MOLAP, ROLAP and HOLAP
• Experienced in developing Dashboards, Scorecards using multiple KPI’s by using Microsoft Share point
• Good experience in utilizing Microsoft Power BI tools such as Power View, Power Pivot, Power Query and Power Map to retrieve, analyze and present data in well-designed visualizations
• An Enthusiastic and goal oriented team player with excellent analytical, communication and interpersonal skills and proficient in technical writing and presentations
• Ability to work independently or part of a team to accomplish critical business objectives

TECHNICAL SKILLS

Databases: MS SQL Server 2008/2005/2000/7.0 , Oracle, MS-Access 2000/2003

Programming Languages: T-SQL, C, C++,C#, PL/SQL, XML,HTML, VB .NET, Visual Basic 6.0

Operating Systems: Windows Server 2003, Windows XP/ 2000/ 95/ NT

SQL Server Tools: SQL Server Management Studio (SSMS), Business Intelligence Development Studio (BIDS), SQL Server Enterprise Manager, Query Analyzer, Profiler, Performance Monitor, Database Tuning Wizard, Import & Export, Visual Studio Net

ETL Tools: SQL Server Integration Services (SSIS), Data Transformation Services (DTS)

OLAP/ Reporting Tools: SQL Server Analysis Services (SSAS), SQL Server Reporting services (SSRS), Crystal Reports

PROFESSIONAL EXPERIENCE

Confidential, Providence, RI

MS SQL Developer/SSAS/SSRS/SSIS

Responsibilities:

• Designed SSIS Packages to transfer data from various sources like Text Files, XML (Extensible Markup Language) Files, SQL Server, Excel and Access to SQL Server using SQL Server Data Tools (SSDT BI).
• Developed ETL process using SSIS with Various Control Flow, Data Flow task and Store Procedures for Work Order Validation process.
• Used Lookup transform to create the SSIS package for inserting the new entry from excel master defective parts source spreadsheet to the SQL Server table and update the old data.
• Responsible for the deployment of the reports on the reporting server and scheduled subscription for the windows file share.
• Developed different types of reports like Tabular Reports, Matrix Reports, Cross Tab Reports, Ad hoc reports, Drill through and Drill down reports.
• Involved in writing T-SQL programming to implement Stored Procedures and Functions for different tasks and created Triggers to enforce data and referential integrity.
• Build packages and handled slowly changing dimensions to maintain the historic data.
• Maintained the table performance by following the tuning tips like normalization, creating indexes and collect statistics.
• Responsible for optimizing all indexes, SQL queries, stored procedures to improve the quality of software.
• Created and Configured OLAP Cubes using SQL Server 2012 Analysis Services and Performance tuning and scaling to large numbers of users.

Environment: MS SQL Server 2012, SSIS, SSRS, SSAS, BIDS, Visual Studio 2008, MS Visio 2008, Windows 2007, ASP.Net, C#.

Confidential, Charlotte, NC

MS SQL Server/ Business Intelligence Developer

Responsibilities:

• Built and organized the data warehouses for the all kind of loans that were received from over 150 branches in around 100 cities, North Carolina.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in SQL Server 2008.
• Gathered requirements from the business users, created technical specification documents.
• Data migration (import & export - BCP) from Text to SQL Server.
• Used various transformation tasks as Aggregate, Sort, Data Conversion, Derived Column, Look up Transformation to create ETL packages for data conversion.
• Designed and built Extract Transform Load (ETL) procedures in SQL Server Integration Services
• From one standard database for loans created diversified destinations for auto loans, student loans, home loans using SSIS packages.
• Involved in analyzing, designing, building and testing of OLAP cubes with SSAS 2008.
• Designed and implemented data mart, facts, dimensions and OLAP cubes using dimensional modeling standards in SQL Server 2008 that maintained data. Involved in the complete data warehouse development life cycle. Actively supported business users for change requests.
• Created and managed schema objects such as Tables, Views, Indexes etc. and referential integrity depending on user requirements and converting them into technical specifications.
• Involved in developing E-R diagrams, logical & physical data modeling, development and implementation of the system.
• Created, managed and extensively worked on OLAP Cubes using SSAS
• Created and modified a variety of parameterized, drill down, click through using SSRS 2008.
• Actively involved in creating, developing and deploying complex SSRS reports involving sub reports, matrix/tabular reports, charts and graphs.
• Experience in configuring and deploying SSRS reports into Microsoft Office SharePoint Server.

Environment: MS SQL Server 2008, T-SQL, SSRS 2008, SSIS 2008, SSAS 2008, SSMS, MDX, ASP.NET, VB.NET, MS Share Point and Excel.

Confidential, New York, NY

MS SQL SSIS/SSAS/SSRS

Responsibilities:

• Migrated data from Heterogeneous data Sources and legacy system (DB2, Access, Excel) to centralized SQL Server databases using SQL Server Integration Services (SSIS) to overcome transformation constraints.
• Maintained the physical database by monitoring performance, integrity and optimized SQL queries for maximum efficiency using Database Engine Tuning Advisor.
• Used SQL Server Profiler for auditing and analyzing the events which occurred during a particular time horizon and stored in script. Used “SQL Profiler T-SQL Duration” template for tracking execution tie of T-SQL Statements.
• In SQL Server Integration Service, worked on error handling data and modules that consist of data from banks, transactions, and currencies, and countries
• Worked on the data modeling, especially Star and Snow Flake Schemas. Created OLAP Cube from the integrated data, and implemented OLAP Cubes, Facts, and Dimensions for providing summarized and aggregate views of large sets of data.
• Created multidimensional Cube structures for the analysis of business condition and involved in creating relationships and hierarchies between attributes and measure groups and drill through actions in SSAS.
• Implemented multidimensional cubes with measures, hierarchies, calculations, KPIs, partitions to support analysis needs and fast data retrieval.
• Designed and developed report specifications, created and modified reports; also deployed and maintained those various SSRS Reports in SQL Server 2008.
• Wrote Parameterized Queries for generating Tabular reports and Sub reports using Global variables, Expressions, and Functions; sorted the data, Defined Data sources and Subtotals for the reports using SSRS 2008 and successfully deployed them to the Share Point Server.

Environment: MS SQL Server 2008R2, SQL Server Integrating Services 2008R2, SQL Server Analysis Services 2008R2, SQL Server Reporting Services 2008R2, Visual Studio 2012, Visio, Enterprise Manager, SQL Server Management Studio (SSMS).

Confidential

MS SQL Server Developer

Responsibilities:

• Installed and configured SQL Server7.0 Servers and clients.
• Designed and developed the databases.
• Created a logical design and physical design of the data warehouse using star schema.
• Configured the DTS packages to run in periodic intervals.
• Extensively worked with DTS to load the data from source systems.
• Writing stored procedures and triggers extensively and working very closely with developers, Business
• Analyst and end users to generate various audit reports and troubleshoot their query problems and connectivity problems.
• Created FTP connections, database connections for the sources and targets.
• Maintained security and data integrity of the database.
• Creating Logins and Roles with appropriate permissions.
• Prepared and documented Backup & Restore Plans.

Environment: Windows XP, SQL Server Business Intelligence, SSRS, T-SQL, MS Visual Studio 2005, Report builder.