SUMMARY:

• Professional, dedicated, and resourceful with proven success in developing with BI/EDW Applications SSIS, SSAS and SSRS. Demonstrated ability to analyze complex situations. Set goals and conceived strategies in meeting deadlines and produced several successful projects
• 5+ years of Business Intelligence expertise in Developing, Analyzing, Designing, and Reporting using Microsoft SQL Server Management Studio software 2008 - 2016 versions and Microsoft Visual Studio (SSIS, SSAS and SSRS).
• Experience processing and generating automated reports for the end business users on a daily, weekly, and monthly basis.
• Experience in handling different type of data like OLTP, OLAP, Excel and XM, Flat file.
• 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 as DDL, DML, DCL and User Defined Functions.
• Proficient with building data warehouse structures, and creating facts, dimensions, aggregate tables, by dimensional modeling, Star/Snowflake schemas and maintaining data integrity.
• Design different management systems 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 documented the ETL processes 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.
• Frequent use of cross-tab, conditional, drill-down, drill through, sub reports, Ad hoc reports, parameterized reports, interactive reports & custom reports in SSRS.
• Experience in Maintains Data warehouse by backups, corruption detection, statistics, Index fragmentation and Data log file management.
• Used efficient task objects /connections/ workflows in packages based on data volumes and data sources Experience working in an Agile/SCRUM-Spiral, Waterfall Mythologies, and Software Development Life Cycle (SDLC) environment.
• Experience in d eveloping Reports in Visual Studio by using the variety of tools such as charts, map, matrix, indicator and more.
• Experience working with SharePoint 2010 for reporting services integration, with focus on creating reports in Visual Studio and create monitoring and analytic tools .

TECHNICAL SKILLS:

RDBMS: MS-SQL Server 2008- 2016

ETL: SQL Server Integration Services, Data Transformation Services -TSQL, TSQL SSAS, SSRS

Languages: SQL, C#, XML

Tools: SQL Visual Studio, SQL Management Studio, Excel Pivot, SharePoint

Office Tools: MS Word, Power Point, Excel

Domain Expertise: Marketing/Sales, Insurance, Health, Financial

Others: Data Analysis, Data Validations, Database Maintain, Error Handling

PROFESSIONAL EXPERIENCE:

Confidential, Richardson, TX

BI/SQL/SSIS/SSRS/ETL 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.
• Working in Agile/SCRUM and Software Development Life Cycle (SDLC) environment.
• Designed different management systems like RDBMS, Cube, ETL, and dashboard.
• Create T- SQL queries, Stored procedures, Views, User-defined function, Trigger, and Confidential .
• Developed and deployed SSIS packages for ETL from OLTP, XML, Flat File, and zip file. Validating Data by using Lookup, Derived Column, Conditional Split, and Slowly Changing Dimension.
• Designed templates for developing SSIS Packages in such a way that they can be dynamically deployed into development, testing and Production Environments.
• Generated and Deployed ETL / SSIS packages both design and code to process data to target databases.
• Used efficient task objects /connections/ workflows in packages based on data volumes and data sources.
• Designed and built reliable SSIS packages with error handling and notification techniques to maintain the integrity and notify responsible parties in the event of an error.
• Designed 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.
• Developed complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies.
• Processed and generated automated reports for the end business users on a daily, weekly, and monthly basis.
• Designed report templates, graphs, charts based, map and more based on the financial data.
• Maintains Data warehouse by backups, corruption detection, statistics, Index fragmentation and Data log file management.
• Created Complex Stored Procedures, Triggers, User-defined functions, Views and other SQL joins to ensure efficient data retrieval.
• Generated Sub-Reports, Drill down, Drill through, Parameterized reports by using SSRS. Experience working Performance Point service 2010, with focus on building different dashboards.
• Gathered user requirements to analyze, design the software and database solutions.
• Experienced in Normalization, DE-Normalization Data warehouse.
• Experienced to build Dimensional Modeling, ER Modeling, Star Schema / Snowflake Schema, FACT and Dimensional tables and Operational Data Store (ODS).
• Worked with Data Architect and Marketing department to implement data warehouse and reporting using tools such as SQL Server 2008-2016 R2, SSIS, SSAS, SSRS.
• Designed and analyzing business requirements, and protentional customer's activities based on business data by conducting insurance application process with underwriting departments.
• Hands-on creating master and child packages. Setting up package- configurations, and logging.
• Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance.

Confidential, Lakewood, CO

BI/SQL/SSIS/SSRS/ETL Developer

Responsibilities:

• Created report based on dimensional, and relational models.
• Created Matrix reports (also called as cross-tab or pivot), Charts and graphs for each clinic, hospital, and doctor, by using appropriate Insurance plan in SSRS.
• Developed Reports in Visual Studio by using the variety of tools such as charts. map, matrix, indicator and more.
• Deployed and configured many reports in Report Service configuration and make it ready for the end user.
• Integrated data from the variety of sources such as Excel, XML, Flat File and more.
• Worked on all activities related to the development, implementation, administration, and support of ETL processes for large-scale Data Warehouses using SSIS.
• Processed and generated automated reports for the end business users on a daily, weekly, and monthly basis.
• Designed and built multiple Cubes in ODS database for Medicare, and Medicaid plans by collaborating with sales, and marketing team based on the business requirement document (BRD).
• Designed data warehouses, Star Schema, and Snow Flakes Schema, dimension Tables (Time, Fact), and ODS Database cube.

Confidential, Los Angeles, CA

BI/SSRS DEVELOPER

Responsibilities:

• Worked with Sales production, Marketing, and Finance department with the collaboration of IT team to automate various business transaction to create reports and scorecards from Excel and Flat file.
• Worked with Business, and Financial Analysis department to understand business sales processes for documenting project requirements and translate them into functional and non-functional specifications for BI reports.
• Maintains Data warehouse by backups, corruption detection, statistics, Index fragmentation and Data log file management.
• Processed and generated subscription reports for the end business users on a daily, weekly, and monthly basis.
• Designed and created Report templates, by using the graph, charts, KPI, and more based on the business requirement.
• Created Drill Down and AD Hoc Reports using SQL Server 2008-2005 Reports Services (SSRS).
• Created and modify dashboard pages by using Tableau Report.