We provide IT Staff Augmentation Services!

Sql/ Bi Developer Resume

White Plains, NY

Summary:

  • Over 8 years of professional experience on Design, Development and Maintenance of Database using tools of MS SQL Server 2008 R 2/ 2008/2005/2000 as a Developer.
  • Experienced in all the stages of SDLC and in the migration and up-gradation of databases.
  • In-depth understanding in client requirement Analysis, Physical and Logical design and development (using Erwin, normalization, and SQL Server Enterprise manager), Resource Planning, Coding, Debugging, Testing, Deployment, Support and Maintenance of business applications using SQL Server 2008/2005/2000 , DTS, SSIS, SSAS and SSRS.
  • Well versed in data Extraction, Transformation and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), DTS and Bulk Insert and Bulk Copy Program utility.
  • Well versed in creating Dynamic SSIS packages, using containers and variables, configuring the packages, and scheduling the packages.
  • Expert in designing complex reports like reports using Cascading parameters, Sub reports, Drill-Through Reports, Parameterized Reports and Report Models and ad-hoc reports using SSRS based on client requirement.
  • Designed and coded application components in an agile environment utilizing a test driven development approach.
  • Hands on experience in developing and deploying cubes with star and snow flake schemas using SQL Server Analysis Services involving multidimensional data and dimensional modeling.
  • Expert in Data Migration. Formulated data from legacy systems. Established cleansing, Mapping and enrichment.
  • Expert in TSQL, creating and using Stored Procedures, Views, User Defined Functions, implementing Business Intelligence solutions using SQL Server 2008/2005/2000 .
  • Expert in Installing, Upgrading and Configuring Microsoft SQL Server. Good Knowledge of writing Reports using Advent Geneva RSL.
  • Involved in Query Optimization and Performance Tuning using tools like SQL Profiler, Index Tuning Wizard and Database Engine Tuning Advisor
  • An enthusiastic and goal-oriented team player possessing excellent communication, interpersonal skills with good work ethics.

Skills set:

MS SQL Server 2008 R2/2005/2000 , SSRS, SSIS, SSAS, MS Office, FrontPage, C, C++, Visual Basic 6.0, ERWIN, UNIX, Windows 7/Vista/XP/2003/2000,.Net, Power Builder, Query Analyzer, T-SQL, PL/SQL, HTML, SQL Profiler, XML, EXCEL, ODBC, MS Visio 2003.

Projects Summary:

Confidential, White Plains, NY

SQL/ BI Developer

Confidential is the world's largest voluntary (nonprofit) health organization dedicated to funding blood cancer research and providing education and patient services.

Responsibilities:

  • Work with customers in gathering business requirements for data migration needs. Work with subject matter experts and project team to identify, define, collate, document and communicate the data migration requirements.
  • Perform Source system data analysis in order to manage source to target data mapping. Perform migration and testing of static data and transaction data from one core system to another.
  • Utilized Extract, Transform and Load process in SQL Server Integration Service (SSIS) to migrate databases from Heterogeneous data Sources (Excel and flat files) to a centralized destination.
  • Used various SSIS tasks such as Conditional Split, Merge Join and Derived Column on the data retrieved, Data conversion, OLE DB Command, performed Data Validation Checks during Staging, and then loaded the data into the Data warehouse.
  • Created and Designed Data Source and Data Source Views Using SQL Server Analysis Services (SSAS).
  • Created reports to retrieve data using Stored Procedures that accept parameters depending upon the client requirements.
  • Created functions and procedures in T-Sql involving complex joins, CTE and sub queries to check the integrity and consistency of data, for scrubbing of data to enable populating data into reporting tables.
  • Worked on updating some of the already existing data extraction store procedures for improving performance enhancement.

Confidential, Horsham, PA

T-SQL BI Developer

Confidential is a Number one Insurance Company. It provides health care to Members. The Goal of the Project is to convert the ICD-9 to ICD-10 Diagnosis Code and Create Extracts based on the Business needs.

