We provide IT Staff Augmentation Services!

Bi Developer Resume Profile

Chicago, IL

Objective:

  • Summary Of expertise:
  • expand my knowledge gains and growth within an organization.
  • I am pursuing a career in Information Technology that utilizes my experience while opportunity to
  • Over 7 years of Professional experience in Information Technology and over 6 years in database design, development of MS SQL SERVER 2000/2005/2008/2008 R2 with Business Intelligence tools SQL MS Server Reporting Services SSRS , MS SQL Server Integration Services SSIS
  • Expert in creating Parameterized Reports, Drill through and Drill Down reports, Tabular reports, Linked Reports, Sub-Reports using MS SQL Server Reporting Services.
  • Ability to prioritize and complete multiple tasks and detail oriented, quick learner, self driven, strong team player, hard worker. Willing to take responsibilities
  • Strong working knowledge in Reporting Services Architecture, Report Designer, Report Builder, Report Manager, Scheduling report and Publishing a Report.
  • Strong working knowledge of Microsoft SQL Server with skills in query writing and performance tuning.
  • Strong working knowledge of Data Visualization in SSRS.
  • Execute data mining techniques for advanced analysis of data and report generation.
  • Experience in Installing, Upgrading, managing, configuring, migrating and troubleshooting MS SQL Server
  • Worked extensively on TSQL Code, including complicated joins and cursor loops, creating indexes for fast retrieval of data, creating views, indexes, triggers, cursors, stored procedures and functions.
  • SQL performance tuning by modifying SQL or adding/changing indexes.
  • Actively involved in Normalization 3NF De-normalization of database.
  • Support an internal team of Developers, Designers and test engineers
  • Experienced with all phase of Software Development Life Cycle SDLC involving Systems Analysis, Design, Development and Implementation.
  • Experience with large-scale relational databases
  • Good Knowledge of normalization/de-normalization of database tables , developing DDL and DML and building referential integrity for the RDMS
  • Performs database development and maintenance tasks.
  • Designs and develops databases structures, scripts, transformation ETL scripts and common components
  • Good understanding of ACID properties, Locks, Recovery model
  • Good knowledge of making SSAS Cubes and can writes MDX query as well
  • Understanding of data warehousing concepts such as Cubes, Fact Table,

Dimensions Table, OLTP, OLAP

  • Experience in writing SQL Queries, TSQL, Stored Procedures, Views, Functions, Indexes, and database Triggers.
  • Experience in designing and developing SSIS packages for loading data from Oracle, text files, Excel, Flat files to SQL Server database.
  • Good understanding of developing Star Schema, Snow flake Schema and Dimensional Data modeling using MS SQL Server Analysis Services SSAS on a Data Warehouse.
  • Expert in creating packages for migration of the data from one source to different destination using SSIS and Handling error with Event handler using SSIS
  • Experience in the design, development and implementation of RDBMS using MS SQL and using oracle 8i/9i as well.

Technical Skill:

Operating Systems

Windows Server 2000, Windows NT Server, Windows Server 2003, Windows XP, Windows 2008, Unix, Linux,

Databases

SQL Server 2008 R2, SQL Server 2008, SQL Server 2005, SQL Server 2000, MS Access, ORACLE 10g/11g, MySQL

Database Tools

Business Intelligence Development Studio, SQL Server Integration Service SSIS , SQL Server Reporting Service SSRS , SQL Server Analysis Service , SQL Server Management Studio

ETL Tools

SQL Server Integration Service SSIS , Informatica , ab-natio

Languages

SQL, T-SQL, PL/SQL,C , .NET, Java, HTML, JavaScript, Jquery, PHP, XML

Reporting Tools

SQL Server Reporting Service SSRS , Cristal Report

Office Tools

MS WORD, MS EXCEL, MS VISIO, MS Project and MS Power Point 2003,2007,2010

Work Summary

BI Developer

Confidential

