SUMMARY

• 7+ years of experience in designing, implementation and administration SQL Server Relational Database / Warehouse in small, medium, and large organizations using SQL Server 2008R 2/2008/2005/ 2000/ 7.0.
• Thorough knowledge of XML in SQL Server 2005. Good hands on DTS/DTSX migration across SQL Server 2008R 2/2008/2005/2000.
• Hands on Experience on Data modeling using Erwin Data Modeler and MS Visio.
• Extensive experience and proficiency on the design, construction and implementation of Business Intelligence tools Star Schema, Data Warehouses, OLAP Cubes, Partitioning and Aggregation ETL Process (Data Extraction, Transformation layer) wif DTS/SSIS, and ad - hoc Reporting.
• Extensive experience in Basic and Advanced report creation wif thorough knowledge of reporting service architecture. Experience in creating various types of reports (table, chart, List, matrix report, web reporting by customizing URL Access etc.) using SQL server Reporting Services (SSRS).
• Experience in report generation using SQL Server Reporting Services (SSRS), Crystal Reports,Cognos Report Tool,Excel 2003 Pivot Table and Chart Wizard,Daptiv Tool
• Extensive experience of creating the On demand, Ad Hoc Reports, Summary Reports, Sub Reports, Master/Detail report, Drill-down, Drill-through Report, Linked Report dynamic grouping, Cross-Tab, Frequency reports etc) using SQl server reporting services 2008/2005(SSRS).
• Experience in configuring report Printing Options (HTML Printing, Printing from PDF Document, Client- Side printing).
• Excellent command on subscriptions, report snapshot and report cache.
• Experience in creating both forms of reporting like Ad Hoc reporting as well as Enterprise Reporting.
• Extensively worked on three stages of enterprise reporting like Authoring, Management and Delivery using SQL Server reporting services (SSRS).
• Extensive experience on scheduling and the deployment of the SSRS reports and uploading files to a report server catalog from the report manger.
• Experience in calling RDL file from SSIS Script task and exporting output into .xls,.csv from SSIS.
• Worked on Report Viewer control to call SSRS report from .Net code.
• Extensive experience working wif ETL tools including SQL Server Integration Services (SSIS), Data Transformation Services (DTS), and ETL package design, and RDBM systems like SQL Servers, Oracle, and DB2. Well versed wif SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.
• Thorough Knowledge of Various SSIS Objects such as Dataflow Components, Control Flow Elements, Connections Managers, Runtime Events, Log Providers etc.
• Proficient in implementing all transformations available on the SSIS toolbox. Excellent knowledge of using variable and expression in SSIS package.
• Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, Logging.
• Experience in data migration (using tools like DTS, BULK INSERT, BCP and Replication) between different homogeneous/heterogeneous systems and SQL Server.
• Extensive Experience in Creating, Populating and maintaining Data marts. Thorough knowledge of Structure, Attributes, Hierarchies, Star and Snow Flake Schemas of Data Marts using Sql server Analysis Services (SSAS).
• Experienced in Building Cubes, Dimensions, Measures and fact tables wif different Architectures and Data Sources for Business Intelligence.
• Experience in designing, creating, processing of cubes using SSAS.Expert in calculating measures and dimension members using multi dimensional expression (MDX), mathematical formulas.
• Good experience in Designing Aggregations and pre-calculating the same in SSAS 2005.Experience in writing MDX Queries used for querying Cubes.
• Thorough Knowledge of Multidimensional OLAP (MOLAP), Relational OLAP (ROLAP), and Hybrid OLAP (HOLAP).
• Extensive experience in Online Analytical Processing (OLAP) and Data mining functionality using a combination of client & server-side components in SSAS.
• Experience in monitoring SQL Server Performance in SQL Server 2005/2000 using SQL Profiler, Query Analyzer, Enterprise Manager, Index Tuning Wizard and Windows Performance Monitor. Experience in creating jobs, SQL Mail Agent, Alerts and schedule DTS Packages.
• Experience in creating tables, indexes, Views, index views, complex Stored Procedures, user defined functions, cursors, derived tables, common table expressions (CTEs) and Triggers to facilitate efficient data manipulation and data consistency using 2008R2/2008/2005 T-SQL.
• Excellent command of writing ad-hoc queries utilizing Dynamic SQL and SQLCMD command line utility.
• Thorough knowledge and extensive experience in using .NET Framework Common Language Runtime (CLR) assemblies to create SQL Server objects, such as stored procedures and triggers.
• Work wif developers, DBAs, and systems support personnel in elevating and automating successful code to production.
• Experience on ADO.NET to access data from SQL Server. Developed the data access layer in C# using ADO.NET disconnected architecture as well as connected architecture.
• Team player wif excellent communication and problem solving skills, presentation skills wif strong aptitude towards learning new technologies

