SUMMARY

• Over 4+ years of professional experience as a SQL Analyst / System Analyst/ Business Data Analyst/ ETL Developer with solid understanding of Business requirement gathering, Business process flow, Database and Warehouse development, and Quality Assurance in Insurance, Automotive, Healthcare, and Electrical Industries.
• Strong knowledge of Software Development Life Cycle (SDLC), development methodologies like Agile and Waterfall.
• Expert in creating data analytics with strong experience in BI Tools like Tableau and PowerBI
• Strong Experience in writing SQL Queries, Stored Procedures, Functions, Triggers, PL/SQL scripts, for the database development and maintenance along with Performance Tuning of SQL Queries with good knowledge in XML
• Hands on experience with ETL/SSIS, including design and development of packages, store procedures, configuration files, tables, views, and functions
• Extensive experience in extracting, transforming and loading (ETL) data from OLTP (transactional) databases and other data sources, including heterogeneous and homogeneous sources into Data Warehouse, in SSIS using various tasks and transformations.
• Solid business communications, and presentation skills, adept at creating and coordinating extensive communication networks (facilitation of joint application design (JAD) sessions and interviews, written correspondence, web - based products, reports, project status reports, PowerPoint presentations, e-mails ).
• Experience in the documentation of system and business requirements and specifications, design and development of use and test-case scenarios and root-cause analysis, GAP analysis, developing test plans, conducting user acceptance testing, training, and implementing new processes and technology.
• Designed several business dashboards using Tableau Desktop, Tableau Server, Tableau reader and Tableau Online.
• Experience in analysis, data aggregation, blending among other things, and deploy statistical methods in Tableau.
• Experience in developing high performance data integration solutions with SSIS, including extraction, transformation, and load (ETL) packages for data warehousing.
• Solid skills in designing and implementing data warehouses and data marts using components of Kimball Methodology, like Data Warehouse Bus, Conformed Facts & Dimensions, Slowly Changing Dimensions, Surrogate Keys, Star Schema, Snowflake Schema, etc.
• Worked with Tableau command line tools tabcmd and tabadmin for managing scheduled tasks, administering users and groups, troubleshooting, performance tuning, and general systems maintenance.
• Hands on experience in installing, configuring, managing, upgrading and migrating Backup/Restore, monitoring and troubleshooting SQL Server 2008 and 2012.

TECHNICAL SKILLS

Platforms: Windows XP, Vista, 7,8,10 and Unix

Languages: HTML, CSS

Database Language: MS SQL, MySQL, MS Access, Oracle (PL/SQL)

Methodologies: Agile, Waterfall, RUP, Business process re-engineering

Reporting Tools: Tableau, PowerBI, Qlik, Visual Studio, IBM Cognos Analytics, SSRS, Crystal Reports.

Testing Tools: Load Runner, HP UFT

PROFESSIONAL EXPERIENCE

SQL Developer / Data Analyst

Confidential - Southfield, MI

Responsibilities:

• Created a technical Specification document to show how the project gathered data to create a new system environment in SQL.
• Analyzed and wrote SQL queries in the database environment.
• Utilized SQL server for select statements needed to access data from different schemas containing data stored.
• Developed test scripts on data mining processes for ongoing File processing and various business-related tasks such as Analysis and Reporting of our audits.
• Analyzed data collected in stores (T-SQL, jobs, stored-procedures and queries) and provided reports to the commercial team (Tableau, PowerBI)
• Created numerous sub reports, drill down reports as part of the project according to business requirements using Reporting Services (SSRS 2012).
• Compiled lists of stores respecting criteria given by client services, while minimizing collection costs (T-SQL, Queries, Views)
• Created tickets in JIRA on issues while getting the data loaded in stage and base tables and worked with SSIS and stored procedures support.
• Assured and checked the quality and the integrity of the data received from the store collectors (T-SQL, Queries, jobs, stored-procedures)
• Involved in testing SubroMax 2 application and developed test case documents for all modules.
• Wrote and analyzed trending reports, drew extrapolations from findings to/with the project manager and the commercial team (SSRS, T-SQL, Queries)
• Prepared Test Plans and Test Cases for Reports testing and Data warehouse ETL testing.
• Optimized stored procedures and jobs into SQL Server to increase overall performance and time/server use of daily functions
• Created SSIS packages to extract data from OLTP and transformed to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures
• Performed all development activities required for delivery of BI solutions including ETL, data modeling, cube development, solution deployment and maintenance.
• Developed customized reports using SSRS
• Used ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Used various SSIS tasks such as Conditional Split, Derived Column, lookup which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Actively participated in standup meetings, story reviews of the Agile process.

