Roles And Responsibilities 2m236f

Resume



Search for: Jobs Resumes Search

Keywords or title

City, state or zip code

Sr sql server ssis/ssrs/ssas developer

Post Job For Free

Posted Name is not set. by: Posted 11/6/2009 date: *****@***********.**.** Info: *****... Show Info Country: United States State: Ohio City: Worthington ZIP: 43085 Email: [email protected]

Similar jobs: warehouse - 1016 sales - 11998 project manager 3530 Jobs vs Resumes

PostJobFree Become a Recruiter Only $20/month

Map data ©2010 Europa Technologies - of Use

Resume a

Similar resumes: java - 2982 c# - 932 java developer 1226 asp.net - 817 sharepoint - 856

Text: SQLSERVER SSIS/SSRS/SSAS/ETL/BI DEVELOPER/DBA WAJID Email: [email protected] Professional Summary: • 6 + years of istration and development experience on Database Design and Development in SQL server 2005/2000 system in OLTP and OLAP environment. • 6 +years of experience in SSIS, SSAS and SSRS of MS SQL Server. • Excellent command on SQL SERVER 2008. • Data modeling using Erwin Data Modeler and MS Visio. • Expert in deg and implementing relational database model as per business needs. • In-depth knowledge of Transact-SQL (DDL, DML). • Expert in creating indexes, Views, complex Stored Procedures, defined functions, cursors, derived tables, common table expressions (CTEs) and Triggers to facilitate efficient data manipulation and data consistency. • 6+ years experience in T-SQL programming. • Reporting Services, Notification Services, Indexing and Full-Text Search • Excellent command of writing ad-hoc queries utilizing Dynamic SQL and SQLCMD command line utility. • Excellent skills in implementing ETL Packages using DTS and SSIS 2008/ 2005. • Proficient in implementing all transformations available on the SSIS toolbox. • Experience in creating master and child packages, package configurations and logging. • Excellent knowledge of using variables and expressions in packages. • Experience in writing VB scripts in script component task. • Migrated DTS packages to SSIS and modified using DTS editor wizard. • Experience in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous System using SQL tools (SSIS, DTS, Bulk Insert, B, XML). • Experience in writing distributed queries. • Experience in Importing/Exporting Data from various data sources like Excel, Oracle ,DB2 and Flat file using DTS utility. Involved in transformation of OLTP data to the Data Warehouse using DTS and SQL commands. • Experience in installation, upgrade and configuration of Microsoft SQL Server and databases.

• Experience in Microsoft SQL Server Database istration including planning, backup, and recovery strategies. • Experience in Performance Tuning, Query Optimization, Database consistency checks using DBCC utilities. • Experience in failover clustering. • Experience in implementing Disaster Recovery for minimal downtime using different types of database backups, restore, and replication. • Experience in implementing log shipping and mirroring. • Extensively used tools like SQL Profiler, Index Tuning Wizard, and Database Engine tuning wizard, Windows Performance Monitor for monitoring and tuning MS SQL Server performance. • Experience in creating Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages. • Extensive experience in database tuning, server s and database permissions. • Expert in deg Star Schema and snowflake schema with Facts, Dimensions, Measures and Cubes • Experience in deg, creating, processing of cubes using SSAS. • Expert in calculating measures and dimension using multi dimensional expression (MDX), mathematical formulas, and -defined functions. • Good experience in Deg Aggregations and precalculating the same in SSAS 2005. • Excellent hands on experience in creating groups and measures, KPIs. • Expertise in generating reports using MS Reporting Services 2008/2005/2000. • Experience in configuration of report server and report manager scheduling, give permissions to different level of s in SQL Server Reporting Services (SSRS). • Experience in generating on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services.. • Experience in XML scripts. • Experience in Dimensional Modeling. • Experience working with XML documents. • Experience in wrting VB scripts for define functions in SSRS. • Excellent hands on experience scheduling and the deployment of the reports and ing files to a report server catalog from the report manger. • Excellent command on subscriptions, report snapshot and