Responsibilities:

  • Analyzing different user requirements and coming up with specifications for the various database applications.
  • Developing database applications which are automated. Planning and implementing capacity expansion in order to ensure that the company’s databases are scalable.
  • Worked on Two Data warehouse ADW/CDW. Running in Oracle and Worked on New Conversion on SQL Server 2008 R2 for make it more Interactive.
  • Analyzed mainframe db2 tables and migrated the Tabled in SQL Server 2008.
  • Worked as a developer in creating Stored Procedures, SSIS packages, triggers, cursors, tables, and views and other SQL joins and statements for applications.
  • Implemented the standard naming conventions for the fact and dimension entities and attributes of logical and physical model
  • Identifying issues with the database and resolving them. Installing and configuring the necessary components so as to ensure that the database is accessible.
  • Diagnosing and resolving database access and checking on performance issues.
  • Worked with integration services for transferring and reviewing data from heterogeneous sources like (Excel, CSV, flat file, Text Format Data).
  • Creates packages with different control flow options and data flow transformations such as Conditional Split, Multicast, Pivot and Union all.
  • Involved in checking Performance Tuning, Indexing, and Query Optimization. Used database consistency checks using DBCC Utilities.

Confidential, Syracuse, NY

T-SQL BI Developer

Confidential is a health insurance company. It provides health care services to members living in upstate New York. The goal of the project is to create, analyze and migrate the claim data from Mainframe System to SQL Server 2008 data warehouse, and create cost estimates for treatment categories and create reports that are currently on mainframe.

Responsibilities:

  • Worked with integration services for transferring and reviewing data from heterogeneous sources like (Excel, CSV, flat file, Text Format Data).
  • Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse which encompasses server name, database name, accounts, tables and direction of data flow, Column Mapping and Metadata.
  • Worked closely with Database Lead to design and implement database components in timely manner.
  • Responsible for Dimension Modeling using the data modeling tools like Erwin, MS Visio.
  • Implemented data mart, facts, dimensions, star schema and OLAP cubes using SQL Server Analysis Service.
  • Created calculated measures and dimension members using multi dimensional expression (MDX), mathematical formulas, and user-defined functions.
  • MS SQL Server database administration, including configure Scheduled Tasks for regular Database Backup and Maintenance Activities, create and modify tables, various clustered and non-clustered indexes, check constraints and functions.
  • Worked as a developer in creating Stored Procedures, SSIS packages, triggers, cursors, tables, and views and other SQL joins and statements for applications.
  • Performed DBA activities like scheduling db trace and analyzing the query performance on a daily basis, suggesting the team for improvements in query development, Monitoring the production database for performance issues and resolving the issues by improving the quality of SQL queries.
  • Assist junior programmers with scripts, SSIS projects, troubleshoot stored procedures and query optimization.

Environment: MS SQL Server 2008, XML, MS SQL Server Analysis Services 2008, MS SQL Server Integration Services, SQL Profiler, Windows XP.

Confidential, New York City, NY

Database SSIS/SSRS Developer

Net App is a $5 billion company and they are specialized in storage and data management solutions. The goal of the project was to create SLA reports for customer complaints, Warranty report and utilization of services by customers and also helped sales team to design the solutions based on existing customer’s information.

Responsibilities:

  • Actively participated in understanding of business requirements and creating technical specifications with business analyst, project manager, and end users.
  • Identified the data source and defining them to build the data source views. Developed invalid data identification process using pattern matching and automated their correction by defined business logics using SQL stored procedures and user defined functions
  • Wrote extensive data transformation process driven by mapping SQL tables using SQL routines in SSIS package tasks.
  • Designed and implemented tables, functions, stored procedures and triggers in SQL Server.
  • Created database objects like tables, views, indexes etc. Created and modified stored-procedures, triggers, cursors
  • Creates packages with different control flow options and data flow transformations such as Conditional Split, Multicast, Pivot and Union all.
  • Accommodated client's changing ranking rules requirement by storing rules in rules tables and created rules engine using dynamic SQL script driven rules SQL tables.
  • Created SSRS reports and hosting it in the web for the users. Created data dictionary and well documented all SQL processes for future reference and support.
  • Used execution plan to analyze stored procedure and individual SQL query to identify performance pitfall and tuned them by creating indexes, updating statistics, removing correlated sub-queries, and strategically de-normalizing SQL tables.
  • Optimized data load process using bulk load method, and multiple threads for parallel loading and Created data dictionary and well documented all SQL processes for future reference and support.
  • Ensure to adopt Quality Procedure for the team and continuously monitor and audit to ensure team meets quality goals.

Environment: MS SQL Server 2005, MS SQL Server Reporting Services 2005,XML, MS SQL Server Integration Services, MS SQL Server Analysis Services 2005,Windows XP.

Confidential, Chicago, IL

