SUMMARY

• 8+ years of extensive experience working with BI (SSRS, SSIS, and SSAS) and T - SQL using SQL Server 2000/2005/2008 R 2/2012/2014/2016.
• Good Experience in Database Design, Data modeling, Development, Implementation, ETL and Reporting in SQL Server 2000/2005/2008 R 2/2012/2014/2016.
• Expert in Data warehousing concepts and OLAP technology.
• Expertise in Banking, Insurance, Finance, Retail, Healthcare, Automobile sectors.
• Experience in Writing TSQL (DDL, DML AND DCL), developing/creating new database objects such as Tables, Views, Indexes, Complex stored procedures, function(UDF), cursors, and triggers, locking issues, common table expressions (CTEs), Backups, Recovery and SQL Server Agent profiler using SQLSERVER 2000/2005/2008 R 2/2012/2014/2016.
• Expertise in Database Administration operations like Backup, Recovery, Replication and using SQL Profiler.
• Well versed in Normalization/Denormalization techniques for optimum performance in relational and dimensional database environments.
• Performance Tuning in SQL Server - Using SQL Profiler, DTA (Tuning Advisor), HINTS, Effective use of DMV’S/DMF’s, Optimization for AD-HOC Workloads, Plan Guides, Parameter Sniffing, DBCC commands, Partitions & Partitioning, Indexed Views & Schema Binding, STATS, Clustered/Non-Clustered Indexes.
• Expertise in solving Dead Locks/Long running queries using Performance Monitor and SQL Profiler.
• Strong skills in Power BI, Microsoft Excel - formulas, Pivot Tables, Charts and DAX Commands.
• Experienced in developing logical and physical data models using data modeling tools such as Erwin and ER/Studio.
• Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), DTS, Bulk Insert and BCP.
• Experience working with Data Cleansing technique, different types Dirty Data from different sources.
• Hands on experience loading Data warehouse for both Dimension tables and fact tables by initial load/ongoing load process using SCD, MERGE, CDC, Parent/Child SSIS packages.
• Excellent Hands on Logging, Error handling using Event Handlers pre and post for SSIS Packages.
• Built Efficient SSIS packages for processing facts and Dimension tables with complex transforms.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Experience in developing SSIS packages for data migration between different heterogeneous sources such as flat file, excel, Oracle, Sybase, DB2, MS access using SSIS 2000/2005/2008 R2/2012/2014,2016
• Experience in developing several Detail, Summary reports including line and pie charts, trend analysis reports and sub-reports according to business requirements using SSRS.
• CreatedSSRSReport Model Projects in BI studio and created, modified and managed various report models with multiple model objects, source fields and expressions.
• Created reports such as Parameterized, Cascading, Drill through/Drill down Reports, Charts and specialized in producing Sub Reports using SSRS.
• Created Job Monitoring and Financial Dashboards using Power BI and DAX quires.
• Expertise in developing several Detail, Summary reports including line and pie charts, trend analysis reports and sub-reports according to business requirements using SSRS.
• Developed MDX queries and Data Mining Expression (DMX) queries forSSAS 2008 and SSRS 2008
• Experience in generating on-demand and scheduled reports for business analysis or management decision using SSRS.
• Experience with scheduling and the deployment of the reports and uploading files to a report
• Experience in Advanced Excel like Power View, Power BI, Power Pivot and Excel Data Connection.
• Experience implementingDashboardsandScore Cardsusing Microsoft Performance Point Server and integrated with share point
• Experience in working on Data Analysis Expressions (DAX) for accessing data directly fromtabularSSAS database.
• Involved in Analyzing, designing, building &, testing of OLAP cubes withSSASand in adding calculations using MDX.
• Strong experience in Creating, Designing and Processing a Multi-Dimensional Analysis Cubes (Configured Cubes, Dimensions, Measures, MDX Queries, DAX Data mining, Data Source, Data Source Views and following Star and Snow Flake schema) using SQL Server 2005/2008/2012 Analysis Services (SSAS).

TECHNICAL SKILLS

Databases: SQL Server 2016/2014/2012/2008 R2, 2005 & 2000/7.0, MS-Access 2000, Oracle 11g/10/9i, DB2

Database Tools: SSMS, BIDS/Visual Studio

SQL Server Tools: SSMS, Configuration Manager, Enterprise Manager, Query Analyzer Profiler, DTS, SSIS, SSAS, SSRS, Database Tuning Advisor,SQL* Plus

