SUMMARY

• Over 7+ years of IT experience in database design and development in Microsoft SQL Server Suite of Products.
• 6+ years of Strong experience in ETL Development, Business Intelligence Development (SSIS, SSRS, and SSAS) with extensive knowledge in Data Warehousing.
• Experience in data analysis, design and development of databases for business applications in a client/server and data warehouse environments in SQL 2000/2005/2008.
• Expert in all areas of SQL Server development including tables, user functions, views, indexes, Stored Procedures, functions, triggers, clustering, T - SQL, relational database models, data dictionaries, and data integrity.
• Efficient, in creating Sub-Queries and Joins for complex queries involving multiple tables, using Exception Handlers
• Well versed in Normalization/Denormalization techniques for optimum performance in relational and dimensional database environments.
• Experience in RDBMS Concepts, Database Management Systems, Database Physical and Logical design, Data Mapping, Table normalization, Data Modeling, Creating ER Diagrams using tools such as MS Visio and Erwin 7.2.
• Experience in Migrating databases from SQL Server 2000 to SQL Server 2005.
• Expertise in Database Administration operations like Backup, Recovery, Replication and using SQL Profiler and excellent knowledge of DDL and DML in T-SQL.
• Expert in extracting and transforming data using DTS Import/Export, DTS Packages, MS SQL Server Integration Services (SSIS) Packages, Bulk Insert and Utilities like BCP.
• Experience in implementing and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables, Check Points and Expressions for SSIS Packages.
• Extensive experience in creating Jobs, Alerts, SQL Mail Agent, and automating DTS/SSIS Packages.
• Expertise in SQL Server Analysis Services (SSAS) CUBE design, development and deploying.
• Migrated and recreated existing Dimensions and Cubes using Star schema on 2005 Server to achieve the efficiency of SQL Server Analysis Services (SSAS).
• Used MDX to interact with the back end OLAP Services
• Expertise in performing various calculations using DAX in SSAS.
• Experience in creating reports through PROCLARITY. Used PROCLARITY for accessing and analyzing cubes and dimensions.
• Hands on experience in designing complex reports using SQL Server Reporting Services (SSRS) and Crystal Reports.
• Expertise in creating Report Models for building Ad hoc reports using SSRS.
• Experience in generating Sub Reports, Charts, Matrix Reports, Ad hoc Reports, Drill Through and Drill Down reports with Drop down menu option, sorting the data and defining subtotals in using SSRS
• Experience in deploying reports in XML and PDF formats on Web browser
• Experience in Diagnosing and Troubleshooting performance issues in SQL using DMV’s and DTA.
• Strong experience in implementing legacy reporting system migration to the Enterprise Data Warehouse utilizing SSIS and SSRS.
• Excellent knowledge of Scheduling Jobs and Alerts using SQL Server Agent.
• Strong experience in Monitoring and Performance Tuning SQL Server database using tools like SQL Profiler, Index Tuning Wizard, Database Engine Tuning Advisor, Windows Performance Wizard for optimal performance.
• Strong experience with Microsoft Excel and Power BI.
• Expert in working extensively on Angular JS.
• Experienced in AJS TABLES, AJS SQL, AJS HTML, AJS FORMS AND VALIDATIONS.

TECHNICAL SKILLS

Operating System: Windows Server 2003, Windows NT, Windows 95/98/2000 XP/Vista/7/8, Unix.

Languages: C++, Visual Basic 6.0. VB.Net, T-SQL, PL/SQL, .Net, AJS, Oracle

SQL Server Tools: SQL Server Management Studio, Enterprise Manager, Query Analyzer, SQL Profiler, Data Base Engine Tuning Advisor, Visual Studio, Business Intelligence Development Studio, SSIS, SSAS, SSRS, Data Transformation Services. Office 365(Power BI).

RDBMS: SQL Server 2012/2008R 2 2008/2005/2000 , MS-Access, Netezza, Oracle8i/9i

Tools: /Utility: Enterprise Manager, SQL Server Management Studio (SSMS), Database Tuning Advisor, DTS, Analysis Manager, BCP, SQL Profiler and Tableau

Data Modelling: Erwin r7.3/7x/4.0, MS Office Visio 2003/2007, MS-Project 2000

Methodologies: Logical and Physical Database Design, Star Schema, Snow Flake Model, UML, Database Design and Normalization.

PROFESSIONAL EXPERIENCE

Confidential, Richmond, VA

SSIS/SSRS/SSAS Developer

Responsibilities:

