Tallapally
****.******@*****.***
Visa Status: Permanent Resident (Green Card)
SUMMARY:
8+ years of MS SQL Server Development experience with expertise in MS SQL Server 2016, 2014, 2012/2008R2/2008/2005/2000 and Microsoft’s suite of products like SSIS and SSRS.
Highly experienced in Creating, Configuring and Fine-tuning ETL workflows designed between Homogenous and Heterogeneous Systems using SSIS of MS SQL Server 2014, 2012, 2008R2, MS SQL Server 2017, 2016 and 2014 respectively.
Experienced in creating complex SSIS and DTS packages for ETL purposes. Implemented complicated transformations to be used in SSIS packages.
Expertise in Data Conversion, Normalization and Data Modeling, Multi-Dimensional Modeling and involved in creation of Fact Tables, Dimension Tables, Star Schema and Snowflake dimensional schema using Erwin Tool.
Proficient in creating On-demand and Scheduled reports, handling sub reports and defining query for generating drill down reports using MS SQL Server Reporting Services 2014, 2012, 2008R2/2008/2005 (SSRS).
Experienced with client server application where XML feeds were consumed and Store Procedures were called using ADO.NET
Experienced in writing Parameterized Queries for generating Tabular reports and Sub reports using Global variables, Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS 2008R2/2008/2005.
Strong experience in Stored Procedure, Formulated Stored Procedure/TSQL /MySQL coding, Performance Tuning and Query Optimization.
Highly proficient in the use of T-SQL for developing complex Stored Procedures, Triggers, Tables, User Defined Functions, views, indexes, user profiles, Relational Database models, Data integrity, query writing and SQL joins.
Extensive knowledge in developing and implementing Disaster Recovery Model, and Replication Models.
Expert in using tools like MS SQL Profiler, Index Tuning Wizard, Windows Performance for monitoring and tuning SQL Server performance.
Excellent communication and inter-personal skills with ability to develop creative solutions for challenging client needs using agile methodologies.
Ability to handle multiple tasks and responsibilities independently as well as a proactive team member.
Education: Bachelor’s Degree from Osmania University, India.
TECHNICAL SKILLS:
MS SQL Server Tech:
MS Access, Transact-SQL (T-SQL), MySQL, PL/SQL, XML, MS SQL Server Integration
Service (SSIS), MS SQL Server Reporting Service (SSRS),
SQL Profiler, SQL Query Analyzer, Visual Studio 2008/2005/2012, 2014, DTS SQL Developer, ERWIN, Windows Server- 2010, 2008/2003/NT/XP/2000, Windows vista.
Operating System:
Windows XP/Vista/2000/Server 2003/2008/ Unix
Database:
Microsoft SQL Server 2000/2005/2008 R2/2012/2014/2016, Oracle 11g/10g/9i/8i, MS Access
Microsoft Tech:
C#.NET, VB.NET, Visual Basic
Internet:
ASP.NET 3.0/2.0/1.1, XSLT, XML, HTML, DHTML, CAML
Reporting Tools:
Crystal Reports 9/10, SSRS, SSIS, SSAS
ETL Tools:
DTS, MS SSIS (SQL Server Integration Services)
MS Servers:
IIS 5.0/6.0/7.0
Tools and IDEs:
Microsoft InfoPath 2003/2007, Visual studio 2003/2005/ 2008/2012/2014, CSS, AJAX, UML, Windows PowerShell.
Frameworks:
.NET Framework 3.5, 2.0 and 1.1
Version Control tools:
VSS 6.0, VS, Team Foundation Server
Scripting Languages:
JavaScript, VBScript, CSS
ROFESSIONAL EXPERIENCE:
Client: Mattress Firm, Houston TX Sep 2017 – Till now
SQL BI Developer (SSIS/SSRS)
Employer: Mattress Firm,
This company is a retail market organization which manages all inventory flow including daily purchase, order inwards, issue, returns and vendors info and customer’s information of organization, allows creating new customers of their products, associate commissions, update employee rate. This System also generates bills, reports like Daily stock, back order list, which helps in decision-making.
Responsibilities:
●Gathered report requirements and determined the best solution to provide the results in either a Reporting Services report, Analytical Cube or an Excel pivot table
●Designed SSIS packages to Extract data from different sources like SQL server 2012/2008R2,MS Excel, MS Access, transform and then load into Dimension and Fact tables in Data Warehouse using SSIS .
●Migrated data from Development to UAT servers and deployed packages to different servers.
●Developed the logic for associates pay commission based on the sales by each associate
●Generated excel templates for the end users from xml file through SSIS to load the data dynamically
●Designed and developed SSIS ETL/SSIS packages to validate, extract, transform and load data from OLTP system to the Data warehouse and Report-Data mart.
●Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Cache Transform, Conditional Split and Derived column etc.
●Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, 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.
●Developed SSIS packages using for each loop in Control Flow to process all excel files within folder, File System Task to move file into Archive after processing and Execute SQL task to insert transaction log data into the SQL table
●Produced operational reports in SSRS 2014, 2012/2008R2 i.e. drill-down, drill-through, Parameterized, cascading, dashboard and matrix reports.
●Generated monthly and quarterly reports as bar charts for the management using different techniques like data filtering, adding interactivity, deploying reports to report server using SSRS
●Converted manual reports pasted together into parameter driven stored procedures to be used with Microsoft Reporting Services 2016, 2014, 2012/2008R2
●Attained legacy data to use as a source to develop new reports previously compiled and maintained manually
●Translated XML Input file data to another XML from consumed by UI.
●Developed functional and technical documentation to assist in the design, development and/or maintenance of deliverables
●Responsible for managing BI environment, which includes Business model, Data Model, Data sources, ETL/SSIS tools, target data warehouse, Data marts, and Reporting tools.
●Created SSRS Data Model projects using Microsoft Visual Studio 2016, 2014, 2012, 2010, 2008R2 /2008 and using Report Builder for report server to create reports
●Configured the report server and generated the report models for user interactions
●Responded to ad hoc requests and special projects that require immediate attention while at the same time maintaining deadlines on existing requests.
●Created Star schema dimensional modeling for the data mart using Visio and created dimension and fact tables based on the business requirement.
●Developed and maintained system documentation, diagrams and flowcharts.
●Worked with project manager and technical leads for resolution of technical issues.
Tools & Technologies:
SQL Server2016, 2014, 2012/2008R2, SSAS, Server Integration Services, SQL server Reporting Service, Microsoft Visual Studio, SQL Server Management Studio, IIS, MS Excel, T-SQL, ERWIN 7.2, C#
Client: Lumeris, Essence Healthcare, ST. Louis, MO April 2017 – Sep 2017
SQL BI Developer (SSIS/SSRS)
Employer: Reliable Software Inc.,
Project: The Lumbers Essence Healthcare is a health care services company based in ST. Louis, MO. The company specializes in patient’s insurance Medicare, Medicaid plans with claims, provider data, member data, clinical data and distribution of pharmaceuticals and medical products. Ensure compliance with federal and state deliverable reporting requirements by performing data quality audits and analysis.
Responsibilities:
Prepared the complete data mapping for all the migrated jobs using SSIS
Responsible for creating and designing SSIS package
Designed Extraction Transformation and Loading (ETL) process using SSIS to extracted data from flat files, excel files and SQL server database
Worked on Medicare, Medicaid on patience claims data, provider data, member data, clinical data
Based on business requirement, developed the Complex SQL queries with Joins and T-SQL, Stored procedure, Views, Trigger to implementing the business rules and transformations
Use different control flow control like for each loop container, sequence container, execute SQL task, send email task
Use package configuration to migrate SSIS package from one environment to other
Use event handing to send e-mail on error events at the time of transformation
Use login feature for analysis purpose
Added intelligent system in SSIS to identify actual change and new change in dimension
Involved in gathering business requirements and development of data modeling to facilitate business and operational needs.
Database and Log Backup, Restoration, Backup Strategies, Scheduling Backups.
Improved the performance of the SQL server queries using query plan, covering index, indexed views and by rebuilding and reorganizing the indexes.
Perform tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
Troubleshooting performance issues and fine-tuning queries and stored procedures.
Defined Indexes, Views, Constraints and Triggers to implement business rules.
Involved in writing Complex T-SQL Queries.
Backing up master & system databases and restoring them.
Developed Stored Procedures and Functions to implement necessary business logic for interface and reports.
Involved in testing and debugging stored procedures.
Designed, built and tested SSAS Cubes on SQL Server.
Created Excel workbooks to enable Cube (SSAS) access for business users.
Process the cubes (SSAS), partitions as and when required.
Writing the DAX statements for Cube
Created Tabular and Matrix Reports with all aggregate functions and expressions
Produced dashboard SSRS reports under report server projects and publishing SSRS reports to the reports server.
Developed functional and technical documentation to assist in the design, development and/or maintenance of deliverables
Environment: MS SQL Server 2008/2012, SSIS, SSAS, ORACLE RAC, TFS, Windows 2003/2008, Deployment Wizard, Visual Studio 2010, MS Excel 2007, Tableau, C#, ASP .Net
Client: United Airlines, Houston, TX October 2015 – March 2017
SQL BI Developer (SSIS/SSRS)
Employer: Reliable Software Inc.,
Project: At United airlines worked in supporting team in the development of packages. Full software application and business intelligence development lifecycle knowledge including initiate design build user acceptance and implementation phases. Preeminent corporate authority in enterprise to support shared assets and resources for multiple business entities. Holds a complete understanding of data warehousing, business intelligence and planning and consolidation with multiple BI tools and database platforms. Experienced in all aspects of project management and in all phases of the systems development life cycle and related methodologies.
Responsibilities:
Translated user requirements into functional and technical requirements in coordination with the Sr. Business Analyst
Executed Store Procedures using ADO.NET framework.
Analyzed the business requirement and functional specifications provided by the data specialist
Worked on SSIS for transferring data from Heterogeneous Data format to SQL Server.
Developed SSIS packages using Change Data Capture (CDC) functionality using complex stored procedures, Execute SQL Task and Data FLOW Task in Control Flow and OLE DB Source, Script Component Transformation and OLE DB Destination in Data Flow.
Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Conditional Split, 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.
Migrated few Oracle sources to SQL server development environment.
Developed SSIS Packages using Lookup Values & implementing rules provided by Business in the mapping document.
Extensively created new reports and modified existing reports using SRSS
Excellent report creation skills using Microsoft Reporting Services (SSRS). Extensively used SQL Reporting Services and Report Builder Model to generate custom reports: Designed and created Report templates, bar graphs and pie charts based on the financial data; Wrote queries to generate reports for analysis of data; Used table control, matrix control to create cross tab reports; handled sub reports and defined query for generating drill down reports in SSRS.
Writing reports using Microsoft Reporting Services (SSRS)
Created jobs, alerts to run SSIS packages periodically. Created the automated processes for the activities such as database backup and SSIS Packages to run sequentially using SQL Server Agent job.
Designed, built and tested SSAS Cubes on SQL Server 2005.
Created Excel workbooks to enable Cube (SSAS) access for business users.
Process the cubes (SSAS), partitions as and when required.
Enhanced performance using optimization techniques: normalization, indexing and Transaction Isolation levels, monitoring logs to ensure the completeness of batch processes, scripts and processes.
Worked with development teams in the design of physical databases and in modification.
Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
Created packages in SSIS with error handling.
Developed Query for generating drill down reports in SSRS 2008.Prepared AD HOC reports through report builders.
Worked with different methods of logging in SSIS and advanced data mapping.
Experience in creating complex SSIS packages using proper control and data flow elements.
Have deployed packages on different servers by configuring it.
Installed and configured SQL Server 2008/2005 in Test environment with latest service packs and migrated few databases.
Used System tables, System Stored Procedure, DBCC commands for Database maintenance.
Implemented computational sensitive queries Stored Procedures.
Migrated DTS packages from SQL Server 2000 to SQL Server 2005 as SSIS Packages.
Designing Visualizations in Tableau 9.2
Client: Frontier Communications, Dallas, TX Aug 2014 – October 2015.
SQL BI Developer (SSIS/SSRS)
Employer: Reliable Software Inc.,
Project: At Frontier Communications, I am part of 3rd tier support group and involved in the development of packages in SSIS. The main objective of the project was to receive package scans from MQ server and collect data from various database sources to perform analysis and then integrate them with the existing systems with SSIS and create reports using SSRS.
Responsibilities:
Worked with business stakeholders, application developers, production teams and across functional units to identify business needs and discuss solution options.
Agile methodology was used throughout the project, performed pivotal role in planning and developing as well as aligning with the assigned sprints.
Developed and deployed SSIS packages for ETL from OLTP and various sources to staging and staging to Data warehouse using For Each Loop Container, Execute Package task, Execute SQL Task, Sent Mail task, Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Slowly Changing Dimension and more. Performed ETL mappings using MS SQL Server Integration Services.
Supported Production Environment with schedule the packages and make the package dynamic with SQL Server Package Configuration.
Designed high level ETL/SSIS architecture for overall data transfer from the OLTP to Data warehouse with SSIS and prepared ETL/SSIS mapping processes and maintained the mapping documents.
Integrated data from SQL Server Parallel Data Warehouse (PDW) with data from Hadoop
Created SSIS packages for Dynamic ETL/SSIS flow to validate, extract, transform and load data into database using Lookup, Fuzzy Lookup, Derived Column, Conditional Split, Slowly Changing Dimension (SCD) to perform Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse
Wrote complex SQL/MySQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
Created/Updated database objects like tables, views, stored procedures, function, packages.
Designed Change data capture to capture insert, update, and delete activity applied to SQL Server tables, and to make the details of the changes available in an easily
Rigorously tested and debugged the Stored Procedures and used Triggers to test the validity of the data after the insert, update or delete.
Deployed reports on Report Server and SharePoint Server also scheduled reports using SSRS to generate all daily, weekly, monthly and quarterly reports including status.
Developed and delivered dynamic reporting solutions using MS SQL Server 2008 Reporting Services (SSRS).
Migrated and recreated existing Dimensions and Cubes using Star schema on 2005 Server to achieve the efficiency of SQL Server Analysis (SSAS)
Involved in monitoring and tuning report performance by analyzing the execution plan of the report.
Generated Drill down, drill through, Matrix Reports, parameterized reports, cascading parameterized Reports using SSRS.
Designed and developed monthly, quarterly and yearly reports at branch and company level.
Involved in table and for index partitioning performance and Manageability.
Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
Designed and developed OLAP Cubes and Dimensions using SQL Server Analysis Services (SSAS).
Monitored the overall performance of the database to recommend and initiate actions to improve/optimize Performance.
Used SQL Server Profiler to trace the slow running queries and the server activity.
Environment: SQL Server 2012/2008R2, SSAS, Server Integration Services 2012, SQL server Reporting Service 2012, Microsoft Visual Studio, SQL Server Management Studio, IIS, MS Excel, T-SQL, ERWIN 7.2, C#
Aon Benfield: Bloomington, MN Mar 2013 – July 2014
SQL BI Developer (SSIS/SSRS)
Employer: Reliable Software Inc.,
Project: As a result of the merger between Aon and Benfield, Aon moved to standardize all their reinsurance business to use their customized reinsurance application worldwide. Aon Benfield wanted a re-usable, repeatable process to migrate data from a wide variety of source systems directly into this application. The main objective of the project was to load data into the main OLTP database from any legacy systems.
Responsibilities:
Involved in interacting with the users for new/change requirements, for designing, developing, and testing solutions to meet these requirements.
Created Star schema dimensional modeling for the data mart using Visio and created dimension and fact tables based on the business requirement.
Gathered report requirements and determined the best solution to provide the results in either a Reporting Services report or an Excel pivot table
Designed SSIS packages to Extract data from different sources like SQL server 2012/2008R2, MS Excel, MS Access, transform and then load into Dimension and Fact tables in Data Warehouse using SSIS.
Migrated data from Development to UAT servers and deployed packages to different servers.
Designed and developed SSIS ETL/SSIS packages to validate, extract, transform and load data from OLTP system to the Data warehouse and Report-Data mart.
Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Cache Transform, Conditional Split and Derived column etc.
Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Conditional Split, 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.
Wrote complex SQL/MySQL queries using joins, sub queries
Designed cubes with star schema using SQL Server Analysis Services (SSAS).
Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
Experience in SQL Server Analysis Services (SSAS) for data mining to identify rules and patterns in the data.
Developed SSIS packages using for each loop in Control Flow to process all excel files within folder, File System Task to move file into Archive after processing and Execute SQL task to insert transaction log data into the SQL table
Produced operational reports in SSRS 2012/2008R2 i.e. drills-down, drill-through, dash board and matrix reports.
Developed OLAP cubes using SSAS (SQL Server Analysis Services) and calculate the metrics that were revealed in the functional analysis
Generated monthly and quarterly reports as bar charts for the management using different techniques like data filtering, adding interactivity, deploying reports to report server using SSRS
Converted manual reports pasted together into parameter driven stored procedures to be used with Microsoft Reporting Services 2012/2008R2
Attained legacy data to use as a source to develop new reports previously compiled and maintained manually
Translated XML Input file data to another XML from consumed by UI.
Developed functional and technical documentation to assist in the design, development and/or maintenance of deliverables
Responsible for managing BI environment, which includes Business model, Data Model, Data sources, ETL/SSIS tools, target data warehouse, Data marts, and Reporting tools.
Created SSRS Data Model projects using Microsoft Visual Studio 2010/2008 and using Report Builder for report server to create reports
Configured the report server and generated the report models for user interactions
Responded to ad hoc requests and special projects that require immediate attention while at the same time maintaining deadlines on existing requests.
Developed and maintained system documentation, diagrams and flowcharts.
Worked with project manager and technical leads for resolution of technical issues.
Environment: MS SQL Server 2012/2008R2, SQL server Reporting Services 2012/2008R2, SQL Integration Services 2012/2008R2, SSAS, SSRS Microsoft Visual Studio 2010/2008, IIS, SQL Server Management Studio, Java Script, MS Excel, T-SQL.
Client: Caterpillar Financial, Nashville TN Oct 2011 – Feb 2013 SSIS/SSRS Developer
Employer: Reliable Software Inc.,
Project:
Caterpillar Financial Services Corporation is the financial arm of Caterpillar Inc., a technology leader and the world's largest manufacturer of construction and mining equipment, natural gas and diesel engines, and industrial gas turbines. The project Involved in planning & administration of the entire migration and system performance also worked on tuning the system to achieve optimization of system resources
Responsibilities:
Worked on the complete life cycle of the project from design to implementation
Translated user requirements into functional and technical requirements in coordination with the Sr. Business Analyst
Executed Store Procedures using ADO.NET framework.
Analyzed the business requirement and functional specifications provided by the data specialist
Worked on SSIS for transferring data from Heterogeneous Data format to SQL Server.
Developed SSIS packages using Change Data Capture (CDC) functionality using complex stored procedures, Execute SQL Task and Data FLOW Task in Control Flow and OLE DB Source, Script Component Transformation and OLE DB Destination in Data Flow.
Migrated few Oracle sources to SQL server development environment.
Developed SSIS Packages using Lookup Values & implementing rules provided by Business in the mapping document.
Developed SSIS packages using Fuzzy Lookup and Fuzzy Grouping for data cleansing purpose.
Used SSIS Variables for storing the values which are used in various components of Data Flow Task.
Developed Unit Test Plans for SSIS packages for checking the functionality of each component.
Modified the existing SSIS packages to meet the changes specified by the users.
Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis
Worked with Inbuilt Transformations in SSIS ETL/SSIS like Persistent Lookups to enhance performance for lookups and more utilization of I/O resources.
Documented the complete data warehouse environment, including all dimension and fact tables, the relationship between SSIS packages and the target tables, which packages were valid and in use, the relationship between the jobs and SSIS packages.
Designed and maintained a wide variety of daily, weekly, and monthly financial and analytical reports used by different departments within the company.
Accountable for making sure reports are scheduled and delivered in a timely manner.
Designed reports using proper text formatting, report headers and footers, and page size to allow for printable reports.
Created ad Hoc and parameterized various reports using SQL server 2008R2 reporting Services with data from SQL Server and MS Access as data sources
Created ad hoc SSRS reports in the test environment for data validation
Produced dynamic Reports from the cube using SSRS 2008R2, and stored procedures.
Troubleshoot the deployment of reports in the test and production environment using SSRS.
Cleaned the data and created fact and dimension tables, performed calculations required for the reports using SQL Server 2008R2 environment and accomplished data modeling.
Environment: MS SQL Server 2008R2, SQL server Reporting Services 2008R2, SQL Integration Services 2008R2, SQL Analysis Services 2008R2, Microsoft Visual Studio, SQL Server Management Studio, MS Excel, T-SQL, ERWIN.
Health Net, Woodland Hills - Los Angeles, CA Jan 2009 – Sep 2011
SQL BI Developer
Employer: Reliable Software Inc.,
Project:
Health Net, Inc. is among the USA’s largest publicly traded managed health care companies. The company's HMO, POS, insured PPO and government contracts subsidiaries provide health benefits to approximately 6.6 million individuals in all 50 states and the District of Columbia through group, individual, Medicare, Medicaid, child care, Tricare and Veterans Affairs programs. Health Net's behavioral health services subsidiary, MHN, provides behavioral health, substance abuse and employee assistance programs (EAPs) to approximately 7.3 million individuals in various states, including the company's own health plan members. The company's subsidiaries also offer managed health care products related to prescription drugs, and offer managed health care product coordination for multi-region employers and administrative services for medical groups and self-funded benefits programs.
Responsibilities:
Worked closely with business unit(s) to understand key business drivers and then identify the individual business metrics and key measures that support them
Designed and configured, including parameters, settings, metrics, data elements and objectives
Worked with management to develop strategies to support company needs
Resolved data conflicts and inappropriate use of data
Wrote complex SQL queries using joins, stored procedures, user defined functions to verify the data from the database to generate reports based on the business requirement.
Wrote SQL Stored Procedure for checking Insert and Update on particular tables and created Transactions and Error Handling in it.
Utilized SSRS reports from different source formats and satisfying clients by representing reports and presentations
Generated matrix reports, tabular, drill-down, drill-through, sub reports, chart reports, multi parameterized reports
Created ad Hoc and parameterized various reports using SQL server 2008 reporting Services
Implemented multiple grouping into several reports using visibility and toggle options
Administrated and scheduled mailing subscriptions on SSRS reporting server
Developed dependent, dynamic menu objects to allow end-users selection and data filtering capabilities
Structured conditional formatting logic to control components behavior and appearance
Produced parameter driven, matrix, sub-reports and integrated report hyperlink functionality to access external applications.
Customized SQL queries to create RDL Datasets and create SQL reports.
Created Tabular and Matrix Reports with all aggregate functions and expressions
Produced dashboard SSRS reports under report server projects and publishing SSRS reports to the reports server.
Developed functional and technical documentation to assist in the design, development and/or maintenance of deliverables
Created SSRS Data Model projects using Microsoft Visual Studio 2008 and using Report Builder for report server to facilitate Ad-hoc reporting by the business users
Environment: SQL Server 2008, SSRS, T-SQL, SSMS, BIDS, Visio, Excel 2003, SharePoint
Java Script, XML, PERL, SSRS, SQL Server 2005.