Responsibilities

  • Generated Drill down, Drill through, Matrix Reports, and Parameterized reports using expressions to calculate, group, filter, and parameterize report using SSRS.
  • Review reporting outputs for transparency, consistency, and accuracy.
  • Developed functions, triggers, stored procedures, views, tables, and SQL scripts to meet the requirements of the business users and application development.
  • Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
  • Developed Strored Procedures for the DataSet to build the reports for the client requirements.
  • Created SQL Joins, sub-queries and other SQL code to implement business rules.
  • Performance tuning, and optimization of procedures and queries.
  • Used DBCC commands for Database maintenance Rebuilding Indexes .
  • Installation and configuration of SQL Server 2008 R2
  • Designed and developed SSIS Packages .dtsx files to import and export data from MS Excel, SQL Server 2008 and Flat files.
  • SSIS packages to update tables with monthly data and automated it through scheduled jobs for the beginning of every month.
  • Created reports using stored procedure. Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2008 R2.
  • Designed packages which utilized tasks and transformations such as Execute SQL Task, Data Flow Task, Sequence Container, For Each Loop Container, Lookup, Aggregate and Derived Column.
  • Developed packages in SSIS with error handling.
  • Created Package Configurations to deploy packages from development to production server.
  • Successfully managed Extraction, Transformation and Loading ETL process by pulling large volume of data from various data sources using BCP in staging database from MS Access, excel.
  • Involved in creating report models and applying row level security filters for report model.
  • Experienced in participating meetings with business users to gather the requirements.
  • Involved in the analysis of existing database structures and creating the new tables and views as per the requirements.
  • Worked with development teams in the design of physical databases and in modification.

Environment: MS SQL Server 2008/2008R2, SQL Server Integration services SSIS , SQL Server Reporting Services SSRS , SQL Server Analysis Services SSAS ,T-SQL,,Microsoft Office 2010, OLAP, MS Visio.

SQL Server Developer

Confidential

  • Created User Defined Functions, Views, stored procedures as per business requirements
  • Optimized the performance of queries with simplifying queries like removing unnecessary columns, eliminated redundant and inconsistence data
  • Created SSIS packages to integrate data from text files and excel files and file Transfer from one location to the other using FTP tasks
  • Performed Normalization and De-Normalization techniques from both OLTP and OLAP system in creating Database objects
  • Used control flow tasks like For Loop Container, For each Loop Container, Sequential Container, Execute Tasks, Email task and different Data Flow Tasks
  • Worked on Transforming and Loading data using SSIS Import/Export wizard
  • Developed Tabular Reports, Sub-Reports, Matrix Reports, Drill down Reports and charts using SSRS
  • Performed sorting, formatting and grouping to custom reports in SSRS and also published reports to the report server virtual directory
  • Involved in designing and creating Databases, Tables, Views, Stored Procedures and Triggers
  • Hands on experience with developing reports using SSRS
  • Interacted with Developers in troubleshooting application and Report Developing
  • Created SSIS Packages using Fuzzy Lookup, Derived Columns, Pivot Transformation, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse
  • Tuned several slow running queries in Production. Implemented Indexes to achieve time performance

Environment:

SQL Server 2005/2008, Windows 2003/XP, Enterprise Manager, SSIS, SSRS, SSMS, SQL Profiler, T-SQL

Database Developer