report cache. • Worked extensively on system analysis, design, development, testing and implementation of projects (Complete SDLC) and capable of handling responsibilities independently as well as a proactive team • Some experience in DB2 queries. • Experience in .NET coding. • Good skills in MS. • Worked on development/staging/production environments and used Team foundation server/visual source safe for version controls and communication’s well as defining Actions, translations and perspectives. • Good skills with computer science concepts and programming. • Very good communication skills, good interpersonal skills & desire to excel, fast learner, hardworking and a versatile team player. Technical Skills: RDBMS/DBMS: MS-SQL Server 2005/2000/7.0, Oracle 8i/9i/10g, MS Access. Programming Languages: T-SQL, MDX,PL/SQL, C, C++, C#, HTML, XML, Java, ASP .NET, VB6 .NET Software/Databases: MS SQL Server 2005 / 2000/7.0, MS SQL Server Reporting Services 2008/2005/2000 (SSRS), MS SQL Server Analysis Services 2005(SSAS), MS SQL Server Integration Services 2005 (SSIS), Data Transformation Services (DTS), Oracle 9i/10g, ODBC, OLTP, OLAP, SQL Server Management studio (SSMS), MS SQL Server 2000 Enterprise Manager, SQL Query Analyzer, Web Services, SQL Profiler, Bulk Copy Program (B),ProClarity Operating Systems: Windows 98/2000/2003/XP/NT/Vista, Windows 2000Advanced Server, Windows 2003 Enterprise Server. Version Control: Visual SourceSafe (VSS), Team Foundation Server (TFS). Web Servers: IIS 6.0, Apache, Share Point(MOSS), Performance Point Server. IDE & BI Tools: SQL Server BI Development Studio (BIDS),

MS Visual Studio 2008/2005,Crystal Reports Data modeling Tools: Erwin 7.2/4.5/4.0, MS Visio 2003/2007, Rational Rose Design Methodology Unified Modeling Language 1.1 using Rational Rose. Reporting Tools SQL server Reporting Services(SSRS),Crystal Reports,Dundas Chart ETL Tools SQL Server Integration Services(SSIS),DTS Academic Qualifications: • Bachelors in Computer Science Certification: • Microsoft Certified Technology Specialist (MCTS)-SQL Server 2005 Professional Experience: Cardinal Health, Columbus, OH Jun 2008 to Present SQL Server SSIS/SSRS/SSAS Developer Cardinal Health is a leader in technologies and services that help hospitals manage all medications from the moment they arrive until they are istered to the patient; store and track specialty supplies; and identify and prevent hospital-acquired infections. The scope of the project was a CRM based inventory-management service a application provided by cardinal health which enables customers to track their orders and manage the inventory by reports provided based on business. The project requires Extract and loading data to data warehouse , creating reports and cube. Responsibilities & Accomplishments: • Created SSIS packages to clean and load data to data warehouse. • Created package to transfer data between OLTP and OLAP databases. • Created SSIS Packages using Pivot Transformation,

Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, 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 a table to save dirty records. • Extracted data from XML to sql server.. • Created SSIS packages for data Importing, Cleansing, and Parsing etc. Extracted, cleaned and validated • Created complex queries to automate data profiling process needed to define the structure of the pre staging and staging area. • Scheduled Cube Processing from Staging Database Tables using SQL Server Agent • Wrote MDX queries and expressions for use in Front End BI Applications. • Created KPI Objects in line with Requirement Docs. • Optimized cubes for better query performance. • Extracted data from XML files. • Aggregated cube with 40% performance for better performance. • Processed cube to perform incremental updates. • Wrote MDX expressions to create name sets and calculated . • Created reports by dragging data from cube and wrote mdx scripts. • Created reports by extracting data from cube. • Generated reports using SQL Server Reporting Services 2005/2008 from OLTP and OLAP data sources. • Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports. • Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status. • Prepared the Layouts by placing the fields to the appropriate place according to the requirement of the final Report. • Created report models and deployed on report server. • Created standard report Subscriptions and Data Driven report Subscriptions • Created report snapshots and cache for better performance. • Used Notification services to generate error messages and send them to the through e-mails, pager messages,

