Sr. Sql Bi Developer Resume
San Jose, CA
PROFESSIONAL SUMMARY:
- Over 9+ years of extensive experience in data warehouse complete life cycle using SQL Server 2000/2005/2008 suite of products SSIS, SSRS, and SSAS.
- Proficient with RDBMS databases including MS SQL Server, Oracle, MS Access and MySQL.
- Experienced in Database design, development, unit testing and Implementation.
- Extracted and Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), and SQL Server Integration Services (SSIS) (2005/2008).
- Defined data warehouse (star and snow flake schema), fact tables, cubes, dimensions, measures using SQL Server Analysis Services (SSAS).
- Extensive experience in acquiring requirements, creating and deploying reports using SQL Server Reporting Services (SSRS) and Business Intelligence projects.
- Experience in creating Ad hoc Reports and interactive reports for the management.
- Good knowledge on Testing Life Cycle, Bug/Defect life cycle, Defect tracking and management.
- Well versed with the knowledge of RDBMS, data warehousing i.e. OLTP & OLAP systems.
- Experience in extraction, transformation and loading (ETL) of data flows using SSIS with complex integration of SQL Server, Oracle.
- Expert in writing T - SQL, working with DTS (Data transformation services) data cleansing, data scrubbing and data migration.
- Strong working experience in the Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Conversions, Data Extraction, Data Transformation and Data Loading (ETL)
- Expertise on various manual testing types like System testing, Regression testing, Functional testing, UAT testing etc.
- Expertise in creating indexed views, complex stored procedures, effective functions, and appropriate triggers to facilitate efficient data manipulation to maintain data consistency.
- Sound knowledge of SQL server administrative skills including, backups, disaster recovery, database maintenance, user authorizations and database creation.
- Good in dimensional data modeling using SSAS, cube partitioning, optimization, creating aggregations
- Good knowledge on Data Ware house concepts.
- Created & formatted cross-tab, conditional, drill-down, top n, summary, form, sub reports, Ad hoc reports, parameterized reports, interactive reports & custom reports
- Experience in providing SSRS server level, item level security & accessibility to various reports in multi-user environment.
- In-depth knowledge of Transact-SQL (DDL, DML)
- Good in creating dashboards, scorecards and building reports.
- Exposure to all phases of software development life cycle (SDLC) with in-depth knowledge of agile methodology, enterprise reporting life cycle, SQL server migrations, change control rules, problem solving skills and escalation procedures.
- Excellent communication, analytical skills, self-learning abilities and leadership quality.
- Flexible to learn advancements in the IT industry, Quick learner, Team Player, willing to learn new technologies.
SKILLS PROFILE:
- MS-SQL Server 2008R2/2005/2000 Oracle 11i/8.0
- T-SQL
- PL/SQL
- SQL Loader
- SQL Server Integration Services (SSIS)
- T-SQL Stored Procedures
- HP Quality Center 9.0
- QTP 9.5
- 10.0
- Test Director
- Win Runner 8.0
- Rational Clear Quest
- Visual Studio 2008/2005/2003
- Toad Reporting Services
- Crystal Reports
- SQL Reports
- Oracle Forms
- Oracle Reports
- SSRS / SSIS
- C
- C++
- PL/SQL
- Pro*C
- .NET
- VB.net
- Java Script
- VB Script
- XHTML
- XML
- ASP
- Java Servlets
- Windows
- XP
- Vista
- UNIX
- Windows 2000
- Windows NT
- DOS
PROFESSIONAL EXPERIENCE:
Confidential, San Jose, CA
Sr. SQL BI Developer
Responsibilities:
- Extensively worked with Business Users gathering their requirements and actively cataloging and supporting various issues and providing their solution.
- Involved in Designing, Developing and Testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems feeds such as CLS (commercial Mtg Accounting System), MSAS ( Agricultural Mtg Accounting System), LMW (Loan Management Workstation), TEBOW (Internal Asset Transfers), SBO ( Residential Mtg Accounting System), CLINK, TANGO, MLHL using SSIS.
- Responsible for coding SSIS processes to import data into the Data Warehouse from Excel Spreadsheet, Flat Files and OLEDB Sources.
- Performed Data cleansing by creating tables to eliminate the dirty data using SSIS.
- Involved in performing incremental loads while transferring the data OLTP to data warehouse using different data flow and control flow tasks in SSIS.
- Used various transformations like Multicast, Conditional split, OLEDB Command, Script Component and Lookup while loading the data into Destination.
- Use ETL to implement the slowly changing Transformation, to maintain Historical Data in Data warehouse.
- Created packages in SSIS with error handling using SSIS 2012.
- Worked with different methods of logging in SSIS.
- Designed & Supported daily, weekly, monthly batch processes using Maestro job scheduler
- Responsible for creating database objects like table, views, Store Procedure, Triggers, Functions etc. using T-SQL to provide structure to store data and to maintain database efficiently.
- Extensively used joins and sub queries to simplify complex queries involving multiple tables.
- Optimized the performance of queries with modification in TSQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized table, established joins and created Clustered, Non-Clustered indexes whenever necessary.
- Created different Parameterized Reports in SSRS 2012 which consist of report criteria in various reports to make minimize the report execution time and to limit the no of records required.
- Created Subscription of reports in different formats like pdf, excel etc. to be executed automatically on daily, weekly and monthly basis.
- Deployed and configured the reports in the Report Server.
- Worked on C#.NET for ETL Backend scripting for designing flat file validations and performance counters.
- Developed Parameterized, Drill-through, and Drill-down Reports to get monthly customers opened account details and profits using SSRS.
- Involved in deploying, configuring and managing reports using Report Manager and Report Builder.
- Formatted the reports using the Global variables and expressions.
Environment: MS SQL Server 2008/2005, T- SQL, MS Excel 2007/2003, Microsoft SQL Server Integration Services (SSIS), Microsoft SQL Server Reporting Services (SSRS), Microsoft SQL Server Analysis Services (SSAS), SQL Server Business Intelligence Development Studio, Team Foundation Server (TFS), Visual source safe (VSS), Microsoft SharePoint 2010.
Confidential, San Jose, CA
Sr. SQL Server BI/SSIS/SSRS/SSAS
Responsibilities:
- Used SSIS Packages to transfer data from different sources to SQL Server using BIDS.
- Used in designing, developing and deploying reports in MS SQL Server environment using SSRS, SSIS in BIDS.
- Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
- Used the complete data mapping for all the migrated jobs using SSIS.
- Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written function, stored procedures and triggers.
- Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and send mail task etc.
- Created many complex Stored Procedures and Triggers.
- Created packages in DTS and SSIS, for data conversion using various transformations tasks
- Built and unit tested reports using SSRS (SQL Server Reporting Services)
- Created reports that call Sub reports in SSRS.
- Developed reporting module using .NET application with set of RDL based reports using SSRS and Complex Stored Procedures.
- Maintained already present reports in Crystal Reports 2008.
- Worked with drill down, cross tab reports as well as chart control reports.
- Successfully understood and implemented the reporting requirements with less amount of supervision.
- Involved in writing SQL Scripts using T SQL to create the datasets for the reports.
- Also created stored procedures based datasets (Datasets that get data using stored procedures).
- Used Joins and sub queries concept for extracting data from multiple tables.
- Involved in writing stored procedures that are used for building consolidated datasets for better reporting needs.
- Extensively used SSIS (SQL Server Integration Services) to load data from different data sources and flat files including but not limited to text excel and comma separated files etc.
- Performing query plans and making sure each and every query is running at its maximum potential and speed.
Environment: SQL Server 2005/2008 Enterprise Edition, SSIS, SSRS, T SQL, .NET Framework, C#, ASP.NET, ADO.NET, Erwin, XML, T SQL, Visual Studio.NET IDE, Windows 2000/2003 Advance Server/XP, MS Excel, MS Access, MS Visual Studio 2005/2008.
Confidential, Foster City, CA
SQL Server Developer (SSIS/SSAS)
Responsibilities:
- Created SSIS packages to clean and load data to data warehouse.
- Created package to transfer data between OLTP and OLAP databases.
- Extracted data from XML to SQL Server.
- Created SSIS packages for data Importing, Cleansing, and Parsing etc. Extracted, cleaned and validated
- Created complex queries to automate data profiling process needed to define the structure of the pre staging and staging area.
- Scheduled Cube Processing from Staging Database Tables using SQL Server Agent
- Wrote MDX queries and expressions for use in Front End BI Applications.
- Created KPI Objects in line with Requirement Docs.
- Optimized cubes for better query performance.
- Extracted data from XML files.
- Created reports by dragging data from cube and wrote mdx scripts.
- Created reports by extracting data from cube.
- Generated reports using SQL Server Reporting Services 2005/2008 from OLTP and OLAP data sources.
- Created report models and deployed on report server.
- Created standard report Subscriptions and Data Driven report Subscriptions
- Created report snapshots and cache for better performance.
- Used Notification services to generate error messages and send them to the user through e-mails, pager messages, and PDA as well as window messengers.
- Created ad-hoc reports, drill down, and drill through reports.
- Deployed reports on Microsoft office SharePoint (Moss).
- Created user defines functions in SSRS using VB script.
- Reviewed and adjusted deliverables involved during SDLC involving database changes/development.
- Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications
- Manage Analysis management objects (AMO) using BIDS.
- Provided knowledge transfer to the company’s SQL programmers.
- Designed maintenance plans
- Wrote distributed queries to extract data from different servers.
Environment: SQL Server 2008/2005, BIDS 2005, reporting service Integration Services 2005, Analysis Services 2005, Windows Server 2003, HealthCare database, SharePoint server, TFS
Confidential, Atlanta, GA
SQL Server SSRS/SSIS.
Responsibilities:
- Worked with Business Analysts and Users to understand the requirement.
- Implement logical design into physical design.
- Maintained design structure (Schema) by directing implementation of SQL standards and guidelines.
- Created a virtual machine and migrated databases.
- Migrated DTS packages using DTS editor wizard in SSIS, validated and tested all packages on development server
- Executed Back up database task, check database integrity, rebuild indexes, update statistics task for maintenance
- Used VB script in script component for data transformations.
- Created reports from cubes by writing MDX queries.
- Managed Package Configurations in XML Files to efficiently Promote Unit Tested.
- Data migration (Import & Export using BCP) from text to SQL Server2005.
- Identified the Measures and Dimensions from the Excel Sheet.
- Successfully Extracted transformed and load data into data warehouse.
- Deployed the generated reports directly on the client’s workstation.
- Created complex Stored Procedures for better performance to generate reports.
- Deployed reports on share point performance server.
- Used VB.net to create user define functions in SSRS.
- Created standard and data driven Subscription, used report manager for securities.
- Created report model for Ad-hoc reporting, generate report in XML format.
Environment: SQL Server 2005, SSIS, SSRS, Query Analyzer, Index Tuning Wizard-SQL MS Access, MS Excel, ERWIN, Windows Server 2003 Enterprise Edition, Share point performance server
Confidential, Grand Rapids, MI
SQL Server SSIS/SSRS Developer
Responsibilities:
- Planned database capacity, infrastructure, configuration and backup/recover strategies
- Performed Relational and OLAP databases installation, configuration, migration, upgrade and performance optimization and tuning
- Perform Database upgrades. Maintained standby servers using log shipping and replication concepts.
- Assigned permission to User(s), Role(s) and objects.
- Designed and created data marts, databases, indexes, views, aggregations, store procedures, partitions & data integrity
- Scheduled and monitored all maintenance activities, database consistency check, index defragment
- Configured securities and accesses to production databases and database servers
- Used SQL Profiler for troubleshooting, monitoring, tuning of SQL Server and SQL code
- Interacting with Business Analysts and Developers in identifying the business requirements, designing and implementing the database schema.
- Provided technical support to internal developers and external clients.
Environment: Access, SQL Server 2005, Visual Studio 2005, Windows Server 2003.