We provide IT Staff Augmentation Services!

Sql/bi Consultant Resume

2.00 Rating

Naperville, IL

SUMMARY

  • 6 years of strong experience with demonstrated success in the Database Design, development and deployment of large - scale enterprise applications.
  • Expert in MS SQL Server 2008/2005/2000 suite of products like SSRS, SSAS, and SSIS.
  • Extensive knowledge in T-SQL queries (DDL and DML).
  • Highly proficient in the use of T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, Relational Database models and Data integrity, and SQL joins.
  • Good understanding of Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.
  • Hands on experience in developing Custom Reports and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
  • Experience in developing various kind of reports like Cascading parameters, Drill down, Drill through, Sub Reports and Charts.
  • Used DTS/Integration services (SSIS) to migrate data from one system to another and performed several transformations to ensure data integrity and validity.
  • Experience in building Data Integration, Workflow Solutions and Extract, Transform, and Load (ETL) solutions for data warehousing using SQL Server Integration Service (SSIS)
  • Developed ETL process using SSIS with various control flow, data flow tasks and store procedures for work order validation process.
  • Solid Knowledge in developing cubes using Partitions, KPI’s, and Perspectives, slow moving dimensions etc and created various user roles.
  • Extensively experienced in database activities like Maintenance and Performance Monitoring and Tuning using tools such as Index Tuning Wizard, SQL Profiler, Troubleshooting and Replication.
  • Configured and deployed SSRS reports onto Microsoft Office SharePoint Server 2007(MOSS).
  • Good hands on Performance tuning to optimize SQL queries using query analyzer.
  • Experience in creating jobs, alerts, SQL mail agent, and scheduling DTS packages.
  • Experience in creating dashboards, scorecards and building reports using performance point server 2007.
  • Proven experience in project and team leading with minimal defect delivery. Equally comfortable working independently as well as in a team environment
  • Excellent problem solving skills in fast paced environment.

TECHNICAL SKILLS

SQL Server/BI Tools: SQL Profiler, Query Analyzer, BIDS, Export & Import (DTS), SQL Server Reporting Services (SSRS), SQL Server Integrating Services (SSIS), SQL Server Analysis Services (SSAS)

Databases: MS SQL Server 2008R2/2008/2005/2000, MS Access

Languages: C, T-SQL, Visual Basic 6.0

Tools: Visual Studio 2005/2008/2010, Erwin 7.2

Application Packages: MS Office, MOSS 2007, PPS 2007

Operating Systems: Windows 2000/NT/XP, UNIX, Windows Server 2003

Architecture: RDBMS, OLAP, OLTP

PROFESSIONAL EXPERIENCE

Confidential, Naperville, IL

SQL/BI Consultant

Responsibilities:

  • Migrated DTS packages from SQL Server 2000 to SQL Server 2008 as SSIS Packages.
  • Created efficient, robust SSIS packages for data movement and loading with error checking and well documented code.
  • Created SSIS Packages to integrate data coming from Text files and Excel files.
  • Migrated old data from MS Access into SQL Server 2008 using SSIS Packages in Business Intelligence Development Studio.
  • Created SSIS packages (.dtsx files) using SSIS to validate, extract, transform and load data to data warehouse databases and data mart databases.
  • Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Derived Column.
  • Wrote stored procedures and User Define scalar Functions (UDFs) to be used in the SSIS packages and SQL scripts.
  • Built connections to/pulling data from AS400, mainframe/db2 and Oracle.
  • Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
  • Created numerous efficient Stored Procedures to perform data cleansing and loading task when data is loaded into staging area.
  • Generated test data andtested databaseto meet the functionalities deliverables in the project documentation and specifications.
  • Scheduled the Packages in SQL Server Agent on daily/weekly/monthly basis.
  • Deployed SSIS package into production environment and used package configuration to export various package properties to make package environment independent.
  • Document new SSIS packages and Train Senior Analyst on basic SSIS concepts.

Environment: SQL Server 2000(Enterprise Manager), Data Transformation Services (DTS), SQL Server 2008 Enterprise Edition, BIDS, Business Objects, Crystal Reports 8.0, XML, ASP.Net, Visual Basic 6.0.