BI Analyst / SQL Developer - Intern

Confidential - Farmington Hills, MI

Responsibilities:

• Gathered client’s requirements and converted into data.
• Managed data by using SQL including joins, insert, update, stored procedure, views, and analytical skills
• Developed Business Intelligence reports, Dashboards, and Scorecards by using Tableau
• Created ETL process to make data available for reporting
• Worked with BI reporting tools like SQL Server reporting service and MicroStrategy
• Managed and performed data cleansing, de-duplication and harmonization of data received from, and used by multiple systems
• Worked on Healthcare and Automotive data in SQL and shared with web development teams.
• Identified and implemented key metrics, algorithms, and graphics into dashboards that facilitate data consumption for both integrity analysis and business execution.
• Provided support to BI Team by using various BI terms.
• Performed ETL/SSIS process for transferring data.
• Used SSRS or Reporting Service for analytical reports.
• Designed, created and maintained internal - external customer reports
• Worked closely with developers and QAs and followed Agile process.

SQL BI Analyst / System Analyst

Confidential

Responsibilities:

• Involved in business process reengineering, including gathering and documenting requirements, documenting workflows and developing functional specifications for the programmers.
• Created stored procedures, views, triggers, ER Diagrams and constrains to implement the database consistency and integrity.
• Implemented indexes such as clustered index, non-clustered index, covering index appropriately on data structures to achieve faster data retrieval.
• Loading data from the various data sources like Flat files, CSV's, SQL Server and MySQL etc
• Created SSIS package to extract, transform and load (ETL) data from different sources into destination target, like data warehouse, Excel using SQL Server Integration Services.
• Designed and developed different type of reports including: Drill through reports, Sub reports, Drill down reports based on business requirement using SSRS.
• Defined measure groups and further tuned dimensions attributes for a cube, created and deployed cubes to an instance of analysis services on the development server.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Worked extensively with the QA team for designing Test Plan and Test Cases for the User Acceptance Testing.
• Experience in the documentation of system and business requirements and specifications, design and development of use and test-case scenarios and root-cause analysis, GAP analysis, developing test plans, test scripts using SQL, conducting System Integration testing (SIT), user acceptance testing (UAT).
• Expert in transforming complex business logic into Database design and maintaining it by using SQL tools like Stored Procedures, User Defined Functions, and Views.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Create spreadsheet reports using Excel (Pivot Tables, vlookups)

SQL Developer

Confidential

Responsibilities:

• Developed and deployed quality T-SQL codes, stored procedures, views, functions, triggers and jobs
• Designed and Populated specific tables, databases for collection, tracking and reporting of data
• Built SSIS packages to extract, transform and load data to data warehouse
• Created and automated SSRS reports
• Diagnosed and addressed operational data issues
• Trained under developing team and worked with testing and manufacturing teams.
• Provided support to all production and development MS SQL Server environment.
• Involved in development of automated daily, weekly and monthly system maintenance tasks such as database integrity verification and indexing updates.
• Created SSIS Packages by using different data Transformations like Derived Column, Lookup, Conditional Split, data conversion and Execute SQL Task to load data into Database.
• Performed database restores from production to QA servers.