SUMMARY:

• 6+ years of experience in Data Analysis, Design, Implementation, Administration, and support of Business Intelligence using SQL Server SSIS, SSAS, and SSRS.
• Sound knowledge of software development life cycle (SDLC) with substantial experience with object - oriented analysis and design methodologies.
• Exceptional hands on working knowledge with SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS).
• Skilled in BI tools of Tableau, Power BI, SSRS including report, query writing using SQL and building front end BI applications as per specifications.
• Experience in Data warehousing and Business Intelligence in analysis, design, development, testing and implementation of the reporting and ETL components.
• Experience in designing various Data Visualization Dashboards, gathering customer requirements, writing test cases, preparing analytical reports to help users to identify critical KPI's and partnering with developers to ensure full understanding of internal/external customer needs.
• Expertise in Data Warehouse Modeling with SQL Server Analysis Services (SSAS).
• Expertise in creation and deployment of dimensions, partitions, aggregation and cubes on SSAS.
• Very good knowledge in scheduling and deploying reports on report manger.
• Created reports that have been defined by business architect and generated canned reports in a Crystal format of Crystal Reports.
• Worked on predefined, developed stored procedures for automation and scheduling in crystal reports.
• Experience in developing Custom Report and different types of Tabular Reports, Matrix Reports, and drill down reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Expertise in creating packages to transfer data between ORACLE, MS ACCESS and FLAT FILES to SQL SERVER using SSIS.
• Experience in enhancing and deploying the SSIS Packages from development server to production server.
• Good Hand on Resolving complex issues and Error Handling in SSIS.
• Created cluster index and non-cluster index on tables and disable them before inserts and enable when inserts completed.
• Expertise in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, to MS SQL Server by using DTS and SSIS services.
• Maintaining jobs for data messaging from development server to test server for generating daily reports for financial and marketing team.
• Implemented complex business logic with User-Defined-Functions, Indexed Views and created User Defined Data type, Clustered & Non-clustered Indexes.
• Expert in automating process by creating jobs and error reporting using Alerts, SQL Mail Agent, FTP and SMTP.
• Developed and implemented the application code in Oracle PL/SQL and T-SQL.
• Ability to work in-groups as well as independently with minimal supervision.
• Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.

TECHNICAL SKILLS:

Data Warehousing/BI Tools: SQL Server Business Intelligence Development - SSIS, SSAS, SSRS, DTS, Power BI, Tableau, ETL

RDBMS/DBMS: SQL Server, MS SQL SERVER 2000/05/08, ORACLE 9i/10g, MS Access.

Database tools: Management Studio, Query Analyzer, DTS, OSQL, Performance Monitor, Client Configuration Utility, Server Configuration Utility.

Web Technologies: HTML, DHTML, XML, XMLA, Apache.

Programming Languages: PL/SQL, SQL, C, UNIX Shell Scripting, Perl Scripting, JavaScript, VBScript

Visualization Tools: Power BI, Tableau, Power Pivot

PROFESSIONAL EXPERIENCE:

MSBI/ Power BI Developer

Confidential - El Paso, TX

Responsibilities:

• As a business intelligence developer, involved in Software Development Life Cycle (SDLC) of the project from the phase of requirements gathering from the users to design, implementation, development and testing.
• Analyzing the Business Requirements, Functional Specification, Use Cases and Configuration Spec Documents.
• Played a major role in design and analysis of database schema, altering and creation of the table structure and other.
• Created & Implemented complex database object like Tables, views, Constraints, Stored procedures, Views and Functions.
• Generated different types of reports like Client Side Report, Tabular Reports, Matrix Reports, Drill down Reports, Parameterized Reports, Ad-hoc Reports, and Stylish Reports using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Involved in design, development and implementation of SSIS and SSRS.
• Designed and implemented Parameterized Reports, Drill Down Reports like Cost Change and Savings Opportunity reports and Drill Through reports using SSRS.
• Used various kinds of transformations like Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc. 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.
• Also, involved in Performance Tuning of Stored Procedures and SQL queries using SQL Profiler and Index Tuning Wizard in SSIS.
• Worked on Extracting, Transforming and Loading (ETL tools) using SSIS, DTS Import/Export Data, Bulk Insert, BCP, DTS Packages and SSIS packages.
• Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
• Scheduling Jobs and Alerting using SQL Server Agent in Power BI.
• Providing analytical, complex and specialized client service analysis using Power BI dashboards.
• Used SSRS, Tableau and MS Power BI to create customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Utilized Power BI to design multiple scorecards and dashboards to display information required by different departments and management.
• Used SSRS, Power BI to create customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Used various Data Visualizations with Power BI and published reports to Power BI Services.
• Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.
• Built integrated reports using Power BI with data from Sales, Marketing, and Finance.
• Conducted meetings with development team, data analyst and DBA teams.

Environment: SQL Server 2014/2016, SSIS, SSRS, SharePoint, PL/SQL, DTS, SQL Server Management Studio, SSIS, SSRS, SQL Server Business Intelligence Development Studio (BIDS), MS-Access, SQL Server Query Analyzer, Visual Studio, Tableau and Power BI.

