SUMMARY

• 8 plus years of extensive experience in database design, development, and administration with MS SQL Server versions 2016/2012/2008 R2/2005/2000 using BI tools like SSIS, SSAS, SSRS in Financial, Retail, Healthcare, Insurance, and Banking industries.
• Experienced with all phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development, and Implementation.
• Strong experience in logical and physical database design and development, Normalization and data modeling using CA Erwin and MS SQL Server Enterprise manager.
• Excellent experience in migration of data from Excel, Flat file, Oracle to Microsoft SQL Server by using SSIS and DTS (Data Transformation Services) utility.
• Experience in Data Model Designing, Reviewing of OLTP and OLAP Logical and Physical Data Models using ER/Studio and ERWIN
• Experienced in designing high level ETL architecture for overall data transfer from the OLTP - Online Transaction Processing to OLAP - Online Analytical Processing with the help of SSIS.
• Strong experience in designing and developing large number of reports in SSRS using the data from ETL Loads, MS SSAS Cubes and various heterogeneous data sources.
• Worked withTSQL, DDL,andDMLScripts and established relationships between tables usingPrimary KeysandForeign Keys.
• Hands-on experience in various phases of SDLC such as requirements and analysis, design and development, Data warehouse, OLAP Cubes and reporting solutions using MS SQL Server 2008 R2/ 2005/ 2000 SSIS, SSRS and SSAS Technologies, Oracle 9i/10 g, Visual Studio 2003 / 2005/2008
• Expert in designing and scheduling complex SSIS Packages for transferring data manually from multiple data sources to SQL server.
• Excellent knowledge in creating Databases, Tables, Stored Procedure, DDL/DML, Views, User defined data types, Cursors and Indexes using TSQL.
• Experienced in using TSQL in SQL Server 2012, 2008 and 2005 platform
• Experienced in writing complex TSQL queries using Inner, Outer and Cross Joins.
• In-depth knowledge of TransactSQL (DDL, DML, DCL) and design and normalization of the database tables.
• Test & Deploy code across various SDLC Environments like TEST, UA/UT/Production
• In depth Knowledge inER ModelingandDimensional modeling(Star and Snowflake Schema) building Dimension and Fact tables.
• Experienced with document integration architecture.
• Expert in creating, configuring and fine-tuning ETL workflows designed in DTS and MS SQL Server Integration Services (SSIS).
• Experienced in developing and modifying cubes using SSAS and transform into pivot table.
• Experienced in developing and modifying multi-dimensional cubes using SQL Server Analysis Services (SSAS)
• Experienced working in Project Management Team.
• Experienced in automation of tasks using Cron Jobs schedulers and scripting using Bash, Perl and UNIX Shell Scripting in UNIX environment.
• Expert in Creating and Deploying SSRS Reports on the portal for user accessibility.
• Expert in developing Drill through and Drill down reports using Crystal Reports and MS SQL Server Reporting Services (SSRS)
• Highly proficient in the use of TSQL for developing complex stored procedures, triggers, tables, user functions, user profiles, relational database models and data integrity, SQL joins and query writing.
• Experienced in implementing Key Performance Indicator (KPI) Objects in SSAS 2005.
• Efficient in upgrading and migration from SQL Server 2000 to SQL Server 2012/2008R2/2005.
• Excellent inter personal skills and communication skills and ready to take challenges with proven ability.
• Experienced in moving data from EDI to Data Warehouse using SSIS.
• Knowledge in SQL Server 2014.
• Experience working with Windows server 2012.
• Good Knowledge on Power Builder.
• Possess good interpersonal, communication and analytical skills with demonstrated abilities.

TECHNICAL SKILLS

Business Intelligence: ER/Studio, Erwin, SQL Server 2016,2012, 2008 R2/2005 SSAS, SSRS, SSIS, SQL Server 2000 DTS Packages, SharePoint Server 2005/2007, Performance Point Server 2007, Quick Address Batch, MatchIT, ProClarity, Tableau, Informatica, Business Objects 5.0

Tools: Rational Rose Product Suite, MS-Project, Visual Source Safe, Dream weaver, MS-FrontPage, MS-Office Suite, Adobe Photoshop, Flash 5.0, Microsoft SharePoint 2007 /2010, Aqua Data Studio 4.7 - 7.2.

Database: MS SQL Server 2008 R 2/ 2005/ 2000 / 7.0 ,TSQL, PL/SQL, Teradata, Oracle 8/8i/9i, IBM Db2 8.1 and MS Access

