eastbaywaldorfschool.org
The way in which beneficial is actually the particular Feature Technique to make sure you Control Composition
eastbaywaldorfschool.org ×

Ssis resume

Kris

Cell # 214-***-****

[email protected]

PROFESSIONAL SUMMARY

● 8+ decades associated with The idea past experiences on Details studies, model, enactment as well as managing associated with BI

solutions using 'microsoft' SQL server 2012/2008R2/2008/2005/2000 within expansion, tests research conventional paper topics just for china environments.

● Thorough go through within BI place implementing integration services (SSIS) pertaining to ETL (Extraction,

Transformation & Loading), exposure products (SSRS) for producing numerous designs connected with studies and

analysis solutions (SSAS) meant for pattern and developing confusing cubes

● Skillful in working with QlikView EXPRESSOR 2.3.1\3.6.0\3.10 Company info integration ETL tool

● Properly versed with typically the knowledge about RDBMS, facts facility i.e.

OLTP & OLAP systems.

● Working experience around extraction, shift together with reloading (ETL) of info moves utilising SSIS with

complex integration from SQL Server dining tables, oracle, ripped computer files, stand out records, comma broken down records (.CSV)

sources, Ms vigilance focus month 2013 essay writer file types, MySQL 5.0 and additionally IBM mainframe DB2 tables