TECHNICAL SKILLS

Languages: C, C++, C#, JAVA, T-SQL,PL/SQL,Java Script,VB Script,Xml,Visual basic, ASP.NET, VB.NET, ADO.NET, Web Services

DATABASE/RDBMS: SQL Server 2008/2005/2000/7.0/6.5 , Oracle 8.0/9ig,DB2,MS Access

Database Technologies/Tools: SQL Management Studio, SQL Business Intelligence Studio SQL Enterprise Manager, SQL Analyzer,SQL Profiler

ETL: SQL Server Integration Services, SQL Server DTS, Data Transformation Services (DTSX Package)

OLAP/Reporting: SQL Server Analysis Services, SQL Server Reporting Services

Data Modeling Tool: MS Visio, ERWIN,UML

Business Objects: Crystal Report 8.5/9,Universe,Data Integrator Designer

Operating Systems: Windows XP/Server 2003/2000/NT4/98/95, Linux

Utilities: BCP, SQLCMD, DTS Import/Export, FTP

PROFESSIONAL EXPERIENCE

Confidential, Princeton, NJ

Sr SQL Server Developer/BI Developer

Responsibilities:

• Involved in Data Integration by identifying the information needs wifin and across functional areas of an enterprise database upgrade and scripting/data Migration wif SQL server 2008R2 Integration services (SSIS).
• Constructed SQL server Analysis Services 2008R2(SSAS) Data Warehouse and designed Fact tables and Dimension tables dat were populated via SSIS package from production OLTP databases.
• Created Drill down, Tabular, Summary, Matrix, Sub Report, List, Chart, Gauge Tablix,,Drilldown Cascade repot, Canned Report, Multivalued and Cascade parametric and Dashboard Reports using SQL server 2008 R2 Reporting Services (SSRS).
• Successfully managed Extraction, Transformation and Loading (ETL) process by pulling large volume of data from various data sources using BCP in staging database from Access, excel.
• Design fact and dimension tables, populated fact and dimension tables, created multi-dimensional OLAP cubes, Hierarchies, Attributes maintain and optimize cubes in SQL server Analysis services (SSAS) 2008R2.
• Used (SSAS) Star Schema, Snowflake Schema, and Aggregation as per Project requirement. Defined Relationships between Dimensions and Measure Groups like Reference Relationship, Many-to-Many Relationship, and Dimension Granularity wifin a Measure Group.
• Created Role-playing Dimensions, Standard Dimensions, Linked dimensions, Time dimensions, and semi additive measures in (SSAS) as per client requirements.
• Wrote MDX expressions to create name sets and calculated members. Used SSIS Analysis Service Process task for automatic Cube Process. Used DSV to Create OLAP Cubes.
• Analyzing the Performance of a Cube by partitioning it and creating Perspective Cubes.
• Defined various facts and Dimensions in the data mart including Fact less Facts, Aggregate and Summary facts
• Used SSAS MDX queries to extract data from the cubes for the complex calculation. Used key performance indicator (KPI) for graphical analysis.
• Worked on Excel 2003 Pivot table and Chart Wizard functionality to display OLAP data.
• Created DTSX package to generate current Date based XML File for Account, Agreement, and Event Application. Used Xml task, Xml Source, Execute SQL task, Script task of SQL server 2008R2 Integration Services (SSIS) to achieve dis task. Used ON ERROR functionality of SSIS to handle failed task.
• 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. 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.
• Used Package Configuration (.dtsconfig) to change property for DTSX package at run time for different environment(Development,QA,UAT)
• Developed Reliable Packages by implementing Logging, Error Handling, Transactions and Checkpoints.
• Monitored and Optimized SSIS package performance to reach the expected timeframe for data loading.
• Used SSIS various types of Control Flow tools and Data Flow tools like Container, Aggregate, Derived column and Conditional Splitting according to need of Data scrubbing.
• Build efficient SSIS packages for processing fact and dimension tables wif complex transforms and type 1 and type 2 changes.
• Create, modify, test, and troubleshoot SQL Server Reporting Services (SSRS) reports
• Developed complex reports using multiple data providers, aggregate formula, charts, and synchronized queries.
• Analyze system, gathered requirements from system and generate Report Mockups for Reporting.
• Worked on scheduling and the deployment of the SSRS reports and uploading files to a report server catalog from the report manger.
• Rendered SSRS reports in different formats like PDF, EXCEL, CSV XML etc to be executed automatically on weekly or monthly basis and managed subscriptions.
• Scheduling the SSRS reports to run on daily/weekly/monthly basis both automated and Manual using (SSRS) and email the results to the users in the required format. Created standard report subscription and Data Driven report Subscriptions
• Used Report Viewer control to call and display SSRS Report. Worked on VB.Net function in SSRS.
• Tuned the SQL queries using the execution plans and avoiding unnecessary joins and other important aspects.
• Created several Dynamic and Complex Stored Procedure, trigger, Cursors, User defined functions, Inline Functions (UDF), View, Metalized View using SQL 2008R2 T-SQL programming to implement the business logic and performance. Used Open XML, For XML, and XML Paths in some of the Stored Procedures.
• Used MERGE feature to perform insert, update and delete operations.
• Worked on development/staging/production environments and TFS for version controls.
• Provided 24 x 7 dedicated supports to Production, QA & Development MS SQL Server Environments

