SUMMARY:

• 6+ years of Business Intelligence expertise in Developing, Analyzing, Designing, and Reporting using Microsoft SQL Server Management Studio software 2008R/2012 & 2014 versions and Microsoft Visual Studio (SSIS, SSAS and SSRS).
• Experience working in Software Development Life Cycle (SDLC) environment.
• Experience to handles different type of data like OLTP, OLAP, Excel and XML
• Expertise in creating indexed views, complex stored procedures, effective functions, and appropriate triggers to facilitate efficient data manipulation to maintain data consistency.
• Implement Business logics using different languages such DDL, DML, DCL and User Defined Functions.
• Proficient with data warehouse structures staging, facts, dimensions, aggregate tables, dimensional modeling, Star/Snowflake schemas and maintaining data integrity.
• Design different management system like RDBMS, Cube, ETL and dashboard.
• Experience in implementing SSIS Business Intelligence Life Cycle such as SSIS packages configurations (XML, SQL Server, and Excel etc.)
• Design and document the ETL process from source to targets use mappings and various types of transformations.
• Create packages in SSIS with error handling capability, and using different type of data transformations like conditional split, cache, for each loop, multi cast, derived column, merge join etc.
• 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.
• Experience in backup/restore of database object such as procedures, tables, indexes, views and user
• Scheduling Weekly, Monthly and yearly reports on sales and marketing information for various categories and regions based on business needs using SQL Server Reporting services (SSRS).
• Experience working in Agile/SCRUM and Software Development Life Cycle (SDLC) environment.
• Excellent communicator with analytical and interpersonal skill.

TECHNICAL SKILLS:

RDMS: MS: SQL Server

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

Languages: SQL, XML

Tools: MS Visual Studio, SSIS,SSAS, SSRS

Office Tools: MS Word, Power Point, Excel

Domain Expertise: Financial, Retail, Marketing, Loan, Public Housing etc.

Others: Data analysis, Data validations, Communication Skills

PROFESSIONAL EXPERIENCE:

SQL Business Intelligence Developer

Confidential, Dallas, TX

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

SQL Business Intelligence Developer

Confidential, Dallas, TX

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.

SSRS Report Developer

Confidential. Irvine, CA

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.