Ms Sql Server / Bi Developer Resume
New York, NY
SUMMARY
- Over 7 years of extensive experience in database design, development and administration with MS SQL Server versions 2008/2005/2000/7.0 using SSIS, SSAS, SSRS in Finance, Pharmaceutical and Healthcare industries.
- Conversant with all phase of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
- Expert in Microsoft Business Intelligence technologies like MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), and MS SQL Server Analysis Services (SSAS) of MS SQL server 2005/2008.
- Experienced in Logical and Physical Database design and development, Normalization and Data modeling using MS SQL
- Experienced in ETL processes, Data warehousing methodologies and concepts including star schemas, snowflake schemas, dimensional modeling and reporting tools, Operations Data Store concepts, Data Marts and OLAP technologies.
- Experienced in designing high level ETL architecture, creating, configuring and fine tuning ETL workflows designed in DTS for overall data transfer from the OLTP to OLAP with the help of SSIS.
- Expert in using Bulk Copy Program (BCP), Data Transformation Services (DTS) packages and SSIS (integration services) with MS SQL Server 2000/2005/2008.
- Proficient in the use of T - SQL for developing complex stored procedures, triggers, tables, user functions, user profiles, relational database models and data integrity, SQL joins and query writing.
- Extensively used performance monitor/SQL profiler to solve dead locks/long running queries.
- Efficient in up gradation and migration from MS SQL Server 2000 to MS SQL Server 2005/2008.
- Hands on experience as a team member in Database Installation, Configuration, Maintenance, Monitoring, Backup and Disaster Recovery procedure and Replication.
- Worked with third party tools like SQL Lite Speed, Spotlight, Erwin,
- Quick learner and good performer both in team and independent job environments.
TECHNICAL SKILLS
- MS SQL Server 2008/2005/2000/7.0
- MS SQL Server 2005/2008 Analysis Services (SSAS)
- MS SQL Server Integration Service (SSIS)
- MS SQL Reporting Services (SSRS)
- Business Intelligence Development Studio (BIDS)
- BCP
- SQL Profiler
- Enterprise manager
- Management studio
- Microsoft Access 2000 4.0/4.1/4.2/7.2
- Microsoft Visio 10.0/11.0
- T-SQL
- ASP.NET
- C#
- VB.Net
- HTML
- XML
- Oracle 9i/10g
- Crystal Reports 8.5/9/10/11
- MS office 2003/2007
- Windows 2000/2003 Advanced Server/Professional
- Windows NT 4.0 Server/Workstation.
PROFESSIONAL EXPERIENCE
Confidential, New York, NY
MS SQL Server / BI Developer
Responsibilities:
- Part of team who gather the requirement for developing BI solution and also designed physical and logical design of data warehouse
- Used star schema to store info in data warehouse
- Responsible for creating and designing SSIS package
- Designed Extraction Transformation and Loading (ETL) process using SSIS to extracted data from flat files, excel files and SQL server database
- Created Views, Stored Procedures, Rules and Defaults
- Designed ETL process in two step:
- Load data from file to staging
- From staging to data warehouse
- Worked as a client-side specialist with JavaScript.
- Applied business logic in staging database
- Created Profiling, Cleansing and Auditing plans with SSIS
- Load data in data warehouse with slowly changing dimension
- Implemented logic with lookup table to maintain parent-child relationship
- Used transformation like Merge join, pivot, lookup, fuzzy lookup and slowly changing dimension
- Use different control flow control like for each loop container, sequence container, execute SQL task, send email task
- Use package configuration to migrate SSIS package from one environment to other
- Use event handing to send e-mail on event like on error
- Use login feature for analysis purpose
- Added intelligent system in SSIS to identify actual change and new change in dimension
- Design OLAP cube
- Design natural and navigational hierarchies in dimension
- Deployed cube on SSAS server
- Created partitions on cubes
- Design SSRS and excel reports for the use of expense analysis, asset related report and balance sheet report
- Deployed reports onto the production report server through various ways.
- Created Ad hoc Reports using report builder in SSRS
- Design store proc, view, trigger, function for data ware housing
- Set up SQL Profiler to trace various Database activities, application Responses and Performance tune them.
- Created script to migrate SQL server object from one environment to other environment.
Environment: SQL Server 2005 Enterprise Edition, Windows Enterprise Server 2003/XP Professional, SQL server 2005/2008,SQL Server Reporting Services, SQL Server Analysis Services, SQL Server Business Intelligence Development Studio, XML Web Services
Confidential, Newark, NJ
MS SQL SERVER / BI Developer
Responsibilities:
- Created SQL Server Reports for Management using SSRS. Tasks included defining requirements, design, develop, test, implement and maintain reports using SSRS.
- Developed several reports with consistent drill-down functionality including Drilldown reports, Summary reports and Master Detail reports.
- Developed Custom Functions, Manual Running Totals and Complex Formulas for reports.
- Used breaks, calculations, sorts, filters and sections to enhance data presentation in reports.
- Created SSIS package in which records were loaded daily, also from other data resources such as Excel, Access, flat file, Oracle and XML in order to create and maintain a centralized data warehouse.
- Created cube structure for the analysis of business condition and for creation of report using SSAS.
- Created drill down and sub reports from SSAS cubes that can be browsed on web.
- Worked on with Report Manager, Report Builder, Reporting Security and Reporting Services Configuration manager.
Environment: MS SQL Server 2008, SSRS, SSIS, SSAS, T-SQL, MS-Excel, XML, Windows 2000/2003/NT/XP
Confidential, Franklin Lakes, NJ
SQL SERVER DEVELOPER / BI Developer
Responsibilities:
- Participated in designing and developing Data Warehouses, Data marts and cubes in Business Intelligence environment using multi-dimensional models such as Star Schema.
- Used SSIS to create ETL packages to extract, transform and load data to data warehouse databases.
- Extracted the data from the different sources and stored the data into the intermediate Staging Database using the SSIS ETL tool.
- Complex business requirements were transformed into ETL's using a variety of transformations like Aggregate, Derived Column, Data Conversion, Union All, Merge Join, Lookup.
- Defined OLAP cubes based on fact tables and dimension tables to suit a range of report/analysis requirements with SQL Server 2008 Analysis Services (SSAS).
- Constructed Cubes based on data volumes mostly adhering to Star Schema.
- Generated very high level SSRS 2008 reports from the OLTP and OLAP cubes.
- Involved in the performance tuning for the OLAP Business Intelligence environment.
Environment: MS SQL Server 2008, MS SQL Server Integration Services 2008, MS SQL Server Reporting Services 2008, Oracle 9i / 10g, XML, Windows XP, MS Office, Excel 2003/2007
Confidential, Tampa, FL
MS SQL Server/ BI Developer
Responsibilities:
- Responsible for creating Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints,
- Created Views, Stored Procedures, Triggers, Rules and Defaults
- Used DBCC commands to check physical and logical consistency of the databases and Rebuild
- Used the SQL Server profiler to capture and store the execution plan. Created necessary indexes,
- Modified the queries to achieve better performance
- Created 3NF normalization forms
- Used SQL SERVER AGENT to automate the process of rebuilding indexes at regular interval for better performance.
- Experienced working on Aggregate, financial and Date time in Development ofreports.
- Developed, deployed and monitored SSIS Packages.
- Extensive experience in data migration between homogenous and heterogeneous system using various tools (Data Transformation Services (DTS), BCP, SSIS).
- Worked on optimization and tuning of SQL queries and indexes.
- Created matrix reports, drill down reports anddevelopedreports with graphs using SSRS.
- Createddifferenttype of reports with charts using SSRS.
- Created employee training reports using parameters and drill down specialty using SSRS.
- Deployed reports onto the production report server through various ways.
- Created Ad hoc Reports using report builder in SSRS
- Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
- Created/developed/maintained the stored procedures, view, triggers to interpret complex business rules, history data and audit analysis
- Scheduled jobs and setup maintenance plans for monitoring the performance of SQL Server databases.
Environment: SQL Server 2005, SQL Server 2000, ERWIN 4.1, SSIS, SSRS, SSAS, SQL Profiler, Windows Advanced Server 2003, Excel, Visio, MS Access