• Developed reports using SSRS for both customized and ad-hoc queries.
• Developed different kind of reports such as Drill down, Drill through,Sub Reports,Charts,Matrix reports, Parameterized reports andLinked reports using SSRS
• Debugging the reports and testing them in SSRS.
• Created Advanced Reporting Services Programming Using the Reporting Services Web Service.
• Created Ad-Hoc Reporting with Report Builder and Programming Reporting Services.
• Managed the entire ETL process involving the access, manipulation, analysis, interpretation and presentation of information from both internal and secondary data sources to customers.
• Understanding the business requirements, analyzing source system, source files, setting up the goals for implementing the new client.
• Extracted data from Oracle, DB2, AS400, SQL Server, Flat Files, Excel and XML using SSIS and cleansed the data.
• Created the Logical, Physical model and ETL Mapping Documents based on Business logic.
• Performed Data Sanitization and Dimension modelling making it feasible for the reporting environment.
• Converted data types using Derived Column, Data Conversion Transformation.
• Converted various data files (CSV, XML, COBOL and Legacy Flat Files) based on business logic using Script Task and Script Component.
• Configured the SSIS Packages using Environment Variables for Dynamic Selection of Development and Production Environment.
• Generated 7M Record files using SSIS Script Task and Script component Format the files based on client requested format using.
• Setup the client packages for Accounts, Transactions and Notes based on Templates.
• Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into UL Database and DB2 Billing Systems.
• Created logging, custom logging and error handling packages.
• Created SSIS Packages for Incremental Loading and slowly changing dimensions.
• Created, Modified SSAS Measures, Dimensions Attribute relationships and Hierarchies.
• Dimension and Fact table design and cubes for KPI, Defining hierarchies and rollups.
• Designed SSAS Cubes, Named Calculations for Dimensions.
• Identified Dimensions and Facts, Used MDX to extract data from cubes and Created MDX script for representing Cube Calculation.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.
• Created usage based aggregations in cube to minimize time for query retrieval from client tool Targit.
• Created Development and Production support documents.

Environment: SQL Server 7.0/2008/2005 Enterprise Edition, Visual Studio 2005, DB2, AS400, Microsoft Visual Basic, VBScript, XML, Microsoft Visio, Windows 2003 R2.

Confidential, Dallas, TX

SSIS/SSRS/SSAS Developer

Responsibilities:

• Worked as a developer in creating complex Stored Procedures, Triggers and Functions.
• Managed index statistics, Tables, Views, cursors and optimizing queries using execution plan for tuning the database. Implemented different types of constraints on tables.
• Used Try catch and @@error for exceptional handling.
• Conducted database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler, Data Engine Tuning Advisor and index tuning wizard.
• Designed Star schema (identification of facts, measures and dimensions) and Snowflake schema.
• Developed logical and physical data models using data modeling tools such as Erwin and ER/Studio
• Used Active Directory for Identity management designed to provide strong authentication and authorization for internal and external websites.
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Created Drill-through, Drill-down, Cross Tab Reports and Sub-Report using RDL.
• Used SSRS to deliver complex reports from different data sources such as SQL Database and Cubes.
• Used cascaded parameters to generate a report from two different data sets using SSRS
• Created queries for generating drill down reports in SSRS 2008/2005.
• Formatted the SSRS reports using the Global variables, expressions and Functions.
• Used the SSIS Import/Export, migrated the Heterogeneous Database such as Oracle and Access database, flat files to SQL server 2005.
• Responsible for ETL operation using SQL Server Integration Services (SSIS) 2008/2005 and Worked with users in training and support and also have experience in incremental data loading.
• Managed upgradation of DTS packages to SSIS packages
• Responsible for developing, monitoring and deploying SSIS2008/2005 packages.
• Configured SQL mail agent for sending automatic emails when a SSIS packages is failed or succeed.
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2005 and in adding calculations using MDX.
• Identified and defined Fact relationships in SSAS.
• Involved in developmentof ASP .NET / C# / SQL Server web application.
• Configured replication servers and transactional replication between production & standby server for disaster recovery.
• Configured Snapshot replication for reporting, user acceptance test and development servers.
• Responsible for providing 24X7 Production support, Database and Log Backups & Restoration, Scheduling Backups. Backing up master & system databases and restoring them when necessary.
• Installed and Configured SQL Server Active/Active and Active/Passive clusters. Monitored Scheduled jobs and alerts.
• Implemented and successfully tested Log Shipping in SQL Server 2000 and SQL Server 2005. Experience using REDGATE to compare and synchronize all database objects.

