PROFESSIONAL SUMMARY:

• A Microsoft Certified Professional with a career spanning over 10+ years as a Business Intelligence Developer, Data Engineer, Reports Developer with Strong technical and analytical skills.
• Proficient in Database Design, Development, Data Analysis, ETL Implementation and support in OLTP/Data warehousing of Microsoft Server 2017/2016/2014/2012/2008R2/2008 in various SDLC environments, building custom reporting solutions/dashboards, and implementation of data warehousing solutions using T - SQL/SSRS/SSIS/SSAS/Azure Services. Design and Implementation of Visualizations using Power BI and Tableau.
• Experience in various Business Domains like Banking, Insurance, Pharmacy, Health Care, Oil and Gas dealing with High transactional, Multi - Server Production Environment.
• Extensively worked on Data Modeling, data mappings& Data dictionaries using ERWIN, BPWin, SQL Diagrams
• Extensive experience in ETL activities (Process Support, Multi-dimensional cubes, Reporting, KPIs and Dashboards) using SSIS, SSAS, SSRS and other tools.
• Solid Knowledge in Designing Database Objects like Tables, Constraints, Views, Indexes and Validation Checks.
• Experienced in creating and troubleshooting SQL, T-SQL Commands, Stored procedures, Triggers and Functions in MS SQL Server 2008R2, 2012, 2014,2016,2017.
• Excellent knowledge in Performance Tuning and Query Optimization using SQL Profiler, Execution Plan, Performance Monitor.
• Experiencein creating Conceptual, Logical and physical Datamodels, Dimensional models, Star Schema and Snowflake Schema.
• Strong analytical, organizational, documentation and communications skills.
• Experience working in a dynamic, deadline oriented environment.
• Diagnose and resolve system, application software or other related problems that impact database availability
• Designing and maintaining ETL solutions using SSIS,perform data migration using SSIS and other applicable tools
• Strong experience in supporting Analysts and Developers on the analysis of database changes and creation of scripts for deployments.
• Expertise indeveloping test plans and test data for database systems and support software, refreshing QA and Development environments for QA and Development teams.
• Experience with traditional software lifecycle methodologies, including Agile.
• Business Intelligence (DTS, SSIS, SSRS, SSAS) Experience:Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server using BCP utility, DTS and SSIS services.
• Data migrating (using ETL tools like DTS, BULK INSERT, BCP) between different homogeneous/heterogeneous systems and SQL Server as a part of Data Migration and Data Maintenance.
• Data Warehouse architect skilled in data modeling, ETL architect design and development.Have architected Extract Transformation and loading solutions.
• Worked with several Control Flow Tasks, Data Flow Tasks and Transformations (Lookup, Merge Join, Conditional Split, Slowly Changing Dimensions, Data Conversion etc.) in SSIS Package Development.
• Highly experienced with DTS/SQL Server Integration Services (SSIS) Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing Data transfers and ETL Purposes across different servers.
• Expertise in handling Errors by using Event Handler and can provide Logging, Custom Logging for SSIS Packages.
• Varied experience in operational, analytical & predictive analysis reporting, designing Metadata layer for ETL
• framework.
• Involved in usage of various SSIS components like Forloop, Foreachloop, FuzzyLookup, Variables, and Error Handling etc.
• Designed Data Model in Power BI Designer according to the Structure and Hierarchy of Data.
• Utilized Power Query (M Language) in Power BI to Pivot and Un Pivot the data model for cleaning and massing.
• Hands-on-experience on Reporting Architecture components and various tools of SQL Server Reporting Services (2008/2008R2/2012/2014/2016).
• Solid designing and development experience in developing various kind of reports like Cascading parameters, pick lists, Drill down, Drill through, Sub Reports and Charts. Creating SSRSreports based on Power Pivot and publishing onto SharePoint.Expert in Power Viewto design Adhoc reports.
• Expert in designing Enterprise reports using SQL Server Reporting Services and Excel Pivot table based on OLAP cubes which make use of multiple value selection in parameters pick list, cascading prompts, matrix dynamics reports and other features of reporting service.
• Experience in creating highly analytical & detailed reports from ERP system for various departments like sales, purchasing, inventory, financial, customer service, marketing, data warehouse, and human resource by using SQL Server Reporting Service, SQL Server Analysis Service (OLAP).
• Expertise skills in creating OLAP Cubes, calculating measures and dimension members in SQL Server Analysis Services (SSAS 2005/2008/2012/2014) using multi-dimensional expression (MDX), mathematical formulas, and user-defined functions .
• Involved in Data Modeling using Erwin, Star and Snowflake Schemas.
• Experience in designing Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, and Data Modeling like Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables using Analysis Services.
• Knowledge on integration of BI suite of products with Microsoft Office range of products like MOSS (SharePoint), Business Scorecard Manager, Dashboards, Performance Point Server.
• Writing MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.
• Developed cubes using Partitions, KPI’s, and Perspectives, slow moving dimensions etc. and created various user roles.
• Built SSAS Tabular Models from scratch.
• Created Measures and Columns in tabular model using DAX queries and created partitions in tabular model.
• Implemented various DAX functions such as CALCULATE, SUMX, FILTER, HASONEVALUE, ISFILTERED, TOTALYTD, RANKX, RELATED, SUMMARIZE, USERELATIONSIP, SAMEPERIODLASTYEAR, ISBLANK, IF
• Built KPIs in tabular based on the end user requirements, worked on Performance of SSAS tabular models.
• Implemented Perspectives and Roles in Tabular Models.

