SUMMARY:

• Experience in installing, configuring, managing, monitoring and troubleshooting SQL Server 2000/ 2005/2008/2008 R 2/2012/2014.
• Experience with all phases of software developmentlife cycle (SDLC) and project methodologies.
• Excellent skills in implementing ETL Packages using Data Transformation Services (DTS) and SSIS 2005/ 2008/2008 R 2/2012/2014.
• Migrated DTS packages to SSIS and modified using DTS editor wizard.
• Developed a dashboard solution for analyzing STD statistics by building SSIS 2012 cubes and Tableau
• Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.
• Worked with the Version control Systems like Team Foundation Server (TFS), Visual Source Safe (VSS).
• Proficient in usage of SSIS Control Flow items (For Loop, Execute package/SQL tasks, Script task, send mail task) and SSIS Data Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Fuzzy Grouping, Pivot).
• Trained and experience in working on Splunk and developing dashboards on Splunk server.
• Extensively worked on Erwin Data Model Tool and good knowledge of Relational Database Modeling/Loading and Dimensional database modeling concepts.
• Experience in building SSIS packages (.Dtsx) involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server.
• Designed and developed a series of complex Business Intelligence solutions using Pentaho Report Designer.
• Experience in writing Multidimensional Expressions (MDX) and used the MDX queries in the report generation
• Designed and implemented solution to integrate applications with Partner Company like GSI,DAX for more than 36 applications.
• Experience in creating Jobs, Alerts, SQL Server Mail Agent, and schedule using DTS/SSIS Packages.
• Hands on experience working with SSIS, for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations.
• Experience in Importing/Exporting Data from various data sources like SQL Server, Excel, DB2 and Flat file using DTS utility.Installation of netezza performance portal
• Experience in Designing, Creating, Deploying and Processing of Cubes using SSAS.
• Good experience in Designing Aggregations and pre - calculating the same in SSAS 2005/2008/2008 R2/2012.
• Excellent hands on experience in creating groups, hierarchies and measures, KPIs.
• Through knowledge in Teradata and Oracle RDBMS Architecture.
• Experienced in troubleshooting Teradata scripts, fixing bugs and addressing production issues and performance tuning.
• Developed a dashboard solution for Integrated SAP ECC, SAP BW with IBM Information Server.
• Expertise in designing complex reports like Drill-Down Reports, Drill-Through Reportsand ParameterizedReports using SQL Server Reporting Services (SSRS) based onclient requirement.
• Expert in creating Ad-Hoc reports, Linked reports, Snapshot reports, Cross-Tab, Conditional, Top N and Sub reports using SQL SSRS.Proficient in creating StandardSubscriptions and Data driven subscriptions for delivering reports to people internally within the project.
• Expert in deploying the SSRS reports using Report manager.
• Built effective queries for high-performance reports and rendered them to HTML, XML, PDF and Excel formats using SSRS.Integration of SSRS Reports using various web parts into Share point (MOSS 2007) and various delivery mechanisms.
• Strong experience with Crystal Reports.Strong Data Mapping Experience ORACLE. Administered and optimized MySQL and SQL Server 2000 databases. Data modeling experience using Erwin Data Modeler and MS Visio.
• Strong ASP.NET, VB.NET knowledge.Expertise in RDBMS concepts such as Tables, User Defined Data Types, Indexes, Indexed Views.Good experience on Qlikview Business Intelligence reporting tool for developing dynamic reports.
• Expert in ComplexStored Procedures, User Defined Functions (UDFs), Triggers, Common Table Expressions (CTEs), Table Variables and Views.Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables and established relationships between tables using Primary Key&Foreign Key Constraints.
• Migrated the MySQL database to SQL Server 2000
• Evaluated database performance and performed maintenance duties such as Tuning, Backup, Restoration and Disaster Recovery. Developed MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.
• Experience in calculating measures and dimension members using Multi-dimensional expression (MDX), mathematical formulas, and user-defined functions.Experience in creating Cell Level Security in cubes using SSAS.
• Experience in SQL Optimizing by using SQL Profiler, Index Tuning Wizard, Database Tuning Advisor(DTA), DBCC Commands and Query Execution Plans.Designed and Developed KPIs, Aggregations and Cube Partitions.
• Good Knowledge and working exposure in Informatica Power Center 9.5
• Very good communication skills, good interpersonal skills & desire to excel, fast learner, hardworking and a versatile team player.