Environment: SQL Server 2008/2005/2000 Enterprise Edition, SSRS, SSIS, SSAS, SQL Server 2005 Partitioning .NET Framework, C#, ASP.NET, ADO.NET, Oracle 9i/ 10g, Visio 2003, MS IIS, Windows 2000/2003 Advance Server, XML, MS Excel, Access and Visual source safe.

Confidential, Boston, MA

SQL Server Developer/ DBA, SSRS/ SSIS/ SSAS Developer

Responsibilities:

• Designed application that collects client transaction volumes for WSS Custody and Sub-Custody products, applies unit costs, and produces a monthly export to the T&SS Costing system (CIIS).
• Created Volume Automation to enable import and maintain unit costs and other reference data, as well as providing summarized MIS reports for administrative/integrity purposes
• Responsible for creating Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints Views, Stored Procedures, Triggers, Rules.
• Created functions and developed procedures to implement application functionality at the database side for performance improvement.
• Created and Modified T-SQL stored procedures/triggers to validate integrity of the data.
• Created DTS and SSIS packages.
• Created packages and scheduled them in SQL Agent jobs to get data from OLTP.
• Created SSIS package to get data from different sources, consolidate and merge into one single source.
• Created ETL package for data conversion using various transformations tasks.
• Created Cubes from which data can be retrieved rapidly by enterprise information consumers.
• Created dash board to show the business performance.
• Created partitions and designed aggregations in Cubes.
• Created perspectives in SSAS and configured security levels for the Cubes.
• Designed KPI’s in SSAS and imported them to Excel.
• Created custom reports which had cascaded parameters using SSRS/SQL Server BI studio.
• Created Ad hoc reports using SSRS.
• Created reports that call Sub reports in SSRS.
• Created datasets for reports using T-SQL and stored procedures
• Responsible for maintaining cubes using SSAS and populate the cubes with the data.
• Responsible for Query optimization and Performance tuning

Environment: SQL Server 2000/2005 Enterprise Edition,.NET Framework, XML, T-SQL,SSIS 2005,SSRS, SSAS,VisualStudio.NET IDE, Windows 2000 Advance Server, Windows 2003 Advance Server, ASP, MS Excel, MS Access. Visual Studio 2005

Confidential, Atlanta, GA

MS SQL Server Developer /SSRS

Responsibilities:

• Responsible for creating Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints Views, Stored Procedures &Triggers
• Maintained data integrity by performing validation checks.
• Actively involved in Normalization & De-normalization of database.
• Was involved in performance tuning of the Database
• Used SQL Profiler and Data Base Engine Tuning Advisor to performance tune the Database.
• Scheduling Jobs and Alerting using SQL Server Agent
• Created User logins at the server level.
• Created logins, roles, and groups to the Window NT and MS SQL Server and maintaining proper security procedures.
• Created SSIS package to get data from different sources, consolidate and merge into one single source.
• Developed custom reports using Microsoft reporting Services.
• Created stored procedures for datasets in SSRS reports to run calculations at database level.
• Wrote expressions in SSRS to provide flexibility to users by providing them with variety of options for seeing the business information in tables/charts etc.
• Created Stepped and Block reports using Microsoft reporting services
• Created Drill Through and Various Cross tabbed reports using Microsoft reporting services.

Environment: SQL Server 2000, Enterprise Manager, UML, MS Project, Windows 2003 Server, .NET, C#, ASP.NET, DTS, Microsoft reporting Services.

Confidential

SQL Developer/Web Developer

Responsibilities:

• Involved in the entire lifecycle of the project, i.e., requirements gathering, design, development, testing and maintenance of the database.
• Setup new SQL Server instances.
• Developed SQL Server objects such as tables, materialized views, clustered and non-clustered indexes, stored procedures, cursors, triggers and constraints.
• Executed query optimization & tuning and also debugging & maintenance of stored procedures.
• Provided database security by using role base authorization on accessing data.
• Retrieved Metadata using System tables and stored procedures.
• Administered the database using SQL Server Enterprise Manager.
• Conducted troubleshooting operations on the production servers.
• Monitored SQL Server jobs, and developed queries to perform database operations.
• Developed user friendly GUI using HTML and ASP.NET 1.0/1.1 in order to display and access data.
• Implemented database programming by using the ADO.NET object Model.

Environment: SQL Server 2000, DTS Package, SQL Server Enterprise Manager, SQL Server Query Analyzer