SUMMARY

• Senior Microsoft SQL Server / Business Intelligence (BI) Developer with extensive experience implementing Data Integration, Reporting, Power BI Dash Boards Development in various Industries.
• Implemented BI solutions following SDLC processes on all stages of BI project work using SSIS, SSAS, SSRS, Power BI, SQL Server, and T - SQL. Proactive in coordinating and processing requests for SQL data integration work, validating requirements, identifying system needs, recommending solutions and working with other team members to develop end to end solutions.
• Over six years of experience in developing BI applications utilizing SQL Server, BI Stack and Power BI.
• Proficient in Developing SSIS Packages to Extract, Transform and Load (ETL) data into the Data warehouse from Heterogeneous databases such as Oracle, SQL Server, and MS Access.
• Experience in managing and automating control flow, data flow events.
• Extensive experience with various transformations in Integration Services development.
• Practical adopting of the Data modeling (Dimensional & Relational) concepts like Star- Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Translated the business requirements into workable functional and non-functional requirements at a detailed production level using Workflow Diagrams, Sequence Diagrams, Activity Diagrams, and Use Case Modeling.
• Worked on the Power BI reports and dashboards with SQL Server/Tabular SSAS sources
• Used Table, Matrix, Bar, Card, Slicer visualizations for various Reports.
• Worked on DAX expressions like filters, Aggregate, Mathematical Functions, etc
• Comfortable in working with filters / calculated columns / measures / relationships and transformations of the Edit Query section.
• Published/shared the reports by creating Content Pack/Sharing the .pbix file.
• Implemented Role-Based Security as part of security in Power Bi.
• Extensive database programming experience in writing T-SQL, User Defined Functions, Triggers, Views, Temporary Tables Constraints and Indexes using various DDL and DML commands.
• Generated parameterized reports, sub-reports, charts, drill through,drill-down reports, Sub reports, Linked reports, Matrix, etc.
• Experienced in the Design and Optimization of OLTP, OLAP tools, creating SSAS based OLAP Cubes.
• Worked on projects using Agile and Waterfall model methodologies.
• Excellent problem solving and organizational skills.

TECHNICAL SKILLS

DATABASES: SQL Server 2012/2008 R2/ 2008, Microsoft Access, Oracle

SQL SERVER TOOLS: Enterprise Manager, Query Analyzer, SQL Server Management Studio, SSRS, SSIS, SSAS

LANGUAGES: T-SQL, ANSI-SQL, C#, c / c++, Power Query M

REPORTING TOOLS: SQL Server Reporting Services (SSRS), Power BI

WEB APPLICATION DEVELOPMENT: HTML, JavaScript, XML, CSS

OPERATING SYSTEMS: Windows, Red Hat LINUX

OTHER TOOLS: MS Office, PowerPoint

PROFESSIONAL EXPERIENCE

Confidential, Madison Ave, NY

Sr MSBI / SQL BI Developer

Responsibilities:

• Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports.
• Worked on the Power Bi reports & dashboards with SQL Server/Tabular SSAS sources.
• Used Table, Matrix, Bar, Card, Gauge, Slicer visualizations.
• Created SSIS Packages using Fuzzy Lookup, Derived Columns, Pivot Transformation, Condition Split, Term extraction, Aggregate, Execute SQL Task, Control Flow Task, and Execute Package Task to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Worked on DAX expressions like filters, Aggregate, Mathematical Functions, etc. created and deployed SSAS cubes using Star Schemas and Snow Flake Schema.
• Handled errors using error handling using SSIS event handler, configured packages, and projects.
• Created basic reports using Confidential files as a source to fetch the data in Power BI. Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
• Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients and mobile apps.
• Collaborate with the BI team for the development of BI architecture and components.
• Define and determine the scope, use, and requirements of business data warehousing.
• Created SSIS package to transfer data between OLTP and OLAP databases using Incremental Load.

