We provide IT Staff Augmentation Services!

Sr.bi Consultant (sql Developer) Resume

SUMMARY:

  • 10+ Years of IT experience in DW - BI Applications (SSIS, SSRS, SSAS), ETL, Power BI, Database Development, System Analysis, Design, Development, implementation and support of MS SQL Server 2005/2008/2012/2014/2017 .
  • Define and Developing BRD, FS, TS, Dataflow documents and Mapping documents.
  • Involving in designing, coding, testing and deploying for SSIS Packages and developing with standards.
  • Worked on Agile and scrum methodologies for project planning and story building.
  • Have experience to create Visio diagrams for conceptual, logical and physical.
  • Strong proficiency in the full life cycle of Business solution development with outstanding capabilities in analysis, problem definition and requirements gathering and architecture.
  • Excellent T-SQL Programming skills. Experience in query optimization & performance tuning. Used SQL Profiler, Execution Plan, Performance Monitor at various levels like ETL and database level.
  • Experience in migration projects from SSIS 2005 to SSIS 2017 and Cristal reports to SSRS.
  • Having experience in analyzing the data and developing the Cubes. Also, involving designing attribute, hierarchies, cube processing, Star and Snow Flake Schemas of Data Marts.
  • Experience in developing the reports using SQL Server reporting services 2012.
  • Generating complex Transact SQL (TSQL) queries, Sub queries, Dynamic SQL queries etc. Programming in SQL Server - Using the stored procedures, Triggers, User-defined functions and Views, Common table expressions (CTEs).
  • Having experience in migrations while using different tools like PVCS (Version control), TFS, Remedy OPAS (Tickets handling), Spotlight (Servers perf. & monitoring) and BizTalk server.
  • Strong understanding of data warehousing concepts, OLTP, OLAP, Normalization, Star, Snow Flake data models and MDX query’s. Experience in AZURE data warehouse.
  • Experience in generating the cubes, set the relationships for dimensions and hierarchies.
  • Experience with aggregation using OLAP analysis services cube.
  • Responsible for building reports in Power BI Desktop, Power Pivot, Power Query, Power View and Power Map with excel analytics and Tableau Reports.
  • Good communication skills, commitment, result oriented to learn new technologies and interest in type of challenging work.
  • Having experience in Support modelling, migrations, handling high priority tickets .
  • Experience in enhancing and deploying the SSIS Packages from development server to production server.
  • Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
  • Generated Reports using Global Variables, Expressions and Functions for the reports.
  • Worked with Business Analysts, Web development team, and users on database solutions.
  • Experience with Ad-Hoc Reporting using Report Builder in SSRS for daily reports and Ad-hoc reports using Excel.

TECHNICAL SKILLS:

Operating Systems: Windows 7, 8, Windows XP, Server 2016.

BI Tools /ETL: SSIS, SSRS, SSAS, Tableau, Power BI, QlikView.

Databases: SQL Server 2017, Oracle, DB2, MDX, DAX.

Programming Language: T-SQL, PL/SQL, HTML, XML, VB.Net, C#.Net

Supporting Tolls: Serena PVCS, TFS, VSTS, SVN, Remedy OPAS.

MF middle ware tool: Attunity.

Data Modeling: MS Visio, ER Studio.

Server Perf. Tool: Spotlight.

Scripting: VBScript, C#, .NET.

Monitoring Toll: Control-M, SQL Server agent Jobs, 24/7, Autosys.

Web Services: AZURE(Power BI, Machine language R, Cosmos DB, Data lake), AWS

PROFESSIONAL EXPERIENCE:

Encore Capital Group, San Diego, CA

Sr.BI Consultant (SQL Developer)

Confidential