Internet Technology: ASP.NET, Web Services, SOAP, .NET Remoting, Security, ASP, OLE DB, COM/COM+/DCOM, Windows Services, ActiveX DLLs, IIS 4.0/5.0/6.0,HTML & Java Script

Language: UNIX Shell Scripts, C#.NET, VB.NET, VB, C, C++, JAVA

Others: Siebel Analytics, Siebel EIM and Billing System like Geneva etc., PeopleSoft, and SalesLogix

PROFESSIONAL EXPERIENCE

Confidential, Fremont CA

MSBI Developer

Responsibilities:

• Worked on Migration from SQL Server 2000/2005 to SQL Server 2008R2 and SQL Server 2012.
• Worked on upgrading SQL Server 2000 and 2005 databases to SQL Server 2008 R2 and SQL Server 2012.
• Experience in moving data from heterogeneous data sources to SQL Server usingDTS/SSIS.
• Experience in Bulk Copy (BCP), Script task and Script component for complex SSIS transformations.
• Experience in Data Conversion and Data Migration using SSIS and DTS services across different databases like Oracle, MS access and flat files.
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart, Ad hoc, Sub Reports and created report subscriptions.
• Created Reports with complex formulas and to query the database for business Intelligence.
• Developed Drill Down, Cascading, Drill through, Sub reports and Charts using Global variables, Parameters Expressions and Functions for the Business Users
• Experience in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services(SSAS).
• Migrated DTS packages into SSIS packages.
• Experience in working and fixing defects on upgrades to systems from SQL Server 2005 to SQL server 2012.
• MS SQL Server Configuration,Performance Tuning, Client-Server Connectivity, Query Optimization, Database Maintenance Plans and Database Consistency Checking DBCC commands.
• Experience in using profilers, IndexTuning Wizard and performance monitor to monitor SQL Server.
• Experience inCreating and Updating Clustered and Non-Clustered Indexesto keep up the SQL Server Performance
• Successfully migrated old data from legacy systems (FoxPro) and external system including DB2, excel and Oracle into SQL Server 2000 using DTS.
• Working experience as SQL DBA.
• Modified the VB.net code into C# aspx.
• Used Team Foundation Server for the version control, branching and msbuild.
• Experience in Software Development Life Cycle, Testing and Implementation of Client/Server applications -using C#, VB.NET and SQL Server 2012
• Worked with test and production teams to Promote Stored Procedures, SSIS packages and Reports into production.
• Skilled at assessing client needs, working in groups, suggesting ideas that enhance efficiency and performance, implementing technology solutions, and training end users.
• Experienced in working with VBA Macros.

Environment: SQL Server 2012/2008R2 Enterprise Edition, Windows Enterprise Server 2008R2, IIS, Tableau, 7.5, C#, SSRS, SSIS, UNIX, Excel 2007/2010, VBA Macros, DB2

Confidential, Ft. Worth, TX

Sr. SQL Server Developer

Responsibilities:

• Developed dashboards and key Performance Indicators (KPI) with SQL Server Reporting Services (SSRS) and Power BI and also deployed dashboards onto SharePoint.
• Worked with Business Analysts in gathering requirements and translating them to technical specifications.
• Involved in the analysis and profiling of source data, creating prototypes and sample reports to help with requirements and design.
• Using SQL Server Reporting Services(SSRS)delivering enterprise, web-enabled reporting to create reports that draw content from a variety of data sources.
• Created jobs for automatically running stored procedures for day-end operations using SQL Server agent such as index rebuild, data loads and summary reports
• Involved inPerformance Tuningof Code using execution plan and SQL profiler and addedIndexesto improve performance on tables
• ESRI ArcGIS Programmer w/Python, Arc Objects, and VBA.
• Assisted Deployment team in setting up Hadoop cluster and services.
• Generated Reports using Global Variables, Expressions and Functions for the reports usingSSRS2012.
• Participating in defining ETL strategies, preparing transformation rulesand mappingdatafrom source to target
• Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Implemented security to restrict the access to users and to allow them to use only certain reports.
• Designed and developed efficientSSISpackages for processing fact and dimension tables with complextransformations.
• Provided daily support to Canadian clients and Entered customer information into CRM software
• Active participation in Software Development Life Cycle (SDLC) specifically waterfall and Agile Scrum methodology
• Extensively used Informatica Repository Manager and Workflow Monitor
• Developed and maintained many SSRS reports in BIDS for users by gathering and analyzing the requirements, validating the accuracy of the report’s output and deploying it on SharePoint 2007 and in .net intranet applications for internal Investment clients.
• Using SSIS with CRM Kingsway for all CURD operations to the SQL CRM database
• Experience in creating packages to transfer data between ORACLE, MS ACCESS and FLAT FILES to SQL SERVER usingDTS/SSIS.
• Used Cognos Scheduler to schedule the Reports.
• Skilled in WebFOCUS products such as BI Dashboard, Developer Studio, HTML Layout
• Used Tortoise SVN a version control software for windows to store, run, view, edit and revert back to different versions of the design in case of a system crash.
• Predictive Model for Human Activity Recognition using R machine learning packages on AWS EC2 (cloud).
• Provided daily support to Canadian clients and Entered customer information into CRM software
• Assisted Deployment team in setting up Hadoop cluster and services.
• Good experience in Generating Statistics/extracts/reports from the Hadoop
• Worked onquerying dataandcreating on-demand reportsusingReport BuilderinSSRSreports andsend the reports via email.
• Understanding the domain and nodes as well as by using the informatica integration service to run the workflows in 8.5.1
• Experienced in Business process Analysis, Improvement, Optimization and application Integration.
• Good experience in Generating Statistics/extracts/reports from the Hadoop.
• Extracted large volumes of data from various data sources and loaded the data into target data sources by performing different kinds of transformations usingSQL Server Integration Services (SSIS).
• CreatedSSISpackages for Uploading of different formats of files (Excel, Access, dbf) and databases (SQL server, Flat files) into the SQL Server data warehouse using SQL Server Integration Services (SSIS).
• Designed data architecture for one project with cloud computing environment using Amazon Web Services AWS for hosting the databases.
• Applied Agile Methodology for Rapid Software Development in all BI Reporting and Security project
• Integrated BOBJ 4.0 and BODS 4.0 with SAP HANA1.0.
• Integrated SharePoint with SSRS and managed reports subscriptions, delivery, generation, rendering, and sharpshooting via SharePoint User Interface.
• Good experience in working with the windows application using the environment of VB.NET.
• Worked extensively on developing WCF web services using .Net Framework3.0, Asp.Net, VB.NET, C#.
• Experienced using Visio database design.
• Having strong and working knowledge on Cognos Connection, Query Studio, Report Studio and Frame work manager
• Support and develop Siemens VAI Iron making MES using .net technology and MS SQL/Oracle database
• Knowledge in performance troubleshooting and tuning Hadoop clusters
• Worked on Power BI and prepared dashboards using Tableau to make it more attractive.
• Migrated data from Heterogeneous Data Sources and legacy system (DB2, Access, Excel) to SQL Server databases using SQL Server Integration Services (SSIS) to overcome transformation constraints
• Experienced in integration testing and data quality.
• SQL Server Index Maintenance and Performance Tuning for Large Tables
• Rewrote and tuned long-running SQL queries to cut execution time, ease database load and improve scalability.
• N-tier architecture using ASP pages, JavaScript, HTML, DHTML, VB Script, FLASH, VB COM+ components, SQL Server 2000 and MTS
• Used Power BI Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports
• Designed data architecture with cloud computing environment using Amazon Web Services AWS for hosting the databases
• Expertise in Tableau, MySQL, Teradata, Oracle, Qlikview, Informatica, COBOL, PL/I, EASYTRIEVE, CICS, DB2, SQL, XML, MS. Access, MS SQL server.
• Used Script task to write custom code using C#
• Experienced working with Winforms for desktop applications.
• Experienced working with Autosys scheduler for reporting and monitoring jobs.
• Experience inETL Data Warehouseenvironment. Created Jobs inSSISand was responsible for ETL job scheduled to run daily.
• Participated in development/implementation of ClouderaHadoop environment
• Worked on various Java sdk scripts to configure authentications, SSO, and web servers for HANA, SAP BW7.3, BODS4.0 and BOBJ4.0.
• Designing and implementing a variety ofSSRSreports such asParameterized,Drilldown, Ad hoc and Sub-reports using Report Designer andReport Builder based on the requirements.
• Good Knowledge on creatingscorecardsanddashboardsusing MS Office performance Point Server (MS ProClarity Analytics) Dashboard Designer and integrated them with SharePoint Web Services
• Worked on JIRA defect tracking.
• Experience in VBA macros to deal errors in excel.
• Developed, monitored and deployedSSISpackages.
• CreatingReportsas per user requirements usingSQL Server Reporting Services 2012.
• Created different types of reports such as Cross-Tab, Drill-down, Drill Through, OLAP andSub reports, and formatting them using bothSSRS2012.
• Written complexTSQLqueries and created Stored Procedures, Triggers, Functions and Views.
• Created data driven subscriptions for different users using Report Manager.
• Experience in SQL DBA.
• Involved in Extraction, Transformation amp Loading ETL process and used Informatica Power Center tools - Source Analyzer, warehouse designer, Mapping Designer, Workflow Manager and Workflow Monitor
• Excellent ability to gather and understand business requirements and translate into IT solutions with the use of Cognos
• Imported and exported data intoMS Accessdatabases and DebuggedVBA scriptslinked to said databases.
• Knowledge in performance troubleshooting and tuningHadoop clusters.
• Worked on Agile Environment.
• Maintaining the version of the project inTeam Foundation Server (TFS)by merging the module developed with latest version inTFS.