Environment: SQL Server 2012, Windows Server 2003 Enterprise, Management Studio, Business Intelligence Development Studio (SSIS, SSAS, SSRS), OLTP, OLAP, XML, Power BI, DAX.

Confidential, Bedminster, NJ

SQL BI Developer

Responsibilities:

• Involved in complete SDLC process by analyzing business requirements and understanding the functional workflow of information from source systems to the destination system
• Wrote functional specification/requirement and detailed design document for the projects as well as development/production support documents
• Created and scheduled SQL jobs to run SSIS packages daily
• Designed, developed, tested and implemented custom ETL solutions, with focus on Data Warehouse design, administration and performance tuning
• Provided ongoing assessment and improvement of ETL processes, including ETL error logging, data purge, and load monitor
• Responsible for designing a clear cut ETL process to be used for loading all clients’ information into various Databases using SSIS.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Designed SSIS packages which utilized tasks and transformations such as Execute SQL Task, Data Flow Task, Sequence Container, For Each Loop Container, Execute Package task, Expression, OLE DB Command and Derived Column, File System Task, Send Mail Task
• Extensively used Data Flow tasks like Lookup, Aggregate, Script Component, Pivot/Unpivot, Derived Column, Row Sampling, Conditional Split, Multicast, Merge, OLE DB Command, Union All
• Created SSIS packages and deployed them in production by creating configuration files to be able to pass values for Process variables from outside SSIS in production and schedule the programs from the company’s proprietary scheduling tool. Query optimization using diagnostic tools like Explain Plan
• Created SSIS packages to extract, transfer and load data into the data warehouse daily, for Incremental loading and slowly changing dimensions.
• Ad-Hoc Reporting with Report Builder and Programming Reporting Services.
• Generated Reports using Global Variables, Expressions and Functions
• Utilized Power Query in Power BI to Pivot and Unpivot the data model for data cleansing and data massaging
• Utilized Power BI to create various analytical dashboards that depict critical KPIs such as billing hours along with slicers and dicers enabling end-users to make filters.
• Expertise in writing complex DAX functions in Power BI and Power Pivot.
• Installed and configured Enterprise gateway and Personal gateway in Power BI.

Environment: MS SQL Server 2005/2008/2012/2014/2016 , Business Intelligence MS SQL Server Integration Services (SSIS), MS SQL Reporting Services (SSRS), PowerBI,OLTP,OLAP.

Confidential

SQL BI Developer

Responsibilities:

• Generated Adhoc and parameterized reports using SSRS. Created various visualizations like a waterfall, funnel, matrix visualization, scatter plots, combo charts, cards, and KPI.
• Used SSIS to acquire huge data from various data sources.
• Developed complex data extracts and ad-hoc queries as requested by clients using SQL and SSIS.
• Developed complex mappings using SSIS to transform and load data received from clients into the central repository.
• Managed Error handling using event handler task and configured errors.
• Worked on the SSRS reports and SQL Server/Tabular SSAS sources.
• Generated cubes to perform the multidimensional queries.
• Performed and created packages to manage control flow and data flow tasks in SSIS.
• Dealt with a huge database and data warehouse, also involved in database designing.
• Managed some database administration tasks like DeadLock and Memory Allocation.

Environment: SQL Server 2012, Windows Server 2012 Enterprise, Management Studio, Business Intelligence Development Studio (SSIS, SSAS, SSRS), OLTP, OLAP, XML, Visual Studio 2012, Oracle 11gR2 DB.

Confidential

SQL Developer/OCA

Responsibilities:

• Involved in complete Software Development Lifecycle (SDLC).
• Wrote complex T SQL Queries, Stored Procedure, Triggers, Views & Indexes using DML, DDL Command and user-defined functions to implement the business logic.
• Performed Normalization & De-normalization on existing tables for faster query results.
• Designed and developed different types of reports like matrix, tabular, chart reports using SSRS.
• Maintained positive communication and working relationship with all business levels.

Environment: SQL Server 2012,SSMS,Oracle 11gR2 DB,SQL SERVER DB.