Confidential

  • Responsible for optimizing queries for reports which take longer time in execution with SQL Server 2008/2005.
  • Created Complex ETL Packages using SSIS to extract data from OLTP database to staging tables to partitioned tables with incremental load.
  • Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into SQL Server Database.
  • Developed, deployed, and monitored SSIS Packages.
  • Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source Oracle , Excel Spreadsheet to SQL Server 2005/2008.
  • Performed operations like Data reconciliation, validation and error handling after Extracting data into SQL Server.
  • Worked on SSIS Package, DTS Import/Export for transferring data from Database Oracle and Text format data to SQL Server.
  • Worked with production Support Team to Hot Fix the critical Issues.
  • Involved with Transact SQL T-SQL Coding, writing queries, functions triggers.
  • Design and normalize the databases and created different objects like tables, views, Stored Procedures, UDF's, indexes rules and defaults on MS SQL server.
  • Created complex SQL queries using table joins inner and outer , temporary tables and table variables.
  • Developed Reports, Sub Reports, Parameterized reports, drilldown reports and various features using SQL Server Reporting Services SSRS .
  • Experience in deploying and scheduling the reports based on quarter, month, and year reports.
  • Enhanced reports by the charts and graphs using Microsoft SQL Server Reporting Services SSRS .
  • Developed, monitored and deployed SSIS packages.
  • Worked on Excels to upload the data from excels to database.
  • Responsible for implementation of data viewers, error configurations for error handling of the packages.
  • Optimized long running Stored Procedures and Queries for effective data retrieval.
  • Optimized queries by looking at Execution Plan for better tuning of the database.
  • Experience in developing ETL packages with the different sources as Flat Files, Excel, Text files, and XML files and migrating the data into destination using SQL Server Integration Services SSIS .
  • Handlers in SSIS packages
  • Implemented Event Checkpoints to rerun the failed package from the point of failure.
  • Responsible for creating user groups and assigning permissions.
  • Created DTS packages to transfer objects from development server to production.
  • Provided analysis and recommendations for setting up a comprehensive Backup and Recovery Strategy for SQL Servers.

SQL Server Developer

Confidential

Responsibilities

  • Design and normalize the databases and created different objects like tables, views, Stored Procedures, UDF's, indexes rules and defaults on MS SQL server.
  • Involved with Transact SQL T-SQL Coding, writing queries, functions triggers.
  • Created complex SQL queries using table joins inner and outer , temporary tables and table variables.
  • Developed Reports, Sub Reports, Parameterized reports, drilldown reports and various features using SQL Server Reporting Services SSRS .
  • Experience in deploying and scheduling the reports based on quarter, month, and year reports.
  • Enhanced reports by the charts and graphs using Microsoft SQL Server Reporting Services SSRS .
  • Developed, monitored and deployed SSIS packages.
  • Worked on Excels to upload the data from excels to database.
  • Responsible for implementation of data viewers, error configurations for error handling of the packages.
  • Optimized long running Stored Procedures and Queries for effective data retrieval.
  • Optimized queries by looking at Execution Plan for better tuning of the database.
  • Experience in developing ETL packages with the different sources as Flat Files, Excel, Text files, and XML files and migrating the data into destination using SQL Server Integration Services SSIS .
  • Handlers in SSIS packages
  • Implemented Event Checkpoints to rerun the failed package from the point of failure.
  • Responsible for creating user groups and assigning permissions.
  • Created DTS packages to transfer objects from development server to production.
  • Provided analysis and recommendations for setting up a comprehensive Backup and Recovery Strategy for SQL Servers.
  • Setup and maintained Linked Servers.

Environment: MS SQL Server 2008/2005, SQL Server Integration Services SSIS , SQL Server Reporting Services SSRS , Business Intelligence Development Studio BIDS , MS Excel, Windows XP.

System Administrator

Confidential

  • Diagnose hardware and software problems, and replace defective components.
  • Perform data backups and disaster recovery operations.
  • Maintain and administer computer networks and related computing environments, including computer hardware, systems software, applications software, and all configurations.
  • Plan, coordinate, and implement network security measures in order to protect data, software, and hardware.
  • Operate master consoles in order to monitor the performance of computer systems and networks, and to coordinate computer network access and use.
  • Perform routine network startup and shutdown procedures, and maintain control records.
  • Design, configure, and test computer hardware, networking software and operating system software.
  • Recommend changes to improve systems and network configurations, and determine hardware or software requirements related to such changes.
  • Confer with network users about how to solve existing system problems.
  • Monitor network performance in order to determine whether adjustments need to be made, and to determine where changes will need to be made in the future.
  • Train people in computer system use.
  • Load computer tapes and disks, and install software and printer paper or forms.
  • Gather data pertaining to customer needs, and use the information to identify, predict, interpret, and evaluate system and network requirements.
  • Analyze equipment performance records in order to determine the need for repair or replacement.
  • Maintain logs related to network functions, as well as maintenance and repair records.
  • Research new technology, and implement it or recommend its implementation
  • Maintain an inventory of parts for emergency repairs.
  • Coordinate with vendors and with company personnel in order to facilitate purchases

Hire Now