TECHNICAL SKILLS:

Operating Systems: Windows NT 4.0, Windows 2000 Server, Windows 2000 AdvancedServer, Windows 2003 Server, Windows XP, Windows Vista, 7.

Programming Languages: SQL, SQL*Plus, HTML, XML,C,C++, DS, Visual Studio 2005,MDX

Software: MS Office 2010/2007, RDBMS, MS SQLServer 2008/2005/2000SQL Server: Management Studio(SSMS), SSAS, Oracle 9i, MS Access

ETL Tools: DTS, SQL Server Integration Services(SSIS)

Database: Query Tools MS SQLServer Query Analyzer, SQL Profiler

PROFESSIONAL EXPERIENCE:

Confidential, Columbus, OH

ETL SSIS Developer/BI developer

Responsibilities:

• Involved in development and implementation of SSIS, SSAS and SSRS application solutions for various business units across the organization
• Developed SQL scripts for administration task
• Maintained SQL scripts, indexes, complex queries for data analysis and extraction
• Manage database and transaction log files, auto loans log files using scheduled script
• Upgraded MS SQL Server 2008 R2 database to MS SQL Server 2012, by using Detach/Attach, Back up & Recovery
• Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Supported in creating KPI, calculation members and measure groups, and MDX queries
• Designing and developing reports using Tableau.
• Develop, Design & Implement end to end BI solutions using Microsoft BI suite, Tableau & PowerBI
• Experience in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server
• Utilized Tableau & Power Bi server to publish and share the reports with business users.
• Created data models using QlikView scripting based on a 3-tier architecture.
• Integrated SAP ECC, SAP BW with IBM Information Server.
• Involved in developing database objects such as procedures, triggers, constraints, indexes and views. Used T-SQL to build dynamic stored procedures. Installation of netezza performance portal
• Extensively worked in Service Oriented Architecture (SOA) through WCF, RESTful Services and C#.NET.
• Implementing logical and physical data modeling with STAR schema using Erwin in Data Mart.
• Developed SSIS packages for File Transfer from one location to the other using FTP task
• Used ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse
• Performed Teradata and Informatica performance tuning
• Extensively created and used various Teradata Set Tables, Multi-Set table, global temporary tables, and volatile tables.
• Developed several Tableau reports for Sales using Sales Data for Different Vendor.
• Developed modules of application in ASP.NET and involved in writing C# classes.
• Involved in development of UI and server side code (behind file) using asp.net coding
• Created Power BI Dashboards with interactive views, trends and drill downs along with user level security
• Development, creation and sharing Reports, Charts, and Dashboards by applying different filters from SSAS cubes using Microsoft Power BI tool and Cube View Reporting tool.
• Worked on ASP.NET validation controls for validating the personal information provided by the Customer.
• Created SSAS OLAP Cubes and Partitioned Cubes. Developed Multi-Dimensional Objects (Cubes, Dimensions) using MS Analysis services (SSAS). Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS
• Generated ad-hoc reports using MS Reporting services and Crystal reports
• Worked on Erwin Data Model Tool and good knowledge of Relational Database Modeling/Loading and Dimensional database modeling concepts. Developing & deploying apps with Splunk.
• Performed data analysis and data profiling using complex SQL on various sources systems including Oracle and Netezza.
• Undergone complete life cycle implementation with experience in Data Modeling, Extraction, Loading, Scheduling, Monitoring, Reporting and Performance Tuning. Used ADO.NET strongly typed datasets to insert, update and retrieve data from a SQL Server database.Used ADO.NET and Data grid for data manipulation. In-depth knowledge on Tableau Desktop, Tableau Reader and Tableau Server.
• Generated DDL Scripts from Physical Data Model using technique of Forward Engineering in Erwin.
• Responsible to add data and maintain the data on Splunk Server. Created data models using QlikView scripting.
• Perform server and application checks for any alerts, warnings errors and resolving the issue. Use of the monitoring tools such as Splunk and Log Parser to understand the logs.
• Worked exclusively with the Teradata SQL Assistant to interface with the Teradata.
• Experience in Using QlikView Functions (Date and Time, Join, String & input Fields etc...)
• Involved in designing and developing logical and physical data models to best suit the requirements.
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS. Created reports using SSRS from OLTP and OLAP data sources and deployed on report server.
• Involved in analyzing source systems and designing the processes for Extracting Transforming and Loading the data to Teradata database. Extensively used Erwin for developing data model using star schema methodologies.
• Developed charts and Graphs using Power Pivot.
• Created Dimensional and Relational Physical & logical data modeling fact and dimensional tables using Erwin.
• Developed Parameterized SSRS Reports and PowerPivot workbook using Data of Tabular model and Cube Data model to prove the functionality of Database.

