We provide IT Staff Augmentation Services!

Sr. Sql Bi Consultant Resume

SUMMARY

  • Total 12+ years of IT experience with nearly 8 years exclusively as a Microsoft Business Intelligence Developer in Production, Development and Staging Environment.
  • Proficient in SQL Server 2000/2005/2008 suite of products, esp. Reporting Services (SSRS), Integration Services (SSIS), Analysis Services (SSAS).
  • Strong Communication and Management skills with Excellent Role playing capabilities.
  • Involved in Huge data migrations, transfers using utilities SQL Server Integration Services (SSIS), Bulk Copy Program (BCP), Bulk Insert and T - SQL.
  • Extensively involved in SSIS, SSRS, T-SQL, Procedures, Functions, Views and implement best practices to maintain Optimal Performance.
  • Experience in BI Development and Deployment of SSIS Packages from MS-Access, Excel, Oracle, Teradata, Flat Files etc.
  • Familiar with the principles and implementation of Data Warehouse with Fact Tables, Dimension Tables, Aggregations, Star & Snowflake schema.
  • Experience in Dimensional Data Modeling Star and Snow Flake Schemas.
  • Expertise in Designing and Deployment of Reports for the End-User requests using SSRS.
  • Expert in creating various reports with tables, matrix, sub-report, chart, parameters, expressions, drilldown, drill-through using SSRS.
  • Involved in the deployment process of SSIS, SSRS and MSSQL objects for different environment (SIT/UAT/PROD) and maintaining/monitoring on Higher to lower level environment server.
  • Experienced in programming tasks-Stored Procedures, Triggers, and Cursors using SQL Server 2008/2012 with T-SQL.
  • Good experience in writing MDX queries while creating and customizing Cubes using SQL Server Analysis Services (SSAS) 2005/2008.
  • Experience in working with SSAS in creating cubes, data source views, named queries, dimensions of analysis services projects.
  • Worked on optimization in T-SQL programming to optimize Stored Procedures, Functions/indexes.
  • Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
  • Very Good knowledge in SQL Jobs configuration, Database Performance/optimization tuning, index rebuilding and reorganize etc.
  • Working knowledge of databases like SQL Server, their integration with programming languages likeVB.NET, ASP.NET, C#.
  • Excellent T-SQL Developer skills including Stored Procedures, Indexed Views, User Defined Functions, Triggers, and Distributed Transactions.
  • Working knowledge of .Net Framework (VB.NET and C#), IIS Web Server.
  • Excellent record as a team player/leader with effective communication skills.
  • A highly motivated and energetic professional, dedicated to understanding and meeting client needs. Knowledgeable in project management tools, processes and techniques.

TECHNICAL SKILLS

Databases: SQL SERVER 2000/2005/2008/2012 , MS-Access, Teradata, Oracle 11g

Programming: VB.NET, C#, T-SQL

Operating System: Windows 2003/2012 Advanced Server, NT & Windows 7/8x

ETL Tools: SSIS, SSAS, SSRS 2008/2012, Crystal Reports

Web Tools: XML, ASP.NET

PROFESSIONAL EXPERIENCE

Confidential

Sr. SQL BI Consultant

Responsibilities:

  • Developed SSIS Packages to Load Claims, Provider, and Person Data from Third Parties.
  • Used T-SQL to Load/Transform Data from Third Parties
  • Defined and developed logical and physical data models to support business needs.
  • Created tables, stored procedures, views, User-Defined functions, indexes, partitions and other T-SQL code to support application development.
  • Developed stored procedures using T-SQL to suit Business Needs and for Auditing.
  • Developed complex SSIS mappings to facilitate daily, monthly and yearly loading of data.
  • Developed Adhoc Queries to meet the Business requirements and to validate the Process.
  • Involved in Data Completion and Data Accuracy of ETL process.
  • Designed and implemented database objects like Tables, Views, Index, Sequences, Functions and Stored Procedures in SQL Server 2008/R2/2012 and Oracle 11g.
  • Created ETL job to load the data into the Third Party Applications using SSIS.
  • Performed Unit/integration testing for the ETL jobs
  • Reviewing the ETLs and T-SQL Code developed by other Team Members
  • Involved Design and Development of Data Feed from legacy systems to CPDM application.

Confidential, CA

Lead SQL BI Analyst / Sr. SQL BI Consultant

Responsibilities:

  • Extracted data from various sources like SQL Server 2008/2012, Oracle, .CSV, Excel and Text file from Client servers and through FTP.
  • Actively involved in the development/deployment of Front-end and ETL packages in .NET, MS-SQL 2008, SSIS and SSRS.
  • Supporting project resource scheduling and capacity planning.
  • Provide regular and effective progress to work closely with Project managers.
  • Line management and personal development of a team of highly skilled developers.
  • Involved in formulate queries using T-SQL in meeting business needs.
  • Participate in reviews and meetings and provide updates on project progress.
  • Formulate implementation design/technical document and mapping document on business logic.
  • Work closely with team internally to ensure alignment of work within the project.
  • Benefitted handling brainstorming discussions design, development process and deployment of SSIS projects.
  • Supporting multiple projects and being responsible for coordinating with on-site.
  • Proactively associated with the business users to jointly come up with user requirements.
  • Formulated High Level Design reviews with business client and implementation of the Low Level Design documents.

Confidential

Lead SQL BI Analyst/ Sr. SQL BI Consultant

Responsibilities:

  • Actively involved in the development/deployment of Front-end and ETL packages in .NET and MSSQL Server 2008.
  • Involved in formulated queries in T-SQL in meeting business needs.
  • Formulate implementation design/technical document and mapping document on business logic.
  • Benefitted handling brainstorming discussions design, development process and deployment of SSIS projects
  • Supporting multiple projects and being responsible for coordinating with on-site.
  • Proactively associated with the business users to jointly come up with user requirements.
  • Formulated High Level Design reviews with business client and implementation of the Low Level Design documents.

Confidential

Sr. SQL Developer

Responsibilities:

  • Analyzing user requirements and preparing LLD based on the given HLD from Line of Business.
  • Involved in backend development, bug fixing and enhancements for this application.
  • Writing stored procedures, SQL Scripts for adhoc requirement from LOB.
  • Creating tables, and creating proper indices for performance optimizing of queries.
  • Preparing unit test cases and test plan to upload to Quality Center.
  • End to End handling of PCRs single handedly.
  • Monitoring jobs running night on daily basis and recovering the failed jobs within SLA time.
  • Co-coordinating with DBA while recovering jobs.
  • Daily verification of jobs and checking all production servers are in sync.
  • Successfully implemented ETL Packages to load data into TQ Servers from different sources.
  • Actively involved in the development of ETL Packages to load data.
  • Involved in training the new joiners and make them work ASAP on Confidential application.

Confidential

Sr. SQL Developer

Responsibilities:

  • Analyzing user requirements and preparing LLD based on the given HLD from Line of Business.
  • Involved in backend development, bug fixing and enhancements for this application.
  • Writing stored procedures, SQL Scripts for adhoc requirement from LOB.
  • Creating tables, and creating proper indices for performance optimizing of queries.
  • Preparing unit test cases and test plan to upload to Quality Center.
  • End to End handling of PCRs single handedly.
  • Monitoring jobs running night on daily basis and recovering the failed jobs within SLA time.
  • Co-coordinating with DBA while recovering jobs.
  • Daily verification of jobs and checking all production servers are in sync.
  • Successfully implemented ETL Packages to load data into SQL Servers from different sources.
  • Actively involved in the development of ETL Packages to load data.
  • Involved in training the new joiners and make them work ASAP on application.

Confidential, NY

Developer

Responsibilities:

  • Analyzing user requirements and preparing LLD based on the given HLD from Client.
  • Involved in front-end and backend development for this application.
  • Writing stored procedures, SQL Scripts for adhoc requirement from LOB.
  • Creating tables, and creating proper indices for performance optimizing of queries.
  • Preparing unit test cases and test plan to upload to Quality Center.
  • End to End handling of PCRs single handedly.
  • Monitoring jobs running night on daily basis and recovering the failed jobs within SLA time.
  • Co-coordinating with DBA while recovering jobs.
  • Daily verification of jobs and checking all production servers are in sync.
  • Successfully implemented ETL Packages to load data into SQL Servers from different sources.
  • Actively involved in the development of ETL Packages to load data.
  • Involved in training the new joiners and make them work ASAP on application.
  • Created Front-end pages using C#, ASP.NET.

Confidential

VB.NET & SQL Developer

Responsibilities:

  • Analyzing user requirements and preparing LLD based on the given HLD from Client.
  • Involved in front-end and backend development for this application using VB.NET.
  • Creating tables, and creating proper indices for performance optimizing of queries.
  • Preparing unit test cases and test plan to upload to Quality Center.
  • End to End handling of PCRs single handedly.

Hire Now