PROFESSIONAL SUMMARY:

• Over 10 years of IT experience as MS SQL Server Developer 2012/2008 R 2/2008/2005/2000 and an accomplished Business Analyst in various Industry verticals like Insurance, Airlines, Telecommunication, Pharmaceutical, Retail and Bank.
• Solid understanding of all phases of Software Development Life Cycle (SDLC) methodology (such as requirement, analysis, design, data modeling, business process modeling, implementation and deployment).
• Extensive experience in gathering, managing and documenting business and functional requirements, communicating effectively wif upper management, developers and QA engineers.
• Strong experience in Stored Procedure, User Defined Function, TSQL 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.
• Wrote and modified stored procedures/Triggers (DML/DDL) to implement complex business rule.
• Involved in developing stored procedures, triggers for the application.
• Used SQL Profiler, Execution Plan, Database Tuning Advisor, Performance Monitor and DBCC Commands.
• Expertise on SQL Server Setup, Installation, Version Upgrade & Architect Setup.
• Designed and Implement Database Backup, Restore & Disaster Recovery Strategy.
• Expertise in Creating, Configuring and Fine-tuning ETL workflows designed between Homogenous and Heterogeneous Systems using SSIS of MS SQL Server 2008 and MS SQL Server 2005 respectively.
• Extensive Knowledge in creating complex SSIS and DTS packages for ETL purposes. Implemented complicated transformations to be used in SSIS packages.
• Expert 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.
• Expertise in developing SSIS Packages and using data transformations and deploying them on various production servers.
• 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 2008/2005 (SSRS).
• Highly skilled 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 2008/2005.
• Expertise in Developing and Extending MS SQL Server Analysis Services 2008 (SSAS) Cubes, Data Mining Models, Deploying and Processing SSAS objects.
• Adept in defining d relationships and calculated members in SSAS and used MDX queries.
• Expert in using tools such as Bulk Copy (BCP) and Data Transformation Services (DTS).
• Extensive noledge 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 track record for meeting deadlines and submitting deliverables on time.
• Has exposure in educating internal customers on business systems and procedures and working wif other analysts and QA team to set priorities and schedules.
• Excellent facilitation skills in conducting walkthroughs, surveys, questionnaires, interviews, brainstorming and JAD sessions.
• Adept at creating and transforming business requirements into functional requirements and designing business models using UML diagrams - Context, Use Case, Sequence, Activity diagrams, Class diagrams, Object diagrams, Collaborations diagrams in MS Visio and Rational Rose.
• Maintained positive communications and working relationships at all business levels.

TECHNICAL SKILLS:

Skillset: MS SQL Server 2012/2008 R 2/2008/2005/2000/7.0, MS SQL Server 2008/2005 Analysis Services (SSAS), MS SQL Server Integration Service (SSIS), MS SQL Reporting Services (SSRS), Microsoft Access 2000/8.0, Business Object 3.1, Microsoft Excel, Outlook, MS SQL Profiler, SQL Query Analyzer, Database engine tuning advisor, Toad, Power Designer 16.0, 16.5, Vb.net, Erwin Data Modeler 7.2/4.2/4.1, Excel VBA, Crystal Reports 8.5, T-SQL, MS Visio 2005, Windows 2003/2000 Advanced Server/Professional, Windows NT 4.0 Server/Workstation.

PROFESSIONAL EXPERIENCE:

Confidential, Deerfield, IL

Sr. Business Intelligence Developer/ Sr.Business Analyst/ DBA

Responsibilities:

• Managed entire project lifecycle.Performed GAP analysis to differentiate between the “as is” and “to be” systems.
• Identified and defined actors, made use cases and grouped them into use case and activity diagrams.
• Created Entity Relationship (ER) Diagrams to the proposed database.
• Worked on logical and physical data base modeling wif UML and ERWIN tools.
• Create database objects such as tables,views, stored procedures, Triggers etc.
• Using T-SQL to provide structure to store data and maintain database efficiently.
• Involved in writing T-SQL programming such as using Joins, sub-queries, temp tables, table variables, CTE for implementing Stored Procedures and Functions for different tasks.
• Working on diagnosing and tuning the performance of stored procedures using Execution Plan, Profiler and Database Engine Tuning Advisor.
• Monitoring and improving Performance in production environment using execution plans and Index tuning. Tuning the queries which are running slow using Profiler by evaluating joins, indexes, updating Statistics and code modifications, dis also involved index creation, index removal and index modification.
• Reviewing each field wif the business prospective to understand the field’s function/use in the overall business process.
• Also involved in creating the Metric source mapping of the fields to the target databases.
• Held JAD sessions to facilitate resolving of conflicts and to on various issues, discuss the release notes for every build during the course of projects.
• Designed mock-up User Interfaces to communicate visual data flow to the end users.
• Interacted and effectively communicated wif project managers, customers and management team.
• Interacting wif team, other DBAs and technical manager to fully understand the requirements of the system, working wif the other IT associates to design, implement, test, and enhance stored procedures necessary to support report generation.
• Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support.
• Proficiently handled SQL Server Replication, Backup/Recovery, Disaster recovery and planning.
• Having hands on experience in DR processes including Log Shipping and Database Mirroring.
• Maintain referential integrity, domain integrity and column integrity by using the available options such as constraints etc.
• Identify columns for Primary Keys in all the tables at the design time and create them.
• Create functions to provide custom functionality as per the requirements.
• Be aware of potential blocking, deadlocking and write code to avoid those situations.
• Endure that the code is written keeping in mind any security issues.
• Develop reports in SQL Server Reporting Services and handled Crystal Reports eventually managing the Universe and Qwaas.
• Design, Develop and Deploy SSIS Packages.
• Expert in data transformation services and Bulk Loads wif SSIS and BULK INSERT ETL operations.
• Working on Database Monitoring/Schedule tools such as Active Batch, SQL Monitor Tool from Redgate and SQL diagnostic Manager from Idera for multiple production servers. Setting up/Hooking the monitoring servers to the monitoring tool.
• Using Redgate SQL Compare and Data Compare the synchronization of structures and data is performed.Worked wif Active for scheduling jobsAnd Idera SQL Check for monitoring servers
• Prepared the project management and technical documentation.

Tools: & Technologies: MS SQL Server 2012/2008 R2, T-SQL, SSIS, Business Object 4.1, Crystal Reports 11, UML,Rational Rose,Active Batch 9,Windows 2008,Winmerge 3, Microsoft ExcelRedgate SQL Compare 11, Redgate SQL Data Compare 11,Redgate SQL Source Control 4,Filezilla FTP Client, Idera SQL Checkv3.6

Confidential, NYC, NY

Sr. Business Intelligence Developer/ Sql Developer/DBA

Responsibilities:

• Working on diagnosing and tuning the performance of stored procedures using Execution Plan, Profiler and Database Engine Tuning Advisor.
• Monitoring and improving Performance in production environment using execution plans and Index tuning. Tuning the queries which are running slow using Profiler by evaluating joins, indexes, updating Statistics and code modifications, dis also involved index creation, index removal and index modification.
• Reviewing each field wif the business prospective to understand the field’s function/use in the overall business process.
• Also involved in creating the Metric source mapping of the fields to the target databases.
• Interacting wif team, DBAs and technical manager to fully understand the requirements of the system, working wif the other IT associates to design, implement, test, and enhance stored procedures necessary to support report generation.
• Creating database objects like table, stored procedures, functions etc. using T-SQL to provide structure to store data and maintain database efficiently.
• Involved in writing T-SQL programming such as using Joins, sub-queries, temp tables, table variables, CTE for implementing Stored Procedures and Functions for different tasks.
• Involved in installation and configuration of SQL server 2012.
• Responsible for configuration of Microsoft Server/Client Products and implementation.
• Managed multiple databases at the headquarters running on different servers.
• Developed and deployed data transfers packages using SSIS 2012/2008.
• Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system, Staging DB to Data warehouse
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS
• Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS
• Created SSRS reports to retrieve data using Stored Procedures that accept parameters.

Tools: & Technologies: MS SQL Server 2012/2008 R2, T-SQL, SSIS, SSRS, Business Object 3.1, Crystal Reports 11, ODBC, Windows 2008,Winmerge 3, Microsoft Excel

Confidential, Mount Laurel, NJ

Sr. Business Intelligence Developer/ Sql Developer/DBA

Responsibilities:

• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Reviewed the database its structure and the corresponding fields wif the business prospective to understand the field’s function/use in the overall capacity planning.
• Wrote complex SQL queries involving multiple tables from different databases using Joins, sub-queries, temp tables, CTE to get time specific data for the Capacity Planning
• Monitored databases wif about million rows, and growing
• Designing and developing SSIS (ETL) packages to validate, extract, and load data from test environment to production. Also designed packages to check the data usage on 5 minute polls. Creating such packages involved using sequence container, for each loop container, script tasks, execute SQL task and various data flow tasks.
• Responsible to monitor the existing SSIS packages to meet the changes specified on daily basis; eventually leading to report generation.
• Generated Drill down, Drill through, Adhoc, Matrix Reports, parameterized reports using SSRS for monitoring Daily traffic KPIs
• Involved in setting up SQL Server Agent Jobs for periodic Backups wif backup devices, database maintenance plans and recovery. Performed database backup wif compression.
• Responsible for database mirroring, performed the data export import using export/import wizard, SQL Command and SSIS packages as well
• Worked on Database Monitoring tools such as SQL Monitor Tool from Redgate and SQL diagnostic Manager from Idera for multiple production servers. Setting up/Hooking the monitoring servers to the monitoring tool ·
• Worked wif the network team and also on the servers in establishing the connections by setting up the inbound and outbound ports rules between the servers to grab the performance counter information onto the Monitoring tool.
• Checking both the database metrics and sql server metrics.
• Applied patches and service packs to keep the database at current patch level.
• Maintain all the SQL documents includes installation and data conversion Procedures documents.
• Created alerts to check the disk space, processor utilization, backup, blocked process, deadlock, fragmentation, long running query, jobs wif unusual duration, failed jobs.
• Configured Email Alerts for unsuccessful completion of Scheduled Jobs.

Tools: & Technologies: MS SQL Server 2012/2008 R2, T-SQL, SSIS, SSRS, Oracle 11g, Microsoft Excel, Redgate - SQL Monitor Tool, Idera-SQL Diagnostic Manager

Confidential, New York City, NY

Sr. Business Intelligence Developer/ Business Analyst

Responsibilities:

• Planned, defined and designed data based on business requirement and provided documentation.
• Interfaced wif business users to prepare and update Business Process Requirements for the new release of Healthcare tools.
• Ability to work wif functional teams in an Agile Environment.
• Prioritized outstanding defects and systems problems, ensuring accuracy and deadlines were met.
• Worked wif the management for improving and giving new ideas for designing future processes of the HIPPA transactions dealing out wif HIPAA 4010, 5010, claim adjustments, claim processing from point of entry to finalizing, claim review, identifying claims processing problems, their source and providing alternative solutions using best practice model and principals and also well versed wif ICD10, Facets.
• Designed mockup and wireframes to communicate visual data flow to the end users.
• Developed use cases, activity diagrams and sequence diagrams for a clear understanding of the vision document.
• Recommended corrective actions, if necessary, along wif the progress against Development/Action Plan routinely to the Project Manager.
• Administered and coordinated User Acceptance Testing and obtain final system acceptance sign-off wif the help of Program Manager.
• Conducted Risk Engineering to derive and execute action plans on time.
• Conducted Joint Application Development (JAD) sessions wif stakeholders throughout SDLC to resolve open issues.
• Actively participated in gathering Business Requirements and System Specification. Participated in implementing the logical design to the physical design by creating tables.
• Analyzed the existing data and performed the appropriate changes from SQL Server 2005 to SQL Server 2008 by following the Normalization standards to maintain data consistency and by performing data validation.
• Involved in the design of new schema, new tables, field definitions and mappings, stored procedures, views, indexes.
• Created SSIS Packages by using advance transformations (i.e. Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate) and also used Custom components such as Audit on Pre-Execute, Audit On Post-Execute, Custom Email Task and Statistics Logging Component.
• Created Dynamic SSIS packages using complex expressions, variables and control flow components such as For Each Loop, For Loop to loop over a Directory to load inbound files coming daily.
• Prepared the Migration document showing the paths for input and output files, configuration files, table scripts, stored procedures and SSIS packages.
• Tested, Cleaned and Standardized Data to meet the business standards using Fuzzy and Exact lookups and String manipulations.
• Enforced the Business Rules to filter bad data from the system by using Complex T-SQL Statements, and implemented various Constraints and Triggers for Data Consistency.
• Responsible for creating the reports based on the requirements using SSRS 2008.
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel formats using Reporting Services (SSRS).
• Created different type of reports which include: Cross-tab, Conditional, Sub report, Drill-down and Parameterized and deployed and scheduled Reports in Report Manager using SSRS to generate all daily, weekly, monthly and quarterly Reports.
• Monitoring performance and optimizing SQL queries for maximum efficiency
• Developed reports using complex formulas and to query the database to generate different types of ad-hoc reports using SSRS
• Deployed and upload the SSRS reports to SharePoint Server for the end users and Involved in Enhancements and modifications
• Administrated the created Reports by assigning permission to the valid user for executing the reports.
• Develop reports using complex formulas and to query the database to generate different types of ad-hoc reports using SSRS
• Developed SSIS packages using Fuzzy Look Up 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.

Tools: & Technologies: MS SQL Server 2012/2008 R2, T-SQL, SSIS, SSRS, Business Object 3.1, Oracle 11g, ODBC, Microsoft Excel, Requirement Traceability Matrix (RTM), User Acceptance Testing (UAT),.