Environment: Windows 2003 Server/XP, WCF, SQL Server 2014, Teradata, SQL Integration Services(SSIS), Netezza, SPLUNK, SQL Reporting(SSRS), SSAS, Business Intelligence Studio, Visual Studio 2008/2005, Team foundation Server, Tableau, VB.NET, OLE DB, Qlikview, DTS Package, SharePoint MOSS 2007, Crystal Reports, Erwin 4.0, VB.Net, HTML.

SSIS Developer/BI developer

Responsibilities:

• Involved in Planning, Defining and Designing data, based on business requirements and provided documentation.
• Worked with the Statisticians, Data Managers to provide SAS programming in analyzing Clinical Trial Data.
• Modified the SAS datasets according to the requirements of the statistician.
• Involved in development and implementation of SSIS, SSAS and SSRS application solutions for various business units across the organization.Maintained SQL scripts, indexes, complex queries for data analysis and extraction.
• Involved in Extraction, Transformation amp; Loading (ETL) process and used Informatica Power Center tools - Source Analyzer, warehouse designer, Mapping Designer, Workflow Manager and Workflow Monitor.
• Used Pentaho Data Integration Designer to create ETL transformations
• Designed Data Mapping documents, DDL scripts, and Data Dictionary and Meta data of the models and maintained them.Developed SQL scripts for administration task.
• Executed Queries in AS400 Database and Oracle Database.Tuned and optimized SQL statements for the Oracle environment, and assisted in overall tuning of the COSMOS database.
• Used .NET provider Data Reader Source Task to Read from RDBMS sources.
• Involved extensively in Functional Testing, System Testing, Integration Testing and Regression Testing and Content Testing, both manually as well as using automated testing tools including Quality Center, QTP, SAP TAO and Load Runner.
• Wrote LINUX Shell scripts for Informatica ETL Tool and Navigate log files.
• Getting data from various source system and create a staging area in Netezza and staging datasets are inputs to create Target dataset and those are stored in same Netezza in target folder.
• Loading data by using the Teradata loader connection, writing Teradata utilities scripts (Fastload, Multiload) and working with loader logs.
• Performed data analysis and data profiling using complex SQL on various sources systems including Oracle and Netezza.
• Reduced Teradata space used by optimizing tables - adding compression where appropriate and ensuring optimum column definitions.
• Worked in ASP.NET Web forms, State management and Caching feature.Design and development of business objects, middle tier components and Windows services in C#, CSLA Framework and applied SOLID Principles.
• Designed different type of STAR schemas using ERWIN with various Dimensions like time, services, customers and FACT tables. Designed screens using CSS rules which were developed by designers. Created angular directives to use as commons across the application. Used ASP.Net Web API for services and Oracle database. Created Web API controllers for different modules. Worked with Project specific physical and logical data modeling.
• Maintained WCF services across the enterprise and integrating UI using MVC pattern
• Developed some codes to work on Visual Studio 2008 and Team foundation server(TFS) also used the same code in SSRS to generate Reports.Upgraded MS SQL Server 2008 R2 database to MS SQL Server 2014, by using Detach/Attach, Back up & Recovery.Connect QlikView to multiple data sources Oracle and MS Excel.
• To create robust data model by considering the QlikView Scripting and Data Model standards and best practices.
• Through knowledge in Teradata and Oracle RDBMS Architecture.
• Experienced in troubleshooting Teradata Scripts, fixing bugs and addressing production issues and performance tuning.
• Created Dimensional and Relational Physical & logical data modeling fact and dimensional tables using Erwin.
• Involved in creation of Data Warehouse database (Physical Model, Logical Model) using Erwin datamodeling tool.
• Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts.Worked on various RDBMSs such as MS SQL Server 2000, Access 2000 and MySQL
• Created SSIS packages to extract data from OLTP and transformed to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.Created Alerts for successful or unsuccessful completion of Scheduled Jobs.
• Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Supported in creating KPI, calculation members and measure groups, and MDX queries
• Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Worked with the Version control Systems like Team Foundation Server (TFS), Visual Source Safe (VSS).
• Developed a dashboard solution for Integrated SAP ECC, SAP BW with IBM Information Server.
• Synchronization has been done between Informatica Metadata and data modeling diagrams.
• Experience in creating Jobs, Alerts, SQL Server Mail Agent, and schedule DTS/SSIS Packages.
• Developed a dashboard solution for analyzing STD statistics by building SSIS 2012 cubes and Tableau
• Experience in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server.
• Involved in developing database objects such as procedures, triggers, constraints, indexes and views. Used T-SQL to build dynamic stored procedures.Developed SSIS packages for File Transfer from one location to the other using FTP task
• Used ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Customized business reports using Power BI as per requirements
• Used Team Foundation Server (TFS) for source version control on a shared team environment.
• Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.
• Analyzed the data from multiple sources such as Microsoft (MS) SQL Server, MS Access, Legacy systems, Mainframes, DB2, SalesForce Automation (SFA / SaaS), Microstrategy (MSTR), Tableau.
• Created different schema objects like Attributes, facts by using MicroStrategy Architect of the Micro Strategy BI Suite.
• Created Tableau & Power BI Dashboards with interactive views, trends and drill downs along with user level security
• Involved in creating Micro Strategy objects like Metrics (Conditional, Transformational, Dimensional, and Compound), Filters, Prompts (Filter, Object), Templates and Reports
• Generated ad-hoc reports using MS Reporting services and Crystal reports.
• Worked on Erwin Data Model Tool and good knowledge of Relational Database Modeling/Loading and Dimensional database modeling concepts. Part of a one week training program for Splunk.
• Involved in creating dashboards and reports for various scenarios.
• Responsible to add data and maintain the data on Splunk Server
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS. Provided Ad-hoc queries and Reports for Companywide users pulling data from Multi-terabyte data warehousing systems.
• Created reports using SSRS from OLTP and OLAP data sources and deployed on report server.
• Experienced in creating SSAS OLAP Cubes and Partitioning Cubes.
• Designed and implemented solution to integrate fanatics applications with partner company like GSI,DAX for more than 36 applications.Defined Calculated members, named sets, and executed other script commands using MDX expressions.
• Conducted weekly Crystal Reports training session for the reports team
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Performed T-SQL tuning and optimization of queries for reports that took longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Generated reports using SSRS which were sent to different Clients, and managers
• Performed Documentation for all kinds of reports, DTS and SSIS packages.
• Created complex Stored Procedures, triggers, cursors, tables, and views and other SQL joins and statements for applications by using T-SQL.Maintained the table performance by normalization, creating indexes and collected statistics by using query optimization, query execution plans, SQL Server Profiler and Database engine tuning Advisor.
• Designed and developed and normalized tables for the MySQL database
• Developed Multi-dimensional Objects (Cubes, Dimensions) using MS Analysis services (SSAS).