Environment: SQL 2008R2 Integration Services,, SQL server 2008R2 Business Intelligence suite, SQL server 2008 R2 Analysis Services,SQL Server 2008 Reporting Services,SQL Server 2008 R2 Management Studio, MS Visio, SQL Profiler Tool, Team Foundation System.

Confidential, Secaucus, NJ

SR SQL Server Developer

Responsibilities:

• Involved in Data Integration by identifying the information needs wifin and across functional areas of an enterprise database upgrade and scripting/data Migration wif SQL server 2005 Integration services (SSIS).
• Built complex Daptive reports using Daptive Tool to support R & D and Project & Resouce functions.
• Created and schedule SSIS packages to load the data form GNE to PW data staging environment and tan to PW live environment.
• Designed logical and physical data models for GNE and PW system using MS Visio.
• Successfully managed Extraction, Transformation and Loading (ETL) process by pulling large volume of data from various data sources using BCP in staging database from Access, excel.
• Design and develop ETL processes to load data from multiple source system (XML, SQL Server, and flat files) into the DW (SQL Server).
• Created DTSX package to generate current Date based XML File for Account, Agreement, and Event Application. Used Xml task, Xml Source, Execute Sql task, Script task of Sql server 2005 Integration Services (SSIS) to achieve dis task. Used ON ERROR functionality of SSIS to handle failed task.
• Filtered bad data from legacy system using Derived column, Lookups, Fuzzy Lookups, Conditional split.
• ETL implementation using SQL Server Integration Services (SSIS), Applying some business logic and data cleaning in staging server to maintain child and parent relationship.
• Wrote SSIS packages and configured SQL server mail agent for sending automatic mails when DTS process is success or fails.
• Extracted, cleaned and validated data from XML file into database using XML source. Managed the Metadata associated wif the ETL processes used to populate the Data Warehouse using SSIS packages.
• Used Execute process task of (SSIS) to send and received files from FTP server.Used Dataflow task to transfer data from XML to XSL file.Used File System Task to Copy, Move, Rename Blueprint Project Files and Directory. Used Email Notification Task to send Status of Package execution. Used XmlStudio 2009 to validate XSD Schema wif XML file.
• Used Package Configuration (.dtsconfig) to change property for dtsx package at run time for different environment (Development, QA, UAT).
• Used various transformation like Lookup, Merge join,Union All,Fuzzy Lookup, Derived Columns, Condition Split,MultiTask, Aggregate along wif Control flow task like 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.
• Created reports using SSRS designer from OLTP and OLAP data sources and deployed on report server
• Created Drill down, Multi parameterized & Multivalue, tabular, Sub Report, List, Chart, drilldown cascade repot and dashboards reports according to business requirement using SQL server reporting services (SSRS).
• Developed complex SSRS reports using multiple data providers, aggregate formula, charts, and synchronized queries.Analyze system, gathered requirements from system and generate Report Mockups for Reporting.
• Worked on scheduling and the deployment of the SSRS reports and uploading files to a report server catalog from the report manger
• Scheduling the SSRS reports to run on daily/weekly/monthly basis both automated and Manual using (SSRS) and email the results to the users in the required format.
• Created Sub reports for Event and Activity for Lilli and Genetic Project; Created matrix, table report as per client requirements; used filter data wif parameters; and conditional formatting using SSRS.
• Created standard report subscription and Data Driven report Subscriptions. Created SSRS Reports for Full year financial Billing details and Revenue Details.
• Worked on configuration of report server and report manager scheduling, give permissions to different level of users in SQL Server Reporting Services (SSRS).
• Add custom DLLs and vb.net code for Localization in SSRS Reports.Used Dynamic Script in SSRS to show Columns as per run time selection .
• Design fact and dimension tables, populated fact and dimension tables, created multi-dimensional OLAP cubes, Hierarchies, Attributes maintain and optimize cubes in SQL server 2005 Analysis services (SSAS). Used MDX queries to extract data from the cubes for the complex calculation.
• Used (SSAS) Star Schema, Snowflake Schema, Aggregation, Partition, and KPI as per Project requirement.
• Created several Dynamic and Complex Stored Procedure, trigger, Cursors, User defined functions, Inline Functions (UDF), View,Materlized View using Sql 2008/2005 T-SQL programming to implement the business logic and performance. Used Open XML, For XML, and XML Paths in some of the Stored Procedures.
• Optimized the performance of various SQL scripts, stored procedures and triggers by using embedded UDFs, CTEs.Worked on SQL Profiler, Tuning Adviser (DTA), Performance Monitor wif various objects & counters, DBCC commands to record and enhance the performance.
• Worked on development/staging/production environments and visual source safe for version controls.
• Provided 24 x 7 dedicated supports to Production, QA & Development MS SQL Server Environments to resolve any issues
• Supports testing, debugging, and refining the Business Intelligence solutions to produce the required product Work wif developers, DBAs, and systems support personnel in elevating and automating successful code to production. Provide on-call support to production system.