Responsibilities:

  • Working with FICO Debt Manager for maximizing returns, controlling costs, and delivering strong consumers.
  • Involved in creating the database object like Tables, Indexes, Store Procedure, Trigger, Views
  • Using with SQL Server Profiler and Execution plane to trace the slow running queries and tried to Optimize SQL queries for improved performance.
  • Extracting the data using SSIS. Wrote data validation stored procedures and executed them in SSIS packages.
  • Working on a SSIS framework that will maintain the logs, error handling, notifications, and restart ability.
  • Working with BIML to automatically generate SSIS packages. Effectively applied code reuse, templates and patterns in ETL solutions.
  • Working with ZappySys web API integration task to send Ad-hoc web requests to DM and save response in SSIS variable.
  • Created script tasks to make rest API calls to the DM application using C#.
  • Have created a data scramble framework to hide sensitive data in DEV and QA databases by replacing it with valid and relevant false data.
  • Working on an enterprise product DDM (Dynamic Data Mapper) to reuse the same mapping logic for different data sources, develop a dynamic mapping that can run against different sources and write the mapping output to different targets. The DDM supports Excel, CSV and fixed length flat files.
  • Working on migrating ETL packages from Pentaho Data Integration to SSIS.
  • Built quality checks orchestration for business data to meet the requirements and load into database.
  • Wrote SSIS package to load data into XML and Excel.

Environment: SQL Server 2016/2014, FICO DM9, FICO DM10, T-SQL, SSIS, Windows Server 2010, Visual Studio 2012, Pentaho Data Integration, ZappySys, C#, QlikView 12.10, GIT, VSTS, BIML.

Confidential, FL,

Sr.BI Consultant - (Lead)

Responsibilities:

  • Designed data model and implemented Tabular Model Cube.
  • Involved in gathering business requirements and development of data modelling to facilitate business and operational needs
  • Created many calculated columns and measures using DAX in Power BI based on report requirements.
  • Created huge and complexity tabular model cube with six different data sources.
  • Provided solutions for self-service data/cube access and user report generation, development of complex, custom reports, and in-depth analytical services including process, operations, and service diagnostics.
  • Created Excel Pivot to enable Cube (SSAS) access for business users.
  • Developed Data Source, Data Source View to create a logical view of the data to be placed in OLAP Cubes using SQL Server Analysis Services (SSAS) project .
  • Built Data Analytics or visualization using Power BI (Power View integrated with Share Point).
  • Designed interactive Power BI dashboards and presented correct decisions independently based on what different kind of visuals would make sense for the business.
  • Created Dashboard Reports using Power BI
  • Complied interactive dashboards in Power BI Desktop and published them to Power Bi Server which allowed story telling behind the market spread with Quick Filters for on demand needed information

Environment: SSAS, Power BI, SQL Server 2014, Oracle 12c, SharePoint, Source Control, Bit bucket, NUnit.

Confidential, CA

Sr.BI Consultant - (ETL Architect)

Responsibilities:

  • Analysis & Understanding of the BRD, FS and TS documents.
  • Involved in project estimations based on complexity.
  • Creating logical and physical diagrams in Visio.
  • Experience in agile project and responsible for project planning for sprints, creating and participating in story building for multiple sprints.
  • Developing SSIS package templates to reduce the time while developing the packages.
  • Developing User define transformations using with C# and .Net code.
  • Implemented various tasks and transformations for data cleansing and performance tuning of packages by using SSIS.
  • Involved in creating the database object like Tables, Indexes, Store Procedure, Trigger, Views
  • Using with SQL Server Profiler and Execution plane to trace the slow running queries and tried to Optimize SQL queries for improved performance.
  • Created UNIT test cases and prepared technical specifications for SSIS packages.
  • ETL Package Jobs Scheduled in Control-M to run daily during Night Hours.
  • SQL Email configuration done to send Email Alert from SQL agent to inform Job Status.
  • Conduct KT/Trainee sessions to the new joins in the team.
  • DW Schema designed and implemented Multi-Dimensional and Tabular Model.
  • Fact table and Fact Less Fact table implementation.
  • User Defined Hierarchies Created for proper drill down.
  • Named Calculation, Growth Calculation, Previous Period Calculation done using MDX.
  • Partitions creation for faster processing and speedy query of data.
  • Create data model using AZURE data warehouse.
  • Performance tuning of cube for faster Process of data and avoid unnecessary elements.
  • Creating dashboard reports in power BI and publish to power BI. In addition, creating tabular SSRS reports.
  • Create data models, hierarchy, measures and KPI’s.
  • Role based Security Implemented for proper data segregation as per role.
  • To create data model from different data sources and creating relations as per requirements.
  • Implement roles and row level security.
  • Developing the different visualization reports in Power BI Desktop using MDX and DAX query's.
  • Power bi reports uploaded into cloud and refresh the reports through data management gateway (SharePoint).

