We provide IT Staff Augmentation Services!

Sr. Bi Consultant Resume

Fort Worth, TX

PROFESSIONAL SUMMARY:

  • Extensive experience as SQL Server and Microsoft Business Intelligence applications developer, Specialized as an ETL Developer with expertise in Analysis and Reporting Services.
  • Experience in Extracting, Transforming and Loading of Data from Excel, Flat file, S to MS SQL Server by using SQL Server Integration Services (SSIS).
  • Expertise with DDL and DML statements, RDBMS’s, data dictionaries and normal forms.
  • Good understanding and designing of Star and Snow Flake data models Schema used in relational, dimensional and multidimensional data modeling.
  • Profound knowledge and ability to write stored procedures, temporary tables, views, indexes, triggers when required and complex queries including correlated queries and queries with complex joins and aggregate functions.
  • Experience in Data Modeling (Logical and Physical Design of Databases), Normalization and building Referential Integrity Constraints. Designed schemas. Built tables, FKs, PKs, etc. by providing a structure that meets the business needs.
  • Used multiple transformations in SQL Server Integration Services to meet the business requirements by collecting data from various sources.
  • Migrated data in various formats like text based files, Excel spreadsheets, to SQL Server databases using SQL Server Integration Services (SSIS) to overcome the transformation constraints.
  • Experience in providing Logging, Error handling by using Event Handler, and Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
  • Experience in creating jobs, SQL Mail, Alerts and schedule SSIS Packages using SQL Server Agent. Maintain the records of the same and follow up.
  • Creating SSIS Packages and involved in Package configurations and deployments between Development and QA and Production servers.
  • Worked with T - SQL, DBCC, DCL, DDL, DML Scripts and established relationships between tables using Primary Keys & Foreign Keys.
  • Has knowledge on MDX queries with extensive experience in creating and customizing Cubes using SQL Server Analysis Services (SSAS) 2005/2008.
  • Excellent Knowledge in analyzing Data warehouse by building cubes using SQL Server Analysis Services (SSAS).Worked on multiple Star Schema’s.
  • Good understanding of Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.
  • Expert in creating parameterized reports, Drill down, Drill through, Sub reports, Linked reports, Snapshot, Cached, Adhoc reports using SSRS.
  • Excellent Analytical skills to understand the business process and Functionality, requirements and to translate them to system requirement specifications.
  • Ability to work with business and technical stakeholders to define and clarify scope and objectives.
  • Has a strong written and verbal communication skill.

TECHNICAL SKILLS:

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

RDBMS/Databases: MS SQL Server 7.0/ 2000/2005/2008 /2008 R2, 2014

SQL Server Tools: Management Studio (SSMS), Business Intelligence Development Studio (BIDS), Visual Studio 2005/2008/2010

ETL Tools: SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS)

Reporting Tools: SQL Server Reporting Services (SSRS)

Architecture: RDBMS, OLAP, OLTP

Data Modeling: Dimensional Data Modeling, Data Modeling, Star Join Schema Modeling, Snow-Flake Modeling, Fact and Dimension tables, Physical and Logical Data Modeling

Languages: C, T-SQL, Visual Basic 6.0

Application Packages: MS Office 2000/2003/2007/2010

PROFESSIONAL EXPERIENCE

Confidential, Fort worth, TX

Sr. BI Consultant