MSBI / Power BI Developer

Confidential - El Paso, TX

Responsibilities:

• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
• Directly involved into requirement gathering and understanding business functions with the end users.
• Provided valuable suggestions to users in terms of database design and new application implementation to overcome existing performance and reliability issues.
• Created report schedules and subscriptions. Created data driven subscriptions, reports that run on demand, cached the Reports, Snapshot of the Reports. Deployed reports both to the SharePoint server, IIS Server, Integrated SharePoint server with Report Server.
• Performance tuned long running lengthy SSRS reports and optimized rendering time by 10 times of the actual time.
• Integrated Custom Visuals based on business requirements using Power BI desktop.
• Developed complex SQL queries using stored procedures, common table expressions (CTEs), temporary table to support Power BI and SSRS reports.
• Developed complex calculated measures using Data Analysis Expression language (DAX).
• Embedded Power BI reports on SharePoint portal page and also managed access of reports and data for individual users using Roles.
• Successfully redesigned and migrated complex applications from Access to SharePoint and SQL Server 2008 by evaluating database structures and data movements.
• Used Microsoft Power BI to Build and maintain the reports and dashboards. Used Power BI Desktop to develop data analysis multiple data sources to visualize the reports.
• Developed complex SQL queries using stored procedures, common table expressions (CTEs), temporary table to support Power BI and SSRS reports.
• 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.
• Developed SSIS packages for extract/load/transformation of source data into data warehouse/OLAP cubes as per the functional/technical design and conforming to the data mapping/transforming rules.

Environment: MS SQL Server 2016/2014/2012/2008 R2, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Power BI, SQL Server Analysis Services (SSAS), SQL Server Management Studio (SSMS), MS-Excel, Windows 7

SQL/ MSBI Developer

Confidential, Orange County CA

Responsibilities:

• Involved in gathering requirements for various project, created technical report requirement document for the Standard Report
• Created tables and their relationships in the data warehouse
• Developed and optimized database structures, stored procedures, views, triggers, cursors and user-defined functions. Created user friendly reports in crystal & SRRS according to business needs.
• Performance Tuning of Stored Procedures and SQL queries using SQL Profiler and Index Tuning Wizard in SSIS Developing custom SQL and data blends as per requirement
• Effectively involved in maintaining the existing reports, scheduling and security.
• Involved in performance tuning of slow running queries.
• Analyze technical and functional design documentations to develop SSIS packages and SQL Server procedures to transform load and extract legacy data based on business rules
• Involved in transferring customer related data from various sources such as Excel, CSV and Flat files into SQL server tables by developing and executing SSIS packages
• Used various control flow tasks such as For each loop, Sequential container, Bulk insert and Execute SQL tasks within SSIS whenever applicable
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files
• Working in coordination with Clients for feasibility study of the project and drawing up the timelines and DB Teams for designing the database as per project requirement
• Working with Business Analysts to streamline any data issues which involve Unit Testing of all the worksheets
• Involved in designing, developing, debugging and testing of reports in SQL Server Reporting Services (SSRS)
• Involved in the Upgrade of objects and servers from SQL Server 2008R2 to SQL Server 2012
• Handling change requests and providing support/maintenance for deployed projects
• Extensively used Control Flow Components, Dataflow Components, Connection managers, Logging, Configuration Files for various SSIS packages
• Experience in various Database Design techniques, Data Modeling, Creating ER Diagrams
• Developed power pivot reports in Excel 2013, charts and other visualization using power view.
• Filter and sorting data using power view in excel 2013, developed power maps using Excel 2013 for reporting
• Manage and validate multiple studies from several clients with customized implementations across multiple groups in various electronic databases

Environment: MS SQL Server 2008R2/2012 Enterprise Edition, Visual studio 2008/2012, SSIS, JD Edwards, SSRS, BIDS, MS Excel, Element Tool, Team Foundation Server, Windows Server 2008 R2

SQL Developer

Confidential

Responsibilities:

• Analyzed business requirements and build logical data models that describe all the data and relationships between the data.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using SQL in SQL Server 2005.
• Validated change requests and made appropriate recommendations. Standardized the implementation of data.
• Promoted database objects from test/develop to production. Coordinated and communicated production schedules within development team.
• Created the DTS Package through ETL Process to vendors in which records were extracts from Flat file and Excel sources and loaded daily at the server.
• Involved in the development of a normalized database using Data Definition Language (DDL) in T-SQL.
• Performed job scheduling in the SQL Server Environment.
• Used Data Modification Language (DML) to insert and update data, satisfying the referential integrity constraints and ACID properties.
• Modified database structures as directed by developers for test/develop environments and assist with coding, design and performance tuning.
• Managed user access. Created and managed new security accounts.
• Backup and restore databases.
• Developed and implemented database and coding standards, involved in improving performance and maintainability of corporate databases.

Environment: SQL Server 2000/2005/2008, SQL, DTS Designer, MS-Office, Ms-Excel, VSS