SUMMARY:

• Specialized SQL BI Developer with 6 years of experience in reporting with strong skills in SQL development, SQL Server, data warehousing in domains such as finance, logistics, insurance, and retail.
• Experience in all phases of software development life cycle (SDLC) from requirements gathering, design, development and support of applications.
• Experience with waterfall and Agile development methodologies and worked with customers in prioritization and planning sprints.
• Strong experience in requirement analysis, physical and logical design development, resource planning, coding, debugging, testing, support and maintenance of business intelligence applications using SQL Server 2008/2012/2014/2016 , DTS, SQL Server Integration, Analysis and Reporting Services
• Experience working with business users closely in gathering business requirements and giving user training on reports and new features launched.
• Worked on ingestion framework, migration from Teradata to Hadoop with hive and MySQL.
• Expert in database activities like database creation and maintenance, performance monitoring, tuning and troubleshooting, disaster recovery, backup/restore and migration.
• Strong experience with SQL Server and T - SQL in constructing joins, user defined functions, stored procedures, triggers, views, indexes, user profiles and data integrity.
• Involved in multiple data migration projects.
• Experience in enhancing and deploying the SSIS packages from development server to production server.
• Strong understanding of Data Warehouse principles using Fact Tables, Dimension Tables, Star/Snowflake Schema modeling and data modeling
• Experience in designing, developing and deploying of Cubes and creating role-based security and row level security in cubes using SSAS.
• Good Knowledge in design partitions and aggregations for performance tuning in SSAS.
• Experience in developing reports using Excel and SSRS, Tableau.
• Experience in cloud computing platform like SQL Azure, involved in data migration from SQL on- Premise environment to cloud computing platform.
• Excellent in interacting with Clients, Business Analysts and developers.
• Expertise in Data Blending concepts in Tableau Desktop, Power BI and creating/Publishing interactive dashboards.
• Strong mentoring skills, capable of leading and motivating individuals to maximize productivity while fostering cohesive teams in a virtual environment.

TECHNICAL SKILLS:

RDBMS: MS SQL Server 2016/2014/2012

Programming Languages: T-SQL, C, HTML, Core Java, HIVE

ETL Tools: SSIS, Import/Export Wizard, DTS

Reporting Rules: Tableau, SSRS, Excel Reporting, Power BI

Analysis Tools: SSAS

Cloud Computing Platform: SQL Azure, AWS

Methodologies: Waterfall, Agile, Software Development Life Cycle

Operating Systems: Windows, Linux

Office Applications / Workflow Tools: MS Outlook, Visio, MS Project, MS-Excel, Power Pivot 2010, MS-Access

Configuration Tools: Team Foundation Server (TFS), GIT HUB

Data Base Monitoring Tools: SQL Profiler (SQL Server), SQL Redgate Products

PROFESSIONAL EXPERIENCE:

Confidential, Berkeley, CA

Sr. SQL BI Developer

Responsibilities:

• Worked closely with business and involved in gathering the user requirements, Analysis, Design, functional & technical specification and wrote SQL scripts for data transfer/migration.
• Extensively worked in analyzing SQL Stored Procedures and enhancing them accordingly.
• Responsible for writing and modifying store procedures, functions, packages and database triggers
• Created indexes, tables and sequences as per the business requirement and views to maintain data privacy.
• Worked with IT operations teams to troubleshoot ETL issues and optimize the database server environments.
• Designing, Coding, Testing, scheduling and implementing project using SSIS.
• Used SQL profiler to identify slow running queries and optimized them foe better performance.
• Updated data in tables based on the user requirement using temp tables, with CTE ‘sand joins.
• Worked with business analysts to provide solutions for technical difficulties and business-related issues.
• Created SSRS Report Model Projects in BI studio and created, modified and managed various report models with multiple model objects, source fields and expressions
• Point of contact for all the production issues (both database and front end/application.)
• Created database links and accessed the data through SQL statements
• Designed SSIS packages to validate, extract, transform and load data into staging and Data Warehouse
• Analyzed the requirements and framed the business logic for the ETL process.
• Responsible for scheduled job maintenance and trouble shooting.
• Created SQL jobs and monitored them often and updated business with the successful migrations.
• Used Scrum Development Methodology.

