We provide IT Staff Augmentation Services!

Ms Sql Developer /bi Etl Developer Resume

3.00/5 (Submit Your Rating)

Somerset, NJ

SUMMARY

  • Over 8 years of IT experience in complete Software Development Life Cycle and Agile Methodologies including Requirement Analysis, Design, Development, testing, Implementation .
  • Strong Expertise in SQL Server 2000/2005/2008 components such as SSRS (SQL Server Reporting Services), SSIS (SQL Server Integration Services), SSAS(SQL Server Analysis Services).
  • Expert in Migrating SQL 2000 databases to SQL 2005 and SQL 2008 using Migration tools.
  • Expert in creating indexes, Views, complex Stored Procedures, user defined functions, cursors, derived tables, common table expressions (CTEs) and Triggers to facilitate efficient data manipulation and data consistency.
  • Extensively used tools like SQL Profiler, Index Tuning Wizard, and Database Engine tuning wizard, Windows Performance Monitor for monitoring and tuning MS SQL Server performance.
  • Expertise noledge on Index tuning and hands on experience on Performance Monitoring
  • Expert in Extracting and Transforming data using DTS in SQL Server 2000, SSIS in SQL Server 2008/2005,SQL Server Import Export Wizard, Bulk Insert Task and Bulk Copy Program(BCP).
  • Experience in Importing/Exporting Data from various data sources like Excel, Oracle, DB2 and Flat file using DTS utility.
  • Excellent command on subscriptions, report snapshot and report cache and built stylish Drill Down, Cascading, Parameterized, Drill through, Sub reports and Charts using Global variables, Expressions and Functions for the Business Users using SSRS.
  • Developing and deploying cubes with Star and Snow Flake Schemas using SSAS.
  • Ability to deliver comprehensive BI through MS solutions including SharePoint Server (MOSS),Windows SharePoint Server 2003(WSS)
  • Co - ordinate with DBA in regard to high availability SQL Server solutions with SQL Server Failover Clustering, Database Snapshot, Log shipping, and Database Mirroring.
  • Experienced in automating the system by using Notification service and creating alerts, jobs and maintenance plans.
  • Adept at interfacing with end users to gather requirements and produce functional requirements, Ample noledge of Relational Database Management Systems (RDBMS) & Entity Relationship Diagram (ERD).

TECHNICAL SKILLS

  • MS SQL Server 2000/2005/2008
  • MS Access
  • Visual Studio
  • SSMS
  • Query Analyzer
  • DTS
  • BI tools( SSRS
  • SSIS
  • SSAS)
  • Bulk Copy program (BCP)
  • SQL Server Management Studio
  • Windows NT/2000/2003/XP/VISTA/2008
  • Windows 7
  • Linux
  • Oracle
  • Toad
  • Erwin
  • HTML
  • XML
  • JavaScript
  • ASP.Net
  • C#.NET
  • Internet Information Server (IIS)
  • MS Office

PROFESSIONAL EXPERIENCE

Confidential, Somerset, NJ

MS SQL Developer /BI ETL Developer

Responsibilities:

  • Gather requirements and understand the specifications of wholesale access certification needs.
  • Designed and built prototype for access certification challenge on the wholesale end to integrate with Enterprise access certification tool.
  • Database migration is done from SQL Server 2005 to SQL Server 2008 to enable the applications to run better and reduce the amount of time you need to spend managing them.
  • Involved in improving performance by using filtered Indexes, Data snapshots for Reports building, regular dropping and construction of indexes.
  • Good noledge in analyzing Execution plan, Performan.
  • Creating Database objects - Tables, Views, and Functions and developing Procedures for implementing application functionality at the database side for performance improvement.
  • Implemented new features in SQL 2008 like Policy based Management, Table Compression & backup compression; SQL Server Auditing and MERGE statement in T-SQL and spatial data types provide powerful and easy to use application development enhancements.
  • Worked extensively on SSIS Packages for extracting the data of the file system and transformed that data and load it into OLAP.
  • Extensively used various SSIS objects such as Control Flow Components, Dataflow Components, Connection managers, Logging, Configuration Files etc.
  • Designed, developed, debugged and tested SSIS packages, Stored Procedures, configuration files and implement best practices packages to maintain optimal performance.
  • Developed and implemented error handling logics in all the SSIS packages to handle bad data and avoid package failures.
  • Developed SQL Server Integration Services (SSIS) packages to automate the nightly extract transform and load jobs.
  • Generated reports using SQL Server Reporting Services integrated and deploying them using web applications onto the web servers.
  • Developed MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and ad-hoc reports.
  • Developed Tabular, Cross Tab reports, Charts reports, Parameterized, cascaded and sub-reports using SSRS.
  • Used SQL Server 2005 to design, implement and manage data warehouses OLAP cubes and reporting solutions to improve asset management, incident management and data center services.
  • Managed the historical data in the data warehouse from various data sources.
  • Monitored, optimized and Performance Tuning of Regression Servers using Performance monitor, SQL Profilers, Activity Monitor.