Environment: Windows 2003 Server/XP, SQL Server 2014, Teradata, SQL Integration Services(SSIS), SQL Reporting(SSRS), SPLUNK, Business Intelligence Studio, Visual Studio 2008/2005, Team foundation Server, Tableau, WCF, VB.NET, OLE DB, DTS Package, SharePoint MOSS 2007, Crystal Reports, Erwin 4.0, VB.Net, HTML.

ETL SSIS Developer/BI developer

Responsibilities:

• Involved in creating Business requirements and from Business User.
• Conducted Data Migration processes in the SQL Server environment using SQL Server Integration Services 2005.
• Conducted and automated the ETL operations to Extract data from multiple data sources, transform inconsistent and missing data to consistent and reliable data, and finally load it into the Multi-dimensional data warehouse.
• Worked on FACETS Data tables and created audit reports using queries. Manually loaded data in FACETS and have good knowledge on FACETS business rules.
• Conducted extensive analysis on migration and conversion of Provider and Member data, Group configurations, plan codes, benefit set-ups, fee schedules, provider pricing, capitation set-ups, etc from Legacy system (Amysis) to FACETS (Client Server based system).
• Performed the forward and backward data mapping between the fields in mainframe and FACETS .
• Extensively worked with complex and huge datasets, and generated reports in various formats such as PDF, RTF, HTML and list files using SAS ODS facility.
• Performed gap analysis and data mapping for HIPAA X12 4010 to 5010 migration .
• Expertise in verifying and understanding EDI raw data, both in 4010 and 5010 format.
• Extensively used T-SQL in constructing user functions, views, indexes, user profiles, relational database models, and data integrity.
• Performed Data mapping, logical data modeling and created ER diagrams
• Used different transformations like Conditional Split, Lookup, Merge Join, Aggregate, Fuzzy Grouping etc. for creating many SSIS packages.
• Created many Variables that were used to pass parameterized values into the package which makes the package Dynamic.Created logical and physical database design using Erwin.
• Integrated SAP ECC, SAP BW with IBM Information Server.Designed many Configuration files that were used to pass parameters from outside the Business Intelligence Development Studio (BIDS) into the packages using XML files.
• Used Microsoft Visual Source Safe (VSS) and Team Foundation Server (TFS) for integration, maintenance and Security of code.Developed a dashboard solution for analyzing STD statistics by building SSAS 2008 cubes and Tableau
• Ensured best practices are applied and integrity of data is maintained through security and documentation.
• Good experience on Qlikview Business Intelligence reporting tool for developing dynamic reports.
• Hands on experience in developing QlikViewDashboards using Chart Box (Drill Down, Drill up & Cyclic Grouping), List, Input Field, Table Box and Calendar etc.Hands on Experience on Power BI for developing Dashboards and Charts.
• Worked in Micro Strategy Administration creating new users, roles, privileges, shared folders, access controls Lists.
• Created Teradata Macro's and stored procedures for repeated use across various applications.
• Created several Teradata SQL queries and created several reports using the above data mart for UAT and user reports.
• Used .NET provider Data Reader Source Task to Read from RDBMS sources.Worked in ASP.NET Web forms.
• Involved in developing the Business Layer in C#.NET, where all the Business Objects are written in developing the whole Application. Designed and developed various abstract classes, interfaces, classes to construct the business logic using C#.NET. Used Entity framework as ORM tool mapping to the database.
• Created Complex SQL Queries using Views, Indexes, Triggers, Roles, Stored procedures and User Defined Functions Worked with different methods of logging in SSIS.
• Designed and developed and normalized tables for the MySQL database. Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts and performed action in XML.
• Used MDX to create calculated members in the cube. Worked on Event Handlers to do Event handling on error at the package and task level on error, on warning and configured it using send email task and script task.
• Created packages in SSIS with error handling.Involved in performance tuning and monitoring of T-SQL blocks.
• Designed reports using SQL Server Reporting Services (SSRS).
• Implemented Software Configuration Management, setting up company Version policies utilizing Team Foundation Server (TFS).Designed and Developed matrix, tabular and parametric Reports in the SQL Server Reporting Services 2005. Designing and implementing a variety of SSRS reports such as Parameterized, Drilldown, Ad hoc and Sub-reports using Report Designer and Report Builder based on the requirements.
• Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report and deployed SSRS reports.