Environment: SQL Server 2005 Enterprise Edition, Sql 2005 Integration Services,, SQL server 2005 business intelligence suite, SQL Server 2008/2005 Reporting Services, SQL Server 2005 Analysis Services, SQL Server 2008/2005 Management Studio, MS Visio,.Net Script,C#,SQL Profiler Tool

Confidential, Montvale, NJ

SR SQL Server Developer

Responsibilities:

• Created SSIS packages to download the files from secure https websites which are in XML format and finally stores them in database.
• Converted the data mart from Logical design to Physical design, Designed and Customized data models for Data Mart supporting data from multiple sources on real time.
• Successfully managed Extraction, Transformation and Loading (ETL) process by pulling large volume of data from various data sources MS Access, excel. Used SSIS Activex script task to call Web Services to evaluate Custom Rules. Used SSIS Notification task to send message through e-mails.
• Created SSIS Packages for testing and cleaning the Standardized Data by using tools in Data Flow Transformations for huge CSV. files.
• Created SSIS package by using advanced tools (Derived Columns, Condition Split, Aggregation, and Multicasting).
• Build efficient SSIS packages for processing fact and dimension tables wif complex transforms and type 1 and type 2 changes.
• Responsible to performance-tune ETL procedures and STAR schemas to optimize load and query Performance.
• Designed SSAS Fact and Dimension Tables, Populated Fact and Dimension Tables, Created Multi-Dimensional OLAP Cubes wif KPIs, Actions
• Created Role-playing Dimensions, Standard Dimensions, Linked dimensions, Time dimensions, Additive & semi additive measures in (SSAS) as per client requirements.
• Used MOLAP storage for fastest query performance. Used multiple partitions to break up measure group into separate physical components to improve Query performance.
• Used MDX queries to extract data from the cubes for the complex calculation. Create MDX script for representing Cube Calculation.
• Responsible for creating the complex client reports and custom reports (On demand, AdHoc Reports, Frequency reports, Summary Reports, Sub Reports, Drill-down, dynamic grouping, Cross-Tab, graphical, aging reports etc) using Sql server 2005 Reporting services (SSRS).
• Created Adhoc Report Model using Report Builder, AdminReport, AuditTrailReport, MySearch Report, Matrix Report using Sql server Reporting Services 2005(SSRS)
• Generated TEMPeffective SSRS reports using formulae, sections, breaks, alerter, and filters.
• Create, troubleshoot, and modify stored procedures used as SSRS data sets
• Rendered SSRS reports in different formats like PDF, EXCEL, CSV XML etc to be executed automatically on weekly or monthly basis and managed subscriptions.
• Worked on scheduling and the deployment of the SSRS reports and uploading files to a SSRS report server catalog from the report manger
• Used Xml Data source to generated Configurable Component report using Sql server 2005 Reporting Services. Used XMLDiff Task of SSIS to Compare Different Version and generate Version Comparison Report using SSRS.
• Generate Adhoc Report Model at VMF level and assign securities for Global administrators of each country.
• Created standard and data driven Subscription, used report manager for securities.
• Created many complex Stored Procedures / Functions and used them in Matrix Reports.
• Create dynamic Audit Report stored procedures to display old and new values through SSRS.
• Created SSIS Jobs and scheduled Packages using SQL Server Management Studio for the Daily/Weekly/Monthly Load as per different Time Zone. Maintain Process Log and Created Process Report using SQl server 2005 Reporting Services(SSRS)
• Worked on XML query language using XPath, XQuery as well as XSLT. Used ROW, AUTO, and EXPLISIT for defining element hierarchy in XML.Used OpenXml and ForXml for retriving data from .Net Application.
• Transformed complex business logic into Database design and maintaining it by using SQL objects like Stored Procedures, User Defined Functions, Views, T-SQL Scripting.
• Designed SQL Database objects in .NET wif SQL CLR programming. Created various Stored Procedures, Functions, Triggers, and User Define Data Types using C#.
• Developer Logical and Physcical Datamodel for CEAC and NGGC Database using Visio.
• Designed SQL Database objects in .NET wif SQL CLR programming. Created various Stored Procedures, Functions, Triggers, and User Define Data Types using C#.
• Tuning SQL queries improving the performance of the Database. Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Enhance performance in Complex stored procedures by avoiding cursors and putting Temp tables wif cluster indexes and improve performance by 40%.
• Provided 24 x 7 dedicated supports to Production, QA & Development MS SQL Server Environments.
• Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.Developed partitioned views and tables for the purpose of security and fast upload.