MS SQL Server /BI Developer

Confidential which deals with various products like Home Insurance, Auto Insurance, Business Insurance and Life Insurance. The scope of the project was to support SQL Server and Crystal reporting development for Property insurance claim utilization.

Responsibilities:

  • Created many complex Stored Procedures/Functions and used them in Crystal Reports directly to generate reports on the fly and Created crystal reports and hosting it in the web for the users.
  • Developed complex T-SQL code for the application. Worked in Enterprise Manager for job scheduling and batch queries. Planned Backup strategy based on projects requirements
  • Monitored performance and optimized SQL queries for maximum efficiency.
  • Implemented fine tuning of database objects and server to ensure efficient data retrieval.
  • Responsible for deploying the generated reports on the production environment after validating them in the QA environment and Debug the reports using Stored Procedures
  • Reviewed and analyzed technical and application related problems. Identified the data source and defining them to build the data source views
  • Involved with DBA for the maintenance of database and implementation Snapshot Replication. Developed administrative tasks of SQL Server of performing daily Backups and Recovery procedures.
  • Designed and implemented data access stored procedures and triggers for automating tasks.
  • Scheduled Job and alerts. Designed and implemented user log in and security.

Environment: SQL Server v7, SQL Server 2000, Win NT v4, Win 2000, Win 2003, Crystal Report 8.5 , MS SQLServer2000, MS Access, Query Analyzer, DTS, BCP, SQL Profiler, Import & Export Data, Windows 2000 Server.

Confidential, Naperville, IL

MS SQL Server Developer/SSRS Developer

Confidential is one of the biggest food manufacturing companies in North America. Confidential manufactures supplies to big retail companies like Wal-Mart, Target. The Scope of the project was to deliver SQL Server reports for forecasting and demand planning using the SSRS 2005.

Responsibilities:

  • Worked closely with system and database administrators to proactively monitor and manage the development and production environments to ensure efficient utilization of resources and maximum uptime.
  • Generated various Report models on Views (due to security issues) and deployed them on to the production reporting server and generated various ad-hoc reports.
  • Identified and worked with parameters for parameterized reports in SSRS 2005. Developed daily, weekly, monthly reports and published them on the company’s intranet.
  • Developed Stored Procedures, triggers, cursors, tables, constraints, views and other SQL joins and statements for applications.
  • Generated Reports using global variables, expressions and functions for the reports. Created drill-down SQL Server Reports using SSRS 2005. Designed and implemented stylish report layouts
  • Tested applications for performance, data integrity, validation issues, job scheduling and alerts.
  • Designed and implemented data access stored procedures and triggers for automating tasks.
  • Scheduled Job and alerts. Designed and implemented user log in and security.
  • Created many complex Stored Procedures / Functions and used them in Crystal Reports directly to generate reports on the fly and Created crystal reports and hosting it in the web for the users.

Environment: MS SQL Server 2005, MS SQL Server Reporting Services 2005, MS SQL Server Analysis Services 2005, Oracle 8i, Windows XP.

Confidential

MS SQL Server Developer

Confidential is a multispecialty hospital specialized in gynecology, cardiology, ENT, Anesthesia and pediatrics. The scope of the project was to work in design, development and implementation and testing of hospital management system using SQL Server. Some of the modules include outpatient, in-patient and pathology, which include patient registration, occupancy details and billing etc.

Responsibilities:

  • Administration of MS-SQL Server 2000. Login and User Management: Added logins, roles, groups to the Window NT and MS SQL Server and maintaining proper security procedures.
  • Scheduled Jobs and Alerting using SQL Server Agent. Involved with DBA to create & manage the Database Users, Login Ids and Security.
  • Created database objects like tables, views, indexes etc. Created and modified stored-procedures, triggers, cursors.
  • Wrote T-SQL queries for the retrieval of the data. Wrote stored Procedures with Secure Coding Principles.
  • Involved in checking Performance Tuning, Indexing, and Query Optimization. Used database consistency checks using DBCC Utilities.
  • Involved with DBA for the maintenance of database and implementation Snapshot Replication. Developed administrative tasks of SQL Server of performing daily Backups and Recovery procedures.
  • Wrote distributed queries for Linked Servers. Good exposure in running jobs in Enterprise Manager using job-scheduling tool.

Environment: MS SQL Server 2000 Enterprise Manager, Query Analyzer, T-SQL, VB Script, Windows NT/2000

Hire Now