Environment: MS SQL Server 2005/2008, SQL server Reporting Services 2008, SQL Integration Services 2008, Microsoft Visual Studio, SQL Server Management Studio, MS Excel, T-SQL,ERWIN.

Confidential, NYC

MS SQL BI Developer

Responsibilities:

  • Worked on the complete life cycle of the project from design to implementation
  • Translated user requirements into functional and technical requirements in coordination with the Sr. Business Analyst
  • Analyzed thebusiness requirement and functional specifications provided by the data specialist
  • Responsible for designing and maintaining a wide variety of daily, weekly, and monthly financial and analytical reports used by different departments within the company.
  • Responsible for making sure reports are scheduled and delivered in a timely manner
  • Designed reports using proper text formatting, report headers and footers, and page size to allow for printable reports.
  • Worked on SSIS for transferring data from Heterogeneous Data format to SQL Server.
  • Created ad Hoc and parameterized various reports using SQL server 2005 reporting Services with data from SQL Server and MS Access as data sources
  • Cleaned the data and created fact and dimension tables, performed calculations required for the reports using SQL Server 2005 environment and accomplished data modeling.
  • Designed and architected of cubes for building reports using SQL Server Business Intelligence Development Studio to support business reporting and forecasting processes
  • Designed and built the dimensions and cubes with star schema using SQL Server Analysis Services (SSAS)
  • Developed and designed cubes with around 45 dimensions, about 25 Measures and 20 calculated members, Design Dimensions and using the MDX expressions for the various calculated members, actions andKPI.
  • Implemented OLAP Cubes, Facts, and Dimensions for providing summarized and aggregate views of large sets of data and used Multi Dimensional Expression (MDX) to access them.
  • Extensively involved in theSSASstorage and partitions and Aggregations, Calculation of queries with MDX, Data Mining Models, developing reports using MDX and T-SQL.
  • Documented the complete data warehouse environment, including all dimension and fact tables, the relationship between SSIS packages and the target tables, which packages were valid and in use, the relationship between the jobs and SSIS packages, and the relationship between the source tables and the OLAP tables used in the SSAS Cube
  • Created ad hoc SSRS reports in the test environment for data validation
  • Created dynamic Reports from the cube using SSRS 2005, and stored procedures.
  • Troubleshoot the deployment of reports in the test and production environment using SSRS

Environment: SQL Server 2005/2008, SQL server Reporting Services 2008, SQL Integration Services 2008, SQL Analysis Services 2008,Microsoft Visual Studio, SQL Server Management Studio, MS Excel, T-SQL,ERWIN.

Confidential, Bellevue, WA

MS SQL/Report Server Developer

Responsibilities:

  • Developed T-SQL code, Views, Functions and Stored procedure using T-SQL to get data from Different data and with best execution plan.
  • Scheduled SQL jobs in SQL Server 2005 to generate alerts to the subscribers to the alerts in RAN 2G & 3G and CORE alerts.
  • Created different user-defined functions using T-SQL Query for the creating Datasets and Data Adapters to use them in SSRS 2008 and SSIS.
  • Configured SQL Mailing Agent for sending alerts to the subscribers by mails upon SSIS packages, SSRS reports2008 and T-SQL Stored Procedures.
  • Involved in developing and deployed Reports from OLAP in SSRS with Charts and PIE Diagrams.
  • Created Drill Down and Drill through reports with user defined parameters with sub reports, Pie diagrams and Charts in SSRS.
  • Configured in report architecture and report security for reports in SQL Server Reporting Services.
  • Involved in invoking reports created in SSRS to front-end like Share-Point server for the managerial and client verification.
  • Developed Custom Report and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server 2005 Reporting Services (SSRS) in Crystal reports.
  • Built advanced reports using query parameters, report parameters, filters, interactive sorts to compare the rates among the four major regions, to generate the alerts history in active reports.
  • Developed Templates for the reports for the managerial cadet so that they need to drag and drop the fields which they need exclusively for Non-technical person in SQL Server Reporting Services (SSRS).
  • Created report models for ad hoc reports when the end user wants to see the reports on fly in SQL Server Reporting Services (SSRS) in Data Dynamics report with VB.NET.
  • Created Ad-hoc reports for manager using SSRS to find all the work items open for Developers.
  • Developed, tested and implemented Referential Integrity rules and regulations through constraints, triggers and views in the centralized Confidential SQL database.
  • Migrated data from Heterogeneous Data Sources and legacy system (ORACLE (OSS), Access, Excel) to centralized SQL Server databases using SQL Server Integration Services (SSIS)
  • Involved in performing incremental loads while transferring data from OLTP to data warehouse using different data flow and control flow tasks in SSIS.
  • Created SSIS package to Export and Import data from SQL Server to Access, Text and EXCEL files and Configured SQL mail agent for sending mails upon package deployment.
  • Generated Crystal reports using SQL Server Reporting Services integrated and deploying them using web applications onto the SharePoint web servers in Data Modeling.