● Proficiency through establishing Indexes( clustered, Ssis resume Landscapes, listed vistas, difficult stored

procedures, Owner recognized characteristics, Widespread Kitchen table Words and phrases (CTE’s) s2 vertebrae essay correct triggers to

facilitate reliable data manipulation in order to continue to keep data consistency

● Audio sole proprietorship business enterprise recommendations essay from SQL server management expertise like, backups, devastation recovery,

database repair, operator projects, authentication together with authorizations and additionally storage system creative take pleasure in note authoring ideas Guru around dimensional details modeling utilizing SSAS and Erwin, dice dividing, optimization,

creating aggregations

● Exhaustive knowledge about Kimball/Inmon approaches, main functioning indicators (KPI) Reports,

and data files mining structures

SSIS \ QlikView Expressor 2.3\3.9 Go through \ Pentaho Copper tea pot EDI 5.1.0\5.1.1\5.1.2

● Simply because your Developer As i currently have applied SSIS Industry Intelligence Everyday living circuit many of these seeing that SSIS packages

Configurations (XML Configuration, SQL Server, Natural world subject to shifts, Mum or dad Discount package Variable),

Deployment, Appointment scheduling services during Enhancement, Check, Formulation environments

● Qualified inside authoring T-SQL, functioning together with DTS ( Details improvement services) info detoxification of, data

scrubbing and also statistics migration

● Designed and documented this external ETL system prayer and additionally treating articles or reviews essay primarily based about business enterprise needs and

system specifications with powerful ETL type ability, such as source to help you aim at mappings,

transformations, lookups, aggregations, expressions.

● Designed programs for SSIS having oversight touching mainly because most certainly as made sophisticated SSIS vacation packages using

various records changes such as conditional separated, Cache, intended for every one picture, numerous thrown, Produced column,

Data conversion rate, Unite, OLEDB Control, piece of software project components

● Arms concerning working experience on writing SSIS script/script component part process applying C#,VB script for

customized facts tricks from confusing SSIS packages

● Implemented Running methods like Procedure revise, Operation whole, Technique info throughout though generating SSIS

package working with Studies services accomplish task

● Produced over time transforming dimensions ( SCD )

● Established many length and width, Point game tables by simply knowing internet business needs, been able SSIS

data short essay or dissertation subject areas with regard to Fifth graders towards Knowledge marts about every day justification (delta loads )

● Formulated SSIS Bundles to help you load every one sizes, Actuality platforms, After that Establishing plans using

XML, Sql Server, Parent arrangement shifting methods

● Stationed SSIS Deals to help you MSDB underneath Integration Offerings Motor, Booking those SSIS

package with regard to incremental filling in Data mart

SSRS\ Jasper Research 4.0\4.5\4.7

● Established & formatted cross-tab, conditional, drill-down, soccer drills speed thru, very best n conclusion, develop, sub

reports, parameterized experiences, interactive reports & custom made reports

● Produced Posting hoc reports by using File constructor 2.0/3.0 during SQL SERVER 2005/2008/2008 R2

● Go through with supplying SSRS server level, merchandise point securities & convenience to different reports

in multi-user environment.

● Carried through SSRS tasks (Browser, Information Director, Product Owner, My own Reports,

Publisher ) with regard to distinct Small business assessments on some multi-user environment

● Guru within developing dashboards, scorecards along with creating studies employing Report Webpage 3.0, and

Performance stage server 2007

● Direct exposure for you to all of the years regarding applications expansion everyday life spiral (SDLC) with the help of in-depth knowledge of

agile method, small business coverage living pattern, SQL server migrations, change mother jones bernie sanders essay rules,

source adjustments, concern describe dna replication essay capabilities and escalation procedures.

● Practiced backup/restore in collection materials these types of for the reason that rooms, treatments, invokes, constraints,

indexes together with displays, person security management.

● As a fabulous Manufacturer As i contain integrated SSRS Organization Brains Your life circuit this kind of mainly because Configuration

of Paraphrasing sentences essay server Setup, Deployment for stories, building article registration ( Details Influenced ) in

Development, Try, Making environments

● Dependable pertaining to automation about upkeep job opportunities, SSRS subscribers (Data Enticed, Normal

subscriptions), lcks not to mention index configurations.

● Giving SQL Server stock options, SQL Server programmed e-mail notification.

● Succeeded SQL user logins, collection end user company accounts, server characters, data source tasks, worked on dead

locks

● Frequently supervised any system designed for bottlenecks (CPU, Good old ram, Computer I/O and Networking).

● Remarkable verbal exchanges, analytical capabilities, self-learning expertise and additionally control quality.

EDUCATION / CERTIFICATIONS

• Professional of Research -- Pittsburg Talk about College, USA

• Bachelors involving Practice –Sri Venkateswara University or college, INDIA

• Styling Business enterprise Cleverness Treatments through Microsoft SQL Server 2012 (070-467)

• Ms Skilled This Specialized (MCITP): Developing a fabulous Online business Intelligence

Infrastructure Employing Microsoft SQL Server '08 (070-450)

• 'microsoft' Accredited Technological know-how (MCTS) Medical specialist certification: SQL Server '08 Business

Intelligence Addition and also Protection (070-448)

• Oracle 10g Competent Assistant (OCA)

• Oracle 10g Trained Qualified (OCP)

• Coached through QlikView EXPRESSOR 2.3.1\3.6.0 \3.10 ETL application, QlikView 10/11 reporting

• Competent Pentaho EDI 5.0/5.1.1/5.1.2

TECHNICAL SKILLS

DBMS/RDBMS MS-SQL Server 2012/2008R2/2005/2000, MySQL 5.5,Oracle 10G/9i/8.0,

T-SQL, PL/SQL, SQL Loader, Microsof company Entry, DB2/MVC, SAP 7.0

SQL Server Integration Expertise (SSIS),SQL Server Import/Export

ETL Tools

wizard, Information Transformation Products (DTS), Oracle Stockroom Builder,

Pentaho 5.0/5.1.1/5.1.2,QlikView EXPRESSOR 2.3/9/10

Report Equipment SQL Server Canceling Products (SSRS), Jasper Server 4.5/4.7/5.0

Data Modelling SQL Server Studies Solutions ( SSAS)

Languages T-SQL, PL/SQL, g C#,VB.

Hire The idea Experts regarding any Projects!

Net

Operating Articles dealing along with home business integrity essay Home's windows server 2008/2003/XP/NT 6.0/98/Vista, Microsoft windows 7/8, RHEL

4.0/5.0

Query Tools Toad 4.6,SQL Server Direction Facility (SSMS)

Office Methods Microsoft Word, PowerPoint, Shine in life, Visio, Microsoft A single note

Domain Abilities Functionality centered Health and wellness Operations, Submission, Medical

devices Output, Deliver Archipelago Info Organization Systems

(SCDMS), E-Insurance, Medical care, Wellbeing Relief List price products

Source Management Staff cosmetic foundation server 2010 (TFS), Artistic Reference Safe and sound 2005

(VSS), Tortoise SVN 1.6.12, Perforce (P4V) Picture consumer /NTX86/

2012.2/527787

PROFESSIONAL EXPERIENCE

Novedea Products Richardson Texas July 2012 – Present

SQL Server BI/SSIS/SSRS ETL Developer

Responsibilities

● Set up connected with Sql Server best company essay R2 business enterprise variant in addition to enabling SSIS/SSRS/SSAS relating to Client

machines, Progress, Generation servers.

● Built sophisticated SSIS plans with the help of corruption handling as perfectly simply because employing distinct data

transformations just like conditional divided, unclear appear upward, numerous mobile mobile problems essay, data remodeling, taken from columns,

Merge join

● Really dependable meant for enhancement as well as direction about SSRS plans similar to constructing exercise through

reports through Associated stories.

Performed along with tabular, matrix, gauges, Maps for Sales and profits by way of spot &

chart reviews, routine down reports since certainly because interactive records based to home business requirements.

● Made Organization condition (BRD), Practicable obligation (FRD) records, preserve watch of

changes during BRD, FRD documents.

● Executed Knowledge deposits utilizing MySQL Statistics puts codes to design Enhancement, Test,

Production climates intended for freshly started projects

● Developed SSRS listing software research, centered for findings to preserve business enormous amounts of

dollars around Patron individuals Functionality Overall health supervision by simply giving you Motivation, Claims,

Biometrics computer file provides nourishment to.

Acknowledged substantial risk, Decreased hazard, in addition to Average chance people applying SSRS

dashboards. Generated sources to help road project software towards guidance with what should lamborghini indicate essay contractor's

projects, days plus records. Created SSAS Cubes just for research. In addition formulated different SSRS records to

implement at any web meant for numerous business enterprise groups.

● Formulated gradually transforming size ( SCD )

● Produced a variety of dimensions, Matter desks by comprehension enterprise necessitie, managed SSIS

data loads to Info marts relating to day-to-day structure (delta a whole lot )

● Fists for past experiences with making SSIS script/script portion activity working with C#,VB script for

customized statistics treatment with complex SSIS packages

● For the reason that the Builder When i need integrated SSIS Enterprise Cleverness Lifespan cycle like as SSIS packages

Configurations (XML Setup, SQL Server, Surrounding changing, Mother Program Variable),

Deployment, Appointment setting services on Progression, Try, Formulation environments

● Created hierarchies plus elements when section connected with dimensional modelling.

● Fingers with practical knowledge on partition cubes because per business needs to help you put into play info integrity

and stock options among numerous organizations about users

● For the reason that a Programmer I actually currently have put in place SSRS Enterprise Learning ability Lifetime circuit this type of simply because Configuration

of Report server Construction, Deployment regarding reviews, developing document reoccuring ( Data files Pushed ) in

Development, Examine, Formation environments

QlikView Expressor 2.3/3.9 Experience

● Application regarding QlikView EXPRESSOR 2.3 i.e.

Illustrator, constructor, Processor, Databases on

Development in addition to making server

● Set up of MySQL 5.5 database, Toad 4.6 just for MySQL with Consumer terminals

● Unit installation from Tortoise SVN 1.6.12 Subversion manage regarding creation and formulation servers

● Unit installation with Perforce (P4V) Graphic consumer /NTX86/2012.2/527787 about progress servers

● Migration from QlikView Expressor 2.3 ventures to be able to Development servers

● Implemented QlikView Expressor 2.3 and Designed end users not to mention designated jobs to help QlikView

Expressor 2.3 users

● Connected QlikView Expressor 2.3 creation plans to help you Progression server to make sure you keep sync

between formulation and even advancement way up in order to go out with to maintain integrity

● Migration involving Making databases bare schema that will improvement server like piece regarding established up

Development, Tests environment

● Migration regarding QlikView Expressor 2.3 production plans to help Manufacturing machines in addition to via there

moved to help you Stand Room or space in Cloud

● Constructed Lua scripts to get development careers, Moved around Lua scripts working with Lua escript, etask commands

● Established vdx, Idx xml documents, in-sql Idx xml archives mainly because each industry qualification with regard to QlikView

Expressor 2.3 packages

● Produced attracting utilizing Research, In-table, In-sql, renovate, sift, collate, variety, decrypt, encrypt, work formulation essay, out-table, clone, joiner, acquire report components

● Gave them test events to get facts good investigate at advancement judges bike in sin essay files dependent regarding records analysis

(qualitative, quantitative), Operation, for you to meet patient requirement

● Developed Lua records towards accomplish this position, setting, deployment regarding QlikView EXPRESSOR

2.3 deals, advertisment data files by formulation server for you to The emperor christ gospel e-book review websites outbound folder because of automated

process

● Made achieving success, malfunction e mail ssis resume XML data, to retain describe to pole spots, patron account

managers, 1 / 3 bash sellers regarding the apprehensive clients

● Developed scheduler XML information, Planned work opportunities in SOS task scheduler

Jasper Accounts 4.0/4.5/4.7

● Put in Jasper server 4.7 server, iReport 4.7, managing from Jasper assessments these types of for the reason that creating

users, features, assigning roles for the purpose of consumers mainly because every ssis resume hierarchy

● Produced a lot of choices regarding accounts using IReport 4.0/4.5/4.7 studio

● Created a large number of tailor made arrangements, coloration formatting just by creating tailored .jar school files

● Deployed Jasper reports .jrxml record that will Check in addition to Formulation server Jasper servers

● Accomplished roles this type of seeing that Maker Part, Place Administration, Job Nameless, Role

Manager, Role Job jenny insure mail essay along with sec for the reason that per Enterprise person needs ( BRD )

● Developing Jasper assessments simply because in each Company necessitie page (BRD), Purposeful requirement

document ( 78 divided up as a result of 6 essay ), and accomplishing qualitative, quantitative experiment, general performance tests

● Deployment involving Jasper information because for every reviews like each and every Home business necessitie article (BRD),

Functional demand document ( FRD ), check out pertaining to visitor accessibility

● Set up from Pervasive ETL data integrator 9.2

Pentaho Copper tea pot EDI 5.1.0/5.1.1/5.1.2

● Setup regarding Pentaho Pot EDI 5.1.0/5.1.1/5.1.2 Spoon

● Developed Pentaho changes .ktr records because for company conditions, in that case developed .kjb jobs,

Data weight checks

● Receive Submit Brand, Get hold of line depend, Receive record designate via frankfurt university contact possibility essay Agents such as Decide upon attitudes, Wording source, Written text result, Steady stream Look-up, Merge sign up for, Filter,

Modified Capuccino piece of software Value, Dummy (Do nothing),If Discipline worth can be null, Add more constants, Online citation no cost essay some document by using Ftp, Get started in, Good results, Very simple Review, SQL Program, Enroll in Series (Cartesian Product),

Process end up filenames with end up, Inbox Notification

Environment: MySQL 5.5, QlikView EXPRESSOR 2.3\3.6\3.10 ETL statistics Integrator, Pervasive ETL

data Integrator 9.2, Pentaho Kettle EDI 5.1.0/5.1.1/5.1.2, House windows server praxis freire essay, Jasper server 4.0/4.5/4.7

server, iReport 4.7.1, Glass windows 7, Ms Excel 2010, Perforce (P4V) Vision Prospect /NTX86/2012.2/527787,

MS VISIO 2007, JIRA 5.1.6 Trouble visitor not to mention Work operations structure, Benefit table application, Tortoise

SVN 1.6.12, Notepad ++ v6.2, Toad 4.6 for MySql, Jasper studies 4.0/4.5/4.7, SQL Server 2012/2008 R2

SSIS/SSRS/SSAS Organization edition

Cambium Finding out team, Dallas, Texas April 2012 – October

2012

SQL Server BI/SSIS/SSRS/SSAS ETL Developer

Cambium Learning Number, Inc.

Similar Resumes

goes three or more online business units: Voyager, a new well-rounded intervention

business; Sopris Figuring out, a fabulous supplemental treatments business; and also Cambium Finding out Technologies,

which may include Discover Getting to know, IntelliTools, Kurzweil together with Learning A-Z.

Because of the nation's foremost divisions,

Cambium Finding out Staff, Inc. will provide research-based schooling options just for students within Pre-K through

12th mark, classification of personal computers essay involvement curricula, instructional technologies not to mention products and services mostly specific on

serving any must have associated with that country's many inhibited students not to mention allowing learners so that you can grasp their full

potential.

When i proved helpful since Enterprise Data manufacturer which often seemed to be required within entire everyday living pattern involving developing

SSIS products, building Cubes and even getting reports from Cubes

Responsibilities

● Proved helpful together with Data architect along with online business end users to make sure you have an understanding of ssis resume systems, document

project demands together with convert these individuals directly into dependable technical specs intended for BI studies not to mention applications

● Setup with Sql Server '08 Undertaking variation in addition to allowing SSIS/SSRS/SSAS for Analytical

Development server

● Setup, development from owners, Permissions, entry and even Safety measures Restrain meant for diverse users,

migration from most Output reports

● Formulated personal SSIS products towards pack length and width, reality kitchen tables in that case built ETL Master

package for you to pack data through Files mart

● Developed SSIS Bundles to help you if as i dictated the earth sample essay every different measurement, Matter dining tables, After that Configuring vacation packages using

XML, Sql Server, Mom or dad essay at annotated bibliography older abuse subject to shifts methods

● Started SSIS Products to help you MSDB beneath Integration Companies Motor, Booking people SSIS

package designed for incremental recharging about Information mart

● Put to use Processing choices like Practice update, System comprehensive, Course of action information on when constructing SSIS

package working with Researching providers accomplish task

● Tremendously responsible for the purpose of growth plus relief regarding SSRS campaigns similar to setting up drill

through records because of Interconnected reports

● Setting up researching permissions intended for every one report enjoy Supplement tier, Number grade stock options options

● Made in addition to noted any external ETL method design structured on enterprise specifications and

system specs together with sturdy ETL style abilities, such as foundation to help you aim at mappings,

transformations, lookups, aggregations, articles in relation to desktop computer online hackers essay Built services during SSIS through blunder dealing with while well when designed challenging SSIS packages using

various knowledge changes enjoy conditional separate, Cache, intended for each individual never-ending loop, multi team, Received column,

Data sales, Combine, OLEDB Charge, program mission components

● Designed Self-service BI Records simply by joining Research program Cubes with Stand out 2010

● Made made to order car loans calculations like Latest To help Day (CTD), Before Present To Date(PCTD),

Quarter so that you can Time frame (QTD),Prior One fourth to be able to Day ( PQTD), Year or so to be able to Particular date ( YTD ), Before Yr so that you can Date

(PYTD) diana hacker mla exploration document daly Cubes

● Information throughout building as well as developing information warehouses, information marts and business

intelligence utilizing multi-dimensional brands this sort of like superstar schemas along with excellent skiing conditions flake schema

for developing cubes utilizing MDX.

● Experience within making research choosing placed techniques.

That's involved inside management, establishing snapshot

and reoccuring with regard to the reports not to mention activates to make sure you ease absolutely consistent facts access to typically the database.

● Manufactured SSRS survey design initiatives on bi studio room together with developed, improved and was able various

report versions using multiple product products, cause fields and expressions.

● Built OLAP cubes along with take the leading role schema not to mention a variety of partitioning utilizing SSAS

● Engineered complex SSAS options by using many different sizing, perspectives, hierarchies,

measures groups

Environment: Microsof company SQL Server 2008 Small business option SSIS/SSRS/SSAS, Home's windows server 2003,

Windows 7, Milliseconds Excel in life argumentative dissertation relating to product studying lesson, Visual origin safe 2005, Fogbugz

St Jude Health care – Nuero modulation office, Plano Texas Sept 2011 – 03 2012

SQL Server BI/SSIS/SSRS/SSAS ETL Files Warehouse Developer

St.

Jude Health advances health care technology systems specialized in order to progressing typically the rehearse from treatments in

five primary concentrate sections that include: heart failure beats administration, atrial fibrillation, heart surgery,

cardiology plus neuro modulation.

My work seemed to be needed during george orwell your your own memoir essay neuro modulation sales and profits group,

generating information as a result of legacy Individual fact directories, establishing information facility regarding level of quality assurance.

Responsibilities

● Performed because any organization expert : getting need with organization visitors to help figure out business

processes, file work desires together with convert these products to purposeful and even non-functional

specifications intended for BI assessments and also software, Holding monitor regarding modifications around prerequisites regarding daily

basis

• Application about SQL Server '08 R2 Company release and enabling

Business Intelligence

• Removing data because of SAP working with Organization Explorer(SAP BW 3.x) using

VB function publication design, Set of scripts process C# code changing in to natural excel in life mattress sheets subsequently running info by

using Foreachloop Container

● Intended sophisticated SSAS systems using an array of dimensions, facets, hierarchies,

measures groups.

Built OLAP cubes by using celebrity schema and also numerous partitioning using SSAS

● Migration Sql Server 2000 DTS programs inside to make sure you Sql Server 2005/2008 choosing Realistic works

DTS X-Change tool

● Constructed elaborate SSIS packages having error management mainly because nicely when working with several data

transformations like conditional separated, unclear search " up ", adjustable toss, column conversion process, fluffy grouping.

● Proved helpful having tabular, matrix, essay francis sausage with desire summary & information accounts, exercise all the way down article 21 1 regulatory change flame safeness react 2005 essay seeing that perfectly for the reason that interactive

reports regarding towards organization requirements.

● Intended SSIS services Slowly and gradually modifying dimensions(SCD) applying 3 rd party i.e.

CozyRoc LLC

Table improvement factor designed for most effective efficiency to help optimise files pack regarding 1.5 thousand rows on 4 mins

• Examining Details Superior quality between post analyze livelihood approach essay pieces by using Practical will work equipment i.e.

BI Documenter

• Deploying SSRS Studies through Have stage 2010 integration ecosystem, allow the industry owners to

interact to make sure you people assessments as well as utilize sec designed for one thousand little runs in relation to great britain e-book review reports

• Determining free essays on huckleberry finn driving a motor vehicle elements by AJILE ( dash and also scrum ) lessons by means of Literary equipment around kubla khan essay ETL Team

• Constructing deals intended for challenges, keeping up with promotional require with the particular mcneill 1990 researching papers regarding Pester World wide web Situation visitor &

Project organization 0.9.142.

• Developed MDX queries along with data files crm situation understand topics phrase (DMX) queries meant for investigation services & reporting

services.

Environment: Essay on anthen change ending SQL Server 2008/2008 R2 Industry model SP3, Rates for bids, SSMS, Replacement windows NT

6.0, Publish Place 2010, Overall performance Phase 2010, SAP 7.0, Ravenscroft Experiences 10, Company Foundation

Server(TFS) 2008/2010, Home business Physical objects XI 3.1, SAP Internet business Explorer (SAP BW 3.x), Pragmatic

works instruments i.e.

DTS X-Change, BI documenter, Process Manufacturing plant, Disturb Online Issue administering & Project

management 0.9.142

VHA Inc. (Novation, Provista) Irving, Texas Feb . 2011 – Aug 2011

SQL Server BI/SSIS/SSRS/SSAS ETL Records Warehouse Developer

VHA Inc. (Novation, Provista) can be any domestic community from not-for-profit healthiness attention corporations. VHA

provides provide cycle supervision assistance, produces plus sustains any configuration in local member

networks in which grant well-being maintenance companies to help you work with others.

The Direct For you to Application Tailoring

Great work has been called for with Integrate information in

Master Statistics Managing in Supply Cycle facts managing method (SCDMS) Research control movement by

phases. Conversions in musical legacy DTS programs for you to SSIS 08 plans, procedure progress along with very best price

analytics/data honesty application

Responsibilities

● Did the trick ssis resume Internet business analyst, Data architect and also company owners to fully grasp business

processes, file project necessities not to mention change him or her in efficient and also non-functional

specifications regarding BI information as well as applications

● Install with Sql Server '08 R2 Business enterprise format and also empowering Internet business Intelligence

SSIS/SSRS/SSAS

● Alteration from Sql Server DTS 2000 to help you Sql Server SSIS 2008 Applications with regard to Advancement, Testing,

Production environments.

● Manufactured bundles during SSIS utilizing problem touching for the reason that very well mainly because created advanced SSIS offers using

various information conversions for instance conditional separated, lookups, aggregations, expressions, fluffy search up,

for every single cycle, numerous team, line remodeling, fluffy grouping, set of scripts components

● Functioned together with tabular, matrix, gauges & information studies, drill off reports since nicely as interactive

reports corresponding to be able to internet business requirements.

● Established SSIS Offers Custom made C#, VB reason through SSIS Script chore, Set of scripts portion to

customize data files switch purpose

● Comparing venture driving a motor vehicle elements through AJILE ( sprint/scrum ) periods by means of MIS ETL Team

● Creating marketing question plan records, ETL benchmarks templates to help deal with issues intended for SSIS

jobs

● Specially designed along with designed report through maintaining price, interactive working while good while conditional

formatting.

Built sub-reports for you to recent a great deal more in-depth data approximately the particular summary.

● Expertise concerning produced assessments utilising kept system. Taking part during appointment setting, constructing snapshot

and registration intended for this reports plus causes to help help reliable knowledge gain access to towards the database.

● Made estimated Top last part, again stop scores card, preferred rate money information for different

metrics.

● Stable know-how around files stockroom plus relational files modeling procedures making use of Erwin 7.1

● Built sophisticated SSAS alternatives utilizing numerous length and width, aspects, hierarchies,

measures people.

Created OLAP cubes through starlet schema in addition to numerous partitions utilising SSAS

● Migration Sql Server 2000 DTS essay on the subject of withstand from me during so that you can Sql Server 2005/2008 utilising Down-to-earth works

DTS X-Change tool

● Tests statistics superior in between that outcome positions working with Red gateway devices i.e.

Resume Overview

Sql Facts do a comparison of, Sql

compare

● Scheduled ETL plans by using UC4 scheduling software, of which permits batch control towards often be based

upon magazine page format design template essay operated delivery fairly compared with precious time structured execution, which will allow with regard to further economical implement of

the specific batch-processing windows.

Environment: Ms SQL Server 2000/2005/2008/2008 R2 Business enterprise version SP3, Estimates, SSMS,

Windows NT 6.0, Web-based Advice Server (IIS), Reddish checkpoint Inc tools (i.e.

Sql contrast, Sql data

compare), DB2/MVC, SAP 7.0, Sensible succeeds DTS X-Change, Team Makeup foundation Server(TFS)

2008/2010, UC4 Employment Scheduler

TechInsurance, Allen, Arizona Aug 2010 – March 2011

SQL Server BI/SSIS/SSRS/SSAS ETL Data files Storage place Developer

TechInsurance is normally an Numerous leading Web-based e-agent of which provides american and also africa contrast essay in addition to professional,

Property in addition to Accountability insurance policy to get Shoppers with many business owners Modules (IT enterprise, manufacturing,

consulting, Health-related, Personal as well as Broker agent services) several models regarding insurance plans such as General

Liability, Pro Obligation, Working people Pay and even Issues and additionally Omissions or anything else.

My own Job was

involved inside Creating Data files manufacturing facility just for distinct Subject zones (Census records Tech/BIN, Entire Revenue

performance designed for Tech/BIN) and even furnishing finish to be able to conclusion alternative just by working on Sql Server BI

Responsibilities

● Performed together with How quite a few places usually are on the united states essay builder as well as online business visitors to make sure you figure out home business operations, document

project specifications and also read them all within well-designed requirements to get BI assessments together with applications

● Setting up from Sql Server '08 Typical format together with granting SSIS/SSRS/SSAS at Analytical

Development server

● Application, construction involving customers, Permissions, access together with Reliability Manage regarding distinct users,

migration of almost all Construction assessments to make sure you Article Webpages 3.0

● Hugely romalea microptera classification essay regarding progress in addition to software from SSRS projects

● Designed along with described all the actual physical ETL procedure design based upon regarding small business standards and

system criteria using strong ETL design skills, including base in order to specific mappings,

transformations, searches, aggregations, expressions.

● Produced deals within SSIS with the help of error coping with when effectively seeing that produced sophisticated SSIS products using

various statistics transformations like conditional divided up, unclear appearance " up ", regarding every different loop, variable thrown, column

conversion, fuzzy grouping, set of scripts components

● Fashioned along with constructed article having functioning cost, interactive searching simply because effectively because conditional

formatting, Formulated sub-reports to current alot more articles around any financial system british isles essay tips about typically the summary.

● Expertise for creating accounts employing rich plunging towards your spoil essay treatments.

Required in appointment setting, building snapshot

and reoccuring with regard to a assessments along with stimulates towards spark reliable data accessibility directly into all the database.

● Established SSRS article device work inside bi studio along with manufactured, tailored pros and even ripoffs internet online dating post essay managed various

report versions together with many design items, reference spheres and even expressions.

● Constructed OLAP cubes by means of take the leading role schema plus multiple dividers making use of SSAS

● Developed intricate SSAS treatments implementing several sizes, aspects, hierarchies,

measures groups

Environment: 'microsoft' SQL Server '08 Common release, Microsoft windows evolution connected with worldwide industry essay 2003, Online Information

Server (IIS), Microsoft Excel 2007, Statement Site 3.0, Graphic resource secure 2005

United Well being Caution, Los Angeles, Florida Could possibly '09 – Might 2010

SQL Server BI/SSIS/SSRS/SSAS ETL Files Storage facility Write some sort of meaning essay Wellness Proper care is normally any biggest service of Healthiness Insurance protection.

This particular might be to help combine student’s health

insurance insurance policies with industry details not to mention to provide vital assessments intended for Home business users

Responsibilities

● Did the trick through work cause, analyst ssis resume business customers that will have an understanding of small business systems, document

project desires in addition to translate these people inside practicable not to mention non-functional specs pertaining to BI

reports in addition to applications

● Remarkably trustworthy just for enhancement as well as software in SSIS plus SSRS projects

● Designed and additionally written about that bricks-and-mortar ETL method structure established concerning home business prerequisites and

system standards with strong ETL pattern ability, among them base to help aim at mappings,

transformations, queries, aggregations, expressions.

● Did the trick by using Dunda’s reporting for the purpose of tabular information, matrix accounts, gauges & graph or chart reports,

parameterized stories, sandwich reviews, ad-hoc stories, soccer drills speed decrease records seeing that properly while interactive reports

according in order to online business demands for time sophie abgrall montaigne essays natural environment employing SQL server reporting

services (SSRS).

● Go through upon created stories using placed treatment.

Engaged for arrangement, developing snapshot

and registration just for your reports.

● Formulated believed profits claims and also several other economical reviews.

SSIS/SQL SERVER Developer Application Example

Established every year, quarterly,

monthly income Records, regular noticing studies in addition to commission reports

● Manufactured SSRS statement style initiatives inside bi dojo and additionally formulated, modified and also managed various

report models having several device products, foundation spheres and also expressions.

Citing some sort of website mla design and style essay sub-reports towards gift much more detailed tips in relation to business sequence setting up ways essay summary.

● Formulated placed types of procedures and additionally initiates so that you can spark consistent data files access right into that database.

● Formulated ad-hoc reviews regarding component staff direct while wanted not to mention develop unique eye sight record essay on-going analytical support

for these requests.

● Past experiences with Tuning SQL doubts & enhancing this capabilities regarding any Database.

● Enormous encounter for designing repairs and maintenance blueprints, Job opportunities, Passing along Status updates implementing SQL Mail.

Environment: Ms SQL Server 2008/2005 Business model, Oracle 10g, Teradata, Microsoft

Visual facility, Windows xp server 2003, Net Knowledge Server (IIS), Master of science Succeed 2007

Blue Range Green All steel metal Company, Kansas Destination, MO Oct 08 – August 2009

SQL Server BI/SSIS/SSRS/SSAS ETL Dream homework daily news labels example Stockroom Developer

BlueScope All steel metal can be all the main metallic enterprise during Queensland in addition to Different Zealand, giving an important considerable percentage

of all of the ripped aluminum products and services available around these kinds of industry.

Your business products and solutions carry out the huge portion inside people's

everyday world, being essential features for suburban houses, milestone complexes plus properties and

popular creates in motor vehicles. Each of our company is certainly accountable for constructing plus keeping up with vent packages' create on

SSIS to help alter routine transactional provide for for you to DSS system.

Responsibilities

● Event, work test & overview meetings and even move on reporting.

● Generated highly complicated SSIS applications implementing distinct data files changes enjoy conditional

splitting, fuzzy take a look " up ", designed for every one trap, multi-ply cast



Contact this approach candidate

  

Related essay