SUMMARY

• Having 8 years of experience in Data Warehousing and Business Intelligence applications design, Development and Maintenance of Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analytical Services (SSAS) and Data Transformation Services (DTS).
• Experience in data analysis, design and development of databases for business applications in a client/server and data warehouse environments in SQL 2000/2005/2008/2012/2014/2016 .
• Expert in all areas of SQL Server development including tables, user functions, views, indexes, Stored procedures, functions, triggers, clustering, T - SQL, relational database models, data dictionaries, and data integrity.
• Well versed in normalization/de-normalization techniques for optimum performance in relational and dimensional database environments and building Referential Integrity Constraints.
• Good knowledge in RDBMS concepts, Data warehousing concepts, OLTP & OLAP.
• Expertise in MS SQL Server databases with tools like Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for optimal Performance.
• Experience in analyzing vast amount of data using Microstrategy Analystics.
• Experience in observing Microstrategy analytic Reports and Dashboards.
• Experience in Interacting with Business users to analyze the business process and transforming requirements into screens, performing ETL, documenting and rolling out the deliverables.
• Having knowledge in Business app introduced in mobile phones using Microstrategy mobile
• Expertise in Extract Transform Load (ETL) and Data Transformation Services (DTS).
• Strong Experience in Creating, Configuring, Deploying and Testing SSIS Packages.
• Expertise in Extraction, Transformation, Loading the data from Oracle, SQL Server, Access, Excel, Flat Files and XML using DTS, SSIS.
• Great Expertise in creating and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages.
• Expertise in creating SQL server Reports using SSRS 2008.
• Expertise in creating Report Models for building Ad hoc reports using SSRS.
• Proficiency in creating diverse types of reports such as Crosstabs, Conditional, Pie Chart Reports, Drill down, Top N, Summary and Sub reports and formatting them.
• Knowledge and experience in designing, developing and deploying Reports and Dashboards.
• Good understanding and designing of Star and Snow Flake data models Schema used in relational, dimensional and multidimensional data modeling.
• Experience in Creating, Modifying Measures, Dimensions Attribute relationships and Hierarchies.
• Experience in managing Alerts, Operators and Scheduled Jobs through SQL Server Agent.
• Experience in using Performance Monitor/Profiler to solve Dead Locks.
• Experience in code optimization and improving efficiency in databases including re-Indexing, updating statistics, Recompiling Stored Procedures and performing other maintenance tasks.

TECHNICAL SKILLS

Languages: C, C++, C#, .NET (4.5/4.0), T-SQL, PL-SQL, Oracle.

Databases: MS SQL Server 2000/2005/2008/2012/2014/2016 , Oracle, MySQL.

Database Tools: SQL Server Management Studio, Business Intelligence Development Studio, SQL Profiler, T-SQL, PL/SQL, OLAP, DBCC.

Reporting Tools: SQL Server Reporting Services, MS Excel, Oracle Report Builder.

Application Packages: MS Front Page, Microsoft Suite, SSIS, SSAS, SSRS.

BI Tools: SSIS, SSRS, SSAS (DAX Language), Power BIOperating Systems Unix, Windows Server 2000/2003/2008.

PROFESSIONAL EXPERIENCE

Confidential, CA

SQL BI Developer/SSIS/SSRS/SSAS

Responsibilities:

• Managed the entire ETL process involving the access, manipulation, analysis, interpretation and presentation of information from both internal and secondary data sources to customers.
• Understanding the business requirements, analyzing source system, source files, setting up the goals for implementing the new client.
• Created the Logical, Physical model and ETL Mapping Documents based on Business logic.
• Used USER product for convenient and secure way to control the Digital access.
• Extracted data from Oracle, DB2, AS400, SQL Server, Flat Files, Excel and XML using SSIS and cleanse the data.
• Configured the SSIS Packages using Environment Variables for Dynamic Selection of Development and Production Environment.
• Converted data types using Derived Column, Data Conversion Transformation.
• Setup the client packages for Accounts, Transactions and Notes based on Templates.
• Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into UL Database and DB2 Billing Systems.
• Developed SSIS ETL Packages & also modified packages into different environment (Development, Testing & Production), as ongoing requirement changes
• Created SSIS Packages for Incremental Loading and slowly changing dimensions.
• Creating, Modifying SSAS Measures, Dimensions Attribute relationships and Hierarchies.
• Designed SSAS Cubes, Named Calculations for Dimensions.
• Dimension and Fact table design and cubes for KPI, Defining hierarchies and rollups.
• Identified Dimensions and Facts, Used MDX to extract data from cubes and Created MDX script for representing Cube Calculation.
• Created Microstrategy techniques in to extract and recover data.
• Used Microstrategy anlytics to analyze and cleansed the data and modified according to our use.
• Enhance SSIS packages to perform dynamic functionalities from static configuration, and changed many of the packages by using C# coding for generic usage within the organization.
• Created & modified SSRS reports (2012 & 2016) depend on the requirement on the priority basis from the DW & BW bug tracker applications.
• Worked on the performance and high priority critical issues to meet deadlines for SSIS package execution and for SSRS reports rendering.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Created SSRS reports using Report Parameters, Drop-Down Parameters, Multi-Valued Parameters Debugging Parameter Issues Matrix Reports and Charts.
• Created Advanced Reporting Services Programming Using the Reporting Services Web Service.
• Created Development and Production support documents.
• Used Subversion for centralized storage within the Data Warehouse department.