Responsibilities:

  • Extensively worked on SSIS packages to Extract, Transform and Load (ETL) data into the data warehouse database and then load to Data Marts by following the existing framework.
  • Created packages with different control flow options and data flow transformations such as Conditional Split, Multicast, Union all and Derived Column etc.
  • Developed multiple packages with parent child relationship by implementing package configurations, using project parameters and multiple variables.
  • Implemented Logging in all the packages
  • A separate database was maintained to capture logs and variables of the packages especially to capture the last run date which is most important for incremental loading, ensured that package design is made accordingly.
  • Created logic for Error Handling for capturing the Error records in a separate stage table which are moved to error schema tables in order to reprocess the data.
  • Used multiple look-ups to populate the data from different database sources to the destination database tables.
  • Scheduled jobs in Management Studio to execute the packages and monitored the jobs.
  • Created Tables, Views, Indexes, Stored Procedures and other T-SQL code and SQL joins during the design of packages.
  • Tuned SQL queries to upgrade SQL Server performance using SQL Server 2012.
  • Developed packages in TFS and deployed them to various environments post testing.  
  • Performed unit testing to ensure the package is working as expected.
  • Developed various types of reports like Drill down, Drill through and parameterized reports using SQL Server Reporting Services 2008 R2.
  • Inspected the reports and fixed bugs in stored procedures and also tuned Reporting Services to the T-SQL to generate multiple reports on regular basis.
  • Worked on the enhancements of the reports based on the business requirements by modifying the stored procedures, views related to reports.
  • Identified the business need and developed reports accordingly which are further used to populate dashboards.
  • Used Report Manager to deploy the applied changes to dashboards in various environments.
  • Created change tickets while working on the enhancements and attended the change meetings to get the changes approved and work based on the schedule.
  • Also worked on incident tickets assigned during production support whenever there was a need.

Environment: SQL Server 2008R2/2012, T-SQL, Business Intelligent technologies SQL Server Integration Services(SSIS), SQL Server Reporting Services(SSRS), SQL Server Analysis Services(SSAS), MS Access, MS Excel, windows 2003, Remedy Ticketing tool.

Confidential, Macon, GA

Senior BI Developer

Responsibilities:

  • Developed SSIS packages to Extract, Transform and Load (ETL) data into the data warehouse database from heterogeneous databases/data sources.
  • Created packages with different control flow options and data flow transformations such as Conditional Split, Multicast, Union all and Derived Column etc.
  • Created SSIS packages for File Transfer from one location to the other using FTP task with Master SSIS Package to run all other packages.
  • Implemented database standards and naming convention for the database objects and documentation of all the processes involved in maintaining the database for future reference.
  • Designed and built Star and Snowflake dimensional models creating facts, dimensions, measures, cube and established data granularity.
  • Created Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
  • Defined Check constraints, Business Rules, Indexes, and Views.
  • Design databases and apply normalization to minimize data redundancy.
  • Created multiple SSIS packages to move the data to Data warehouse where the business logics are applied and data is cleansed which is further used to develop reports.
  • Responsible for Deploying the SSIS packages to different environments and scheduling the package through Jobs in management studio.
  • Built MOLAP cubes for fast data retrieval and complex calculations.
  • Designed SSAS Cube and developed MDX queries for Analysis.
  • Modified complex chart reports to meet Business requirements.
  • Developed multiple drill down, drill through, parameterized reports to submit the daily/ weekly and monthly reports.

Environment: SQL Server 2008R2/2012 Enterprise Edition, SQL, T-SQL, Business Intelligent technologies SQL Server Integration Services(SSIS), SQL Server Reporting Services(SSRS), SQL Server Analysis Services(SSAS), Unix, Visual Studio 2008, MS Access, MS Excel,& Windows 2003 server.

Confidential, Moutain View,CA

Sr SQL/BI Developer

Responsibilities

  • Modified existing database by adding tables and relationships.
  • Designed and developed packages for data warehouse using SQL Server Integration services (SSIS) SQL Server 2005/2008. 
  • Designed and Created databases, tables, views, stored procedures and triggers.
  • Deploy SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.  
  • Implemented Event Handlers and Error Handling in SSIS packages and notified the process results to various user communities in the status meetings.
  • Designed, modified and troubleshoot SSIS packages.
  • Imported data from text files and excel spread sheets into SQL Server 2005 database using SSIS.
  • Responsible for Deploying the SSIS packages and scheduling the package through Jobs in all Tiers including Development.
  • Worked with T-SQL to create Tables, Views, and triggers and stored Procedures.
  • Experienced in Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Star Schema Modeling, Snow-Flake Modeling.
  • Created complicated reports like Parameter based Reports, Graphical Reports, Well-Formatted Reports, Drill-Down Reports, Matrix Reports, Chart and Tabular using SSRS.
  • Involved in Analyzing, designing, building and testing of On-Line Analytical Processing (OLAP) cubes with SSAS.
  • Knowledge in SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
  • Experience in creating Adhoc reports Using Report Builder 1.0 and Report Builder 2.0.