TECHNICAL SKILLS

Programming Languages: SQL, T-SQL, PL/SQL Dynamic SQL, MDX, HTML, XML, DHTML, C, C++,VB Script, Shell Scripting, C# .NET,VB .NET, ASP .NET, ADO .NET, Visual Studio, XML, ActiveX, MS Access, Lotus notes, DAX, Python, Pyspark.

RDBMS: MS SQL Server 2000/2005/2008/2012/2014/2016,MS Access 97/2000/2003,SybaseTeradata V2R5, Oracle 8i/9i/10g, IBM DB2 UDB 8.2/8.0,MS Visual Source Safe.

Database Design Tools and Data Modeling: MS Visio, ERWIN 4.5/4.0,Star Schema/Snowflake Schema modeling Relational, Fact& Dimensions tables, Dimensional and multi-dimensional modeling Physical & logical data modeling and De-normalization techniques, Kimball& Inman Methodologies, MSX, MS Access, MS Project.

Tools And Utilities: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Visual Studio.Net, IIS 6.0/7.0Microsoft Management Console, Visual Source Safe 6.0,DTS,Business Intelligence Development Studio (BIDS),Crystal Reports 9.0, Power View, Power Pivot, Business Objects, Web Services.

Operating Systems: Windows 95/98, NT, Windows 8/7/XP/2003/2000, Unix, MS- DOS.

DWH / BI Tools: SQL Server Reporting Services(SSRS),SQL Server Analysis Services(SSAS),SQL Server Integration Services(SSIS), Business Intelligence Development studio(BIDS), Visual Studio, Crystal Reports 9.0, Performance Point Server, ProClarity, SQL*Plus, SQL*Loader, MS Visio, Erwin, Informatica 6.x.

Version Control And Configurations: Visual SourceSafe 6.0/2005, Remedy Change Management, Clear Case, Clear Quest, Visual Studio Team Foundation Server, Azure DevOps, GitHub

Packages: MS Office, MS Outlook (Microsoft Office Suite), Microsoft Office SharePoint Server (MOSS) 2007, Microsoft Performance Point Server 2007.

Portal: SharePoint Portal Server 2003/2007, Windows SharePoint Services

Visualization Tools: Power BI Desktop, Power BI Service, Tableau

Cloud Technologies: Azure, Azure Data Lake Storage Gen2, Azure Data Factory, Azure Databricks, Azure SQL, Cosmos DB, Azure Synapse.

PROFESSIONAL EXPERIENCE

Confidential, San Antonio, TX

Sr. Data Engineer

Responsibilities:

• Worked on Huge data migrations, huge data transfers, ETL processes using SSIS for Data warehouse implementation Projects involving conversion of data from heterogeneous sources to Enterprise Datawarehouse (EDW).
• Responsible for Data mapping document: from Staging/Data warehouse/Report-Data mart.
• Translated business requirements and end user’s needs into architectural models to deliver high quality BI solutions.
• Participated in scope, design and delivery of advanced, scalable BI and Analytics solutions in partnership with business stakeholders and senior data warehouse team members.
• Implemented Slowly changing dimensions, role playing dimensions, junk dimensions and conformed schemas to support reporting needs.
• Created SSISpackages to load data fromFlat Fileto Flat File and Flat File to Data warehouse and Report-Data mart usingLookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation and Slowly Changing Dimension.
• Extensive experience in SSIS Development, Deployment (Package and Project Deployment Model) and Maintenance and used various SSIS Components such as Event Handlers, Logging and Tasks such as Execute SQL Task, Data Flow Task, Custom C# Script Task/Script Component, Execute Package Task.
• Developed complex T-SQL Stored Procedures, Tables, Views, Indexes, Cursors, and performed Query tuning/optimization.
• Worked extensively on performance Tuning by Index Defragmentation and Query Optimization using SQL Profiler, Execution Plan, and Performance Monitor.
• Created logical and physical relational and multi-dimensional (OLAP) data modeling models using best practices and compliance with BI data models (Snowflake, Star Schema) for Transactional and Enterprise Datawarehouse (EDW) systems.
• Select the appropriate data types and sizes for the new fields added to the system data model.
• Experienced in MS SQL Server 2016/2014/2012 Reporting (SSRS) Development, Configuration, Deployment and Maintenance. Developed various Drill Through, Drill Down, Parameterized Reports, Sub Reports, Cross Tab Reports and administered the SSRS Report Manager and Server.
• Created SSAS Tabular Models off the data warehouse and built Pivot Table templates for the end users.
• Involved in creating complex measures including ranking, KPIs, aggregation by DAX in SSAS Tabular Models according to business requirements. Involved in designing and implementing partitions in the Tabular Models.
• Designed dynamic row level security for entire global procurement team with different level of users utilizing complex DAX functions within SSAS tabular model.
• Deployed and scheduled reports using SSRSto generate all daily, weekly, monthly and quarterly reports including current status.
• Built custom Reports for Business forecast using Power BI Desktop and Power BI Service.
• Experience in working on Cube structure optimization for MDX query performancein Analysis Services
• Designed and developed Power BI (Tabular) Models from Azure Data Lake and Published them to Power BI Service to promote Self-Serve Power BI Reporting.
• Created Semantic Layer (on top of Azure data lake /SSAS Cubes/SQL database) to support Power BI ad-hoc and planned reporting needs of users.
• Extensively used M-Language in Power Query, created parameters to address dynamic environments, used DAX in Power Pivot to create Quick Measures, Custom Measures, columns.
• Developed Power View using various Power BI Visuals such as Bar Chart, Area Chart, Table, Card and Custom (Microsoft Store) Visuals such as Hierarchical Visuals, Sankey Chart etc.
• Created and Updated the data visualizations in Power BI reports and Dashboards on Business users requests.
• Experienced in Power BI Service maintenance such as pbix deployment, schedule on- premises gateway refreshes, power bi workspace administration and app (content pack) management.
• Designed and Implemented Power BI security using Active Directory groups and role-based security.
• Developed confidential proprietary analytical tools and reports with Confidential Excel, and Power Pivot and Power Point.
• Designed & Implemented BI solutions on Azure using Azure Data Platform services.
• Created Notebooks in DataBricks to read and write JSON, CSV and Parquet files using SQL, Python, Pyspark
• Created Data frames in DataBricks and applied various transformations like string functions, aggregations, window functions, Filtering, Splitting, Renaming, Removing duplicates etc.
• Used various complex data types like Structs, Arrays, Maps, Lists to handle complex data and flattened them using Split and explode.
• Created Managed, Unmanaged Tables, Views, Cache and Used Hive Metastore to persist tables in Databricks.
• Optimized Databricks notebooks tuning cluster configurations, Repartitioning, join types, Shuffling configurations, Memory settings and caching.
• Redesigned On-Premises SSIS Packages when moved into cloud using ADF and ADB.
• Used Extract Transform and Load data from Sources Systems to Azure Data Storage services using a combination of Azure Data Factory, T-SQL, Spark SQL, and Azure Data Lake Analytics. Data Ingestion to one or more Azure Services - (Azure Data Lake, Azure Storage, Azure SQL, Azure DW) and processing the data in In Azure Databricks.
• Designed and Developed Pipelines in ADF using Linked Services/Datasets/Pipeline/ to Extract, Transform, and load data from Sources like Azure SQL, SQL Server, CSV’s etc. to Azure Data Lake, Azure Synapse, Azure SQL.
• Some of the SSIS Packages are Deployed into Cloud from On-Premise with “Lift and Shift” after making Minimum Configuration Changes
• Leveraged Azure Cloud and Azure Pipelines along with Source Control for Continues Integration Builds and Continues Deployment (CI/CD) to Targets.

