We provide IT Staff Augmentation Services!

Sr. Microsoft Bi Consultant Resume

0/5 (Submit Your Rating)

Philadelphia, PA

SUMMARY

  • Over 7+ years of IT experience with a strong emphasis on MS - Business Intelligence experience using SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS) and SQL Server Analysis Services (SSAS).
  • Experience with SSIS performance tuning using counters, error handling, event handler, re-running of failed SSIS packages using checkpoints and scripting with Active-X and VB.NET in SSIS.
  • Involved in migration from MS SQL Server 2000 to SQL Server 2005, DTS to SSIS, running and scheduling SSIS packages, Fuzzy Look-up for cleaning bad data, validating data using SSIS wizard
  • Experience in developing MDX queries and OLAP cubes using SSAS.
  • Experience in version control tools such as Microsoft Visual Source Safe, Team foundation server (TFS) etc.;
  • Experienced in MS Analysis Services (SSAS) programming for Data Warehouses (Schemas), Proficiency in data warehousing techniques for data cleaning, Slowly Changing Dimension phenomenon surrogate key assignment and CDC (change data capture).
  • Sound knowledge of Dimensional Modeling using Star Schema and Snow Flake Schema for faster, effective querying and Business Analysis Requirements.
  • Expertise in generating reports using Performance Point Server, Crystal Reports, Tableau Reports, SQL Server Reporting Services and Excel spreadsheet.
  • Knowledgeable in planning and implementing SQL Server Security and Database Permissions.
  • Experience in designing Database Models using MS Visio and ER-win.
  • Good knowledge in developing and implementing Disaster Recovery Model, and Replication Models.
  • Expert in creating dashboards/scorecards using ProClarity, SSRS etc.;
  • Expert in extracting and transforming data using DTS Import Export Data, SSIS/DTS Packages, Bulk Insert and BCP
  • Implemented Microsoft Business Intelligence by using platforms including Performance Point Server 2007. Designed Scorecards and Dash board reports using Performance Point (ProClarity).
  • In-depth knowledge of Transact-SQL DDL and DML, Stored procedures, Indexes, Views, Synonyms, Joins, Sub queries, CTE's, Derived Tables & User defined functions
  • Have strong analytical, administration and problem-solving skills dedicated to maintain the high quality standards. Good communication skill, ability to work independently.

TECHNICAL SKILLS

Database /Utility Tools: SQL Profiler, SQL Query Analyzer, Management studio, Index Analyzer, DTS Import/Export, Backup Server, Replication server, SQL Agents, SQL Alerts, SQL Jobs, Visual Source Safe 2005.

ETL Tools: DTS (Data transformation services),SQL Server Integration Services(SSIS), SQL Server Analysis Services, OLAP cubes

Reporting Tools: SQL Server Reporting Services (SSRS), ProClarity 6, Crystal reports 8.0/9.0/10.0 , MS Excel, Performance Point Server, Tableau.

Languages: SQL, MDX, DMX, ASP .Net 2.0,3.5 C ++, C#, JavaScript, HTML

Operating Systems: Windows 98/2000/XP/NT/Vista, Windows 2000/2003 Servers, UNIX.

Databases: SQL Server 2008 R 2/2008/2005/2000/7.0/6 , MS Access

Others: SharePoint Server 2007, Windows SharePoint Server(WSS) 2003

PROFESSIONAL EXPERIENCE

Confidential, Philadelphia, PA

Sr. Microsoft BI Consultant