and PDA as well as window messengers. • Created ad-hoc reports, drill down, and drill through reports. • Deployed reports on Microsoft office sharepoint(Moss). • Created define functions in SSRS using VB script. • Reviewed and adjusted deliverables involved during SDLC involving database changes/development. • Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications • Manage Analysis management objects(AMO) using BIDS. • Provided knowledge transfer to the company’s SQL programmers. • Designed maintenance plans • Wrote distributed queries to extract data from different servers. • Created and tuned stored procedures, triggers and tables. • Created several materialized views and UDF’s to be accessed by the new front end applications. • Created views by vertical partitions of tables. • Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases • Optimized the performance of various SQL scripts, stored procedures and triggers by using embedded UDFs, CTEs and System stored procedures. • Successfully tested all task in staging and stored all versions of data using team foundation server(TFS). Environment: SQL Server 2008/2005, BIDS 2005, Reporting service es 2005, Integration Services 2005,Analysis Services 2005, Windows Server 2003, HealthCare database, Oracle 9i,DB2,Share point server,TFS WellPoint HMC Richmond Virginia Aug 2007- Jun 2008 SQL Server Developer/SSIS/SSRS/DBA HMC, a wholly owned subsidiary of WellPoint Inc., an independent licensee of the Blue Cross and Blue Shield Association and the largest health insurer in the United States, works with insurers to keep healthy those who suffer from chronic medical conditions such as asthma, circulatory problems, or diabetes. The data warehouse was on MS SQL Server 2000. Because of the company’s growth and so growth of database that was 3.8 TB,WellPoint increased

requirements led them to move to MS SQL Server 2005 having some enhanced features. This project requires monitoring for billing services by creating reports and report model using SSRS according to business requirement. Migrated from SQL Server 2000 to SQL Server 2005. The data warehouse was populated using SSIS Packages. Responsibilities & Accomplishments: • Worked with Business Analysts and s to understand the requirement. • Implement logical design into physical design. • Maintained design structure (Schema) by directing implementation of SQL standards and guidelines. • Created a virtual machine and migrated databases. • Migrated DTS packages using DTS editor wizard in SSIS ,validated and tested all packages on development server • Migrated data from different data sources to sql server. • Tested all stored procedures on testing server • Created Stored Procedures, triggers, UDF, views, tables and generated TSQL script for application • Created indexes for better performance • Tested the data with complex queries, s and sub queries. • Successfully migrated the data from SQL Server 2000 to SQL Server 2005. • Created log shipping on servers for disaster recovery. • Created packages to migrate data from different data sources to data warehouse. • Created packages for database maintenance. • Executed Back up database task, check database integrity, rebuild indexes, update statistics task for maintenance • Used VB script in script componenet for data transformations. • Created reports from cubes by writing MDX queries. • Managed Package Configurations in XML Files to efficiently Promote Unit Tested. • Data migration (Import & Export using B) from text to SQL Server2005. • Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, 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. • Identified the Measures and Dimensions from the Excel Sheet. • Successfully Extracted transformed and load data into data warehouse. • Created reports using SSRS from OLTP and OLAP data sources and deployed on report server • Created tabular, matrix, chart, drilldown reports, parametric, cascaded reports and dashboards and scorecards reports according to business requirement. • Deployed the generated reports directly on the client’s workstation. • Created complex Stored Procedures for better performance to generate reports. • Created dashboards and scorecards using dundas charts. • Deployed reports on share point performance server. • Used VB ,net to create define functions in SSRS. • Created standard and data driven Subscription, used report manager for securities. • Created report model for Ad-hoc reporting, generate report in XML format. • Used Team Foundation Server (TFS) for version control, source control and reporting. • Documentation for all kinds of reports and DTS and SSIS packages. Environment: SQL Server 2005, SSIS, SSRS, Query Analyzer, Index Tuning Wizard-SQL MS Access, MS Excel, ERWIN, Windows Server 2003 Enterprise Edition, Share point performance server Franklin Templeton Investments – San Mateo, California Nov 2006 –Aug2007 SQL Server Develper(SSIS/SSRS/SSAS)/ETL Franklin Resources Inc. is an investment firm specializing in conservatively managed mutual funds. It offers products under the Franklin, Templeton, Mutual Series and Fiduciary brand names. The sales feed from Central Data Warehouse (CDW) to the CRM had to be modified to fit the new Salesforce.com architecture, as the existing process was bound to the old schema which was to be discontinued. Project was to alter the process to meet the new business requirements associated with the Salesforce.com Responsibilities: • Extracted required mapping fields from different sources