Environment: SQL Server 2012/2014/2016/2017, SQL Server Management Studio, Visual Studio, SSDT, Business Intelligence Development Studio (BIDS), Azure Data Lake, Azure Data Factory, Azure Databricks, Azure Synapse, Azure SQL, Azure Dev Ops, Power BI Desktop, Power BI Service. SSIS, SSRS, SSAS (Multi-Dimensional and Tabular), Oracle, Visio, GitHub.

Confidential, Jacksonville, FL

Houston, TX

Responsibilities:

• Worked with the team to design and develop queries in SQL Server Management Studio 2016.
• Created new database objects such as Joins, Stored Procedures, Functions and Non-Clustered Indexes to get and organize the required claim and policy data using SQL Server 2012
• Involved in Framework development for ETL Implementation and support for the Analytics and Reporting needs for various customers.
• Worked on mapping the data and creating packages for the customer's history and claims information and Extracted, Transferred and Loaded (ETL) data from Oracle, IBM DB2, Excel Spreadsheets and Flat files sources with the help of SQL Server Integration Services (SSIS) 2012
• Used BIDS to design SSIS packages to transfer data between servers, load data into database, and archived data file from different DBMS. Scheduled the job to do this task periodically.
• Experience in SSIS script tasks, Look up transformations and Data flow tasks using T- SQL, C# and Visual Basic scripts.
• Wrote new Stored Procedures for new system and optimized old Store Procedures and Functions on Production Server.
• Developed packages using various transformations like Multicast, Conditional split, OLEDB Command, Script Component and Lookup while loading the data into Destination.
• Improved data load performance by analyzing database design and query plans.
• Modified and Create Joins to Improve the Database and execution speed.
• Experience in optimizing the database by creating various clustered, non-clustered columnstore indexes and indexed views.
• Designed and Developed matrix, tabular and parametric Reports using SSRS 2012.
• Designed and developed Drill down and Drill Through reports with Drop down menu option using SSRS.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Involved in Performance Tuning using SQL Server Profiler and SQL server Hints. Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source, Excel Spreadsheet to SQL Server 2012.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations using SSIS.
• Used C# in Script Tasks (SSIS Packages)
• Developed and supported XML/XLS schemas.
• Developing OLAP cubes using SSAS 2012 and calculated the metrics that were revealed in the functional analysis.
• Developed cubes using Partitions, KPI's, and Perspectives, slow moving dimensions etc. and created various user roles.
• Experience in working on Cube structure optimization for MDX query performancein Analysis Services 2012/2008
• Developed and delivered dynamic reporting solutions using MS SQL Server 2014/2012/2008Reporting (SSRS).
• Involved in designing reports and delivering them by any of the delivery methods like standard subscriptions, data-driven subscription, URL access etc.
• Filtered bad data from legacy system using complex T-SQL statements, and implemented various constraint and triggers for data consistency.
• Created Power BI reports by using Joins in multiple tables from multiples database using complex SQL queries.
• Designed a Power BI Data Model with multiple Fact Tables and Dimensions depending on the business requirements.
• With the help of visualizations in Power BI, created various visualization like Pie charts, Bar graphs, Tree maps, Infographics, Word Cloud etc.
• Extensive knowledge of DAX code to support the business requirements in column and measure variables
• Good experience in DAX formulas such as summarize group by, Intersect, calculate, filters and SUMX, CALCULATE, Hasonevalue, Hasonefilter, Samepreiodlastyear and switch etc.
• Created various types of charts like Heat Maps, Pie Charts, Bar Charts, Tree Maps, Gantts, Circle Views, Line Charts, Area Charts, Scatter Plots, Bullet Graphs and Histograms in Power BI Desktop and Excel to provide better data visualization.
• Created ad-hocBusiness Object environmentfor reporting and analytics.