Responsibilities:

  • Responsible fortranslating user & business requirements into functional and technical requirements.
  • Designed end-to-end ETL process to load the data from client extracts into data warehouse
  • Experience working with SXC claims adjudication processing system.
  • Responsible for translating the data from MEDCOPALand Supplemental files into D.0 layout
  • Recommended necessary changes to the existing data model, to be able to maintain raw history claims and processed claims data for reconciliation.
  • Responsible for developing mappings both PAL & Supplemental files to be able to load the data into casted claims and Catalyst data warehouse using SSIS Packages.
  • Optimized the performance of various SQL scripts, stored procedures and triggers by using embedded UDFs, CTEs and System stored procedures.
  • Create joins and sub-queries for complex queries involving multiple tables.
  • Used DDL and DML for writing triggers, stored procedures, and data manipulation.
  • Creating Triggers, Stored procedures, Tables and queries. Import and export of SQL objects from and to various sources.
  • Well versed in creating Dynamic SSIS packages, using containers & variables, configuring and scheduling the packages.
  • Deployed the SSIS Packages from development server to production server.
  • Implemented the Master Child Package Model for easier maintenance and better performance of SSIS Packages.
  • Configured SQL Mail agent for sending Automatic emails when a SSIS Process is Failed or Success
  • Involved in SSIS Performance Tuning Using Counters, Error handling, Event handling
  • Involved in user requirement gathering to find the exact specifications for the SQL reports.
  • Generated custom and parameterized reports using SSRS
  • Configuration and Deployment of all the Reports(RDL,RDS) across various SDLC environments
  • Actively involved in developing Complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs
  • Worked with cubes in creating hierarchies for dimensional tables like date dimensions and region dimension tables using SSAS.
  • Active part in building Star schema and Snow flake schema based on the business requirements.
  • Configured and managed data sources, data source views, cubes, dimensions, roles and hierarchies.

Environment: MS SQL Server 2005/2008/2008 R2, SSIS 2005/2008/2008 R2, SSRS 2005/2008/2008 R2, MS Visual Studio.Net 2005, Visio, Windows Server 2003, TFS 2008.

Confidential, Orlando FL

Sr. Microsoft BI Consultant

Responsibilities:

  • Experience working with Student Access Data such as student grades, Tests Scores, student schedules, Enrollments.
  • Created functional requirement specifications and supporting documents for business systems.
  • Designed and optimized indexes, views, stored procedures and functions using T-SQL
  • Developed complex Stored Procedures, Triggers, User Defined Functions based on the requirement
  • Monitored time taking queries with Performance Tuning to reduce the execution time
  • Development of dynamic SSIS packages for importing and exporting student data files to Florida State’s Department of Education (DOE Server).
  • Designed and developed efficient packages for processing Fact and Dimension tables with complex transforms and using Procedures.
  • Involved in designing of Star, Snowflake schemas and dimensional data models.
  • Developed SSIS packages for transferring and reviewing data from multiple flat files
  • Involved in replicating the Student Access database
  • Involved in user requirement gathering to find the exact specifications for the SQL reports.
  • Configuration and Deployment of all the Reports(RDL,RDS) across various SDLC environments
  • Created Parameterized reports, Cross-Tab reports, Drill down reports & Summary reports for Progress Book using SSRS.
  • Actively involved in developing Complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs

Environment: MS SQL Server 2005/2008/2008 R2, SSIS 2005/2008/2008 R2, SSRS 2005/2008/2008 R2, MS Visual Studio.Net 2005, Visio, Windows Server 2003, TFS 2010, Tableau Pro 6.0.2, Tableau Desktop.

Confidential, Atlanta GA

Sr. Microsoft BI Consultant / Tableau Developer