(schema, CDW) to Sales Force Warehouse for Staging Table. • Performed all Conversion goals and objectives which include identifying data for processing sales, and validating of historical sales is available in CDW for migrating the data to Sales Force. • Analyzed and performed Data mapping which involves identify source data field, identify target entities and their lookup table id’s, and translation rules. Evaluation of data groups and data critically and developed automated conversion process. • Developed and modified many Scalar Valued Functions, Stored Procedures for parsing data required for mapping in Sale Force. Tweaked low performance functions. • Developed Store Procedure and Staging table for data push from CDW to Sales Force. • Preformed QA Testing for all the Store Procedures to validate the sales results. • Developed SSIS Packages not only for particular table’s fields and required data types for lookup tables in Staging but also for data Warehouse requirements of CDW. • Increased query performance by 20%, which is necessary for statistical reporting after monitoring, tuning, and Optimizing Indexes by using Performance Monitor and SQL Profiler. Reduced and obliterated unnecessary s and indexes. • Created and scheduled SSIS packages for running AM and PM feeds from various departments and multiple servers and resources to Development Servers. • Created SSIS Packages by using advanced tools (i.e. pivot Transformation, Derived Columns, Condition Split, Term extraction, Aggregations, Multicasting). • Created Packages by testing and Cleaning the Standardized Data by using tools in Data Flow Transformations (Data Conversion, Export Column, Merge , Sort, Union all, Conditional Split and more) for existing/new packages and huge CSV file import to Sale Force from different data sources and other ongoing tasks for mapping. • Developed and modified the existing reports from basic Chart and tabular to parameterized reports including Single/Multi/Boolean valued parameters and linked reports based on new business logic. • Created SQL server configurations for SSIS packages and XML & Windows event logs. • Used sub reports functionality for complex report

calculations. • Created parameterized reports ing parameter through report screen. • Used VB .net in SSRS. • Rendered reports in different formats like pdf, excel etc to be executed automatically on weekly or monthly basis and managed subscriptions. • Using MDX created calculated for customized calculated measures. • Analyzing the Performance of a Cube by partitioning it and creating Perspective Cubes. • Documented all database objects, procedures, views, functions & packages for future references. • Performed all QA testing and match results for different environments. • Experience in working with stocks and bonds. • Documented all old and migrated Store Procedures and scripts for future references. Environment: Windows XP/2003 Enterprise edition, MS SQL Server 2005/2008, Excel 2003, Visual Studio 2005, TFS, VBScript, Database Engine Tuning Advisor, Profiler SQL Server Management Studio 05, SQL Server Business Intelligence Development Studio, Reporting Services Configuration, SSIS, SSRS. Multiplan Inc, New York, NY Jan 2006- Oct 2006 SQL Server Developer/ SSIS/SSRS Developer Multiplan is one of the most progressive and integrated health insurance organizations in the nation providing services to more than two million residents. The project was to migrate data from various heterogeneous data sources such as oracle, DB2, MS Access, MS Excel and flat files into SQL Server 2005 and maintain Database for the Facility search and Provider search. This was an OLTP database with the data storage of 2.2 TB in size with 210 tables. The presentation Tier was on .Net Framework 2.0 with C# and ASP.Net Interface. Responsibilities & accomplishments: • Developed and created logical and physical database architecture using ERWIN. • Transformed complex business logic into Database design and maintaining it by using SQL objects like Stored

Procedures, Defined Functions, Views, T-SQL Scripting and Jobs. • Successfully implemented indexes on tables for optimum performance. • Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost using index tuning wizard. • Created SSIS packages to import data from MS Access, Excel to SQL 2005 • Filtered bad data from legacy system using Derived column, Lookups, Fuzzy Lookups, Conditional split. • Successfully managed Extraction, Transformation and Loading (ETL) process by pulling large volume of data from various data sources using B in staging database from MS Access, excel. • Developed scripts to migrate data and the database objects to/from multiple sources. • Extensively used s and sub-queries for complex queries involving multiple tables from different databases. • Involved in creating front end interface to allow customers to interact with the application using C# objects and HTML. • Created effective functions, appropriate Triggers to facilitate efficient data manipulation and data consistency. • Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler. • Developed complex stored procedures using T-SQL to generate Ad hoc reports within SQL Server Reporting Service (SSRS). • Built different types of chart reports using SSRS for the business requirement like column chart, Pie Charts. • Created SQL Server Integration Service (SSIS) packages between enterprise databases and Third party data source to transfer data. • Migrated data from different data sources. • Created SSIS package to automate maintenance, database back up, update statistics, re-build indexes as well as create error log for event during data load. • Responsible for the creation and the maintenance of Analysis Services objects such as cubes, dimensions and MDX queries. • Used MDX queries for pre calculated measures. • Created report Model on SSAS Cubes as well as changing default configuration on existing Cubes.