Environment: ETL, SSIS, SSAS, Power BI, SQL Server 2014.

Confidential

MSBI Developer (ETL Architect)

Responsibilities:

  • Quick understanding of the technical specification document
  • Involved in development of the code from various stages like source to landing, landing to consolidation, consolidation to quality stage and quality to pre - target in OLTP environment.
  • Writing stored procedures, Functions, Triggers and views in T-SQL.
  • Experienced in creating jobs Alerts, Alerts, SQL Mail Agent, and Scheduling SSIS Packages using SQL Server Agent job.
  • Implemented various tasks and transformations for data cleansing and performance tuning of packages by using SSIS.
  • Created SSRS Reports Based on Client Requirements
  • Develop user requested reports migrate the Crystal reports to SSRS reports.
  • Involved in creation of Drill-Thru and Master-Detail reports as per the business requirements
  • Developed various types of prompts on a report as per the Report Requirement templates.
  • Developed more professional reports using Conditional formatting features.
  • Developed chart reports for showing summary information
  • Developed parameterized and summarized reports to understandable format for end users.
  • Designed and developed different type of reports including Tabular forms, Matrix (cross Tab report) form, Conditional, List items, Charts and Sub reports, custom report, drill down reports using SSRS.
  • Created UNIT test cases and prepared technical specifications for SSIS packages.

Environment: SSRS,SSIS, SQL Server 2008, Cristal Reports.

Confidential

MSBI Developer

Responsibilities:

  • Creating Tables, Views, Stored procedures and optimizing queries.
  • Pulling data from other databases and importing to SQL Server
  • Extensively used ETL Components to Extract Data from Different Sources
  • Using design documents and mapping documents developed dtsx packages.
  • Migrating MS Access db to SQL and converting VB scripting to SSIS package.
  • Created templates to save the time in developing the packages.
  • Processing the data like property, casualty insurance and life insurance policy data.
  • Created UNIT test cases and prepared technical specifications for SSIS packages.
  • Implemented CDC and SCD Techniques.
  • Read the data from BizTalk server and load into sql server.
  • Working on OLTP and OLAP environment and processing the huge volume of data.
  • Writing stored procedures and T-SQL.
  • Applying standards like logging, check points and package configurations.
  • User defined Hierarchies, Calculations, perspective and KPI in SSAS.
  • Named Calculation, Growth Calculation, Previous Period Calculation done using MDX.
  • Partitions creation for faster processing and speedy query of data.
  • Involved in testing and SSAS cube performance.
  • Involved in SSAS cube deployment in production using with XMAL.
  • Involved in deployment and Creating and scheduling jobs in SQL server.
  • Involved in performance tuning.

Environment: SSIS, Attunity, BizTalk Server, SQL Server 2012.

Confidential, TX

Sr. BI Consultant

Responsibilities:

  • Creating Tables, Views, and Stored procedures and Optimizing queries.
  • Coding & Integration of the application to other applications
  • Pulling data from other databases (Oracle, data files, SQL Server) and importing to SQL Server
  • Extensively used ETL Components to Extract Data from Different Sources
  • Using design documents and mapping documents developed dts packages.
  • Created templates to save the time in developing the packages.
  • Migrating from SSIS 2005 to SSIS 2008.
  • Identify the data quality issues, excel connection issues and compatibility issues.
  • Developed user defined transformations and lodging into OLTP db.
  • Interacting with business analyst for mapping issues and data issues to better output.
  • Applying standards like logging, check points and package configurations.
  • Involved in deployment from development server to UAT server.
  • Involved in performance tuning at package level and db.
  • Pass in variables when scheduling or running a package.

Environment: SSIS, SQL Server 2005/2008, Visio, Windows.

Hire Now