Environment: SQL Server 2016, SSIS, SSRS, SSAS, Power BI, Visual Studio, DB2, AS400, Microsoft Visual Basic, VBScript, XML, Microsoft Visio.

Confidential, PA

SQL Developer/SSIS/SSRS/SSAS

Responsibilities:

• Developed complex programs in T-SQL, writing Stored Procedures, Triggers and Queries with best execution plan.
• Rewrote SQL queries to upgrade SQL Server performance using SQL Server 2012/2008
• Created User Defined Functions to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Optimizing Stored Procedures and long running queries using indexing strategies and query-optimization techniques.
• Used Try catch and error for exceptional handling.
• Conducted database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler, Data Engine Tuning Advisor and index tuning wizard.
• Used the SSIS Import/Export, migrated the Heterogeneous Database such as Oracle and Access database, flat files to SQL server 2012.
• Managed up gradation of DTS packages to SSIS packages
• Expertise in applying correct filters/slicers on the Power BI report based on business need.
• Experience in consulting with IT, Business Users & Business Analysts for building reports and dashboards based their needs.
• Worked with ETL to implement the slowly changing transformation, to maintain Historical Data in Data warehouse.
• Created ETL packages with different data sources ( SQL Server, Flat files, Excel source files) and loaded the data into target tables by performing various kinds of transformations using SSIS
• Used Team Foundation Server as Source Control to store Packages, Reports and SQL Scripts and share it among team members.
• Responsible for developing, monitoring and deploying SSIS packages.
• Configured SQL mail agent for sending automatic emails when a SSIS package is failed or succeed.
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Created Drill-through, Drill-down, Cross Tab Reports and Sub-Report using RDL.
• Using Microstrategy developed scalable software.
• Created queries for generating drill down reports in SSRS 2012. Formatted the reports using the Global variables, expressions and Functions.
• Created Linked Servers to connect OLE DB data sources and providers.
• Deploying and troubleshooting the SSIS Packages.
• Designing dashboard / reports to give them consistent and professional looks using TIBCO Spotfire professional.
• Using SSRS/Spotfire for development of reports for Business users from various sources like tables, stored procedures and development of several types of reports.

Environment: MS SQL Server 2012/2008, SQL Server Integration Services (SSIS), T-SQL, SQL server Reporting Services (SSRS), Business Intelligence Development Studio (BIDS), MS Excel 2013/2010.

Confidential, Kansas City, KS

SQL BI Developer/SSIS/SSRS/SSAS

Responsibilities:

• Generated the reports (SSRS) depending upon the requirements.
• Created subscriptions using SSRS report manager.
• Created several types of SSRS reports like cascading reports, parameterized reports.
• Worked on parameterized reports and Drilled down reports for newly created markets.
• Worked on troubleshooting process, issues, and errors using SQL Server Integration Services (SSIS).
• Extract/Load/Transformation data from different Source System like BAS, BW, NEB, net FORUM, etc. into Data Warehouse for Daily, Weekly & Monthly incremental SQLjobs.
• Worked on complete SSIS life cycle in creating SSIS packages, building, and executing the packages in both the environments (Development and QA)
• Worked on application integrations to manage the data using BI tools.
• Extensively worked on claims processing data and created the reports using SSIS packages and exported reports in excel.
• Used the health care data warehousing for the provider data management system.
• Used various transformations in SSIS Data flow, control flow using loop containers and fuzzy lookups etc.
• Created SSIS packages to migrate data from different data sources to data warehouse.
• Worked on the claims reports and on different operational reports.
• Created and scheduled jobs to run on a daily and weekly basis including maintenance of the jobs.
• Used BIDS to create parameterized reports and exported reports in excel.
• Involved in deployment process and subversion.
• Worked on reports (SSRS) with respective to new reports.
• Worked on production support and testing environment to ensure it's according to the business rules, developed reports and involved in testing and deployment.
• Generated periodic reports based on the statistical analysis of the data from various time frames and division using SQLServer Reporting Services (SSRS) and Spotfire.
• Worked on T-SQL programming, stored procedures and views in the processing of developing reports.
• Used various SSIS tasks such as Conditional Split, Derived Column etc., which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Worked on SQL Server 2008 R2 and 2012 for various parts of the project.
• Involved in regression testing, and optimization of the query.

Environment: SQL 2012/2008, DTS/SSIS, SSRS, SSAS, ERWIN, MS Access

Confidential, Dallas, TX

SQL Developer/SSIS/SSRS/SSAS

Responsibilities:

• Designed Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Involved in Creating Parameterized, Cascaded, Drill-down, Cross-tab and Drill-through Reports using SSRS.
• Developed, implemented, and executed a quality assurance program and quality control standards for all ETL (SSIS) activities. Performed regular data consistency, quality and reliability checks.
• Responsible for implementing and maintaining commercial ETL application(s) and integrating them into the data warehouse environment (SSIS).
• Managed the entire ETL process involving the access, manipulation, analysis, interpretation and presentation of information from both internal and secondary data sources to customers.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Developed scripts to migrate data from multiple sources.
• Communicated statuses with data warehouse and business intelligence teams and assisted in resolving data-related problems.
• Master working in OLTP & OLAP environments using SSIS, SSRS and SSAS cubes that include QA, Production and development, implemented and maintained database schema and Entity relationship (ERD) diagrams (using ERWIN) from business requirements.
• Configured packages to operate them on testing and production environments and scheduled jobs to run the packages and created configuration files to execute package in multiple environments.
• Provide DTS, ETL capability between Excel, access and MSSQL Service.
• Developed tableau reports to represent the trend of data that was loaded using SSIS packages.
• Created Dashboards using Power BI and deployed into Office 365.
• Responsible for design, create and tune database objects (tables, views, indexes) to support Logical and dimensional models. Maintain the referential integrity of the database.
• Developed ETL packages with different data sources (SQL Server, Flat Files, Excel source files etc.) and loaded the data into target tables by performing various kinds of transformations using SQL Server Integration Services (SSIS).
• Deployed SSIS Packages from Dev/Staging/Production using Package Configurations.
• Formulated and documented ETL process design based on business requirements and system specifications with strong ETL design skills, including source to target mappings, transformations, lookups, aggregations and expressions.
• Worked in production support to optimize the stored procedures and scheduled many jobs.
• Involved in Maintaining Database with Backup, Restore Strategies and scheduling those backups using SSIS packages as a Developer.

Environment: SQL Server 2008 R2/2012 Enterprise Edition, SSIS, SSRS, SSAS, Tableau dashboard, SharePoint, PL/SQL, C#, .net, Visual Studio 2010 & 2013, MS Visio 2007, Team Foundation Server (TFS).

Confidential

SQL BI Developer/SSIS/SSRS/SSAS

Responsibilities:

• Interacted with end users to gather Requirements. Created technical, user documentation.
• Studied and designed the system.
• Install, Update, Configure and Maintain the MS SQL Server.
• Created database objects like tables, views, indexes, stored-procedures, triggers, and user define functions.
• Analyzing and resolving all issues exists from long time.
• Design and tune ETL process.
• Data quality done by using the Data cleansing by using ETL development.
• T-SQL queries for the retrieval of the data.
• Created a report interface using Visual Basic 6.0, which allowed users to select reports and dynamically filter reports.
• Created calculated Measures for dashboard KPI's using DAX and Direct Query, build custom attributes for dashboard slicers and other filters using DAX.
• Developed, monitored and deployed SSIS packages.
• Involved in extracting the data using SSIS from OLTP to OLAP.
• Designing new SSIS packages on demand to provide report collected from various sources.
• Implemented Functions, views, triggers, stored procedures and enforced business rules via checks and constraints. Performed Replication, Backup compression for individual tables and indexes and reducing the disk usage and I/O resources.
• Provided support for access, training, and usage of POWER BI dashboards / reports / visualizations.
• Analyzing and providing fixes for all issues arises during business hours and have dataflow continue.
• Used SSRS to create reports, customized Reports, on-demand reports, and involved in analyzing multi-dimensional reports in SSRS.
• Tuning front-end applications like Visual Basic, which query the SQL Server databases.
• Written Various ASP codes for user interactions.
• Written Java Script for different validations
• Used SQL Statements to Present Query responses

Environment: SQL Server 2008 R2/2012, T-SQL, UNIX, .NET, VB Script, JavaScript, ASP, Microsoft Excel.

Confidential

SQL Developer

Responsibilities:

• Analyzed business requirements and build logical data models that describe all the data and relationships between the data.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in SQL Server 2000
• Validated change requests and made appropriate recommendations. Standardized the implementation of data.
• Promoted database objects from test/develop to production. Coordinated and communicated production schedules within development team.
• Modified database structures as directed by developers for test/develop environments and assist withcoding,designandperformance tuning.
• Managed user access. Created and managed new security accounts.
• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables from different databases.
• Analyzing and providing fixes for all issues arises during business hours and have dataflow continue.
• Created Views to facilitate easy user interface implementation and Triggers on them to facilitate consistent data entry into the database.
• Compared the target data with the source data.
• Gathered the data and resolved various quality problems associated with the data.
• Analyzed data by creating simple SQL queries and identified fact and dimension tables.
• Performed Data profiling using SQL queries on various sources.
• Restricted data for users using Row level security and User filters.
• Performed Data Analysis and Data validation by writing complex SQL queries using SQL against the SQL server database.
• Backupandrestoredatabases.
• Developed and implemented database and coding standards, improving performance and maintainability of corporate databases.
• Created theDTSPackagethroughETLProcess to vendors in which records were extracts from Flat file and Excel sources and loaded daily at the server.
• Updated the statistics info for both the old and new servers.
• Assisted with various ad hoc query requests.
• Provided back-end support for functional testing and performance testing

Environment: SQL Server 2005, T-SQL, DTS Designer, MS-Office, MS-Excel, VSS