Responsibilities:

  • Designing Data Model and implementing changes in the earlier phase of the project to accommodate business logic and dynamic nature of the front end application.
  • Involve in Business requirement gathering, Technical Design Documents, Business use cases and Data mapping.
  • Experience working with Freight and Small Business data.
  • Experience working with Growth Volume and Revenue data.
  • Designed and developed efficient packages for processing Fact and Dimension tables with complex transforms and using Procedures.
  • Experience working with development of complete Life Cycle including Design, Development and Testing.
  • Responsible for logical and the physical design of the data mart for the use reporting services with the use of the OLTP Roster Database in SQL Server 2005
  • Extensive experience working with T-SQL involving the development of complex queries, stored procedures, views, triggers, CTE's, and user-defined functions
  • Designed and developed efficient packages for processing Fact and Dimension tables with complex transforms and using Procedures.
  • Configured SQL Mail agent for sending Automatic emails when a SSIS Process is Failed or Succeed.
  • Involved in SSIS Performance Tuning Using Counters, Error handling, Event handling,
  • Extensive Experience working with Tableau desktop and Tableau Server.
  • Experience working with Geo Maps in Tableau.
  • Involved in publishing the Dashboards on the Tableau Server and print the workbooks in to pdf are using Perl Script.
  • Created complex dashboards using Tableau sheets for Growth Volume, Revenue, and Volume by Product, Profit and international Profit Data.
  • Experienced working with Action filters, Grouping and creating Sets as filters in tableau workbooks.
  • Used Tableau desktop for testing the large volume and revenue data for Freight and Small Business.
  • Experience working with data sources such as Microsoft SQL Server, Access, Cubes, Excel Sheets, Flat Files etc for tableau desktop.
  • Generated tableau reports for Monthly and Quarterly data.
  • Experienced working with Dundas for SSRS.
  • Created Cross-Tab, Drill-down and Sub-Report using RDL and promoted to SSRS.
  • Used Visual Source Safe as source control.

Environment: MS SQL Server 2005/2008, SSIS 2008,SSRS 2005/2008, MS Visual Studio.Net 2005, Visio, Windows Server 2003, Microsoft Visual SourceSafe 6.0, Tableau Pro 6.0.2, Tableau Desktop.

Confidential, Indianapolis IN

Sr. Microsoft BI Consultant / Tableau Developer

Responsibilities:

  • Involved in Business requirement gathering, Technical Design Documents, Business use cases and Data mapping.
  • Create tables, views, clustered & non-clustered index, user defined data types, and user defined functions. Created stored procedures and triggers for database transactions in SQL Server.
  • Involved in creating SSAS cubes for the reporting source for creating Tableau Reports.
  • Created reports utilizing Business Intelligence tools like Tableau against Data Warehouse and Data cubes
  • Designed and Developed Web and Excel Tableau Reports.
  • Experience Configuring and Publishing Tableau workbooks across the environments
  • Created SSRS reports for Business Units like Oncology, Diabetes, Bio-Medicines and Emerging Markets.
  • Create new standard SSRS reports (or in corporate into existing reports) data related to capital investments, MS&T projects, external portfolio..
  • Expertise in creating Ad-hoc reports with Report models and explained end users how to use it in the Report Builder using SSRS 2005/2008.
  • Integrated Reporting Services with Microsoft Office SharePoint Services for central delivery and management of business insight.
  • Experienced writing Test Scripts to the given Test Cases for the testing and Data Validation of the reports.
  • Used Performance Point Server to provide users with rich dashboard filters to dynamically filter all the report views displayed on the dashboard.
  • Created SSIS Packages to import and export Enrolment and History Data from different Medical SAD staging data sources to data warehouse.
  • Experienced in Building Cubes and Dimensions with different architectures and Data Sources for Business Intelligence using SSAS 2005/2008.
  • Good knowledge in calculating KPI’s, Measure and Dimension members using MDX, mathematical formulas and user defined functions.
  • Involved in creating SSAS cubes for the reporting source for creating Tableau Reports.
  • Created reports utilizing Business Intelligence tools like Tableau against Data Warehouse and Data cubes
  • Designed and Developed Web and Excel Tableau Reports
  • Worked with cubes in creating hierarchies for dimensional tables like date dimensions and region dimension tables using SSAS.
  • Experience working with Team Foundation Server as the source for version control and project issue management.

Environment: MS SQL Server 2005/2008, SSIS 2008,SSRS 2005/2008, MS Visual Studio.Net 2005, Visio, Windows Server 2003, Visual Studio TFS 2005/2008, MOSS 2007, IIS 6.0.

