SUMMARY

• Over 7+ Years of IT experience which includes Data Analysis, Design, and Development & Support of MS SQL Server 2008/2005/2000 in development, data warehouse, and production environments on various business domains like Health, Financial, Banking and Automobile.
• Hands on experience in creating database objects such as Tables, Constraints, Indexes, Views, Indexed Views, Stored Procedures, Triggers and Cursors.
• Good experience in Query Optimization and Performance Tuning.
• Managed reports in SSRS via Management Studio and also Report Manager by setting up permissions and RDL files.
• Used SSRS to Ad - hoc, Cross-Tab, Drill-down and Sub-Report, customized Reports, on-demand reports and involved in analyzing multi-dimensional reports in SSRS.
• Created many sub-reports to produce multiple results in a single view for analysis.
• Experienced in creating and deploying SSIS (ETL process) packages using various Transformations such as Slowly Changing Dimension, Multicast, Merge Join, Lookup, Fuzzy Lookup, Conditional Split, Aggregate, Derived Column, and Data Conversion Transformations.
• Extensive knowledge of Installation, Configuration and Maintenance of SQL Server/BI Suite (2005/2008), usage of SQLCMD utilities, Creation and Management of Logins, Users, Schemas and Permissions, Transaction Logs, DBCC commands, Automation of SQL Server using Operators, Jobs and Alerts, Database Backups, Restoration and Recovery, High availability of Database using Clustering, Standby Servers, Log Shipping and Database Mirroring and Replication and Bulk Copy (BCP).
• Build ETL processes utilizing SSIS and DTS, including FTP data from remote location, transform it, mart it to data warehouse and provide proper error handling and alerting.
• Extensive knowledge of Relational Database Management Systems using Complex Stored Procedures and Triggers.
• Experienced in implementing Data Warehouses using SQL 2008/2005 Analysis Services creating Cubes and populating them with Dimensions and Facts.
• Upgrade DTS packages to SQL Server Integration Services (SSIS) and Expertise in Data Transformation Services (DTS) in SQL server 2000.
• Migration of MS SQL SERVER 2005 to MS SQL SERVER 2008.
• Strong Experience in designing cubes, defining referenced relationships, calculated members, writing MDX queries and in identifying KPI’s in SSAS 2008/2005.
• Experienced in implementing Calculated Members and Key Performance Indicators (KPIs) via MDX queries.
• Good knowledge of Collations, Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Data Modeling like Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables using Analysis Services.
• Extensive Hands on experience in troubleshooting database issues as well as migrating data from different sources like Excel and Flat files to MS SQL Server by using BCP and DTS utility.

TECHNICAL SKILLS

• MS SQL Server 2008/2005/2000
• SQL Server Integration Services (SSIS)
• SQL Server Analysis Services (SSAS)
• SQL Server Reporting Services (SSRS). Business Intelligence Development Studio (BIDS)
• DTS Packages
• ETL
• SQL Server Management Studio
• SQL Server Enterprise Manager
• SQL Server Profiler
• Visual Studio .Net
• Microsoft Management Console
• Visual Source Safe 6.0
• MS Visio
• ERWIN7.3/4.5/4.0
• MS Access
• MS Project
• MS Office
• Windows XP/2000/2003/NT 4.0/9x/Vista
• MS-DOS
• UNIX
• Oracle 9i/10g.

PROFESSIONAL EXPERIENCE

Confidential, Oakland, CA

MS SQL SERVER SSRS/SSAS Developer

Responsibilities:

• Created Complex SQL queries, Derived tables, common table expressions (CTEs), complex stored procedures, views, indexed / materialized views, generating Cross Tab Tables (Pivot), full text Search, Distributed Queries, user defined functions (UDF), Cursors and Database triggers. Extensively involved in designing (Logical and Physical) of customer database.
• Produced Ad-Hoc reports for testing purposes and the Data Warehousing process.
• Supported specific user groups with reports based on necessary business requirements.
• Used Pull delivery to allow employees to grab any of the reports they need and in whichever format they desire.
• Used sub-reports and linked reports to produce results based on many different datasets.
• Formatted the reports to display only the information that was important to the user.
• Modified and created Stored Procedures to facilitate the datasets required by reporting services.
• Created complex packages to cleanse and populate data warehouses using transformations like fuzzy lookup fuzzy grouping and slowly changing wizard.
• Wrote complex queries and stored procedures in T-SQL to meet new business requirements.
• Optimized the existing queries to improve performance using SQL Profiler tools
• Prepared feasibility reports for MOLAP Cubes against relational ROLAP for the application.
• Measured the existing size of the data on the relational side, plan for growth (addition of new data everyday) for a year.
• Created a test Analysis Services Warehouse to estimate how much space was required to hold the current data in MOLAP off the relational database and prepared comparison reports based on this.
• Convinced the Project Manager that Analysis Services MOLAP Warehouse was a better option based on facts in the reports including performance differences.
• Implemented the Final Warehouse on Analysis Services, built Key Performance Indicators KPIs and Calculated Members.
• Communicated with the team members on regular basis. The change requests had to be made for all the implementations.
• Created XML, PDF, EXCEL files using SSRS.
• Used MDX queries to build reports in SSRS pulling data from existing cubes.
• Created different types of reports like drill down reports, drill through reports and linked reports to answer different business questions.

Confidential, Texas

MS SQL Server SSRS/SSIS/SSAS Developer

Responsibilities:

• Managed the entire process involving the access, manipulation, analysis, interpretation and presentation of information from both internal and secondary data sources to customers in sales area.
• Developed reporting templates to produce quicker SSRS solutions based off a base set of requirements.
• Proactively promoted the reporting life cycle for the creation and management of business reports.
• Created reports for auditing and testing OLAP database for data integrity or anomalies.
• Migration of MS SQL SERVER 2005 to MS SQL SERVER 2008.
• Designed reports using MDX and the reporting wizard to produce Drill Down and Drill Through reports to provide custom views of the information for users.
• Worked with Oracle and MS SQL Server databases to create complex reports.
• Created crystal reports, ODBC and database connections.
• Created MOLAP Warehouse on SQL 2008 Server Analysis Services and created cubes with dimensions and facts.
• Analyzed and understood all data in the source databases and designed the overall data architecture and all the individual data marts in the data warehouse for each of the areas of Compliance Management, Preference Management, and Privacy Management.
• Involved in the creation of Tables, Table Partitions, and Indexes.
• Implemented various integrity constraints for data integrity like Referential integrity using primary key and foreign keys relationships.
• Handled alerting mechanisms, system utilization issues, performance statistics, capacity planning, integrity monitoring, population, maintenance, reorganization, security, and recovery of databases.
• Identified and tracked the slowly changing dimensions, heterogeneous Sources and determined the hierarchies in dimensions.
• Created application-specific Data Marts so that users can access personalized dashboards of information that is specific to their department and business unit.
• Worked on database connections, SQL joins, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.

Confidential, Campbell, CA

MS SQL Server SSRS/SSIS Developer

Responsibilities:

• Worked closely with the requirement team and designing team for understanding the business requirement.
• Designed and applied Entity and Attributes description and definition for the models.
• Implemented different types of Constraints on tables designed in the data staging area for the migration.
• Designed various SSIS modules in order to fetch the data in the data staging environment based on the different types of incoming data.
• Designed various packages using various task e.g. For Each Loop, File System Task, Fuzzy Lookups, Multicasting various others for data cleansing.
• Extensively used Views for complex joins queries involving multiple tables from different databases.
• Created complex Stored Procedures, Triggers, and Functions for validation process & for loading data from the staging are to the product database in SQL 2005.
• Implemented Views (Partition View, Parameterized Views) and other T-SQL code for making joins between the tables.
• Developed, Maintained, and Monitored all import/export and Data Transformation into the Staging, Production and Data Warehouse environments.
• Designed different type of reports including: Tabular forms, Matrix (cross Tab report) form, Conditional, List items, Charts and Sub reports.
• Transformed data from various data sources using OLE DB connection by creating various SSIS packages.
• Created and developed query for Drill Down and AD Hoc Reports using SQL Server 2005 Reports Services (SSRS).
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Maintained scheduling the subscription reports with the subscription report wizard.
• Utilize SSRS (Reporting Services) to generate user/business reports provide technical support to adept to Team Lead.
• Serve as technical expert guiding choices to implement analytical and reporting solutions for client.
• Worked closely with DBA's deploying packages for staging/production server with shell scripts.
• Documented all database objects, which were used in the project and for further upgrades and maintenance.

Confidential

MS SQL Server Developer/SSRS Developer

Responsibilities:

• Designed and developed ER diagrams (Physical and Logical using MS Visio) and mapping the data into database objects.
• Developed stored procedures, views and functions.
• Designed and developed different type of reports including: Tabular forms, Matrix (cross Tab report) form, Conditional, List items, Charts and Sub reports, Drill down reports.
• Created complex expressions, calculations, sorting, filtering to enhance data presentation in reports.
• Created insert, update and delete triggers on some tables in order to capture any DML activities happening on some crucial and confidential data.
• Back end Experience in MS SQL Server development, writing T-SQL stored procedures, views, triggers, cursors, UDFs for SSRS.
• Created and maintained databases, tables, users, logins, indexes, check constraints, and business rules using T-SQL.
• In order to perform Error Handling created each stored procedure with TRY and CATCH blocks.
• To get the best performance for SSRS reports and applied performance tuning on various SQL procedures and created proper indexes on tables.
• Created report snapshots to improve the performanceofSSRS.
• Created user defined functions to split the string for the multi valued parameters and pass to the main query.
• Involved in activities of Integration testing and deployment in various environments, like QA, staging and production.
• Involved in various activities of generating Insert and update scripts to load the data to and from production servers to dev servers.
• Designed and developer SSRS security architecture using Role based security model provided in SSRS 2005.

Confidential

MS SQL Server Developer

Responsibilities:

• Created Database Objects in TSQL - Tables, Indexes, Views, and Roles.
• Created Customized Stored Procedures, Triggers, and Cursors.
• Involved in job scheduling using MS SQL server Agent.
• Prepare and set up environment for Disaster recovery.
• Transformation of data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS).
• Data conversions from legacy systems to SQL server Using DTS.
• Wrote DTS scripts for data transfer
• Responsibilities also included transferring of customer, personal financial history information from various ODBC driver files to SQL server database files using DTS.
• Performed Data transfer (Import & Export) using BCP.
• Identified slow running query and optimization of stored procedures and tested applications for performance, data integrity using Execution Plan.
• Generated Daily, Weekly and Monthly reports for the analysis of managers and end users.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules.
• Designed and created views for security purposes, implemented rules, defaults, and User defined data types.
• Designed index, statistics and optimized queries by using execution plan for performance tuning of the database.