• Configured replication servers and transactional replication between production and standby server for high availability / disaster recovery. • Held responsibility for database maintenance plans. • Actively involved in gathering and analyzing stakeholders requirements. • Created alerts, notifications, and e-mails for system errors. Environment: SQL Server 2005, SSIS, SSRS, Query Analyzer, Database Engine tuning wizard, C#, MS Access, MS Excel, ERWIN, Windows Server 2003 Enterprise Edition, HTML AT&t Dallas TX Nov 2004 – Dec 2005 SQL Server Developer/BI specialist AT&T Inc is the largest provider of local, long distance telephone services in the United States, and also serves digital subscriber line Internet access. AT&T is the second largest provider of wireless service in the United States, with over 77 million wireless customers, and more than 150 million total customers.. The project focused on developing a client specific data-mart that enables the company to prospect for new clients and track the activities of existing clients to better serve them and offer them additional products and services. Responsibilities & Accomplishments: • Created and managed stored procedures, indexed views, defined functions, triggers, database constraints to meet business requirements and policies. • Created and managed complex batch jobs. • Created complex queries for database auditing purposes. • Performed database Tuning, monitoring, and Scalability Testing • Evolved in the creation and maintenance of index using Index Tuning Advisor wizard, Query optimizer, and selected the best indexing plan to be deployed. • Thorough analysis and testing of database objects & TSQL statements before deployment to the production server. • 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, MDX queries, and KPI’s. • Created a report model on SSAS cubes. • Created Drill down Reports, Ad-hoc Reports and Drill through reports using the ROLAP as a source. • Assisted in the scheduling and the deployment of the reports and assisted in ing files to a report server catalog from the report manger. • Scheduled packages and different maintenance tasks using MS jobs. • Used Notification services mainly to manage packages on success, completion and failure of deployments and other tasks. Environment: SQL Server 2000, ERWIN Data Modeler, Windows 2000, Windows 2003 Advanced server, Windows NT, DTS, SSAS, SSRS, SSIS,Crystal Reports ICICI Bank India Aug 2003-Sep 2004 SQL Server DBA ICICI Bank is India's largest private sector bank by market capitalization and second largest overall in of assets. Bank has total assets of D 77 billion, a network of over 1,400 branches, and 24 million customers. Worked on retail collection system, a GUI based client/server bill collection software, to assist brokers in carrying out their daily transactions. Upgrade from MS SQL Server 7.0 to 2000. Responsibilities & Accomplishments: • Involved in requirements gathering, analysis, design, development, change management, • Developed backup restore scripts for SQL Server as needed. • Upgraded to latest version from SQL server 7.0 to 2000. • Written various stored procedures for the purpose of application development. • Tuned SQL statements (Using Indexes) and Stored Procedures. • Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost using index tuning

wizard. • Disaster recovery and database maintenance plan. • Replication of data using Transactional method. • Migrated data from sql server 7 to sql server 2000 sucessfully • Data conversion from Text File into SQL Server Table. • Created constraints and validated database integrity. • Designed and implemented data access stored procedures and triggers for automating tasks. • Job scheduling and alerts. • Designed and implemented and security. • Extracted Data from MS Access and Oracle. • Created many complex Stored Procedures / Functions and used them in Matrix Reports. • Creating reports and hosting it in the web for the s. • Created reports for the senior management. • Involved in java coding with java developers • Tested successfully all store procedures on SQL 2000 server Environment: SQL Server 2000, T-SQL, SQL Server 2000 Reporting Service, VSS,Windows 2000 Server,Enterprise Mnager,Query Analyzer,SQL Profiler

this job seeker

©2010 PostJobFree.com - Home - Fresh Resumes - Post Job