Confidential, Bronx, NY

Senior SQL/BI Consultant

Responsibilities:

  • Created/Updated database objects like tables, views, stored procedures, function, packages,
  • Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
  • Developed tablix reports, chart reports, line reports, parameterized reports, sub reports using SQL Server Reporting Services 2008.
  • Designed reports using Pivot-tables, bar-charts, Line-charts and Pie-charts on data from cubes and SQL Server in Excel 2007.
  • Integration of SSRS Reports using various web parts into SharePoint and various delivery mechanisms.
  • Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
  • Deployed SSRS reports onto Microsoft Office SharePoint Server 2007(MOSS).
  • Designed and developed packages for data warehouse using Integration Services (SSIS) SQL Server 2008/2008R2.
  • Involved in providing ETL support for the production server.
  • Involved in creating SSIS jobs to automate the reports generation and cube refresh packages.
  • Enhanced the functionality of OLAP cube by creating actions and perspectives from huge dataset using SQL Server 2008 Analysis Services.
  • Created SQL Server Profiler traces & used with Database Tuning Advisor (DTA) for optimum performance of T-SQL.
  • Created logical and physical database design, data structures and maintained it by writing stored procedures, user defined functions, views, T-SQL script.
  • Optimize the database by creating various clustered, non-clustered indexes and indexed views.

Environment: SQL Server 2008 Enterprise Edition, BIDS, SSAS, SSIS, SSRS, T-SQL, MOSS 2007, MDX, ETL, VB.Net, ASP.Net, C#, Oracle 9i, Performance Point Server 2007, Erwin 7.2.

Confidential, Mt. Laurel, NJ

MS SQL Server Developer / BI Developer

Responsibilities:

  • Worked on extracting, transforming and loading data using SSIS Import/Export Wizard.
  • Created SSIS Packages to integrate data coming from Text files and Excel files.
  • Provided Full Reporting Life Cycle support using SQL Server Reporting Service 2008.
  • Developed Tabular Reports, Sub Reports, Matrix Reports, Drill down Reports and Charts using SQL Server Reporting Services (SSRS).
  • Created Query Parameters and Report Parameters to control data returned by the query and filter data at report level.
  • Created linked, unlinked and on-demand sub Reports.
  • Understood the various complex reporting requirements of company and created web reports using Reporting Services.
  • Developed tables, Views, Stored Procedures and Triggers using SQL Server Management Studio.
  • Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
  • Established Inner Join, Outer Join and created Indexes whenever necessary.
  • Modified report content and exported reports in multiple formats based on user input.
  • Developed logical and physical data models, design data access strategies and wrote SQL code to access and manipulate data stored in relational databases.
  • Experience in creating Multidimensional cubes using SSAS and designing DW schemas.
  • Involved in implementing Key Performance Indicator (KPI) Objects in SSAS 2008. Create Calculate member in MOLAP cube using MDX in SSAS 2008.
  • Scheduled the reports to run on daily/weekly/monthly basis and email the results to the users in the required format.
  • Created User Defined functions for sharing formulas across multiple reports.
  • Modified existing reports according to requirements of the end users.

Environment: MS SQL Server 2008, SQL Server Reporting Services (SSRS), MS Access, MS Excel, SSIS, BCP, T-SQL

Confidential, Long Beach, CA

MS SQL Server / SSIS/SSAS/SSRS Developer

Responsibilities:

  • Scheduled the packages to run automatically for incremental data and deploy them to their destination servers
  • Developed tables, Views, Stored Procedures, Functions, Indexes and Triggers using SQL Server Management Studio.
  • Understanding the OLAP processing for changing and maintaining the data warehouse, optimizing dimensions, hierarchies and adding aggregations to the cube.
  • Developed SQL scripts to insert, update and delete data in MSSQL database tables in OLTP environment.
  • Performed data consistency and performance tuning effectively with SQL Profiler, Index Tuning Wizard.
  • Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
  • Improved data load performance by analyzing database design and query plans.
  • Performed changes in the schema of the proposed database as required and informed those changes to the application development team.
  • Created numerous efficient Stored Procedures to perform data cleansing and loading task when data is loaded into staging area.
  • Documented different stages of data transformation, procedures and scripts.
  • Optimized the query performance with modification in T-SQL queries, removing unnecessary columns, eliminating redundant and inconsistent data, establishing necessary joins, creating useful clustered index and non-clustered indexes.