Confidential, Wilmington, DE

Sr. Microsoft BI Consultant

Responsibilities:

  • Responsible for logical and the physical design of the data mart for the use reporting services.
  • Developed database objects such as SSIS Packages, Tables, Triggers, and Indexes using T-SQL, SQL Analyzer and Enterprise Manager
  • Configure the SSIS Package for run time Parameters.
  • Gathered user requirements to develop the business logic and analyzed and designed software and database solutions
  • Designed and Developed Web and Excel Tableau Reports
  • Helped designing and implementing processes for deploying, upgrading, managing, archiving and extracting data for reporting
  • Wrote complex queries for the drill down reports
  • Scheduled and monitored all maintenance activities of SQL Server 2005 including database consistency checks and index defragmentation
  • Created Parameterized, matrix and drill down reports using SSRS 2005
  • Develop the Documents for Logging/Error Handling for SSIS Packages
  • Integrate the SSIS package, converting all existing DTS packages of MS SQL by adding extra SSIS task.
  • Handling the orphan rows in Dimension and Fact tables.
  • Experience in Developing and Extending SSAS Cubes, Dimensions and data source views SSAS-Data Mining Models and Deploying and Processing SSAS objects.
  • Used Open Query from SQL Server the SSAS Server to combine data from SSAS cube and DW database.
  • Responsible for the deployment of the Cube on the SSAS.
  • Designed reports in SSRS with the use of data from SSAS cube (MDX) and DW database.
  • Designed and modeled Microsoft SQL Server 2005 data warehouse and data marts, including the modification of existing Microsoft SQL Server 2000 data warehouse and data marts.
  • Schedule execution of reports in report manager and send them to managers on daily and weekly basis.
  • Participated actively in analysis and discovery phases of data warehouse implementation.
  • Perform T-SQL tuning and optimizing queries for Reports which take longer time in execution SQL Server 2005.
  • Extensive work on SSIS creating all the interfaces between front end application and SQL Server 2005 database, then from legacy database to SQL Server Database and vice versa.

Environment: MS SQL Server 2008/2005, SSIS/SSRS/SSAS, ProClarity, Microsoft Visual Source Safe, Windows Server 2003.

Confidential, Atlanta, GA

Sr. Microsoft BI Consultant

Responsibilities:

  • Designed and analyzed the Statement of Works, created layouts for the exports.
  • Created SSIS packages for importing the Excel layouts into the database using SSIS.
  • Used SQL BIDS to design SSIS packages to transfer data between servers, load data into database, and archived data file from different DBMS. Scheduled the job to do this task periodically.
  • Loaded data from ODS to Data Warehouse using SSIS packages.
  • Ensured all artifacts complied with corporate SDLC Policies and guidelines.
  • Worked with development teams in the design of physical databases and in modification
  • Improved data load performance by analyzing database design and query plans.
  • Optimized old Store Procedures and Functions on Production Server. Wrote new Stored Procedures for new system.
  • Developed Stored Procedures for the BCP of the data from the client database in the requested format.
  • Developed Stored Procedures for the changes only file and Open Enrollment file as needed by client.
  • Generate test file using UltiPro to demonstrate the client and help client with their export.
  • Manual Testing of the export file as per the format requested by client using Quality Center.
  • Automated Testing of the application using QTP for functional testing of the application.
  • Developed automated scripts using QTP to perform functional and regression testing.
  • Performed User Acceptance Testing
  • Interacting with client in case they find any difficulties or any issues in the export.

Environment: SQL Server 2008/2005, T-SQL, SQL Server Reporting Services, SQL Server Integration Services.

Confidential, Melville, NY

Sr. Microsoft BI Consultant