Confidential, San Jose, CA

MS SQL Developer

Responsibilities:

  • Involved in Data analysis and Data Profiling to analyze Data quality and plan approaches for Data cleansing and transformations.
  • Developed Technical Design specifications and Source to Target Mapping (STTM) specifications for each legacy system interface with Enterprise system.
  • Designed and developed physical and logical Data Models using Erwin and developed SQL Server Database objects including Tables, Views and Indexes.
  • Designed, developed and deployed complex DTS packages to cleanse and transform data and load from legacy systems into the Enterprise system SQL Server database.
  • Used advance features of T-SQL to design and tune T-SQL to interface with the databases and other applications in the most efficient manner.
  • Developed complex Stored Procedures and Functions and incorporated them in Crystal Reports to enable report generation on the fly.
  • Designed and implemented Job scheduling, setting up alerts, User logins and access rights based on user roles, permissions and security requirements.
  • Analyzed and designed disaster recovery and replication strategies based on business requirements.
  • Responsible for developing processes, automation of maintenance jobs, tuning SQL Server, locks and indexes configurations, administering SQL Server security, SQL Server automatic e-mail notification and SQL Server backup strategy and automation.
  • Tested to optimize the procedures and triggers to be used in production.
  • Prepared Documentation of the system.

Environment: SQL Server 2005/2000, MS-Access, DB2/UDB, ERwin7.1, VB Script, WIN2000/XP.

Confidential, Oaks, PA

MS SQL Server Developer

Responsibilities:

  • Involved in Installing SQL Server 2000 with latest service pack.
  • Extensively worked in creating Database, database objects such as view, table, stored procedure, trigger and function using T-SQL.
  • Performance tuning of stored procedure.
  • Wrote complex Join queries using T-SQL.
  • Created the Logical and Physical Data Model using Erwin tool.
  • Created DTS Packages to integrate the Business Logic and Data Transformations
  • Transformed data using DTS packages, BCP utility and Bulk Insert statement.
  • Created and saved DTS package according to requirements.
  • Performance tuning of server and gave suggestion to senior developer.
  • Created and managed index.
  • Involved in Performance Tuning activities including Query Tuning and Index Maintenance.
  • Monitoring the application and database performance using SQL Profiler and Performance Monitor
  • Used Index tuning wizard to get a better idea of implementing indexes on the existing databases
  • Created Database Maintenance Plans for Database Backups, Re-indexing and Data Integrity Checks
  • Created SQL Server Jobs and Schedules for automated and timely execution of Daily, Weekly and Monthly processes.
  • Created Windows Admin Scripts to monitor Disk and Tape Backups, Disk Space and Service Status for different servers and generate alerts.
  • Created SQL Server Agent Alerts to monitor the SQL Server Events and SQL Server Performance Alerts and notify the Administrators of the critical situations.
  • Created Triggers to monitor activities on server as well as database and generate alerts and notifications.
  • Created Stored Procedures, User-Defined Functions, Ad-hoc Scripts and Cursors on Development and Test servers for pre-deployment testing.

Environment: MS SQL Server 2000, Enterprise Manager, Query Analyzer, and System Monitor/Performance Monitor, Event Viewer, Database Maintenance Plan Wizard and Data Transformation Services, T-SQL, Third party Application, Windows 2003/2000 server, Window 2000

Confidential

SQL Server Developer

Responsibilities:

  • Extensively involved in installing and configuring SQL server 2000.
  • Transformed data using DTS packages, BCP utility and Bulk Insert statement as and when necessary.
  • Improved Performance of databases by analyzing Indexes, Fill Factor and Fragmentation issues
  • Monitored server critical issues including Response Delay, Locking/Blocking and Server Downtime.
  • Created Scripts to monitor Backups, Drive Space, Log Size, Database Size and Service Status monitoring.
  • Creation and Management of Jobs, Schedules and Sending Alerts using SQL Mail
  • Gained expertise in Security Issues by creating Users and granting Permissions on various Objects
  • Creation of Triggers to perform Data validations as well as Server level and Database level monitoring and Alert the users with the field status changes.
  • Created database and database objects such as index, Table, stored procedure, view, trigger and function using T-SQL.
  • Monitoring server performance by using Performance counter.
  • Created complex Stored Procedures and Cursors to support applications using T-SQL.
  • Prepared Estimates for Database Files and Table size growth. .
  • Generated Reports for the day-to-day as well as weekly/monthly purposes.
  • Created Distributed Partition views Using T-SQL.

Environment: MS SQL server 2000, Windows 2000, Enterprise manager, Query analyzer, DTS, SQL profiler.

We'd love your feedback!