Languages: C, C++, VB.NET, C#.NET, JAVA, PHP, UNIX, SQL, T-SQL, PL/SQL, MDX, DAX

RDBMS: SQL Server 2000/2005/2008 R2/2012, Oracle 11g/10/9i

IDE: Visual Studio 2003/2005/2008 R2/2012

OS: Windows 2003 Enterprise, Windows 2000 Datacenter, Windows NT & XP

Other Tools: Erwin/Power Designer (Data Modeling), Visio, Visual SourceSafe, MS Office suite, Quality Control(QC)

Architecture: Relational DBMS, Client-Server Architecture, OLAP, OLTP

Methodologies: Agile, Waterfall, Scrum, SDLC

PROFESSIONAL EXPERIENCE

Confidential, St Louis, MO

Sr SQL BI Developer/SSIS/SSRS/SSAS/Power BI

Responsibilities:

• Involved in writing stored procedures, Triggers, User-defined Functions, Views and Cursors for both Online and Batch requests handling business logic and functionality of various modules
• Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and created clustered and non-clustered indexes
• Created SSAS OLAP Cubes and Partitioning Cubes, monitored and full and incremental load using cube wizard.
• Created tabular, matrix, chart, drilldown reports, and parameterized, cascaded reports according to business requirement.
• Involved in developing Cubes in Business Intelligence Development Studio using SSAS.
• Involved in Analyzing, designing, building &, testing of OLAP cubes withSSASand in adding calculations using MDX.
• Generated multiple Enterprise reports using SSRS from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports (Hyperlink) etc.
• Created SSRS report templates for ease of report development.
• Created different Parameterized Reports (SSRS 2008/2012) which consist of report Criteria in various reports to make minimize the report execution time and to limit the no. of records required.
• Wrote MDX queries and expressions for use in Front End BI Applications and created SSRS reports.
• Involved in designing, developing, debugging and testing of reports in SQL Server Reporting Services (SSRS).
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).
• Generated multiple Enterprise reports (SSRS/Crystal/Impromptu) from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, Parameterized Reports.
• Developed custom calculated measures using DAX in Power BI to satisfy business needs.
• Created Job Monitoring and Financial Dashboards using Power BI and DAX queries.
• Experience in creating SSAS 2012 tabular model by adding tables to the model and creating relationships between tables.
• Integrated Custom Visuals based on business requirements using Power BI desktop.
• Developed complex SQL queries using stored procedures, common table expressions (CTEs), temporary table to support Power BI and SSRS reports.
• Involved in performance tuning of T-SQL queries and Stored Procedures
• Designed T-SQL scripts to identify long running queries and blocking sessions
• Optimized the performance of various SQL scripts, stored procedures and triggers by using embedded UDFs, CTEs and System stored procedures.
• Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases
• Involved in database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler, SQL Analyzer, and SQL Enterprise Manager.
• Developed different types of tabular reports, matrix reports (cross tab or pivot) reports, chart and graphs, reports that aggregate data using SQL Server Reporting Services(SSRS)
• Worked closely with business power users to create reports/dashboards usingSSRS.

Environment: Microsoft SQL Server 2016/2014, MS Access, MDX, DAX, SSAS, SSIS, SSRS, HTML, Visual Studio 2005/2008/2010 , IIS, Query Analyzer, ERWIN, Windows server 2008R2, TSQL, SQL Profiler, DTS, Team Foundation Server.

Confidential, Hamilton, Ohio

Sr. SSRS/SSAS Developer

Responsibilities:

• Involved in writing stored procedures, Triggers, User-defined Functions, Views and Cursors for both Online and Batch requests handling business logic and functionality of various modules
• Did SQL performance monitoring and tuning of reporting data by optimizing indexes and stored procedures.
• Involved in performance tuning of T-SQL queries and Stored Procedures.
• Used different data flow elements like Flat File, OLEDB, Excel Sources, Destinations and Data Flow Transformations like Data Conversion, Conditional Split, Derived Column etc.
• Wrote MDX queries and expressions for use in Front End BI Applications and created SSRS reports.
• Experience in OLAP cube modeling, including: MDX scripting, aggregations, partitions, dynamic dimension and cell security, KPI's, actions, write backs and perspective's development (SSAS).
• Working with large dimensions to optimize ETL load and SSAS processing times.
• Implemented SSAS dynamic dimension and cell security with user specific sub-set calculations
• Created and designed solutions that use the SSRS gateway to interface between SSRS and a web front end (ideally flex) reports to make minimize the report execution time and to limit the no of records required.
• Created Job Monitoring and Financial Dashboards using Power BI and DAX queries.
• Involved in developing Cubes in Business Intelligence Development Studio using SSAS.
• Involved in Analyzing, designing, building &, testing of OLAP cubes withSSASand in adding calculations using MDX.
• Developed complex calculated measures using Data Analysis Expression language (DAX).
• Worked extensively onDashboardsto create the reports as per the client requirements. Used session and repository variables to control access and data. Used filters to restrict data.
• Create ad-hoc SQL queries for customer reports, executive management reports
• Generated multiple Enterprise reports using SSRS from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports (Hyperlink) etc.
• Created different Parameterized Reports (SSRS 2008/2012) which consist of report Criteria in various reports to make minimize the report execution time and to limit the no. of records required.
• Experience in using SSRS gateway service calls to and from SSRS reports.
• Experience in modifying SSRS rdl (XML) which is the primary role of SSRS gateway.
• Worked closely with the business users in defining and documenting reporting requirements to design, develop and maintained in SSRS 2008 R2.
• Comfortable mentoring others in my team for complex SSRS reports
• Experience in developing several Detail, Summary reports including line and pie charts, trend analysis reports and sub-reports according to business requirements using SSRS.
• CreatedSSRSReport Model Projects in BI studio and created, modified and managed various report models with multiple model objects, source fields and expressions.

Environment: SQL Server 2012, MDX, DAX, SSIS (2012/2008), SSRS (2012/2008), Visual Studio 2010/2013, MS Excel 2010, Team Foundation Server (TFS), VB.Net, ASP.Net, C#, SQL Profiler, SQL Server Agent.

Confidential, Bellevue, WA

MS SQL/SSIS/SSRS/SSAS Developer

Responsibilities:

• Involved in Data Analysis and Migration of Data.
• Involved in complete Software Development Cycle (SDLC).
• Created SSIS packages to load data into SQL Server using various transformations in SSIS.
• Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into Database and Billing Systems.
• Capture business objectives and processes and design and develop a comprehensive application and solution.
• Extract the data from various sources like SQL Server, Text files, and access into Data Warehouse
• Works with SQL Server, SSIS technologies and has a good Data Warehouse knowledge and tools.
• Extract Transform and Load (ETL) source data into respective target tables to build the required data marts.
• Documentation for all kinds of reports and SSIS packages.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc.
• Successfully conducted root cause analysis to identify the underlying issues and design solutions accordingly.
• Involved in the data mapping sessions and creation of Data dictionary.
• Migration of the data from one environment to another environment. Testing and analysis of the migrated data.
• Identify and replace manual processes and exchange of data with an Automated System.
• Implement the best design patterns in data migration to adapt for future changes.
• Review several test plans and test scenarios with the QC team for each project worked on.
• Involved in designing, developing, debugging and testing of reports in SQL Server Reporting Services (SSRS).
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).
• Generated multiple Enterprise reports (SSRS/Crystal/Impromptu) from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, Parameterized Reports.
• Worked on Performance tuning of ETL transformations, data validations and Stored Procedures.
• Worked on XML along with PL/SQL to develop and modify web forms

Environment: Microsoft SQL Server 2012/2008/2005 , MS Access, MDX, DAX, SSAS, SSIS, SSRS, HTML, Visual Studio 2005/2008/2010 , IIS, Sybase 12.0, Query Analyzer, ERWIN, Windows server 2008R2, TSQL, .Net, SQL Profiler, DTS, Team Foundation Server, CITRIX, CISCO Any Connect.

Confidential, PA

MS SQL/BI Developer

Responsibilities:

• Experience in writing Stored Procedures, Views, and Functions in SQL using Oracle SQL Developer for data to SSRS reports.
• Create new SSIS Packages to export flat file for customer. Created and executed SSIS packages to populate data from the various data sources for different data loading operations for many applications.
• Gathered functional and non-functional client requirements to optimize the design of BI deliverables (reports, dashboards, alerts, visualizations).
• Worked closely with visual design team to select the appropriate visualizations for BI deliverables.
• Created various complex Reports such as Tablix reports for static columns and matrix report types for dynamic pivot columns using SQL Server Reporting Services 2008 using Oracle 11g as the data source.
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSASand in adding calculations using MDX.
• Created and designed solutions that use the SSRS gateway to interface between SSRS and a web front end (ideally flex) reports to make minimize the report execution time and to limit the no of records required.
• Implemented Extraction Transformation and Loading (ETL) process by pulling large volume of data from various data sources using SSIS.
• Designed and developed SSIS Packages for loading data from text files, CSV files to SQL Server databases using SSIS.
• Migrated data between different heterogeneous sources such as Flat file, Excel 2005 using SSIS.
• Experience in using SSRS gateway service calls to and from SSRS reports.
• Experience in modifying SSRS rdl (XML) which is the primary role of SSRS gateway.
• Worked closely with the business users in defining and documenting reporting requirements to design, develop and maintained in SSRS 2008 R2.
• Comfortable mentoring others in my team for complex SSRS reports.
• Wrote MDX queries and expressions for use in Front End BI Applications.
• Created KPI Objects in line with Requirement Docs and Optimized cubes for better query performance.
• Design new DTS packages as per needs, Resolve the problems.
• Migrated data from different environments to SQL Server 2008 R2 via SSIS and applied conversion and transformation procedures according to business requirements.

