SUMMARY

• I have 6 plus years of experience in IT industry working with SQL Server, Oracle, snowflake and Business Intelligence Tools. I have worked on designing and implementing BI solutions with MSSQL, T - SQL and PLSQL programming, ETL (SSIS) package/data set migration/transformation, data loading, enterprise reporting (SSRS), Tableau develpment and Data Analysis.
• I also have experience in Requirement Gathering and Business Analysis, and Preparing Concept Papers for proposed projects. I am a self-starter, highly motivated and have very good problem solving and communication skills.
• Experience in architecting data systems and warehouse models for new and existing workflows
• Extensive experience in database design
• Experience in designing and implementing BI solutions with MSSQL Server Reporting Services 2008/2012/2014 (SSRS), Integration Service 2012/2014 (SSIS)
• Design and develop reports using SQL Server Data Tools and develop ad-hoc reports using Microsoft Report Builder 2.0/3.0.
• Extensive experience in SQL Server SSIS packages to import and transform data between databases and external data sources
• Extensive exposure in creating database T-SQL scripts, stored procedures, joins, views, tables, indexes, constraints, etc. using SQL Server and Oracle.
• Experience in Database Design using Microsoft Visio and ER Assistance

TECHNICAL SKILLS

Tools: /Skills: SQL Server, Oracle, snowflake, SSIS (ETL), SSRS, Tableau, Data Modeling (Logical & Physical)

Database Programming: DDL, DML, T-SQL, Stored procedures, Sequence, Trigger, CTE, Views, etc

Data Access Technology: ODBC, OLE DB

DWH Design: Star and Snowflake Schemas, Dimension and Fact Tables

Data Modeler: Visio, ER Assistance

MS-Office: Excel, Word, PowerPoint

PROFESSIONAL EXPERIENCE

Confidential, Seattle, WA

HR Analytics Report Lead

Responsibilities:

• Work with reporting team and with business units to continually improve current reporting, including both the processes involved and reporting design
• Lead and/or assist with implementation of regulatory changes, industry best practices, and internal risk and control policies
• Assist team to produce accurate and timely reports
• Continually update reporting object to reflect changes made on scheduling tools
• Facilitate the onboarding and product implementation process with different departments
• Ensure processes are documented and the controls are functioning

Confidential, Seattle, WA

Enterprise Data Architect

Responsibilities:

• Review existing warehousing models and architecture leading to new development that improved existing data accessibility and function for users
• Architect data systems and warehouse models for new subject areas.
• Worked with all levels of external and internal business customers for requirements development
• Coordinated project activities involving system users and IT development staff to ensure data mart requirements are identified and verified, and meet user specifications.
• Highlighted gaps in reporting and data management capabilities, and developed mitigation strategies.
• Create content for Data Governance center; and assist in reviewing and approving content

Confidential, Seattle, WA

Sr Business Intelligence Developer

Responsibilities:

• Building/Enhancing reports using SSRS
• Writing SQL scripts, stored procedure, and views.
• Inserting and updating data to SQL database.
• Analyzing data and writing SQL script for ad hoc requests.
• Deploying SSRS reports and SSIS Solutions to Sharepoint
• Making sure all the executive reports go out on time when on-call
• Prepare weekly production deployments/releases and check for SOX compliance
• Prepare and conduct trainings on our tools both for fellow developers and end users
• Prepare Test Scripts, Code Reviewing for team members, and send out reports for UAT approval
• Verify requirement document and prepare mockups for Jira tickets and Vette tickets after investigation.
• Update, maintain, and create SSIS package for the user maintained files
• Attend backlog grooming and sprint planning meetings
• Overall customer service oriented support

Confidential, Boulder CO

BI Developer/BI Analyst

Responsibilities:

• Building reports using SSRS and Power BI.
• Writing TSQL scripts, stored procedure, user defined functions and views.
• Inserting and updating data to SQL database.
• Analyzing different data and writing SQL script that helps viewing the analysis.
• Deploying SSRS reports on Reporting Server and configuring reporting server.
• Collect data from websites and prepare relevant reports using PowerBI Desktop
• Develop business critical financial reports using SSRS
• Creating, developing, and managing a SQL Server database.
• Preparing requirement document for database development and database modification.
• Preparing conceptual and logical document based on a requirement document.
• Extracting data from different data sources and creating SSIS packages using ETL techniques.
• Automating store procedures and SSIS packages using SQL job.
• Creating complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code for reports and analysis and backend requirements.
• Design different types of SSRS reports like parameterized and drill-down based on requirements.