Sql Server Bi Developer Resume
Agoura Hills, CA
SUMMARY
- Over 7+ years of IT experience as a MS SQL Server Developer 2012/2008/2005/2000 in various Industry verticals like Finance and Insurance.
- Extensive experience with different phases of software development life cycle (Analysis, Design, Implementation, Testing, and debugging new and existing client - server based applications).
- Experience in Installation and Configuration of SQL Server 2008/2005/2000.
- Excellent knowledge in creating Databases, Tables, Stored Procedure, DDL/DML Triggers, Views, User defined data types, Cursors and Indexes using T-SQL.
- Good knowledge in Normalizing and De-normalizing the tables and maintaining Referential Integrity by using Triggers and Primary and Foreign Keys.
- Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.
- Experience in using profilers, Index Tuning Wizard and performance monitor to monitor SQL Server.
- Highly experienced in complete cycle of SQL Server Integration Services (2005/2008), Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing data transfers and ETL purposes across different servers.
- Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS) (2005/2008).
- Extensively used Control Flow and Data Flow transformations like Execute SQL Task, FTP Task, Send Mail Task, Conditional Split and Fuzzy Lookup.
- Extensively used ETL methodology for performing Data Migration, Extraction, Transformation and Loading using SSIS and designed data conversions from wide variety of source system.
- Experience in creating SSIS packages using Active X scripts and with Error Handling.
- Experience in providing Logging, Error Handling by using event handlers and custom logging for SSIS Packages.
- Experience in Scheduling and Monitoring ETL processes using DTS Exec utilities and batch files.
- Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
- Highly Proficient in creating SQL Server Reports, handling sub-reports and writing queries to perform roll-up and drill down operations in SSRS 2005
- Experience in creating complex drill down reports, parameterized reports, dropdowns and images, charts using SSRS 2005/2008, Crystal Reports and MS Excel for the analyzation of the data at an enterprise level.
- Knowledge in creating Ad-hoc reports and data driven subscription reports by using Report Builder (version).
- Expertise in creating Cubes with dimensions and Facts Tables in MOLAP Warehouse using SQL Server Analysis Services (SSAS).
- Involved in designing, deploying and processing OLAP Cubes using SSAS for the analysis of data with pre-calculated aggregations and also in summarized fashion which can be modeled into a report accordingly.
- Involved to develop the VB Script, C# in SSIS.
- Good at collaboration and interpersonal skills
- Can work as individual as well as a team player
TECHNICAL SKILLS
Languages: SQL, T-SQL, PL/SQL. C, C++, VB 6.0,Perl,CSS, HTML, XML, MHTML
Databases: SQL Server 2012/2008/2005/2000/7.0 , Oracle 9i/8.x, DB2 MS Access
Reporting Tools: SQL Server Reporting Service (SSRS), Crystal Reports XI/10/9
ETL Tools: SSIS(SQL Server Integration Services), DTS(Data Transformation Services), Import Export Data, Bulk Copy Program (BCP)
Other Software: MS Office- 2007/2003/2000 , Adobe Professional, SharePoint
Operating Systems: Windows / 98/2000/2003/ XP/Vista, Unix.
Database Tools: SQL Query Analyzer, SWIFT Tool, ERWIN, SQL Enterprise Manager, SQL Server Management Studio(SSMS), SQL Server 2005 Query Editor, Solution Explorer, Analysis Manager, Reporting Server, Business Intelligence Development Studio(BIDS)
Methodologies: Logical and Physical Database Design, UML, Database Design and Normalization, Data Modeling
PROFESSIONAL EXPERIENCE
Confidential, Agoura Hills, CASQL Server BI Developer
Responsibilities:
- Involved in complete Software Development Life Cycle.
- Worked with the application developers and provide necessary SQL Scripts using T-SQL.
- Designed and created SQL Databases, tables, indexes, and views based on user requirements.
- Create joins and sub-queries for complex queries involving multiple tables
- Created User Defined Functions, Stored Procedures, and Triggers.
- Created database maintenance plans for the performance of SQL Server including database integrity checks, update database statistics, re-indexing and data backups.
- Experience in creating complex SSIS packages using proper control and data flow elements.
- Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, Oracle,DB2etc) and then loaded the data into destination tables by performing different kinds of transformations using SSIS packages
- Created data loads and Performed Data validations
- Created packages in SSIS with error handling.
- Worked with different methods of logging in SSIS.
- Experience in Error Handling using TRY and CATCH blocks and performance tuning using counters in SSIS
- Have deployed packages on different servers by configuring it.
- Created the automated processes for the activities such as database backup processes and SSIS Packages run sequentially using SQL Server Agent job.
- Monitoring the jobs in case of heavy data loads and high memory usage. .
- Worked on SSRS to generate reports for various user groups and developer groups.
- Created Tabular reports, Matrix reports, Parameterized reports, Sub reports, Cascaded parameterized reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment.
- Created SSRS Report Model Projects in BI studio and created, modified and managed various report models with multiple model objects, source fields and expressions.
- Generate various ad hoc reports using MS Reporting services.
- Deployed and generated reports on to the server using the Reporting Services Report Manager.
- Deployed and uploaded the SSRS reports to SharePoint Server for the end users and involved in enhancements and modifications.
- Used MS Team Foundation server for Code Check -in and check out.
- Prepared documentation related to database design, Low-Level-Design Documents, Service Level Agreement and Unit testing plan and scripts.
Environment: SQL Server 2012/2008R2/2005, Query Analyzer, Enterprise Manager, TFS, SSIS, SSRS, T-SQL, Windows 2000/XP, SharePoint server 2007.
Confidential, Santa Clara, CA
SQL Server BI Developer
Responsibilities:
- Worked with the application developers and provide necessary SQL Scripts using T-SQL.
- Created database maintenance plans for the performance of SQL Server including database integrity checks, update database statistics, re-indexing and data backups.
- Created User Defined Functions, Stored Procedures, and Triggers.
- Designed and created SQL Databases, tables, indexes, and views based on user requirements.
- Create joins and sub-queries for complex queries involving multiple tables
- Worked with the application developers and provide necessary SQL Scripts using T-SQL.
- Experience in creating complex SSIS packages using proper control and data flow elements.
- Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc) and then loaded the data into destination tables by performing different kinds of transformations using SSIS/DTS packages
- Created data loads and Upgrade scripts for data migrations and validations
- Created packages in SSIS with error handling.
- Worked with different methods of logging in SSIS.
- Experience in Error Handling using TRY and CATCH blocks and performance tuning using counters in SSIS
- Have deployed packages on different servers by configuring it.
- Created the automated processes for the activities such as database backup processes and SSIS Packages run sequentially using SQL Server Agent job.
- Used Active-X scripting in SSIS for transformation of data into staging tables and also to extract data from database tables and write the data to text files.
- Worked on SSRS to generate more than 60+ reports for various user groups and developer groups.
- Created Tabular reports, Matrix reports, List & Chart reports, Parameterized reports, Sub reports, Cascaded parameterized reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment.
- Created SSRS Report Model Projects in BI studio and created, modified and managed various report models with multiple model objects, source fields and expressions.
- Generate various ad hoc reports using MS Reporting services.
- Created various Weekly and Monthly reports showing detailed information.
- Deployed and generated reports on to the server using the Reporting Services Report Manager.
- Worked with various Delivery mechanisms of Reports including Email /PDF/Schedules etc
- Deployed and uploaded the SSRS reports to SharePoint Server for the end users and involved in enhancements and modifications.
- Implemented Unit Tests and Integration Tests.
- Prepared documentation related to database design, objects security and rules.
Environment: SQL Server 2008R2/2005, Query Analyzer, Enterprise Manager, DTS, SSIS, SSRS, T-SQL, Windows 2000/XP, SharePoint server 2007.
Confidential, Berkeley Heights, NJ
SQL Server BI Developer
Responsibilities:
- Involved in Installation and Configuration of MS SQL Server 2008.
- Created Database Objects like Stored Procedures, Triggers and User Defined Functions (UDF) for this project.
- Created Views to maintain security of customer data.
- Created Indexes to get the high level performance.
- Performed ETL operations to support incremental, historical data loads and transformations using SSIS.
- Created SSIS packages to extract data from OLTP to OLAP systems and scheduled jobs to call the packages.
- Created ETL packages with different data sources and loaded the data into destination tables by performing complex transformations using SSIS packages.
- Designed SSIS packages for synchronizing the data between two different servers.
- Created and Scheduled jobs for various tasks and also was responsible for maintaining jobs.
- Used various advanced SSIS functionalities like complex joins, conditional splitting, column conversions for better performance during package execution.
- Created SSIS Packages to migrate slowly changing dimensions.
- Designed numerous ad-hoc and custom reports using SQL Reporting Services.
- Created various Tabular and Matrix Reports using SSRS.
- Created Ad-hoc reports and cascading reports for historical data using SSRS..
- Developed and Scheduled SSIS Packages for loading Facts and Dimensions.
- Created Partition table for very large database for good performance.
- Configured mail profile for sending automatic mails to respective people when job is failed or succeed.
- Created partition function, schema and file groups for fact tables.
- Involved in the post deployment maintenance of canned reports and cubes.
- Involved in the design, development and maintenance of different cubes using SSAS
Environment: MS SQL Server 2008/2005, TFS, Query Analyzer, Windows 2003, SSAS, Excel, Oracle10g.
ConfidentialMS SQL Server Developer
Responsibilities:
- Involved in different stages of Project Life Cycle.
- Actively participated in gathering Business Requirements and System Specifications.
- Created new Databases, tables, established relationship among tables in a database.
- Created stored procedures and functions to support efficient data storage and manipulation.
- Created views to display required information on user interface, and triggers to validate consistent data entry into the database.
- Defined Constraints, Indexes.
- Used SQL Server System Catalog to find Stored Proc, UDF, Triggers, indexes and constraints on existing databases.
- Implemented batch processing using Jobs and DTS.
- Migrated data from Flat files to SQL server 2000 using DTS (Import and Export Wizard)
- Created and Scheduled DTS packages to pull data from SQL Server and exported to Excel Spreadsheets and vice versa.
- Scheduled Jobs using SQL Server Agent.
- Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
- Maintaining jobs for data messaging from development server to test server for generating daily reports for financial and marketing team.
- Designed and implemented several complex reports.
- Developed Reports to generate daily, weekly, monthly, quarterly, yearly Reports using crystal Reports.
- Created different user level groups, and assigned appropriate permission level to the database.
- Preparation of project documentation.
Environment: SQL Server 2000/2005, DTS, MS Access, MS EXCEL, T-SQL, Windows 2000 server.