Environment: SQL Server 2005(Enterprise Manager, Query Analyzer, SQL Profiler, Index Tuning Wizard, Data Transformation Services (DTS), Crystal Reports 8.0, XML, ASP.Net, VB Script.

Confidential, Chantilly, VA

SQL BI Developer

Responsibilities:

  • Generated database monitoring and data validation reports inSQL Server Reporting Service (SSRS).
  • Createdpartition tablefor very large database for good performance.
  • Designed dynamicSSIS Packagesto transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
  • Responsible for writing SQL queries, stored procedures, views, triggers, T-SQL andDTS/SSIS
  • DeployedSSISpackages and Reports to Production Servers.
  • Involved in creation of Data warehouse Cubes inSQL Server Analysis Service (SSAS).
  • Migrated data using ETL Tool inSSIS.
  • Maintained system monitoring jobs and providehigh availability support.
  • Worked on Migration of packages from DTS usingSQL Server Integration Service (SSIS).
  • ParticipatedDatabases Architectureanddata modelingdesign.
  • Performing DBA functions, installing, configuring and supporting database systems.
  • Reported all events and requirements through established reporting mechanisms inSSRS.
  • Reviewed and developeddata models and database designswith development teams
  • Wrotestore proceduresfor some job automations.
  • Generated test data andtested databaseto meet the functionalities deliverables in the project documentation and specifications.
  • Designed and developed OLAP using MS SQL Server Analysis Services
  • Designed and developedMS SQL ServerReporting Services(SSRS)under SQL Server 2005

Environment:MS SQL Server 2005, SSRS, SSIS, SSAS, ProClarity,C#,ASP.NET, VB.NET, OLAP, Erwin 7.0, DTS/SSIS, BIDS.

Confidential

SQL Server Developer

Responsibilities:

  • Interacted with Team and Analysis, Design and Develop database using ER Diagram, Involved in Design, Development and testing of the system
  • Developed SQL Server Stored Procedures, Tuned SQL Queries( using Indexes)
  • Created Views to facilitate easy user interface implementation and Triggers on them to facilitate consistent data entry into the database.
  • Implemented Exceptional Handling
  • Worked on client requirement and wrote Complex SQL Queries to generate Crystal Reports
  • Creating and automating the regular Jobs.
  • Tuned and Optimized SQL Queries using Execution Plan and Profiler
  • Rebuilding Indexes and Tables as part of Performance Tuning Exercise
  • Involved in performing database Backup and Recovery
  • Worked on Documentation using MS word

Environment: SQL Server 2000, SQL, T-SQL, BCP, Visual Basic 6.0/5.0, Crystal Reports 7/4.5, ASP/VB.NET

Confidential

SQL Developer

Responsibilities:

  • Involved in the Data modeling, Physical and Logical Design of Database
  • Created tables, indexes, sequences, constraints, triggers and procedures.
  • Used DDL and DML for writing triggers, stored procedures, and data manipulation.
  • Designed stored procedures and triggers for automating tasks.
  • Defined Check constraints, Business Rules, Indexes, and Views.
  • Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
  • Tuned and Optimized SQL Queries using Execution Plan and Profiler
  • Helped in integration of the front end with the SQL Server backend.
  • Import & Export of data from one server to other servers using tools like Data Transformation Services (DTS)
  • Created DTS package to schedule the jobs for batch processing.
  • Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures
  • Configured Server for sending automatic mails to the respective people when a DTS process failure or success.
  • Performed development support, document reviews, test plan, integration of the system.

Environment: MS SQL Server 2000, T-SQL, DTS, BCP

We'd love your feedback!