Confidential

Sql developer/BI Developer/Data Modeler

Responsibilities:

• DesignedSSIS packages to Extract data from different sources like SQL server 2008, MS Excel, MS Access, DB2 and transform and tan load intoDimension and Fact tables in Data Warehouse using SSIS.
• Developed SSIS packages using for each loop inControl Flow to process all excel files wifin folder, File System Task to move file into Archive after processing and Execute SQL task to insert transaction log data into the SQL table.
• Interact wif the Enterprise Data Warehouse team to facilitate and document the data mapping to the Reporting SQL Server environment.
• 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
• Produced operational reports in SSRS 2008 i.e. drill-down, drill-through, dashboard and matrix reports.
• Provided design, implementation and maintenance for custom reports 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 wif Microsoft Reporting Services 2008.
• Created SSRS Data Model projects using Microsoft Visual Studio 2008 and using Report Builder for report server to create reports.
• Responded to ad hoc requests and special projects that require immediate attention while at the same time maintaining deadlines on existing requests.
• Worked wif project manager and technical leads for resolution of technical issues.
• Defined appropriate measure groups andKPIs&deployed cubes.
• Extensively used SSIS transformations such asLookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Worked on formatting SSRSreports using the Global variables and expressions.
• Createdparameterized reports, Drill downandDrill throughreports using SSRS.
• Diagnoses and resolved data mart access and performance issues
• Responsible for the creation and maintenance of Analysis Service objects such as Cube, Dimensions, MDX queries, and KPI’s.

Tools: & Technologies: MS SQL Server 2012/2008 R2, T-SQL, SSIS, SSRS, SSAS, Erwin 7.2, Microsoft Access, Oracle 10g

Confidential, Birmingham, AL

Senior MS SQL Server/SSIS/SSRS Developer/ Data Modeler

Responsibilities:

• Worked wif project lead and business users to understand business processes, gather and document project requirements and translate them into functional and non-functional specifications for BI reports and applications.
• Responsible for creating database objects like Views, Store Procedure, Triggers, Functions etc. using T-SQL 2012/2008 to store data and to maintain database efficiently.
• Used ETL to implement the SCD transformation, to maintain historical data in data warehouse. Applied various data transformations like Data Conversion, Multicasting, Conditional Split, Derived column in SSIS.
• Developed and deployed data transfers packages using SSIS 2012/2008, also maintained the jobs running on Servers.
• Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system, Staging DB to Data warehouse and Data marts.
• Wrote SSIS Packages to migrate user’s logins, stored procedures, and functions.
• Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling the packages.
• Deploying, Testing and Scheduling SSIS packages using SQL Agent.
• Developed Custom Functions, Manual Running Totals and Complex Formulas for reports used calculations, sorts, filters and sections to enhance data presentation in reports.
• Created many Cascaded parameters in the reports using SQL SSRS 2012/2008. Developed many Tabular Reports, Matrix Reports, Drill down Reports and Charts using SQL Server Reporting Services (SSRS 2012/2008).
• Highly involved in automating reports generated weekly and monthly basis for the client and business sales teams.
• Worked wif production control team to deploy code and for schedule run in both staging while testing and production. Responsible for providing 24/7 on-call production support for daily job and ETL loads.
• As in development team, worked wif DBA teams for database update and system restarts.

Tools: & Technologies: MS SQL Server 2012/2008 R2, T-SQL, SSIS, SSRS, Win 2003 Advanced Server, Erwin v7.2

Confidential, Wilmington, DE

MS SQL Server Developer/SSIS/SSRS Developer/data modeler

Responsibilities:

• Planned, Defined and Designed data based on business requirement and provided documentation.
• Gathered data and documenting it for further .
• Designed Database using Erwin data modeler.
• Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Cache Transform, Conditional Split and Derived column etc.
• Developed SSIS Packages using Look Up Values & implementing rules provided by Business in the mapping document.
• Developed SSIS packages using Fuzzy Look Up 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.
• Trained on building Conceptual, Logical and Physicaldatamodel.
• Created the conceptual model for thedatawarehouse wif emphasis on insurance (life and health)
• Reviewed and implemented the naming standards for the entities, attributes, alternate keys, and primary keys for the logical model.
• Scheduled Jobs for executing the stored SSIS packages, which were developed to update the database on Daily basis.
• Reviewed the conceptual EDW (EnterpriseDataWarehouse)datamodel wif business users
• Created the Load packages for loading the CSV files from DB2 into SQL Server using SSIS 2008.
• Generated parameterized reports, sub reports, tabular reports using SSRS-2008.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2008.
• Generated Sub-Reports, Drill down reports, Drill through reports and parameterized reports using SSRS 2008.
• Created reports to retrieve data using Stored Procedures that accepts parameters.
• Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard
• Responsible for Monitoring and Tuning Report performance.
• Configured the report viewing security for various users at various levels using Report Manager
• Scheduled report and exported in PDF format.