Environment: MS SQL Server 2008 R2/2012, Team Foundation Server, Excel 2010, VAB Macros, Microsoft Reporting Services (SSRS), Visual Studio 2010, Windows 7,T-, Erwin v8.0, ASP.Net, C#.JIRA, DB2, UNIX

Confidential, Austin, TX

Sr. SQL Developer/BI Developer

Responsibilities:

• Worked on Migration from SQL Server 2000/2005 to SQL Server 2008R2 and SQL Server 2012.
• Worked on upgrading SQL Server 2000 and 2005 databases to SQL Server 2008 R2 and SQL Server 2012.
• Experienced in managing and reviewing Hadoop log files.
• Experienced on Tableau Admin activities, Multidimensional database and writing SQL queries.
• Experience in moving data from heterogeneous data sources to SQL Server usingDTS/SSIS.
• Experience in Bulk Copy (BCP), Script task and Script component for complex SSIS transformations.
• Experience in Data Conversion and Data Migration using SSIS and DTS services across different databases like Oracle, MS access and flat files.
• Proficient in using Agile Scrum methodologies, performed roles of Scrum Master following sprint/standup sessions and used Excel extensively to write user stories, analyzed the Iteration Burn Down charts and reviewed defects.
• Development of oracle PL/SQL functions and procedures to Populate the Dimension and Fact table of STAR Schema
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart, Ad hoc, Sub Reports and created report subscriptions.
• Integrated SAP Net weaver portal to Business objects content using Knowledge management, Iviews, work sets, portal roles
• Created and Configured Workflows, Worklets, and Sessions to transport the data to target warehouse Netezza tables using Informatica Workflow Manager.
• Experienced in creating interactive UI Design (Siebel Answers, Delivers, and Dashboards) including experience in User Interface Design using CSS, HTML, XML and Java Scripts.
• Built, and deployed a multitude applications utilizing almost all of the AWS stack (Including EC2, R53, S3, RDS, DynamoDB, SQS, IAM, and EMR), focussing on high-availability, fault tolerance, and auto-scaling
• Created web parts, workflows, info path forms and used SharePoint designer for master page creation.
• Created Reports with complex formulas and to query the database for business Intelligence.
• Developed Drill Down, Cascading, Drill through, Sub reports and Charts using Global variables, Parameters Expressions and Functions for the Business Users
• Experience in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services(SSAS).
• Creating SSRS and CRM reports and CRM dashboards for the users
• Having good knowledge on HTML and JavaScript and ability to implement those technologies in Cognos reports.
• Migrated DTS packages into SSIS packages.
• Experience in working and fixing defects on upgrades to systems from SQL Server 2005 to SQL server 2012.
• DesignedSSRSreports withsub reports, dynamic sorting, defining data source and subtotals for the report.
• Participated in development/implementation of ClouderaHadoop environment.
• Experienced in Tableau Platform Dash boarding In-Memory OLAP processing.
• MS SQL Server Configuration,Performance Tuning, Client-Server Connectivity, Query Optimization, Database Maintenance Plans and Database Consistency Checking DBCC commands.
• Experience in using profilers, IndexTuning Wizard and performance monitor to monitor SQL Server.
• Experience inCreating and Updating Clustered and Non-Clustered Indexesto keep up the SQL Server Performance
• Used DTS, SSIS, MS Access and Excel to extract and transform data from a variety of data sources to a staging database to be used as the souce for local reports.
• Successfully migrated old data from legacy systems (FoxPro) and external system including DB2, excel and Oracle into SQL Server 2000 using DTS.
• Working experience as SQL DBA.
• Modified the VB.net code into C# aspx.
• Used Team Foundation Server for the version control, branching and msbuild.
• Experience in Software Development Life Cycle, Testing and Implementation of Client/Server applications -using C#, VB.NET and SQL Server 2012
• Worked with test and production teams to Promote Stored Procedures, SSIS packages and Reports into production.
• Created and Configured Workflows, Worklets, and Sessions to transport the data to target warehouse Netezza tables using Informatica Workflow Mana
• Experience in solving issues relatedSharePointEnvironment and SQL server.
• Skilled at assessing client needs, working in groups, suggesting ideas that enhance efficiency and performance, implementing technology solutions, and training end users.
• Experienced in working with VBA Macros.