Environment: SQL Server 2005, Windows 2000/2003, Teradata, MS Access 2000/2003,T-SQL, Windows 2000 Advanced Server, Qlikview, SPLUNK, SSAS, SQL Server Integration Services(SSIS), SSRS, Crystal Reports, Tableau, VB.NET, WCF, SharePoint (MOSS) 2007, Erwin 4.0.

SSRS/SSIS/SQL DEVELOPER

• Involved in the Migration of Databases from SQL Server 2005 to SQL Server 2008
• Involved in development and implementation of SSISand SSRS application solutions for various business units across the organization.Wrote T-SQL queries and T-SQL stored procedures in SQL SERVER 2000.
• Created SSIS packages to clean and load data to data warehouse.
• Created SSIS package to transfer data between OLTP and OLAP databases using Incremental Load.
• Created SSIS Packages using Fuzzy Lookup, Derived Columns, Pivot Transformation, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Scheduled Cube Processing from Staging Database Tables using SQL Server Agent.
• Configured complex SQL queries to meet customer requirements as needed.Worked on Complex SSRS Reports, Sub Reports, Graphing, Data Drill-Down, and Data sorting/grouping, Crystal Reports Design.Deployed and uploaded the SSRS reports to SharePoint Server for the end users and involved in enhancements and modifications.
• Developed a dashboard solution for analyzing STD statistics by building SSAS 2008 cubes and Tableau
• Created Crystal Reports using Crystal Reports formulae, Grouping, Parameters, Selection criteria.
• Experienced in creating SSAS OLAP Cubes and Partitioning Cubes.
• Wrote MDX queries to retrieve the data from data warehouse dimensions and to perform analysis
• Experienced in using Dimension Usage, Aggregations, Calculation and Perspective on a Cube.
• Experience in SQL joins, sub queries, tracing, usage of Table Variables, Temp tables etc.
• Involved in optimization of queries, improving the performance by using various approaches from execution plans, Index optimization, and DMV’s.
• Hands on experience in developing QlikViewDashboards using Chart Box (Drill Down, Drill up & Cyclic Grouping), List, Input Field, Table Box and Calendar etc.Carry out creation of SDLCdocumentation for existing applications
• Assigning new Users and permitting access rights to the users.
• Worked with Splunk support team to resolve the Splunk issues.
• Filtered inaccurate data from legacy system using complex T-SQL statements, and implemented various constraints and triggers for data consistency.Created views to display required information on user interface, and triggers to validate consistent data entry into the database.
• Created checks and constraints to maintain data integrity and created Complex Stored Procedures.

