Ms Sql Server Ssrs/ssis/ssas Developer Resume
Los Angeles, CA
SUMMARY
- Over 8 years of IT Experience in System Design, Development and Support of Microsoft SQL Server 2008/2005/2000 in Development, Data warehouse, Test and Production Environments on various business domains like Insurance, Financial, and Banking.
- Worked extensively on system analysis, design, development, testing and implementation of projects (Complete SDLC) and capable of handling responsibilities independently as well as a proactive team member.
- Strong experience in MS SQL Server 2005/2008 with Business Intelligence in SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS) and SQL Server Analysis Services (SSAS) of 2005/2008.
- Expert in creating SQL server Reports using SSRS 2005/2008.
- Expert in defining Query for generating drill down reports in SSRS 2005/2008.
- Excellent experience in designing and developing Reporting System using Business Objects.
- Experienced in using tools like Bulk Copy Program (BCP), Bulk Insert, Data Transformation Services (DTS) and SSIS with MS SQL Server 2005/2008.
- Proficient in High Level Design of ETL DTS Packages for integrating data from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data).
- Extensively used SSIS Import/Export Wizard for performing the ETL operations.
- Strong Experience in creating SSIS packages using Active X scripts and with Error Handling.
- Experience in enhancing and deploying SSIS Packages from development server to production server.
- Experience in creating SSIS Packages and migrating DTS Packages from SQL Server 2000 to SQL Server 2005 and SQL Server 2005 to SQL Server 2008.
- Data modeling experience focusing on high - activity, normalized transaction systems (OLTP), highly-usable denormalized reporting systems (OLAP) as well as staging areas and data marts.
- Good understanding of Data Marts, Data warehousing, Operational Data Store (ODS), calculation scripts, data matrix, OLAP, Star Schema Modeling, Snow-Flake Modeling, partitions, facts, dimension tables using MS Analysis Services 2008/2005.
- Extensive experience in writing MDX Scripting and MDX Queries.
- Strong Expertise in building the OLAP cubes with SSAS.
- Expert in calculating measures and dimension members using Multi Dimensional Expressions (MDX), mathematical formulas, and user-defined functions (UDFs).
- Experienced in working with Star/Snowflake Schema modeling to develop ROLAP/MOLAP/HOLAP Cubes using SQL Server 2005/2008 Analysis Services.
- Developed interactive reports using Crystal Reports and SQL Server Reporting Services.
- Excellent command over managing Alerts, Operators and Jobs through SQL Server Agent.
- Strong noledge of creating Tables, Views, Indexes, Replication, and other SQL joins and query writing.
- Experienced in strategically implementing the indexes such as Clustered index, Non-clustered index, covering index appropriately on data structure to achieve faster data retrieval.
- Expert in developing T-SQL (DDL, DML, DCL) statements, Data Integrity (constraints), Rules, Performance Tuning, Query Optimization and Validation issues, used DBCC (Database Consistency Checks) Utilities to check the physical and logical consistency of the database.
- Expertise in Database Administration operations like Backup, Recovery, Replication and using SQL Profiler.
- Expert in working with trace files and execution logs.
- Excellent verbal and written communication skills combined with strong interpersonal and conflict resolution skills and possess strong analytical skills.
TECHNICAL SKILLS
- MS SQL Server 2008/2005/2000
- Oracle 9i/10g/11g
- MS Access
- DB2
- MS SQL Server Management Studio 2008/2005
- Business Intelligence Development Studio (BIDS) 2008/2005
- Database Tuning Advisor
- SQL Profiler
- Enterprise Manager
- Query Analyzer
- MS SQL Server Integration Services 2008/2005
- DTS
- BCP (Bulk Copy Program)
- MS SQL Server Reporting Services 2008/2005
- Crystal Reports
- Performance Point Server 2007
- SharePoint
- MS SQL Server Analysis Services 2008/2005
- SQL
- T-SQL
- PL/SQL
- C
- C++
- .NET
- C#
- JAVA
- Perl
- VB Script
- Cold Fusion
- ERwin
- MS Visio
- ProClarity
- Windows (95/NT/2000/XP/7)
- UNIX (Solaris/Linux (Ubuntu)/AIX)
- Microsoft Office
- HTML
- XML
PROFESSIONAL EXPERIENCE
Confidential, Los Angeles, CA
MS SQL Server SSRS/SSIS/SSAS Developer
Responsibilities:
- Created SQL Server Reports using SSRS 2008/2005.
- Implemented the business logic in stored procedures calling different functions.
- Used SVN (Tortoise SVN) for code development.
- Strictly adhered to the Agile methodology and timely Sprint deliverables.
- Developed Query for generating drill down/drill through reports in SSRS 2008/2005.
- Generated Reports using Global Variables, Expressions and Functions for the reports.
- Actively involved in generating Matrix, Sub reports and complex reports with multi value parameters for the analysis of Performance
- Responsible for scheduling the subscription reports with the subscription report wizard.
- Worked on different database development environments like Dev, QA, Staging and Production.
- Developed, monitored and deployed SSIS packages.
- Scheduled and executed SSIS Packages using SQL Server Agent.
- Created OLAP cubes based on Dimensions and Facts for efficient loads of data based on Star Schema structure.
- Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
- Identified and defined Key Performance Indicators (KPIs) in SSAS.
- Used MS Excel (Pivot Table), Reporting Services as Front Viewer and OLAP cube as backend and provided integration between MS Excel/SSRS and SSAS.
- Extensively involved in the SSAS storage and partitions, Aggregations, calculation of queries with MDX, Data Mining Models and developing reports using MDX and SQL in SSAS 2008.
- Worked with thecalculated members(CTEs) and XML Data.
- Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
- Managed indexes, statistics and optimized queries by using execution plan for tuning the database.
- Maintained the physical database by monitoring performance, integrity and optimized SQL queries for maximum efficiency using SQL Profiler.
- Monitored Scheduled jobs and alerts.
Environment: MS SQL Server 2008 Enterprise Edition, MS SQL Server 2005 Enterprise Edition, BIDS 2008/2005, SSRS 2008/2005, SSIS 2008/2005, SSAS 2008/2005, .NET Framework 3.5/3.0/2.5, Erwin 4.1, Windows XP/Windows 7.
Confidential, Palo Alto, CA
MS SQL Server SSRS/SSIS/SSAS Developer
Responsibilities:
- Created SQL Server Reports using SSRS 2008/2005.
- Identified the Data Sources and defined them to build the Data Source Views.
- Developed Query for generating drill down/drill through reports in SSRS 2008/2005.
- Generated Reports using Global Variables, Expressions and Functions for the reports.
- Actively involved in generating Matrix, Sub reports and complex reports with multi value parameters for the analysis of Performance
- Identified and worked with Parameters (e.g. cascading parameters) for parameterized reports in SSRS 2008/2005.
- Responsible for scheduling the subscription reports with the subscription report wizard.
- Deployed the generated reports directly on the client’s workstation.
- Developed, monitored and deployed SSIS packages.
- Used most of the controls and features in SSIS for transforming data from different sources.
- Created OLAP cubes based on Dimension and Facts for efficient loads of data based on Star Schema structure.
- Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
- Identified and defined Key Performance Indicators (KPIs) in SSAS 2005.
- Used MS Excel (Pivot Table), Reporting Services as Front Viewer and OLAP cubes as backend and provided integration between MS Excel/SSRS and SSAS.
- Extensively involved in the SSAS storage and partitions, Aggregations, calculation of queries with MDX, Data Mining Models and developing reports using MDX and SQL in SSAS 2008.
- 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 the tables.
- Designed and applied entity and attributes description and definition for the models.
- Managed indexes, statistics and optimized queries by using execution plan for tuning the database.
- Maintained the physical database by monitoring performance, integrity and optimized SQL queries for maximum efficiency using SQL Profiler.
- Monitored Scheduled jobs and alerts.
Environment: MS SQL Server 2008 Enterprise Edition MS SQL Server 2005 Enterprise Edition, BIDS 2008/2005, SSRS 2008/2005, SSIS 2008/2005, SSAS 2008/2005, .NET Framework 3.5/3.0/2.5, Erwin 4.1, Windows XP/Windows 7.
Confidential, San Jose, CA
MS SQL Server SSIS/SSRS Developer
Responsibilities:
- Created Cross-Tab, Drill-down, Drill Through, Parameterized and Sub-Reports using Report Definition Language (RDL) and Semantic Model Definition Language (SMDL).
- Actively involved in developing Complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Hyper-Linking, Charts and Graphs.
- Managed the Report Server contents with Admin privileges and Report Manager for Subscriptions, Snapshots and Security Content on the reports.
- Responsible for ETL through SSIS and loading Data to DB from different input sources.
- Used ETL for data flow from different source files like XML, Excel, Tables, and Views to other databases and files with proper mapping.
- Developed custom interface for executing and managing SSIS packages.
- Scheduled and executed SSIS Packages using SQL Server Agent.
- Created Event Handlers for SSIS package on Error, on Post execute.
- Performed Data migration (Import & Export - BCP (Bulk Copy Program)) from text to SQL Server
- Used various transformations like Multicast, Slowly Changing Dimensions and Conditional split, OLEDB Command, Script Component and Lookup while loading the data into Destination.
- Involved in various levels of testing (Unit, Functional and Integration).
- Performed quality assurance and testing of SQL server environment.
- Involved in Testing the Packages and fixing bugs using SQL Server 2005.
- Performed transformations of data such as adding derived column, sorting of data, merging of data has been done while pulling data from SQL Server 2005 to the SQL Server 2008.
- Improved the performance of SQL server queries using query execution plan, covering index, indexed views and by rebuilding and reorganizing the indexes, updating statistics on the tables.
Environment: MS SQL Server 2008 Enterprise Edition MS SQL Server 2005 Enterprise Edition, BIDS 2008/2005, SSRS 2008/2005, SSIS 2008/2005, .NET Framework 3.5/3.0/2.5, Erwin 4.1, Crystal Reports, Windows XP/Windows 7.
Confidential, Pleasanton, CA
MS SQL Server SSRS/SSAS Developer
Responsibilities:
- Generated database monitoring and data validation reports in SQL Server Reporting Service (SSRS) 2005.
- Developed Query for generating drill down/drill through reports in SSRS 2005.
- Extensively used the Report Items (Table, Matrix, Rectangle, List, Image, Sub report, Chart) in report creation.
- Created subscription for the windows file share and implemented three layer securities for the reports, SSRS website, and in the Intranet web application.
- Generated Reports using Global Variables, Expressions and Functions.
- Added Replication definition and its function on Reporting Server and monitored replication.
- Configured Snapshot replication for reporting, User Acceptance Testing (UAT) and development servers.
- Created code documentation using Visual source safe.
- Created OLAP Cubes in SQL Server Analysis Service (SSAS) 2005.
- Involved in design and building the Dimensions/measures for the cubes with star/snowflake schema.
- Designed user defined hierarchies (including parent-child hierarchy) along with the attribute hierarchies.
- Created components, tools, techniques, methods and procedures used in On-Line Analytical Processing (OLAP) environment for accessing and translating data into understandable and usable business information.
- Calculated measures and dimension members using Multi Dimensional Expressions (MDX), mathematical formulas, and User-Defined Functions (UDFs).
- Used MDX to extract data from cubes and Created MDX script for representing Cube Calculation.
- Designed and created views for security purposes, implemented rules, defaults, and user defined data types.
- Tested queries to optimize the procedures and triggers to be used in the production environment.
Environment: MS SQL Server 2005, BIDS 2005, SSRS 2005, SSAS 2005, Cubes, OLAP, OLTP, UML MDX, T-SQL, Crystal Reports, Query Analyzer, .Net
Confidential, Minneapolis, MN
MS SQL Server SSIS/SSAS Developer
Responsibilities:
- Created SSIS Packages to load data from Oracle to SQL Server.
- Successfully migrated data from multiple Heterogeneous/Homogeneous Environments into SQL Server 2005 using BCP (Bulk Copy Program), Bulk Insert and SSIS Packages.
- Used ETL for data flow from source files like XML, Excel to other databases like MS Access, Oracle.
- Created Event Handlers for SSIS package on Error, on Post execute.
- Developed custom interface for executing and managing SSIS packages.
- Used Lookup transformation in SSIS to get the data from reference data sets.
- Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
- Worked on the partition of the cube.
- Defined unnon members and null processing properties in SSAS 2005.
- Designed Dimensions and used the MDX for the various Optimizations like Optimizing cube schema.
- Responsible for identifying Key Performance Indicators (KPIs) in SSAS 2005.
- Identified and defined Fact relationships in SSAS.
- Monitored and analyzed the performance and results of the organization using Dashboards and KPIs in Performance Point Server (ProClarity).
- Created complex Stored Procedures, triggers, cursors, tables, views and other SQL joins and statements for applications by using T-SQL.
Environment: MS SQL Server 2005, BIDS 2005, SSIS 2005, SSAS 2005, Cubes, OLAP, OLTP, UML MDX, T-SQL, Crystal Reports, Query Analyzer, .Net, Oracle 10g, Performance Point Server
Confidential, Cupertino, CA
MS SQL Server Developer / DBA
Responsibilities:
- Developed backup restore scripts for SQL Server as needed.
- Wrote various stored procedures for the purpose of application development.
- Tuned SQL statements (e.g. using Indexes) and Stored Procedures.
- Performed disaster recovery and database maintenance plan.
- Involved in replication of Data (Transactional method used).
- Designed and implemented data access stored procedures and triggers for automating tasks.
- Involved in job scheduling and alerts.
- Designed and implemented user log in and security.
- Resolved any deadlocks issues with the Databases/Servers on a real-time basis.
- In-Depth working noledge of ODBC (Open database Connectivity).
- Created many complex Stored Procedures/Functions and used them in Crystal Reports directly to generate reports on the fly.
- Created crystal reports and hosted in the web for the users.
Environment: MS SQL Server 2005, T-SQL, Win NT v4, Win 2000, Win 2003, Crystal Report 8.5.
Confidential
MS SQL Server Developer
Responsibilities:
- Responsible for developing processes, automation of maintenance jobs, tuning SQL Server, locks and index configuration, administering SQL Server security, SQL Server automatic e-mail notifications and SQL Server backup strategy and automation.
- Involved in testing to optimize the procedures and triggers to be used in the production environment.
- Involved in project planning with project managers.
- Managed user logins, database user accounts, server roles, database roles and permissions.
- Involved in analyzing and designing disaster recovery/replication strategies with business managers to meet the business requirements.
- Configured replication servers and transactional replication between production and standby server for disaster recovery.
- Supported front-end development team to resolve SQL Server related issues in Active Server Pages (ASP) during server migration.
Environment: MS SQL Server 2000, T-SQL, ERwin v4.0, Windows 2000, Crystal Report 8.5.