Environment: SQL Server 2005 Enterprise Edition, Sql server 2005 Integration services, SQL server 2005 business intelligence suite, SQL Server 2005 Reporting Services, SQL Server 2005 Analysis Services, Sql server Management Studio, MS VISIO,SQL Profiler Tool

Confidential, Columbus, GA

Sr SQL Server Developer

Responsibilities:

• TEMPEffectively design, develop, and implement Business Intelligence solutions using Microsoft Integration Services 2005(SSIS), Analysis Services 2005(SSAS) and Reporting Services 2005(SSRS).
• Developed and created logical and physical database architecture using ERWIN.
• Data transfer using SSIS & DTS packages, used Open Query, Bulk Insert, BCP to copy data between various data sources Used DTS jobs for importing data from legacy systems to the current model. Used ActiveX scripting for transferred data modifications.
• Used SSIS various types of Control Flow tools and Data Flow tools like Container, Aggregate, Derived column and Conditional Splitting according to need of Data scrubbing.
• Created complex ETL Strategies to populate the Data warehouse/Data-mart facts and dimensions.
• Used multiple transformations including Fuzzy lookups and Fuzzy grouping in the data cleansing process.
• Responsible for the creation and maintenance of Analysis Service objects such as Cube, Dimensions, Fact,Measures,MDX queries, and KPI’s
• Creating SSAS OLAP CUBES and having partition on cubes on monthly bases, Pulled over those data in Excel pivot functionality sheet as per client requirement.
• Created reports by extracting data from OLAP Cube. Created report model on SSAS cubes Generated reports using SQl server Reporting Services 2005 from OLAP and OLTP data source.
• Created User Conditions and Filters to improve report generation and readability of report and displayed the summary of data by creating Charts.
• Designed and deployed SSRS reports wif Drill Down, Drill Through, Ad-hoc and Parameterized and Linked reports using ROLAP source. Involved in the scheduling and the deployment of the reports and assisted in uploading files to a report server catalog from the report manger.
• Created user defines functions in SSRS using VB Script. Created on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services 2005
• Work on future initiatives to add data mining/data analysis capabilities to OLAP/Reporting functions.
• Created Indexes, Stored Procedures, Views and Triggers as per the requirements and needs during the project.
• Worked on SQL Profiler, Tuning Adviser (DTA), Systems Performance Monitoring wif various objects & Counters, DBCC commands to record and enhance the performance