Environment: SQL Server 2012/2008R2 Enterprise Edition, Windows Enterprise Server 2008R2, IIS 7.5, C#, SSRS, SSIS, UNIX, Excel 2007/2010, VBA Macros, DB2

Confidential, Louisville, KY

Sr 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 anddevelopedMicrosoft SQL Server 2008 R2 data warehouse and data marts, including the modification of existing Microsoft SQL Server 2005 data warehouse and data marts.
• Used SSIS packages to roll out data to Live Tables and to Processing Database.
• Developed database objects such as Tables, Triggers, and Indexes using TSQL, SQL Analyzer and Enterprise Manager
• Strong experience in all phases of Software Development Lifecycle (SDLC) using Waterfall, Agile/Scrum, RUP (Rational Unified Process) and Software Testing Life Cycle (STLC).
• Created DTS packages using Active X Task to migrate data from heterogeneous data sources such as MS Access, Excel etc.
• Creating SSRS and CRM reports and CRM dashboards for the users
• Experienced in managing and reviewing Hadoop log files
• Acted as a lead resource and build the entire Hadoop platform from scratch.
• Designed data architecture with cloud computing environment using Amazon Web Services AWS for hosting the databases
• Integrated ERP Systems (People Soft, Oracle EBS, SAP) in order to extract and load the data in to the target HFM applications using FDMEE
• Created medium universes using the IDT (Information Designer Tool) in SAP BO XI 4.0 from the relational data sources for work flow reporting.
• Extracted and audited data for SAP Tables, functions, Idocs.
• Integrate SQL Server 2005 Reporting Services with Microsoft Sharepoint Portal Server to deliver automatically generated reports to the Share Point portal
• Develop the Documents for Logging/Error Handling for SSIS Packages
• Schedule Package using SQL Server Job for daily/weekly/monthly feeds.
• Used Checkpoint as part of SSIS packages to rerun the package from the closest point of failure.
• Develop the Slowly Changing Transformation to maintain the Historical Data.
• Handling the errors during data moving and Sequencing the task as per requirements.
• Developed packages using fuzzy task for data cleansing.
• Experience in writing dimensions using DAX language and KPI's based on the user requirement
• Performed data Visualization and interpretation using Tableau, batch scripting, ad-hoc SQL analysis
• Worked as a developer on databases like MS SQL Server 2000, MS Access.
• Handling the orphan rows in Dimension and Fact tables.
• Participated actively in analysis and discovery phases of data warehouse implementation.
• Perform TSQL tuning and optimizing queries for Reports, which take longer, time in execution SQL Server 2008.
• Backed by strong credentials including a bachelor degree in Electronics & communication, SDLC, Experience in Agile and V-shaped testing methodologies, Strong knowledge of Transact-SQL, Pl/SQL languages and Date warehouse architecture. ETL tools Informatica Power center and Oracle SQL developer, BI tool OBIEE and cross-platform skills in Windows and UNIX.
• Used MS Excel to produce Dashboard mockups for developers for Tableau. Prepared Power point slides to present development solutions to the developer team. Used Ataccama for Data Quality Management. Used Alteryx for Data Blending and Analytics.
• Developed interface and reporting stored procedures, views, UDF for efficient data storage and manipulation
• Experience in creating re-useable UI components using task-flow declarative components in ADF.
• Migrated some Crystal reports to SSRS reports manually
• Used 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, then from legacy database to SQL Server Database and vice versa.

Environment: MS SQL Server 2008 R2, SSRS, TSQL, SSIS, Win 2003 Advanced Server, Erwin v7.2

Confidential

Microsoft Business Intelligence Consultant

Responsibilities:

• Involved in Design, Development and Deployment of the entire ETL solution of the Siebel Data Migration using Microsoft SQL Server 2005 SSIS Packages.
• Involved in building Cubes using Microsoft SQL Server 2005 SSAS for the Core Business Analysts.
• Analyzing Address & Name data for discrepancies and mismatch by each element by system.
• Involved in cleaning the Names and addresses in different systems by validating against the CAS USPS standardized data by using Quick Address Batch Tool.
• Used MS Access and Excel to prototype reports before developing with SSRS and deploying on the report server.
• Experience in Integrated Oracle EBS to the HFM/Planning/Essbase applications using FDMEE as the ETL tool
• Acted as a lead resource and build the entire Hadoop platform from scratch.
• Expertise in DevOps, Release Engineering, Configuration Management, Cloud Infrastructure, Automation. It includes Amazon Web Services (AWS), Ant, Maven, Jenkins, Chef, SVN, GitHub, Serena Products, ClearCase, Build Forge, Serena PVCS, CVS, Tomcat, JBoss, LINUX etc
• Created MDX queries to retrieve data from the cube and also to display SSRS reports
• Involved in Syncing up and Deduping Data in different systems by using Match IT Tool and SQL Scripts.
• Involved in generating different kind of data profiling reports and Extracts in the form of flat files etc.
• Designed, developed and implemented most complex logic of building Account Hierarchies among all the different Account Types such as Wire line and Wireless Customer, Service, Circuit and LEG Accounts.
• Designed, developed and implemented the Assets Migration Logic compatible with the new Product / Bundles Structure in the Target by incorporating multi-level hierarchies. This piece has been recognized and appreciated to a greater extent by the Oracle Partner.
• In-depth knowledge of working and implementation of Crystal Reports, converting Crystal reports to SSRS Reports and in upgrading crystal reports 8.5/9.0/10 to XI.
• Created variousSSRS Reportsinvolving variety of features likeReports,Charts,Filters,Sub-Reports,DrillDown,Drill-Through,Multi-valued parametersetc.
• Participated in Agile Scrum planning sessions as client transitioned from waterfall delivery methods and began educating team members on the nuances of DW/BI development via Agile Scrum
• Involved in interacting with the different ACS Stewards associated with different data elements like Billing Name, Service Name, Billing Address, Service Address and Tax Address for defining business rules / config criteria required for cleansing.
• Designed, Developed and Deployed ACS Report using MSRS by migrating the existing Reports from DB2 Scripts / Shell Scripts.

Environment: Quick Address Batch, Match IT, MS SQL Server 2005/2000, Toad for DB2 Freeware, Aqua Data Studio 4.7-7.2 SQL Editor, Siebel 7.5 and 8.0, MSIS and MSRS, Siebel Data Model.

Confidential

SQL Server Developer

Responsibilities:

• Implemented a well-planned backup and restore strategy that protects databases against data loss
• Responsible for design, development and implementation of mappings/transformations based in source-to-target specifications, definingETL (extract transform, load).
• Developed complexSQL queries,stored procedures, andDTSpackages
• Involved in complete SDLC, which includes requirement gathering, analysis, design, development, Implementation
• Worked on Setup and Workflow in FDMEE
• Involved in designing and writingStored Procedures,functionsand packages using TSQL for SQL Server 2005
• Development of oracle PL/SQL functions and procedures to Populate the Dimension and Fact table of STAR Schema
• Used DBCC utilities to fix data corruption in application databases
• Development of Business rules implemented asConstraints, Triggersand orStored Procedures
• Actively involved in Normalization & De-normalization of database.
• Installed and ConfiguredSQL Server 2005on servers.
• Designed DDL and DML for MS SQL Server 2005.
• UsingSQL Server Integration Services (SSIS)to populate data from various data sources
• Optimized query performance by creating indexes.
• Involved in writingSQL batch scripts.
• Created scripts for tables,stored procedures andDTS.
• WritingTSQLstatements for retrieval of data and Involved inperformance tuningof TSQL
• Involved in merging existing databases and designed new datamodels to meet the requirements.
• Createjoinsandsub-queriesfor complex queries involving multiple tables.
• Used DML for writingtriggers, stored procedures, and data manipulation.
• Taking DatabaseFull Backup, Transaction log backup & differential backupin daily Routine
• Monitor production Server Activity
• Worked with DTS packages to load the massaged data into Data warehousing system
• Tuned the SQL queries using SQL profiler and involved in tuning the database

Environment: SQL Server 2005 Enterprise, Windows Enterprise Server 2003, Erwin, Microsoft Visio, DTS, SQL Profiler, Query Analyzer.