Tools: & Technologies: MS SQL Server 2008, SSRS, T-SQL, SSIS, Win 2003 Advanced Server, Erwin v7.2.

Confidential, Newton, MA

SQL Developer/BI Developer/Data Analyst

Responsibilities:

• Created SSIS package to export and import data fromSQLServer to Access, text and Excel file. Used Event Handlers for Exception Handling in SSIS packages
• Developed and deployed SSIS packages for ETL from OLTP and various sources to staging and staging to Data warehouse using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Slowly Changing Dimension and more. Performed ETL mappings using MS SQL Server Integration Services
• Modified the existingSQLqueries according to the requests and executed them to check the performance.
• Designed and implemented Data Marts, Facts, Dimensions and OLAP cubes having Star/ Snowflake schemas using Dimensional data Modeling principals in SSAS
• Created data flow model using MS Visio
• Used SQL Server Profiler to trace the slow running queries and the server activity
• Scheduled Jobs and Alerting using SQL Server Agent
• Created stored procedures, views, triggers, user defined functions to in corporate the flow of business
• Involved in project status report updates/ creation of issue items for reviews/ updates of technical and transformation files on timely basis
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS
• Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS
• Created SSRS reports to retrieve data using Stored Procedures that accept parameters
• Performed daily tasks including backup and restore by using MS SQL Server tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor
• Documented all the new procedures, troubleshooting issues and solutions, Enhancement and changes in Daily and monthly running processes, and maintain the database for future

Tools: & Technologies:MS SQL Server 2008, SQL Server Reporting Services 2008, SQL Server Integration Services 2008, SQL Server Analysis Services 2008, Windows 2003/2000 and T-SQL.

Confidential, Dallas, TX

MS SQL Server Developer/ETL Developer

Responsibilities:

• Designing Data Model and implementing changes in the earlier phase of the project to accommodate business logic and dynamic nature of the front-end application.
• Designed and modeled Microsoft SQL Server 2005 data warehouse and data marts, including the modification of existing Microsoft SQL Server 2000 data warehouse and data marts.
• Used SSIS packages to roll our data to Live Tables and to Processing Database.
• Developed database objects such as SSIS Packages, Tables, Triggers, and Indexes using T-SQL, SQL Analyzer and Enterprise Manager
• Configure the SSIS Package for run time Parameters and Configured file
• Develop the Documents for Logging/Error Handling for SSIS Packages
• Integrate the SSIS package, converting all existing DTS packages of MS SQL by adding extra SSIS task.
• Schedule Package using SQL Server Job for weekly/monthly basis.
• Used Checkpoint for avoiding re-executes Package from the first task.
• Develop the Slowly Changing Transformation to maintain the Historical Data.
• Handling the errors during data moving and Sequencing the task as per requirements.
• Perform T-SQL tuning and optimizing queries for Reports, which take longer, time in execution SQL Server 2005.
• Migrated some Crystal reports to SSRS reports manually
• XML result set from Stored Procedures to create custom XML file for third party data export.
• Extensive work on SSIS creating all the interfaces between front end application and SQL Server 2008 database, tan from legacy database to SQL Server Database and vice versa.

Tools: & Technologies: SSIS, MS SQL Server 2008, Windows 2003

Confidential

MS SQL Server Developer

Responsibilities:

• Planned, Defined and Designed database based on business requirement and provided documentation.
• Gathered data and documenting it for further .
• Designed DB using Erwin data modeler.
• Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Cache Transform, Conditional Split and Derived column etc.
• Developed SSIS Packages using LookUp Values & implementing rules provided by Business in the mapping document.
• Created 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.
• Generated parameterized reports, sub reports, tabular reports using SSRS 2005.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS 2005
• Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS 2005.
• Created reports to retrieve data using Stored Procedures that accept parameters.
• Responsible for Monitoring and Performance Tuning of Reports.
• Scheduled report and exported in PDF format.
• Fine tuned SQL Queries for maximum efficiency and performance.
• Provided documentation for all kinds of reports and SSIS packages.
• Designed and implemented Stored Procedures and Triggers for automating tasks.

Tools: & Technologies: MS SQL Server 2000/4.0, Windows Server, Windows NT, .NET, Erwin.