Environment: SQL Server 2008, Business Intelligence Development Studio, SSRS 2008 R2, SSIS 2008 R2, VB.Net, ASP.Net, MS Visual Studio 2008.

Confidential

MS SQL Server/SSIS/SSRS Developer

Responsibilities:

• Created Database Objects - Schemas, Tables, Indexes, Views, User defined functions, Cursors, Triggers, Constraints and Roles.
• Creating Distributed Partitioned Views, Debugging / Troubleshooting Stored Procedures, upgrading existing Stored Procedures.
• Created Logical and Physical data models using ERWIN data modeling tool.
• Assisted in migrating de-normalized report Database into a Star Schema design.
• Extracted data from various heterogeneous sources and created packages using SSIS, Import/ Export Data, Bulk Insert and BCP utilities.
• Worked with various SSIS control flow tasks and data transformation tasks like Data conversion, Derived Column, Look-up, Fuzzy Look-up, Conditional Split etc.
• Used various Control flow tasks like For Loop, execute package/SQL tasks, Script task, send mail task and different data flow tasks/transformation.
• Developed the reports using stored procedures by adding variables such as Language translation and Time zone by considering different scenarios according to business requirement and Executed to get the required output.
• Responsible for ongoing maintenance and change management to existing reports and Optimize report performance in SSRS-2008.
• Experience in developing several Detail, Summary reports including line and pie charts, trend analysis reports and sub-reports according to business requirements using SSRS.
• CreatedSSRSReport Model Projects in BI studio and created, modified and managed various report models with multiple model objects, source fields and expressions.
• Enhanced performance using optimization techniques-normalization, indexing and Transaction Isolation levels, monitoring logs to ensure the completeness of batch processes, scripts and processes. Created Linked Servers to connect OLE DB data sources and providers.

Environment: SQL Server 2005/2008 Enterprise Edition, SQL, SSRS, SSIS, MS SharePoint, MS Access, Windows 2003 platform, VB.NET, ERWIN, SQL Server Management Studio, Visual Studio.

Confidential

MS SQL/SSIS/SSRS Developer

Responsibilities:

• Gathered functional requirements and Business requirements and written the technical specifications for building the Global Enterprise Data warehouse.
• Created new database objects likeProcedures, Functions, Packages, Triggers, IndexesandViewsusingT-SQLinSQL Server 2000.
• Modified database structures as directed by developers for test/develop environments and assist withcoding,designandperformance tuning.
• Backupandrestoredatabases.
• High Level Design of ETL DTS Package for integrating data from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data).
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Developed several Detail, Summary reports including line and pie charts, trend analysis reports and sub-reports according to business requirements using SSRS.
• Created AD-Hoc Report models and drill down and drill thru and complex reports using SSRS
• Involved in creating, debugging, migrating, maintaining and customizing reports for Clients using SSRS.
• Created Cross-Tab, Drill-down, Drill-through, Parameterized and Sub-Report using RDL.
• Created theDTSPackagethroughETLProcess to vendors in which records were extracts from Flat file and Excel sources and loaded daily at the server.
• Managed Up gradation of DTS packages to SSIS packages.
• Implemented transactional replication among different servers.
• Provided technical guidance and support to end-users by developing documentations required.
• Performed application and database code production pushes, following production release procedures.
• Performed production SQL release final verification procedure to production.
• Documented all database changes and follow and enforce change and release management processes.
• Audited and enforced database security, code and procedural standards.

Environment: MS SQL Server 2000/2005, MS Analysis Services 2005, MS-Excel, DTS, SQL Server Management Studio (SSMS), Business Intelligence Development Studio (BIDS), VSS.