Environment: SQL Server 2012, 2014, 2016, SSIS, Tableau, Power BI, HIVE

Confidential, San Bruno, CA

SQL/MSBI Developer

Responsibilities:

• Engaged in new development as well as support maintenance or enhancement of existing applications. Projects will entail complex business requirements and processes.
• Worked closely with business and involved in gathering the user requirements, Analysis, Design, functional & technical specification and wrote SSIS scripts for data transfer.
• Extensively worked in analyzing SQL Stored Procedures.
• Updated data in tables based on the user requirement using temp tables and joins.
• Extract data from Terada and create data sources using Data warehousing concepts.
• Create action filters, parameters and calculations for preparing dashboards and worksheets in Tableau.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Preparing workbooks using calculations, parameters in Tableau.
• Understanding of relational database structures, theories, principles, and practices.
• The ability to interact professionally with a diverse group, including executives, managers, and LOB.
• Modified SSIS package for manipulating the data Source coming from As400 to Back Office system.
• Worked extensively in migrating data from various sources such as Excel, Oracle, MS Access, MySQL, OLE DB, and flat files to different destinations using SSIS.
• Upgraded SSIS packages from version and created indexes on tables if needed.

Environment: SQL Server 2008, 2012, 2014, SQL Server Integration Services, Hadoop technologies.

Confidential, San Rafael, CA

SQL / ETL Developer

Responsibilities:

• Worked closely with business analysts to provide solutions for business problems.
• Gathered requirements, Analysis, Design, functional & technical specification and wrote SSIS scripts for data transfer.
• Worked with business users to handle issues while refreshing the excel spreadsheets pointing to SSAS cubes.
• Handled offshore team with daily sync up call with onsite providing detailed explanation about business and individual tasks on JIRA board.
• Point of contact for all the production issues.
• Developed OLAP cubes using SSAS (SQL Server Analysis Services) and calculated the metrics that were revealed in the functional analysis.
• Coordinated with Business Users to understand business needs and implement the same into a SSAS Cube as a team.
• Defined cubes, dimensions, user hierarchies, aggregations in an OLAP environment.
• Extensively worked in analyzing Stored Procedures.
• Updated data in tables based on the user requirement using temp tables and joins.
• Worked closely with business and involved in gathering the user requirements
• Created database links and accessed the data through SQL statements
• Analyzed the requirements and framed the business logic for the ETL process
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations
• Created package to transfer data between OLTP and OLAP databases
• Designed Cubes with star schema using SSAS
• Created various complex reports and manage them using SQL Server Reporting Services (SSRS)
• Responsible for scheduled job maintenance and trouble shooting the production issues.

Environment: SQL Server 2012, 2014, SSIS, SSAS

Confidential

Associate Software Engineer/ Data Analyst

Responsibilities:

• Designed, developed and deployed data movements using TSQL, Stored Procedures and SQL Server Integration Services.
• Collaborated with business analysts, subject matter experts, and other team members to determine data extraction and transformation requirements.
• Experienced in using Data Manipulation Language (DML) for the query and update commands and the Data Definition Language (DDL).
• Worked on views, cursors, CTE's, schemas, permissions and performance issues with client/server database design.
• Created Reports Using functionality like Drill Down, Cross tab, Master and Detail reports.
• Created Alerts for complex Reports and prepare custom Hierarchy.
• Extensively used calculations, Sorting, Rank, Drill down, Drill thru, Slice and Dice.
• Created Complex/ad-hoc reports using SQL Server Reporting Services.
• Involved in deploying, configuring and managing reports using Report Manager and Report Builder.
• Formatted the reports using the Global variables and expressions.
• Developed different kind of reports such a Sub Reports, Charts, Matrix reports, Linked reports. Used cascaded parameters to generate a report from two different Data Sets.
• Analyzed old reports designed in crystal reports and transform those reports into SSRS report with proper mapping and error handing.

Environment: SQL Server 2012, SSRS, Crystal reports, MS Access