Environment: MS SQL Server 2000/2005/2008 , MS Access, Windows 2000/2003, XML, UNIX, SQL Server Integration, SQL Server Analysis Services(SSAS),Reporting And Analysis Services.

Confidential, Mountain View, CA

Senior BI Developer

Responsibilities:

  • Developed and optimized database structures, stored procedures, DDL triggers and user-defined functions
  • This involved index creation, index removal, index modification, file group Modifications and updating statistics in databases.
  • Performed data conversions from flat files into a normalized database structure.
  • Optimizing Stored Procedures and Managed indexes, statistics and tuned queries by using execution plan for optimizing the performance of the databases.
  • Created complex Stored Procedures, Triggers, Functions (UDF), Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards.
  • Created database maintenance planner for the performance of SQL Server, which covers Database integrity checks, update Database statistics and re-indexing.
  • Created packages to convert flat file to XML file.
  • Created cubes and dimensions (SSAS) for the analysis of sales in specific areas.
  • Configured mail tasks to know the job status of SSIS packages.
  • Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring and archived data files for different DBMS.
  • Good understanding of SSRS with Report authoring, created various weekly and monthly reports as per the requirement using Reporting Services.
  • Developed Report Models for building Adhoc reports using Crystal Reports. Developed optimal stored procedures and queries to create data sets for reports.

Environment: SQLserver 2000/2005/2008 , SQL Server Analysis Services(SSAS),Windows Server 2003/2008, HTML, XML, SQL Server Data Tools 2010, MS Access.

Confidential

SQL Developer

Responsibilities:

  • Worked on deriving technical specifications based on functional specifications.
  • Generated database monitoring and data validation reports in SQL Server Reporting Service (SSRS).Daily, weekly, monthly Reports are created and maintained.
  • Created partition table for very large database for good performance.
  • Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
  • Created new database objects like Sequences, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server.
  • 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.
  • Deployed SSIS packages and Reports to Production Servers.
  • Created Data warehouse Cubes in SQL Server Analysis Service (SSAS).
  • Migrated data using ETL Tool in SSIS, using multiple transformations.
  • Maintained system monitoring jobs and provide high availability support.
  • Worked on Migration of packages from DTS using SQL Server Integration Service (SSIS).
  • Created SSIS packages with which data resources are loaded daily in order to create and maintain a centralized data mart. Made the package dynamic so it fit the environment.
  • Performed data conversions from SQL server to flat file using SSIS. Created packages that implements tasks like Execute SQL Task, Data Flow Task etc.
  • Participated in Databases Architecture and data modeling design.
  • Performing DBA functions, installing, configuring and supporting database systems.
  • Reported all events and requirements through established reporting mechanisms in SSRS.
  • Reviewed and developed data models and database designs with development teams
  • Designed and developed OLAP using MS SQL Server Analysis Services
  • Designed and developed MS SQL Server Reporting Services(SSRS) under SQL Server 2005

Environment: MS SQL Server 2005/2008, SQL Server Reporting Services, SQL Server Integration Services, SQL Server Analysis Services, OLAP, SSIS, BIDS.

Confidential

Software Programmer

Responsibilities:

  • Monitoring all Servers around the world (North America, Asia Pacific, Europe and Africa) through monitoring tool -Netcool.
  • Perform activities as per the SOPs and make sure we adhere to the SLAs.
  • Monitoring & escalating of alerts with respect of vulnerabilities of type of alert, to concerned support groups.
  • Maintaining Good SLA throughout.
  • To deliver tasks assigned within agreed SLA.
  • Genuine commitment to quality and customer satisfaction.
  • Creating for better performance of Operations.
  • Creating / modifying SOPs and uploading a new approved SOP for operations in the Database.

Environment: SQL Server 2000/2005, Netcool, Microsoft Office, Windows 2003/XP.

Hire Now