Environment: SQL Server 2005 Enterprise Edition, SQL server 2005 business intelligence suite,, Sql server Management Studio, ERWIN, Business Object XI,Cognos PowerPlay Transformer, Cognos Report Tool, ERWIN, Asp.Net, C#, Query Analyzer, Windows Application Log and SQL Server Event Viewer

Confidential, Parsippany, NJ

SQL Server Developer

Responsibilities:

• Build ETL processes using MS DTSX package. Used Sql 2005 DTS jobs for importing data from legacy systems to the current model. Used ActiveX scripting for transferred data modifications.
• Created (SSIS) DTSX packages to import and export data from Excel, Text File, CVS Files.
• Developed and created logical and physical database architecture using ERWIN.
• Responsible for creating the Tabular Report, Summary Reports, Sub Reports, and Drill-down, dynamic grouping, Cross-Tab etc) using SQl server reporting services 2005(SSRS).
• Created User Conditions and Filters to improve report generation and readability of report and displayed the summary of data by creating Charts.
• Involved migrating reports developed in Crystal Reports to SSRS.
• Created tabular, matrix, chart, drilldown reports, and parametric, cascaded reports and dashboards reports according to business requirement.
• Review the current Data Mart and OLAP cubes and propose corrections and enhancements
• Constructed Sql server Analysis Services 2005(SSAS) Data Warehouse and designed Fact tables and Dimension tables dat were populated via DTS from production OLTP databases.
• Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Created views and stored procedures for Reports using complex SQL, T-SQL and Dynamic T-SQL. Implemented ER Integrity using Foreign Keys and Cascade Triggers.
• Responsible for Converting old Crystal reports into SQL server 2005 reporting services.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers
• Participated in User Acceptance Testing (UAT) for different modules. Helped creating Test Cases and Test Plans

Environment: SQL Server 2005 Enterprise Edition, Sql server 2005 business intelligence suite, SQL server 2005 Management Studio, ERWIN,Business Object, Crystal Reports 9.0, VB.NET, Windows 2000 platform

Confidential

Software Engineer

Responsibilities:

• Analysis and design the application architecture.
• Architecture and designing of the entire project as per client’s specification
• Involved in design and development of application interface
• Involved in code review of the application
• Wrote code for Knowledge mark Program and utilize ADO database for connection and retrieval and update database information
• Created Storedprocedure,Triggers,Function,Views using SQl Server 2000/7.0
• Extensively used Joins and Sub-Queries for complex queries involving multiple tables for reporting purposes
• Designed and Developed reports using Data reports/Crystal Reports
• Hands on experience in ActiveX, COM and DCOM Technologies
• Created COM/DCOM components using VB6 (ActiveX DLL) and are Exported, Packaged and Deployed.
• Database Programming using ADO, DAO and ODBC
• Developed reports using dynamic selection criteria, parameter passing to formulas
• Extracted, transformed, cleansed, and loaded (ETL) data from their legacy Access system to SQL Server.
• Developed stored procedures, functions and triggers in T-SQL to implement data extract, transformation, and load (ETL) processes for all raw data and to manipulate raw data into views and materialized views for reporting purposes
• Used DTS Packages for data import and data export from SQL Server to Access, text and Excel files. Developed ETL for SQL Server 2000 using DTS packages
• Developing T-SQL / DTS scripts as required to load or manipulate data wifin database environments
• Performed Unit testing wif test data and live data and monitor the functional testing and Integration testing before deploying
• Implementing project as per requirements specified by client

Environment: Visual Basic 6.0, COM/DCOM,MS Access 97, Win NT and Data Reports, Crystal Reports,SQL server 200/7.0.