SUMMARY:

• 5+ years of experience working with SQL Management Studio building T.SQL (to Build Structured Queries), SSIS (to do Data Migration), SSRS (to Build Reports) & SSAS (to build OLAP "Online Analytical Processing”)
• Worked with different SDLC (Software Development Life Cycle) such as Agile, Spiral & Waterfall Methodology
• Experienced to handles different source of data like Flat File, Excel and XML
• Knowledge of different SQL Languages such as DDL (Data Definition Lang), DML (Data Manipulation Lang), TCL (Transaction Control Lang.), & DCL (Data Control Lang.)
• Expertise in creating various stored procedures, triggers, functions, views, transactions, joints, and also building referential integrity between my tables based on primary and foreign keys.
• Experienced in creating variables and temp database structures such as temp tables, table variables and CTE’s (Common Table Expression).
• Ability to build relational and dimensional data warehouse with Top - Down or Innoman approach & bottom-up or Kimball approach and organize data using star schema (Denormalized), snowflake Schema (Normalized) & ER Models with both fact and dimension tables and using measurements or partitions such as Month, hierarchy, name calculation and slowly changing dimensions type 1,2 & 3.
• Design and document the ETL process from source to targets use mappings and various types of transformations.
• Created packages in SSIS with error handling and package configurations and using control flow to build script task, SQL task to Execute Queries to Delete, Truncate, Update and Insert, b data flow task to flow data using different transformation tools such as merge join, conditional splits, multi-casts, derived column, data conversion and so on
• Build SSIS Packaged using different containers such as Foreach loop container to loop through multiple excel file within a folder, using sequence container to have my control flow task flow within a certain sequence, using file system task to copy File, Rename File, Delete File, and Move to Archive.
• Built reports from both relational and dimensional data sources building all type of dashboards with drill through, parameterize, drill down and sub reports and using different type of tools to visualize reports like line, pie, area charts, gauges, matrices, indicators, KPI, maps and so on.
• Experience with SSRS in different areas like report front-end development, report query writing/tuning, report deployment and management.
• Use of cross-tab, conditional, drill-down, top n, summary, form, sub reports, Ad hoc reports, parameterized reports, interactive reports & custom reports in SSRS.
• Ability to Schedule Weekly, Monthly and yearly reports on sales and marketing information for various categories and regions based on BRD using SQL Server Reporting services (SSRS).
• Knowledge of using SQL profilers, tuning adviser and execution plans for performance optimization and maintenance of Database.
• Experience in backup/restore of database object such as procedures, tables, indexes, views and user

TECHNICAL SKILLS:

RDBMS: MS-SQL Server 2008R/2012 & 2014

ETL: SQL Server Integration Services (Transformation Services, T-SQL, Stored procedures)

Languages: SQL, C#

Tools: MS Visual Studio, MS Management Studio

Office Tools: MS Word, Power Point, Excel

Domain Expertise: Sales data, marketing data, financial data, etc.

Others: Data analysis, Data validations, Database maintenance & Error-handling

PROFESSIONAL EXPERIENCE:

Confidential, Los Angeles, CA

SQL Business Intelligence Developer

Responsibilities:

• Develop Ad-hoc, Standard, Dashboards, and other reports using SQL Server Reporting Services (SSRS) from a variety of data sources including Analysis Services Cubes and relational databases.
• Develop and deploy SSIS packages for ETL from OLTP and various sources to staging and staging to Data warehouse using Lookup, Derived Column, Conditional Split, Term, Slowly Changing Dimension etc.
• Design Templates for developing SSIS Packages in such a way that they can be dynamically deployed into Development, Testing and Production Environments.
• Generate and Deploy ETL SSIS packages both design and code to process data to target databases.
• Used efficient task objects/connections/work flows in packages based on data volumes and data sources.
• Design and build reliable SSIS packages with error handling and notification techniques to maintain integrity and notify responsible parties in the event of an error.
• Implement Star and/or Snowflake schemas while designing relational database and data warehouse as per business and report requirements.
• Designing enterprise reports using SQL server reporting services (SSRS) and excel pivot tables based on OLAP cubes which make use of multiple value section in parameters pick list, cascading and dynamics reports.
• Creating Matrix reports, Charts and graphs as per customer requirements Using SSRS.
• Experience in Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.
• Create Drill Down and AD Hoc Reports using SQL Server 2010 Reports Services (SSRS).
• Created and modified dashboard pages in SharePoint server that use excel web access web parts and reporting services web parts and used excel services for reports.
• Run SQL queries to analyze and validate outside vendors BI related project in UAT environment and provided feedbacks.
• Implemented tools to report weekly and monthly sales and industry trends to senior and executive team.
• Developed and implemented dashboard to track new product and tests for the marketing team.
• Conducted multiple regression analysis to find correlations among the variables drivers of the business growth.
• Implemented reporting tools and monitored online traffics, sales and other key performance indication

Confidential, Dallas, TX

SQL Business Intelligence Developer

Responsibilities:

• Report based on existing data and the business requirement.
• Created Matrix reports (also called as crosstab or pivot), Charts and graphs for each Tellers and Bankers Using SSRS.
• Developed query for Drill Down and AD Hoc Reports with use of SQL Server 2008 R2 Reports Services (SSRS).
• Wrote SQL queries and stored procedures to generate data for reports.
• Deployed and configured the reports in the Report Server.
• Created Parameterized reports, Cross-Tab reports, Drill Down reports by using SSRS.
• Worked on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SSIS.
• Designed architecting the flow of data from various sources to target.
• Developed complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies.

Confidential, Irvine, CA

SSRS Report Developer,

Responsibilities:

• Worked with Point of Sales, Operation, Finance and IT team to automate various financial and operation reports and scorecards from Excel and Access.
• Created various Stored Procedures to validate the data from the source and update/insert the records into target tables.
• Designed and built OLAP star schema dimensional model cube using SSAS.
• Worked with Business analyst, Financial analyst, department heads and business users to understand business processes, document project requirements and translate them into functional and non-functional specifications for BI reports and applications
• Gathered requirements, analyzed data, wrote and maintained SQL code, developed and deployed reports.
• Designed, developed, tested and deployed ECR (Enterprise Custom Reports) on internal and client environments using SQL Server Reporting Services (SSRS)
• Processed and generated manual reports for the end business users on a daily, weekly, and monthly basis.
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Designed and built multiple Cubes for operation, finance and marketing team based on the business requirement document (BRD).
• Create Drill Down and AD Hoc Reports using SQL Server 2010 Reports Services (SSRS).
• Used internal tools to create, packages, and deployed client reports to test and production environments
• Created and modified reports and dashboard pages in SharePoint server.
• Rendered reports in different formats like pdf, excel etc. to be executed automatically on weekly or monthly basis and manage subscriptions.
• Performed data validation to tie out the source data to the SSRS and the cube data.