Environment: MS SQL Server 2005/2008, SQL Server Integration services (SSIS), VB.NET, SSAS, Tableau, SQL Server Reporting Services (SSRS), BIDS and Windows 2003, SharePoint (MOSS) 2007.

SQL Server Developer/SSIS/SSRS/SSASMDX

Responsibilities:

• Created SSIS packages and used Analysis Services processing task to update the cube with current data.
• Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into Databaseand Billing Systems. Extract Transform and Load (ETL) source data into respective target tables to build the required data marts
• Created SSIS packages to load data into SQL Server using various transformations in SSIS.
• Analyzed the existing tool and participated in meetings with the business users to gather
• Requirements and design goals of data warehouse.
• Identified the dimension, fact tables and designed the data warehouse using star schema.
• SSAS storage and partitions, aggregations, calculation of queries with MDX, data mining models, developing reports using MDX and SQL. Deployed and processed OLAP Cubes.
• Developed Aggregations, partitions and calculated members for cube as per businessrequirements.
• Defined appropriate measure groups and KPIs&deployed cubes.
• Created Parameterized reports, Cross-Tab reports, Drill down reports& Summary reports by using SSRSand designed reports using Crystal Reports.Created report snapshots to improve the performance of SSRS.
• Developed new objects (i.e. Tables, Views, and Stored Procedures) in SQL server 2005 database and performed tuning on it.
• Migrated database from SQL server 2000 to SQL server 2005 using utilities i.e. exp/imp and attach/detach for SQL servers 2005 futures.

Environment: SQL Server 2005, Windows 2000/2003,T-SQL, Tableau, SQL Server Integration Services, VB.NET, SQL Server Reporting Services, SQL Server Analysis Services, SQL Profiler, MS Excel 2003, MSIIS,Visual Studio 2005, Visual Team Foundation Server, Crystal Reports.

SQL BI/SSASMDX /SSRS/SSIS

Responsibilities:

• Involved in developing database objects such as procedures, triggers, constraints, indexes and views. Used T-SQL to build dynamic stored procedures.
• Created data-related documentation (e.g., file descriptions and definitions, entity relationships and attributes, etc.).
• Managed Database files, transaction log and estimated space requirements.Monitored database application.
• Responsible for developing automation of maintenance jobs, tuning SQL Server locks and indexes configurations, administering SQL Server security.Experience in calculating measures and dimension members using Multi-dimensional expression (MDX), mathematical formulas, and user-defined functions.
• Designed and implemented several complex reports and administration modules.
• Used .NET provider Data Reader Source Task to Read from RDBMS sources.
• Worked in ASP.NET Web forms, State management and Caching feature.
• Designed stored procedures for module integrity and application.
• Involved in installation, upgrade and configuration of Microsoft SQL Server and databases.
• Involved in Microsoft SQL Server Database Administration including planning, backup, and recovery strategies.
• Implemented High availability concepts, Data base Mirroring, Replication and log shipping.
• Involved in Performance Tuning, Query Optimization, Database consistency checks using DBCC utilities.
• Involved implementing Disaster Recovery for minimal downtime using different types of database backups, restore, and replication.

Environment: SQL Server v2000, T-SQL, Win NT v4, Win 2000, MS Excel, ASP.NET