PROFILE SUMMARY:

• 6+ years of experience in IT with Database applications and Business Intelligence Design, development, and Data Analysis in Production, Development, Testing and Staging Environments.
• Strong interpersonal skills and ability to work well within an team
• A fast learner with the ability to understand, retain and apply new information quickly
• Attention to detail, accuracy, quality of output with excellent analytical, interpersonal and presentation skills
• Experienced with all phases of software development life cycle (SDLC) and Agile methodologies.
• Experience in generating reports for OLTP and OLAP databases.
• Experience across entire Microsoft BI suit of products including SQL Server, SSIS, SSAS, and SSRS from prototyping to deployment.
• Expertise in MS SQL Server 2016/2014, MSBI products like SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis services (SSAS).
• Experience in Data Extraction, Transforming and Loading (ETL) from multiple sources like Excel, MS Access, XML, Oracle, and DB2 to MS SQL Server by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, and Excellent knowledge in RDBMS concepts and Data Warehouse Concepts.
• Experience in designing, developing, deploying and scheduling ETL solutions using SQL Server SSIS packages involving various control flow items like Loops, Bulk Inserts, Incremental Loads, FTP and Emails Alerts.
• Experience with Issue Tracking systems like JIRA and ServiceNow
• Utilized various filtering functionalities within Tableau for better performance and provide required data through visualizations.

TECHNICAL SKILLS:

Database: Oracle, PL/SQL, SQL Server 2016, 2014, 2012

SDLC: Agile, Scrum, Waterfall, and Spiral

Data Modeling: ER - win, MS Visio

Database Programming: T-SQL, Dynamic SQL

Integration Tool: SSIS

Analysis Services: SSAS, OLAP Cubes, Tabular Model

Reporting Tools: SSRS, Tableau Desktop

PROFESSIONAL EXPERIENCE:

Confidential, Plano, TX

MSBI/ETL Developer

Responsibilities:

• Collaborating with business partners to understand their business needs, designing and implementing potential technical solutions using BI Tools.
• Gathered and documented business requirements for analytical reports. Participated in requirements meetings and data mapping sessions to understand business needs. Identified and documented detailed business rules.
• Served as a good Team Player for the Business Intelligence team.
• Quickly jumped on to the requirements and delivered work times within the stipulated time.
• Perform all SDLC phases related to extract, transform, and load (ETL) processes using SQL Server Integration Services (SSIS) and SQL Server T-SQL stored procedures within SQL Server 2014 environment.
• Developed strategies for Data Profiling of tables, which additionally helped to clean the data in the staging phase.
• Modified the existing SSIS packages to meet the changes specified by the users.
• Implemented slowly changing dimension transformation within SSIS to maintain historical data in the data mart.
• Developed SSIS packages with Transaction options (required, supported) to accomplish proper data loads.
• Managed execution of SSIS packages and procedures with SQL Server Job Agent.
• Configured packages with parameters and deployed packages to other servers.
• Performed data cleansing with Fuzzy Lookup and Fuzzy Grouping based on the confidence and similarity levels provided by data quality team.
• Assisted in analyzing, designing, building and testing of OLAP cubes with SSAS.
• Designed the ETL process along with accessing, manipulating, analyzing, interpreted and presenting information from multiple sources.
• Adapted error handling techniques within procedure and logged errors for analyzing and debugging.
• Resolved data extraction issues from different data sources (Excel, Flat files and SQL Server).

Tools: & Environment: SQL Server 2016, Windows 10, Visual Studio 2015, Transact SQL, SSIS, SSAS, SSMS, SSDT, SQL Profiler.

Confidential

MSBI Developer

Responsibilities:

• Reviewed execution plans for various queries for improving performance and tune the database.
• Implemented features such as translations, custom actions, partitions with different storage modes.
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
• Used Joins, sub-queries, Stored Procedures, Indexes, and Views for involving multiple tables from different databases to integrate the data as business requirements
• SQL Scripting, using Microsoft SQL Server Management Studio, to research, update, add, or delete information for records within tables using SELECT, UPDATE, INSERT, or DELETE statements with JOIN, WHERE, GROUP BY, and ORDER BY clauses.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing different kinds of transformations using SSIS packages.
• Developed, enhanced, and supported processes using Transact SQL and SSIS which moved data from the Oracle system and other sources into the MS SQL Server warehouse
• Created SSIS packages for File Transfer from one location to the other using FTP task.
• Generated reports utilizing relational databases and OLAP cubes.
• Created various reports such as drill down, drill through and chart with reporting services.
• Built ad-hoc reports using report builder and SQL Server data tools (SSRS) based on user requests.
• Designed and developed different type of reports including Tabular forms, Dashboards, Matrix (cross Tab report) form, Conditional, List items, Charts and Sub reports, Custom report and Drill down reports using SSRS.
• Formulated dashboard SSRS reports server projects and published SSRS reports to the reports server tabular and matrix reports with aggregator functions and expressions.
• Worked with report snapshots, linked reports and used report manager for deploying reports in SSRS.
• Created the reports using charts like Pie, Bar, Line, KPI Visuals, Custom visuals, etc.

Tools: & Environment: SQL Server 2016, T-SQL, Windows 10, Visual Studio 2015, SSIS, SSRS, SSAS, SSMS, MS-Visio, Microsoft-Office 2016.

SQL Developer

Confidential

Responsibilities:

• Participated in all the phases of Software Development Life Cycle (SDLC) methodologies throughout the project life cycle.
• Conceptualized data migration strategy to populate the data-mart with facts and dimensions.
• Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.
• Maintained data model and synchronized it with the changes to the database.
• Extensive writing stored procedures/functions, creating tables, indexes and views in Oracle, PL/SQL.
• Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based).
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Optimized performance of DQL queries with clustered/non-clustered indexes on tables.
• Implemented isolation levels, locks and transactions to avoid blocks/deadlocks.
• Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.
• Loaded Data into Oracle Tables using SQL Loader.
• Partitioned large Tables using range partition technique.
• Gained experience of working with data visualization tools with specialization in Tableau.
• Wrote complex Tableau expressions for creating calculated columns as required.
• Design and develop Tableau visualization solutions.
• Work on generating various dashboards in Tableau server using various data source
• Utilized many of the filtering functionalities within Tableau for better performance and provide required data through visualizations.
• Participated in troubleshooting and performance tuning of reports and resolved issues within Tableau Server.
• Able to creatively stretch the capability of Tableau to customize and develop creatively stunning and dynamic visualizations.

Tools: & Environment: Oracle 9i/10g SQL, PL/SQL, and Tableau Desktop

Financial Consultant

Confidential

Responsibilities:

• Developed client leads and implemented marketing strategies to retain new clients.
• Established customer-focused, needs based review process to educate customers about insurance options.
• Scheduled daily appointments for home services to market financial solution
• Established track record of results and success in Sales
• Providing consultation and advising on financial products available and best suited for the client.
• Sustaining and expanding client relationships
• Processed, prepared, and submitted business or government forms, such as submitting applications for coverage to insurance carriers.
• Mentored trainees, preparing work stations and assigning specific duties.
• Aid other financial consultants in maximizing sales results while minimizing their time spent on administrative and operational tasks
• Work with clients and carriers as required with a central role with the service team and communication via telephone and email