Responsibilities:

  • Configuring the package for QA, Production environments.
  • Used SSIS packages to roll our data to Live Tables.
  • Designing Data Model and implementing changes in the earlier phase of the project to accommodate business logic and dynamic nature of the front end application.
  • Involve in Business requirement gathering, Technical Design Documents, Business use cases and Data mapping.
  • Involved in Migrating Data from Oracle to SQL Server using SSIS.
  • Massaging the Data and changing the Data types while migrating.
  • Design, develop and deploy the Packages using Deployment utility.
  • Troubleshoot the problems came across the Migration Processes.
  • Handle and Trace the Error using Error Handler.
  • Determine the Dependencies and create Tidal Jobs to kick off the running of the packages.
  • Run the package to Development or Staging for Starters, and compare the data against the Production data which will run in parallel, make sure the data matches.
  • Use logging to trace the action of package.
  • Configure the package using XML and Environmental variables.
  • Created report models for ad hoc reports when the end user wants to see the reports on fly in SQL Server Reporting Services (SSRS) in Data Dynamics report with VB.NET
  • Design and create the Store procedure, Trigger and Function
  • Design Cubes using SSAS and deploying on the Production Server.
  • Involved in Performance Tuning using SQL Server Profiler and some T-SQL Commands.
  • Modified and Create Joins to Improve the Database and execution speed.
  • Testing the Data before deploying the Data in the Production server.
  • Involve in some DBA task such as Back-up and Recovery, Log-shipping, performance tuning.

Environment: SSIS, SSAS, Microsoft SQL Server 2000\2005 Enterprise Edition, T-SQL, Visual Source Safe.

Confidential, Philadelphia, PA

SQL Server Developer

Responsibilities:

  • A highly transactional OLTP system, where I was extensively involved in writing complex Stored Procedures and Triggers.
  • Actively involved as part of a team for gathering and analyzing the needs of End User Requirement and Online System Specification.
  • Successfully applied schema change scripts to existing objects to synchronize with changing business rule for computing book basis of mortgage and revenue recognition.
  • Created Stored Procedures to compute the Fixed Income on the unpaid Mortgages.
  • Created triggers, views and added/modified tables for data load, transformation extraction and manipulation.
  • Worked on DTS Package, DTS Import/Export for transferring data between SQL Server
  • Responsible for the design of the SSIS package for the update the data mart from OLTP database.
  • Involved in upgrading DTS packages to SSIS packages.
  • Create SSIS Packages to move the data from MySQL into SQL database. Before loading the data into the server, using various tasks, transformations and variables, made dynamic SSIS packages which did data scrubbing, including data validation checks.
  • Created cubes using SSAS, by determining suitable candidates for dimensions and measures while creating fact tables (demoralized tables) for star schema
  • The reporting was created with SSRS and utilized the cube and MDX to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports
  • Planned the Complete Backing up of Database and Restored the Database from Disaster Recovery.

Environment: SQL Server 2005,SSIS,SSRS,MDX,MySQL, SQL Server 2000, Windows 2003/2000, MS Access, HTML, CSS, Visio, MySQL, Crystal Report XI.

Confidential, Montvale, NJ

MS SQL Server & Report Developer

Responsibilities:

  • MS SQL Server & Report Developer
  • Designed the data mart with the use of the fact and dimension table model. Also designed the aggregate table for the usage summary reports.
  • Stored configuration information in SQL Server table for the migration from development server to the production server.
  • Used various dataflow and control flow controls for the ETL.
  • Responsible for the validation of the aggregate data from the ODS and the OLTP Database.
  • Return the stored procedure for the ETL functionality from ODS to Data mart in SQL Server 2005.
  • Created Alerts for successful or unsuccessful completion of scheduled Jobs.
  • Designed the usage summary and detailed reports in SSRS 2005 from the requirement document and the old report Mock-Up in MS Excel.
  • Responsible for report generation using Crystal Reports XI based on business requirements
  • Responsible for the reports deployment on the reporting services website and created subscription for the windows file share. Returned the stored procedure and the UDF for the reports.

Environment: MS SQL Server 2005, Windows server 2003, VB.Net, ASP. NET, VS 2005Access, MS Excel.

We'd love your feedback!