Environment: MS SQL Server 2014/2012/2008, SQL Server Analysis Services (SSAS), Reporting Services (SSRS), Business Intelligence Development Studio (BIDS), SQL Server Integration Services (SSIS), ETL, MDX, Microsoft Office SharePoint Server (MOSS) 2007, Performance Point Server 2007, ProClarity, Microsoft.NET (Asp .NET, C# .Net), Visual Source Safe, TFS, VBScript, T-SQL, Visual studio 2008, Excel, SQL Profiler,, MS Power BI, Snowflake

Confidential, Seattle, WA

Sr.SQL/ETL Developer (SQL/SSIS)

Responsibilities:

• Worked with Business to identify requirements for the integration/migration project from ETL/Data Migration perspective.
• Worked closely with the BA’s and users to understand the Business Requirement Documents (BRD) and transform them to Technical requirements.
• Define Mapping documentation for the ETL process.
• Performed Data Mapping to determine where identified source data belonged in the Data Base.
• Perform source system data analysis to manage source to target Data Mapping.
• Involved in various projects related toData Modeling, System/Data Analysis, Design and Development for both OLTP and Data warehousing environments.
• Facilitated data requirement meetings with business and technical stakeholders and resolved conflicts to drive decisions.
• Practical understanding of theData modeling(Dimensional & Relational)concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Implemented Extract, Transform and Load (ETL) strategy by architecting and creating a project wide Custom ETL Framework to support the migration.
• Used the SQL Server database tables and implemented referential integrity among them to create the ETL Control Database to handle the ETL Framework.
• Embedded the ETL Framework in the ETL packages (SSIS packages) created to migrate the data across different stages.
• Designed the SSIS packages using various control flow tasks such as Execute SQL Task, Data Flow Task, Sequence Container.
• Used various Data flow tasks such as OLEDB Source, Union ALL, Derived Column, Conditional Split, Multicast and OLEDB Destination etc. in the SSIS packages.
• Managed the Control Flow of the packages using Precedence Constraints and Sequence Containers.
• Implemented Parent Child Packages using Execute Package Task and managed the flow using the ETL Framework.

Environment: SQL Server 2012/2014, Visual Studio, SSDT, Business Intelligence Development Studio (BIDS), MS Office, MS Office SharePoint, MS Visio, SQL Server Integration Services (SSIS). Microsoft Dynamics AX, DIXF, SQL Server Agent, MS Power BI, Snowflake

Confidential . Houston, TX

Sr.Business Intelligence Developer (SSRS/SSIS/SSAS/SQL)

Responsibilities:

• Extensively worked on MS-SSRS, SSISand Slowly Changing Dimensions.
• Adept at rebuilding indexes on various tables.
• Created temporary tables and table variables while creating complex queries in SQL Server 2005/2008.
• Developed indexed views, complex stored procedures, effective triggers, and useful functions to facilitate efficient data manipulation and consistent data storage.
• Running DBCC consistency checks, and fixing data corruption in databases.
• Developed/Monitored ETL packages with different data sources (SQL Server, Flat Files, Excel files, etc.) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Developed Scheduled Jobs to automate the packages.
• Implemented Event Handlers and Error Handling in SSISpackages and notified process results to various user communities.
• Creating Parameterized Reports, Drill down, Sub-reports using SQL Server Reporting Services 2008.
• Created reports from various migrated data sources into simple dashboards for easy reviewing.
• Creating Ad hoc reports using Report Builder.
• Created interactive reports for sorting, different parameterized reports which consist of report criteria in various reports to make minimize the report execution time and to limit the no of records required.
• Used Shared Datasets and Shared Data sources in various reports which point to the same objects and pulled data from OLTP and OLAP Systems.
• Involved in designing sub reports and linked reports depending on the user requirement and in order to limit the number of Data Sources.
• Created parameters (multivalue, hidden, default etc...) for the required fields using the report designer in order to see the dropdowns in the end report.
• Used various types of report layout options like charts (bars, lines, pie etc...), images, graphs, sub reports, hyperlinks etc to make them more attractive and understandable.
• Increased performance necessary for statistical reporting by 25% after performance monitoring, tuning, and optimizing indexes.
• Configuration and Deployment of all the Reports (RDL) across various SDLC environments.
• Deployed the solutions on Web Server, Implemented security to restrict the access to users and to allow them to use only certain reports.
• Used Team Foundation Server to store, run, view, edit and revert back to different versions of the design in case of a system crash.
• Provided documentation about reporting and Updated functional specification and technical design documents.
• Created SSIS Packages to perform the daily and weekly processing of SSAS Cubes using Execute Analysis Services Task.
• Deployed the Packages to File System and SQL Server and scheduled them using SQL Agent to run automatically.

Environment: MSSQLServer 2008 R2/2008/2005, Visual Studio 2005/2008. Reporting Services (SSRS 2000/2005/2008/2008 R2), IBM Netezza,Business Intelligence Development Studio (BIDS), MS Office 2007/2010, MS Access, Visual Source Safe,VB.net, SharePoint, Microsoft VSTF, MS Visio, VB.Net, Integration Services (SSIS 2005/2008), Sales Force, SAS.

Confidential, Chicago, il

Sr.SQL/ETL Developer (SSIS/SSRS/SSAS)

Responsibilities:

• Collected business requirements from users and translated them as technical specs and design docs for development.
• Identified various datasources, formulated data dictionaries, design and develop datamodels (physical/logical datamodels) based on the given specs and requirements .
• Transferred data from various data sources/business systems including MS Excel, MS Access, Flat Files etc. to SQL Server using SSIS/DTS using various features like data conversion etc. Created derived columns from the present columns for the given requirements.
• Created Stored Procedures, Triggers, Indexes, User defined Functions, Constraints etc on various database objects to obtain the required results.
• Created SSIS packages and scheduled them as jobs to run automatically to Process the cube, load data etc.
• Involved in dimensional modeling (Star &Snowflake) and creating the Data Source Views (DSV) and Cubes using the identified Fact and dimension tables.
• Involved in development &Deployment of SSAS Cubes and Monitor Full and Incremental loads and support any issues.
• 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, navigation reports (Hyperlink) etc.
• Created different Parameterized Reports (SSRS 2000/2005/2008) which consist of report Criteria in various reports to make minimize the report execution time and to limit the no of records required.
• Worked on all types of report types like tables, matrix, charts, sub reports etc.
• Created Linked reports, Ad-hoc reports and etc based on the requirement. Linked reports are created in the Report Server to reduce the repetition the reports.
• Written MDX Scripts in order to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.
• Scheduled reports to refresh and run on daily, weekly and monthly basis in the report manager and SharePoint.
• Implemented security to restrict the access to users and to allow them to use only certain reports.
• While developing reports from Cubes also used the KPI’s for decision making, also implemented Cube Partitions and also debugged data connections, data sources and Data Source Views.
• Helped users to test the reports created and optimized the performance of the end reports getting data from SQL server Databases and SQL server analysis services.
• Dynamically supported business users for given requirements and developed the reports accordingly.
• Developed various T-SQL stored procedures, triggers, views, and adding/changing tables for data extraction, data load and transformations.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing different kinds of transformations using SSIS/DTS packages.
• Developed the packages with monitoring features and logging so that audit information of the packages and their execution results are loaded in to the audit table.
• Developed Cubes using SQL Analysis Services (SSAS) and Dimensions using cube wizard and also individually and Generated Named calculations and named queries.
• Used ProClarity server to create interactive reports with ability to drill down into details.
• Experience in ProClarity's powerful visualization tools, including the Decomposition Tree, Perspective View and Performance Map, to drill down, cross drill, pivot, chart, and investigate data.
• Used various report items like tables, sub report and charts to develop the reports in SSRS.
• Deployed and generated reports on to the server using the Reporting Services Report Manager.
• Migrated Crystal reports to SSRS reports.

Environment: T-SQL, PL/SQL, MS SQL Server 2005/2000, SSIS, SSRS, SSAS, BIDS, MS Excel, ProClarity Server, Crystal Reports, Oracle 9i, VBScript.